Importing product options through XCART

GETTING THE XCART FILE READY

First of all you will need to download the xcart example file provided in this article then open up the file and you will see the following:

There is a meaning behind every code that you can see in that excel file. And here is a quick explanation of what everything means:

!PRODUCTCODE = sku, or the product unique identifier on the shop (has to be the same as the one already used on the shop)

!!! Please take in mind that the SKU of the product can either be a number or a string and you cannot import product options if a product has a SKU of 00001 but another product in the same XCart file has a SKU of LLB1. The SKU has to look the same to get imported.

!CLASS = this is how the option name will appear on the shop (ex. Color)

!OPTION = this is how the types of options will appear on the shop (ex. Black, White, etc.)

!PRICE_MODIFIER = if a client wants the price to change depending on the option chosen, we have to add here the amount that will change from the price already on the shop (if the client has no such preference, leave it as zero)

Ex: Client has a chocolate priced at £10 in the shop.

He wants to add a size option, and he wants the Medium sized chocolates to be keep their current price, but the new Large sized chocolates to be £16.

We would put 6 in the price modifier column next to the “Large” option name.

The system will then add 6 to the already setup 10, and when the client chooses “large” it will be priced at £16.

!MODIFIER_TYPE = if the client expresses the change in price via a percentage of the original price, type in % in this field. Otherwise leave empty.

If you want to see a more in depth list of everything, please check out this link where you can find some information that is a bit more technical.

I also have to mention that there has to be an empty row after each product, as you can see in the above image some rows (row 6, row 10, row 13) are empty. This is done to specify that we added a new product for which we need to modify the options. The only exception where we do not need an empty space is for the first product, you can see that in the above image, the first product sits on row 3 and directly above it, row 2 is completed with some declarations that xcart need in order to import the options.

Now that you know what every data means you can complete the document for your own products. Below you can find 3 product examples from a demo store before importing xcart options and a screenshot with the xcart document that I completed for those 3 products.

As you can see the product with the SKU "00003" appears twice. I have done this because I want to import two options for that product. If you want to import two options for the same product, you still need to add an empty space between the options.

NOTE: If your product SKU is like the one above ("00001") sometimes the software might delete those 0's in front, in this case you should format that column so the whole column would be shown as "text".