SupplierPilot

Your suppliers send spreadsheets. Your store needs prices and stock.

SupplierPilot reads the price and stock files from every supplier you buy from, works out which one to sell each product from, and updates Shopify on a schedule. You stop copying numbers by hand, and nothing goes live below your margin.

Install on ShopifyFree while in early access

This morning, two files arrived:

SupplierPilot matched them to your products and prepared this:

Different column names, comma decimals, a prefix on every SKU. You tell SupplierPilot once which column is which; after that every new file is read the same way.

How it works

  1. Add each supplier and their file. Upload a CSV or Excel file, paste a link SupplierPilot downloads from, connect an FTP/SFTP folder, or give the supplier a private address to email it to.
  2. Check the columns once. SupplierPilot guesses the SKU, cost and stock columns. Fix anything it got wrong, choose your markup, and pick the Shopify location to update.
  3. Approve the first sync. You see every change before it happens. After that it runs daily or hourly, and emails you a short summary.

Which supplier wins

When more than one supplier carries a product, SupplierPilot sells from the one that has it in stock. If several do, the cheapest wins, counting delivery and import costs you set per supplier. If they cost the same, your preferred supplier wins.

The price is your cost plus markup (a percentage or a fixed amount, with different markups per brand, product type or tag if you like), rounded to .99, .95 or whole numbers. It never goes below a brand’s minimum advertised price.

When a file is wrong

Suppliers send broken files. A truncated export can look like your whole range sold out overnight.

  • If a sync would change far more than usual, it pauses and waits for you.
  • A price that would fall under your minimum margin is held back, not published.
  • Any sync can be undone. Orders taken since then are kept.

Questions

My SKUs don’t match the supplier’s.
You can match by barcode instead, strip a prefix like ACM-, or link individual products by hand. SupplierPilot lists every supplier row it couldn’t match.
What file formats work?
CSV, TXT, TSV, XLSX and XLS, including files with several sheets or headers that don’t start on the first row.
How much does it cost?
Nothing during early access. When paid plans start, stores that joined early keep a lower price.
One of my files is a mess.
Send it to [email protected] and I’ll set it up with you.

Who makes this

I’m Giorgi, an independent developer. I built SupplierPilot after watching a store owner spend every morning pasting three wholesalers’ spreadsheets into Shopify. If something doesn’t work for your files, write to me and you’ll get an answer from me, not a ticket system.

Install on Shopify[email protected]