The Orders with Cost Details report surfaces information found in the Orders report and the cost for each item sold.
This report is useful for:
Viewing the top-selling staff members.
Viewing sales of specific product variants as well as the line cost(s).
Filtering the Product Type by "Penalty Fees" to view charges from no-shows and late cancellations.
The same order can be populated in the report more than once.
For example, the initial purchase will show up in its own row. If there are any returns for that order, the return(s) will also populate their own row(s).
Pulling up the Report
Navigate to Reports from the left panel > Inventory > Orders with Cost Details > View.
Specify the time frame from the date picker.
The populated data depends on the Transaction Date for a specified time frame, not the Order Date.
Apply any additional filters.
If you select multiple options within a filter type, it will act as an OR statement.
For example, if you select Product Type > Clothing and Accessories > Apply Filters, the report will populate clothing or accessory orders.
If you select multiple options within a filter type and another, new filter type, it will act as an AND statement.
For example, if you select Product Type > Clothing and Accessories, then select Fulfillment Location > Santa Monica > Apply Filters, the report will populate clothing or accessory orders at Santa Monica.
Click Generate Report and, if necessary, Export the report.
Understanding the Report
The Orders with Cost Details report includes:
Order Number: Auto-generated from the system.
Order Status: Latest status for the order (completed, refunded, partially refunded).
Order Date: Date of checkout.
Order Time: Time the order was placed.
Order Time Zone: Based on the local time zone of the purchase location.
Currency
Order Device: Device type in which the purchase was made.
mobile = mobile browser
desktop = desktop browser
unknown = mobile app
tablet = tablet browser
[blank] = orders processed through the Admin platform
Processed by System?:
True: All automatic charges (recurring memberships, no-show penalty fee, late cancel penalty fee) or a "bill on start" membership.
False: All other sales made by employees in the POS or by customers from the website/app.
First-time membership payment will render FALSE, and all subsequent payments will be TRUE.
Customer ID: Customer's ID generated by the system.
Customer Email: Customer's email.
Customer Name: Customer's name.
For walk-in sales through the walk-in feature, columns 8-10 will be left blank.
Company Name: Pulled from the customer's profile if available.
Broker ID: ID of the person who processed the transaction.
If this information is different than the Customer ID, the broker is an employee.
All employees have two IDs: one for the employee account and one for their customer account. The ID displayed will always be pulled from their Customer ID.
If the order was processed by the system (column 7), the Broker ID will always display the customer's information.
Broker Email: Email of the person who processed the transaction.
Broker Name: Name of the person who processed the transaction.
Product: Name of the product at the time of purchase
This data will never change. If you rename a product and generate an updated report, the data will still reflect the name of the product at the time of purchase.
Product ID: ID of sold product (Parent ID)
Variant ID: ID of the product variant (Child ID)
This data will never change and is one number higher than the Product ID.
Product Barcode
If a product's barcode changes and you generate an updated report, the data will still reflect the barcode of the product at the time of purchase.
Product SKU
This field will update to reflect any SKU changes.
Product Color
This field is optional and will update to reflect any changes.
Product Size
This field is optional and will update to reflect any changes.
Product Type: Classification of product.
Product Type cannot be changed once a product has been uploaded and is linked to the tax rate.
Vendor: Brand of product.
This field is optional and will update to reflect any changes.
Line Status: Displays if a transaction is complete and which row is the original purchase or return data.
Transaction Date: Date payment/refund was processed.
Line Quantity: Displays the quantity of the specific product (variant).
Line Cost: The unit cost of the product x line quantity.
For example, if you sold two leggings with a unit cost of $50, you'll see $100 (2 x $50).
Line Subtotal: Amount paid without tax and including any discounts.
Line Tax: Tied to Product Type.
Line Total: Line Subtotal + Line Tax.
Purchase Location: In-Store (any sales processed through the POS) or E-commerce (any sales via your studio's website or app).
Fulfillment Location
Fulfillment Region: Dependent on Fulfillment Location.