On this page
Integrations in Flashpricer
How integrations work in Flashpricer: sync cost, min/max, MAP, strategy and more from a hosted CSV, FTP file or Google Sheet — auto-refreshed every 30 minutes. Learn the supported fields, the replace behavior, and why an integration cost never overrides a manual or uploaded cost.
Integrations pull your pricing data — costs, min/max, strategies and more — from an external source and keep it in sync automatically. Set up a file once, and Flashpricer refreshes from it every 30 minutes.
An integration reads a file you host — a hosted CSV, an FTP file, or a published Google Sheet — matches each row to a listing by SKU, and updates the fields you provide. It's the hands-off way to keep costs and price guardrails current.
What you can sync
Each row is keyed by SKU. Some columns identify or target the row; others set a value on the matching item:
| Column | Role | What it does |
|---|---|---|
| SKU | Required | Matches the row to a listing. |
| SALES CHANNEL ID | Selector | Targets a specific sales channel for the row. |
| REGION | Selector | Targets an Amazon marketplace for the row — US, CA, MX, BR, UK, DE, FR, IT, ES, NL, BE, PL or SE. TARGET REGION also accepted. |
| COST | Value | Sets the item cost — must be greater than 0 (see precedence below). |
| MIN | Value | Minimum price. MIN PRICE also accepted. |
| MAX | Value | Maximum price. MAX PRICE also accepted. |
| MAP | Value | Minimum Advertised Price. |
| STRATEGY ID | Value | Assigns a repricing strategy. |
| FBM SHIPPING COST | Value | Merchant shipping cost for FBM listings. |
| REPRICING ENABLED | Value | Turns repricing on/off — yes or no. |
| B2B MIN PRICE | Value | Amazon Business (B2B) minimum price. |
| B2B MAX PRICE | Value | Amazon Business (B2B) maximum price. |
Headers are matched by name, case-insensitive and in any order. A CURRENCY column is accepted as a header but isn't currently applied to items, so leave pricing in your account's currency.
Required: every row needs a SKU, plus at least one recognized column — one of COST, MIN, MAX, MAP, SALES CHANNEL ID, REGION, STRATEGY ID, REPRICING ENABLED, FBM SHIPPING COST, B2B MIN PRICE or B2B MAX PRICE.
Where the data comes from
Pick whichever source is easiest to keep updated — they all sync the same way:
There are also partner integrations — SkuVault, Finale Inventory, Linnworks and SellerCloud — under Connect Integration → Partner Integrations.
How updates are applied
All three sources use the same replace model, on the same 30-minute schedule.
- ·New values replace old ones. Whatever's in the file becomes the value on the matching item.
- ·A blank cell clears that field. If a column is present but a cell is empty, the existing value is removed. (Leaving a column out entirely leaves that field untouched.)
- ·Cost of 0 or blank = "no cost". It clears the cost and its calculated min/max bounds — so keep a real cost in every row you want priced.
- ·Repricing enabled must be
yesorno. A blank or invalid value skips that whole row.
Which value wins: cost vs everything else
Cost behaves differently from the other fields — this is the one rule worth remembering:
Cost
Min, Max, MAP, Strategy…
In short: a manual or uploaded cost is safe from integrations. Your min/max (and other fields), on the other hand, are last-writer-wins — so pick one source of truth for those to avoid surprises.
Best practices
- ·Keep the source current. The file is read every 30 minutes, so it's your live source — update it there.
- ·Validate before you import. Because blanks remove values, double-check the file so you don't accidentally wipe a cost or min/max.
- ·One source of truth per field. Especially for min/max, decide whether the integration, uploads, or the UI owns it — mixing them means the last change wins.
Frequently asked
How often does an integration refresh?
Does an integration cost overwrite a cost I set by hand?
What are the required columns?
What happens if I leave a cell blank?
0 cost is treated as "no cost" and also clears the calculated min/max.Choose a source — Hosted CSV, FTP or Google Sheets — and connect it on Settings → Integrations. Questions? Email success@flashpricer.com.