ProductMemberGroupPrices
Returns information regarding prices by member groups.
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 column supports the = operator.
SELECT * FROM ProductMemberGroupPrices WHERE BrandCode = 'CD12345'
Columns
Name | Type | Description |
BrandCode [KEY] | String | System product code. |
GroupId [KEY] | Integer | Member group ID. |
GroupName | String | Member group name. |
Price | Integer | Price by member group. |
Point | Integer | Points by member group. |
PointType | Integer | Point type - 0: Absolute value of point 1: Rate according to price. |