Upload multiple orders (Delivery, Return, Exchange, Cash Collection) : ShipBlu

1) Upload file:

- Fill in the mandatory columns, and the optional columns if needed, then upload the file to your ShipBlu account by clicking on Drop Excel File or Browse.

Mandatory Columns	Optional Columns
Full Name: Customer's full name.	Email: Optional, if you want to register an email for the customer.
Phone: Primary contact number for the customer.	Secondary Phone: Additional contact number for the customer.
Address Line 1: Main address details for the customer.	Products Declared Value: Optional, if you want to record the value of the products sent to the customer, especially if they have already paid.
Address Line 2: Landmark or additional details to clarify the customer’s address.	Delivery Notes: Shipment contents/product description sent to the customer.
Governorate: The governorate associated with the customer’s address.	Merchant Reference Number: Reference number for the shipment.
City: Primary subdivision after selecting the governorate.	Allowed To Open: If you allow the customer to open the shipment for inspection (without testing, measuring, or breaking it up), select "Y." If not, select "N."
Zone: Zone for the customer’s address.	Counter Drop Off: if you will dropoff the shipments to the nearest ShipBlu hub.
Package Size: Size of the package(s) used for packaging the products for the customer.	Discount Code: Enter a discount code if provided by ShipBlu.
Number of Packages: number of the package(s) used for packaging the products will be sent to the customer.

- Shipments will appear in your ShipBlu account based on the order type: shipments uploaded for delivery to the customer will appear under "Delivery Orders," while shipments uploaded for returns will appear under "Return Orders," and so on.

- Select the shipments you want to deliver to the customer and click "Request Pickup" before 1 PM for same-day pickup.

- Print the shipping label by selecting the shipments and clicking "Print Label." Be sure to package the shipments before the courier arrives.

2) Autozoning Upload:

- Fill in the mandatory columns, and the optional columns if needed, then upload the file to your ShipBlu account by clicking on Drop Excel File or Browse.

Mandatory Columns	Optional Columns
Full Name: Customer's full name.	Secondary Phone: Additional contact number for the customer.
Phone: Primary contact number for the customer.	Email: Optional, if you want to register an email for the customer.
Full Address: Complete customer address including street name, building number, floor, and landmarks to help the system determine the correct area.	Products Declared Value: Optional, if you want to record the value of the products sent to the customer, especially if they have already paid.
Cash Amount: Amount to be collected from the customer upon delivery, including shipping fees.	Delivery Notes: Shipment contents/product description sent to the customer.
Number of Packages: Number of packages used to package the products for the customer.	Merchant Reference Number: Reference number for the shipment.
Shipment Type: Type of shipment or order (Delivery, Return, Exchange, Cash on Delivery).	Allowed To Open: If you allow the customer to open the shipment for inspection (without testing, measuring, or breaking it up), select "Y." If not, select "N."
	Counter Drop Off: If shipments are delivered to a branch, select "Y."
	Discount Code: Enter a discount code if provided by ShipBlu.

- Shipments will appear in your ShipBlu account based on the order type: shipments uploaded for delivery to the customer will appear under "Delivery Orders," while shipments uploaded for returns will appear under "Return Orders," and so on.

- Select the shipments you want to deliver to the customer and click "Request Pickup" before 1 PM for same-day pickup.

- Print the shipping label by selecting the shipments and clicking "Print Label." Be sure to package the shipments before the courier arrives.

3) Fill Manually:

- Fill in the mandatory columns and any optional columns as needed. Enable autozoning area selection based on address details, then click "Submit."

- Shipments will appear in your ShipBlu account based on the order type: shipments uploaded for delivery to the customer will appear under "Delivery Orders," while shipments uploaded for returns will appear under "Return Orders," and so on.

- Select the shipments you want to deliver to the customer and click "Request Pickup" before 1 PM for same-day pickup.

- Print the shipping label by selecting the shipments and clicking "Print Label." Be sure to package the shipments before the courier arrives.

Mandatory Columns	Optional Columns
Full Name	Fragile
Phone	Open package
Full Address	Address Line 2
Order Type	Email
Number of packages	Secondary Phone
COD	Delivery Notes
	Merchant Reference Number
	Counter DropOff
	Products Declared Value
	Discount Code
	Merchant Location: If you have multiple pickup locations, specify the location for the shipment to be collected from.