How to set product category with Excel – Sello

In this guide, we will show you how to set a category on your products using one of our file-based import systems, such as the Excel import feature.

We will also provide links to documents containing the unique category ID:s you can use to set a category on your products.

The first step is getting a file containing your product's SKU or Sello ID, this can be done using the Excel export feature in Sello.

Here's how:

Log into Sello.
In the top-left menu, find "Import / export".
Go to the "Export" section.
Click: "Export Inventory".
Select the columns you want to export.
Click: "Export Inventory".

Next, you'll need to add the category column for the channel you are setting categories for, to do that, you need to find out what to name it.

Here's how:

Log into Sello.
In the top-left menu, find "Import / export".
Find "Excel" in the Import -section.
Click: "Import".
Find the "Supported fields" -section.

This section contains all your connected channels as well as "General fields". Clicking a row here will expand it revealing all supported column names related to that section.

Next, you need to find the unique category ID:s that tells Sello which category to set on the product. Below is a list of links to documents containing categories and ID:s for our connected sales channels.

Simply find your desired channel and click the link, which will download a .csv file to your device.

Rakuten:
FR:	rakuten_fr_categories.csv
DE:	rakuten_de_categories.csv
vidaXL:
SE:	vidaxl_se_categories.csv
AU:	vidaxl_au_categories.csv
BE:	vidaxl_be_categories.csv
DK:	vidaxl_dk_categories.csv
EE:	vidaxl_ee_categories.csv
FI:	vidaxl_fi_categories.csv
FR:	vidaxl_fr_categories.csv
GR:	vidaxl_gr_categories.csv
IE:	vidaxl_ie_categories.csv
IT:	vidaxl_it_categories.csv
NL:	vidaxl_nl_categories.csv
NO:	vidaxl_no_categories.csv
PT:	vidaxl_pt_categories.csv
SK:	vidaxl_sk_categories.csv
SI:	vidaxl_si_categories.csv
ES:	vidaxl_es_categories.csv
UK:	vidaxl_uk_categories.csv
DE:	vidaxl_de_categories.csv
US:	vidaxl_us_categories.csv
AT:	vidaxl_at_categories.csv
CZ:	vidaxl_cz_categories.csv
CH:	vidaxl_ch_categories.csv
PL:	vidaxl_pl_categories.csv
Afound:	afound_categories.csv
Miinto:
NO:	miinto_no_categories.csv
SE:	miinto_se_categories.csv
NL:	miinto_nl_categories.csv
BE:	miinto_be_categories.csv
PL:	miinto_pl_categories.csv
CH:	miinto_ch_categories.csv
Åhléns:	ahlens_categories.csv
Huuto:	huuto_categories.csv
Fruugo:	fruugo_categories.csv
Allegro:	allegro_categories.csv
Spartoo:
UK:	spartoo_uk_categories.csv
FR:	spartoo_fr_categories.csv
ES:	spartoo_es_categories.csv
DE:	spartoo_de_categories.csv
IT:	spartoo_it_categories.csv
NL:	spartoo_nl_categories.csv
PL:	spartoo_pl_categories.csv
SE:	spartoo_se_categories.csv
DK:	spartoo_dk_categories.csv
FI:	spartoo_fi_categories.csv
GR:	spartoo_gr_categories.csv
PT:	spartoo_pt_categories.csv
TU:	spartoo_tu_categories.csv
BE:	spartoo_be_categories.csv
AT:	spartoo_at_categories.csv
CZ:	spartoo_cz_categories.csv
CN:	spartoo_cn_categories.csv
SK:	spartoo_sk_categories.csv
HU:	spartoo_hu_categories.csv
RO:	spartoo_ro_categories.csv
BG:	spartoo_bg_categories.csv
SI:	spartoo_si_categories.csv
HR:	spartoo_hr_categories.csv
Etsy:	etsy_categories.csv
Zalando:
DE:	zalando_de_categories.csv
NL:	zalando_nl_categories.csv
FR:	zalando_fr_categories.csv
IT:	zalando_it_categories.csv
UK:	zalando_uk_categories.csv
AT:	zalando_at_categories.csv
CH:	zalando_ch_categories.csv
PL:	zalando_pl_categories.csv
BE:	zalando_be_categories.csv
SE:	zalando_se_categories.csv
FI:	zalando_fi_categories.csv
DK:	zalando_dk_categories.csv
ES:	zalando_es_categories.csv
NO:	zalando_no_categories.csv
CZ:	zalando_cz_categories.csv
IE:	zalando_ie_categories.csv
PT:	zalando_pt_categories.csv
Tradera:	tradera_categories.csv
CDON:
V4 (new 2020):	cdon_v4_categories.csv
V2 (old 2014):	cdon_v2_categories.csv
Let's Deal:
SE:	letsdeal_se_categories.csv
NO:	letsdeal_no_categories.csv
Fyndiq:
V3:	fyndiq_v3_categories.csv
V2:	fyndiq_v2_categories.csv
Amazon:
UK:	amazon_uk_categories.csv
SE:	amazon_se_ctegories.csv
ES:	amazon_es_categories.csv
FR:	amazon_fr_categories.csv
DE:	amazon_de_categories.csv
IT:	amazon_it_categories.csv
eBay:
US:	ebay_us_categories.csv
AT:	ebay_at_categories.csv
IT:	ebay_it_categories.csv
IE:	ebay_ie_categories.csv
UK:	ebay_uk_categories.csv
FR:	ebay_fr_categories.csv
DE:	ebay_de_categories.csv
NL:	ebay_nl_categories.csv
ES:	ebay_es_categories.csv
PL:	ebay_pl_categories.csv
Elkjøp Nordic:
Elkjøp:	elkjop_categories.csv
Elgiganten Sweden:	elgiganten_sweden_categories.csv
Elgiganten Denmark:	elgiganten_denmark_categories.csv
Gigantti:	gigantti_categories.csv

Google Categories:

This list contains Google's own category hierarchy, this is used by the "Sello Category" -feature in the inventory, read more here.

google_categories.csv

Once you have found out what to name your column and located your category ID:s, you need to edit your file.

Here's how:

Open your exported file.
Add a new column.
Name the column according to the legend in Sello.
Input your desired category ID:s under your category column.
Save the file as .xlsx.

The last step is to import the file in Sello.

Here's how:

Log into Sello.
In the top-left menu, find "Import / export".
Find "Excel" in the Import -section.
Click: "Import".
Choose: "Update products with my file".
Select your file.
Click: "Start".

Your file will now be queued for processing, you can see your estimated wait time to the right.

Done!

Good to know:

Should you want to create products with categories, simply use your SKU:s as a product identifier instead of "Id" and choose "Create new products from my file".

Related articles