Jump to content
romper

Mutliple categories and subcategories CSV import

Recommended Posts

Hello,

 

I import products through CSV import and it works great. However I can not import multiple categories and its subcategories. I have following tree of categories and subcategories that one of my product belongs to.

 

  • Backpacks (main category)
    •          Bicycle backpacks(subcategory)

  • Backpacks (main category)
    •          Bags(subcategory)

  • Travel (main category)
    •          Bags (subcategory)

 

In my .CSV file I refer to this category tree in this way:

 

Categories (x,y,z...)

Backpack, Bicycle backpacks, Backpacks, Bags, Travel, Bags.

 

CSV importer links some but not all categories and subcategories with a product. How to solve it. How can I match all categories and subcategories with a product.

 

Thank you,

Edited by romper (see edit history)

Share this post


Link to post
Share on other sites
I solved my issue. If you want to transform your category and subcategory tree into csv import format , you should use slash / to specify dependencies between your category and subcategories. If you have more than one category, you should separate them by comma.

 

So my csv import category table looks like this:

 

Backpacks/Bicycle backpacks, Backpack/Bags, Travel/Bags

Edited by romper (see edit history)

Share this post


Link to post
Share on other sites

I've been struggling with this for over a month.

My Categories csv loads perfectly but when I import Products, additional categories are created. The / method leaves me with a a tree with sub categories within Parent categories and vice versa. Prestashop support are useless, Teapot never get back to me, I have spent nearly £1000 on 'Experts' who just seem interested in taking money.

 

Are there any Experts on here that can give me real advice on how to correctly format these sheets?

 

 

Share this post


Link to post
Share on other sites

Just Use category id instead of the words. Put the last ID of the category. Example Home(id:1),Bycicles(id:2), Wheels(id:3) in the spreadsheet at the voice Category x,y,z just put the number 3

Share this post


Link to post
Share on other sites

I managed to sort out the issues. Its a easy work around...

Basically you need to do a level by level import...

1. In the import CSV file, first import your main Categories under the Name coloum and under Parent you add "HOME", this essentially adds your main categories under HOME as the parent...

2. Import the CSV again, this time replace the HOME with the name of the categories in file 1 in the parent coloum. Please see example below

My Categories are Printers > HP Printer

IMPORT FILE 1

Name = Printers | Parent = HOME

IMPORT FILE 2- Do not delete old categories, remove the tick this will update the current categories

Name = HP Printer | Parent = Printers

Regards

 

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More