Jump to content

Importing Default Category for Each Product using CSV?


ijoin

Recommended Posts

hi,

 

Is there any way to bulk edit the default category for each product?

 

I have about 3000 products and it will take long time to edit it one by one

 

I want to change the default category so I can show the full breadcumb path

 

Or is there any way to show full breadcumb without changing the default cateogry?

 

Thanks

Link to comment
Share on other sites

What do you mean by "bulk edit"?

You can create all the things in the admin section category wise and breadcrumb can manage from the admin easily.

May I know, which platform you are using?

 

I mean how to edit all my products' default category in one go?

 

First the breadcumb is like this, it only show the main category without showing the sub category

 

motobreadcumerror.png

 

 

I need to edit the default category for the product, like this

 

motocategory.png

 

So in the end it will be like this

 

after.png

 

 

 

 

What i mean is, is there a way to bulk edit all the product via csv?

thanks

Link to comment
Share on other sites

  • 3 months later...

On previous 1.5 version it used to be the first category in the csv e.g (11|12 || other category || other category...)

Categories (x,y,z...) = 11|12||23|24|25|54

 

But I noticed that in my 1.6.0.9  it only sets to the first category (11) ignoring the following (12) in my example.  Is it a bug? or is this intended?

Link to comment
Share on other sites

Hi proudbird,

 

I found a solution here https://www.prestashop.com/forums/topic/166528-how-to-set-default-category-in-the-csv-import-file/

 

Currently, I think the only way you can bulk change the default category is by using sql, not by csv file.

 

You can find the sql code from the topic above, written by TWDesign.

 

And please take note that you need to run the sql code in both "ps_product" and "ps_product_shop" tables in order to make it works.

 

I have tried it, and it works for me.

 

Hope this would be helpful to you.

Link to comment
Share on other sites

Hi bruce_ooi,

 

Thank for your reply, but I solved that problem another way (but I am not sure that it solves the problem completely). I took the last version of AdminImportController.php from here. It helped me to set the default category as I want, but as I understood the issue is opened still.

Link to comment
Share on other sites

×
×
  • Create New...