Clean dates demo Prestashop v1.7 - Borrado de datos de ejemplos Prestashop v1.7

clean-prestashop-v1.7.x.md

Borrado de Datos de Ejemplo en Prestashop v1.7.x

PROCESO

1. Borrar Direcciones
2. Borrar Clientes
3. Carritos de Compra
4. Borrar Pedidos
5. Borrar Pedidos del Trash
6. Reset Num Factura

CONSULTAR REGISTROS

1. Elimina las Direcciones

SELECT * FROM ps_address;

2. Elimina los Clientes

SELECT * FROM ps_customer;
SELECT * FROM ps_customer_group;

3. Elimina los Pedidos y resetea numero de factura

SELECT * FROM ps_orders;
SELECT * FROM ps_order_detail;
SELECT * FROM ps_order_history;
SELECT * FROM ps_order_invoice;
SELECT * FROM ps_order_invoice_payment;
SELECT * FROM ps_order_payment;
SELECT * FROM ps_order_carrier;

4. Elimina la Información Adicional de Clientes y Carritos

SELECT * FROM ps_cart;
SELECT * FROM ps_cart_product;
SELECT * FROM ps_connections;
SELECT * FROM ps_guest;

5. Limpiar la Caché

EXEC DELETE

DELETE FROM ps_address;
DELETE FROM ps_customer;
DELETE FROM ps_customer_group;
DELETE FROM ps_orders;
DELETE FROM ps_order_detail;
DELETE FROM ps_order_history;
DELETE FROM ps_order_invoice;
DELETE FROM ps_order_invoice_payment;
DELETE FROM ps_order_payment;
DELETE FROM ps_order_carrier;
DELETE FROM ps_cart;
DELETE FROM ps_cart_product;
DELETE FROM ps_connections;
DELETE FROM ps_guest;