ADO.NET Provider for Lohaco

Build 21.0.7930

ItemAttributes

Retrieve information related to attribute information of the product.

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

Insert

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')

Update

Lohaco allows updates. Both ItemCd and Groupcd should be spefied

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

Delete

ItemAttributes can be deleted by providing the ItemCd and GroupCd .

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

Columns

Name Type ReadOnly References Description
SellerId String False

The Id of the seller.

ItemCd [KEY] String False

Items.ItemCd

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