X-Cart import format and Ecwid

Last updated

X-Cart import format can be used to import categories, products, and product options.

X-Cart export file contains a lot of data blocks. For example - [CONFIG], [STATES], [CATEGORIES], [PRODUCTS] etc. 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

Attachment 

Was this article helpful?
0 out of 0 found this helpful
Questions?
Get help
  • Presales Chat

    Need help choosing the right Ecwid plan? Our Sales team has the answer you’re looking for.

  • Forums

    Join the Ecwid community. Discuss support topics and store ideas with other Ecwid users.

  • Contact us

    Still have questions about Ecwid? Let us know! We will be glad to help you with your Ecwid store.

  • Status Monitor

    Get real time status updates on Ecwid services here, 24/7