Importing products from another ecommerce platform

Importing products from another ecommerce platform

In Shopit, you can choose from 3 ways to enter your products:
  1. Manual add (there are 2 examples you can edit)
  2. Import a csv using our template
  3. Import from another platform e.g. Shopify
It is important to remember that whilst Shopit has a default product record structure (Product Title, Description, Cost Price etc), you can also add custom fields to make it match your incoming data.

Before you begin, it is important to have an understanding of Product Types

Here we will show you how to add products from another ecommerce platform using our Migration Tools.


Shopify Migration Tool

We have built an automatic tool to speed up migration from Shopify, which will pull across all product information and images. 



  1. Click "Apps"
  2. Scroll to the bottom of the page and click "Manage private apps"
  3. Click "Create a new private app"
  4. Enter an app name and email address
  5. Ensure "Read access" is granted for "Products, variants and collections"
  6. Click "Save"
  7. Confirm app creation on prompt
  8. You will be redirected to a page with an "API key" and "Password" to enter below
  9. Once all your products have been imported it is safe to delete the Shopify app, you can recreate later if needed

Amazon Migration Tool

This tool is currently in beta testing.

EKM Migration

Although EKM seem to maintain a far more complex data structure, importing your products from their system is relatively simple as many columns can be ignored.  

Firstly, you will need to export from EKM:
  1. Ensure that the Import/Export add-on is installed on your EKM shop
  2. Proceed to export all products, categories and images.
Next, export a template of the  Shopit data structure:
  1. Go to Settings > Import/Export
  2. Export Products
  3. This will export anything you have added, and/or the default products you are given by us
EKM has a maximum total 53 columns - Shopit has 37 to begin with, including multiples images and EAN/MPN/ASIN information if available. (Check out Using Custom Product Fields for creating fields for your additional data). 

We can help - we can import your EKM data in a fraction of the time it might take for you to learn it - contact us 

Importing from another eCommerce Platform

1. Compare Data and Create Custom Fields


All platforms have their own default database structure with a differing array of fields (or columns when viewing as a spreadsheet). Shopit allows you to customise our default structure so you can import as much information as required.

Example:
  1. Shopit gives you columns A B C D E F
  2. Your import has columns A C D F G H J K L M
If your product information requires additional columns (that may be shown on the front end sales channel):
  1. Go to Settings - Products - Add Custom Field
  2. Export Products to see the new columns
We recommend that you spend some time moving your existing data into the matching Shopit columns, and make sure the data type is correct (i.e. for 'Taxable', we accept a 'y' or 'n').

If you need help, reach out to our Onboarding Team

2. Import and Validate your Data

When you are happy with your data matching the (new) Shopit database structure
  1. Go to Settings - Import/Export
  2. Choose Import Products
  3. Upload your file
  4. On the next screen, choose which Sales Channel you want to import into
  5. You will be given the option to validate the incoming columns, against the existing Shopit columns for example:


  1. Once matched and imported you will then be given a Status Check which highlights data that can be successfully imported, and data that does not match the requirements and has errors.



  1. Once all data can be successfully imported, the import process can successfully begin.
  2. You will be given a notification once complete.