SSIS Components for Yahoo Shopping

Build 20.0.7587

OrderShippings

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 OrderShippings WHERE OrderId = 'store_000001'

SELECT * FROM OrderShippings 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 an unfiltered data to be pushed.

Insert

Insert is not supported by OrderShippings

Update

Yahoo Shopping allows updates for the IsPointFix, ShipStatus , ShipMethod, ShipMethodName, ShipRequestDate, ShipRequestTime, ShipNotes, ShipCompanyCode, ShipInvoiceNumber1, ShipInvoiceNumber2, ShipInvoiceNumberEmptyReason, ShipUrl, ArriveType, ShipDate, ArrivalDate, NeedGiftWrap, GiftWrapType, GiftWrapMessage, NeedGiftWrapPaper, GiftWrapPaperType, GiftWrapName, ShipFirstName, ShipFirstNameKana, ShipLastName, ShipLastNameKana, ShipPrefecture, ShipPrefectureKana, ShipZipCode, ShipCity, ShipCityKana, ShipAddress1, ShipAddress1Kana, ShipAddress2, ShipAddress2Kana, ShipPhoneNumber, ShipEmgPhoneNumber, ShipSection1Field, ShipSection1Value, ShipSection2Field, ShipSection2Value, OperationUser columns.

Update OrderShippings set IsPointFix = 'true' , ShipStatus = 3 , ShipMethod = '1' , ShipMethodName = ' the ship method name' , ShipRequestDate = '2017-04-04' , ShipRequestTime = '01:01:01' , ShipNotes = ' shipping notes' , ShipCompanyCode = '1001' , ShipInvoiceNumber1 = 'number 1' , ShipInvoiceNumber2 = 'number 2' , ShipInvoiceNumberEmptyReason = ' reason' , ShipUrl = 'domain.com' , ArriveType = 0 , ShipDate = '2017-04-04' , ArrivalDate = '2017-04-04' , NeedGiftWrap = 'false' , GiftWrapType = '' , GiftWrapMessage = '' , NeedGiftWrapPaper = 'false' , GiftWrapPaperType = '4' , GiftWrapName = 'wrap name' , ShipFirstName = 'ship name' , ShipFirstNameKana = ' ship name phonetic' , ShipLastName = 'last name' , ShipLastNameKana = 'last name phonetic' , ShipPrefecture = 'prefecture' , ShipPrefectureKana = ' prefecture phonetic' , ShipZipCode = '980-0021' , ShipCity = 'NJ' , ShipCityKana = 'NJ phonetic' , ShipAddress1 = ' the address' , ShipAddress1Kana = 'the address phonetic' , ShipAddress2 = ' address 2' , ShipAddress2Kana = 'address 2 phonetic' , ShipPhoneNumber = '050-5578-7397' , ShipEmgPhoneNumber = '050-5578-7390' , ShipSection1Field = 'test field 1' , ShipSection1Value = 'test value 1' , ShipSection2Field = 'test field 2' , ShipSection2Value = 'test value 2' , OperationUser = 'API'  Where OrderId = 'store-10000002'

Delete

Delete is not supported by OrderShippings

Columns

Name Type ReadOnly References Description
OrderId [KEY] String False

Orders.OrderId

Order Id.

SellerId String False

Store account.

OrderTime Datetime True

The date and time when the order was made.

IsPointFix Boolean False

Used only on update.

ShipStatus Integer False

Delivery status 0: Can not be shipped 1: Can be shipped 2: Shipping in progress 3: Shipped completed 4: Receiving completed.

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

ShipMethod String False

Delivery method number: any one of postage 1 - 14, 16.

ShipMethodName String False

Delivery method name.

ShipRequestDate Date False

Desired delivery day.

ShipRequestTime String False

Delivery time desired.

ShipNotes String False

Delivery note.

ShipCompanyCode String False

Delivery company code 1000: Other 1001: Yamato Transport 1002: Sagawa Express 1003: Japan Post 1004: Seino Transportation.

ShipInvoiceNumber1 String False

Delivery slip number information of the shipping company that the store set with the tool or API.

ShipInvoiceNumber2 String False

Delivery slip number information of the shipping company that the store set with the tool or API.

ShipInvoiceNumberEmptyReason String False

NULL: (Unregistered state) 101: For direct item from manufacturer's inventory 102: For goods that do not need shipping 103: For overseas receipt items 104: For direct contact from the delivery company 105: Document number Because it is not issued (can not be tracked) because of the delivery method.

ShipUrl String False

Tracking URL of the shipping company that the store set with tools and APIs.

ArriveType Integer False

Drinking 0: Normal 1 : School order 2: Matsutake order

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

ShipDate Date False

Shipment date entered.

ArrivalDate Date False

It is the arrival date entered.

NeedGiftWrap Boolean False

Presence or absence of gift wrapping.

GiftWrapType String False

Gift wrapping type.

GiftWrapMessage String False

Gift message.

NeedGiftWrapPaper Boolean False

Whether or not.

GiftWrapPaperType String False

Works type.

GiftWrapName String False

Enter name (message).

Option1Field String True

Option field Key information (field name).

Option1Type Integer True

Option field Key information (setting).

Option1Value String True

Option field Input contents.

Option2Field String True

Option field Key information (field name).

Option2Type Integer True

Option field Key information (setting).

Option2Value String True

Option field Input contents.

ShipFirstName String False

Destination name.

ShipFirstNameKana String False

Destination name phonetic.

ShipLastName String False

Destination surname.

ShipLastNameKana String False

Destination surname phonetic.

ShipPrefecture String False

Delivery destination Prefecture In case of overseas 'Other' is entered.

ShipPrefectureKana String False

Destination prefecture phonetic.

ShipZipCode String False

Delivery addressee postal code.

ShipCity String False

Destination city / county.

ShipCityKana String False

Destination city / county phonetic.

ShipAddress1 String False

Destination address 1.

ShipAddress1Kana String False

Destination address 1 phonetic.

ShipAddress2 String False

Destination address 2.

ShipAddress2Kana String False

Destination address 2 phonetic.

ShipPhoneNumber String False

Destination telephone number.

ShipEmgPhoneNumber String False

Destination telephone number (urgent).

ShipSection1Field String False

Addressee affiliation 1 Field name.

ShipSection1Value String False

Addressee affiliation 1 input information.

ShipSection2Field String False

Addressee affiliation 2 Field name.

ShipSection2Value String False

Addressee affiliation 2 input information.

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

CollectionDate Date True

The date when Yamato Transport collected the cargo.

CashOnDeliveryTax Integer False

The tax amount for the delivery payments.

NumberUnitsShipped Integer True

The number of packages sent by Yamato Transport.

ShipRequestTimeZoneCode Integer True

Preferred delivery time zone number. Blank if not specified, 101: Morning (8:00 to 12:00), 102: 14:00 to 16:00, 103: 16:00 to 18:00, 104: 18:00 to 20:00, 105: 19:00 to 21:00.

使用できる値は次のとおりです。101, 102, 103, 104, 105

ShipInstructType Integer True

The used delivery service category. 1: Direct cooperation, 2: Via couriers, 101: Yamato P & D.

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

ShipInstructStatus Integer True

The status of orders in Yamatopic & Delivery. 0: Not applicable, 100: Shipping instruction not yet accepted, 101: Waiting for shipping instruction, 102: Cancelled shipping, 103: Shipping instruction completed. 104: Shipping completed, 105: Delivery completed, 106: Undeliverable.

使用できる値は次のとおりです。0, 101, 102, 103, 104, 105, 106

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