Multi Product Delete Problem

[glamourfish]

Hi People...I need some help if any of you know what I can do. I used the Multi Product Manager to delete items from my site. However when I used the delete option I chose to delete "only in this category" option. So now if I do a search by category type the item is not there = very good. BUT when i search by manufacturer it is still there = VERY BAD!!! This mean that the item doesn't show up anywhere in my control panel & I need to go into my database to delete them there - about 500 items, BUT ONLY after trying to compare the 2 different options of sorting first by manufacturer then by category! I'm going mad! ANY suggestions how one might be able to fix this easly I living in a dream world? :blink: :'( >_< :blink:

[glamourfish]

I eventually figured this one out - not sure if it was the best solution but this is what I done (just in case anybody is ever stuck with the same problem:

 

1. Exported from DataBase to Excel: PRODUCTS & deleted everything besides Product ID Column.

2. Exported from DataBase to Excel: PRODUCTS_TO_CATEGORIES

3. Merge the above into 1 excel spreadsheet on different workbooks.

4. Did a VLookUp to see which from PRODUCTS_TO_CATEGORIES where not included in ALL PRODUCTS list by comparing the PRODUCT ID.

5. Then ran a SQL query to delete the Product ID's NOT having a CATEGORY connected to it. (SQL query to be run in mySQLadmin control panel with hosting company)

 

It looked something like this (i won't how all 500+ lines I had):

 

DELETE FROM `products` WHERE `products_id` =32 LIMIT 1 ;

DELETE FROM `products` WHERE `products_id` =33 LIMIT 1 ;

DELETE FROM `products` WHERE `products_id` =37 LIMIT 1 ;

DELETE FROM `products` WHERE `products_id` =38 LIMIT 1 ;

DELETE FROM `products` WHERE `products_id` =39 LIMIT 1 ;

DELETE FROM `products` WHERE `products_id` =40 LIMIT 1 ;

DELETE FROM `products` WHERE `products_id` =41 LIMIT 1 ;

......

 

Surprisingly enough it worked!!!

 

 

Hope that helps somebody else in future! Once I had it figured out it only took about 20 mins to do!