Import Product manufacturer or barcode and it generates a new category '0'

[Harfoot]

When I import from a .csv file the barcode or the manufacturer for an existing product. The details are added successfully but it also puts the product in a new category called '0'

It keeps the existing categories but each update makes a new category.

So if I import 20 product updates I get 20 new categories called '0'

 

The .csv is very simple only using the SKU as reference and then one value barcode still does this

Any ideas appreciated

Thanks

[Adria Laxson]

No matter what part of the product I am adjusting I always select the ID, the name & the item I am adjusting. Then for the rest I select "ignore this column." It works every time that way.

[Harfoot]

Hi There,

Thanks for the answer.

I have just tried this and the same thing happened. All the data uploaded correctly however it still added a new Category '0' and also added this to the product.

 

It is a very simple test file I am using.

I have attached some screen shots which might help

 

[Adria Laxson]

You have a much newer version than I do. I've got that version installed for someone else I plan to take a look once I get a chance. If nobody else responds I will try to help.

[Harfoot]

Hi Adria,

Thanks, I want to import 1,200 barcodes and manufacturers so I don't want to create 1,200 new categories called '0' but I can't seem to see why it is happening.

[Adria Laxson]

I'm working in 1.6 now and realize what your missing in your code is the category name/names that you want your product going into. Adding that line will put it in the proper place. Sorry so late but maybe it helps someone else.

[Diego M.]

Maybe a bit late but this issue is still happening and other users could be affected.

Yoy shoud check your "category_product" table, its almost sure that there are oime ghost registers addresing the id_product with a "0" id_category.

When the importer (on a update import) try to recover the old categories from the product, it will find this "0" id_category and will treat as a new category.