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