How to Create a Where-to-Buy Page from Distributor Reports

This guide walks you through building a "where to buy" page using Storepoint. If you have distributor reports from UNFI, KeHE, or other distributors, you'll learn how to import them with automatic deduplication and product filtering. If you have a simpler retailer list from a CRM export, spreadsheet, or even a handwritten list, the same steps apply.

Whether you're a national CPG brand with thousands of retail doors across multiple distributors or a smaller brand with a CSV of 30 stockists, the setup is the same. Upload your data, map your columns, embed the product locator. Done.

Start Your Free Trial See Examples

Before You Start

You'll need a Storepoint account. If you don't have one yet, start a free trial and follow the Quick Start Guide.

Step 1: Import Your Retailer Data

Your distributor report or retailer spreadsheet is all you need. At minimum, Storepoint needs a name and address for each retail location:

In your Storepoint dashboard, create a Source for each data feed. Upload the file, map your columns once, and your retailers appear on the map. When you get fresh data, upload it to the same Source. Storepoint remembers your column mapping and handles deduplication, so you never wrangle spreadsheets.

Any CSV or spreadsheet with retailer names and addresses works: a distributor report from UNFI, a CRM export from HubSpot or Salesforce, a wholesale order list, or a spreadsheet you maintain by hand.

Importing Distributor Reports

CPG brands typically get retailer data from distributor sales reports. These come from platforms like UNFI Insights, KeHE CONNECT BI, DOT Foods, McLane Link, or regional and specialty distributors. The exports vary in format, but they all share the same core data: store names, addresses, and which products each retailer carries.

Distributor reports usually have one row per product per retail location:

That format imports directly. No pivot tables, no manual cleanup, no data transformation. Storepoint automatically deduplicates rows with the same store name and address into a single map pin, and combines all product values from matching rows. Whole Foods Market becomes one pin tagged with "Organic Hot Sauce" and "Habanero Reserve".

Common Distributor Sources

Here's where to pull your retailer data from the most common CPG distribution platforms:

UNFI — Export from UNFI Insights under Analytics > Year Over Year Sales. Set the period to the last 52 weeks and include both East and West distribution centers for full coverage. Export as CSV.

KeHE — Pull from KeHE CONNECT BI under Connect Data > Reporting. The Brand Item Location report or Full POD Vendor report both contain the store-level detail you need. Export as CSV.

DOT Foods — Request your retailer location report from your DOT sales representative or pull from their supplier portal. Export contains redistribution points and end-retailer data.

McLane — Export from McLane Link under delivery and order reporting. Store-level data is available by item and location.

DSD / Regional Distributors — Most regional and DSD distributors provide Excel or CSV reports with store names, addresses, and products shipped. The format varies, but the data maps the same way.

Broker Reports — If your broker compiles retail placement data across multiple distributors, that report works too. Create a Source for it and upload. Same process.

Step 2: Embed Your Product Locator

1. Go to Embed in your dashboard
2. Copy the embed code
3. Paste it into your "Where to Buy" page

Get Embed Code

Need help embedding? Shopify · WordPress · Squarespace · Wix · Webflow · All platforms

Your product locator is live. Shoppers search by zip code or city, find nearby retailers carrying your products, and get directions. Updates you make in your dashboard go live instantly. You only embed once.

Add Product Filtering

If you carry multiple SKUs and want shoppers to filter by product, flavor, or variety, add a "tags" column to your spreadsheet with the products each retailer carries:

Import or sync your sheet. The product names become filter options in the locator automatically. To organize them into a labeled dropdown, create a tag group in your dashboard with a label like "Products" or "Flavors".

Multiple Filters

All tags go in the same column. In the dashboard, you organize them into separate filter dropdowns using tag groups.

A common CPG setup combines a product filter with a retail channel filter:

Create two tag groups: "Products" (Organic Hot Sauce, Habanero Reserve, Smoky Chipotle) and "Channel" (Natural Grocery, Conventional Grocery, Online). Each becomes its own dropdown. Shoppers can combine them, like "Habanero Reserve" + "Natural Grocery".

Product-Specific Pages

Storepoint generates filtered embed codes that show only retailers carrying a specific product. On your Habanero Reserve product page, shoppers see only retailers that stock it. One account, many product-specific locator views.

You can also link to your "Where to Buy" page with a product pre-selected by adding ?tags=your-product to the URL. Useful for email campaigns, social posts, paid media, and in-store QR codes.

Optional: Add Purchase Links

Add a "Shop Now" button that sends shoppers to your product page on the retailer's website. Create a Button field in Custom Fields, then add the URL for each retailer. The button appears alongside Directions on each location card, and only shows where you've added a link. The URL column also appears in your import template and sync template for bulk updates.

What's Next?

• 📍 Custom map markers: Different icons for natural grocery vs conventional vs online, so shoppers spot the right retailer type at a glance
• ⭐ Priority sorting: Feature key retail partners at the top of results
• 🖼️ Retailer images: Add retailer logos or storefront photos to location cards

Common Questions

Do I need product filtering?

No. If you sell a single product or your full line is available at every retailer, the locator works without it. Shoppers search by location, find nearby retailers, and get directions.

My distributor report has thousands of rows. Is that a problem?

No. Storepoint handles large datasets. Upload your full report to a Source and deduplication takes care of the rest. Brands with distribution across thousands of retail doors use Storepoint without issues.

Can I show different retailers on different product pages?

Yes. Use filtered embed codes scoped to each product's tag. One account, many product-specific views.

My spreadsheet has extra columns like "Cases Shipped" or "Invoice Number". Is that a problem?

No. Storepoint ignores columns it doesn't recognize. Sales data, velocity metrics, case counts, and other distributor fields won't cause any issues.

Can I combine data from multiple distributors?

Yes. Create a separate Source for each distributor: one for UNFI, one for KeHE, one for your DSD routes. Upload each report as-is, no merging needed. When you get a fresh report from any distributor, drop it into the same Source and it updates only those locations automatically.

I don't have distributor reports. Can I still use this?

Yes. Any spreadsheet with retailer names and addresses works. Export from your CRM, copy from a wholesale order list, or build one by hand. The distributor-specific sections of this guide cover UNFI, KeHE, and similar platforms, but the core steps apply to any data source. For a simpler walkthrough, see the Create a Store Locator guide.

Can I use this on Shopify product pages?

Yes. Storepoint works on Shopify and every major platform. Add the full locator to a "Where to Buy" page, or use filtered embed codes on individual product pages.

Learn More

• Filters & Tags for product filters, tag groups, and filter logic
• Custom Fields for purchase buttons and other field options
• Google Sheets Sync for automatic retailer data updates
• Import from Spreadsheet for bulk uploading retailers
• Sources for managing multiple distributor feeds with saved column mappings
• Embed Code Options for pre-filtered product page embeds
• Dealer Locator with Territories for territory-based distribution networks