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 ColumnDatabase 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

Last updated