New format “Excelify: CSV” for truly big data export and import

Shopify export very large store to CSV file

If you have a store that is so large that the data don’t fit into an Excel file, now you can choose to Export into “Excelify: CSV” format.

That will still allow you to export several entities in the same export (Products, Collections, Customers, …), because each entity is saved into its own CSV file, and they are all zipped into one nice zip file to take less space.

The only limitation here is that you cannot export Metafields. It’s because each item Metafield can be only discovered when that item is read from Shopify, but CSV files don’t allow to add columns on the fly.

You can import that same zipped CSV format as well.

Similarly, as Excel sheets, each CSV file will have its own name that determines what is in that file. For example, you will find Products in the “Products.csv” file, when unzipping the exported file.

Excel file format is limited to 1 million rows, but this new format allows you to exceed well over 1 million rows in your exports and imports.

All the columns are the same as in our Excelify Excel template. It works exactly the same as with Excel. Also, after the import, you are able to download the Import Results file and see the result columns.

The exported result will look like this:

Shopify exported to CSV files

Filter Products by SKU fragment

Shopify filter products by SKU fragment

You can filter Products – to export only those, which contain fragments of SKU.

To filter by several fragments, split them by comma.

In this example, if you have the filter set to “SKU-1, AAA”, then it will export only those Shopify Products, where any part of their SKU contains “SKU-1” or “AAA”.

To export all Products, where SKU is empty – set the filter by SKU, and leave the search box empty.

You can apply the filter when exporting to any format, including Excel, Google Shopping Data Feed, Amazon.

Export products from Shopify to Amazon

Shopify Amazon

You can sell your Shopify products on Amazon by exporting from Shopify and importing to Amazon in bulk using Bulk Import Export Update with Excel app.

From the Shopify side, your products should have certain information filled in. From the Amazon side, you need the Professional Merchant account. There are some constraints from the Amazon, what and how you can add to your listings, those will be applied to uploads as well.

The basic approach will be:

  1. Prepare your product data in Shopify.
  2. Export products with Bulk Import Export Update with Excel app into Amazon Inventory Flat File format.
  3. Add Products via Upload to Amazon.
  4. Review upload results.

Prepare your product data in Shopify

You can import either products with no variants (only one variant) or with several variants. Currently, variants having Options of color and size are detected automatically. If you have other option names for variants, you will have a chance to use them too, just with small copy-paste in the exported file.

Let’s start with most important things first.

You must have SKU and Barcode fields filled for your Shopify Products

Product SKU and Barcode


You can use any SKU you like, but it must be at least 8 characters long. From Amazon perspective, this is your inventory ID.


Your Barcode should be valid product identifier according to one of those classifications: ISBN, UPC, GTIN, EAN, ASIN. Usually, you can get it with your product data from your supplier. You can validate your barcode numbers using Lookup Databases online, for example –

Amazon Product Type

When importing to Amazon, it requires the feed_product_type field in the import file. That product type is not the same as Shopify Product Type field, because Amazon accepts only certain values, according to their own classification.

See the full list of acceptable values on the Amazon Product Types page.

You can see all product_id_type values on Inventory File Template page for the needed category.

How to fill Amazon product type?

You can keep your Shopify Product type as it is, no need to change that. When exporting to Amazon Inventory Flat File format, you can get it filled in one of three ways:

  1. Enter it in the exported Excel file, in the column “product_id_type”.
  2. Set the Tag for your product with Amazon product type. For example, if you want to use the Furniture And Design Amazon product type, add a tag to the product: “AmazonProductType:furnitureanddesign“.
  3. Set the Metafield: “product_id_type” in namespace “amazon” for your Products. When importing in bulk, that’s the column: “Metafield: amazon.product_id_type“.

You can export and import those Tags or Metafields in bulk using this same Bulk Import Export Update with Excel app.

Shopify Amazon product type as Tag

You can view all custom fields you can set for Amazon exports, in this Amazon Inventory Flat File documentation.

Export product with Variants and Images into Amazon Inventory Flat File

Got to the App, select to Export Products with Variants and Images and Export it into Amazon Inventory Flat File:

Export products

Export Amazon Flat File

Download exported file.

Shopify exported Flat File for Amazon

Exported file contains all the basic columns with the data that is needed for your products to be created on Amazon.

TemplateType=home, by default, but if your products are of different Product Category, then the different value needs to be set here. Find more information on Product Categories and TemplateType values here.

It also contains Shopify columns with your product variants data for your convenience, if you need to use them for other variation themes.

All the exported columns are described in Amazon Inventory Flat File documentation.

Import Excel file via Upload into Amazon

Go to your Amazon merchant account. Go to Inventory -> Add Products via Upload. Choose file and click Upload and wait for upload result.

Add via Upload

After clicking on Upload, you will be redirected to the Monitor Upload Status tab. When upload is finished, you can see the processing report there:

Upload status

Download your Processing Report.

See that products were successfully imported:

Import report

If there is a Warning about the Shopify columns, then you can ignore it.

You also can see imported products in the Inventory -> Manage Inventory

Imported products

Good to know:

  • Amazon has a huge product catalog and will try to match your products with already existing ones. If it will (usually by UPC number), it will check if the information is the same and will import if it is. If there will be some discrepancies, you will get error messages in the upload report and instructions, how to fix them.
  • Read the Amazon Inventory Flat File documentation to find out what Shopify data goes into which columns of the Amazon Excel file, and how can you make repeated exports and have the data as you want it to be without further manual changes in the exported Excel file.
  • Please, read the Amazon Inventory Loaded Instructions carefully if you have any issues importing the exported file into Amazon.
  • Look into Amazon Inventory File Templates to see different templates Amazon requires for each product category.
  • Contact us if you run into issues that you can’t fix – we will help.


Send activation invitations with MailChimp to your newly migrated Shopify customers

Send campaign

This is the continuation of the tutorial “How to migrate customers to your new Shopify store and activate their new accounts?“, if you want to send out invitations to your newly migrated customers in bulk, and you want to use your own template with MailChimp, instead of Shopify built-in template from Admin.

Here I assume that you have already imported your new customers into the Shopify. If you haven’t migrated them yet, then go on and import them using the above mentioned tutorial.

The steps will be:

  1. Look at the default manual way to send invitation to new customer by one customer at a time from Shopify Admin.
  2. Export unactivated customers from Shopify by generating Activation URLs in the Excel with Bulk Import Export with Excel app.
  3. Import list of customers with their activation URLs to MailChimp (or any other mass mailing service).
  4. Send out e-mail campaign to new customers from MailChimp with nice invitation to activate their accounts.


It may look complicated, but trust me, when you will do it once, and understand the system, this will take you not more then 15 minutes to set up everything.

1. The default way to send invitations from Shopify Admin

Shopify provides the functionality to send account invite for non-active customers. Open any customer data we just imported and see Send account invite right under the customer name:

Account invite

Click on Send account invite and you will get the form for email:

I filled it in with information I want to provide to the customer. Click on Review email:

Review email

Click Send notification and you will get the email with activation link. You can test this and activate account.

Activation email


Clicking on Activate your account will bring you to the Activation page: Activation page


Doing like that you can send Activation email to one customer at a time. And if you have 100 or 1000, or even more customers?

2. Export customers from Shopify with generated Activation links in bulk

We will save time and send activation emails to them all at once.

We need to get Activation URLs for all customers for that.

To get this data, lets export customers customers with Bulk Import Export with Excel app. Check Activation URLs when exporting:

You will get Activation URLs in the Export file.

Exported file

There are a lot of columns, but we will need only 4 of them Email, First Name, Last Name and Activation Account URL. So, I will delete all other columns:

File for import


Create the list of customers in MailChimp

There is a service MailChimp, that allows to send notifications, campaigns, newsletters etc. to lists of customers. As we want to send Account activation emails to several customers at a time, let’s first create the list of customers.


Login (or register) into MailChimp service.

Click on Lists -> [Create List] and fill in list data. I called my list “Migrated customers”:Create list

Click Save.

Of course, we will not add customers to the list manually 🙂 We will import the data from the Excel we exported from the Shopify earlier (the one with Activation URLs). Click Imports subscribers:  Import customers
Will import from xlsx file: Import from xlsx  There are 3 mandatory fields: Email Address, First Name, Last Name. We will need one more field: Activation URL (as we need to invite customers to activate their accounts in our new shop). Import

Now we need to open the exported Excel, copy all data and paste it to the MailChimp form:Import into MailChimp

Press Next.

Now we need to help MailChimp to understand what data about customers we want to import.

Imported customers


In the column names select appropriate title and press Save. Do it for Email Address, First Name and Last Name columns. For Activation URL column you need to add New column name. I will call it Activation URL.Imported columns

Press Next.

Import contacts

Import contacts

Now we have all customers’ data imported:   Customer contacts

We will do one more thing. Go to the Lists. Open Migrated Customers list. Click Settings -> List fields and *| MERGE |* tags

List settings

Here we will change tags for the First name field and for the Activation URL field. Set NAME and URL accordingly. Press Save Changes. We will need this when creating Activation email.

List field tags


For the testing purposes I will create one more List and call it Test Customer. This list will contain only one customer with my own email. I will copy real Activation URL (from the Excel) and also add field tags as in the previous step. With this list I will test, if email is sent as I wanted it to be and if Activation URL is working correctly.

Test Customer


Create the campaign in MailChimp for sending Activation emails

Now we need to create a New campaign in the MailChimp with what we will send the information to our customers and invite them to activate accounts. Click Campaigns -> [Create Campaign]

Create New Campaign

Choose Create an Email (as we will send the Campaign via email).

Name your campaignCampaign name

Choose the list of customers – Migrated customers Campaign listFill in Campaign infoCampaign info

Pay attention to the checkbox Personalize the ‘To” field. I Check it and put field tag *|NAME|* *|LNAME|*  in recipient name. Remember, we added these tags earlier, when creating the list? So, now each customer will get the personalized email, with his/her First name and Last name as the recipient.

Click Next.

MailChimp provides a lot of templates for email campaigns. I will choose “Make an Announcement” template

Choose template

There will be prepared boxes that you need to modify and deleted what you do not need. Imagine how do you want the email to look like. Do you need any images? What text will you put there and attract your customer and make him/her interested to activate account.

Editing Campaign

When you have approximate idea, click on the appropriate box and modify it.

I have added the Logo. Then I edited the box with the text. Edit Activation email

I deleted boxes with images and all other except the button.

I edited the button as follow: Edit Activation button

In the Web address (URL) field I put URL tag that we added, when creating the list. This button will take each customer to his/her own Account activation page, as it will take his/her particular Activation URL from the list.

Press Save and Close.

Test and then send the e-mails to all customers

Now we can test it with test email. Go Preview and Test -> Send a test email.

Send test email

Provide the email, where you want to send test and click [Send Test].

Here is mine Test email

Looks good to me. Activation button will not work here, as this is just a test. But I would like to test, if the button will work in the real email, so I will send this Campaign to my Test Customer list (remember, I have created one?)

I will click Next Choose test list

Here I will change the list. Click on [Edit]  for the List and choose Test Customer list Test customer

Click Next -> Next -> Next. And then click Send!

Send campaign

Click Send Now!

And now wait for the email 🙂

I have got mine Test campaign email

Now I see there Name and Last name. And [Activate Now]  button will take me to the Activate Account page Activate Account Page


Now we should send Activation emails to the real customers.

Go Campaigns. For the New Store Account Activation campaign choose ReplicateReplicate campaign

Choose Migrated Customers list Choose list

Click Next, Next, Send.

You will be asked again if you want to send. There should be 4 subscribers (in my case). Click [Send Now].

And we are done!