Schedule your Shopify store backup

With Excelify you can backup your Shopify store daily, weekly or monthly. Here we will take a look at how to configure it.

Steps to backup your store.

1. Select checkboxes to export all fields.

In Excelify App you can select checkboxes to export specific information from your store. Here we will select everything so our backup file contains all the information possible about the store, but you can also schedule backups for only a few specific items.

To export everything from your store select all possible checkboxes and sub-checkboxes except the following –

  • Do not check Collections under Products – this is an export only field, and will not be imported in case of restoring, so you do not need to include those in your backup.
  • Do not check any Metafields – If you do not use metafields or don’t know what metafields are then most likely you don’t need them in your export. As metafields add a lot of time to export.
  • Do not check Generate New Activision URLs for Customers – DO NOT select this for backup or export, as this will reset your customer accounts and your customers will need to activate their accounts.
  • If unsure – copy the checkboxes from the picture below.

2. Configure export options.

Now we before exporting we click on ‘Options’ and set up our scheduled export.

  1. Checkbox ‘Repeat every‘ and select how often do you wish this export to run. Exporting every day might be a bit of ‘overkill’, so preferred time would be every week.
  2. Now use the custom file name, so we can faster find the backup file when needed. We will use dynamic placeholders so we know what date it was exported at. One example name would be – Excelify-Backup-%d-%m-%y. Example of the exported file would be – Excelify.Backup-20-12-18. *This is optional and you can also leave the field empty.
  3. Make sure to checkbox – ‘Zip CSV files
  4. And select the exported file format as ‘Excelify: CSV‘ – CSV file format will export much faster and will import also faster if you will need to restore some data. 

3. Start your export.

This is it, now once a week there will be export running that backups your whole store.

You can see all your scheduled exports when clicking on ‘History & Schedule’. Here you can also download any exported file by clicking on the file name, this includes your backup files.Shopify export history

Good to know!

  • You can also configure automated exports to Google Sheets, so you have easier access to your data all the time – Scheduled exports to Google Sheets
  • In a similar manner, you can also synchronize your store with another Shopify store automatically – Synchronize your Shopify stores
  • If you need assistance to configure your store back up contact our support and we will help – Contact Us

Clone Shopify Blogs, Blog Posts (Articles) and their Comments to other store?

Shopify Blog Posts - Clone

This video will show you how to copy all your current Blogs, Blog Posts (Articles) and their comments to your new store.

This is needed when you are migrating to a new Shopify store, or when you need to set up the test/development store and want to use the data from your real store.

Summary of steps to clone your Articles:

  1. Install the Excelify app on both stores – old and the new one (get the second store for free, remember that you don’t have to pay for two stores here).
  2. Go to source store, select to export all Blog Posts, Blogs, Comments and Metafields (if you have those).
  3. When export is finished, download the exported Excel file.
  4. Go to the new store and upload the exported file.
  5. Press “Import”.
  6. Wait for import to finish.



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 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.

How To Clone Your Shopify Store?

Clone Shopify Store

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 a zip or Excel file:

Clone Shopify Store - Step 1 - Export 2 - Download

Step 2: Import that Zip or 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 Zip or Excel file.

Clone Shopify Store - Step 2 - Import 1When you upload that Zip or Excel file, the app will analyze it, and show you all the Zip file CSV files or 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. To make the export and import faster and handle really large stores (with over 100’000 items), choose the export format “Excelify: CSV” – that will create zip file with CSV files inside. If you want to have it more human readable, choose the format “Excelify: Excel”.
  3. 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.
  4. 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.
  5. 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.
  6. 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.