Migrate Blog Posts from WordPress to Shopify

Blog Posts - WordPress to Shopify

This video tutorial shows you step by step instructions how to migrate your Blog Posts (Articles) from WordPress to Shopify Blogs.

Steps to migrate articles from WordPress to Shopify:

  1. Go to your WordPress site, and install the Plugin: All Export.
  2. Export all your WordPress blog posts using “All Export” plugin to the CSV file.
  3. Open the CSV file, save it as Excel file.
  4. Rename the Excel file sheet (tab) to “Blog Posts” so that the Excelify app knows what’s inside that sheet.
  5. Set the column titles of the columns you want to import – copy column names from the Excelify template file.
  6. Import the new Excel file to Shopify using the Excelify app.

 

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.

Done!

 

Rearrange Product Variant Positions

Shopify Product Variants

To rearrange Shopify product variants:

  1. Export Products + Inventory / Variants (without images or Metafields)
  2. Find the column “Variant Position” and change the numbers as you like them to be. (no need to change the row order, just change the numbers)
  3. You could just import that same file back but it will update all the columns that you import. So, to make the import smaller and quicker, and to update just the positions and nothing else, you can select just the following columns:
    • ID
    • Handle
    • Variant ID
    • Variant Position
  4. Copy those columns to new empty Excel file.
  5. Set the name of the sheet “Products” (so that the app knows that those are the Products data there).
  6. Import that file. It will just update the variant positions of those variants.

You can, of course, import only the product rows that you really want to change. No need to import all the products back.

See the full tutorial in the video.

How to remove duplicates from Shopify store

Remove duplicates

To see how to remove duplicated Products from your Shopify store, watch this video or read on.

How to remove duplicate Products from your Shopify store?

So you have this store with your products duplicated for some unfortulate chain of events.

Shopify store with duplicate products

1. Export your Products to Excel file – without any variants or images, just plain Products

This will give you one row per product.

Export only Products from Shopify

 

2. Sort your exported Excel file by two columns at the same time: Title, Handle

Take your exported file, open it.

Use the Excel “Sort” feature to sort by two columns at the same time:

  • Title
  • Handle

This will make all the same titles get together one after the other. And then it will sort those same Titles by Handle – in such a way that your correct product will be the always the first one.

If you have another reason for duplication and you don’t have equal titles then you still can find other factors that could allow you to sort all the rows so that the correct one is always the first one.

Sort exported Products by Title and by Handle

3. Make the formula that will show TRUE for duplicated row of the same title, and FALSE for the first one

Now that all your duplicate rows are nicely sorted together with the first row as the correct one, you can proceed to mark – which ones you want to keep, and which to delete.

Add new column with name “Duplicate?” and put the following formula in the row 2 there:

=IF(D2=D1,TRUE,FALSE)

Excel Formula to mark the duplicates

Copy this formula all the way down.

4. Filter Excel rows to show only the duplicate rows

Set the filter to keep only those rows where “Duplicate?” equals TRUE.

Filter Excel to show only duplicates

5. Copy the columns ID, Handle and Command to the new clear sheet

Select the A, B, C columns and copy filtered values to a new clear file.

Then set the name of the sheet to “Products” so that the app knows that those are Products in this sheet (double-click the “Sheet1” to rename it).

And then change the Command column value to “DELETE” for all those copied products.

Result should look like this:

Copy duplicate products to new Excel sheet and set to delete

6. Import that file with Excelify app

Upload that file to Excelify app and press “Import” button.

Watch your duplicate products get deleted.

Excelify results of deleted duplicates

See in your Shopify Admin – and be pleased by the result that all the duplicates are now gone, and you have just one copy of each product.

It should look like this now:

Shopify store with duplicates removedGood to know

  • You can de-duplicate also Collections, Customers, Pages, Orders, or anything else – the same way.
  • If you have the export file with Variants, just first copy your ID, Handle, Command, Title columns to new sheet and use Excel function “Remove Duplicates” – then you will have just one row for each product. And then you can use this tutorial from there.
  • If you have more advanced situation, our Support can help you remove duplicates.

 

Import to Shopify from any file

Import to Shopify from any file (with video)

To see how it’s done, watch the video.

Short summary how to import to Shopify from any file

  1. Open your file, save it to Excel and give the sheet name “Products”.
  2. Take the Excelify.io template file – to take needed column names from it.
  3. Look into your source file columns one by one, and copy the appropriate column names from the template.
  4. Import the file.

You can do that with any other Excel sheets to import not just Products but any Shopify data.

 

Schedule import to Shopify from Google Sheets

Google Sheets to Shopify

Importing from Google Sheets is a bit different than importing from a file that is saved on Google Drive, that’s why we will look at it as a separate tutorial.

If you want to import Excel or CSV files that are stored on Google Drive, read this tutorial: Schedule import to Shopify from Google Drive.

Steps to import file from Google Sheets to Shopify

  1. Prepare your Google Sheet on your Google Docs account.
  2. Make that Google Sheet viewable from a public link.
  3. Paste your Google Sheet link in the app.
  4. Schedule the regular import from that Google Sheet URL.

1. Prepare your Google Sheet on your Google Docs account

Your Google Sheets document needs to be prepared in the same manner as the “Excelify: Excel” file – with the sheet names, and columns that are understandable by “Bulk Import Export Update with Excel” app.

Basically, it will look like this:

Google Sheet to Shopify import - prepare Google Sheet

2. Make that Google Sheet viewable from a public link

Press the “SHARE” button and make the publicly shareable link to this Sheet.

You just need to give it permission “Anyone with the link can view” – no need for a write permission.

Copy that link.

Google Sheet to Shopify import - share the sheet as view only

3. Paste your Google Sheet link in the app

Open the “Bulk Import Export Update with Excel” app in your Shopify store, install it if you haven’t already.

Scroll down to the “Import” section, and paste the URL there.

Google Sheet to Shopify import - paste the URL in the app

Then press the blue “Upload from URL” button – so that the app can upload the file and analyze it.

Don’t worry – it will not import that just yet, you will need to set additional options first.

4. Schedule the regular import from that Google Sheet URL

After the app has finished uploading and analyzing the file, you will see the “Options” button there.

Press that button and set up the import options – the scheduled time for your next import in your Shopify store time zone.

And repeating time interval.

Your eventual options will look like this:

Google Sheet to Shopify import - setup options to schedule and repeat import

Notice the “Take import file from URL” – that is pointing to your Google Sheet. The app will download the fresh file each time it repeats the import.

Now, press the “Schedule Import” button.

It will schedule the import and if the date and time for the first import have already passed, then the app will start the first import shortly after you schedule it.

Good to know

  • You can see the progress of all your scheduled imports and exports in the “History & Schedule”. You can also cancel any of those jobs from there. You can download the import results file from there, too.
  • The scheduled time is in your Shopify store time zone.
  • You can also schedule import files to Shopify store from FTPDropbox or Google Drive the same way.
  • You can also import files from Google Sheet manually – by just pasting that Google Sheet link.
  • Import, not just Products data – import and update any of supported by Excelify.io formats.

Schedule import to Shopify from Dropbox

Dropbox to Shopify

So you have the file in your Dropbox folder that you edit on your computer. You update it regularly, and you want to import that file to Shopify every day.

This is how you set up that regular daily import automatically.

Steps to import file from Dropbox to Shopify

  1. Save your file to Dropbox.
  2. Copy Dropbox link.
  3. Paste your Dropbox link in the app.
  4. Schedule the regular import from that Dropbox URL.

Now, let’s dig into details of each step.

1. Save your file to Dropbox

Shopify import file saved to DropboxYou know that green checkbox icon which means that the file is synced to Dropbox.

That’s it – just make sure you have enough space on your Dropbox cloud storage, and that the file is really syncing.

2. Copy Dropbox link

Shopify import from Dropbox - copy dropbox link3. Paste your Dropbox link in the app

Open the “Bulk Import Export Update with Excel” app in your Shopify store.

Scroll to the “Import” section and paste that URL there.

Shopify schedule import from Dropbox - paste the Dropbox linkThen press the “Upload from URL” button.

It will upload the file and analyze it for the first time.

Don’t press the import here just yet.

4. Schedule the regular import from that Dropbox URL

Press the “Options” button.

And set up the scheduled time in your Shopify store time zone and repeating intervals.

Also, you might want to remove the checkbox from the “Stop if images cannot be downloaded for updated items.” so that the import doesn’t stop in case it will not be able to update images.

The configured options should look like this:

Shopify schedule import from Dropbox - setup the daily repeated importNotice the “Take import file from URL” – it points to your Dropbox file link.

That means the app will download the fresh file from this Dropbox link each time when doing the next scheduled import.

Now, press the “Schedule Import” button.

If the scheduled time will be today and time will be already passed, then the today’s import will start shortly after you will schedule it.

Good to know

  • You can see the progress of all your scheduled imports and exports in the “History & Schedule”. You can also cancel any of those jobs from there. You can download the import results file from there, too.
  • The scheduled time is in your Shopify store time zone.
  • You can also schedule import files to Shopify store from FTP and Google Drive the same way.
  • You can also import files from Dropbox manually – by just pasting that Dropbox link. That will make your file upload much faster because you will not need to upload the file from your own computer.
  • Import not only Products data – import and update any of supported by Excelify.io formats.

How to import several product images from one row?

Shopify several images for product (with video)

So you are in this situation when you have to import several product images, but you hate to copy rows?

Here’s how you import several images per Product as one row – by separating image URLs with ; (semicolon).

Step 1: Prepare Import File With Several Product Images

Prepare your import file, where you have one row per Product, and put all your images in the same “Image Src” column, delimited by ; (semicolon).

For example:

https://i.com/image-1.jpg ; https://i.com/image-2.jpg

To change images for a Product in this way, you need at minimum the following columns in your import file:

  • ID (or Handle)
  • Image Src

Shopify import several product images separated by semicolon

Step 2: Import That Excel File With Images

Import that with Bulk Import Export Update with Excel app.

Shopify Product several images import

Step 3: View Imported Images

Shopify imported several images delimited by semicolon

Good To Know

  1. You can have up to 250 images per Product.
  2. You can add, replace and update images for products the same way.
  3. You can combine both image import methods – have them as several rows, and split by ; (semicolon) in the same cell. As visible in the example image with Product “Jumping Dog”.
  4. Remember to give name for sheet “Products”, so that it knows which sheet contains Products import.
  5. You can update many Product fields at once with the same import file – just put them as additional columns.

 

Where To Go From Here?

  1. Install the Bulk Import Export Update with Excel app from Shopify AppStore and try bulk update for Free on your own store.
  2. If you want to know more about this app, look the How it works? tutorial and video.
  3. Read the detailed Field Descriptions.
  4. Read other Tutorials.
  5. If you are not sure how to prepare the import file, ask our Support, we will teach you, or do that for you.

 

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.