AbanteCart Community

General Topics => General Discussion => Topic started by: elmergrech on August 01, 2017, 02:33:02 PM

Title: Product Tag via CSV Import
Post by: elmergrech on August 01, 2017, 02:33:02 PM

I have inserted the products via csv data import. However I made a mistake and I now have 14 product tags for each product. How can I remove the product tags and start again. I have 1200 products and therefore I need a solution using csv import instead of going into each and every product to delete. Any help please?

Title: Re: Product Tag via CSV Import
Post by: Geoffrey on August 01, 2017, 09:46:46 PM

Off the top of my head:

You could try to import products again without the "mistake".
If the new import overwrites the existing product library, your excess tags should disappear?

Alt:
Export your product library as a csv. 
Use excel to clean it up. 
Re-import.

Title: Re: Product Tag via CSV Import
Post by: elmergrech on August 18, 2017, 01:16:41 PM

HI thanks for your help. The problem is that when i export through csv, clean and re import clean data, the system does not overwrite, it just adds to current data.

anyway, i managed to solve the problem by accessing and deleting bad data from the database directly/