驿氪帮助中心 - 1220 - Member sales orders upload

Scenario

External system uploads sales orders to EZR, to calculate level/points and Provide report/analysis.

Direction

External system will call EZR

Call path: api/csale/vipsaleupload

Core Logic

Only sales orders of members are accepted.

Non-member order will be rejected.

100 pieces maximum at a time

Request Parameters

Field	Type	Required	Length	Description
ShopCode	string	Yes	1~16	Shop ID
SaleNo	string	Yes	1~26	Sales orders number
RefSaleNo	string		0~26	Reference order number i.e. a return order should fill its original order number here
SaleType	string	Yes	1	S = Sales R = Return C = Change
VipOffCode	string	Yes	1~20	Member's unique code (external system)
SaleDate	string	Yes	-	yyyy-MM-dd HH:mm:ss
SaleQty	int			Total quantity
SaleMoney	double			Sales price (2digits demical)
SaleProdQty	int			Product quntity (SKU)
SaleOrigMoney	double			Tag price
SalePayMoney	double			Actual paid price (2digits demical)
UseBonus	int			Points used as cash
CalcBonus	Int			Points rewarded for this order
SalerCode	string		0~16	ID of sales person
Dtls	[]	Yes		Detail items of order
DataOrigin	Int			Source of record 0 = offline 1= WeCHat store 2 = website 5 = taobao 6 = jd
SaleCategory	Int			0:member 1:non-member

Detail of “Dtls”

Field	Type	Required	Length	Description
ProdCode	string	Yes	1~22	SKU information
RetailPrice	double	Yes		Retail price of single item (tag)
SalePrice	double	Yes		Sale price of single item (actual price)
SaleQty	int	Yes		Quantity of sold item
SaleMoney	double			Total price （RetailPrice * SalePrice)
CmdShopCode	string		0~16	No. of store as salse source
CmdSalerCode	string		0~16	No. of saler as sales source
SalerCode	string		0~16	Salesman's ID

How to process return/exchange order

Here are examples to deal with return/exchange orders. Since numbers of fields with affect related points calculation process, it is required to follow these instructions.

Original order

Body

ShopCode	SaleNo	SaleType	SaleMoney	SaleQty
S001	ORD00001	S	1200	6

Dtls[]:

ProdCode	SalePrice	SaleMoney	SaleQty
P001	100	300	3
P002	200	400	2
P003	500	500	1

Return order (only return)

Body

ShopCode	SaleNo	RefSaleNo	SaleType	SaleMoney	SaleQty
S002	ORD00002	ORD00001	R	-200	-2

Dtls[]

ProdCode	SalePrice	SaleMoney	SaleQty
P001	-100	-200	-2

1. Use SaleType = R to upload order with only returned items;

2. Use negative value for “SaleMoney” and “SaleQty”;

3. Make sure to put correct order number of original order in “RefSaleNo”;

Exchange order (return + sale)

Body

ShopCode	SaleNo	RefSaleNo	SaleType	SaleMoney	SaleQty
S003	ORD00003	ORD00001	C	800	-1

Dtls[]

ProdCode	SalePrice	SaleMoney	SaleQty
P001	-100	-200	-2
P004	1000	1000	1

1. Use SaleType = C to upload order with returned items mixed with sold items;

2. Use negative value for “SaleMoney” and “SaleQty” for returned items;

3. Make sure to put correct order number of original order in “RefSaleNo”;

Example Request (JSON)

[{

"ShopCode": "HQS0001",

"SaleNo": "000012809",

"RefSaleNo": "",

"SaleType": "S",

"VipOffCode": "EZ00001201",

"SaleDate": "2015-06-22 10:30:01",

"SaleQty": 2,

"SaleMoney": 890.00,

"SaleProdQty": 1,

"SaleOrigMoney": 890.00,

"UseBonus": 10,

"Dtls": [{

"ProdCode": "15026609123",

"ProdUID": "12389",

"RetailPrice": 450.00,

"SalePrice": 450.00,

"SaleQty": 1,

"SaleMoney": 450.00,

"SalerCode": ""

}, {

...

}]

}, {

...

}]

Example Result (JSON)

{

"Status": true,

"StatusCode": 200,

"Msg": "成功",

"Timestamp": "20150622093101",

"Sign": "6ECC9BF07C69E80F6D8552FF7B2E7A8FCA2CC80E",

"Result": 见业务返回结果示例,

}