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:

Metric	Summary
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:

1

Choose a Store/Location

Select a specific Store or Location to evaluate.

2

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:

Metric	Summary
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.

The report can be run for one or multiple websites.

Metrics

The report shows the following information:

Metric	Summary
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:

Metrics	Summary
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:

1

Choose a Day

Select the specific day you want to analyse.

2

Apply Filters

Apply filters to narrow the report based on either Store/Location or Sales Channel.

Metrics

The report shows the following information:

Metric	Summary
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:

Metrics	Summary
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:

Filter	Summary
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:

Metric	Summary
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:

Metric	Summary
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:

1

Choose a Manufacturer/Supplier

Select whether to view the report based on a specific Manufacturer or Supplier, or all.

2

Choose a Date Range

To narrow down the data, apply a filter based on the date the Goods Receipt Note (GRN) was created.

Metrics

The report shows the following key information:

Metric	Summary
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:

Metric	Summary
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:

Metric	Summary
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:

Metric	Summary
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:

Metric	Summary
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.