Mass Delete

Some how I have created multiple listings for the same item. I think I made any error in importing a csv file. For example I have over 100 separate items with the same SKU (STNP-1) and desription. Is there a way to delete these as a bunch and not each single one. Thanks for any advice.

Reply to
Steve
Loading thread data ...

Steve:

Each item has a unique ID called the primary key even though you may have entered all of the other > Some how I have created multiple listings for the same item. I think I made

Reply to
MO

Steve, also keep in mind if you have activity in your database for any of these items, deleting them may cause some problems as the itemid for the deleted items are stored in other tables throughout the database when you use them on a purchase order, sales transaction, physical inventory, etc.... Deleting these items in this case will leave behind orphan records in these tables

hth kev> Steve:

Reply to
kskinne

Tom, I use this query with items that have been created incorrectly, but what I find is that I can not delete from the actual Matrix Name. I hate all of the ZZ's that we have had to create because of the persons involved with creating the items. Do you know of anything to remove Matrix Names?

Thank you.

Jocelyn

"Terrible Tom" wrote:

Reply to
Jocelyn

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.