Excel worksheet import of CUSTOM PROPERTIES?

[harlequin]

haha, i want you to make it real simple for us all and post a few lines of example....i know what a flat file is, but when i open up a sample actinic hierarchical, even at 1024x768, with a whole column page width, i cannot see all of the contents of the first cell, never mind all what is going on..

i was kinda thinking a simple post, explaining the concept, not just for me but in case anyone else benefitted from knowing the actual rules as it were, not just a sample file and work it out for yourself..

cheers if you can..

[Ben]

Oh, alright

Hierarchical importing is useful for importing product variants, shipping charges, brochure pages, customer accounts and price scheules as well as custom properties.

The basic structure is made up of header records that define the field name, and data records for the values. Header records start with 'Header:' and then the header keyword - data records start with the keyword. So for instance ...

Header:Section,Section name
Header:Product,Short description,Price
Section,Basic Products
Product,Calculator,851
Product,Bunch of Flowers,2128
End,Section

... describes the section name and product name and price for the first section in the default catalogue. The 'End,Section' line simply specifies the end of the section or sub-section.

Further information is held in the Help files, although I always recommend exporting your own catalog and examining the resulting file if you want to understand it.

HTH

[pinbrook]

Ok....

I want to import 2 customvars where do they go in the import file?

Custom Properties MUST be written BEFORE any being referenced in a product. A warning message will alert you to this requirement. It is strongly advised to write Valid Custom Properties as the first rows of the import file to simplify the structure and avoid import errors (e.g. insertion by mistake within a section).

What does this mean?

if the example below is my file

Header:Section,Section name
Header:Product,Short description,Price
Section,Basic Products
Product,Calculator,851
Product,Bunch of Flowers,2128
End,Section

and my calculator and bunch of flowers has a customvar called commission

[Jan]

To include customvars in an import file then you need to add these headers, in the header section

Header:CustomProperty,Custom Property Name,Value,Use as CUSTOMVAR,Is Searchable,Is File Name,Use File Content
Header:ValidCustomProperty,Name,Type

Then for each customvar you want to define for a product add an entry before the product details to 'declare' the customvar

ValidCustomProperty,"Commission",2

Then for each product you can add the customvar details

CustomProperty,Commission,"70",0,1,0,0

Regards,