ADO.NET Provider for Lohaco

Build 21.0.7930

Items

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 本製品.

  • ItemCd. GroupCd. LLCategoryCd, MCategoryCd and SCategoryCd support the following operators: =.
For example, the following query is processed server side:
SELECT * FROM Items

SELECT * FROM Items WHERE ItemCd ='item code'

SELECT * FROM Items WHERE GroupCd ='group code'

SELECT * FROM Items WHERE CatalogItemCd = 'catalog item code'

SELECT * FROM Items WHERE LLCategoryCd = 'categorycode'

SELECT * FROM Items WHERE LCategoryCd = 'categorycode'

SELECT * FROM Items WHERE MCategoryCd = 'categorycode'

SELECT * FROM Items WHERE SCategoryCd = 'categorycode'
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 ItemImages#TEMP (FileName) VALUES ('dog.jpg')

INSERT INTO ItemAttributes#TEMP (AttributeCd,AttributeValueCd) VALUES ('8021',40000)

INSERT INTO ItemAttributes#TEMP (AttributeCd,AttributeValueCd,AttributeNo) VALUES ('241P',40100,0)

INSERT INTO ItemAttributes#TEMP (AttributeCd,AttributeValueCd) VALUES ('1011',40700)

INSERT INTO Items (ItemCd,GroupCd,ItemName,ItemNameKana,Price,ValidityEndDate,ValidityStartDate,SaleEndDate,SaleStartDate, OutletFlag,StockOverFlag,RepresentativeFlag,DeleteFlag,SalesUnitNum,LinkedItemImages,LinkedItemAttributes) VALUES ('123456789987523565665','t-hunglead-newom-sample0groupardit','test api ardit','test api ardit kana ',123,'2018-11-30','2018-11-09','2018-11-30','2018-11-09', 0, 1,0,0,3,'ItemImages#TEMP','ItemAttributes#TEMP')

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

Items can be deleted by providing the ItemCd and GroupCd .

DELETE FROM Items WHERE ItemCd='1231231123' AND GroupCd='group Code'

Columns

Name Type ReadOnly References Description
SellerId String False

The Id of the seller.

ItemCd [KEY] String False

Product code.

GroupCd String False

Groups.GroupCd

Product group code.

CatalogItemCd String True

Catalog item code.

ItemName String False

Product name.

ItemNameKana String False

Product name (phonetic).

ValidityStartDate Datetime False

Effective start date.

ValidityEndDate Datetime False

Expiration date.

ReleaseDate Datetime False

Release date.

SaleStartDate Datetime False

Sales start date.

SaleEndDate Datetime False

End of sale.

SaleMax Integer False

Maximum number of purchases.

OriginalPrice Integer False

Manufacturer suggested retail price (tax included).

Price Integer False

Normal selling price (tax included).

Taxable Integer False

Taxable. Tax exemption: 0, Taxable object: 1.

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

DiscountRate Integer True

Discount rate.

SpCodes String True

Promotional codes.

StockQuantity Integer True

Stock number. If not set, 0 is returned.

StockOverFlag Boolean False

Order flag exceeds the number of stock. Orderable: true, order impossible: false.

IsOverStock String True

Excess purchase settings (seller set value).Purchase exceeding inventory quantity is impossible: false. Purchase exceeding inventory quantity is possible: true.

Jan String False

JAN code.

Isbn String False

ISBN code.

NewArrivalsDate Datetime False

New arrival date and time information.

NewArrivalsFlag Integer True

New arrival flag. If the current date and time is within 2 weeks from the new arrival date and time, it is new arrival. Others: 0, New arrival: 1.

Point Integer False

Point magnification (set value for each item).

ValidityPoint Integer True

Effective point magnification.

PointValidityStartDate Datetime False

The point magnification validity start date of goods.

PointValidityEndDate Datetime False

Point magnification of goods Effective end date month.

ApplyPointValidityStartDate Datetime True

The applied point magnification effective date of commencement.

GrantPoint Integer True

Granting point (normal).

GrantAddonPoint Integer True

Granting point (add-on).

ApplyPointValidityEndDate Datetime True

Applied point magnification effective end date month.

BasketStatus Integer True

Basket status.

SaleTaxRate Integer True

Sales tax rate.

SaleTaxType Integer False

Sales tax Type.

SalesUnit String False

Sales unit.

SalesUnitNum Integer False

Number of units sold.

SalesUnitOutput String True

Sales unit (for display).

LLCategoryCd String True

Double large category code of the representative category.

LLCategoryName String True

Double large category name of the representative category.

LCategoryCd String True

Large category code of the representative category.

LCategoryName String True

Large category name of the representative category.

MCategoryCd String True

Medium category code of the representative category.

MCategoryName String True

Medium category name of representative category.

SCategoryCd String True

Small category code of the representative category.

SCategoryName String True

Small category name of the representative category.

RepresentativeFlag Integer False

Representative product flag, used on Insert. There can be only one representative product in one product group. Non-representative: 0, Representative: 1.

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

OutletFlag Integer False

Outlet flag. Outlet object: 1, not subject: 0. When the discount rate is less than 30% (setting file), it can not be set as outlet target (1).

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

LinkedItemImages String False

Date and time information on the reflection.

LinkedItemAttributes String False

Date and time information on the reflection.

LinkedItemDisplayAttributes String False

Date and time information on the reflection.

LinkedItemAxisAttributes String False

Date and time information on the reflection.

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
GroupName String

Filter by product grup name.

PromotionalCd String

The promotional code.

Status Integer

Registration status. 1: Operation, 2: Waiting for reflection, 3: Temporary storage. Defaults to 1.

RequestType Integer

Request type. 1: Seller tool, 2: Front. Defaults to 1.

DeleteFlag Integer

Outlet flag. Outlet object: 1, not subject: 0. When the discount rate is less than 30% (setting file), it can not be set as outlet target (1).

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

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