Inventory - Custom Reports

Have more questions? Submit a request

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.

 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful