While importing via EZ Populate, I did not notice that my vendor changed the formats of the Categories and Sub Categories. Categories like:
ANTENNA - ACCES ............ are now
ANTENNA - ACCESSORIES
and so on and so forth, I have about 3,000 duplicate items with the same ID and "Invalid Master Category"
Is there an SQL script I can run to delete items in bulk from the invalid categories? Without Deleting them from the remaining categories?
Not sure of the SQL syntax but I am guessing something like
Delete * from Category 9
Delete * from Category 11
Delete * from Category 46
Will something like this do it? And for the SA's that want to make a smart remark, YES I already searched, but may not be searching for the right keywords, and if I already had a clue, I would not be asking here.
THANKS ALL
JOhn ><>


Reply With Quote
