Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Importing Orders into OSC


intelopment

Recommended Posts

Posted

I have a requirement to import customer orders from an external accouning software package (exported as a csv file) into my store.

 

As a first step I have tried to manually create an order by adding an order via admin in the mysql database. I have added a row to the 'orders' and 'orders_product' tables. I have exactly matched fields from a previous order shown in the database, placed via the storefront for a test customer. I have incremeted the orders_id field in the row I added in the 'orders' and 'orders_products' tables.

 

The phpMyAdmin screens show the order in these tables. But when I log into the test customer account in the store, this manually added order via the admin mysql interface, does not show up in the order history display.

 

So, the order has been manually added to the mysql database, but the storefront user account doesn't show it.

 

Is there an additional table in the database I also have to modify?

Posted

Did you also add the necessary information in the customer table and other tables. Without looking into it further, the list might be customer driving. i.e. list customers with orders, not list orders. Not sure though.

Posted

you need to modify a bunch of tables if you want to do it manually. You could check the catalog\checkout_process.php file and see the tables that have to be modified.

Posted
you need to modify a bunch of tables if you want to do it manually. You could check the catalog\checkout_process.php file and see the tables that have to be modified.

 

Thanks, looking through the checkout_process file helped me find the other tables I had to modify.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...