Mapping wholesaler data to your catalog
Wholesale price lists are built for trade buyers: product codes, purchase prices, pack sizes, minimum order quantities. To sell those products in a store, the data has to be translated into what customers and store platforms expect. A data mapping tool does that translation, once per wholesaler, and repeats it automatically for every new price list.
What is specific about wholesale data
- Pack sizes. The price may be per box of 12, while you sell single units.
- Minimum order quantities, which affect which products are realistic to offer.
- Tiered prices, with different purchase prices depending on volume.
- Recommended retail prices set by brands, sometimes mandatory.
- Trade names and codes, which mean little to customers.
- Prices without VAT, often in a different currency.
Mapping step by step
- Fields: identify the code, name, purchase price, recommended price, quantity, brand, category, images and attributes in the wholesaler's file.
- Units: decide how pack prices convert into unit prices, and how stock in packs converts into units.
- Prices: choose which price column is your cost, and add currency and VAT handling.
- Categories: map the wholesaler's categories to your store structure.
- Products: link wholesaler codes to your catalog by barcode or part number.
- Test: process one file and check a sample by hand before going live.
Common mistakes
- Applying a markup to the pack price and selling a single unit at that price.
- Using the recommended retail price column as the cost.
- Mapping by product name, which breaks when the wholesaler edits a name.
- Forgetting to check new categories in later files.
Wholesaler data mapping in YfiFX
YfiFX lets you map any wholesaler price list, whether Excel, CSV, XML, YML, JSON or API, to the fields and categories of your Master price list. The mapping is saved per wholesaler and used on every import. Products are linked across wholesalers, and prices are calculated with your markups, exchange rates, recommended retail prices and supplier priority. The result is exported to your store or feed on a schedule.
Frequently Asked Questions
What is product data mapping?
It is the process of matching fields in a wholesaler's price list, such as their code, price and stock columns, to the fields of your own catalog, so every new file is read correctly.
Can wholesaler categories be mapped to my store categories?
Yes. Each wholesaler category is assigned to a category in your catalog once, and the mapping is applied on every import.
Can prices be calculated during mapping?
Yes. After import, prices are calculated from the wholesaler's cost with your markup rules, exchange rates and recommended retail prices.
Related Articles
Set it up once. YfiFX does the rest
14 Days Free Trial. Sign up and import your first price list today.