Bulk Updating Order Status (Shipped and Delivered) in OneCart

When you have dozens or hundreds of orders to move along, updating them one at a time is slow. OneCart’s Bulk Update Order Status tool lets you upload a spreadsheet of order numbers and push a status change to the marketplace for all of them at once.

Open it here: Bulk Update Order Status.

OneCart sends each change to the marketplace for Shopee, Lazada, and TikTok seller-fulfilled orders. Anything it can’t update for that stage is reported back to you and left untouched. Nothing is changed silently.

The three stages

An order moves through three stages, left to right. Each stage is a separate tab, and each tab is its own upload. You do one stage at a time.

1. Stage tabs: Ready to ship, Shipped + tracking, Delivered. Open the tab for the stage you’re doing.
2. Platform chips: each tab shows which marketplaces that stage supports. A muted chip (for example “TikTok — not here”) means that platform isn’t handled on this tab.
3. Download template: every tab has its own template with the exact columns for that stage.
4. File upload: choose your filled-in file, then click the upload button. Accepts .xlsx, .xls, or .csv, up to 2000 rows per file.

Stage 1: Ready to ship

Tell the marketplace the order is packed and ready to hand over.

• File column: order_no (no tracking numbers at this stage).
• Use this when you want to flag orders as packed before you have tracking numbers.
• Shopee only accepts a tracking number at ship time, so if you already have tracking numbers, skip straight to Stage 2.

Stage 2: Shipped + tracking

Attach tracking numbers and ship the orders.

• File columns: order_no, tracking_number, package_number.
• Leave package_number blank for a normal, single-parcel order.
• For a split order, use one row per package: repeat the order number on each row, and give each row its own tracking_number and package_number. A single tracking number is never stamped across all of a split order’s parcels.

Stage 3: Delivered

Confirm the orders were delivered.

• File column: order_no.
• Use this for your own-fleet deliveries once the parcel has reached the buyer.

Which marketplaces work at which stage

This is the part to get right. Each tab’s chips mirror the table below.

Stage 2, where all three platforms are supported:

Stage 3, where Shopee is not supported but Lazada and TikTok are:

Per-platform notes

• Shopee: ships with your tracking number at Stage 2. There is no “delivered” step for Shopee. The marketplace completes the order on its side.
• Lazada: Stage 2 submits your tracking number (buyers then see the parcel move to “Out for delivery”), and Stage 3 marks it delivered. This is for your own delivery fleet.
• TikTok: only your seller-fulfilled orders are updated. Orders that TikTok ships for you are handled by TikTok and are reported as such, not changed. TikTok uses the carrier already on the order, so there’s no carrier column in the file.

Reading the results

After you upload, OneCart takes you to a status page. Each row shows:

• Order No: the order from your file.
• Platform: Shopee, Lazada, or TikTok.
• Outcome: for example shipped, delivered, not seller-shipping, or tracking number required.

When the run finishes, you get a summary email, and the original file is saved to your Upload History on the same page, so you can always go back and check what happened.

A few tips

• Download the template from the tab you’re on. The columns differ between stages.
• Do one stage per file. Don’t mix ready-to-ship and delivered order numbers in the same upload.
• If a row comes back as tracking number required, add the tracking number and re-upload just that order through Stage 2.
• Splitting a parcel first? See Splitting an Order into Multiple Parcels in OneCart, then use one row per package in your Stage 2 file.
• Need the air waybill for those parcels? See How to Print an Airway Bill (AWB) in OneCart.

Frequently asked questions

Can I put Shopee, Lazada, and TikTok orders in the same file? Yes. OneCart routes each order to the right marketplace based on where it came from. Any order that can’t be updated at that stage (for example a Shopee order in a Delivered file) is reported and left untouched.

What happens to orders that can’t be updated? They’re never changed silently. They appear on the status page with an outcome that explains why (for example “not supported” or “not seller-shipping”), and everything else in the file still goes through.

Why can’t I mark Shopee orders as delivered? Shopee has no delivered API outside Brazil, so OneCart can’t push a delivered status to Shopee. Shopee completes the order on its own side once the buyer receives it.

My TikTok orders came back as not updated. Why? Only seller-fulfilled TikTok orders can be updated here. If TikTok is fulfilling the order for you, TikTok controls its status, and OneCart reports those rows rather than changing them.

How many orders can I upload at once? Up to 2000 rows per file, in .xlsx, .xls, or .csv format.