How to set up categories into different products on excel exported file.

Question

Im trying to add various categories to different products which share the same categories on a excel file, since adding them manually to each products on the product creation screen takes a huge amount of time.
I been trying to add at least 3-4 categories to different products, which are already added into the ecommerce categories but I can't figure out how to set up the excel file or when I am exporting the file, which columns need to be exported and in which correct order so that they can be a

Anusha · Accepted Answer

Hi,
I hope you already imported the products and the Ecomerce Category.  first of all export the categories containg *name and  id.*then export the products including *name,website category*.So you get all the data to import.change the website category column with the category database id in the product master that you already exported .then Go to Products and import this .don't forgot to take the column name as  *product external ID* for product since we are updating an existing data and also s

Sidibe Aliou Badara · Answer

try to use the category Id, not external id; if you want to import.

This question has been flagged

Enjoying the discussion? Don't just read, join in!