Author Topic: Product Tag via CSV Import  (Read 4211 times)

Offline elmergrech

  • Newbie
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Product Tag via CSV Import
« 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?

Offline Geoffrey

  • Full Member
  • ***
  • Posts: 153
  • Karma: +28/-3
    • View Profile
Re: Product Tag via CSV Import
« Reply #1 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.


Offline elmergrech

  • Newbie
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Product Tag via CSV Import
« Reply #2 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/

 

Powered by SMFPacks Social Login Mod