How to Import Products to Shopify from a Supplier CSV or Excel File
How to import products to Shopify from your supplier's CSV or Excel file, with variants, photos and stock, and how to bulk update prices and stock when the supplier sends a new price list.
Try Csvio free on your own fileChapters
- 0:00A supplier's file in your store
- 0:14Upload your supplier's file
- 0:24Choose what the import does
- 0:36Check the AI mapping
- 1:12Defaults and preview
- 1:29Import and read the report
- 2:03Update prices and stock from a new file
- 2:49Find every import later
Transcript
A supplier's file in your store
These four products came from one supplier spreadsheet. Each color and size is a variant, with its own stock. They're drafts, hidden until I publish. Let me show you how. I'm on csvio's Import page.
Upload your supplier's file
I drag in the supplier's file, just as they sent it. It uploads, and then csvio reads every row.
Choose what the import does
Create adds new products. Bulk edit changes ones I have. These are new, so I click Continue. The AI matches the columns.
Check the AI mapping
Here's what it matched. Item Desc is the title, RRP is the price, Trade is the cost, SOH is the stock, EAN, the barcode, and Img, the photo. Colour is option one, and size, option two. Next, the categories. For the socks, the best guess is Socks. That's right, so I click Keep. And I open the three it matched on its own, to check them. The Fabric column goes to a custom field.
Defaults and preview
New products come in as drafts. I can change that for this import, or for every import. Then the preview. I open the running tee to check it. I can download the preview as a spreadsheet, too.
Import and read the report
Nothing's sent until I confirm. I click Import to Shopify and check the summary. Then I confirm. Big files run in the background, so I could close this tab. Done: four products, fourteen variants. I'll open them in Shopify. Here's the running tee. I open its colors, and each size has its own price and stock.
Update prices and stock from a new file
Now the supplier sends a new price list. I drop it in. This time I'm changing products I already have, so I pick Bulk edit, and Continue. Each row is matched to my products by SKU. Only the price and the stock will change. One SKU isn't in my store, so it's skipped, with the reason. I click Apply bulk update, and Apply update. It updates the products. Done. The new prices and stock are live. I'll check them in Shopify.
Find every import later
Every import is saved in History. I open this one to see exactly what changed. Try csvio free, on your own supplier's file. The link's in the description.
Step-by-step guides
- Shopify bulk product import
- Import an Excel file to Shopify
- Getting started with Csvio
- Update prices from a supplier file
More Csvio tutorials
2:33How to Import Products to Shopify from a Supplier CSV File
2:59How to Move Products from WooCommerce to Shopify with a CSV Export
2:03