What’s the Shopify maximum import limit? (Updated on 15 Dec, 2017)

Searching For Maximum - 100'000 - progress - 4 hours remaining

With this exercise our goal is to find the Shopify maximum points. (Updated on Dec 15, 2017 with new speed improvements)

We will start with basic thing – by importing 100k Products, and move up from there.

Day 1: 100’000 Products Import

Before we started, it was estimating 2d 7h min to complete, which would be the time of single-stream import.

But we will have 10 streams importing in parallel, so let’s see where this takes us.

Shopify maximum import speed

Few minutes later the estimated time dropped to just 7h 9 min, because all the 10 parallel imports are working like crazy!
We are moving at the speed of 0.264 seconds per Product, which is basically 3.79 Products per second, or 227 Products per minute, or 13k Products per hour.

It’s done! Our Shopify store now has 100’691 Products!

Searching For Maximum - 100'000 - done


What next?

You make a guess! ūüėČ

OK, look! Pressing “Import” button now…

Big Import of Collections, Customers, Discounts - before start

Alright, the weekend has passed, and I admit, we had some bumps – we had wrongly formed Discounts import table which was failing. So we decided to cancel the import, fixed the table, and imported again. We want the “finding maximums” kind of results here.

Here they are:

As you can see, the first kind of maximum is found. That is – we have hit the Shopify limit of 5000 Smart Collections.

Other than that, 10k+ Custom Collections, 100k+ Customers, 20k+ Discounts. Not bad at all, Shopify! Very not bad at all!


Should we continue?

Off course, we should, and we will…

Tune into our Twitter account @excelify_io for further tests and updates.

How To Clone Your Shopify Store?

Clone Shopify Store - Step 2 - Import 2 - Download Results

We have designed the feature to clone Shopify store as a completely smooth experience for you.

Step 0: The starting point

We start by having a Pet Shop store with some Products, some Smart Collections, some Custom Collections with Products in them, Customer and Discounts. This is the one that we want to clone to another store we have.

Clone Shopify Store - Step 0 - Products & Collection

Step 1: Export from your existing Store

Export whatever you want from your existing store.

If you want also Custom Collections to contain all the correct Products, be sure to export also Products and Linked Products in the same Export.

Clone Shopify Store Step 1 Export

When the export has finished, press that green Download Exported File button to get your Shopify data as Excel file:

Clone Shopify Store - Step 1 - Export 2 - Download

Step 2: Import that Excel file

If you simply want to copy contents of one Shopify store to another, you even don’t have to look inside that file.

Just go to your other Shopify store, install the same app, and import that exported Excel file.

Clone Shopify Store - Step 2 - Import 1When you upload that Excel file, app will analyze it, and show you all the Excel Sheets it found inside, and how many items it found in each Sheet.

Then press blue “Import” button to start the import.

When it’s done, you will see the green “Import Completed” message.

Clone Shopify Store - Step 2 - Import 2 - Download Results

Step 3: Go, Check Your Shopify Store Clone

Clone Shopify Store - Step 3 - See Results

Notice that the store name is different, URL is different. No joking Рeverything is there the same as it was in that Pet Shop store.

Even Manual Collections (Custom Collections) have their products linked, as you would expect.

Good To Know

  1. That other store can have items there already. When you clone Shopify store by this method, the additional items will be added, and the ones that have the same Handle (or E-mail, or Discount code) will be updated. Others will not be touched.
  2. If you open that Excel file you downloaded, you will notice that it’s perfectly human readable. If you need to, you can change, add or remove data there, and do the import again in all your stores.
  3. After import is complete, you can download the “Import Results” Excel file, where the last 2 columns (Import Result and Import Comment) will show you the result for each row. This is helpful, when something failed in the import – you will see the failure reason there.
  4. You can use this method to translate your store items to whatever other language you have in your other store. Export it to Excel, give to professional translator that Excel file, and import the translated file into your new store.
  5. Hey, and if you have two stores in separate languages, you can import column updates to both of them, without touching the translated columns (like inventory quantity or price). Only then those items need to have the same Handles, as this is how app will identify that they are the same ones to update.


Where To Go From Here?

  1. Install the Bulk Import Export Update with Excel app to your Shopify store. Actually to all of your stores, so that you can clone them back and forth.
  2. Get your additional store included in the same paid Plan –¬†send our Support addresses of all of your stores.
  3. Read other Tutorials, to get idea what else can you do besides cloning your Shopify store.
  4. Read the detailed Column Descriptions of all columns (fields) that you can export and import.
  5. Write us a Review and give some stars along with your story, how it helped.