ADO.NET Provider for Lohaco

Build 21.0.7930

OrderItems

Retrieve and update information related to order items.

Select

The {i 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 {i. For example, the following query is processed server side:

SELECT * FROM OrderItems

SELECT * FROM OrderItems WHERE OrderId = 'orderid'
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.

Insert


INSERT INTO OrderItems (OperationUser, LineId, ItemCode, Title,Quantity,  UnitPrice, OrderId)  VALUES ('test4', 4, 'cd4', 'title4', 24, 1234, 'L000000045338384')

BatchInsert

INSERT INTO OrderItems#Temp (OperationUser, LineId, ItemCd, Title,Quantity,  UnitPrice, OrderId)  VALUES ('test4', 4, 'cd4', 'title4', 24, 1234, 'L000000045338384')

INSERT INTO OrderItems#Temp (OperationUser, LineId, ItemCd, Title,Quantity,  UnitPrice, OrderId)  VALUES ('test4', 4, 'cd4', 'title4', 24, 1234, 'L000000045338384')

INSERT INTO OrderItems#Temp (OperationUser, LineId, ItemCd, Title,Quantity,  UnitPrice, OrderId)  VALUES ('test4', 4, 'cd4', 'title4', 24, 1234, 'L000000045338384')

INSERT INTO OrderItems#Temp (OperationUser, LineId, ItemCd, Title,Quantity,  UnitPrice, OrderId)  VALUES ('test4', 4, 'cd4', 'title4', 24, 1234, 'L000000045338384')

INSERT INTO OrderItems (OperationUser, LineId, ItemCd, Title,Quantity,  UnitPrice, OrderId)  SELECT OperationUser, LineId, ItemCode, Title,Quantity,  UnitPrice, OrderId FROM  OrderItems#Temp"

Update

Lohaco allows updates. Groupcd should be spefied

Update OrderItems set ItemCd = 'test2', Title = 'test3', Quantity = 25, UnitPrice = 25, OperationUser = 'test' Where  OrderId ='L000000045338384'  and LineId = '1'" 

Columns

Name Type ReadOnly References Description
SellerId String True

The Id of the seller.

OrderId [KEY] String True

The id of the order.

OperationUser String False

The registered name of the ID who performed the update.

LineId [KEY] Integer False

The id of the product line.

CtgItemCd String True

The code of the catalog.

ItemCd String False

The code of the product.

Title String False

The title of the item.

Quantity Integer False

The quantity of each product.

UnitPrice Integer False

The unit price of each product.

IsTaxable Boolean True

The flag that shows eather the item is taxable or not.

Jan String True

JAN code.

Isbn String True

ISBN code.

LlCateCd String True

Double large category code.

LCateCd String True

Large category code.

SCateCd String True

Small category code.

OriginUnitPrice Integer True

The coupon amount before applying the unit price.

UnitStoreCouponDiscount Integer True

The coupon discount amount for each product.

ReleaseDate Date True

The date of the release. If the release date is earlier than the order date, it is treated as pre-order.

IsShippingFree Boolean True

The flag that shows if item has free shipping.

UnitGetPoint Integer True

Is an unit grant point number for each product.

AddonGetPoint Integer True

Is an add-on grant point number for each product.

AddonGetPointRatio Integer True

Is an add-on grant point magnification of each product.

YjCardGetPoint Integer True

The number of points granted for card use.

YjCardGetPointRatio Integer True

The point magnification grant of card use.

TaxRatio Integer True

The consumption tax rate for each product.

ShipLeadTimeInfo String True

Estimated shipping set by the store. (Value at the time of order completion).

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