Every morning I spend 30 minutes fitting order columns to the courier template

Built!

Courier Excel Converter connects order columns to a courier template, lets you review each order, and creates the final upload file.

Current workflow

Order exports from marketplaces like Smart Store, Coupang, and 11st all use different column orders, and each courier — CJ Logistics, Lotte, Hanjin, Logen, Korea Post — has its own upload template that differs again. So every morning, sellers open the order file and spend around 30 minutes cutting and moving the recipient, phone, and address columns into the courier template's order. Paid all-in-one management tools such as Sabangnet and PlayAuto charge a monthly fee, and Excel Power Query is hard to set up. Moving columns by hand also causes dropped leading zeros in phone numbers and missing required columns that get the upload rejected.

Solution

Courier Upload Converter

How to use

1. Upload your marketplace order file and the courier template file. 2. Once, connect the order file's columns (recipient, phone, address, and so on) to the courier template's columns. This mapping is saved in your browser. 3. Check and edit the recipient, phone, address and other values for each order, and choose any orders to leave out. 4. Check the required fields and template columns in the final preview, download the Excel file, and upload it to the courier program. The saved mapping can be reused, but the order file and the courier template have to be uploaded every time.

Example

- Input: columns with different names and orders for each marketplace, such as "Receiver" and "Delivery Address" - Result: a courier upload file where the "Receiver" column lands in the template's "Recipient" column and "Delivery Address" lands in "Address"

Open tool
View details
Limits
- If required information (phone, address) is blank in the order file, the upload will still be rejected after conversion. Fill in the original first. - The mapping is saved in the browser you use. On a different computer, you need to connect the columns again.
Cost type
Free

When a courier updates its template, a saved mapping can fall out of sync, and the tool does not detect template changes on its own. If the courier announces a template change, compare the columns of the first converted file once. Each courier also has required fields such as shipping type, box size, and item name, and an item name over the character limit gets the upload rejected — but those checks surface at the upload stage, not the conversion stage. A quick look at the converted result is still worth it.

Support

I have this problem too · 0 people

Sign in to support or ask a question

Comments

Be the first to comment.

Additional information

Delete a post made without signing in