intelopment Posted March 10, 2006 Posted March 10, 2006 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?
Avec Posted March 11, 2006 Posted March 11, 2006 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.
Guest Posted March 11, 2006 Posted March 11, 2006 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.
intelopment Posted March 11, 2006 Author Posted March 11, 2006 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.