Sales Analysis of Processed Orders
Home || Linnworks || Sales Analysis of Processed Orders
Description
RIS-SC-1010 Sales Analysis of Processed Orders
This query retrieves data related to stock items including their category, SKU, current and minimum levels, units sold, orders, total sales, and bin rack number. It calculates the minimum level as half of the total units sold in the last 6 months. The data is filtered based on certain conditions such as order processing date, composite parent row ID, property name, and company name exclusion.
How to generate the report: a step-by-step guide
- 1. Select the Sales Analysis of Processed Orders Report in the Query type drop-down menu.
- 2. Click the Generate Report button.
- 3. Select the Time Zone and click the Download (CSV file) button when downloading the report.
Reported Values
The report returns the following values:
| Column Name | Description |
|---|---|
| RN | Row number within each category ordered by total units sold in descending order. |
| pCategory | Category of the stock item. |
| SKU | Stock Keeping Unit (SKU) of the item. |
| Current Level | Current stock level of the item. |
| Minimum Level | Minimum stock level calculated as half of the total units sold in the last 6 months. |
| Units Sold in last 6 months | Total units sold in the last 6 months. |
| Orders in last 6 months | Count of orders containing the item in the last 6 months. |
| Total Sales in 6 months | Total sales revenue generated by the item in the last 6 months. |
| BinRackNumber | Bin rack number associated with the item. |
Summary
This query aggregates information about stock items including their category, SKU, current and minimum levels, units sold, orders, total sales, and bin rack number. It calculates the minimum level as half of the total units sold in the last 6 months. The data is filtered based on specific conditions such as the processing date of orders, absence of composite parent row ID, property name (‘pCategory’), and exclusion of certain company names (e.g., ‘Amazon Fulfillment Center’). The result set is grouped by SKU, current level, category, and bin rack number.
