Stock/Inventory
Venditan Commerce contains several detailed reports covering your stock and inventory including stock valuation, status and location reporting.
Inventory Valuation Report
A non-configurable report summarising the value of your held stock, broken down by Location and Store.
Metrics
The Inventory Valuation Report provides the following information:
Location
The physical Location of the product, e.g. Warehouse name.
Store
The specific Store where the stock is held.
Unique SKUs
The number of unique stock-keeping units available.
Stock Level
The quantity of stock on hand.
Cost Value
The total cost value of stock on hand, based on your Cost Prices.
About the Inventory Valuation Report
The Inventory Valuation Report utilises your products’ Cost Prices to provide a basic valuation of the inventory that you hold across the business.
This report is an essential tool for assessing stock value across different Locations and Stores. It enables you to make informed decisions regarding inventory management and financial planning.
Inventory Valuation Breakdown Report
This report summarises non-sold stock values for a specific Location and Store.
Configuration
To generate an Inventory Valuation Breakdown Report, you can configure the following options:
Apply Filters
Apply Filters to narrow down the evaluated products. Choose from:
Manufacturer: Filter by the Manufacturer of the products.
Season: Choose a specific Season to analyse.
Product Code: Filter by specific Product Codes.
Supplier: Select the supplier associated with the stock.
Sales Audience: Specify the Sales Audience for the products.
Departments: Filter by Department categories.
Product Categories: Choose specific Product Categories.
Product Tags: Use Product Tags assigned to the inventory for additional filtering.
Metrics
The report provides the following information:
Brand
The Brand associated with the stock.
Unique SKUs Count
The number of unique stock-keeping units.
Stock Level
The quantity of non-sold stock on hand.
Cost Value
The total cost value of the non-sold stock.
Retail Value
The total retail value of the non-sold stock.
Margin (%)
The percentage margin is calculated on the retail value compared to the cost value.
About the Inventory Valuation Breakdown Report
The Inventory Valuation Breakdown Report provides insight into non-sold stock values specific to your location and store.
By offering detailed breakdowns across various dimensions, this report aids in identifying trends and managing inventory more effectively.
Inventory Status Report
This non-configurable report displays information regarding the "Qualifies for Web" status of non-qualifying products and explains why a product does not qualify.
Metrics
The report shows the following information:
Product ID
The unique identifier for each product.
Product Code
The specific code associated with the product.
Qualifies for Web
Indicates whether the product qualifies for web publication, including explaining why the product is disqualified.
Is Purchaseable
Indicates if the product is available for purchase, including an explanation of why the product isn't purchaseable.
Stock Level (Primary Location)
The quantity of stock available in the primary Location.
Stock Level (Other Locations)
The quantity of stock available elsewhere.
About the Inventory Status Report
The Inventory Status Report helps you clearly understand which products are ineligible for publishing on your website, and the reasons why.
For instance, it identifies products that may be missing images or other necessary attributes, enabling you to take corrective actions so they can be published.
Stock Returned Damage Report
This report lists products that have been returned with a Return Reason listed as ‘Damaged.’
Configuration
You only need to choose a Date Range to generate a Stock Returned Damaged Report.
Metrics
The report shows the following information:
Product Code
The unique code associated with each returned product.
Product Title
The title of the product that has been returned.
Brand
The Brand of the returned product.
No. Returned
The quantity of the product returned as damaged.
Total (exc. Tax)
The total value of the returned products, excluding Tax.
About the Stock Returned Damaged Report
The Stock Returned Damaged Report provides a straightforward snapshot of returned products because the customer listed them as Damaged.
You can then review the items and write them off or book them back for allocation.
Mark Down Report
The Mark Down Report lists products on sale for a given day and Sales Channel.
Configuration
To generate a Mark Down Report, you can configure the following options:
Metrics
The report shows the following information:
Product Code
The unique identifier for each product.
Product Title
The title of the product.
Brand
The Brand associated with the product.
Variation
Details regarding any product variations (e.g., Size, Colour)
Stock
The quantity of the product available.
Current Price (inc. Tax)
The current selling price of the product, including Tax.
Sale Price (inc. Tax)
The discounted price of the product, including Tax.
About the Mark Down Report
The Mark Down Report offers a snapshot of items currently on sale.
This information can help you catch pricing discrepancies, implement further markdowns, or generally review and manage your ongoing sales pricing.
What's in the Bin Report
This report provides a breakdown of stock held within a specific Bin.
Configuration
To generate a What’s in the Bin Report, you only need to select the Bin you want to review.
Metrics
The report shows the following information:
Bin
The specific Bin in which the stock is located.
Store
The Store within which the Bin is contained.
Product
The Title and Description of the product.
Master Code
The unique identifier for the Master product.
SKU
The stock-keeping unit for each product in the Bin.
Barcode
The barcode assigned to the product.
Colour
The colour variant of the product.
Size
The size variant of the product.
Brand
The Brand associated with the product.
Product Category
The category to which the product belongs.
Department
The department associated with the product.
Available Stock
The quantity of stock available in the Bin.
Allocated Stock
The quantity of stock allocated for Orders or tasks.
Allocated to Picking Stock
The quantity of stock set aside for picking processes.
Available Cost
The cost value of the available stock.
Allocated Cost
The cost value of the allocated stock.
Allocated to Picking Cost
The cost value of the stock allocated for Picking.
About the What’s in the Bin Report
The What’s in the Bin Report provides a clear overview of what is expected to be stored in a particular storage Bin.
You can use this report to inspect the Bin to ensure that the records match visually.
Stock Take Report
The Stock Take Report is a robust and detailed report that provides a breakdown of current stock levels across all Locations in your business at the time of running the report.
Configuration
To generate a Stock Take Report, you can apply the following Filters to narrow your inventory down to the subset that you would like to evaluate:
Sales Channel
Select the specific Sales Channel where the products are sold, e.g. Websites, Amazon, or a physical store.
Brand
Choose the Brand associated with the products to view stock levels for specific brands.
Department
Filter by Department.
Product Category
Specify the category to which the products belong.
Season
Select the season relevant to the products.
Sales Audience
Filter by the target audience for the products.
Condition
Choose the condition of the products.
Product Status
Specify the status of the products.
Size
Filter by the size options available for the products.
Location
Select a specific Location to stock take.
Store
Select a specfiic Store to stock take.
Bin
Select a specific Bin to stock take.
SKU
Filter by stock-keeping unit.
Supplier
Choose the Supplier from whom the products were sourced.
Product Tag
Stock take tagged products.
Metrics
To identify individual products, the report can generate any of the following information based on your configuration:
Product Code
The unique identifier for each product.
Master Code
The unique identifier for the master product.
Product Title
The name or description of the product.
Barcode
The Barcode assigned to the product.
HMRC Import Code
The code used for customs importation.
HMRC Export Code
The code used for customs exportation.
Location
The specific Location where the stock is held.
Store
The Store where the stock is held.
Bin
The specific Bin in which the stock is located.
ISR Category
The ISR (Inventory Stock Report) category assigned to the product.
Product Category
The category to which the product belongs.
Department
The department associated with the product.
To analyse stock levels, the report can generate any of the following information based on your configuration:
Available Stock
The quantity of stock currently available.
Allocated Stock
The quantity of stock that is allocated for orders or tasks.
Counted Stock
The quantity of stock counted during the stock take (this column will be empty initially).
Available Cost
The cost value of the available stock.
Allocated Cost
The cost value of the allocated stock.
About the Stock Take Report
The Stock Take Report offers a comprehensive view of your current stock levels across all locations that you manage.
Detailed filtering and configuration help you to hone in on particular product types or individual locations and monitor stock availability/allocation.
Goods In By Manufacturer/Supplier Report
The Goods In By Manufacturer/Supplier Report provides a breakdown of new stock received into the business.
Configuration
To generate a Goods In By Manufacturer/Supplier Report, you can configure the following options:
Metrics
The report shows the following key information:
Brand
The Brand associated with the stock being reported.
Quantity
The total quantity of stock booked from the selected Manufacturer or Supplier, for that Brand.
Breakdown Report
In addition to the main report, an accompanying Breakdown Report provides further information by breaking the report down into individual products. It includes:
Product
The Product Title and Code.
Quantity
The quantity of each specific product booked in.
Brand
The Brand the product belongs to.
Description
Short and Long Product Descriptions.
Composition
The materials or ingredients used in the product.
Care Instructions
Guidelines on how to care for or maintain the product.
Sizes
The size options available for the product.
Colours
The colour options available for the product.
About the Goods In By Manufacturer/Supplier Report
This report lets you keep tabs on recently received stock and filter that down by individual Suppliers or Manufacturers.
It is helpful for those with regular deliveries of new stock to keep tabs on the overall inventory flow into the business.
Purchases Delivered
The Purchases Delivered Report provides an overview of Purchase Orders, detailing the quantities and percentages of items received compared to the total ordered.
Configuration
To generate a Purchases Delivered Report, you specify the date range for the purchase orders you want to include in the report.
Metrics
The report shows the following key information:
Purchase Order Number
The unique identifier for each Purchase Order.
Supplier
The name of the Supplier associated with the Purchase Order.
Date Created
The date when the Purchase Order was created.
GRNs
The Goods Receipt Notes related to the Purchase Order.
Items Ordered
The total quantity of items ordered in the Purchase Order.
Cost
The total cost of the items ordered.
Items Delivered
The quantity of items delivered against the Purchase Order.
% Delivered
The percentage of items delivered relative to the items ordered.
Cost Delivered
The total cost of the items that have been delivered.
% Cost Delivered
The percentage of the cost delivered relative to the total cost of the order.
Purchased Delivered (Grouped) Report
You can also generate a list of Purchase Orders and the quantity and percentage of items received against the total ordered, grouped by Department or Product Category.
About the Purchases Delivered Report
This report offers valuable insights into your purchase orders by highlighting suppliers' performance in delivering ordered items. You can identify discrepancies and optimise future orders by tracking the quantity and cost delivered against what was ordered.
Bestsellers Report
The Bestsellers Report provides an overview of the top-selling products within a specified Date Range.
Configuration
To generate a Bestsellers Report you only need to select a Date Range.
Metrics
The report shows the following key information:
Product
The Product Title and Product Code.
Colour
The Colour options available for the product.
Quantity Sold
The total number of units sold during the specified date range.
Total Sales
The total revenue generated from sales of the product.
Profit
The total profit made from the sales of the product.
Margin
The profit margin percentage for the product.
Last Purchase Date
The most recent date when the product was purchased.
About the Bestsellers Report
This report reviews sales data, including profit and margin, to identify your most successful products.
This can help you to strategise on restocking, marketing, and website optimisation to maximise sales opportunities.
Outstanding Stock Adjustments Report
The Outstanding Stock Adjustments Report provides an overview of stock adjustments that require attention due to unresolved stock movements related to in-store transactions.
Metrics
The report shows the following key information:
Product SKU
The specific code associated with each product.
Product Title
The name or description of the product.
Total Adjustments
The total number of outstanding stock adjustments that must be addressed.
Variations
Any product variations, e.g. Size, Style, Colour.
About the Outstanding Stock Adjustments Report
This report highlights stock discrepancies that Venditan Commerce could not automatically reconcile, such as in-store sales not reflected in the system.
This is crucial for maintaining accurate inventory levels and ensuring stock records align with sales.
You can resolve stock discrepancies directly from the report.
Last updated
Was this helpful?