Storeden Help Center

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

Importing products via CSV

Follow

 

Guide to the correct compilation of the CSV file. The columns of the CSV must be separated by ; (semicolon) and the text delimited by “ (double quote).

The columns of the CSV must be kept as position and order. It is not possible to omit the columns, otherwise the import malfunction, which can lead to unexpected results.

The import can be used to create new products or update existing products, the control value is the SKU code: if the SKU code is already entered in the system, the product will be updated, if the SKU code is not present in the catalog, a new product will be created. It is therefore not possible to change the SKU of a product via CSV.

If you want to update a product, only in some columns, you can insert the value "nochange" in the columns that allow it. By inserting the value "nochange" the value of the product referred to the column will not be modified. This system can be used for example if you want to make some changes directly from the back office and update only some information via CSV.

Below are the details of each column of the CSV. No columns can be removed from the CSV, even when the value is not required. Scroll / drag sideways to read all the contents of the table.

 

 

mandatory

nochange

note

sku

yes

no

the SKU code must be unique, if in the CSV there are two identical SKU codes the product will be overwritten with the data of the last corresponding row.

name

yes

yes

product title.

description

no

yes

Product description.

price

yes

yes

starting price of the product. It must be greater than or equal to zero. Enter only the numeric value, without currency.

final_price

yes

yes

selling price of the product. It must be greater than or equal to “price”. Enter only the numeric value, without currency.

stockcount

no

yes

quantity available. Enter 0 if the product is with variants or has an unlimited quantity. Enter numeric values ​​only.

unlimited

no

yes

enter 1 if the product has unlimited availability

usevariants

no

no

enter 1 if the product has variants

variants

no

yes

Definition of variants. Color::red|blue|yellow#size::42|44 this string will generate for the product the combinations of variants for Color "Red", "Blue" and "Yellow" and Size "42" and "44".

Warning! No special characters are allowed in the variant title (for example / -? _). If you wish to have a particular character appear in the variant title, you can insert it in the translations of the variants by going to the Tools >> Translations >> Variants section. As for the variant values, they cannot contain special characters including:

- underscore (example: lilac_blu)

- comma (example: 42.5)

- slash (example: lilac/blue)

The names of the variants and options must be entered in the CSV in lowercase and without spaces.

You can configure the labels of the variants in the Tools > Translations > Variants section, where you can enter all the characters you want.

variantsvalue

no

yes

Definition of variant combinations: all possible combinations of product variants entered in the variants column must be listed. The # symbol separates the definition of each variant combination. Each combination consists of 11 elements, separated by | (pipe): superkey (1), quantity (2), surcharge (3), sku (4) ean (5) url image (6) mpn (7) weight (8) width (9) height (10) depth (11). The superkey is the combination of the options, separated by _ (underscore): red_42 is the superkey of the red color variant, size 42 of the product. If you only have one variant, such as size, the superkey will match the size entered in the variants column.

categorytree

no

yes

"categories to which the product is associated. Attention: the corresponding categories will be created, if not already present in the catalog, based on the names entered. Upper and lower case are to be considered different. It is not possible to remove categories via CSV. The structure of the categories is created with the separation #.

An example: categoryA#subcategoryA.

If the product is to be inserted into several categories, the structure of the categories must be separated by “|” .

An example: categoryA#subcategoryA|categoryB#subcategoryB.

socialcategoryid

no

yes

Blomming marketplace category ID. The updated list of categories is available here.

brand

no

yes

Brand name: the brand is created if it is not already present in the catalog, uppercase and lowercase letters are to be considered different. It is not possible to remove brands via the CSV.

weight

no

yes

Product weight, in kg. Enter a numeric value, without unit of measure.

w

no

yes

Product width, in cm. Enter a numeric value, without unit of measure.

h

no

yes

Product height, in cm. Enter a numeric value, without unit of measure.

x

no

yes

Depth of the product, in cm. Enter a numeric value, without unit of measure.

parameters

no

yes

Filters applied to the product. Filters and options must first be created in catalog > filters. In the field enter filter key: option id separated by #, example color|1#discounted|0 will apply the navigation filters color and discounted.

images

no

yes

List of URLs (reachable from the internet, therefore http/https) to the product images. Separate urls with | (pipe).

tags

no

yes

Product Tags. Enter the tags in lowercase, without accented letters or special characters, use - (hyphen) in place of the space. Separate tags from each other with , (comma).

facebookenable

no

no

Product activation in the Facebook shop (deprecated field, usable for shops that have the old FB Shop). Not usable for those who use Facebook Ads Extension.

seotitle

no

yes*

SEO title

seodescription

no

yes*

SEO description

seokeywords

no

yes*

SEO keywords. Separate keywords with , (comma).

ean13

no

yes

EAN product

mpn

no

yes

MPN product

path

no

no

This field is obtained only in export, it cannot be modified therefore any value entered here is irrelevant.

visible

yes

yes

Product status, 1 for active, 0 for deactivated product.

minQuantity

no

yes

Minimum purchase quantity, enter a value greater than or equal to 1

nextQuantity

no

yes

Subsequent purchase quantity, after entering the minimum quantity in the cart. Enter a value greater than or equal to 1

maxQuantity

no

yes

Maximum purchase quantity, enter a value greater than 0 to set a maximum purchase limit, 0 otherwise.

 

*Attention: the SEO fields have a particular management of the nochange, to avoid errors pay close attention to the following:

- if the nochange is inserted in the seotitle column, no SEO fields will be updated without these having the value nochange. seotitle = nochange blocks updating all SEO fields.

- if the nochange is entered in seotitle and seodescription, then only the seokeywords field can be updated.

- the nochange cannot be entered independently on seodescription or seokeywords.

Here you can find the sample file: Click 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

en-us