ShippingInfo
Returns data regarding shipping info. ShippingStatus column is required to be specified for this view.
Select
The 本製品 will use the Qoo10 API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.
- ShippingStatus supports the '=' operator.
- SearchCondition supports the '=' operator.
- Date supports the '=', '<' and '>' operators.
SELECT * FROM ShippingInfo WHERE ShippingStatus = '1' SELECT * FROM ShippingInfo WHERE ShippingStatus = '3' AND SearchCondition = '2' AND Date > '2017-04-24' AND Date < '2019-04-23'You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.
Columns
Name | Type | Description |
ShippingStatus | String | Status of the shipping. 1 : Waiting for Shipping 2 : Request Shipping 3 : Check Order. |
SellerID | String | Id of the seller. |
OrderNo [KEY] | String | Code of the order. |
DeliveredDate | Datetime | Date of the delivery. |
SellerItemCode | String | The code of seller. |
SellerDiscount | Decimal | The code of seller. |
ItemTitle | String | Title of the item. |
ShippingCountry | String | Country specified for shipping. |
EstShippingDate | Datetime | Est Shipping date. |
ShippingDate | Datetime | Shipping date. |
ZipCode | String | ZipCode. |
ShippingAddr | String | Shipping address. |
Addr1 | String | First address. |
Addr2 | String | Second address. |
HopeDate | String | Hope date. |
ShippingWay | String | ShippingWay. |
ShippingMsg | String | Message of the shipping. |
ShippingRate | Decimal | Rate of the shipping. |
ShippingRateType | String | Rate type of the shipping. |
SellerDeliveryNo | String | Number of the delivery. |
DeliveryCompany | String | Delivery company. |
TrackingNo | String | Invoice number. |
Gift | String | Gift. |
BranchName | String | Branch name. |
PickupAddress | String | Pickup address. |
PickupzipCode | String | Pick up zip code. |
SearchCondition | String | Inquiry Date Type. 1: (Order date), 2:(Payment date), 3 :(Shipping date), 4 :(Delivered date). Default :1. |
Date | Date | Date range. |