Help CenterOrders

Import orders in bulk

Admin portalOrdersUpdated today

Create many orders from one Excel or CSV file, and correct many orders at once with bulk edit.

Before you start
  • Your role has the Import permission (and Edit for bulk edit).
  • One file is for one merchant. A file can hold up to 5,000 rows.
1

Open Import

There are two ways to open it.

OrdersSample screen
The page ⋯ menu
1 Import orders
Bulk edit orders
Export
Hover Create Order in the header
New order
2 Import orders
  1. From the page ⋯ menu, choose Import orders…
  2. …or hover Create Order in the header and choose Import orders.
2

Choose the merchant and download the template

Always start from a fresh template. It is built from your account.

Import ordersSample screen
Import orders✕
Al Noor Electronics ▾
2Drag a file here or click to upload · Excel or CSV · up to 5,000 rows
3Download templateCancel
  1. Merchant. Pick the merchant first. One file is for one merchant, and the package rules and order ID setting come from that merchant.
  2. Upload file. Drag a file in or click. It can be Excel or CSV, with up to 5,000 rows. You need the merchant first.
  3. Download template. Available once you pick a merchant. Choose CSV or Excel. It is built from your account, so city, area, service, payment type and the merchant’s package rules are dropdowns (in a CSV the lists are in a second sheet). Required columns are marked.
3

Fill in the file and upload it

Fill in one row per order, then upload the file.

Import ordersSample screen
2 ReferenceRecipient *Phone *City ▾ *3 AreaService ▾ *Payment ▾ *Package rule ▾COD
1 1KH-7716Khalid Al-Harbi0550123456RiyadhOlayaNext dayCODPR-102450.00
2DD-310Sara Al-Qahtani0551234567JeddahAl RawdahSame dayPrepaid4 0
3SF-2204Omar Nasser0559876543DammamFaisaliyahNext dayCODPR-102220.00
orders-nov.xlsx · 8 rows 5Upload
  1. One row per order. Fill in the recipient, phone, city, service and payment type. Mandatory columns (*) are highlighted in amber in the template. COD is a number: 0 for a prepaid order.
  2. Reference. The merchant’s own reference. If the merchant uses their own order IDs, this becomes the order ID and must be unique.
  3. Area. Type the merchant’s own wording. If it does not match your zones, an Area rule maps it for you. Area is required unless the row has a map pin.
  4. Package rule. Leave it empty to use the merchant’s default rule.
  5. Upload the file. You review it before anything is created. A file can have up to 5,000 rows.
4

Review every row

Before anything is created, you review the whole file.

Review importSample screen
Review import✕
RowRecipientCity1Result
1Khalid Al-HarbiRiyadhValid✕
2Sara Al-QahtaniJeddaCity not found 2Fix ▾✕
3Omar NasserDammamDuplicate reference 3Create anyway✕
… 5 more rows, all valid
46 of 8 rows are validCancel5Fix 2 rows to continue
  1. Result. Every row shows whether it is valid or what is wrong, for example “City not found”, “Phone number looks incomplete”, “Area isn’t in Riyadh” or “Unknown service ID”. Cells with errors are highlighted.
  2. Fix. Correct the mistake right here. Stored values, such as city, area, service and package rule, are dropdowns. Reference, recipient, phone and COD are typed.
  3. Create anyway. Use it for a duplicate reference when you want the order created.
  4. The count says how many rows are valid.
  5. The button says “Fix N rows to continue” until every row is valid, and then “Create 8 orders”. Nothing is created before that, so a batch is all-or-nothing.
5

Follow your batches

Every upload becomes a batch on Orders › Import.

Orders › ImportSample screen
All merchants ▾
New import
2Batch3TypeMerchant4Uploaded byRows5Status
IMP-0032CreateSahab FashionMerchant portal5Ready to confirm6Open ›
IMP-0031CreateAl Noor ElectronicsAdmin portal8Completed · 8 createdOpen ›
IMP-0030Bulk editSahab FashionAdmin portal12Rejected · locked ordersOpen ›
  1. Merchant filter. Show the batches of all merchants or of one.
  2. Batch. Every upload becomes a batch with its own ID, whatever its status. Orders › Import lists the uploads of your team and of your merchants.
  3. Type. Create, for new orders, or Bulk edit, for changes to existing orders.
  4. Uploaded by. The admin portal, or a merchant uploading from the merchant portal.
  5. Status. Completed, Ready to confirm, Validating, or Rejected with the reason. The batch also shows how many orders were created or updated.
  6. Open the batch to see the details: Open N orders shows Orders filtered to the batch (with a Back to Import link), Review & confirm finishes a batch that is ready, and Download error report shows what was rejected.
6

Edit many orders at once

Use bulk edit to correct existing orders with a file.

OrdersSample screen
OrderMerchantStatus
☑ORD-004822Ref KH-7716Al Noor ElectronicsNext dayOut for delivery35m · attempt 1⋯
☑ORD-004821Ref DD-310Daily Dates Co.Same dayUnassigned12m⋯
☑ORD-004819Ref SF-2204Sahab FashionNext dayIn hub3h⋯
12 selected1Update statusAssignPrint⋯Clear
Bulk edit orders
Create exception
Copy tracking links
Cancel orders
Bulk edit orders✕
2Download template with these orders
orders-edit.xlsx
4
10 updated · 2 rejected
ORD-004815 · Delivered: can’t be edited
  1. Select the orders you want to change, or filter them first and select none, then open ⋯ in the bar and choose Bulk edit orders. You can also find it in the page ⋯ menu.
  2. Download the template. It holds the orders that can be edited (locked ones are left out), with their editable fields and dropdowns. Choose CSV or Excel, change it and save it.
  3. Upload the file. Only the editable fields apply.
  4. Locked orders are rejected with the reason. The batch appears on Orders › Import, like any other batch.

Screens are simplified drawings with sample data. Your portal may look a little different, but the names and steps are the same.

Common questions

Why was my whole file refused?

A batch is created only when every row is valid. Open the review, fix the rows marked in red and try again.

Can I import orders for several merchants in one file?

No. One merchant per file.

Can I find the orders of one batch later?

Yes. Open the batch and press Open N orders, or use the Import batch and Order source filters on the Orders page.

Related guides

Create an orderEdit, cancel and correct mistakes
Was this helpful?
On this pageOpen ImportChoose the merchant and download the templateFill in the file and upload itReview every rowFollow your batchesEdit many orders at onceCommon questions