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.

What is the difference between Shopify CSV and Excelify.io Products import and export?

Difference between Shopify CSV and Excelify

Differences between using Shopify CSV for Products export and import, or Excelify.io:

  1. With Shopify you work with CSV files, whereas with Excelify.io you work with pure Excel files.
  2. With Shopify you upload the CSV file and wait for e-mail – you don’t see what’s happening, and you don’t control anything; whereas with Excelify.io you see the progress of your imports/exports, estimated time to complete, and can cancel them any time.
  3. With Shopify CSV export you always get the full store with all products and all fields, whereas with Excelify.io you can choose in more grained details, what details to export, and filter which Products you need to export. That is convenient, because it not only saves the time and file size, but also because it allows you to export data so that you don’t have those duplicate rows. For example, if you want to just update Tags, then you don’t need Images or Variants, because those create additional rows for each product in the table, but you need just one row per product, just with base columns where the Tag column is.
  4. With Shopify CSV – to import several images per product, you need to copy rows and put image in each row, whereas with Excelify.io you can put all images in one row in “Image Src” column, split images by semicolon ;. See: How to import several product images from one row?
  5. With Shopify CSV you cannot export or import Metafields, whereas with Excelify.io you can export Metafields as columns in the same table of Products, edit them, and import them back as updates. See Metafields documentation.
  6. With Shopify CSV, when you import, you either create new, or replace existing Products (you cannot update, only replace); whereas with Excelify.io you can update products as well. You can update even individual fields by importing just those fields (together with ID). See for example the tutorial how to update just the Product Price.
  7. With Shopify CSV – to update Image Alt Text field, you need to import whole Product with all its variants again, and replace it; whereas with Excelify.io you export existing Products with just Images and Image Alt Text as additional data, update that column in the Excel file and import it back as an update.
  8. With Shopify CSV you cannot export or import Template Suffix field of your products, and you cannot update it in bulk, where as with Excelify.io the Template Suffix is just one column in the file, which you export or import.
  9. With Shopify CSV you have the file size limit of 15 MB, which is roughly not more than 10’000 Products (depending on your images/variants rows); whereas with Excelify.io there is 100 MB Excel file size limit you can upload, which for the Excel file is a lot more than you can ever need, because Excel file is compressed. For example, 300’000+ Products in one import is ok.
  10. Descriptions that contain escaped HTML code, with symbols like < > are being fixed to normal HTML code.