JDBC Driver for GMO MakeShop

Build 24.0.9062

Products

Returns information related to products.

Select

The 本製品 will use the GMO MakeShop API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.

  • BrandCode, UbrandCode columns support the = operator.
  • ModifiedDate column supports the >,>=,=,<=,< operators.
  • CategoryCode pseudo-column supports the = operator.

Ordering is supported for one of CreatedDate, ModifiedDate, ProductName, Price. For example, the following queries are processed server side:

SELECT * FROM Products WHERE BrandCode = 'CD12345' AND ModifiedDate >= '2018-09-04 22:54:43+01:00' AND ModifiedDate <= '2018-09-04 23:54:43+01:00' ORDER BY CreatedDate ASC

SELECT * FROM Products WHERE UbrandCode = 'CD0012345' AND ModifiedDate > '2018-09-04 22:54:43+01:00' AND ModifiedDate < '2018-09-04 23:54:43+01:00' ORDER BY ProductName ASC

SELECT * FROM Products WHERE ModifiedDate = '2018-09-04 23:54:43+01:00' AND CategoryCode = 'CT001' ORDER BY Price DESC

Columns

Name Type Description
BrandCode [KEY] String System product code.
UbrandCode String Original product code.
CreatedDate Datetime Date and time information of product registration.
ModifiedDate Datetime Date and time information of product last modification.
IsDisplayed String Product display availability - Y: Displayed N: Not displayed.
IsMemberOnly String Members only setting.Y: This is a member exclusive product N: Not a member exclusive product
IsReducedTaxRateBrand Boolean Boolean displaying if the brand is eligible for reduced tax rate
DisplayableMemberGroups String Displayable member group names. List seperated by pipeline.
BasicCategoryCode String Code of the lowest hierarchical node of the basic category.
BasicCategoryPath String Path of the lowest hierarchical node of the basic category.
ProductID Integer Product ID.
ProductName String Product name.
Weight Integer Product weight.
Price Integer Selling price.
ConsumptionTaxRate Integer Sales tax rate.
GroupId Integer .
GroupName String .
Point String Product points.
PointType Integer Point type - 0: Absolute value of point 1: Rate with respect to price.
FixedPrice Integer List price.
PurchasePrice Integer Purchase price.
JANcode String JAN code of the product.
Vendor String Product manufacturer.
Origin String Place of origin.
IsDisplayOrigin Integer Place of origin display flag - 0: Show Origin 1: Do not.

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

Stock Integer Product quantity.
IsDiplayStock Integer Quantity display flag - 0: Do not display stock number 1: Display stock number.

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

MinimumQuantity Integer Minimum order limit.
MaximumQuantity Integer Maximum order limit.
Collections Integer Display position - 0: New item 1: Special item 2: Recommended 3: Category Recommended items.
IndividualShipping Long Individual postage setting.
IsPublishDateFrom Integer Posting date designation flag - 0: Do not set posting start date 1: Set posting start date.

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

PublishDateFrom Datetime Posting start date.
IsPublishDateTo Integer Posting end date designation flag - 0: Do not set the posting end date 1: Set posting end date.

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

PublishDateTo Datetime Posting end date.
IsDiscountRate Integer Discount use flag - 0: Enable discount 1: Disable discount.
DiscountRate Integer Discount rate percentage.
DiscountTerm String Discount period interval dates.
ItemGroup String Product group.
SearchKeyword String Product search term.
Note String Product specific display note.
OptionName1 String First name of the lowest product option.
OptionName2 String Second name of the lowest product option..
OptionGroupCode String Option group code of the lowest set product.
OptionGroupName String Option group name of the lowest set product.
NameOptionGroupId String Insert name group ID of the lowest set name insertion group.
NameOptionGroupLabel String Insert name group label of the lowest set name insertion group.
NameOptionGroupDescription String Insert name group description of the lowest set name insertion group..
ProductPageUrl String Product details page URL .
ZoomImageUrl String URL of enlarged image. Multiple product images are not displayed.
ImageUrl String Regular image URL. Multiple product images are not displayed.
ThumbnailImageUrl String URL of thumbnail image .
MobileImageUrl String Mobile image URL.
SubImage1Url String URL of additional product image 1.
IsDisplayMobileSubImage1 Integer Additional product image mobile display - 0: Display additional product image 1 on mobile, 1: Do not display.
SubImage1Content String Product image 1 description.
SubImage2Url String URL of additional product image 2.
IsDisplayMobileSubImage2 Integer Additional product image mobile display - 0: Display additional product image 2 on mobile, 1: Do not display..
SubImage2Content String Product image 2 description.
SubImage3Url String URL of additional product image 3.
IsDisplayMobileSubImage3 Integer Additional product image mobile display - 0: Display additional product image 3 on mobile, 1: Do not display..
SubImage3Content String Product image 3 description.
SubImageLayout String Layout specification - A/B/C/D.
MainContent String Main product description for PC.
MainContent2 String Additional description for PC.
MobileContent String Mobile item description.
SmartphoneContent1 String First product description for smartphones.
SmartphoneContent2 String Second product description for smartphones.
IsDisplayMobileContent String Mobile display of first description on smartphone product - Y: Display explanatory text N: Do not display explanatory text.
ProductListContent String Product description for product category.
IsDisplayProductListContent String Possibility to display product description for product category - Y: Display explanatory text N: Do not display explanatory text.
OrderPageNote String Settlement screen remarks .
IsRestockNotification String Stock notice - Y: Restocked Notification N: Not Receiving Notification.
GoogleShoppingCondition String Google shopping product status flag - New/Second hand/Refurbished.
GoogleShoppingTitle String Google shopping product name.
GoogleShoppingDescription String Google shopping product details.
GoogleShoppingOptionLayoutType String Google shopping product option display format.
GoogleShoppingIsbnCode String Google shopping product ISBN code.
GoogleShoppingBrand String Google shopping product brand name.
GoogleShoppingMnp String Google shopping product manufacturer model number.
GoogleShoppingGoogleProductCategory String Google shopping product google category.
GoogleShoppingGender Integer Google shopping product gender - 1: Male 2: Female 3: Unisex.
GoogleShoppingAgeGroup Integer Google shopping product age group - 1: Adult 2: Child.
GoogleShoppingColor String Google shopping product color.
GoogleShoppingSize String Google shopping product size.
GoogleShoppingMaterial String Google shopping product material.
GoogleShoppingPattern String Google shopping product pattern.
GoogleShoppingItemGroupId String Google shopping product group ID.
GoogleShoppingAdwordsGrouping String Google shopping product adwords group.
GoogleShoppingAdwordsLabels String Google shopping product adwords label.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
CategoryCode String Products in exactly matched categories are displayed as search results.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062