背景:订单组对应wish中间表需要调整迁移;利润需要整改
(RB_Wish_OrderInfo)的中间表 相关字段 将做移除;需求对应到
订单改造字段如下背景------------------------------------
http://pm.irobotbox.com/zentao/task-view-21278.html
{
Quantity 数量
OrderTotal 订单价格
Price 产品价格
Cost
Shipping
ShippingCost
ChinaPostSubsidyAmount
ShippingReimbursementAmount
EligibleForShippingReimbursement 判断字段,对应是否合并计划;
MerchantResponsibleRefundAmount
}
------------------------------------------------------------------------------
利润需求如下:
1. Wish 新方法 对应关系
202110310745108571711 案例
V2 V3
"quantity": "1" "product_quantity": 1
"shipping_cost": "16.1" shipping_merchant_payment ,"amount": 16.1,
"Price" "product_price" "amount": 72.02
"cost": "56.18" "product_merchant_payment" "amount": 56.18,
"order_total": "72.28" "payment_total" "amount": 72.28,
"shipping_reimbursement_amount": "0.0" "shipping_reimbursements": []
"merchant_responsible_amount": "72.28" "merchant_responsible_amount" "amount": 72.28, "refund_amount": "72.28"
"shipping": "20.64" "product_shipping_price" "amount": 20.64
"transaction_tax": "20.69" "tax_amount_in_merchant_currency" "amount": 20.69
"eligible_for_shipping_reimbursement": "False" "shipping_reimbursements": [] 该项有值则为WishPost运费
V2
1、非合并计划订单(EligibleForShippingReimbursement)不计算该项费用。
2、合并计划订单需计(EligibleForShippingReimbursement)算该项费用。
- 合并计划订单有WishPost运费(ShippingReimbursementAmount),其他收入取值WishPost运费,该费用为真实值。
- 合并计划订单没有WishPost运费(ShippingReimbursementAmount),其他收入取值本地仓派送运费,该费用非预估值。
ShippingReimbursementAmount 非空 其他收入 = ShippingReimbursementAmount"
ShippingReimbursementAmount 空值 其他收入 = 本地仓派送运费
"shipping_reimbursements": [] 非空 ,其他收入 = "shipping_reimbursements"
"shipping_reimbursements": [] 空值 ,其他收入 = 本地仓派送运费
