ADO.NET Provider for Lohaco

Build 21.0.7930


Retrieve information related to attribute information of the product.


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 ItemAttributes
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.


To add an Item in an exsisting group ItemImages,ItemAttribute child tables are necessary. The insert is achived by using temp tables.

INSERT INTO ItemAttributes (itemcd,AttributeCd,AttributeValueCd) VALUES ('132131231565848898','8021','40000')


Lohaco allows updates. Both ItemCd and Groupcd should be spefied

Update Items SET ItemName='New Name' WHERE ItemCd='1231231123' AND GroupCd='group Code'


ItemAttributes can be deleted by providing the ItemCd and GroupCd .

DELETE FROM ItemAttributes WHERE ItemCd='1231231123' AND AttributeCd='attribute Code'


Name Type ReadOnly References Description
SellerId String False

The Id of the seller.

ItemCd [KEY] String False


The item code.

AttributeCd [KEY] String False

Attribute item code.

AttributeName String True

Attribute item name.

AttributeValueCd String False

Attribute value code.

AttributeValueName String True

Attribute value name.

AttributeValueAlias String False

Attribute value alias.

AttributeNo Integer False

Attribute serial number to identify the manufacturer's size.

AttributeValueText String False

Attribute value text.

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