Fulfilling orders is an essential part of running a Shopify store. While manually fulfilling a few orders is straightforward, handling a large volume can become overwhelming and time-consuming. The StoreRobo Import/Export Suite simplifies this process, allowing you to bulk fulfill Shopify orders with CSV in a few organized steps. This guide will walk you through the process of bulk fulfilling Shopify orders efficiently, saving valuable time and effort.
Bulk fulfill Shopify orders
The bulk fulfillment process consists of three simple steps:
- Export Orders to Fulfill
- Update Fulfillment Data
- Import Updated Fulfillment Data
Use case
For this example, we will be updating the fulfillment status of all orders placed on or after August 2024.
Step 1: Export orders to fulfill
From the Shopify admin dashboard, head to Apps > StoreRobo > Export.
- Choose an export template (e.g., Shopify CSV, Google Shopping Feed) and click Proceed.
- Select Orders, pick columns, and apply filters if needed. For fulfillment updates, ensure the following columns are included in the export.
Choose to export Basic Columns, Line Items, and Fulfillments. As you aim to update the fulfillment status and not to update the entire orders, to streamline the process, only export the following columns:
Required
- Basic Columns:
- Name
- Line Items:
- Line: Type
- Fulfillments
- Fulfillment: Status
- Fulfillment: Location
Optional Columns (Recommended for better management):
- Fulfillments:
- Fulfillment: Tracking Company
- Fulfillment: Tracking Number
- Fulfillment: Shipment Status
- Fulfillment: Processed At
- Fulfillment: Send Receipt
- Optional:
- Enable Export to FTP/SFTP and set up/select a profile.
- Choose a delimiter and save the configuration as a preset.
- Click Export.
- Download the exported file.
For detailed steps and information on the order export process, refer to the article, Import / Export Shopify Orders with StoreRobo.
Step 2: Update order fulfillment-associated columns
After exporting the order data:
- Open the file in the CSV editor.
- Delete line item duplicates if you have any.
- Set all Line: Type column values to
Fulfillment Line. - Set the Fulfillment: Status to
SUCCESS. - Set the Fulfillment: Tracking Company to the name of the tracking company you are using.
- Set the Fulfillment: Location to the location name from which you want to fulfill. You can leave it empty or skip this column – then it will be fulfilled from your default store location.
- When filling out the Fulfillment: Location column, make sure you have the fulfillment location mentioned available for your store.
- If your inventory is managed by an external service, such as Amazon , creating the fulfillment for this location will trigger the fulfillment process in that service, meaning the line items are shipped to the customer.
- Set the Fulfillment: Shipment Status to
delivered. - Set the Fulfillment: Tracking Number to the tracking number for the particular Order. To set multiple tracking numbers for the same Fulfillment, list them in the same cell separated by a semi-colon(“
:“). - Set the Fulfillment: Processed At to the current date or any custom date. make sure to follow the correct date format(
2024-11-06T05:29:41Z). - Set Fulfillment: Send Receipt to
TRUEto email your customer about this fulfillment. Otherwise, set it toFALSE. - Save the updated CSV file.
- If you lack tracking numbers or any tracking data, you may leave the columns blank or exclude them from the import entirely.
- If some of the line items have already been fulfilled, this import will fulfill the remaining unfulfilled items.
Step3: Update existing orders with new fulfillment data
Return to the Shopify admin dashboard and go to Apps > StoreRobo > Import.
- Upload the updated CSV file to StoreRobo.
- Choose the corresponding delimiter.
- Preview your file to make sure the CSV is formatted correctly.
- Select the data type as Orders and click Upload.
- Under Options, Choose to Update if Orders already exist in the store.
- Click on Import.
Once the import is finished, the selected orders will be fulfilled.
