Store Order Report

Store Order Report is designed to provide a detailed summary of items ordered, grouped by transaction and item. This report will help you gain deeper visibility into store order activity across locations.

Reports → Inventory Reports → Store Order

The Store Order Report allows you to view and analyze store order transactions by source and destination locations. It consolidates orders by transaction number and organizes the data by item, making it easier to track product movement and manage inventory planning across venues and locations.

Users can toggle the "Consolidate by Transaction" checkbox to switch between item-level and transaction-level views.

When Consolidate by Transaction is Unchecked (Default View)

This is the item-level view, showing each product ordered with full item and order details. This view hides transaction-level fields for clarity.

Fields in the report:

• UPC: Unique Product Code.
• Item ID: Internal identifier for the item.
• Item Name: Name of the ordered item.
• Product ID: Identifier for the specific product type.
• Product Name: Descriptive product name.
• Department: Department the item belongs to.
• Category: High-level grouping of products.
• Sub-Category: More specific product classification.
• Brand: Brand associated with the item.
• Season: Season label for the product.
• Team: Team the product is related to.
• Size: Size of the item.
• Color: Color of the item.
• Style: Style of the product.
• Quantity Ordered: Number of units ordered.
• Unit Retail: Retail price of a single item.
• Extended Retail: Total retail amount (Unit Retail × Quantity Ordered).
• Unit Cost: Cost price for a single unit.
• Extended Cost: Displays the cost of the items sold.

When Consolidate by Transaction is Checked

This view shows a summary grouped by transaction, hiding item-level details but providing transaction-level insights.

Fields in the report:

• Transaction #: Unique identifier for the store order transaction.
• Source Location: The location sending the items.
• Destination Location: The location receiving the items.
• Created Date: Date the store order was created.
• Quantity Ordered: Total quantity of items ordered in the transaction.
• Extended Retail: Total retail value for the transaction.
• Extended Cost: Total cost value for the transaction.
• Status: Status of the overall transaction.

Available Filters:

You can apply filters to narrow down the report results:

• Date Range
• Item ID
• Item Name
• Venue
• Location (Store & Warehouse)
• Store Order #
• Status (Under Generation, Sent, Cancelled, Transfer Initiated, Closed)
• Team

The Store Order Report can be exported in CSV and PDF allowing easy sharing, printing, or analysis.

Articles in this section

• Item Import Field Descriptions
• Overview
• Merchant Onboarding
• Navigation Bar
• Reports
• Items
• Settings
• Dashboard Overview
• Company
• Register

See more