In our company we set different prices for different buyer groups. (Think Retailer, Distributor, Gov't, National Store, etc). By default Hubspot only allows one price to exist and the only workaround currently is to either create discount codes or multiple variants. The discount code wouldn't work as it isn't a flat discount percent across the SKUs to go from one group to the other. Using multiple variants would lead to having 1000's of products and will almost guarantee that mistakes will be made by the sales team when entering deals. Ideally, if we could have a lookup table that takes the SKU + 1 other field to pick the correct price, that would be the most efficient and error proof.
...read more