Drupal e-Commerce

I see there are an uninstall hooks for each module in v 4.x installation apis - but reinstalling 3.x is still tricky.

I had major problems trying out different versions of e-Commerce with Userpoints payment integration and eventually abandoned it for Ubercart.

Here is the SQL that worked for me in the end - I did not even discover the shadow product nodes until I set up Ubercart - they did not appear in the Content listing with or without e-Commerce installed.


TRUNCATE TABLE cache;
TRUNCATE TABLE cache_content;
TRUNCATE TABLE cache_filter;
TRUNCATE TABLE cache_menu;
TRUNCATE TABLE cache_page;
TRUNCATE TABLE cache_views;

DROP TABLE IF EXISTS ec_address;
DROP TABLE IF EXISTS ec_anon;
DROP TABLE IF EXISTS ec_audit;
DROP TABLE IF EXISTS ec_authorize_net;
DROP TABLE IF EXISTS ec_cart;
DROP TABLE IF EXISTS ec_credit_card;
DROP TABLE IF EXISTS ec_customer;
DROP TABLE IF EXISTS ec_invoice;
DROP TABLE IF EXISTS ec_mail;
DROP TABLE IF EXISTS ec_product;
DROP TABLE IF EXISTS ec_product_features;
DROP TABLE IF EXISTS ec_product_ptypes;
DROP TABLE IF EXISTS ec_product_tangible;
DROP TABLE IF EXISTS ec_receipt;
DROP TABLE IF EXISTS ec_receipt_allocation;
DROP TABLE IF EXISTS ec_receipt_paypal;
DROP TABLE IF EXISTS ec_receipt_types;
DROP TABLE IF EXISTS ec_renewal;
DROP TABLE IF EXISTS ec_shipping_product;
DROP TABLE IF EXISTS ec_shipping_product_attribute;
DROP TABLE IF EXISTS ec_shipping_shipfrom;
DROP TABLE IF EXISTS ec_shipping_transaction;
DROP TABLE IF EXISTS ec_sp_attribute;
DROP TABLE IF EXISTS ec_sp_bpattribute;
DROP TABLE IF EXISTS ec_sp_pattribute;
DROP TABLE IF EXISTS ec_sp_pproduct;
DROP TABLE IF EXISTS ec_sp_variation;
DROP TABLE IF EXISTS ec_tax;
DROP TABLE IF EXISTS ec_tmp;
DROP TABLE IF EXISTS ec_transaction;
DROP TABLE IF EXISTS ec_transaction_address;
DROP TABLE IF EXISTS ec_transaction_misc;
DROP TABLE IF EXISTS ec_transaction_product;


I am indebted to mikesmullin who posted some basic code at http://drupal.org/node/119432 , but without "IF EXISTS" it caused an SQL error (I'm not sure if this is a complete list of all possible ec_ tables) - and I have added code to clean the products out of the node table (if desired).

I am not sure if this is the best place for this page, so feel free to reposition it.