Orders disappeared

RWD theme: Making search bar permanent
retrive quote cart after reorder and delete product

I have upgraded my magento to 1.7 but when I go to Sales –> Orders, it shows blank, and my lifetime sales and so forth is displayed as 0.

Now iv’e checked the sales_flat_order table, and it is empty. However, The table Sales_Order isn’t and has the whole 31827 orders in there. I assume this is the old table used in

So, I am wondering is it possible to take across order history or not ? and if so how can I ensure that it is kept in upgrade?

Related Posts

  • Losing orders from magento on old structure (0)
    I have been raking my hair out going through a magento upgrade: now I have upgraded from to (incrementally taking it upto 1.9). BUT!!!!!!!! all of the history is not showing up, looks like magento does not migrate sales order info over to new structure tables. Why […]
  • After upgrading POS module, only incognito window catches the right appearance (1)
    I have upgraded Point of Sales module. If I enter admin panel in incognito window, the new table and buttons of POS are aligned well, otherwise they are misplaced and product images are not displaying in its list. I emptied the cache but did not help.
  • Creating invoice backend works but gives blank screen Magento 1.7 (0)
    Every time I create an Invoice from Sales Order it gives me Blank screen (see attached) even though it's blank screen the invoice was created but not visible. What is the solution for this?
  • Magento 1.7 Sales Invoice Generated and Sent automatically (0)
    Is there a possible way to make Sales invoice being sent to the customer instantly the moment I click "INVOICE" button? No more preview, just send right away. But checks if shipment order has been created first. Is it possible to do it? How?
  • Lifetime sales display for all order status in magento 1.9.2 (0)
    I want to display lifetime sales for all order status like pending, processing etc etc in Magento 1.9.2. I have followed this one but its not working http://stackoverflow.com/questions/15567716/how-to-display-pending-orders-in-magento-dashboard-graph So I just wanted to change […]
  • How to get quotes converted in order where order status != pending (0)
    I need to modify the cron cleanExpiredQuotes and delete quotes only if the quote has been converted in processing, complete, closed or canceled and if the lifetime is expired. I overrides the function cleanExpiredquotes in Mage/Sales/Model/Observer and tried to join the table […]
  • How to echo customer Lifetime Sales on admin Order View page (1)
    I'm looking to display the customer Lifetime Sales value (£) within the admin on admin Order View page. I've managed to pull in the customer total order count with the code below, and basically would like to do the same with the lifetime value getOrder()->getCustomerId(); $_orders […]
  • What types of processes/modules could interfere with the Sales_Flat_Order_Status_History table being correctly updated? (0)
    This database table is essentially a log of all Order Status changes. My company's order status's are changing and updating correctly. However, our database table is not reflecting those changes correctly - namely the 'Complete' status. We had purchased the Follow Up Email module […]
  • magento2 cron schedule not running, cannot understand why (0)
    Crontab * * * * * php -c /opt/alt/php56/etc <magento2_path>/bin/magento cron:run | grep -v "Ran jobs by schedule" >> <magento2_path>/var/log/magento.cron.log * * * * * php -c /opt/alt/php56/etc <magento2_path>/update/cron.php >> […]
  • No customers displayed after Migrate to 2.0 (2)
    I migrated the Magento to Magento 2.0. No errors encountered while doing the migration using data migration tool. After migration when I hit the customers It returns 0 records. But when I check the customer_entity table it has all customer records. I noticed that […]
RWD theme: Making search bar permanent
retrive quote cart after reorder and delete product

2 Comments on this article

Add a comment

To create code blocks or other preformatted text, indent by four spaces:

    This will be displayed in a monospaced font. The first four 
    spaces will be stripped off, but all other whitespace
    will be preserved.
    Markdown is turned off in code blocks:
     [This is not a link](http://example.com)

To create not a block, but an inline code span, use backticks:

Here is some inline `code`.

For more help see http://daringfireball.net/projects/markdown/syntax