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]

CSV Column	Database Column
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