Skip to main content
Sign in

How to set product category with Excel

  • Updated

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:

  1. Log into Sello
  2. In the top-left menu, find Import / export
  3. Go to the Export section
  4. Click: Export Inventory
  5. Select the columns you want to export, such as Item no or SKU
  6. 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:

  1. Log into Sello
  2. In the top-left menu, find Import / export
  3. Find Excel in the Import -section
  4. Click: Import
  5. 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 tell 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.

Afound

afound_categories.csv

Allegro

allegro_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
NL - amazon_nl_categories.csv
PL - amazon_pl_categories.csv
BE - amazon_be_categories.csv

Asos

asos_categories.csv

Bol

bol_categories.csv

Boulanger

boulanger_categories.csv

Carethy

carethy_categories.csv

Carrefour

carrefour_categories.csv

Cdiscount

cdiscount_en_categories.csv

CDON

V4.9+ (newest): cdon_v4.9+_categories.csv
V4: cdon_v4_categories.csv

Conrad

bol_categories.csv

Decathlon

decathlon_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

Ellos

ellos_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

eMAG

emag_categories.csv

ePrice

eprice_categories.csv

Etsy

etsy_categories.csv

Fnac

FR - fnac_fr_categories.csv
BE-FR - fnac_be-fr_categories.csv
BE-NL - fnac_be-nl_categories.csv
ES - fnac_es_categories.csv
PT - fnac_pt_categories.csv
CH - fnac_ch_categories.csv

Fruugo

fruugo_categories.csv

Fyndiq

fyndiq_categories.csv

H&M

hm_categories.csv

Homeroom

homeroom_categories.csv

INNO

inno_categories.csv

Joom

joom_categories.csv

Kaufland

kaufland_categories.csv

Let's Deal

SE: letsdeal_se_categories.csv
NO: letsdeal_no_categories.csv

ManoMano

DE - manomano_de_categories.csv
ES - manomano_es_categories.csv
FR - manomano_fr_categories.csv
IT - manomano_it_categories.csv
UK - manomano_uk_categories.csv

Manor

manor_categories.csv

MediaMarkt

mediamarkt_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

NK

nk_categories.csv

OnBuy

onbuy_categories.csv

PcComponentes

pccomponentes_categories.csv

Perfume's club

perfumesclub_categories.csv

Rakuten

FR - rakuten_fr_categories.csv
DE - rakuten_de_categories.csv

Secret Sales

secretsales_categories.csv

Sephora

sephora_categories.csv

Stadium

SE - stadium_se_categories.csv
FI - stadium_fi_categories.csv

Tradera

tradera_categories.csv

Worten

ES - worten_es_categories.csv
PT - worten_pt_categories.csv

Yoox

yoox_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

Åhléns

ahlens_categories.csv

Google Categories:

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

Google

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:

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

 en_import_category_7.png

 The last step is to import the file in Sello.

Here's how:

  1. Log into Sello
  2. In the top-left menu, find Import / export
  3. Find Excel in the Import -section
  4. Click: Import
  5. Choose: Update products with my file
  6. Select your file
  7. Click: Start

sv_import_category_8.png  sv_import_category_9.png sv_import_category_10.png sv_import_category_11.png

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

 

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