Data Views
Products
Data Octopus products view using IdoSell data: "finished" orders for store ID "1", sales, customers, costs and profit.
View overview – Products
This data view presents sales performance at the product level using IdoSell store-engine data. It covers transactions for store ID "1", focusing on orders with status "finished". The report aggregates all integrated sales channels to provide a full picture of purchasing activity.
- Standard transactions directly through the online store.
- Marketplace sales (Allegro, Empik, Amazon).
- Orders entered manually by store staff.
- POS transactions.
Sales-data visibility depends on IdoSell integration settings. Orders from external platforms (such as Allegro) appear only when processed by the store engine.
Data date range
The report covers the last 30 days, ending yesterday.
Example insights from the data view
- 1Analyse Net Revenue by product to identify bestsellers and their contribution to overall sales.
- 2Compare Orders with Clients to identify products repeatedly bought by the same customers, suggesting loyalty or subscription opportunities.
- 3Examine Avg Basket Position to understand which products initiate purchases and which are complementary additions.
- 4Compare Item Quantity with Gross/Net Revenue to identify the most effective products.
- 5Monitor Product Age in Days alongside sales to assess how time in the assortment affects popularity.
- 6Compare Gross/Net Revenue with Net Cost of Goods to identify the highest-margin products.
- 7Track Quantity All Stocks against sales to optimise inventory and avoid popular products running out.
- 8Analyse Profit Level 1 alongside orders and clients to identify products contributing most effectively to business profitability.
Product identifiers
| Field name | Description |
|---|---|
| id | Unique product variant identifier in the system. |
| item_group_id | Product group identifier, linking variants of the same product. |
| title | Full product name displayed in the store. |
| brand | Product brand name in the system. |
Product categorisation
| Field name | Description |
|---|---|
| category_lev_1 | Main category (first categorisation level). |
| category_lev_2 | Subcategory (second categorisation level). |
| category_lev_3 | Detailed category (third categorisation level). |
Sales data
| Field name | Description |
|---|---|
| orders | Total number of orders containing the product or products in this group. |
| clients | Number of unique customers who purchased the product or products in this group. |
| item_quantity | Total quantity of items sold for the product or group. |
| item_order_gross_value | Total gross sales value (including tax) for the product or group. |
| item_order_net_value | Total net sales value (excluding tax) for the product or group. |
Analytical data
| Field name | Description |
|---|---|
| avg_basket_position | Average position of the product or products in this group in shopping baskets. |
| net_cogs | Total net cost of goods sold (COGS) for the product or group. |
| ecom_profit_level_1 | Level 1 profit after product acquisition costs, aggregated for this product or group. |
Inventory management
| Field name | Description |
|---|---|
| product_quantity_all_stocks | Total available product quantity across all warehouses. |
| product_age_days | Product age in days: the number of days since it was introduced into the assortment. |
Related articles