Import Shopify Orders in bulk, with your store Products as line items

Min New Order featured

Minimum requirements to bulk create new Shopify Orders with Products from your store:

You can create new Orders with the Excelify app. Here we will look into what are the minimum requirements to create new Shopify orders with Products that exist in your store and therefore – are linked to those Products.

  1. Construct an Excel file. First, we need to have the correct name of the sheet.
    • If you are using CSV file then file name needs to be ‘Orders.csv’
    • If you are using Excel xlsx file, then sheet/tab name needs to be ‘Orders’
  2. Then, we need to add the main columns required to create any order:
    • Name
    • Command
    • Line: Type
    • Line: Quantity
  3. To add an existing Product we will need to identify the Product (and variant if the Product has Variants with options):
    • To identify Product we will need at least one of the following columns:
      • Line: Product ID
      • Line: Product Handle
    • To identify Variant we will need at least one of the following columns:
      • Line: Variant ID
      • Line: Variant Title
      • Line: SKU
  4. Import the file with the Orders you wish to create. By using this minimalist approach of creating Orders their status will be ‘Paid’ and ‘Unfulfilled’. There will be no Customer, Shipping or Billing information yet.

Examples:

  • New Order file for an existing Product by using Product Handle and Variant SKU:Order with your products 1
  • Order file for existing Product without Variants or options by using Product Handle:

Orders with your products 2

Good to know

  • Your Excel sheet (tab) name must be “Orders” – for the app to know that you are importing Orders.
  • In case you are importing from CSV file then your CSV file name must be “Orders.csv” – for the app to know that you are importing Orders.
  • If you need to delete the Shopify Orders, you can do it like explained in this tutorial.
  • To repeat importing the same Orders several times, set the “Command” column to “REPLACE” – that will delete the existing Order each time before importing the new one again.

Where to go from here?