Skip to content

Order Grid not showing NEW orders after upgrade from 2.0 to 2.1 #6932

@shanevbg

Description

@shanevbg

Ever since I upgraded from Magento 2.0 to 2.1 (and now 2.1.1), I haven't been able to see NEW orders in the order grid (old ones show up just fine). I've tried disabling extensions, etc. I can get to the orders by either going to transactions and see them there, or the dashboard, but the order grid doesn't show any entries from after I updated to 2.1.

NEW orders also don't show up in the query
SELECT * FROM sales_order_grid AS main_table
order by entity_id desc

Environment

  1. Ubuntu 16.04.1
  2. Magento 2.1.1
  3. PHP 7.0.8
  4. MySql 5.7.15

Steps to reproduce

  1. Create a new order
  2. Go to dashboard, see order
  3. Go to Admin-Sales-orders no order
  4. If used a transaction, can find the transaction and order from transaction

Expected result

  1. Should see new orders in the order grid

Actual result

  1. No new orders show in the order grid after upgrading from 2.0 to 2.1, all old orders are still visible however

Question

Is there someway to run a script/job to update the order_grid, etc?

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions