How to import Shopify products into a new store
Learn how to import Shopify products into a new store in four steps: export a clean CSV, fix formatting, test a small batch, then check the catalog.
On this page
How to import Shopify products into a new store comes down to four steps: export a clean product file, fix formatting problems, import a small test batch, then check the catalog before you open the store to customers. Most failed imports trace back to the export file, not the new store, so this guide spends most of its time on preparation. It covers what to gather first, how to clean the file, how to import, what to verify, and how to build the new store with FromScratch.
What you need before you start
You need three things: access to the source Shopify store with permission to export products, access to the new store where the products will land, and a clear list of what you actually want to move.
Decide scope before you export. Do you need every product, or only the active ones? Do you need all collections, or only the categories you will sell in the new store? Old test products, discontinued items and duplicate listings are common in Shopify stores that have been running for a while. Moving them only creates cleanup work later.
Check your product count and image sources
Count your products and variants before you start. A store with 40 products and 200 variants will import differently from one with 40 simple products. Also check where your images live. Shopify stores usually host product images on Shopify's servers, and the export file contains links to those images. If you plan to remove or move the old store later, download copies of the images now. Store them in a folder named by SKU or product handle so you can reattach them if a link breaks.
Step 1: Export your products from Shopify
In the Shopify admin, open the Products page and use the export option. Shopify's own help center describes the current steps and the export options available in your plan. Search for "export products" at help.shopify.com, since the menu labels change from time to time.
Export as a CSV file, which is a plain-text spreadsheet format that most tools can read. The Wikipedia article on comma-separated values explains how the format is structured if you want background. Open the file in a spreadsheet app such as Google Sheets or Excel to check it.
A Shopify product export usually has one row per variant. A T-shirt sold in three sizes and two colors can produce six rows, with the product title and description repeated on each row and only the option values changing. Look for these columns:
- Handle: the short URL-friendly name for the product, which should be unique.
- Title: the product name.
- Body (HTML): the description, often stored with HTML tags.
- Vendor and Tags: useful for grouping and filtering.
- Variant SKU: your internal stock code.
- Variant Price and Variant Compare At Price: current and original prices.
- Variant Inventory Qty: stock on hand.
- Image Src: the link to the product image.
Save the original file as a backup before you edit anything. Name it with the date, for example shopify-products-original-2025-06-01.csv. If an import goes wrong, you will need this copy.
Step 2: Clean the file before importing
Most import problems come from data that is technically valid but wrong for the new store. Work through these checks in your spreadsheet.
Remove test and duplicate products. Sort by title and look for "test," "copy," "draft" or repeated names. Delete any row you would not sell.
Check prices and currency. Make sure every price uses a period as the decimal separator and no currency symbol. A value like 12,50 may be read as a text string, and €12.50 may fail. Confirm that all prices use the same currency. Mixed currencies in one file are a common source of confusion.
Confirm image links still load. Open a few image URLs in a private browser window. If they load without logging in, the new store can usually fetch them. If they do not, download the images and host them where your new store can reach them, or upload them by hand later.
Fill in missing SKUs and handles. Each product needs a unique handle, and each variant needs a unique SKU if you use SKUs at all. Blank SKUs cause products to merge or overwrite each other in some tools. Generate simple codes such as CANDLE-LAV-100 if needed, and keep a record of what you assigned.
Common formatting errors and how to fix them
- Broken characters such as
éwhere an accented letter should be: re-save the file as UTF-8 CSV. - Extra spaces before or after values: use the TRIM function in your spreadsheet.
- Descriptions with raw HTML showing tags on the page: remove the tags or let the new store strip them.
- Stock shown as negative or as text: change the cell to a whole number, and set it to 0 where stock is unknown.
- Missing titles on variant rows: Shopify often leaves the title blank on the second and later variant rows. Copy the title down so each row is complete.
Step 3: Import the products into the new store
Open the import option in your new store's admin or builder. Upload the cleaned file, then check whether the tool asks you to map columns. Column mapping tells the tool which spreadsheet column holds the title, which holds the price and so on. If the names match, mapping may happen automatically. If they do not, match them by hand.
Do not import the full catalog on the first try. Create a small test file with five to ten products that include at least one simple product, one product with variants and one with several images. Import that file first.
After the test import, review what arrived. Did the variants group correctly under one product? Did the prices land in the right field? Did the images appear? If the test passes, delete the test products from the new store and run the full import. Deleting test items before the full run keeps the catalog clean.
Step 4: Check the imported catalog
Checking the catalog takes longer than the import, and it is the step people skip. Work through it in a fixed order.
- Compare several products with the original. Open at least ten products, including the most important ones, and compare titles, descriptions, prices and images against the Shopify store side by side.
- Check variants and options. Confirm that size, color and other options appear as choices on the product page, and that each combination has the right price and stock count.
- Check stock. Pick two products with low stock and confirm the new store shows the same quantity. Decide now whether the new store or Shopify will be the place stock gets updated after launch, so the numbers do not drift apart.
- Test the buying path. Add an item to the cart, change its quantity, and go through checkout as a customer would. Use a test payment setup, not a real card, until you have confirmed the flow.
- Check the search and category pages. Search for a product you know is there, and open each category to confirm products are filed correctly.
Keep a short written list of what you checked and what you fixed. If you find a problem across many products, fix the spreadsheet and re-import rather than editing each product by hand.
Build it with FromScratch
FromScratch is an AI app builder. You describe the app in plain language, the agent builds it into a React front-end, a Python (FastAPI) back-end and a database, and you see a live preview within minutes. For a store, that means you describe the catalog, layout and features in chat, then refine it. You can learn more about how this works on the AI app builder overview page and in the guide to AI app builders for business.
FromScratch supports e-commerce stores with a product catalog, cart and checkout. You can import products from an existing Shopify or WooCommerce store, so you do not have to rebuild the catalog by hand. Here is the process:
- Prepare your source. Make sure you have access to the Shopify store and that your product list is current. Use the checklist in Steps 1 to 2 above, and remove test products first.
- Start a new project. Sign in to FromScratch and create a new project. The free plan is enough to start building and testing.
- Describe the store in chat. Type your request into the chat and let the agent build the first version.
- Import your products. Use the import option for Shopify, following the prompts. If you prefer to import from a file, use the CSV you cleaned in Step 2.
- Review the live preview. Open the preview and run through the checks in Step 4: titles, prices, images, variants and stock.
- Refine by chatting. Ask for changes such as a new category or a search bar, and check each result in the preview.
- Connect Stripe. Card payments run through your own Stripe account. Follow the guide to connecting Stripe to an AI-built store before accepting real orders.
- Publish. Publish to a public URL, or to your own domain. The custom domain guide explains that step.
Here is the prompt for the candle business example. Type it as written, then adjust the details to match your catalog:
Build an online store for my handmade candle business. Import my existing products from my Shopify store, with titles, descriptions, prices, images and stock counts. Include product categories, a search bar, a cart and checkout that takes card payments through my own Stripe account.
After the first build, check the catalog as described in Step 4. Ask the agent for specific fixes, such as "group the candle sizes under one product" or "add a category filter for scented and unscented candles." Each change is saved, so you can return to an earlier version if a change goes wrong.
FAQ
Can I import products without an export file?
Usually a file or a direct import from the source platform is simpler and more reliable. Check which methods your new store supports before you start, since each tool handles this differently. If you only have a few products, you can also enter them by hand and skip the import.
Do customer accounts and order history move too?
Product import does not cover customer accounts or orders. Plan that move separately, and decide whether you need to keep past order records for returns, reporting or support. Keep your Shopify account active until you have that plan in place.
How long does an import take?
It depends on the size of the catalog and the number of images, so there is no fixed time to promise. Start with a test batch of five to ten products. If that goes well, the full import is usually the less risky part.
Can I undo a bad import?
Yes, as long as you kept the original export. Delete the products from the new store that came from the bad import, correct the spreadsheet, and run the import again. This is why the backup from Step 1 matters.