X-Cart Import Format (Third Party Store)

Modified on Fri, 18 Nov, 2022 at 9:42 AM

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 Name	Description	Type	Optional	Limits
!CATEGORY	Category path (for example, Books/Computers/HTML)	String	Required	255 symbols for each category name ("Books" is one category name, "Computers" is other category name)
!AVAIL	Category availability (enabled/disabled)	Boolean	Optional	"true", "yes", "Y", "1" for true, any other values for false
!ORDERBY	Category ordering	Integer	Optional	Any integer value

[PRODUCTS]

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

Column Name	Description	Type	Optional	Limits
!PRODUCTCODE	Product SKU	String	At least one of the following fields is required: “!PRODUCTCODE” or “!PRODUCT”.	255 symbols
!PRODUCT	Product name	String	At least one of the following fields is required: “!PRODUCTCODE” or “!PRODUCT”.	255 symbols
!WEIGHT	Product weight	Floating number	Optional	Any valid floating number value. If column is present but empty, product is intangible.
!DESCR	Product description	String	Optional	No limits
!AVAIL	Used to control quantity in stock	Integer	Optional	None
!FORSALE	Product availability (enabled/disabled)	Boolean	Optional	"true", "yes", "Y", "1" for true, any other values for false
!SHIPPING_FREIGHT	Product shipping freight value ("Fixed Rate" value in Store product editor)	Floating point	Optional	None
!LOW_AVAIL_LIMIT	Product quantity warning limit ("Send me a note when quantity in stock reaches..." option)	Integer	Optional	None
!CATEGORY	Category path (Books/Computers/HTML) that the product belongs to	String	Optional	255 symbols for each category name ("Books" is one category name, "Computers" is other category name)
!PRICE	Product price	Floating point	Optional	None
!THUMBNAIL	Link to product image	String	Optional	Only http:// and https:// links are allowed, any other values are ignored.
!IMAGE	Another link to product image (if defined it overwrites the !THUMBNAIL value)	String	Optional	Only http:// and https:// links are allowed, any other values are ignored.

[PRODUCT_OPTIONS]

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

Column Name	Description	Type	Optional	Limits
!PRODUCTCODE	Product SKU	String	At least one of the following fields is required: “!PRODUCTCODE” or “!PRODUCT”.	None
!PRODUCT	Product name	String	At least one of the following fields is required: “!PRODUCTCODE” or “!PRODUCT”.	None
!CLASS	Option class name (for example "Color", "Size", etc)	String	Optional	None
!TYPE	Option type ("Input Type" in Store product editor)	String	Optional	"Text type" if empty. "Drop-down type" if value equals to "Y".
!OPTION	Option name (for example, for option class "Size" option names are "Small", "Medium", "Large")	String	Required	None
!PRICEMODIFIER	Price modifier value	Floating point	Required	None
!MODIFIERTYPE	Price modified type	String	Optional	If 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	!CATEGORY
00001	My product	Books/Programming/HTML
		Books/Programming/CSS
		Books/Programming/Internet