Import UNFI to StoreLocators

What This Export Does#

This process generates a comprehensive CSV file containing all store locations where your products are sold. This process will:

Map all retailer locations to your store locator
Verify store addresses and contact information
Enrich provided information with canonical store names, address information
Ensure accurate geographic placement on your map
Configure store details and product availability

Step-by-Step Instructions#

Step 1: Access UNFI Insights#

After logging into myUNFI, locate the "Frequently Used Applications" section. Click on "UNFI insights" to access the supplier data platform.

Access UNFI Insights from the Frequently Used Applications section. This platform provides dashboards detailing sales, velocity, inventory, and distribution data needed for your store locator integration.

Step 2: Navigate to Analytics#

In the left sidebar navigation, click on "Analytics" to access the reporting dashboards.

Click Analytics in the left sidebar to access all available reporting dashboards and data exports.

Step 3: Select Year Over Year Sales Report#

Under the "Business Health" section, click on "Year Over Year Sales". This report provides comprehensive store-level sales data.

Select Year Over Year Sales under Business Health. This report type provides the complete retailer location dataset including store names and distribution details that will populate your store locator map.

Step 4: Configure Report Parameters & Export#

Configure the following parameters to ensure all retailer locations are captured:

Period Start Date: Select "is in the last 52 weeks" for comprehensive coverage
Date Granularity: Set to "Weekly"
Only Show Full Periods?: Select "Yes" for complete data
Product: Leave as "is any value" for all products
Chain: Leave as "is any value" for all retailers
Distribution Center: Important: Include both "EAST" and "WEST" for nationwide coverage
Distribution Center Region: Leave as "is any value"
Group by Product or UPC: Select "Product"

After configuring all parameters, click the three-dot menu (⋮) in the top right corner, then select "Download".

Configure your report filters to capture all retailer locations. Click the three-dot menu and select Download to export your data.

Step 5: Export as CSV#

In the download dialog:

Set Format to "CSV"
Click the "Download" button

Important: CSV format is required to properly process and map your retailer locations. Other formats cannot be imported into our system.

Select CSV as the export format. This is the required file type that our StoreLocators team needs to import your retailer data and populate your store locator map.

Next Steps After Export#

Save the CSV file with a clear filename (e.g., "YourBrand_UNFI_Retailers_Sept2025.csv")
Upload directly to StoreLocators:
- Open your StoreLocators Shopify app
- Navigate to the "Uploads tab"
- Upload your CSV file directly through the interface
Processing happens on our end: Once uploaded, our team will automatically process the data and update your store locator

Why This Data Matters#

This UNFI export provides the foundation for your store locator by providing:

Complete retailer coverage: Every store where your products are distributed
Accurate location data: Store addresses, contact information, and regional details
Distribution insights: Which products are available at which locations
Geographic mapping: Ensures customers find the nearest stores carrying your products

Important Requirements#

CSV format only: Excel, PDF, or other formats are unsupported
All locations included: Include both EAST and WEST distribution centers
Current data: Use the last 52 weeks for up-to-date store information
Complete parameters: Leave chain and product filters as "is any value" for complete coverage
Upload directly: Use the Uploads tab in your StoreLocators app for immediate processing

Troubleshooting#

If the export fails or seems incomplete:

Verify you included both EAST and WEST distribution centers
Check your internet connection during the export process
Ensure you have permissions to access all retailer data
Try shorter date ranges if the file is too large

If upload to StoreLocators fails:

Check file size limits in the Uploads tab
Verify the CSV format is correct (comma delimited)
Ensure your Shopify app permissions are up to date
Contact our support team if technical issues persist

For questions about specific parameters for this report or store locator integration, contact support: support@storelocators.com. For UNFI Insights technical issues, reach out to UNFI customer support.