On this page
CSV: How to setup an integration via Hosted .CSV
Connect a Hosted CSV integration in Flashpricer: host a CSV of your SKUs and costs at a public URL, add it under Settings → Integrations → Connect Integration → Hosted CSV, and it auto-syncs cost, min, max, MAP and more every 30 minutes.
Host a CSV of your SKUs and costs at a public URL, connect it in Flashpricer, and your pricing data stays in sync automatically — Flashpricer re-reads the file every 30 minutes, no manual uploads.
A Hosted CSV integration reads a CSV file you keep online, matches each row to a listing by SKU, and updates the fields you include. It's the simplest way to feed Flashpricer costs (and min, max, MAP and more) from your own system.
Step 1 — Prepare your CSV
Your file needs a header row with a SKU column plus at least one value column. One SKU per row, comma-separated:
SKU,COST,MIN,MAX,MAP SKU-1,12.50,15.99,24.99,19.99 SKU-2,8.00,10.99,18.50,(blank) SKU-3,5.25,7.49,12.00,
- ·Host it at a public URL. The file must be reachable without a login — anywhere that serves the raw CSV works (your server, a storage bucket, a published Google Sheet…).
- ·SKU is the only required column. Add at least one of
COST,MIN,MAX,MAP,SALES CHANNEL ID,STRATEGY IDorFBM SHIPPING COST. Headers match by name, case-insensitive.
For the full list of columns you can include (and exactly what each one updates), see Integrations in Flashpricer. Prefer a spreadsheet? Use the Google Sheets guide; on an FTP server? See CSV via FTP.
Step 2 — Connect it in Flashpricer
Go to Settings → Integrations (the gear icon → Integrations).
Click Connect Integration and choose Hosted CSV from the menu.
Give the integration a Name, paste your CSV Url, then click Create CSV integration.
Then fill in the form:
The CSV file must be hosted on a public URL and contain the following column headers: SKU + one or all of the following COST, MIN, MAX, MAP, SALES CHANNEL ID, STRATEGY ID, CURRENCY, FBM SHIPPING COST.
Flashpricer validates the URL as you type and previews the headers it recognized, so you'll know immediately if the file is set up correctly. It also runs a first sync as soon as you create the integration.
How the sync works
- ·Automatic every 30 minutes. Flashpricer re-reads the file on a schedule — update the file and the changes are picked up on the next cycle.
- ·Costs you set by hand are safe. A cost you set manually (or via a bulk upload) takes precedence — the integration only replaces a cost that itself came from an integration. (Min, max and other fields are last-writer-wins, from any source.)
- ·A blank cell clears that field. If a column is present but a cell is empty, the existing value is removed. A blank or
0cost is treated as "no cost" and also clears the calculated min/max.
Troubleshooting
- ·URL unreachable or errored — the file isn't public, or the host returned an error. Confirm the link opens the raw CSV in a private browser window.
- ·Missing headers — the file must have a header row with SKU plus at least one recognized column. A page that returns HTML (not CSV) fails this check.
- ·Too few rows — the file needs a header row and at least one data row.
- ·Stuck in error > 5 days — an integration left in an error state for over 5 days is disabled automatically; fix the file and reconnect.
Frequently asked
Where can I host the file?
http(s) URL — your own web server, a cloud storage bucket, or a Google Sheet published as CSV. It just can't require a login.How often does it refresh?
Will it overwrite a cost I set by hand?
Which columns can I include?
Host your CSV, then connect it on Settings → Integrations. Questions? Email success@flashpricer.com.