Automatically synchronize your Shopify store with your other store daily/weekly/monthly

Sync Shopify

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

  1. Store A: Setup the scheduled regular export of the data you want to synchronize.
  2. Store A: Wait for the first export to finish and copy the exported file URL.
  3. Store B: Setup the scheduled regular import from the URL of the regular export.

Let’s get to it!

Store A: Setup the scheduled regular export of the data you want to synchronize

Sync Shopify store - Setup the regular exportMark the items you want to 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: Wait for the first export to finish and 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:

Sync Shopify - copy the exported file URLThere you will see the next scheduled export for tomorrow, and the export that finished today.

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 from the URL of the regular export

Now, open the app on your other store – that where you want the data to get imported from the 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:

Sync Shopify - paste the export URL in the Store B

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.

Sync Shopify - import from scheduled export fileWhen everything looks nice, press the “Schedule Import” button.

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.

Sync Shopify - see scheduled import statusThat’s it!

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.

Improve import speed when importing from another Shopify store

Import to Shopify by ignoring ID

When you export from one store and import to another, the import file includes items with their IDs. If you would import that same file into the existing store (like when you update some items), that ID allows to identify existing items very quickly, so the import speed to the same store is very good.

But when you copy your data to another store, those IDs don’t exist in the other store, so that causes the app to make an additional request to API to find that out. You can improve the speed by checking the “Ignore ID” box and that will tell the app not to try to use those IDs.

It will improve your import speed by at least 20%.

Schedule and repeat imports to Shopify

Shopify import schedule and repeat

You can schedule and repeat imports to your Shopify store.

After uploading the import file, you can click the “Options” button and set the scheduling and repeating parameters.

You can combine them as you like. You can set just to schedule the import to start at a certain date and time. And you can set the import to repeat at certain time intervals, for a given amount of times.

You can also set to import now and repeat at the same time at given time intervals.

To review or cancel the scheduled imports, go to the “History & Schedule”.Shopify schedule and repeat history and cancelHere’s the tutorial on one typical scenario: Schedule regular Product price update.

Bulk Delete Pages from Shopify

So you need to bulk delete Pages from your Shopify store.

Here’s how you delete any Shopify Page with Excelify.io app:

1. Export your existing Pages from Shopify to Excel

Just check the checkbox for the Pages and all your Shopify store Pages will be exported to Excel.

Export pages

2. Edit exported Excel file to mark pages you need to delete

Delete from that Excel file all the pages which you want to keep in your store – so that your file contains only Shopify Pages you want to delete.

Then set the values for “Command” column to “DELETE”.

Like this:

Pages Delete Command
3. Import prepared file to delete those Pages

Import Deletes Pages
That’s it – those Pages will be deleted from your Shopify store permanently.

Good to know

  • You can delete any other items from your Shopify store the same way.
  • Before deleting pages, you might want to do the full export of all Pages details to Excel file. You can keep that file for reference, or even restore deleted pages later to your Shopify store if you need to.

 

“Command” column: NEW, UPDATE, REPLACE, DELETE

In each sheet, you can use the “Command” column, by which you can tell, what to do with the row that is being imported:

The possible commands are:

  • NEW: will try to create a new item with the provided details. If such item will already exist (with the same ID or same Handle), then the result will be Failed.
  • UPDATE: will try to find existing item by ID or by Handle, and update it with data from the row. If such item will not be found, then it will create new.
  • REPLACE: at first, if such item with provided ID or Handle exists, then the app will delete it. After that, it will create a new one. If an existing item will not be found, then still the app will create a new one. The difference from UPDATE is that it will not keep any of columns, which were not included in the import file since the item will be deleted and re-created.
  • DELETE: the app will delete the existing item, which is found by ID or Handle. If such item will not be found, then the result will be Failed. This DELETE command is very handy for deleting items in bulk.

If no Command is specified, then the app will assume the UPDATE command.

Option to remove images from Body HTML descriptions when importing

You can remove images (<img> tags) from your Body HTML description by selecting a checkbox option “Remove images from Body HTML” when importing.

Also you can update your existing products, collections and pages the same way.

Here is the tutorial: How to remove images from Shopify Body HTML descriptions?

Option to remove images from Shopify Body HTML

How to remove images from Shopify Body HTML descriptions?

The same image appearing in Shopify images and in the Body HTML description

If you are in the situation that your Shopify Products has Body HTML with images, then here’s how you remove images from product descriptions in bulk.

That is especially important in cases when you get the product data from your dropshipper, and it has images as links, which you import with your product data, and at the same time they have those images in the description too.

You actually have not just one, but two problems with images in product description:

  1. Your product page is showing duplicate images, because they come from Shopify Product images, and also from the description HTML.
  2. Typically those images used in the HTML come from very slow servers, so your page loads a lot slower for the client, because client browser has to download those additional images from wherever they come from.

Example Body HTML

Here is how your Body HTML looks like when it has image tags:

<p><strong>This is the t-shirt description.</strong></p>
<p>And here comes the image in description too.</p>
<p><img src="https://something.com/NICE_t-shirt_black_red.jpg?v=1464400950" alt="" /></p>

You can import your Excel file in such a way that your resulting Body HTML will look like this – with images removed from the HTML code:

<p><strong>This is the t-shirt description.</strong></p>
<p>And here comes the image in description too.</p>
<p></p>

 

How to remove images from Body HTML?

When importing your Shopify data with Excelify.io app, right after you have uploaded the file, you will see the “Options” button.

Click that button. Then there is an option that says “Remove images from Body HTML” – mark that checkbox.

And press “Import”.

Option to remove images from Shopify Body HTML

 

How to remove images from existing Products already in Shopify?

You can remove images from your existing Shopify products (and other items) descriptions with the following steps:

  1. Do the Export of just Products (without any additional data)
  2. Download the exported file.
  3. Upload that same file to Import, and mark the “Remove images from Body HTML” checkbox in options.
  4. Complete the import.

As a result – images will be removed from all your product descriptions.

This is how your product looks before removing images from description:

The same image appearing in Shopify images and in the Body HTML description

This is how your Shopify product looks after removing images from product descriptions:

Images removed from the Shopify Product description Body HTML

Good to know:

  • With this same method you can remove images from Body HTML description for Shopify Products, Collections and Pages.
  • You can remove images only from select products either by exporting them with filter. Or you can export your whole store, and then keep in the import file just the items where you want images to be removed from descriptions.
  • You also will need to remove images from product descriptions, when importing products to Amazon, because Amazon doesn’t allow to have images in descriptions. Read more about importing to Amazon.
  • You can import back only the Body HTML column, without updating other fields. Then just import the file with the following columns: Handle and Body HTML. Like this:
    Import Columns with just Shopify Body HTML description with images