Import products from Ingram to Shopify

Import books from Ingram to Shopify

There is this enormous book warehouse called “Ingram” (https://www.ingramcontent.com).

You can use the Excelify app to import Ingram books into your Shopify store.

1. Download the following files from your Ingram FTP account:

If you want to start with their test files of top 10’000 books:

File name FTP folder
[email protected] /Top_10K
10KPMall_active.txt /Top_10K
10KTtlingv2.txt /Top_10K
10KWklyImages* /Top_10K

If you want to use real full files (warning that they are really large and will take a lot longer to process):

File name FTP folder
[email protected] /Inventory
pmall_active.txt <ask Ingram Support>
ttlingv2.txt <ask Ingram Support>
<images> <ask Ingram Support>

Note that individual files need to be unzipped (if you download the zip files from Ingram FTP).

2. Zip the data files into one “ingram.zip” file:

For testing – take the following files:

And zip them into one zip file.

Name that zip file so that the file name contains the word “ingram” in it. For example “ingram.zip”.

3. Upload that Ingram zip file into the Excelify app

Whe you upload that zip file, you should see that the Excelify app detected it as the “Format: Ingram”.

It should look like this:

Ingram zip file uploaded to Excelify for Shopify

Don’t press the Import button just yet!

4. “Dry run” the import

Press the Options button.

There, mark the checkbox “Dry run – just generate the Results file without importing“.

Dry run the Ingram file conversion to Shopify importable format

Only then press the Import button.

That will make the Excelify app just transform your Ingram file into the Excelify format, but will not do the import just yet.

5. Review and update your CSV file for Shopify import

After the conversion is finished, you will be offered to download the “Import Results” file. It will be a zipped CSV file – because Excel cannot hold millions of rows but CSV can.

Download that file, and see that it’s the proper Excelify template CSV file of Products. Those are generated from your Ingram data files.

Review the Excelify file which you are about to import, do any changes to it according to your needs.

Deleting books with no inventory:

  • In the “Command” column for some books you will see the value “DELETE”. That means that this book is out of stock, so the Excelify will try to delete it from your store (searching by its Handle).T
  • This is useful if you repeat the imports several times – then it will delete whatever book are out of stock in Ingram.

Book images:

  • Notice that the “Image Src” column has links to Excelify image server.
  • You will need to upload those images so you get their links working.

6. Upload Ingram image files to Excelify Image Server

Request the access to Excelify image server by asking our support (requires you to have the Enterprise Plan).

Take your downloaded images from Ingram.

Unzip all those files so that you have the image files, which are basically named as <Barcode>.jpg.

Upload all those images to your Excelify image server folder “ingram”.

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).

7. Import your Ingram Excelify zipped CSV file to Shopify using the Excelify app

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:

Importing Ingram products to Shopify - progress

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:

Imported Ingram book to Shopify

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.
  • Contact Excelify support if you need any assistance.

 

Export Products from Shopify to eBay

Shopify to eBay export

To export your Shopify Products to eBay, follow these steps:

1. In the Excelify app “Export” section select the format “eBay: File Exchange – Advanced Template”:

Shopify export to eBay - choose eBay File Exchange - Advanced Template

2. Apply any filters if you need to export just specific Products

3. Select to include “Metafields” if you have specific values prepared in the Metafields “ebay” namespace.

Read more about the Metafield values you can prepare, in the “eBay: File Exchange – Advanced Template” fields documentation.

4. Press the “Export” button.

5. Upload the file to eBay FileExchange.

 

Good to know

  • You will have some columns filled with default values, which you might want to review and customize their values.
  • Read the detailed “eBay: File Exchange – Advanced Template” format documentation and field mapping to Shopify.

Import to Shopify from Turn14.com

Turn14 Distribution Logo

Turn14 Distribution is the dropshipper of the car and truck parts and automotive accessories.

To import Products from Turn14.com to Shopify, do the following:

1. Get your Turn14 API keys

Login to Turn14.com with your login, and go to: Control Panel -> API

Scroll down until you find the section “API Credentials“.

Turn14 API Credentials

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

https://API_CLIENT_ID:[email protected]

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

Upload from Turn14 API to Shopify

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.

Import to Shopify from Turn14 - dry run

5. Update and improve your import file

Excel file for importing from Turn14 Distribution6. Import your Excel file with Excelify

When you are done editing your Excel file, then upload and import that into the Excelify app.

 

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

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.

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

You can see all feed_product_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 “feed_product_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: “feed_product_type” in namespace “amazon” for your Products. When importing in bulk, that’s the column: “Metafield: amazon.feed_product_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.