ADO.NET Provider for Lohaco

Build 21.0.7930

Orders

Returns data from a sample table.

Select

The 本製品 will use the Lohaco API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品. For example, the following query is processed server side:

SELECT * FROM Orders

SELECT * FROM Orders WHERE OrderTime >= '2018-10-19'

SELECT * FROM Orders WHERE OrderStatus = 0

SELECT * FROM Orders WHERE IsSeen = true

SELECT * FROM Orders WHERE IsRoyalty = true

SELECT * FROM Orders WHERE IsRoyaltyFix = true
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.

Update

Lohaco allows updates. Groupcd should be spefied

Update Orders set IsSeen = 'true', OperationUser = 'test' Where OrderId = 'L000000045338384'

Update OrderDetails set OrderStatus = '1', OperationUser = 'test', CancelReason = '110'    Where OrderId = 'L000000045338384'

Columns

Name Type ReadOnly References Description
OrderId [KEY] String True

Order Id.

SellerId String True

Store account.

OrderTime Datetime True

The date and time when the order was made.

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

Version Integer True

Shopping cart and IF specification version of order API.

DeviceType Integer True

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

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

IsSeen Boolean False

Viewed flag.

IsRoyalty Boolean True

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

IsRoyaltyFix Boolean True

It judges whether the order is billable. For example, for a non-billable order, specify false.

IsSeller Boolean True

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

LastUpdateTime Datetime True

It is the last modification date of order information.

RoyaltyFixTime Datetime True

Charging decision date and time.

CouponType Integer True

Coupon type 0: No coupon 1: Mall coupon 2: Store coupons.

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

StoreCouponType Integer True

Store coupon type 1: Flat-rate value discount 2: The declining value discount 3: Free shipping.

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

StoreCouponCode String True

Store coupon code.

StoreCouponName String True

Store coupon name.

OperationUser String False

Used on Updates, if updater name is not specified, system is entered.

BuyerCommentsFlag Boolean False

Flag to indicate tif the buyer has left any comments.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PrintDeliveryFlag Boolean

Flag indicating whether the invoice has been output.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930