Excel Add-In for Yahoo Shopping

Build 24.0.9062

OrderPayments

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

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

Insert

Insert is not supported by OrderPayments

Update

Yahoo Shopping allows UPDATEs for the PayStatus, PayDate, OperationUser, PayType, PayKind, PayMethod, PayMethodName, PayNotes, NeedBillSlip, NeedDetailedSlip, NeedReceipt, BillAddressFrom, BillFirstName, BillFirstNameKana, BillLastName, BillLastNameKana, BillZipCode, BillPrefecture, BillPrefectureKana, BillCity, BillCityKana, BillAddress1, BillAddress1Kana, BillAddress2, BillAddress2Kana, BillPhoneNumber, BillEmgPhoneNumber, BillMailAddress, BillSection1Field, BillSection1Value, BillSection2Field, BillSection2Value columns. 

UPDATE OrderPayments SET PayStatus = 0, PayDate = '2108-10-10', OperationUser = 'system', PayType = 0, PayKind = 7, PayMethod = 'payment_c1', PayMethodName = 'testname', PayNotes = ' payment notes here..', NeedBillSlip = 'false', NeedDetailedSlip = 'false', NeedReceipt = 'true', BillAddressFrom = 'from address', BillFirstName = 'first name', BillFirstNameKana = 'first name phonetic', BillLastName = 'last name', BillLastNameKana = 'last name phonetic', BillZipCode = '1423', BillPrefecture = 'prefecture ', BillPrefectureKana = 'prefecture phonetic', BillCity = 'city', BillCityKana = ' city phonetic', BillAddress1 = 'address 1', BillAddress1Kana = 'address 1 phonetic', BillAddress2 = 'address 2', BillAddress2Kana = 'address 2 phonetic', BillPhoneNumber = '050-5578-7397', BillEmgPhoneNumber = '050-5578-7397', BillMailAddress = 'mail address', BillSection1Field = 'field 1', BillSection1Value = 'value 1', BillSection2Field = 'field 2', BillSection2Value = 'value 2' WHERE OrderId = 'store-10000002'

Delete

Delete is not supported by OrderPayments

Columns

Name Type ReadOnly References Description
OrderId [KEY] String False

Orders.OrderId

Order ID.

SellerId String False

Store account ID.

OrderTime Datetime True

The date and time when the order was made.

PayStatus Integer False

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

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

SettleStatus Integer True

Settlement status. 1: Settlement application, 2: Waiting for payment, 3: Payment completion, 4: Waiting for payment, 5: Completion of settlement, 6: Cancel, 7: Refund, 8: Expired, 9: Payment application, 10: Authorization error, 11: Sales cancelled, 12: Suica address error.

使用できる値は次のとおりです。1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12

PayType Integer False

Payment classification. 0: Postpay, 1: Prepay.

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

PayKind Integer False

Payment type. 0: Card, 1: Internet banking, 2: Carrier settlement, 3: Transfer, 4: Cash on delivery, 5: Convenience store, 6: Electronic money 7: Other.

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

PayMethod String False

Payment method number. payment_a 1: Credit card payment, payment_a 6: Convenience store payment (7-Eleven), payment_a 7: Convenience store payment (Others), payment_a 8: Mobile Suica payment, payment_a 9: Docomo Mobile payment, payment_a 10: au Easy settlement, payment_a 11: Soft bank collectively payment, payment_a 15: Payee, payment_a 16: Yahoo Money / deposit payment, payment_b [1-6]: bank transfer (name is free setting of store), payment_c1: Japan Post Bank (prepayment), payment_c2: Japan Post Bank (postpay), payment_c3: registered mail, payment_d1: cash on delivery goods, payment_e [1-15 ]: Free payment method name of the store, payment_z1: Full payment of points.

PayMethodName String False

Payment method name.

SellerHandlingCharge Integer True

A settlement fee for the store's burden.

PayActionTime Datetime True

Purchase history detail screen It contains the payment update date and time.

PayDate Date False

The deposit date entered in the order management tool.

PayNotes String False

The contents of the remarks column of the deposit entered by the order management tool.

SettleId String True

Settlement ID.

CardBrand String True

In case of credit card it is the card brand name (VISA etc).

CardNumber String True

Only store of original merchant store contract is available. Encrypted character string information can be acquired.

CardNumberLast4 String True

The last four digits of the credit card.

CardExpireYear String True

The expiration year of the card.

CardExpireMonth String True

The expiration month of the card.

CardPayType Integer True

Card payment classification. 1: Lump sum payment, 2: Bonus lump sum payment, 3: Ribbon payment, 4: Installment payment

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

CardHolderName String True

The name of the cardholder

CardPayCount Integer True

The number of payments in installments.

CardBirthDay String True

Card date of birth.

UseYahooCard Boolean True

Yahoo! JAPAN JCB Card Availability.

UseWallet Boolean True

Wallet availability.

NeedBillSlip Boolean False

Whether or not you wish to have an invoice when ordering entered by the purchaser.

NeedDetailedSlip Boolean False

The presence or absence of the requested statement when ordering entered by the purchaser.

NeedReceipt Boolean False

Whether there is a receipt at the time of ordering entered by the purchaser.

AgeConfirmField String True

The field name set by the store in the age confirmation field.

AgeConfirmValue Integer True

Age confirmation field numeric input.

AgeConfirmCheck Boolean True

If the box has been checked when there is an age check check box.

BillAddressFrom String False

Billing address. P: UDB home address, B: UDB work address, ship: same as the addressee, O1: others, O2: other, O3: other 3 O4: other 4 O: other input.

BillFirstName String False

Billing Name.

BillFirstNameKana String False

Billing name (phonetic).

BillLastName String False

Billing surname.

BillLastNameKana String False

Billing last name (phonetic).

BillZipCode String False

Billing Postal Code.

BillPrefecture String False

Billing address Prefecture In case of overseas 'Other' is entered.

BillPrefectureKana String False

Billing prefecture phonetic.

BillCity String False

Billing city / county.

BillCityKana String False

Billing County District Phonetic.

BillAddress1 String False

Billing address 1.

BillAddress1Kana String False

Billing address 1 phonetic.

BillAddress2 String False

Billing address 2.

BillAddress2Kana String False

Billing address 2 phonetic.

BillPhoneNumber String False

Billing telephone number.

BillEmgPhoneNumber String False

Billing telephone number (urgent).

BillMailAddress String False

Billing E-mail address.

BillSection1Field String False

Billing address Affiliation 1 Field name.

BillSection1Value String False

Billing address Affiliation 1 Input information.

BillSection2Field String False

Billing address Affiliation 2 Field name.

BillSection2Value String False

Billing address Affiliation 2 Input information.

CombinedPayType Integer False

Billing address Affiliation 2 Input information.

CombinedPayKind Integer False

Billing address Affiliation 2 Input information.

CombinedPayMethod String False

Billing address Affiliation 2 Input information.

PayMethodAmount Decimal False

Billing address Affiliation 2 Input information.

CombinedPayMethodName String False

Billing address Affiliation 2 Input information.

CombinedPayMethodAmount Decimal False

Billing address Affiliation 2 Input information.

PayNo String True

Payment number.

PayNoIssueDate Datetime True

Payment number issue date / time.

ConfirmNumber String True

Authorization number.

PaymentTerm Datetime True

Payment due date for convenience store payment, mobile Suica settlement, and payment settlement.

IsApplePay Boolean True

Availability of ApplePay.

OperationUser String False

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062