A store owner at a desk importing products on a laptop, with a green progress screen and a spreadsheet open beside the store dashboard.

How to Import Products to Shopify: 7 Safe Steps

By the Dropship Stair team. Last reviewed: November 2026.

Key takeaways:

  • How to import products to Shopify means moving product data into your store by CSV file, supplier app, or manual entry, and the CSV route is the one most owners control best.
  • Start from Shopify’s sample CSV, keep the file under 15 MB, and save it as UTF-8 so titles and prices come through clean.
  • Back up your products first and test with a few rows before you load a full catalog.
  • The overwrite option replaces values in matching columns, so a blank cell can wipe out a price or a vendor name.
  • A supplier app suits a store that reorders often, while a one-time CSV import suits a launch or a platform move.

To learn how to import products to Shopify safely, back up your current products, build your file from Shopify’s sample CSV, test it with a few rows, then upload it through Products, then Import, and check prices and images before you publish anything live.

If you are opening a new store or moving an old one to Shopify, getting products in is the first big job. Typing each product by hand works when you sell five things, and it falls apart when you sell fifty. This guide shows how to import products to Shopify the safe way, in bulk.

What do you need before you import products to Shopify?

You need a backup of your current products, Shopify’s sample CSV file, your product images uploaded to Shopify, and a clear list of prices and variants. Gather those four things first.

Start with the backup. In your Shopify admin, go to Products, then Export, and save a copy of what you already sell. Keep that file safe, because it is your way back if an import goes wrong. If you are moving from another platform, export your products there instead, then reshape the file to match Shopify’s columns. Our guide on how to migrate to Shopify covers a full platform move.

Next, get your images ready. Upload them through Content, then Files, and copy the public link for each one. The CSV file holds links, not the image files, so a picture that still sits on your computer will not load. Prices go in as plain numbers, with no dollar sign, and each variant gets its own row. The import works on every plan, and Basic costs $39 per month, or $29 per month billed yearly, per Shopify pricing.

How to import products to Shopify in 7 safe steps?

The 7 steps are: back up your products, build your file from the sample CSV, test a small batch, upload the file, review the preview, run the import, and check the results.

  1. Back up your products. Export your current catalog from Products, then Export, and save the file. If the store is brand new and empty, this still proves the export works before you need it.
  2. Download the sample CSV. Get Shopify’s sample product CSV from the Help Center and open it in Google Sheets or Excel. Delete the two example products, or they will land in your store.
  3. Fill in your products. Add one row per product, or one row per variant for sizes or colors. Put the title, price, vendor, and image link in the right columns, and keep the header row exactly as it came.
  4. Test with a few rows. Save a copy with only three or four products and import that copy first. A small test shows header errors and bad prices before they touch your whole catalog.
  5. Upload the file. In your Shopify admin, go to Products, click Import, click Add file, and pick your CSV. Then click Upload and continue. The steps come from Shopify’s guide to importing products with a CSV file, checked for this guide in November 2026.
  6. Review the preview and mind the overwrite box. Shopify shows a summary before anything changes. Check the product count and the column mapping. Only tick Overwrite products with matching handles if you mean to replace live products.
  7. Run the import and read the confirmation email. Click Import products, then wait for Shopify’s confirmation email. An import cannot be cancelled once it starts, so the preview is your last chance to catch a problem.

How do you prepare a product CSV file for Shopify?

A clean file starts with the sample CSV, not a blank spreadsheet. Shopify’s help page offers a sample product CSV, and it holds two example products you must delete before you add your own rows. Building on the sample keeps your headers right.

For new products, the only required column is Title. If a product has variants, the URL handle column is also required, and it must stay the same across every row of that product. The handle becomes part of the product page URL, so keep it short and free of spaces. Price takes a plain number with no currency symbol, and a blank price becomes 0.00. Status can be active, draft, or archived.

Save the file as UTF-8, which keeps accents and symbols intact. Google Sheets saves as UTF-8 by default, while Excel may need an extra step. Keep the file under 15 MB, and split a bigger catalog into smaller files, with all rows of one product in the same file. A product can have up to three options, such as size, color, and material, and headers are case sensitive, so Title is not the same as title.

How to import products to Shopify with a supplier app?

A supplier app moves products from your supplier into Shopify without a spreadsheet, and it keeps prices and stock in sync after the first import. That ongoing sync is the real reason to use one.

The flow is simple. Install the app from the Shopify App Store, connect your supplier account, pick the products you want to sell, and push them to your store. When a customer orders, the app forwards the order to the supplier, and stock levels update on their own. That saves hours each week for a store that reorders often, but it ties your catalog to the app and the supplier. Read the app price before you install it, and check what happens to your products if you cancel. Our roundup of the best Shopify apps for dropshipping compares the main options, and our guide on how to start dropshipping on Shopify shows how the app fits a full launch.

A supplier app is also the right pick when your supplier changes prices or stock often. A CSV file is a snapshot that goes stale the day after you import it, while an app keeps the numbers fresh.

When should you type products in by hand instead?

Manual entry wins when your catalog is tiny, under about ten products, or when each product needs careful photos and copy. A spreadsheet saves no time at that size.

Hand entry also fits one-off additions after a bulk import. If you add a single new product each week, opening the product form is faster than building a file and checking the preview.

What breaks most often during a Shopify product import?

Most failed imports come from four causes: headers that do not match the sample file, a file saved in the wrong encoding, a blank cell under the overwrite option, and images that were never uploaded.

Header trouble is the most common. Shopify treats header names as case sensitive, and a file that uses handle where the sample says URL handle will fail. Strange symbols in titles usually mean the file was not saved as UTF-8, so save it again in the right encoding. Curly quotes pasted from Word can also break the file.

Option conflicts cause a subtler failure. If you move a value such as Size from Option 1 to Option 2, the import can fail with a bare line error, because variant options must stay unique. Import with a temporary option name, then rename it after the import lands. A CSV file also cannot delete products in bulk, or change product availability on other sales channels.

How do you check your store after the import?

Once the import finishes, knowing how to import products to Shopify is only half the job. Open five or six products by hand and check the title, price, images, variants, and URL handle on each one. If those look right, the rest probably loaded cleanly, but scan the full list too.

Then check what a spot check misses: products stuck in draft that should be active, and products published to sales channels you did not mean to use. Check that collections filled in as expected, since the Collection column only works on import and does not appear in exports. If you sell abroad, confirm the international price columns came through, and read our guide on how to sell internationally on Shopify before you turn on new markets. Finally, place a test order, and confirm your payment setup with our guide on how to accept payments on Shopify.

CSV import vs supplier app vs manual entry at a glance

Method Best for Cost Ongoing sync Main risk
CSV import One-time loads and platform moves Free beyond your plan No, repeat the upload Overwrite wipes values
Supplier app Stores that reorder often App fee, varies by app Yes, prices and stock update Tied to the app and supplier
Manual entry Under about ten products Free beyond your plan No Slow and typo prone

The short version of how to import products to Shopify is this: use a CSV file for a one-time load, a supplier app for a catalog that changes often, and manual entry for a handful of products.

Frequently asked questions

Can I import products to Shopify for free?

Yes, the built-in CSV import costs nothing beyond your Shopify plan, and the Basic plan starts at $39 per month, or $29 per month billed yearly. You can add products by hand at no extra cost too. Supplier apps often charge a monthly fee, so check the price first.

How many products can I import to Shopify at once?

Shopify limits the file, not the product count, so one CSV file must stay under 15 MB. A store with short titles and few variants can fit thousands of products in that space. A store with long descriptions may need to split the file and import it in parts.

Will importing products overwrite my existing products?

Only if you tick the overwrite box. When you select Overwrite products with matching handles, Shopify replaces the values in matching columns for matching products. If you leave the box unticked, matching products are skipped. A blank cell can also wipe out a value, so check every column first.

Can I import product images with a CSV file?

Yes, if the image column holds a public web link for each picture. Upload your images to Shopify first through Content, then Files, and paste those links into the Image Src column. A link to a file on your own computer will not work, because Shopify cannot reach it.

What should I do if my Shopify import fails?

Start with the error message Shopify shows, since it usually names the broken row or column. Check that your headers match the sample file exactly and save the file as UTF-8. If one row keeps failing, fix that row on its own and try it again.

Learning how to import products to Shopify is a job where slow beats fast. Back up the catalog, build the file from the sample, test a few rows, and check the results. That care saves you from fixing hundreds of wrong prices one by one. If you are still choosing a platform, read our guide on Shopify vs WooCommerce for dropshipping, or start from our pre-built Shopify store options.

Share the post

Scroll to Top