I have an ambitious goal of merging about 1000 orders from a custom, shopping cart solution (not Magento) that we used before my company switched to Magento. This is for the sake of customer service reps who are having to bounce back and forth between two systems to find an order but it would also help with reporting. The plan was to create an additional column in Magento's order grid that represented the previous shopping cart's order number as Magento uses a different numbering system.

I see sales_flat_order and sales_flat_order_grid contain a large amount of order data. I attempted at first just to populate these two tables, create sequential entity_ids and increment_ids (order number) but my orders didn't show.

Question: What is the minimum number of tables that must be populated in order for Magento to show orders on the order grid? I may not necessarily have shipping information or customer information however I can populate those additional tables if necessary.

2 Answers 2


You should at least look at quote tables, which is related to quote items etc. Maybe better approach would be to use the API magento provides and place those orders? Mark them shipped where required. Use an offline payment method to be able to easily invoice them?

  • Interesting approach. Thank you for the suggestion. I will look into that tonight.
    – sparecycle
    Nov 11, 2014 at 21:09
  • I'm revisiting this for a different reason now but are you saying to load the data into quote tables and somehow process with the help of the API? If so do you have any documentation or links that might provide insight for that?
    – sparecycle
    Dec 10, 2014 at 22:12

Take a look at Clearing Magento after testing (sales related section).

It would be virtually impossible to recreate these orders from the db

A better approach would be

Please remember to disable transactional email

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.