mass delete products
Avatar image
Jun 29, 2014
Joseph wrote
I have to delete about 160,000 products, store manager says lasts 510 hours.
Is there a possibility to delete products quickly?
Reply
8 Answers
Avatar image
Jun 30, 2014
Support Manager agent wrote
Hello,

Thank you for your question.

We'd recommend you to setup bridge connection and remove products locally. Please check our documentation for details how to setup bridge connection:
http://store-manager-for-magento-documentation.emagicone.com/quick-start-guide/php-mysql-bridge-connection

Let us know if you have more questions
Avatar image
Jun 30, 2014
Joseph wrote
Hello,

I work with bridge Connection
the system i work with is strong enough, core i7 4771 - 32 GB ram - ssd harddrive
so i do not now why it is so slow to delete products

regards Josef
Avatar image
Jul 01, 2014
Support Manager agent wrote
Hello,

Thank you for your reply.

Please try to remove the products by parts - divide it by 10k
Unfortunately, there is no another way to speed-up the process, since Store Manager have to remove records from all related tables.

Let us know if you have other questions
Avatar image
Jul 01, 2014
Joseph wrote
Hello


it takes 26 seconds to one product to delete,
no matter how many I select, 1 10 or 1000
Avatar image
Jul 02, 2014
Support Manager agent wrote
Hello,

Thank you for your reply.

Please submit a ticket and provide us with Store Manager logs to check (you can find log files at Start/All programs/eMagicOne/Store Manager for Magento/Application data/Logs)
Also, please provide us with your store connection configuration (you can save it at Preferences[F12] / Actions / Save current configuration) and id of the product that we could delete from our side, so we could check what caused the issue for you.

Please do not post any details here, since it is a public forum and all data is accessible for all our users.

Waiting to hear from you
Avatar image
Jul 15, 2014
NETOMZET NL wrote
You can do this via phpmyadmin:
SET FOREIGN_KEY_CHECKS = 0;

TRUNCATE TABLE `catalog_product_bundle_price_index`;
TRUNCATE TABLE `catalog_product_bundle_selection`;
TRUNCATE TABLE `catalog_product_bundle_selection_price`;
TRUNCATE TABLE `catalog_product_bundle_option_value`;
TRUNCATE TABLE `catalog_product_bundle_option`;
TRUNCATE TABLE `catalog_product_entity_datetime`;
TRUNCATE TABLE `catalog_product_entity_decimal`;
TRUNCATE TABLE `catalog_product_entity_gallery`;
truncate table `catalog_product_entity_group_price`;
TRUNCATE TABLE `catalog_product_entity_int`;
TRUNCATE TABLE `catalog_product_entity_media_gallery`;
TRUNCATE TABLE `catalog_product_entity_media_gallery_value`;
TRUNCATE TABLE `catalog_product_entity_text`;
TRUNCATE TABLE `catalog_product_entity_tier_price`;
TRUNCATE TABLE `catalog_product_entity_varchar`;
TRUNCATE TABLE `catalog_product_flat_1`;
TRUNCATE TABLE `catalog_product_link`;
TRUNCATE TABLE `catalog_product_link_attribute_decimal`;
TRUNCATE TABLE `catalog_product_link_attribute_int`;
TRUNCATE TABLE `catalog_product_link_attribute_varchar`;
TRUNCATE TABLE `catalog_product_option`;
TRUNCATE TABLE `catalog_product_option_price`;
TRUNCATE TABLE `catalog_product_option_title`;
TRUNCATE TABLE `catalog_product_option_type_price`;
TRUNCATE TABLE `catalog_product_option_type_title`;
TRUNCATE TABLE `catalog_product_option_type_value`;
TRUNCATE TABLE `catalog_product_super_attribute_label`;
TRUNCATE TABLE `catalog_product_super_attribute_pricing`;
TRUNCATE TABLE `catalog_product_super_attribute`;
TRUNCATE TABLE `catalog_product_super_link`;
TRUNCATE TABLE `catalog_product_enabled_index`;
TRUNCATE TABLE `catalog_product_website`;
TRUNCATE TABLE `catalog_category_product_index`;

TRUNCATE TABLE `catalog_category_product`;

TRUNCATE TABLE `catalog_product_entity`;
truncate table `catalog_product_relation`;

TRUNCATE TABLE `cataloginventory_stock_item`;
TRUNCATE TABLE `cataloginventory_stock_status`;
SET FOREIGN_KEY_CHECKS = 1;



When reindex all gives an errror, just truncate the table that causes the error and the reindexer will regenerate it.
Avatar image
Jul 15, 2014
NETOMZET NL wrote
^ Works on Magento ver. 1.8
Avatar image
Jul 16, 2014
Support Manager agent wrote
Hello,

Thank you for your reply.

Actually, you can run same SQLs at Custom SQL section at Store Manager. Please note, that running such SQLs required basic knowledge of shopping cart structure, so it is not recommended to run it each time.

We checked from our side and we should mention that deleting 1 product took 1-2 seconds (with removing images).

Can you please provide us with Store Manager logs to check (you can find log files at Start/All programs/eMagicOne/Store Manager for Magento/Application data/Logs)

Waiting to hear from you