OpenTradeCommerce Box, starting from version 1.1.3-excel-fix, provides two options of placed orders uploading into excel file.
Earlier option provides uploading of every single order. Thus, 1 order = 1 file.
To use this option, press "Export" button next to the order. System requests to save file on the computer.
Fields uploaded to the file:
Recipient’s Full Name | Recipient’s Address | Order Number | Product (Taobao link) | Color | Size | 颜色分类 | 尺码 | Product Image | Quantity | Price (w/o discount in yuan) | Price (initial price in yuan) | China Delivery (initial price in yuan) | Total product price plus cost of delivery service (initial price in yuan). |
New additional option in the specified Box version provides bulk uploading of the orders. All orders from the list on a page are uploaded in excel file.
Press "Order Uploading" upper button to the right of the list. System starts uploading orders, as shown in the figure below:
As all orders are ready to uploading, the system will request to save file on the computer.
Fields uploaded to the file:
Order id | Full name | Address | Shippment Method | Item | 颜色分类 | 尺码 | Qty | Original price (yuan) | China delivery (yuan) | Total price (yuan) |