The Crisp harmonized data feed allows you to access unified point of sales and inventory data in an export feed, so you can easily analyze data consolidated from multiple retailers in third-party tools or pipe it to a cloud storage provider. Currently, the Crisp harmonized feed includes three export tables with data from the following sources:
- Retailer Inventory DC table - Dollar General, Kroger, Target, and Walmart
- Retailer Inventory Store table - Dollar General, Kroger, Home Depot, Target, and Walmart
- Retailer Sales table- Dollar General, Home Depot, Kroger, Target, Walmart, Wegmans, and Whole Foods.
Note: Kroger inventory data has some differences from other data in this feed. To learn more, see the Kroger inventory data section of this article.
For more on the data in these tables, see the Crisp data catalog.
To access Crisp harmonized data as a data source for a destination connector:
Note: You must have access to a data portal and have set up a connector for the data source before the data will flow to the Crisp harmonized feed. For instructions on setting up a new connector, see Getting your data into Crisp and select the article for the relevant source.
-
From the main menu on the left side of the screen, select Connectors.
-
Select an existing destination connector (e.g., Excel) or create a new one.
For instructions on setting up a new connector, see Exporting your data and select the article for the relevant retailer.
-
From the Connector source data section, select the Change selection button.
🗒 Note: If this is for a new connector, this button is called Select.The Select source data screen appears with a list of your available data sources.
-
From the Connectors section, select Crisp.
-
Select the tables you want to include in your feed, then deselect any data columns (e.g., distribution_center_address) that you want to exclude from your feed.
-
If you want to see documentation that describes the columns in a table, select the book icon to the right of the table.
-
Select the Accept button.
Your destination connector is now configured to include Crisp harmonized data.
Crisp harmonized model documentation
To access documentation on the data included in this feed:
-
Log in to Crisp, then open the data catalog by clicking here.
-
Select Crisp.
A list of the available tables appears. -
You can select a table name (e.g., Retailer Inventory Dc) to see the data columns it includes and descriptions and examples of the data.
Kroger inventory data
Kroger inventory works a bit differently than the other sources in this connector because Kroger does not report inventory when there is no inventory in stock for a product. Since other sources in this feed do report zero sales when there is no stock, Crisp has taken some steps to normalize the Kroger inventory data.
We add zero inventory entries for Kroger when we don't receive data for a product. We also cross-check the store authorization detail report to see if the product is authorized for the store and therefore likely truly out of stock. Because we use store authorization as an indicator of whether or not to add zero inventory, store authorization status has a greater impact on your inventory data for Kroger. For example, you may see zero inventory when a product is new and authorized, but not yet selling on the shelf or a product is discontinued at a store but still authorized in the system (this is expected and will remedy itself once the product authorization is accurate in Kroger's system).
If you see zero inventory for a product, but you see sales for a product that is not new or discontinued, this may indicate that there's an issue with the product in Kroger's inventory system. Check with your buyer to see if they can investigate and resolve the issue.