This article is also available in:
CSV files allow you to export order information, customize order with images, product variants, product SKU... and fulfill order manually. This section will guide you on how to fulfill orders by CSV files.

In this section

A. Export your orders in CSV format
B. Import order shipping information using a CSV file
C. Enter the correct value for the Shipping Carrier field of the CSV file uploaded to the system in section B

A. Export your orders in CSV format

Before exporting, you will need details of your order information, which is available in the order CSV file. Follow our guide to fulfill your orders seamlessly:

Step by step Tutorial

From your ShopBase admin site, go to Orders > All orders.


Select Export (if you want to export orders on the current page, orders within a specific date range, or entire orders).


In case you want to export specific orders, check those orders and press Export.


You can also search for orders you want to export from in the search bar and press Export.


In the new window, set up and customize the suggested orders, then click Export to file. In which:


Store: Select the store you want to export orders.
Exports (Current page, Orders by date, All orders, Selected ... orders, Current search): Select orders you want to export information.
Export as: Select file type to export order information.
Export template: Select file template to export order information.

To export your order information, click Orders


To export transaction histories of your orders, click Transaction histories


If you want to customize information in your order export file, click Customize export fields. Choose the information you want to export from Available fields. You can also click Save to template button so that the selected fields will be saved to be a template for a later use.


For example, if you want to export orders with customized products, choose Lineitem Properties field.
Press Export to file and the system will automatically download the file containing the order information exported to your device.

B. Import order shipping information using a CSV file

From your store admin, go to Orders > All orders. Click Import tracking number


Download the sample CSV template. Fill in required information about your orders, including:

Domain: The domain name of the store with the order
Name: number of the order
Lineitem SKU: SKU codes of all products in an order
Lineitem Quantity: the number of products
Tracking Number: shipping tracking code of the order
Shipping Carrier: The unit that carries the order
Tracking URL: link to shipping tracking page of order

Note:

Name and Tracking Number are required fields. The remaining fields are optional but should be filled in so customers can track their orders easily, thereby reducing the rate of return / refund request.
Lineitem SKU field information is particularly useful for orders containing multiple products with different shipping tracking codes. It is easier for the customer to track the shipping information of the products by looking at the shipping code corresponding to the SKU for each product.

Click Choose file to upload this CSV file.



Tick Update the existing fulfillments that have the same Order Name and Lineitem SKU if you want to overwrite orders (with the same field values ​​ Name and Lineitem SKU) which have been processed before.

Tick Send a notification email to the customer if you want the system to automatically send email notifications to customers about updates related to their orders.

Click Upload file

C. Enter the correct value for the Shipping Carrier field of the CSV file uploaded to the system in section B

For orders paid via PayPal, ShopBase sellers can automatically send their order shipping information to PayPal as instructed in this article. Sending shipping information of orders to PayPal automatically saves sellers time. It does not limit PayPal's ability to receive payments (often in the case of delayed shipping information, customers package to PayPal).

When your order's shipping information is filled in with PayPal, PayPal will ask for the shipping provider. The values ​​listed below will be considered the valid PayPal carrier. You should refer to and correctly fill in the Shipping Carrier field of the CSV file uploaded to the system in section B to reduce the workload, making it convenient for automatic updating of shipping information from the system to PayPal.

China Post
China EMS (ePacket)
GLS
DPD
DPD UK
DPD Local
FedEx UK
FedEx International MailService
4PX
TNT
USPS
UPS
FedEx
DHL Express
DHL eCommerce Asia
DHL eCommerce US
Other

Note:

As for the Other value, if your carrier is not one of the 16 specified shipping carriers recorded by PayPal, you can fill in the shipping service information as Other.
If your tracking numbers record your Shipping Carrier as Other on PayPal by mistake, you can update the Carrier to the correct format, then re-fulfill orders (and select overwriting option here).



Related articles

Fulfill order manually
Insert product image in CSV file for fulfillment
Fulfill order via PrintHub
Fulfill order via Ali Dropship Connector
Fulfill order via CrossPanda
Was this article helpful?
Cancel
Thank you!