Ecommerce: X-Cart Import

You can use the X-Cart import format to import categories and product options into your store. Ensure you’re saving your file as a CSV for this option.

An X-Cart export file will contain several sets of data: Categories, Products, and Product Options.

Categories [Categories]

Use the following columns to structure your information:

Name Description Type Optional Limits
!CATEGORY Category path (e.g. clothes or shoes) String Required 255 symbols for each name (“Clothes” is one category name and “Shoes” is another)
!AVAIL Category availability (enabled/disabled) Boolean Optional Use “true”, “yes”, “Y”, “1” for enabled, with all other values indicating disabled
!ORDERBY Category ordering Integer Optional Any integer

Products [Products]

Use the following columns to structure your information:
Column Name Description Type Optional Limits
!PRODUCTCODE Product SKU String At least one of the following is required: “!PRODUCTCODE” or “!PRODUCT”. 255 symbols
!PRODUCT Product name String At least one of the following is required: “!PRODUCTCODE” or “!PRODUCT”. 255 symbols
!WEIGHT Product weight Floating number Optional If column exists, any valid floating number can be used. If column is empty, product is intangible.
!DESCR Product description String Optional None
!AVAIL Use to define quantity that is in stock Integer Optional None
!FORSALE Product availability (enabled/disabled) Boolean Optional Use “true”, “yes”, “Y”, “1” for enabled, with all other values indicating disabled
!SHIPPING_FREIGHT Shipping freight value of product (Listed as “Fixed Rate” value in the store) Floating point Optional None
!LOW_AVAIL_LIMIT Product quantity warning limit (this is an option for “Send me a note when quantity in stock reaches x”) Integer Optional None
!CATEGORY Category path where the product belongs (e.g. Clothes, Shoes) String Optional 255 symbols for each name (“Clothes” is one category name and “Shoes” is another)
!PRICE Product price Floating point Optional None
!THUMBNAIL Link to product image String Optional http:// and https:// links only (any other value ignored)
!IMAGE Another link to product image (when defined it will overwrite the !THUMBNAIL value) String Optional http:// and https:// links only (any other value ignored)

Product Options [PRODUCT_OPTIONS]

Use the following columns to structure your information:
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 (e.g. “Size”, etc.) String Optional None
!TYPE Option type (Listed as “Input Type” value in the store) String Optional If column is empty, this will be “Text type”. If this value is equal to “Y” this will be a “Drop-down type”.
!OPTION Option name (e.g. option class “Size” options are “S”, “M”, “L”) String Required None
!PRICEMODIFIER Price modifier value Floating point Required None
!MODIFIERTYPE Price modified type String Optional If the value equals “%”, then modified type is “Percent” (%)/ If its any other value it is “Absolute”.
You can choose to import a variety of options – e.g. you can import categories alone, products with options and no categories.If you want your product to belong to multiple categories, set your columns like this:
!PRODUCTCODE !PRODUCT !CATEGORY
001 My product Clothes/Shoes/Bags
Clothes/Shoes/Accessories
Clothes/Shoes/Jewelry