Check “OUT OF STOCK” cancellations against inventory

Procedure to Verify Canceled Orders Against Inventory

1. Download the Canceled Order Report.

2. Freeze the top row.

   Apply Custom Sort:

   • Check My Data Has Headers
   • Sort by Order Date → Largest to Smallest

3. Go to Products with Inventory and request an Export.

   In the Product Export spreadsheet, create a Pivot Table:

   • Select data range from SKU to WAREHOUSE_INVENTORY.

     In Pivot Table Fields:

     • Add BARCODE_TYPE under Rows.
     • Add WAREHOUSE_INVENTORY under Values (set to Sum of WAREHOUSE_INVENTORY).
4. Copy the Pivot Table.
5. Paste the Pivot Table as values into cell N1 of the Canceled Order Report.
6. In N2, enter formula: =VLOOKUP(G2,N:O,2,FALSE)
7. Copy N2 and paste down to match all rows in the left column.

8. Copy Column M and paste back as values in the same column.

   Set Filters:

   • In the Cancellation Reason column, exclude:
     • BUYER ASKED TO CANCEL
     • Buyer Canceled
     • CUSTOMER REQUESTED SELLER TO CANCEL
   • In Column M, filter values >0 (exclude N/A).