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. |
| TARGET REGION | Selector | Targets a region (US / CA / MX) for the row. |
| 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, STRATEGY ID or FBM SHIPPING COST.
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.