Integration Specifications
This document will help you understand the Whole Foods Market Portal data source and provide technical specifications for Daasity's integration and data model.
Whole Foods Market Portal data provides store-level product sales, distribution, and velocity metrics across your portfolio of products and categories. This integration enables you to gain insights into sales performance, distribution reach, and product velocity at both total Whole Foods and regional levels. Available for all Enterprise merchants.
Refresh Cadence
Data from the Whole Foods Market Portal is updated weekly every Thursday morning (EST) with the prior week's data through Saturday. Once the integration is set up, the data is automatically refreshed on this schedule, ensuring you always have access to the most current metrics.
Where to Find This Data
Reports
Omnichannel Dashboard
Whole Foods Market Dashboard
Explores
Whole Foods Market Explore
Unified Retail Schema (URS) Explore
Data Model
ERD
(Click here to view the ERD for the Daasity Whole Foods Market integration illustrating the different tables and keys to join across tables.)
Source Table
Whole Foods Market
CSV File: Whole Foods Market
Update Method: UPSERT
Table Name: [retail.wfm]
Brand
brand
Family
family
Category
category
Subcategory
subcategory
Class
class
Scan Code
scan_code
ASIN
asin
Item Description
item_description
Item Size
item_size
Item UOM
item_uom
Operational Area
operational_area
Store Name
store
Store Number
store_number
Store Status
store_status
Channel Type
channel_type
Week Desc
week_desc
Net Sales
net_sales
Net Sales LY
net_sales_ly
% Net Sales YOY
pct_net_sales_yoy
Unit Sales
unit_sales
Unit Sales LY
unit_sales_ly
% Unit Sales YOY
pct_unit_sales_yoy
Avg Net Retail Price
avg_net_retail_price
Gross Sales
gross_sales
Return Sales
return_sales
Gross Units
gross_units
Return Units
return_units
MD5(ASIN + ':' + Store Number + ':' + Channel Type + ':' + Week Desc)
__sync_key
Last updated