FTP: How to setup an integration via FTP

A CSV via FTP integration connects to your server, lets you browse to the CSV file, matches each row to a listing by SKU, and updates the fields you include. Same data model as any Flashpricer integration — just delivered over FTP.

Step 1 — Prepare your CSV

Put a CSV on your server with a header row: a SKU column plus at least one value column (cost, min, max, MAP, sales channel ID, strategy ID, or FBM shipping cost). One SKU per row.

Step 2 — Connect Integration → CSV via FTP

Go to Settings → Integrations, click Connect Integration, and choose CSV via FTP. Give the integration a Name, then enter your connection under FTP Configuration:

• ·Protocol — pick FTP or SFTP. The Port defaults to 21 for FTP and 22 for SFTP; change it if your server uses a different one.
• ·Host — enter just the hostname, e.g. ftp.mystore.com (no http://, no trailing /).
• ·Anonymous login — turn it on if your server needs no credentials; otherwise leave it off and enter your Username and Password.

Click Continue — Flashpricer connects and shows a Connected confirmation.

Step 3 — Pick your file

Once connected, browse your server and click the CSV you want to sync. Use the folders to navigate and the back arrow to go up a level:

Flashpricer validates the file you pick and flags it right away if the headers aren't recognized.

Step 4 — Create the integration

With the connection and file set, click Create CSV integration. Flashpricer runs a first sync immediately, then re-reads the file on schedule.

How the sync works

• ·Automatic every 30 minutes. Flashpricer re-reads the file on a schedule — update it on your server and the changes are picked up on the next cycle. It also syncs once right after you connect it.
• ·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 0 cost is treated as "no cost" and also clears the calculated min/max.

Troubleshooting

• ·Can't connect — "An error occurred while connecting to the FTP server." Check the host (hostname only, no http://), the port, the protocol (FTP vs SFTP), and your username/password.
• ·Missing headers — the file needs a header row with SKU plus at least one recognized column, or it's rejected ("Missing SKU column").
• ·Invalid file — if the selected file isn't a valid CSV, you'll see "The selected file is not valid, please select another one." Pick a different file.
• ·Stuck in error > 5 days — an integration left in an error state for over 5 days is disabled automatically; fix it and reconnect.

Frequently asked