Multiple uploads: importing products via CSV

From the ‘Import’ section you can upload multiple products to your shop at once. The products can be uploaded via a CSV file compiled according to the instructions below. 

The columns of the CSV must be separated by a ; (semi colon) and the text delimited by " (double quotation marks).

The columns of the CSV file (download an example) must be kept in the original position. They cannot be deleted or moved. 

SKU (Stock Keeping Unit): A unique product code. If the code is already in your e-shop, it will be overwritten with the new data. Otherwise a new product will be created. 

NAME: Product title

DESCRIPTION: Longer description of the product

PRICE: Listed price of the product

FINALPRICE: Final price of the product

STOCKCOUNT: Product stock, also called availability.

UNLIMITED: If set to 1, the system will ignore the quantity and the product can be sold an infinite number of times. If set to 0, its availability will depend on the StockCount field.

USEVARIANTS: Set to 1 if using different product versions.

VARIANTS: The versions available for the product. (e.g.: colour::red|blue|yellow#size::42|44 means that the product comes in 3 colours [red, blue and yellow] and 2 sizes [42 and 44] ). Enter all the variation combinations, using the below as an example:

red - size 42

red - size 44

blue - size 42

blue - size 44

yellow - size 42

yellow - size 44

In the following field, Variantsvalue, the quantity, extra fees, SKU, EAN and images of the coinciding variants can be set.

VARIANTSVALUE: This field defines the quantity available and the extra charge for the coinciding product version. Each variant combination should be defined as follows:  COMBINATION|QUANTITY|EXTRACHARGE|SKU|EAN|URL_IMAGE# ... The # (hash) symbol separates one combination from the next. Spaces are not permitted. The | (pipe symbol) separates the properties of the combination and should be kept even when there is no data.

Combination: the superkey for the options of the current combination. For example: if we’re on the colour red, size S, the superkey will be: red_s . If there is just one version, the superkey is the option key: red

Quantity: the quantity available of the combination (leave as zero 0 if the product is unlimited)

Extra cost: extra cost for the combination (which will be added to the product cost, optional, it can be set to 0)

SKU: the product's unique code (optional)

EAN: EAN of the combination (optional) 

URL_image: URL of the image of the combination (optional, the URL must be reachable from the web to be downloaded) - URLs from local computers will not work.

CATEGORYTREE: Tree of the category to be assigned to the product. If the categories don’t exist, they will be automatically created by the system. The tree of the categories is created with the # separator.

For example: categoryA#subcategoryA.

If the product is added to multiple categories, the trees are separated by a | .

For example: categoryA#subcategoryA|categoryB#subcategoryB

SOCIALCATEGORYID: Enter the ID of the marketplace category. Click here for an updated list of categories. 

BRAND: The brand that produces the product. If it doesn’t already exist in the system it will be created

WEIGHT: Weight (kg) of the product.

W: Width of the product packaging in centimetres (used to calculate shipping)

H: Height of the product packaging in centimetres (used to calculate shipping)

Z: Depth of the product packaging in centimetres (used to calculate shipping)

PARAMETERS: Filters set from the control panel. (example: colour|1#discounted|0 will apply the ‘colour’ and ‘discounted’ browsing filters)

IMAGES: URLs of images that can be accessed via http to assign the main image of the product and other related images. Images are to be separated by "|" (for example: main_link| related_link1| related_link2).

TAGS: Enter the hashtags for your product separated by commas “,”

FACEBOOKENABLE: If set to 1, the product will be visible on the Facebook ‘shop window’. If set to 0, it will not be visible.

SEOTITLE: SEO title for the product

SEODESCRIPTION: SEO description for the product

SEOKEYWORDS: Meta keywords for the product

FREE_SHIPPING: If set to 1, the shipping will be free for the customer. If set to 0, the product will be subject to shipping fee calculations.

EAN13: Enter the EAN13 or EAN8 code for the product. This code will be used, if requested, when syncing with third-party marketplace websites.

MPN: Manufacturer Part Number. This field can be used when syncing with third-party marketplaces.

VISIBLE: Set to 1 to make the product visible. If set to 0, the product will be hidden from your shop.