Report - Vendor/Supplier items short shipped on backorder

Shopify Discussion

Topic summary

Request to generate a report that flags products short shipped and on backorder for a specific vendor, including key dates and quantities. “Backorder” = items ordered but not yet received; “short shipped” = received less than ordered.

Proposed report scope and filters:

  • Vendor/Supplier selection.
  • Date range for purchase orders (e.g., last month).

Suggested columns:

  • PO Number, PO Date.
  • Item SKU/ID, Item Name.
  • Quantity Ordered, Quantity Received, Quantity Backordered (Ordered – Received).
  • Date Received (for partial receipts).
  • Optional: Expected Delivery Date, Reason for Backorder.

How to run and use it:

  • Use an inventory management/reporting module; find purchase/backorder/inventory reports.
  • Apply vendor and date filters; include the listed columns; run the report.
  • Export to CSV/Excel for sorting and analysis.
  • Use insights to spot vendor backorder trends, prioritize reorders, and follow up with suppliers.

Outcome/status:

  • Guidance provides a report template and workflow, but is tool-agnostic and not Shopify-specific.
  • No confirmation of a native Shopify report that exactly matches these needs; resolution remains open.
Summarized with AI on December 29. AI used: gpt-5.
1

Report - Vendor/Supplier items short shipped on backorder. Can a report be created that will identify products on backorder for a specific vendor/supplier?

Date of purchase order

Date received

Products short shipped

Products on backorder

Thank you

2

Hi @okboot ,
This is Theodore from PageFly - Shopify Page Builder App.

Report: Vendor/Supplier Short Shipped Items on Backorder

This report helps you track backordered products from a specific vendor, including short shipments.

Report Criteria:

  • Vendor/Supplier: Select the specific vendor to track.
  • Date Range: Define a date range (e.g., last month’s purchase orders).

Report Columns:

  • PO Number
  • PO Date
  • Item SKU/ID
  • Item Name
  • Quantity Ordered
  • Quantity Received
  • Quantity Backordered (Quantity Ordered - Quantity Received)
  • Date Received (if applicable) (for partially received backorders)
  • Optional: Expected Delivery Date, Reason for Backorder

Running the Report:

  1. Access your inventory management system’s reporting module.
  2. Locate a report related to purchases, backorders, or inventory.
  3. Apply the chosen vendor/supplier and date range filters.
  4. Select the desired columns to include.
  5. Run the report.

Exporting and Analyzing:

  • Export the report (CSV, Excel) for further analysis.
  • Sort and filter data (e.g., by backordered quantity, PO date).
  • Use the report to:
    • Identify backorder trends from specific vendors.
    • Prioritize reordering critical items.
    • Communicate with suppliers regarding delays.

Best regards,
Theodore | PageFly