X-Cart import format can be used instead of the standard Netcash Shop import tool if you need to import categories and product options. The import file should be in a CSV format. Download a sample X-Cart file.
X-Cart export file contains a lot of data blocks. Netcash Shop uses only three blocks at this moment – [CATEGORIES], [PRODUCTS] and [PRODUCT_OPTIONS].
[CATEGORIES]
From [CATEGORIES] block Netcash Shop 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, Netcash Shop 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 Netcash Shop 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 Netcash Shop 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 Netcash Shop 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