How to Migrate to Shopify Using Orderimp

Migrating to Shopify can be a frustrating and time-consuming process. Orderimp is the original and universal solution that reliably works to import order to Shopify from any other e-commerce platform. The below video is a detailed walkthrough of how to go about preparing your .csv files for import, common errors to watch out for, and a simple overview of how to use Orderimp to import your e-commerce orders into Shopify. If you want to just get to the Orderimp walkthrough, skip to 17:45 in the video below, otherwise, we begin with how to prepare your order file for migration. If you’re more of the text type, we also have a walkthrough below the video.

 

Prepare Your Shopify .CSV Order File

Download a sample Shopify .csv file here

One of the first things that you’ll want to do when getting ready to migrate to Shopify is to export your current orders into a format that Shopify can handle. If you’re not sure how to export e-commerce orders from your current platform, we have a few guides on how to free those bad boys over on our support page.

Once you have your orders liberated, you may want to transfer them into Shopify’s preferred format. Orderimp can import orders from just about any platform in the format that your other system exports, but we’ve found that sometimes the process goes just a little smoother if you transcribe them into Shopify’s format first. Here is a sample .csv in the Shopify format for your reference. Don’t worry if you don’t have all that information though! The fields that you will want to get from your other e-commerce provider are: customer name, customer address, customer email, order number, order total, SKU, item name, item description. Anything else is a bonus that will help to set up your orders with as much information as possible, but as long as you have those fields we will be able to import successfully.

Some common errors that you’ll want to watch for and correct before importing:

Customer names – make sure that every line item and every order has a customer name attached

Customer email – make sure that every order has an email attached and that the emails are valid. We often see errors where an email was imput as ‘.con’ or ‘@gnail.com’, etc. Catching these before the import will save you time later on. If you have an order without an email attached, we recommend making up a ‘dummy’ email that you can use to denote that there was no email provided.

Hidden formatting – Often when you export your orders from another e-commerce platform, especially if it was exported as an .xls file rather than a .csv file, you will find that there is some hidden formatting which can cause errors in the Shopify import. To ensure that this is removed simply open your sheet in excel or Google sheets, select all, and then locate the ‘remove formatting’ option of your preferred spreadsheet software. Once that is done, you’ll likely then need to go back and re-apply formatting to your dates columns so they correctly read as dates. When it looks good to you, download a copy as a .csv file and you’ll be ready to go.

Those three errors are the most common that we see, so fixing them before you import will save you time down the road. For anything more advanced, check out our knowledge base with more information on troubleshooting errors.

 

Import Your Orders into Shopify

Now that your .csv order file is ready to go and exported from your previous e-commerce platform, you’re set to get things going and actually start importing into Shopify. Make sure that you’ve got the Orderimp app installed in your Shopify store and then follow along below:

1. Upload your Order File in .CSV format

We prefer uploading your order file from a .csv file on your desktop, but you can also upload it from a specific URL or even via FTP if you prefer.

 

2. Choose the Header row in your file:

This is where you tell Orderimp which row contains the headings and which are the data that it should be importing. Select the radio button on the left that applies to your header row.

 

3. On the next screen click “Create Preset”

Presets are what we call the set of rules that you create for importing orders from a specific platform or type of file. Every time that you upload a file to Orderimp to be imported to Shopify, you can either create a new preset or you can select one that you previously used. So if you frequently upload files from multiple sources such as Amazon or WooCommerce to be fulfilled in Orderimp, using a saved preset will save you time on future imports. If you are just migrating your store to Shopify this once, then you can just select ‘Create Preset’ this time.

 

4. Map the columns in your file to the OrderImp fields and click “Complete”.

This is where you tell Orderimp exactly which columns hold which data. Each screen pertains to a specific part of the order, such as the Customer details, Shipping details, etc. You’ll want to double check all of this information before submitting and ensure that each column in your order file is correctly mapped here.

Here are all the fields possible to map on the presets screen:

Order Parameters Tab

  • Order Number – The customer’s order name as represented by a number. Must
    be unique.
  • Order Date – The date and time when the order was imported. This value can
    be set to dates in the past when importing from other systems. If no value
    is provided, it will be auto-generated.
  • Payment Method – The list of all payment gateways used for the order.
  • Notes / Comments – The text of an optional note that a shop owner can
    attach to the order.
  • Total Tax – The sum of all the taxes applied to the order (must be
    positive).
  • Order Subtotal – Price of the order before shipping and taxes
  • Order Total – The sum of all the prices of all the items in the order,
    taxes and discounts included (must be positive).
  • Financial status – Possible values are: “pending” (The finances are
    pending), “authorized” (The finances have been authorized),
    “partially_paid” (The finances have been partially paid), “paid” (The
    finances have been paid. This is the default value.), “partially_refunded”
    (The finances have been partially refunded), “refunded” (The finances have
    been refunded), “voided” (The finances have been voided)
  • Total discounts – The total amount of the discounts to be applied to the
    price of the order.
  • Currency – The three letter code (ISO 4217) for the currency used for the
    payment.
  • Total weight – The sum of all the weights of the line items in the order,
    in lbs.
  • Browser IP – The IP address of the browser used by the customer when
    placing the order.
  • Password: Optional – if you want to set a customer password.
    This is to import an existing customer password, some merchants requested this feature whom had customer passwords stored in another cart platform. This works for new customer accounts only.
  • Import Customers Only (Checkbox) – This is used for merchants whom are just importing customers with passwords, the second checkbox is to send them a new account welcome email.

Customer Parameters Sub-Section:

  • Accepts Marketing – Indicates whether or not the customer would like to
    receive email updates from the shop. Valid values are true and false.
  • Email – The customer’s email address.
  • Note – Extra information about the customer
  • Tags – Tags are additional short descriptors, commonly used for filtering
    and searching, formatted as a string of comma-separated values. For
    example, if an order has three tags: tag1, tag2, tag3.

Address Tab

Billing Address:

  • Address 1 – The street address of the billing address.
  • Address 2 – An optional additional field for the street address of the
    billing address.
  • City – The city of the billing address.
  • Company – The company of the person associated with the billing address.
  • Country – The name of the country of the billing address.
  • Country code – The two-letter code (ISO 3166-1 alpha-2 two-letter country
    code) for the country of the billing address.
  • First name – The first name of the person associated with the payment
    method.
  • Last name- The last name of the person associated with the payment method.
  • Name – The full name of the person associated with the payment method.
  • Phone – The phone number at the billing address.
  • State/Province – The name of the state or province of the billing address.
  • Zip Code – The zip or postal code of the billing address.

 

Shipping Address:

  • Address 1 – The street address of the shipping address.
  • Address 2 – An optional additional field for the street address of the
    shipping address.
  • City – The city of the shipping address.
  • Company – The company of the person associated with the shipping address.
  • Country – The name of the country of the shipping address.Country code – The two-letter code (ISO 3166-1 alpha-2 two-letter country
    code) for the country of the shipping address.
  • First name – The first name of the person associated with the payment
    method.
  • Last name- The last name of the person associated with the payment method.
  • Name – The full name of the person associated with the payment method.
  • Phone – The phone number at the shipping address.
  • State/Province – The name of the state or province of the shipping address.
  • Zip Code – The zip or postal code of the shipping address.

Only one of these is absolutely required. If you check the small box at the top of the screen on this page, you will be able to use the billing address details for missing shipping details and vice versa. This is handy if your previous platform only collected one of these, or if the customer didn’t provide all the information.

Line Items Tab

  • SKU – A unique identifier of the item in the fulfillment.
  • Title – The title of the product.
  • Price – The price of the item before discounts have been applied.
  • Quantity – The number of products that were purchased.
  • Lbs – The weight of the item in lbs.
  • Fulfillment status – How far along an order is in terms line items
    fulfilled. Valid values are: fulfilled, null or partial.
  • Taxable – States whether or not the product was taxable. Values are: true
    or false.
  • Total discount – The total discount amount applied to this line item. This value is not subtracted in the line item price.

Line items refer to each unique item within an order. The file format that Shopify prefers will have you place each item within an order on its own unique row in the .csv file, and a column which will specify the order number. When Orderimp imports these orders to Shopify, they will be joined together by that order number. If your order file instead uses columns for each item and defines orders by row, you will use this page to make a new ‘Line Item’ section for each set of columns that are in the file. Drop us a line here for help if this is the case for you.

Details Tab

Shipping Lines:

  • Shipping Charges – The price of this shipping method.
  • Shipping Method – The title of the shipping method.

Discount Codes:

  • Coupon / Discount Amount – The amount of the discount.
  • Coupon Code – The discount code.
  • Type – The type of discount. Can be one of: “percentage”, “shipping”,
    “fixed_amount” (default).

Tip: To mark an order as “unfulfilled”, manually type in the value “null” in the order preset for fulfillment status.

This is where you’ll specify any last details such as the shipping charges or discount code information. You can also input details for any prefixes you’d like us to add to the order numbers, or if you’d like customer emails to be sent out if these are live orders.

 

5. Review your field mappings

On the “Preview Orders” screen, you will be given a first look at how Orderimp has deciphered your order details. If the order previews look correct, click “Send to Shopify” and Orderimp will take it from there!

6. Once your import starts, watch the progress bar at the top of the screen for stats on your order import

We are currently working to make this a real-time bar, but in the meantime just refresh the page to get up-to-the-second details on how your import is going.

 

7. Go to the “Orders” screen to view orders successfully imported, orders with errors, or duplicate orders

 *Note: It is recommended that you disable order notifications before your order import to avoid excessive alerts

To disable order notifications, follow these steps in your Shopify admin:
Settings > Notifications > Order Notifications > Disable (next to existing notification)

Order notifications only apply to Shopify store users and DO NOT affect customers.

 

And that’s it! Hopefully, your import went smoothly and you now have a Shopify store full of orders, customers, and all the associated data and analytics. If you have a few errors though, don’t worry! You can click on the orders from the Orderimp orders screen and find out what happened and even edit the order right from inside the app.

For more resources on importing your e-commerce orders into Shopify, check out our knowledge base where most questions that you might have are likely to be answered! And as always, reach out at any time for additional support.

Leave a Comment