I am using multiple catalogs assigned to customers based on volume. I need to retrieve the customer specific pricing for a collection of variants. Starting with the email, how can I get the pricing for one or more variants?
I would guess the chain looks something like this:
-
Determine ContactId from email
-
Determine CompanyId from ContactId
-
Determine Locationid from Company.
-
For each location, determine Catalogs from the Location.
-
For each Catalog, determine the price for the Variants
-
Use the lowest price for an item found in any catalog.
I can’t believe this isn’t something others are doing for marketing and other purposes. TIA