You have more than one stores on Shopify, and now you need to synchronize their contents regularly.
Here’s how you do that using Excelify.io app.
Steps to automatically synchronize data from one Shopify store to another
- Synchronize Shopify Admin -> Settings -> Locations between both stores.
- Store A: Setup the scheduled regular export of the data you want to synchronize.
- Store A: Wait for the first export to finish and copy the exported file URL.
- Store B: Setup the scheduled regular import from the URL of the regular export.
Let’s get to it!
Synchronize Locations between stores
Go to Shopify Admin -> Settings -> Locations in both stores and make sure that you have the same amount of Locations and Location Names are the same. This is needed to migrate Products and Orders for stores with multiple locations. When importing into Store B the app will try to set Inventory Qty for each location as listed in the exported file. If such a location would not be found the Product will fail to import.
You can skip this point if you do not use multiple locations.
Store A: Setup the scheduled regular export
You can even set the filters, for example, to export only Products that have a certain Tags, or products that exist only in certain Collection. Use any of the available filters in the app.
Then, under the Options button, you need to set up the:
- Schedule export on: choose the starting date of the first export and time. In this example, it will start the first export today at midnight of the store time zone.
- Repeat every: set the interval when to repeat that same export, and how many times to repeat it. In this case, it will export every day and will repeat it forever.
- Custom file name: and this is the most important part. You need to set the custom file name for your export because this will ensure that your exported data will always be available at the same URL. We will use that URL in the scheduled import.
Then press “Schedule Export” to schedule it.
2. Store A: Copy the exported file URL
If you have set the repeated export to start today at the time that has already passed, the app will start the export shortly after you schedule it – to complete the today’s export.
Open the “History & Schedule” page and see that the export is done. If it is not yet finished, you will need to refresh this page manually to update the status.
When your first export is finished, the page should look like this:
You will see that the completed export has the file there – your custom defined file name.
Right-click on it, and “Copy Link Address“.
This link will be the same for all the future exports of this scheduled export. So now you will use it for the scheduled import.
Store B: Setup the scheduled regular import
Now, open the app on your other store – that where you want the data to get imported from store A.
And scroll to the Import section of the app.
There you will see the box where you can paste the URL of the file to upload.
Paste your copied URL there, like that:
Then press the “Upload from URL” button.
It will upload the file, and the app will analyze it. And just hold the horses, don’t press the Import button here.
Instead of that, press the Options button.
And then set up your schedule so that it always starts at the time that is after your export would finish. In this example, we have set the export to be on midnight, so we will set the import to happen at 1am every day, starting from today.
Notice that the checkbox is removed for the option “Stop if images cannot be downloaded for updated items.” – that is useful when updating your existing items, the app will not stop if some images will not get imported. It’s what you most likely want, right?
Also, notice how it has the “Take import file from URL:” filled with your URL – it means that every time the app will run this repeated import, it will use the fresh file from that URL you pasted earlier.
Again, if the time for today’s import is already passed, the app will shortly start the import to complete the first import for today. And that is a good way to check that it did work as you expected.
You can find that import status in the “History & Schedule” page.
Now it will sync your stores just the way you want it!
Good to know
- You can synchronize any kinds of items – Products, Collections, Discounts, Customers, Pages, even Orders.
- You can synchronize items partially by using Filters when setting up your repeated export. For example, you can synchronize just products with certain Tags, or that are in just the certain Collection.
- You can have several syncing processes happen at the same stores. No limitations, but just bear in mind that running two processes at the same time will make their speed two times slower.
- You can set up the same synchronization both directions – just set up the same logic from store B to store A.
- The scheduled time uses the time zone from your Shopify store.