I have a CSV file of each of my 150 brands (““vendors””") with new update prices. About 3000 products need to be updated with cost and sell prices.
The common identifier to products in the list and in Shopify is ONLY the barcode or EAN or SKU (as I set the SKU and Barcode as the same)
I cannot seem to import in shopify a CSV file that has not “Handle” and/or “Title” filled in.
It seems ridiculously easy to do (on all other mayor platforms and minor platforms too, i could do this literally in seconds) but in Shopify I have to put in 80 hours of manual work? Can’t be, right?
Any sollution? Work-around or ANOTHER plugin…?
But remember please that in my file the product Handle and Product titel might be very different than in my shopify store.
Hey @tim_1 and @nowvitamins
Thank you for mentioning and suggesting our app.
You sure can updating product data only by the SKU as per the above-linked tutorial.
For example, you can import a file with just 3 columns Variant SKU, Variant Cost and Variant Price.
The app will find product variants by their SKU and update only the cost and price attributes for them.
Just make sure that your SKUs are unique for each variant in the store.
If you have any questions or concerns alogn the way, let us know!
Hey! I actually built a free tool specifically for this — it’s called MarginSync.
You upload your supplier’s CSV, it auto-detects your SKU and cost columns, matches them to your Shopify products, shows you a full price preview, then syncs with one click. You can also roll back if anything looks wrong.
It’s completely free right now (I’m looking for beta testers). Here’s the form if you want to try it: MarginSync Beta Tester Application
I know this thread is a bit old, but I’m curious if anyone has tried other bulk-edit apps for updating costs and prices. Have there been any new tools released since the last discussion that might offer similar or better functionality than Matrixify or Ablestar? Always interested in hearing about new solutions that can save us all time!
Adding one angle that hasn’t come up in the thread: with 3,000 products across 150 brands, the harder problem isn’t matching by SKU — it’s verifying afterwards that all 3,000 actually took. A supplier list that partially applies is worse than one that fails outright, because you don’t find out until something sells at the wrong margin.
Full disclosure, I’m the developer of a tool called Pricely, built around exactly that. You upload a file with just SKU (or barcode) plus cost and price — no Handle or Title needed, since it matches on the identifier and writes only the fields you map. Before anything is applied you get a row-by-row preview: current price → new price, which rows are already correct and will be skipped, and which SKUs weren’t found in your catalog. After it runs, every row carries a status you can export, so a partial run is visible instead of silent.
Cost goes into Shopify’s cost-per-item field, so your margin reports pick it up.
