oscommerce - массовое удаление заказов.
Информация о заказах в OsCommerce хранится в нескольких таблицах (все они начинаются с oders…)
Для быстрого массового удаления информации о заказах можно использовать SQL-скрипт:
delete from orders_products where orders_id in (select orders_id from `orders` WHERE date_purchased<'2010-10-01');
delete from orders_products_attributes where orders_id in (select orders_id from `orders` WHERE date_purchased<'2010-10-01');
delete from orders_status_history where orders_id in (select orders_id from `orders` WHERE date_purchased<'2010-10-01');
delete FROM `orders_total` where orders_id in (select orders_id from `orders` WHERE date_purchased<'2010-10-01');
delete FROM `orders` WHERE 1 and date_purchased<'2010-10-01';
Да, самое главное.. не забудьте сделать резервную копию!
Удачи!
UPD Массовое удаление клиентов (кроме админов)
delete FROM `address_book` WHERE customers_id not in (select customers_id from admin_access); delete FROM `customers` WHERE customers_id not in (select customers_id from admin_access);
delete FROM `customers_info` WHERE customers_id not in (select customers_id from admin_access);
Метки: oscommerce
