Storeden Help Center

Welcome,
search through the guides and find what you need.

Importing products via CSV

Follow

This guide will help you properly complete the .csv file used to import products. The file's columns should be separated by a ; (semicolon) and the text delimited by a ". The columns shown below should maintain their position and order.

SKU (Stock Keeping Unit): Unique product code. If the code is already present in your e-commerce, the product will be overwritten with the new data.

NAME: Product title

DESCRIPTION: Product description

PRICE: Product list price

FINALPRICE: Product final price

STOCKCOUNT: Product stock or quantity

UNLIMITED: If 1, the system will not manage the quantity of the product and it can be sold unlimited times. If enter 0, product quantity/availability will depend on the StockCount field.

USEVARIANTS: Set the field to 1 if there are product variants.

VARIANTS: Variants available for that product [e.g. color::red|blue|yellow#size::42|44 means that the product will have three colors (red, blue, yellow) and two sizes (42,44)]. 

Enter all variant combinations, following the example below:

red - size 42

red - size 44

blue - size 42

blue - size 44

yellow - size 42

yellow - size 44

VARIANTSVALUE: Defines the quantity and the additional price for the combined variants. Each variant combination must be defined: COMBINATION | QUANTITY | ADDITIONAL CHARGE | SKU | EAN | URL_IMAGE # ...

The # (hash) character separates one combination from the next. No spaces are allowed.

The | (pipe) character separates the properties of the combination and must be included even when a piece of data is not present.

Combination: the superkey of the options in the current combination. For example: if we are in the color red, size S, the superkey will be: red_s . If I have only one variant, the superkey is the same as the key to the option: red

Quantity: the available quantity of the combination [leave as 0 (zero) if the product has unlimited quantities]

Additional charge: additional charge for the combination (will be added to the product price, optional, it can be 0)

SKU: unique code for the combination (optional)

EAN: EAN of the combination (optional)

Image URL: URL of the image of the combination (optional). The URL must be reachable from the network. No URLs from local computers.

CATEGORYTREE: Category tree to which the product is assigned. If the categories do not already exist, they will be created automatically by the system.

SOCIALCATEGORYID: Insert the marketplace ID category. Here is the updated list of social categories .

BRAND: Product brand. If it is not already in the system, it will be automatically created.

WEIGHT: Weight of the product in kg.

W: Length in cm of the packaging (used to calculate shipping)

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

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

PARAMETERS: Filters set from the control panel (e.g. color|1#discounted|0 will apply the "color" and "discounted" filters)

IMAGES: Image URL reachable via HTTP to assign the product's main image and any related images. Images must be separated by "|" (e.g. link_principal|link_related1|link_related2).

TAGS: Insert tags for your product separated by a "," (comma).

FACEBOOKENABLE: If 1, the product will be visible on the Facebook showcase; if 0, it will not be visible.

SEOTITLE: Product SEO title

SEODESCRIPTION: Product SEO description

SEOKEYWORDS: Product meta keywords

FREE_SHIPPING: If 1, the product will have free shipping. If 0, the product will be included in the shipping cost calculation.

EAN13: Insert the EAN13 code or EAN8 code of the product. This code will be used, if required, during synchronization with third-party marketplaces (e.g. Amazon, eBay etc.).

MPN: Manufacturer Part Number. Used to sync with third-party marketplaces.

VISIBLE: Set to 1 to make the product visible on your storefront. Set to 0 to hide the product from your storefront. Here is a file to use as an example: Click here to download

Was this article helpful?
0 out of 0 found this helpful

Comments

Don't wait, start now to sell with Storeden

Try it for free