ADO.NET Provider for Lohaco

Build 21.0.7930


Retrieve information related to group recommends.


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

  • GroupCd> support the following operators: =.
For example, the following query is processed server side:
SELECT * FROM GroupRecommends

SELECT * FROM GroupRecommends WHERE GroupCd='group code'
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 a new GroupRecommends

INSERT INTO GroupRecommends(GroupCd,ItemCd) VALUES ('group code','item code')


Lohaco allows updates. Groupcd should be spefied

Update GroupRecommends set ItemCd='goodsSku001-025amonpuno' where GroupCd='group Code' AND ItemCd='scscsc'


Items can be deleted by providing the ItemCd and GroupCd .

DELETE FROM GroupRecommends WHERE GroupCd='t-hunglead-newom-sample0groupardit' AND ItemCd='goodsSku001-025amonpuno'


Name Type ReadOnly References Description
SellerId String False

The Id of the seller.

GroupCd [KEY] String False


Product group code.

ItemCd [KEY] String False

Product code.

CatalogItemCd String True

Catalog item code.

ItemName String True

Product name.

BrandName String True

Brand name.

Mprice Integer True

Manufacturer suggested retail price (tax included).

EuPrice Integer True

Normal selling price (tax included).

ItemImageInfo String True

Product image.

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.

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

SaleFlag Integer True

Sale flag.

BasketStatus Integer True

Basket status. Effective start date and time ~ sales start date and time = without basket: 1. Sales start date ~ release date = reservation: 2. Release date (sales start date / time when not set) ~ effective end date / time = basketed: 3. Others: 0.

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

StockQuantity Integer True

Stock number.If stock number is not set,0 is returned.

StockOverFlag Integer True

Order flag exceeds the number of stock.Adjust to store setting: 1. Orderable: 2. Order impossible: 3.

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

IsOverStock String True

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

Display String True

Page release. Private: 0, Public: 1.

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

SalesUnit String True

Sales unit.

SalesUnitNum String True

Number of units sold.

SalesUnitOutput String True

Sales unit (for display).

GrantPoint Integer True

Granting point (normal).

GrantAddonPoint Integer True

Granting point (add-on).

OutletFlag Integer True

Outlet flag.Outlet object: 1, Not applicable: 0.

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

Point Integer True

Point magnification (set value for each item).

PointValidityStartDate Datetime True

The point magnification validity start date of goods.Format: YYYYMMDDHH24 MISS.

PointValidityEndDate Datetime True

Point magnification of goods Effective end date month.Format: YYYYMMDDHH24 MISS.

ValidityPoint Integer True

Effective point magnification.

ApplyPointValidityStartDate String True

The applied point magnification effective date of commencement. Format: YYYYMMDDHH24 MISS.

ApplyPointValidityEndDate String True

Applied point magnification effective end date month. Format: YYYYMMDDHH24 MISS.

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