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!

 

Settings for Notifications

Excelify notifications for Shopify data import-export events

You can press the “Settings” button and configure when to receive e-mail notifications, and to which e-mails.

By default, the e-mail is sent to Shopify store owner on every event except when starting new manual import (as this is probably something you already know you are doing so you might not need an e-mail about that – but in case you still need it, you can switch it on).

Product Variant Weight can be imported in any units

Shopify weight import and export in real units

Previously you could just import Product weight in “Variant Grams”.

Now there is a column “Variant Weight” where you can set any value in the units as you specify in the “Variant Weight Unit“.

For example – you can import precisely 1 lb, and no need to convert to grams, and no need to struggle with rounding problems.

You can still import the “Variant Grams” if you need to – then your Variant Weight column needs to be empty or non-existing.

Variant Grams are not exported anymore – only Variant Weight column is exported.

Read the full documentation about Product columns.

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.

 

Export to custom file name with dynamic placeholders

Shopify export custom file name with placeholders

When exporting, under Options you can specify the “Custom file name” for the export.

This is especially useful for scheduled exports so that you can specify what the file name should be for your exports.

You can include the dynamic fields of the Export starting date and time in the file name, using the placeholders like this:

Placeholder Meaning Example
%Y Year with 4 digits 2018
%y Year with 2 digits 18
%m Month with padded zero (01 – 12) 04
%-m Month, not padded (1 – 12) 4
%B Month full name April
%^B Month full name uppercase APRIL
%b Month abbreviated Apr
%^b Month abbreviated uppercase APR
%d Day of the month with padded zero (01 – 31) 05
%-d Day of the month, not padded 5
%j Day of the year (001 – 365) 124
%H Hour in 24-hour format, with padded zero 01
%I Hour in 12-hour format, with padded zero 01
%P Meridian indicator, lower case am
%p Meridian indicator, upper case AM
%M Minute 45
%S Second 23
%z Time zone as hour and minute offset from UTC +0900
%Z Time zone abbreviation name UTC
%A Full weekday name Thursday
%^A Full weekday name, uppercase THURSDAY
%a Weekday abbreviation Thu
%^a Weekday abbreviation, uppercase THU
%u Day number of the week where Monday is 1 (1 – 7) 4
%w Day number of the week where Sunday is 0 (0 – 6) 4
%U Week number of the year where the week starts with Sunday (00 – 53) 14
%W Week number of the year where the week starts with Monday (00 – 53) 13

You can use those placeholders in any combination inside your filename.

Some examples:

Example Resulting file name
%Y-%m-%d at %H-%M-%S 2018-04-05 at 01-45-23
%m%d_%H%M 0405_0145
Products_%Y-%^b-%-d Products_2018-APR-5