Export and Import “Buy X Get Y” Discount Codes

Shopify "Buy X Get Y" Discount Code

Shopify has a relatively new discount code type “Buy X Get Y“.

You can now export and import that discount code using the Excelify app.

The best way for you to understand which columns need which values are if you enter one such Discount code manually in the Shopify Admin, and then do the export using the Excelify app.

Then you will see what data goes into which columns.

See all the documentation about all the Discounts sheet columns.

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 Discounts from Shopify

Bulk Delete Discounts Tutorial

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

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

1. Export your existing Discounts from Shopify to Excel

Just click the checkbox for the Discounts and all your Shopify store Discounts will be exported to Excel.

Export Discounts

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

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

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

Like this:

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

Import Deleted Discounts
That’s it – those Discounts 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 Discounts, you might want to do the full export of all Discounts details to Excel file. You can keep that file for reference, or even restore deleted discounts 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.

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?

Of course, we should, and we will…

Tune into our Twitter account @excelify_io for further tests and updates.

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 Excel file:

Clone Shopify Store - Step 1 - Export 2 - Download

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

Clone Shopify Store - Step 2 - Import 1When you upload that Excel file, app will analyze it, and show you all the 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

See?
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. 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.
  3. 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.
  4. 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.
  5. 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.