Purpose
These reports provide insights into current inventory levels, purchasing activity, and consignment split arrangements. They are useful for bulk edits, inventory audits, pricing reviews, and tracking vendor-specific inventory data.
To learn more about creating customer reports, please view our Custom Reports Overview guide.
Report Setup
Inventory with Barcodes (Bulk Inventory Edit Report)
Description:
This report is ideal for bulk inventory updates using barcode scanning. It lists all items currently in stock for a specific consignor, making it easy to locate and edit inventory in bulk via barcode workflows.
Base:
Inventory
Fields to Include:
Field Name | Description |
SKU | Unique item identifier |
Item Name | Name or description of the item |
On Hand QTY | Quantity currently in stock |
Barcode | Barcode associated with the item |
Filters:
Filter | Use Case |
On Hand QTY is greater than 0 | View only currently stocked items |
Consignor ID is [specific ID] | Narrow report to a specific consignor |
Inventory Split by Consignor Report
Description:
This report shows what consignment split is assigned to each item currently in inventory. It’s useful for auditing split settings by consignor or ensuring consistency in payout terms.
Base:
Inventory
Fields to Include:
Field Name | Description |
SKU | Unique item identifier |
Item Name | Name or description of the item |
Store Split % | Percentage of sale retained by the store |
Filters:
Filter | Use Case |
On Hand QTY is greater than 0 | View only items currently in inventory |
Consignor ID is [specific ID] | Isolate inventory by consignor |
Buy Count
Description:
This report tracks inventory acquisition over time, helping you analyze vendor performance, restocking patterns, and pricing strategies. It’s essential for reviewing buying volume and evaluating inventory sourcing.
Base:
Inventory
Fields to Include:
Field Name | Description |
Last Buy Date | Date the item was most recently purchased |
Item Name | Name or description of the item |
SKU | Unique item identifier |
Buy Count | Total number of times the item has been bought |
On Hand QTY | Quantity currently in stock |
Cost | Per-unit cost |
Total Cost | Total cost based on quantity |
Retail | Per-unit retail price |
Total Retail | Total retail value |
Brand | Item brand |
Color | Item color |
Size | Item size |
Filters:
Filter | Use Case |
Buy Date is after [start date] | Start of date range for review |
Buy Date is before [end date] | End of date range |
Tips
-
Use the barcode report when importing updates through a scanner or inventory app.
-
Audit splits regularly to ensure consignor agreements are reflected correctly.
-
Monitor Buy Count reports monthly to spot top-selling vendors or underperforming stock.