Removing lots of items

[magicjebb]

Hello, there.

 

I use Easy Populate that helps me updating my shop very quickly, but lately I'm having a problem with it.

 

I configured my shop not to show stuff that are not available in stock, but EP updates these items as well, and since these items correspond to half of my stock (currently more than 10000 items) they really slow down the shop.

 

Is there a way to include an option that could erase from the database all these items that are not available in stock at once?

 

I guess a simple piece of code would do the job, but since I really don't know WHAT I should go erasing from my database, better leave it for the pros.

[Guest]

I have a vague memory of writing to my webhost when I needed help updating my database. I wanted to change the weight of all 3,000 items from .5 to 1 at once. They wrote a little SQL snippet for me to use in phyMyAdmin that accomplished that.

 

I suppose you could run something there that would delete all products with a quantity of zero. That being said, I don't know what that would be. Personally, I'm rather skiddish about messing around with the database. Your webhost may be of help with this, though.

[magicjebb]

I have a vague memory of writing to my webhost when I needed help updating my database. I wanted to change the weight of all 3,000 items from .5 to 1 at once. They wrote a little SQL snippet for me to use in phyMyAdmin that accomplished that.

 

I suppose you could run something there that would delete all products with a quantity of zero. That being said, I don't know what that would be. Personally, I'm rather skiddish about messing around with the database. Your webhost may be of help with this, though.

 

 

Honestly, I don't want to mess around with the mysql database. The last time I've tried to remove a product right from the database I had to write the whole thing back, since there seems to be several instances of data that must be removed together for the trick to work and the product to disappear without leaving any errors.

 

I would gladly try to develop something on my own if somebody could just point out WHICH are these instances of data to be removed.

 

Other thing that occured me is that there could be an implementation on EasyPopulate that would remove 0 stock items from the database at the time the easypopulate excel file is updated, rather than adding them. If the file shows 0 in the 'v_products_quantity', the item is removed. Again, such modification would necessarily imply in knowing which mysql data to be removed or changed, not to mess up with the whole shop.

 

Anybody else, some help on these data to be removed?

[adyck]

Honestly, I don't want to mess around with the mysql database. The last time I've tried to remove a product right from the database I had to write the whole thing back, since there seems to be several instances of data that must be removed together for the trick to work and the product to disappear without leaving any errors.

 

I would gladly try to develop something on my own if somebody could just point out WHICH are these instances of data to be removed.

 

Other thing that occured me is that there could be an implementation on EasyPopulate that would remove 0 stock items from the database at the time the easypopulate excel file is updated, rather than adding them. If the file shows 0 in the 'v_products_quantity', the item is removed. Again, such modification would necessarily imply in knowing which mysql data to be removed or changed, not to mess up with the whole shop.

 

Anybody else, some help on these data to be removed?

 

This has been a chronic issue with me, too. I have about 4,000 items in my store and I update my database quarterly from an excel spreadsheet that my supplier gives me using Easy Populate. But, again, the issue is that it won't remove the items that aren't available anymore and so I've done it manually. When I know that my database is really screwed up, I delete all of the categories to clean out my database and upload the new database.