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.
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!
You make a guess! 😉
OK, look! Pressing “Import” button now…
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?
Of course, we should, and we will…
Tune into our Twitter account @excelify_io for further tests and updates.