Test that the image links from your “Image Src” folder works by opening at least one of them in your browser (with the barcode which you uploaded, because Ingram doesn’t have all the 10k images in their test image files).

Upload your zipped CSV file which you got from the Dry Run into the Excelify app.

Now it should say it recognized it as Excelify format.

And then press Import.

Import process should look like this:

Notice that some items will be Failed, because the app can’t delete some books which are out of stock, if it can’t fnd them in your store.

To be sure, after the import is finished, to be sure, please, download and review the Import Results file – last two columns will contain reasons for each failed import.

When imported, in your Shopify Admin the book will look like this:

Good to know

We are well aware that importing from Ingram is not a simple task. We have tried to make it more simple than importing without Excelify, but there are still many things to improve – so please, be gentle to us if you still have to experience a struggle.

2. Take those credentials and construct the URL like this:

3. Paste that URL in the Excelify app Upload section, and press “Upload from URL”

4. Run Import in the “Dry Run” mode

You could just press “Import” and do the import, but at least for the first time, you might want to check, what kind of data is being imported, and maybe adjust some of it.

To not import just yet, but to see the data in the Excelify import format, you can run the import in “Dry run” mode. That will not actually import any data, just it will generate the import results file, which you can update, and then import that modified Excel file afterward.

After you mark the checkbox for “Dry run” – then press the “Import” button. And wait…

Note that at first it will download everything from the Turn14 API, so it will show no progress at first for some 30 minutes or so.

5. Update and improve your import file

6. Import your Excel file with Excelify

When you are done editing your Excel file, then upload and import that into the Excelify 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:

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

SKU

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

Barcode

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 – upcitemdb.com.

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.

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

Download exported file.

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.

Import Excel file via Upload into Amazon

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:

Download your Processing Report.

See that products were successfully imported:

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

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.

This website uses cookies

We use cookies to analyse our traffic. We share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information that you’ve provided to them. You consent to our cookies if you continue to use this website. See Cookie Policy here