1. Go to Orders.
2. Select your channel orders (e.g. Shopee Malaysia).
3. Tick on the checkbox beside the Order Ref Number to select the orders that you would like to export.
4. Then, click Export to Excel button. The Excel file will be auto-downloaded to your desktop.
5. The following details describes the format of the Excel file that will be created when you export orders:
I. Order Ref: The order reference / ID.
II. Account: Number of your channel account.
III. Order Creation Date: The date when the payment was captured for the order.
IV. SKU No: The item SKU number.
V. Marketplace: Marketplace channel.
VI. Marketplace Nickname: Marketplace channel nickname.
VII. Product Name: The name of the product item.
VIII. Order Status: Whether the order Ready To Ship, Shipped, Completed, Unpaid, Cancelled, and Return.
IX. Payment Method: The payment method used to pay the order.
X. Item Price: The price of the product item purchased.
XI. Quantity: The quantity of the product item purchased.
XII. Item Tax: The cost of the product item tax.
XIII. Item Tax Rate: The total cost of the product item tax.
XIV. Item Tax Type: The type of the product item tax (Inclusive or Exclusive)
XV. Product Subtotal: The order's subtotal before shipping and taxes.
XVI. Discount: The amount of the discount applied to the order.
XVII. Shipping Fee: The total cost of the shipping fee.
XVIII. Shipping Tax: The total cost of the shipping tax.
XIX. Shipping Tax Type: The type of the shipping tax (Inclusive or Exclusive)
XX. Coin: Shopee coin.
XXI. Grand Total: The total cost of the order.
XXII. Billing Name: The first and last name from the customer's billing address.
XXIII. Billing Phone: The customer's billing phone number.
XXIV. Billing Address: The full line of the billing address.
XXV. Billing Postcode: The customer's billing address postal code.
XXVI. Billing City: The customer's billing address city.
XXVII. Billing State: The customer's billing state or province.
XXVIII. Billing Country: The customer's billing country.
XXIX. Receiver Name: The first and last name of the customer's name.
XXX. Receiver Phone: The customer's phone number.
XXXI. Shipping Address: The full line of the shipping address.
XXXII. Shipping Postcode: The customer's billing shipping postal code.
XXXIII. Shipping City: The customer's shipping address city.
XXXIV. Shipping State: The customer's shipping state or province.
XXXV. Shipping Country: The customer's shipping country.
If you have any issues or questions, please drop us an email at email@example.com