Prices Data Pipeline
The price dataset contains historical price information for each SKU in a merchant's store, enabling analysis of markup values and monthly price trends.
The data available in price history is only the data from the
price_table_maintable.
This article includes the following information:
- Data characteristics
- Table: pricing_latest
- Table: pricing_historical
- Analyses with price data
- Correlations with other data
Data characteristics
| Feature | Description |
|---|---|
| Data source | Prices module. |
| Availability | VTEX Admin and Pricing APIs. Keep in mind that the data available through the API may not be structured exactly the same way as it is in the Data Pipeline dataset. |
| History | Data history starts in August 2023. For clients already using the VTEX platform, data is retained for two years from 2024. |
| Minimum update interval | One hour. |
Table: pricing_latest
The pricing_latest table contains current price data for the store's products. The table includes the following fields:
| Column name | Column type | Column description |
|---|---|---|
| account_name | character varying(255) | Name of the account associated with the item. |
| last_date | date | Date and time of the last price change. |
| sku_id | character varying(255) | SKU identifier. |
| batch_id | character varying(255) | Identifier used when data is loaded into the table for quality control of data ingestion. |
| listPrice | double precision | SKU list price. |
| costPrice | double precision | SKU cost price. |
| markup | double precision | SKU markup. |
| basePrice | double precision | SKU base price. |
| fixedPrices | super | Fixed price. |
Table: pricing_historical
The pricing_historical table provides a historical record of your store's prices. The table fields are described below:
| Column name | Column type | Column description |
|---|---|---|
| account_name | character varying(255) | Name of the account associated with the item. |
| date | date | Date and time of the last price change. |
| sku_id | character varying(255) | SKU identifier. |
| author_id | character varying(255) | Identifier of the user who made the price change. |
| batch_id | character varying(255) | Identifier used when data is loaded into the table for quality control of data ingestion. |
| id | character varying(255) | Price change ID. |
| listPrice | double precision | SKU list price. |
| costPrice | double precision | SKU cost price. |
| markup | double precision | SKU markup. |
| basePrice | double precision | SKU base price. |
| fixedPrices | super | Fixed price. |
Analyses with price data
Price data can be used in the following analyses:
- Current SKU price: Assess the current price for a particular SKU or for a product range.
- SKU price history: Explore the price history for a particular SKU or for a product range.
- SKU price per account: For stores with multiple VTEX accounts, this data helps to compare prices across different stores.
Correlations with other data
The price dataset has correlations with the following sets of the VTEX data ecosystem:
- Interaction with order data: Combining order data provides insights into sales trends related to a product price, allowing price elasticity analysis.
- Relationship with inventory: Integrating with inventory data enables you to assess the total value of your assets accurately.
- Impact on conversion rates: By examining navigation and conversion funnel data, you can understand the influence of price on conversion rates.