X-Cart CSV format and Ecwid (legacy)
X-Cart CSV format can be used within the standard Ecwid import tool if you need to add categories and product options in bulk. The import file should be in a CSV file. Download a sample X-Cart file.
X-Cart export file contains a lot of data blocks. Ecwid uses only three blocks at this moment - [CATEGORIES], [PRODUCTS] and [PRODUCT_OPTIONS].
[CATEGORIES]
From [CATEGORIES] block Ecwid uses these columns:
| Column name | Description | Type | Optional | Limits |
| !CATEGORY | category path (Books/Computers/HTML for example) | string | required | 255 symbols for each category name ("Books" - one category name, "Computers" - 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 [PRODUCTS] block, Ecwid uses the following columns:
| Column name | Description | Type | Optional | Limits |
| !PRODUCTCODE | product SKU | string | at least one of "!PRODUCTCODE" or "!PRODUCT" field is required | 255 symbols |
| !PRODUCT | product name | string | at least one of "!PRODUCTCODE" or "!PRODUCT" field is required | 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 | |
| !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 Ecwid product editor) | floating point | optional | |
| !LOW_AVAIL_LIMIT | product quantity warning limit ("Send me a note when quantity in stock reaches" option) | integer | optional | |
| !CATEGORY | category path (Books/Computers/HTML), which product belongs to | string | optional | 255 symbols for each category name ("Books" - one category name, "Computers" - other category name) |
| !PRICE | product price | floating point | optional | |
| !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 overwrites the !THUMBNAIL value | string | optional | only http:// and https:// links are allowed, any other values are ignored |
[PRODUCT_OPTIONS]
From [PRODUCT_OPTIONS] block Ecwid uses these columns:
| Column name | Description | Type | Optional | Limits |
| !PRODUCTCODE | product SKU | string | at least one of "!PRODUCTCODE" or "!PRODUCT" field is required | |
| !PRODUCT | product name | string | at least one of "!PRODUCTCODE" or "!PRODUCT" field is required | |
| !CLASS | option class name, for example "Color", "Size" etc | string | optional | |
| !TYPE | option type ("Input Type" in Ecwid product editor) | optional | string |
"Text type" if empty. "Drop-down type" if value equals to "Y". |
| !OPTION | option name, for example for option class "Size" a option names are "Small", "Medium", "Large" | string | required | |
| !PRICE_MODIFIER | price modifier value | floating point | required | |
| !MODIFIER_TYPE | 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. Any floating point value has to be formatted accordingly to your store settings (look at Control Panel -> System settings -> General -> Formats & Units)
One product can belong to many categories. In this case, column values must look like here:
| !PRODUCTCODE | !PRODUCT | !CATEGORY |
| 00001 | MyProduct | Books/Programming/HTML |
| Books/Programming/CSS | ||
| Books/Programming/Internet |
X-Cart import CSV sample in attachment