ADO.NET Provider for Yahoo Shopping

Build 20.0.7587

OrderLineItems

Returns data from a sample table.

Select

The 本製品 will use the Yahoo Shopping API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.

  • OrderId AND SellerId support the = operator.
For example, the following queries are processed server side:
SELECT * FROM OrderLineItems WHERE OrderId = 'store_000001'

SELECT * FROM OrderLineItems WHERE OrderId = 'store_000001' AND SellerId = 'store' 
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 unfiltered data to be pushed.

Insert

To add a OrderLineItem specify the OrderId, IsQuotation, ItemId, LineId, Quantity, Title, UnitPrice columns.

Insert INTO OrderLineItems  (OrderId, IsQuotation, ItemId, LineId, Quantity, Title, UnitPrice) Values ('store-10000004', 'false', 'CD0012345', 22, 10, 'some new title test', 150) 

Batch Insert

Yahoo Shopping allows batch inserts for the same columns. OrderId should be the same in all batch records.

Insert INTO OrderLineItems  (OrderId, IsQuotation, ItemId, LineId, Quantity, Title, UnitPrice) Values ('store-10000004', 'false', 'CD0012345', 22, 10, 'some new title test 1', 150) 

Insert INTO OrderLineItems  (OrderId, IsQuotation, ItemId, LineId, Quantity, Title, UnitPrice) Values ('store-10000004', 'false', 'CD0012346', 22, 10, 'some new title test 2', 150) 

Insert Into OrderLineItems  (OrderId, IsQuotation, ItemId, LineId, Quantity, Title, UnitPrice) SELECT OrderId, IsQuotation, ItemId, LineId, Quantity, Title, UnitPrice FROM OrderLineItems#Temp

Update

Update is not supported by OrderDetails

Delete

Delete is not supported by OrderDetails

Columns

Name Type ReadOnly References Description
OrderId [KEY] String False

Orders.OrderId

Order ID.

LineId [KEY] Integer False

Product line ID.

OrderTime Datetime True

The date and time when the order was made.

SellerId String False

Store account ID.

ItemId String False

Product ID.

Title String False

Product title.

SubCode String False

The subcode of the product when this value has been set.

SubCodeOption String True

The subcode option when this value has been set. Both key & value.

IsUsed Boolean True

Indicates whether it is a used item.

ImageId String True

The product image ID.

IsTaxable Boolean True

Tax object flag.

Jan String True

Japanese Article Number code.

ProductId String True

The product code (product number/model number).

CategoryId Integer True

Category code.

AffiliateRatio String True

Store burden rate.

UnitPrice Integer False

Unit price of each item (amount after discount of store coupons) .

ItemTaxRatio Integer True

Unit price of each item (amount after discount of store coupons) .

Quantity Integer False

The quantity of each item.

PointAvailQuantity Integer True

Points to be granted quantity.

ReleaseDate Date True

Release date. This is only when there is input of release date. For release date bigger than order date, treat it as a pre-order.

HaveReview Boolean True

Product review absence flag.

PointFspCode String True

Point code by item. 10001 to 10015, 2001 to 20010.

PointRatioY Integer True

Granted Point Magnification (Yahoo! JAPAN Burden).

PointRatioSeller Integer True

Granted Point Magnification (Store Burden).

UnitGetPoint Integer True

Number of credit points granted.

IsGetPointFix Boolean True

Granted point determination flag.

GetPointFixDate Date True

Granulation point determination date. After 14 days of order date, we will set the pre-order to 14 days after release date.

CouponDiscount Integer True

Coupon discount amount.

CouponUseNum Integer True

Number of applicable coupons.

OriginalPrice Integer True

Unit price before discount.

OriginalNum Integer True

Quantity before line splitting.

LeadTimeStart Date True

Start of shipment date.

LeadTimeEnd Date True

Shipment day end.

LeadTimeText String True

Shipping date text.

CouponData String True

Store coupons.

IsQuotation Boolean False

Used only on UPDATE.

OperationUser String False

It is the registered name of Yahoo! JAPAN business ID who carried out update work.

YamatoCoopStatus Integer True

It is a status that shows the current status of the link to Yamato Transport.

使用できる値は次のとおりです。0, 1, 2, 3, 4

PickAndDeliveryCode String True

The bar code information required for delivery.

PickAndDeliveryTransportRuleType Integer True

It is an information on cargo handling.

使用できる値は次のとおりです。0, 1, 2, 3, 4, 5

YamatoUndeliverableReason String True

The reason why Yamato delivery is not possible.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587