TRUNCATE commerce_customer_profile;
TRUNCATE commerce_customer_profile_revision;
TRUNCATE commerce_line_item;
TRUNCATE commerce_order;
TRUNCATE commerce_order_revision;
TRUNCATE commerce_payment_transaction;
TRUNCATE commerce_payment_transaction_revision;

TRUNCATE field_data_commerce_customer_address;
TRUNCATE field_data_commerce_customer_billing;
TRUNCATE field_data_commerce_customer_shipping;
TRUNCATE field_data_commerce_line_items;
TRUNCATE field_data_commerce_order_total;
TRUNCATE field_data_commerce_price;
TRUNCATE field_data_commerce_product;
TRUNCATE field_data_commerce_shipping_service;
TRUNCATE field_data_commerce_total;
TRUNCATE field_data_commerce_unit_price;

TRUNCATE field_data_commerce_display_path;
TRUNCATE field_data_field_supplier;


TRUNCATE field_revision_commerce_customer_address;
TRUNCATE field_revision_commerce_customer_billing;
TRUNCATE field_revision_commerce_customer_shipping;
TRUNCATE field_revision_commerce_line_items;
TRUNCATE field_revision_commerce_order_total;
TRUNCATE field_revision_commerce_price;
TRUNCATE commerce_product;
TRUNCATE commerce_product_revision;
TRUNCATE field_revision_commerce_product;
TRUNCATE field_revision_commerce_shipping_service;
TRUNCATE field_revision_commerce_total;
TRUNCATE field_revision_commerce_unit_price;
TRUNCATE field_revision_commerce_display_path;
TRUNCATE field_revision_field_supplier;

DELETE FROM field_data_field_mnogo_id WHERE entity_type = 'commerce_product';
DELETE FROM field_data_field_mnogo_id WHERE entity_type = 'commerce_order';

DELETE FROM node WHERE TYPE = 'product_display';
DELETE nr.* FROM node_revision nr LEFT JOIN node n ON n.nid = nr.nid WHERE n.nid IS NULL;


DELETE FROM field_data_commerce_stock WHERE entity_type = 'commerce_product';
DELETE FROM field_revision_commerce_stock WHERE entity_type = 'commerce_product';
DELETE FROM field_data_field_min_order_quantity WHERE entity_type = 'commerce_product';
DELETE FROM field_data_field_step_quantity WHERE entity_type = 'commerce_product';
DELETE FROM field_data_field_image_large WHERE entity_type = 'commerce_product';
DELETE FROM field_data_field_image_small WHERE entity_type = 'commerce_product';
DELETE FROM field_data_field_weight WHERE entity_type = 'commerce_product';

DELETE FROM field_revision_field_step_quantity WHERE entity_type = 'commerce_product';
DELETE FROM field_data_field_min_stock_alert_quantity WHERE entity_type = 'commerce_product';
DELETE FROM field_revision_field_min_stock_alert_quantity WHERE entity_type = 'commerce_product';
DELETE FROM field_revision_field_min_order_quantity WHERE entity_type = 'commerce_product';
DELETE FROM field_revision_field_image_large WHERE entity_type = 'commerce_product';
DELETE FROM field_revision_field_image_small WHERE entity_type = 'commerce_product';
DELETE FROM field_revision_field_weight WHERE entity_type = 'commerce_product';
DELETE FROM field_revision_field_mnogo_id WHERE entity_type = 'commerce_product';
DELETE FROM field_data_field_category WHERE entity_type = 'commerce_product';

DELETE FROM field_data_field_description_long WHERE entity_type = 'commerce_product';
DELETE FROM field_data_field_description_short WHERE entity_type = 'commerce_product';
DELETE FROM field_revision_field_description_short WHERE entity_type = 'commerce_product';
DELETE FROM field_revision_field_description_long WHERE entity_type = 'commerce_product';
DELETE FROM field_data_field_order_rules WHERE entity_type = 'commerce_product';
DELETE FROM field_revision_field_order_rules WHERE entity_type = 'commerce_product';
DELETE FROM field_revision_field_min_stock_alert_quantity WHERE entity_type = 'commerce_product';
DELETE FROM field_revision_field_min_order_quantity WHERE entity_type = 'commerce_product';
DELETE FROM field_revision_field_category WHERE entity_type = 'commerce_product';
DELETE FROM file_managed WHERE uri LIKE '%physical_products%';