No olvidarse de ajustar el prefijo de las tablas antes de ejecutar la consulta SQL
Funciona con versión 1.9.x.x
CLIENTES
SET FOREIGN_KEY_CHECKS=0; |
-- Eliminar clientes y su respectiva información |
TRUNCATE `customer_address_entity`; |
TRUNCATE `customer_address_entity_datetime`; |
TRUNCATE `customer_address_entity_decimal`; |
TRUNCATE `customer_address_entity_int`; |
TRUNCATE `customer_address_entity_text`; |
TRUNCATE `customer_address_entity_varchar`; |
TRUNCATE `customer_entity`; |
TRUNCATE `customer_entity_datetime`; |
TRUNCATE `customer_entity_decimal`; |
TRUNCATE `customer_entity_int`; |
TRUNCATE `customer_entity_text`; |
TRUNCATE `customer_entity_varchar`; |
ALTER TABLE `customer_address_entity` AUTO_INCREMENT=1; |
ALTER TABLE `customer_address_entity_datetime` AUTO_INCREMENT=1; |
ALTER TABLE `customer_address_entity_decimal` AUTO_INCREMENT=1; |
ALTER TABLE `customer_address_entity_int` AUTO_INCREMENT=1; |
ALTER TABLE `customer_address_entity_text` AUTO_INCREMENT=1; |
ALTER TABLE `customer_address_entity_varchar` AUTO_INCREMENT=1; |
ALTER TABLE `customer_entity` AUTO_INCREMENT=1; |
ALTER TABLE `customer_entity_datetime` AUTO_INCREMENT=1; |
ALTER TABLE `customer_entity_decimal` AUTO_INCREMENT=1; |
ALTER TABLE `customer_entity_int` AUTO_INCREMENT=1; |
ALTER TABLE `customer_entity_text` AUTO_INCREMENT=1; |
ALTER TABLE `customer_entity_varchar` AUTO_INCREMENT=1; |
-- Eliminar Búsquedas |
TRUNCATE `catalogsearch_query`; |
TRUNCATE `catalogsearch_fulltext`; |
TRUNCATE `catalogsearch_result`; |
ALTER TABLE `catalogsearch_query` AUTO_INCREMENT=1; |
ALTER TABLE `catalogsearch_fulltext` AUTO_INCREMENT=1; |
ALTER TABLE `catalogsearch_result` AUTO_INCREMENT=1; |
-- Eliminar Encuestas |
TRUNCATE `poll`; |
TRUNCATE `poll_answer`; |
TRUNCATE `poll_store`; |
TRUNCATE `poll_vote`; |
ALTER TABLE `poll` AUTO_INCREMENT=1; |
ALTER TABLE `poll_answer` AUTO_INCREMENT=1; |
ALTER TABLE `poll_store` AUTO_INCREMENT=1; |
ALTER TABLE `poll_vote` AUTO_INCREMENT=1; |
-- Eliminar Reportes |
TRUNCATE `report_viewed_product_index`; |
ALTER TABLE `report_viewed_product_index` AUTO_INCREMENT=1; |
-- Eliminar Boletín de noticias |
TRUNCATE `newsletter_queue`; |
TRUNCATE `newsletter_queue_link`; |
TRUNCATE `newsletter_subscriber`; |
TRUNCATE `newsletter_problem`; |
TRUNCATE `newsletter_queue_store_link`; |
ALTER TABLE `newsletter_queue` AUTO_INCREMENT=1; |
ALTER TABLE `newsletter_subscriber` AUTO_INCREMENT=1; |
ALTER TABLE `newsletter_problem` AUTO_INCREMENT=1; |
ALTER TABLE `newsletter_queue_store_link` AUTO_INCREMENT=1; |
-- Eliminar lista de deseos |
TRUNCATE `wishlist`; |
ALTER TABLE `wishlist` AUTO_INCREMENT=1; |
SET FOREIGN_KEY_CHECKS=1; |
LOGS
SET FOREIGN_KEY_CHECKS=0; |
TRUNCATE `log_customer`; |
TRUNCATE `log_visitor`; |
TRUNCATE `log_visitor_info`; |
TRUNCATE `log_visitor_online`; |
TRUNCATE `log_quote`; |
TRUNCATE `log_summary`; |
TRUNCATE `log_summary_type`; |
TRUNCATE `log_url`; |
TRUNCATE `log_url_info`; |
TRUNCATE `sendfriend_log`; |
TRUNCATE `report_event`; |
TRUNCATE `dataflow_batch_import`; |
TRUNCATE `dataflow_batch_export`; |
TRUNCATE `index_process_event`; |
TRUNCATE `index_event`; |
ALTER TABLE `log_customer` AUTO_INCREMENT=1; |
ALTER TABLE `log_visitor` AUTO_INCREMENT=1; |
ALTER TABLE `log_visitor_info` AUTO_INCREMENT=1; |
ALTER TABLE `log_visitor_online` AUTO_INCREMENT=1; |
ALTER TABLE `log_quote` AUTO_INCREMENT=1; |
ALTER TABLE `log_summary` AUTO_INCREMENT=1; |
ALTER TABLE `log_url_info` AUTO_INCREMENT=1; |
ALTER TABLE `sendfriend_log` AUTO_INCREMENT=1; |
ALTER TABLE `report_event` AUTO_INCREMENT=1; |
ALTER TABLE `dataflow_batch_import` AUTO_INCREMENT=1; |
ALTER TABLE `dataflow_batch_export` AUTO_INCREMENT=1; |
ALTER TABLE `index_event` AUTO_INCREMENT=1; |
SET FOREIGN_KEY_CHECKS=1; |
PRODUCTOS
SET FOREIGN_KEY_CHECKS = 0; |
TRUNCATE TABLE `catalog_product_bundle_option`; |
TRUNCATE TABLE `catalog_product_bundle_option_value`; |
TRUNCATE TABLE `catalog_product_bundle_selection`; |
TRUNCATE TABLE `catalog_product_entity_datetime`; |
TRUNCATE TABLE `catalog_product_entity_decimal`; |
TRUNCATE TABLE `catalog_product_entity_gallery`; |
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_link`; |
TRUNCATE TABLE `catalog_product_link_attribute`; |
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_link_type`; |
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`; |
TRUNCATE TABLE `catalog_product_super_attribute_label`; |
TRUNCATE TABLE `catalog_product_super_attribute_pricing`; |
TRUNCATE TABLE `catalog_product_super_link`; |
TRUNCATE TABLE `catalog_product_enabled_index`; |
TRUNCATE TABLE `catalog_product_website`; |
TRUNCATE TABLE `catalog_product_entity`; |
TRUNCATE TABLE `cataloginventory_stock_item`; |
TRUNCATE TABLE `cataloginventory_stock_status`; |
TRUNCATE TABLE `catalog_category_entity`; |
TRUNCATE TABLE `catalog_category_entity_datetime`; |
TRUNCATE TABLE `catalog_category_entity_decimal`; |
TRUNCATE TABLE `catalog_category_entity_int`; |
TRUNCATE TABLE `catalog_category_entity_text`; |
TRUNCATE TABLE `catalog_category_entity_varchar`; |
TRUNCATE TABLE `catalog_category_product`; |
TRUNCATE TABLE `catalog_category_product_index`; |
TRUNCATE TABLE `catalog_product_relation`; |
TRUNCATE TABLE `catalog_product_flat_1`; |
TRUNCATE TABLE `catalog_category_flat_store_1`; |
TRUNCATE TABLE `catalog_category_flat_store_2`; |
TRUNCATE TABLE `catalog_category_flat_store_3`; |
-- Eliminar Etiquetas |
TRUNCATE `tag`; |
TRUNCATE `tag_relation`; |
TRUNCATE `tag_summary`; |
ALTER TABLE `tag` AUTO_INCREMENT=1; |
ALTER TABLE `tag_relation` AUTO_INCREMENT=1; |
ALTER TABLE `tag_summary` AUTO_INCREMENT=1; |
SET FOREIGN_KEY_CHECKS = 1; |
VENTAS/PEDIDOS
SET FOREIGN_KEY_CHECKS=0; |
TRUNCATE `sales_payment_transaction`; |
TRUNCATE `sales_flat_creditmemo`; |
TRUNCATE `sales_flat_creditmemo_comment`; |
TRUNCATE `sales_flat_creditmemo_grid`; |
TRUNCATE `sales_flat_creditmemo_item`; |
TRUNCATE `sales_flat_order`; |
TRUNCATE `sales_flat_order_address`; |
TRUNCATE `sales_flat_order_grid`; |
TRUNCATE `sales_flat_order_item`; |
TRUNCATE `sales_flat_order_status_history`; |
TRUNCATE `sales_flat_quote`; |
TRUNCATE `sales_flat_quote_address`; |
TRUNCATE `sales_flat_quote_address_item`; |
TRUNCATE `sales_flat_quote_item`; |
TRUNCATE `sales_flat_quote_item_option`; |
TRUNCATE `sales_flat_order_payment`; |
TRUNCATE `sales_flat_quote_payment`; |
TRUNCATE `sales_flat_quote_shipping_rate`; |
TRUNCATE `sales_flat_shipment`; |
TRUNCATE `sales_flat_shipment_item`; |
TRUNCATE `sales_flat_shipment_grid`; |
TRUNCATE `sales_flat_shipment_track`; |
TRUNCATE `sales_flat_invoice`; |
TRUNCATE `sales_flat_invoice_grid`; |
TRUNCATE `sales_flat_invoice_item`; |
TRUNCATE `sales_flat_invoice_comment`; |
TRUNCATE `sales_order_tax`; |
TRUNCATE `sales_order_tax_item`; |
-- Eliminar Reportes |
TRUNCATE `sales_bestsellers_aggregated_daily`; |
TRUNCATE `sales_bestsellers_aggregated_monthly`; |
TRUNCATE `sales_bestsellers_aggregated_yearly`; |
TRUNCATE `sales_invoiced_aggregated`; |
TRUNCATE `sales_invoiced_aggregated_order`; |
TRUNCATE `sales_order_aggregated_created`; |
TRUNCATE `sales_order_aggregated_updated`; |
TRUNCATE `sales_refunded_aggregated`; |
TRUNCATE `sales_refunded_aggregated_order`; |
TRUNCATE `sales_shipping_aggregated`; |
TRUNCATE `sales_shipping_aggregated_order`; |
TRUNCATE `coupon_aggregated`; |
TRUNCATE `review`; |
TRUNCATE `review_detail`; |
TRUNCATE `review_entity_summary`; |
TRUNCATE `rating_store`; |
ALTER TABLE `sales_payment_transaction` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_creditmemo` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_creditmemo_comment` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_creditmemo_grid` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_creditmemo_item` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_order` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_order_address` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_order_grid` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_order_item` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_order_status_history` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_quote` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_quote_address` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_quote_address_item` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_quote_item` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_quote_item_option` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_order_payment` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_quote_payment` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_quote_shipping_rate` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_shipment` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_shipment_item` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_invoice` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_invoice_grid` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_invoice_item` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_invoice_comment` AUTO_INCREMENT=1; |
ALTER TABLE `sales_flat_shipment_grid` AUTO_INCREMENT=1; |
ALTER TABLE `sales_order_tax` AUTO_INCREMENT=1; |
ALTER TABLE `sales_order_tax_item` AUTO_INCREMENT=1; |
TRUNCATE `eav_entity_store`; |
ALTER TABLE `eav_entity_store` AUTO_INCREMENT=1; |
SET FOREIGN_KEY_CHECKS=1; |