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.

For example, the following query is processed server side:

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.