SSIS Components for Yahoo Shopping

Build 20.0.7587

Orders

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 support the = operator.
  • SellerId DeviceType IsSeen IsSplit IsRoyalty IsAffiliate Suspect OrderStatus and StoreStatus support the = operator.
  • OrderTime supports the following operators: =,<,<=,> AND >=.
For example, the following queries are processed server side:
SELECT * FROM Orders WHERE ReadOnlyMode = 2

SELECT * FROM Orders WHERE OrderId = 'store_000001'

SELECT * FROM Orders WHERE OrderId = 'store_000001' AND SellerId = 'store' 

SELECT * FROM Orders WHERE OrderTime>'2010-07-07 00:00:00+01:00' AND OrderTime <= '2018-07-07 00:00:00+01:00' AND DeviceType = 1 AND IsSeen='true' AND IsSplit='false' AND IsRoyalty='true' AND IsAffiliate='false' And Suspect = 0 AND OrderStatus = 2
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

Insert is not supported by Orders

Update

Yahoo Shopping allows updates for the IsSeen, Suspect and StoreStatus columns.

Update Orders set IsSeen = 'true',  Suspect = 0, StoreStatus = '3' Where OrderId = 'store-10000001'

Delete

Delete is not supported by Orders

Columns

Name Type ReadOnly References Description
OrderId [KEY] String False

Order Id.

SellerId String False

Store account.

OrderTime Datetime True

The date and time when the order was made.

Version Integer True

Shopping cart and IF specification version of order API.

OriginalOrderId String True

It is the order ID when we processed the order.

ParentOrderId String True

This is the splitting order ID when order is split.

DeviceType Integer True

Device information 1: PC 2: Galaxy 3: Smartphone 4: Tablet.

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

IsSeen Boolean False

Viewed flag.

IsSplit Boolean True

Split flag.

IsRoyalty Boolean True

It judges whether it is a charge target or not. For example, for a test order, specify false.

IsSeller Boolean True

Administrator order flag. The seller ordered by Yahoo! ID registered. It displays in order management.

IsAffiliate Boolean True

It is judging whether it is an order via an affiliate.

IsRatingB2s Boolean True

Seller It is judged whether it has been evaluated or not.

ExistMultiReleaseDate Boolean True

Multiple release date available.

LastUpdateTime Datetime True

It is the last modification date of order information.

Suspect Integer False

Flag to judge mischief target, non target, and canceled. 0: non-mischievous order 1: mischievous order 2: mischievous canceled order.

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

OrderStatus Integer True

0: Not entered 1: Reserved 2: In process 3: Hold 4: Cancel 5: Complete 8: Wait for consent.

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

StoreStatus String False

It is a status that the store can set independently.

RoyaltyFixTime Datetime True

Charging decision date and time.

IsReadOnly Integer True

Read only flag. 1: Read only (cancel acceptance order) 0: Readable / writable.

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

YamatoCoopStatus Integer True

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

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

ReadOnlyMode Integer True

Property to get data that the user can be able to cancel. Supports only value 2

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

デフォルト値は2です。

TotalCount Integer True

Total number of records available.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Start Integer

Search index where to start seraching records from.

PayStatus Integer

Deposit status. 0: Waiting for payment, 1: Payment already made

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

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