X-Cart Import Format (Third Party Store)

To determine which eCommerce solution you are on, see How do I know if I am using Native eCommerce or Third Party eCommerce?

X-Cart import format can be used to import categories and product options into your Store. The import file should be in a CSV format.

X-Cart export file contains a lot of data blocks. Store uses only three blocks: [CATEGORIES], [PRODUCTS], and [PRODUCT_OPTIONS].

[CATEGORIES]

From the [CATEGORIES] block, Store uses the following columns.

Column NameDescriptionTypeOptionalLimits!CATEGORYCategory path (for example, Books/Computers/HTML)StringRequired255 symbols for each category name ("Books" is one category name, "Computers" is other category name)!AVAILCategory availability (enabled/disabled)BooleanOptional"true", "yes", "Y", "1" for true, any other values for false!ORDERBYCategory orderingIntegerOptionalAny integer value

[PRODUCTS]

From the [PRODUCTS] block, Store uses the following columns.

Column NameDescriptionTypeOptionalLimits!PRODUCTCODEProduct SKUStringAt least one of the following fields is required: “!PRODUCTCODE” or “!PRODUCT”.255 symbols!PRODUCTProduct nameStringAt least one of the following fields is required: “!PRODUCTCODE” or “!PRODUCT”.255 symbols!WEIGHTProduct weightFloating numberOptionalAny valid floating number value. If column is present but empty, product is intangible.!DESCRProduct descriptionStringOptionalNo limits!AVAILUsed to control quantity in stockIntegerOptionalNone!FORSALEProduct availability (enabled/disabled)BooleanOptional"true", "yes", "Y", "1" for true, any other values for false!SHIPPING_FREIGHTProduct shipping freight value ("Fixed Rate" value in Store product editor)Floating pointOptionalNone!LOW_AVAIL_LIMITProduct quantity warning limit ("Send me a note when quantity in stock reaches..." option)IntegerOptionalNone!CATEGORYCategory path (Books/Computers/HTML) that the product belongs toStringOptional255 symbols for each category name ("Books" is one category name, "Computers" is other category name)!PRICEProduct priceFloating pointOptionalNone!THUMBNAILLink to product imageStringOptionalOnly http:// and https:// links are allowed, any other values are ignored.!IMAGEAnother link to product image (if defined it overwrites the !THUMBNAIL value)StringOptionalOnly http:// and https:// links are allowed, any other values are ignored.

[PRODUCT_OPTIONS]

From the [PRODUCT_OPTIONS] block, Store uses the following columns.

Column NameDescriptionTypeOptionalLimits!PRODUCTCODEProduct SKUStringAt least one of the following fields is required: “!PRODUCTCODE” or “!PRODUCT”.None!PRODUCTProduct nameStringAt least one of the following fields is required: “!PRODUCTCODE” or “!PRODUCT”.None!CLASSOption class name (for example "Color", "Size", etc)StringOptionalNone!TYPEOption type ("Input Type" in Store product editor)StringOptional"Text type" if empty. "Drop-down type" if value equals to "Y".!OPTIONOption name (for example, for option class "Size" option names are "Small", "Medium", "Large")StringRequiredNone!PRICEMODIFIERPrice modifier valueFloating pointRequiredNone!MODIFIERTYPEPrice modified typeStringOptionalIf value equals to "%", then modified type is "Percent" (%) or "Absolute" ($) if any other value.

Any data block is optional. You can import only categories, or products with options without categories at all. One product can belong to many categories. In this case, column values must look like the following.

!PRODUCTCODE!PRODUCT!CATEGORY00001My productBooks/Programming/HTML  Books/Programming/CSS  Books/Programming/Internet