After going through a painful process I was able to upgrade my old 1.4 magento to brand new 1.7. Now I have this last glitch with upgrade which I am unable to resolve so far. The problem is if I browse sales_order table I am able to see all orders over there but not in magento admin. Only 178 most recent orders are showing up while actual figure is 3500+. Has anyone faced this problem and was able to solve it?
What i have found is the 172 orders it is showing are from sales_flat_orders....I am really confused since 1.4 had same structure with few orders stored in sales_flat_orders and others in sales_orders but they are shown up in Admin without any problem.
What I have learned so far that Magento no more store orders in sales_order but sales_flat_orders. During the upgrade the table data is not copied to newly created sales_flat_order.
Interestingly, the orders showing up in backend are the one’s loading from sales_flat_orders. Now I am really confuse what went wrong. Can anybody help?