Qoo10 Technical Scope

ℹ ### **Product flows** **Create Products** To be scoped. **Update Products** To be scoped. **Update Stock and Price** Depending on whether it's a single product or a variation group two different calls are to be used - *SetGoodsPriceQty* and *UpdateInventoryDataUnit*. The following is the mapping for the request of *SetGoodsPriceQty*: | Qoo10 | Hemisphere | | --- | --- | | ItemCode | ia_qoo_ten.itemCode | | SellerCode | i.SKU | | Price | ia.StartPrice | | Qty | ia.Quantity | | ExpireDate | Null | There is no mapping for the response of *SetGoodsPriceQty*. The errors, if any, should be stored in the proper error field depending on which flag was raised to trigger the call. The following is the mapping for the request of *UpdateInventoryDataUnit*: | Qoo10 | Hemisphere | | --- | --- | | ItemCode | ia_qoo_ten.itemCode | | SellerCode | i.SKU | | OptionName | extracted from ia.VariationSpecifics | | OptionValue | extracted from ia.VariationSpecifics | | OptionCode | TBC | | Price | ia.StartPrice | | Qty | ia.Quantity | There is no mapping for the response of *UpdateInventoryDataUnit*. The errors, if any, should be stored in the proper error field depending on which flag was raised to trigger the call. **Deactivate Product** Done via *EditGoodsStatus* call. The following is the mapping for the request: | Qoo10 | Hemisphere | | --- | --- | | ItemCode | ia_qoo_ten.itemCode | | SellerCode | i.SKU | | Status | 3 | There is no mapping for the response. The errors, if any, should be stored in the *ia.revise_item_error* field.

ℹ ### **Order flows** **Get Orders** There are two options for calls to be used for getting orders - *GetShippingInfo* and *GetShippingInfo_v2*. The difference between them is only in the parameters we supply (and not in the response we get) so we are going to implement the first one *GetShippingInfo*. It currently seems that we receive one order for each item that has been purchased and probably all items in the basket are related to each other by *RelatedOrder* parameter in the response. If this is the case we have to keep the *tool_status* as *Pending* until we get all related orders. There is no mapping for the request, we need to get all orders for a time period which clips the previous one by 5 minutes. The following is the mapping for the response: | Qoo10 | Hemisphere | | --- | --- | | shippingStatus | order.order_status | | orderDate | order.order_created_time | | PaymentDate | order.order_paid_time | | buyerEmail | order.buyer_mail | | buyer | order.billing_name | | buyerMobile | order.billing_phone | | buyerTel | order.billing_phone (if no buyerMobile) | | orderNo | order.marketplace_order_id | | sellerItemCode | order_item.item_sku | | itemTitle | order_item.item_title | | orderQty | order_item.item_quantity | | option | order_item.item_variations ??? (TBC by Yoan) | | ShippingRate | order_item.item_shipping_cost | | total | order.order_total_amount | | receiver | order.shipping_buyer_name | | shippingCountry | order.shipping_country_name or order.shipping_country_code | | zipCode | order.shipping_postal_code | | shippingAddr | order.shipping_street1 | | Addr1 | order.shipping_street2 (concat with below) | | Addr2 | order.shipping_street2 (concat with above) | | receiverMobile | order.shipping_phone | | receiverTel | order.shipping_phone (if no receiverMobile) | | ShippingWay | order.shipping_service | | PaymentMethod | order.order_payment_method | | Currency | order.order_currency | | ShippingMsg | order.note ??? (TBC by Yoan) | | DeliveryCompany | N/A | | RelatedOrder? | see above | | TrackingNo | N/A | **Accept Orders** There are two options for calls to be used for accepting orders - *SetSellerCheckYN* and *SetSelletCheckYN_V2*. The difference between them is only in the parameters we supply (and not in the response we get) so we are going to implement the first one *SetSellerCheckYN*. The following is the mapping for the request: | Qoo10 | Hemisphere | | --- | --- | | OrderNo | order.marketplace_order_id | There is no mapping for the response, should there be an error that should be logged in *order.order_error* column. Orders are accepted (also) when downloading the orders and their status in not "incomplete" and out_of_stock = 1. **Update Shipping** This is done via the *SetSendingInfo* call. This call is done for orders with tool_status = "waiting_for_delivery" and update_shipping = 1. The following is the mapping for the request for *SetSendingInfo*: | Qoo10 | Hemipshere | | --- | --- | | OrderNo | order.marketplace_order_id | | ShippingCorp | order.shipping_carrier | | TrackingNo | order.shipping_track_num | There is no mapping for the response for *SetSendingInfo*, should there be an error that should be logged in *order.update_shipping_error* column. After this call is done successfully the order_status becomes "On delivery". It is not known at the moment whether we need to confirm that the whole shipping is completed, if needed it is done via the *SetSendingComplete* call. This call should be triggered as part of the same cron that triggered the first call and should be done immediately after the first call. This call is done for orders with status "On delivery" or orders for which the previous call was successful. The following is the mapping for the request for *SetSendingComplete:* | Qoo10 | Hemisphere | | --- | --- | | OrderNo | order.marketplace_order_id | | ServiceNation | N/A | There is no mapping for the response for *SetSendingComplete*, should there be an error that should be logged in *order.update_shipping_error* column. **Cancellations** To be scoped and confirmed.

Note: Please have in mind this is not final version and will need some more work

Marketplaces / Qoo10 / Qoo10 Technical Scope

Qoo10 Technical Scope