Importing products into X-Cart
|
Revision date: Jan 31, 2006
|
Notes
on product categories import
You can have more than one category
column in your CSV file - one for the product main category and the
necessary number of columns for the additional categories (if any). For
example, you are going to import a product which is a book and which
you want to be located in two categories: 'Books/Internet' (main) and
'Books' (additional). If you have chosen to use /// as the category
path separator, your CSV file should have two category columns: category;category
Books///Internet;Books
Tip: If your CSV file contains several
category fields, you can use the 'Get column names from the first row
of CSV file' functionality to let X-Cart know the order in which fields
are being imported. on product prices importYou can have more than one price
column in your CSV file - one for the basic product price and the
necessary number of columns for the wholesale prices (if any). Basic
product price is entered into the field 'as is' (If, for example, a
product costs $0.99, you only need to enter 0.99 into the price field).
For the import of membership-specific prices use the following format: Membership:Quantity:Price
For example, if you want to describe a wholesale price
according to which ''Wholesale' customers can purchase 5 or more items
of some product at $0.89 per item, the contents of one of your price
fields must look as follows: 'Wholesale:5:0.89' If a price
is applied to all membership groups, the 'Membership' part can be omitted:
'5:0.89' means that any user can purchase 5 or more items of the
product at $0.89 per item. Tip: If your CSV file
contains several price fields, you can use the 'Get column names from
the first row of CSV file' functionality to let X-Cart know the order
in which fields are being imported. on extra fields importFor example, you need to import the following extra fields: UPC
ISBN
Artist
Publisher
Pages The extra_fields field in the CSV file for import into X-Cart should be filled in as follows : field=UPC&&&value=%VALUE%###
field=ISBN&&&value=%VALUE%###
field=Artist&&&value=%VALUE%###
field=Publisher&&&value=%VALUE%###
field=Pages&&&value=%VALUE%
where {%VALUE%} must be replaced with the actual field values. on product options importFirst of all, please note that if a product has product options defined, they are deleted before import. For Modificator type options use the following product_options field format: /*
<Class>
<Name></Name> 'Option class name
<Text></Text> 'Text description of the option class
<Type></Type> 'Option type (Y for Modificator)
<Avail></Avail> 'Availability, Y or N
<OrderBy></OrderBy> 'Sorting position of the class
<Options>
<Option>
=<ID></ID> 'Option variant ID
<Name></Name> 'Option variant name
<Avail></Avail> 'Availability, Y or N
<OrderBy></OrderBy> 'Sorting position of the option variant
<PriceModifier></PriceModifier> 'Price modifier value (positive or negative)
<ModifierType></ModifierType> 'Modifier type ($ or % for Modificator)
</Option>
...
</Options>
</Class>
...
<Exception>
<ID></ID> 'ID of exception component
...
</Exception>
...
<JScode></JScode> 'JavaScript validation code
*/
Example 1. Modificator type options.
Information about the product options from Example 1 shown in the picture above can be entered into the product_options field as follows: <Class>
<Name>Cover</Name>
<Text>Choose cover type</Text>
<Type>Y</Type>
<Avail>Y</Avail>
<OrderBy>0</OrderBy>
<Options>
<Option>
<ID>10</ID>
<Name>Soft</Name>
<Avail>Y</Avail>
<OrderBy>10</OrderBy>
<PriceModifier>0.00</PriceModifier>
<ModifierType>$</ModifierType>
</Option>
<Option>
<ID>11</ID>
<Name>Hard</Name>
<Avail>Y</Avail>
<OrderBy>20</OrderBy>
<PriceModifier>5.00</PriceModifier>
<ModifierType>$</ModifierType>
</Option>
</Options>
</Class>
<JScode></JScode>
For Variant type options use the following product_options field format:
/*
<Class>
<Name></Name> 'Option class name
<Text></Text> 'Text description of the option class
<Type></Type> 'Option type (empty for Variant)
<Avail></Avail> 'Availability, Y or N
<OrderBy></OrderBy> 'Sorting position of the class
<Options>
<Option>
<ID></ID> 'Option variant ID
<Name></Name> 'Option variant name
<Avail></Avail> 'Availability, Y or N
<OrderBy></OrderBy> 'Sorting position of the option variant
<PriceModifier></PriceModifier> 'Price modifier value (0.00 for Variant)
<ModifierType></ModifierType> 'Modifier type (empty for Variant)
</Option>
...
</Options>
</Class>
...
<Exception>
<ID></ID> 'ID of exception component
...
</Exception>
...
<Variant>
<SKU></SKU> 'Product variant SKU
<Avail></Avail> 'Availability, Y or N
<Weight></Weight> 'Product variant weight
<Price></Price> 'Product variant price
<Items>
<ID></ID> 'ID of product variant component
...
</Items>
</Variant>
...
<JScode></JScode> 'JavaScript validation code
*/
Example 2. Variant type options.
Information about the product options from Example 2 shown in the picture above can be entered into the product_options field as follows: <Class>
<Name>Size</Name>
<Text>Choose size</Text>
<Type></Type>
<Avail>Y</Avail>
<OrderBy>10</OrderBy>
<Options>
<Option>
<ID>22</ID>
<Name>L</Name>
<Avail>Y</Avail>
<OrderBy>0</OrderBy>
<PriceModifier>0.00</PriceModifier>
<ModifierType></ModifierType>
</Option>
<Option>
<ID>23</ID>
<Name>XL</Name>
<Avail>Y</Avail>
<OrderBy>0</OrderBy>
<PriceModifier>0.00</PriceModifier>
<ModifierType></ModifierType>
</Option>
</Options>
</Class>
<Class>
<Name>Color</Name>
<Text>Choose color</Text>
<Type></Type>
<Avail>Y</Avail>
<OrderBy>20</OrderBy>
<Options>
<Option>
<ID>122</ID>
<Name>Red</Name>
<Avail>Y</Avail>
<OrderBy>0</OrderBy>
<PriceModifier>0.00</PriceModifier>
<ModifierType></ModifierType>
</Option>
<Option>
<ID>123</ID>
<Name>White</Name>
<Avail>Y</Avail>
<OrderBy>1</OrderBy>
<PriceModifier>0.00</PriceModifier>
<ModifierType></ModifierType>
</Option>
</Options>
</Class>
<Variant>
<SKU>SKU10</SKU>
<Avail>70</Avail>
<Weight>1</Weight>
<Price>59.99</Price>
<Items>
<ID>22</ID>
<ID>123</ID>
</Items>
</Variant>
<Variant>
<SKU>SKU100</SKU>
<Avail>100</Avail>
<Weight>1</Weight>
<Price>61.99</Price>
<Items>
<ID>23</ID>
<ID>123</ID>
</Items>
</Variant>
<Variant>
<SKU>SKU101</SKU>
<Avail>98</Avail>
<Weight>1</Weight>
<Price>59.99</Price>
<Items>
<ID>22</ID>
<ID>122</ID>
</Items>
</Variant>
<Variant>
<SKU>SKU102</SKU>
<Avail>36</Avail>
<Weight>1</Weight>
<Price>61.99</Price>
<Items>
<ID>23</ID>
<ID>122</ID>
</Items>
</Variant>
<JScode></JScode>
For Text field type options use the following product_options field format: /*
<Class>
<Name></Name> 'Option class name
<Text></Text> 'Text description of the option class
<Type></Type> 'Option type (T for Text field)
<Avail></Avail> 'Availability, Y or N
<OrderBy></OrderBy> 'Sorting position of the class
<Options></Options> 'Options (Empty for Text field)
</Class>
<JScode></JScode> 'JavaScript validation code (Empty for Text field)
*/
Example 3. Text field type options.
Information about the product options from Example 3 shown in the picture above can be entered into the product_options field as follows: <Class>
<Name>Message</Name>
<Text>Enter your message</Text>
<Type>T</Type>
<Avail>Y</Avail>
<OrderBy>1</OrderBy>
<Options></Options>
</Class>
<JScode></JScode>
on applied taxes importapplied_taxes
field can contain service names of taxes which must be applied to the
product being imported. The service names must be delimited by &&&. For example, if the service names of the applied taxes are VAT and VAT17_5, the applied_taxes field should be filled in as follows: VAT&&&VAT17_5
Tip: If you are still not sure what data format must
be used for some field in the CSV file for import, use the
provider/admin interface of your store to add a product with
characteristics similar to those of the product(s) you want to import,
then export the products and see what kind of format you've got for
this field in the resulting CSV file.
|
Revision date: Jan 31, 2006
|
|
|
|
'Product options' form
'Add/Update option' form
'Product options' form
'Add/Update option' form (size)
'Add/Update option' form (color)
'Product variants' form
'Product options' form
'Add/Update option' form