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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

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