Update Sales Order B2C

Field

Data Type

Description

Note

warehouse_id

String(20)

Warehouse code assigned

Example: WH-TGR04

Mandatory

seller_nick

String(20)

Seller Nick Name

Please Fill with Empty String

so_number(60)

String

Sales Order Number

Example: SALES-OUTBOUND-1X

Mandatory

order_identification_code

Integer

Public Order Identification 1: Pending Shipment

Mandatory

internal_order_status

String(45)

Client’s ERP order status

Mandatory

express_code(100)

String

Courier Code

Optional

tenant_name

String(200)

Client Name

Mandatory

consignee

String(300)

Consignee Name

Mandatory

consignee_phone

String(300)

Consignee Phone

Mandatory

mobile

String(300)

Consignee Mobile Phone

Please Fill with Empty String

consignee_email

String(200)

Consignee Email Address

Mandatory

consignee_full_address

String(800)

Consignee Full Address such as street no, district, city, province

Mandatory

consignee_state

String(30)

Consignee State

Mandatory

consignee_province

String(50)

Consignee Province

Mandatory

consignee_city

String(50)

Consignee City

Mandatory

area

String(100)

Area Name

Please Fill with Empty String

town

String(30)

Town Name

Please Fill with Empty String

zipcode

String(20)

Consignee ZIP Code

Mandatory

consignee_doc_type

Integer

Consignee ID Type,

1: ID card,
2: Passport,
3: Other

Optional

consignee_doc_no

String(255)

Consignee ID number

Optional

notice_send_date

yyyy-MM-ddTHH:mm:ssZ

Sales Order Appointment Date

Optional

trans_priority

Integer

Transfer order priority

Optional

seller_flag

String(10)

Platform order flag

Optional

buyer_remark

String(500)

Buyer Remarks

Mandatory

seller_remark

String(200)

Seller Remarks

Mandatory

order_price

Decimal(10,2)

Sales Order Price

Mandatory

pre_tax_price

Decimal(10,2)

Pre-tax amount

Optional

tax_price

Decimal(10,2)

Withholding tax

Please Fill with 0 (Zero)

discount_price

Decimal(10,2)

Discounted price

Please Fill with 0 (Zero)

postage

Decimal(10,2)

Delivery Cost from the courier or 3PL

Mandatory

cod_price

Decimal(10,2)

Cash on Delivery for the sales order

Mandatory

order_time

yyyy-MM-ddTHH:mm:ssZ

Sales Order Created Date Time

Mandatory

payment_time

yyyy-MM-ddTHH:mm:ssZ

Payment time

Please Fill with Empty String

invoice_type

Integer

Invoice Type,

0: No Invoice,
1: Ordinary Invoice,
2: VAT Invoice

Please Fill with 0 (Zero)

invoice_title

String(200)

Invoice Title

Please Fill with Empty String

invoice_content

String(300)

Invoice content

Please Fill with Empty String

invoice_amount

Decimal

Invoice amount(10,2)

Please Fill with 0 (Zero)

payment_type

Integer

Payment Type,

0: Non-Cash on Delivery,
1: Cash on Delivery

Mandatory

payment_way

String(20)

Payment Method Code

Mandatory

distribution_status

String

Whether is it a distribution order

Mandatory

plat_last_changed

yyyy-MM-ddTHH:mm:ssZ

Last update time of order from client’s ERP

Mandatory

distribution_mode

Integer

Distribution mode,

1: Consignment,
2: Distribution

Please Fill with 0 (Zero)

distribution_name

String(255)

Distributor name

Please Fill with Empty String

express_no

String(60)

AWB Number

Optional

payment_number

String(40)

Payment serial number

Please Fill with Empty String

gross_weight

Decimal(10,2)

Gross weight

Please Fill with 0 (Zero)

paint_marker

String

Big head pen

Please Fill with Empty String

express_print_data

-

-

Please Fill with Empty String

DETAILS

oid

String(100)

Platform sub-transaction number

Please Fill with Empty String

title

String(30)

Title of commodities on the platform

Please Fill with Empty String

sku

String(40)

SKU Code. 1 SKU Code map to 1 UoM. Example 1 Carton and 1 Pack of the same Goods will use different SKU Code at WMS and OMS

Mandatory

order_qty

Integer

Order Quantity. 1 SKU Code map to 1 UoM

Mandatory

goods_price

Decimal(10,2)

Goods Price

Please Fill with 0 (Zero)

avg_money

Decimal(10,2)

Average Money

Please Fill with 0 (Zero)

tax_price

Decimal(10,2)

Tax for The Goods

Please Fill with 0 (Zero)

discount_price

Decimal(10,2)

Discound Amount

Please Fill with 0 (Zero)

return_status

Integer

Refund Status

Please Fill with 0 (Zero)

sku_properties

String

Commodity specifications

Please Fill with Empty String

net_weight

Decimal

Net weight

Please Fill with 0 (Zero)