Inventory Data Pipeline
The dataset of the item_inventory table provides information about the availability of items in the inventory, specifying the total quantity of available items, active reservations, unlimited inventory option, as well as SKU and inventory IDs. This table also records updates with timestamps and control IDs.
This section includes the following information:
- Inventory data characteristics
- Table: item_inventory
- Analyses with item_inventory
- Correlations with other data
Data characteristics
| Characteristic | Description |
|---|---|
| Data source | Obtained from information in the logistics module. |
| Availability | VTEX Admin. |
| History | We have made historical data available since June 2022. For customers who already use the VTEX platform, data is retained for two years starting in 2024. |
| Minimum update interval | One hour. |
Table: item_inventory
The table fields are described below:
| Column Name | Column Type | Description |
|---|---|---|
| parent_account_name | character varying(200) | Name of the main account associated with the fundamental entity to which the inventory belongs. |
| main_account | character varying(200) | Name of the Merchant's main account in License Manager. |
| account_name | character varying(200) | Name of the account to whom the inventory belongs. |
| quantity | bigint | The total quantity of items available in stock. |
| reserved_quantity | bigint | Number of active reservations for an item. |
| is_unlimited_quantity | boolean | Indicates whether the item can have infinite stock (True/False). |
| batch_id | character(13) | Identifies the last ingestion batch that updated this row. |
| warehouse_id | character varying(400) | ID of the warehouse where the stock is located. |
| item_id | character varying(300) | Identifies the item whose stock is being quantified. |
| last_update | timestamp without time zone | The last time this particular item stock was updated. |
| warehouse_status | varchar(8) | Display the current status of the warehouse where this inventory is stored. Accepted values are: active, inactive, or deleted. |
Analyses with inventory
Some of the analyses that can be run using the inventory table are mentioned below:
- Inventory level analysis: Assess whether the inventory meets demand and identify items at risk of running out of stock.
- Inventory reservation trends: Analyze the number of items that have been reserved over time to identify patterns and adjust inventory management strategies.
- Inventory distribution analysis by account: Optimize inventory management across multiple accounts and understand how inventory is distributed.
Correlations with other data
Inventory data correlates with order and product sets, and provides a more comprehensive analysis for purchases, sales, and marketing. Some examples are:
- Interaction with order data: Joint analysis with order data offers insights about how efficiently is customer demand being met and helps forecast restocking needs.
- Relationship with SKUs: Integration with SKU data helps manage inventory based on product popularity and availability.
- Purchase and supplier data: Coordination with purchase data allows you to maintain an ideal inventory balance, which avoids overstocking or shortages.
- Sales and marketing analysis: Understanding inventory directly impacts marketing and sales strategies, which allows aligning promotions and campaigns with product availability.