ProductMemberGroupPrices
Returns information regarding prices by member groups.
Select
The connector 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 connector.
- 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. |