Get Excelify now
Get Excelify now

Import Shopify Orders in bulk, with custom line items

New Order Featured Custom Prod||Orders with custom line items|

Minimum requirements to bulk create new Shopify Orders with custom products:

You can create new orders simple and fast with Excelify. Here we will look into what are minimum requirements to create new Shopify orders with custom items.

  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. You will only need following columns to successfully create a new order with custom line item:
    • Name
    • Command
    • Line: Type
    • Line: Quantity
    • Line: Title
    • Line: Price
  3. 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.

Orders with custom line items

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.
  • You can link the order to the existing customer by using columns – “Customer: ID”, “Customer: Email” or “Customer: Phone”.

Where to go from here?