Fulfill existing Shopify 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 Shopify Orders, do the following steps:

  1. Export the Orders you want to fulfill.
  2. Delete not needed columns.
  3. Delete duplicated rows.
  4. Update fulfillment data.
  5. Import updated Excel file with Excelify App.

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

Export orders for Fulfillment

Download and open exported file

2. Delete unnecessary columns

Leave only the following columns in your Excel file:

    • ID
    • Name
    • Command
    • Line: Type
    • Fulfillment: ID
    • Fulfillment: Status
    • Fulfillment: Tracking Company
    • Fulfillment: Location
    • Fulfillment: Shipment Status
    • Fulfillment: Tracking Number
    • Fulfillment: Tracking URL
    • Fulfillment: Send Receipt

Delete unnecessary columns

3. Delete unnecessary rows

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 column 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: Tracking Company” to whatever tracking company you are using. The list of tracking companies can be found here in the Orders documentation.
    6. Set the “Fulfillment: Location” to the location name (or custom fulfillment service name) from which you want to fulfill. You can leave it empty or skip this column – then it will fulfill from your default store location. Important: If your inventory is managed by an external service, like Amazon or Oberlo – then using this location to create the fulfillment, will actually initiate fulfillment in that fulfillment service – meaning, it will ship those line items to the customer.
    7. Set the “Fulfillment: Shipment Status” to “delivered“.
    8. Set the “Fulfillment: Tracking Number” to your tracking number for this Order.
    9. If you have the specific tracking URL, you can set it in the column “Fulfillment: Tracking URL“.
    10. If you want to send the e-mail to your customer about this fulfillment, set the “Fulfillment: Send Receipt” values to “TRUE”.

Update orders to fulfillSave the updated Excel file!

5. Import the file to fulfill Shopify orders

Import the file with the orders you want to fulfill.

Import file with fulfillments

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 get the error “Failed. Line Items: must be stocked at the same location” then you either need to specify the location from which to fulfill the items or the location you specified doesn’t have those items stocked in it – then you need to choose another location to ship them from.
  • If you want to make fulfillments go out from another Location / Fulfillment Service, you should first change the Fulfillment Service for those Product Variants to that Fulfillment Service, and then create those fulfillments for Orders.
  • 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: Location
    • Fulfillment: Tracking Company
    • Fulfillment: Tracking Number
    • Fulfillment: Tracking URL

Where to go from here?