Fulfill existing Orders in Bulk

Fulfill existing Shopify Orders

*In the video (0:30) Maris says to include Line Items checkbox at the export, but this is not needed anymore if you wish to fulfill the whole order. You only need to include Fulfillments checkbox.

To fulfill existing Shopify Orders, do the following steps:

Note that this will not replace the orders – this will truly update the existing ones.

  1. Export the Orders you want to fulfill – with Fulfillments included in the export.
  2. Delete all the columns and rows, leave only the following columns in your Excel file:
    • ID
    • Name
    • Command
    • Line: Type
    • Fulfillment: ID
    • Fulfillment: Status
    • Fulfillment: Shipment Status
    • Fulfillment: Tracking Company
    • Fulfillment: Tracking Number
    • Fulfillment: Tracking URL
    • Fulfillment: Send Receipt
  3. If you see many rows per Order (with the same ID and Name values) then use the Excel function to remove duplicates – you only need one row per order.
  4. Update the Excel file columns with data:
    1. Set the “Command” column values to “UPDATE“.
    2. Set the “Line: Type” column values to “Fulfillment Line“.
    3. Leave the “Fulfillment: ID” empty – because you will be creating new fulfillments.
    4. Set the “Fulfillment: Status” to “success“.
    5. Set the “Fulfillment: Shipment Status” to “delivered
    6. Set the “Fulfillment: Tracking Company” to whatever tracking company you are using. The list of tracking companies can be found here in the Orders documentation.
    7. Set the “Fulfillment: Tracking Number” to your tracking number for this Order.
    8. If you have the specific tracking URL, you can set it in the column “Fulfillment: Tracking URL“.
    9. If you want to send the e-mail to your customer about this fulfillment, set the “Fulfillment: Send Receipt” values to “TRUE”.
  5. Import the file with the orders you want to fulfill.

Good to know

  • If you don’t have tracking numbers or any other tracking data, you can leave the columns blank, or even not include them in the import.
  • If you have some of the line items already fulfilled then this import will fulfill whatever is remaining unfulfilled items.
  • If you need to partially fulfill an Order, then you need to fill in the following columns:
    • ID
    • Name
    • Command
    • Line: Type (with the value “Fulfillment Line” – essentially, just change the Line: Type from “Line Items” to “Fulfillment Line” of the exported Order)
    • Line: ID (with “Line: ID” value of the line item you need to fulfill)
    • Line: … (all the other Line: columns of the line item you need to fulfill)
    • Line: Quantity (the quantity which you need to fulfill. If you wish to fulfill all quantity for this item you can leave “Line: Quantity” empty)
    • Fulfillment: ID (set to any number, which corresponds to a fulfillment where you need to put those line items. E.g. if you have to create two fulfillments, set the number “1” for the first, and “2” for the second one).
    • Fulfillment: Status
    • Fulfillment: Shipment Status
    • Fulfillment: Tracking Company
    • Fulfillment: Tracking Number
    • Fulfillment: Tracking URL

Where to go from here?