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 |