How do I stop copying supplier price sheets into every channel by hand?

What is a supplier price list?

It is the file a supplier gives you with what each item costs you and, often, what they have in stock. It might be a spreadsheet by email, a PDF, a CSV on a web link, or an FTP folder (a shared file drop). Each supplier formats theirs differently: their part numbers, their column names, their units, their idea of a case versus a single item.

Your job each time one arrives: find what changed, work out new selling prices, and update every place you sell. Do that by hand across three channels and a dozen suppliers and it eats days.

What supplier price list software does

Whatever the brand, the work is the same six steps:

1. Collect the file: from email, a link, FTP or an API.
2. Read it: find the right columns, whatever they are called.
3. Match each row to your own SKU. This is the hard part. See my SKU management guide.
4. Apply your rules: markup, rounding, minimum margin, channel fees.
5. Update costs, prices and stock on each channel.
6. Report and flag anything odd: a price that doubled, a product that vanished, a row that did not match.

Different tools cover different steps. Few cover all six, and the messy first three are where most ready-made tools stop.

Options and what they cost (as of November 2026)

Option	What it is	Cost	Fits
Matrixify	A Shopify app for bulk import and export, that can read files from web links, Google Sheets, Google Drive, Dropbox or FTP/SFTP and run on a schedule	Basic $20 per 30 days, Big $50, Enterprise $200; there is also a free demo plan with small limits	Shopify-only sellers with clean, consistent supplier files
Stock Sync (listed on the Shopify App Store as SyncX: Stock Sync)	A Shopify app that syncs stock and prices from Google Sheets, FTP/SFTP, Google Drive, Dropbox or an API	The listing shows a free plan and a free trial; check it for paid plans	Shopify stores with feed-style supplier data
Syncee	A marketplace that connects stores to dropship suppliers (companies that ship orders for you) and keeps their product data in sync	Free plan; paid plans, billed monthly, at $39.99 a month (Basic, 100 products), $59.99 (Pro, 250 products) and $99.99 (Business, 10,000 products); annual billing is listed separately	Dropshippers using suppliers already on its network
A sheet with a script	Google Sheets plus Apps Script, which can run on a timer	Free, plus setup time	A few suppliers, tidy files, someone who can maintain it
Custom tool	Built around your suppliers, your rules and your channels	One-time build, then you own it	Many formats, many channels, special pricing rules

Check each vendor's pricing page before buying, since plans and limits change. Also confirm which of your channels the tool can write to. Most ready-made tools are strongest on Shopify and weaker on Amazon or Etsy.

Where ready-made tools fall short

• Messy files. A PDF, or a sheet where the header is on row 7 and one supplier uses merged cells.
• Different units. Cost per case, sold per piece. Someone has to say how many pieces are in a case.
• Complex pricing rules. Markup that depends on category, minimum advertised price, or different prices per channel.
• Many channels. Updating Shopify is easy. Updating Amazon, Etsy and Walmart in the same pass is not.
• Safety checks. A tool that blindly pushes a bad price live can sell stock at a loss in minutes.

How to set up an automated flow, step by step

1. List your suppliers and note, for each, the file format, how often it changes and how you get it.
2. Build the mapping table: supplier part number to your SKU, plus the pack size. Give every variant its own SKU, because Shopify's help page says each product and variant needs a unique one, and Etsy lets you set separate SKUs, prices and quantities for up to 400 option combinations on one listing.
3. Write your pricing rules in plain words. For example: cost plus 40 percent, round to .99, never below 20 percent margin.
4. Automate the easiest supplier first and watch it for two cycles.
5. Add guardrails. Hold any change over, say, 25 percent for approval. Hold any product that disappears from the file instead of setting stock to zero or deleting it.
6. Push to channels in one run so prices stay in step.
7. Send a change report to you after every run. If it is boring, it is working.

The Shopify side of bulk price work is explained in Shopify bulk price update and the stock side in stock sync for Shopify.

A worked example (made-up numbers)

A brand buys from 6 suppliers and sells 2,500 products across Shopify and Amazon. Each supplier updates monthly, and each update takes about 3 hours to read, match and re-key. That is 18 hours a month. At a made-up $25 an hour for staff time, that is $450 a month, plus the cost of mistakes. If an automated flow cuts the human part to a 15-minute review per supplier, it takes about 1.5 hours a month. The saving, about $410 a month, is the figure to compare against any tool fee or build cost. Your numbers will differ, so run your own.

Where AI helps, and where it should not

Reading a messy file and guessing the column meanings is a good job for AI, as I describe in using AI to read supplier price lists and stock files. But a human should approve large changes, and fixed rules, not a guess, should set the final price. If you are taking in prices by hand because a person is keying them, also look at data entry outsourcing before you pay for more hours.

How I'd approach this

Count your suppliers and file formats first. If you have one or two with clean files and sell only on Shopify, use a ready-made app and stop there. If you have many formats, several channels or pricing rules that depend on the product, a ready-made tool will keep failing at the edges. That is the case a small custom tool fits: it reads each supplier's file the way they send it, maps it to your SKUs, applies your rules, holds suspicious changes for your approval, and updates every channel. It is the lead thing I build for multichannel sellers, and you own it. For the bigger picture see business process automation.