mass delete products

Jun 30, 2014

Ira Kobylianska 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

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

Jul 01, 2014

Ira Kobylianska 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

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

Jul 02, 2014

Ira Kobylianska 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

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.

Jul 15, 2014

NETOMZET NL wrote

^ Works on Magento ver. 1.8

Jul 16, 2014

Ira Kobylianska 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