Not really a new modification, however I was trying to import data from ZenCart to OpenCart, I found Franz-Peter's Oscommerce Data Importer module and made one slight edit to get it to import a ZenCart database.
Step 1. Download Franz-Peters contrib here:
http://www.opencart.com/index.php?route ... ion_id=276
Step 2. Follow install instructions provided regarding config file changes
Step 3. Make the following code change:
Replace: import_osc_orders.php (around line 237)
Code: Select all
$query_orders = "SELECT orders.orders_id, orders.customers_id, orders.customers_name, orders.customers_telephone, orders.customers_email_address, orders.delivery_name, orders.delivery_street_address, orders.delivery_suburb, orders.delivery_city, orders.delivery_postcode, orders.delivery_country, orders.billing_name, orders.billing_company, orders.billing_street_address, orders.billing_suburb, orders.billing_city, orders.billing_postcode, orders.billing_country, orders.payment_method, orders.cc_type, orders.cc_owner, orders.cc_number, orders.cc_expires, orders.last_modified, orders.date_purchased, orders.orders_status, orders.currency, orders.currency_value, orders_total.value, customers.customers_firstname, customers.customers_lastname FROM orders INNER JOIN (customers) ON (customers.customers_id = orders.customers_id) LEFT JOIN orders_total ON orders.orders_id = orders_total.orders_id AND orders_total.class = 'ot_total'" ;
Code: Select all
$query_orders = "SELECT * FROM " . $source_db_table_prefix . "orders INNER JOIN (" . $source_db_table_prefix . "customers) ON (" . $source_db_table_prefix . "customers.customers_id = " . $source_db_table_prefix . "orders.customers_id) LEFT JOIN " . $source_db_table_prefix . "orders_total ON " . $source_db_table_prefix . "orders.orders_id = " . $source_db_table_prefix . "orders_total.orders_id AND " . $source_db_table_prefix . "orders_total.class = 'ot_total'" ;
