In AMP, you can create Exclusive Price Lists to assign different pricing tiers to specific customers or reps. This can be done for tiered pricing (multiple customers accessing the same price level) or customer-specific pricing (unique pricing for individual customers).


Follow the steps below to create and assign Exclusive Price Lists.


Steps to Create an Exclusive Price List:

1. Add a Column for Exclusive Prices in Your Product Table:

  • First, add a column in your Product Table to store the exclusive prices for each product.
  • You can name this column something descriptive, such as Exclusive Price, or something that fits your pricing structure (e.g., Special Discount Price).

2. Tag the Column as "Exclusive Price":

  • After adding the column, tag it as Exclusive Price. This tag will identify the column as containing exclusive pricing for specific customers or reps.


3. Add a Column for Price List Access in Your Customer Table:

  • In your Customer Table, add a new column that specifies which price lists the customer or rep can access.
  • Tag this column as Allowed Rep Price Lists or Allowed Buyer Price Lists, depending on whether you are setting this up for reps or buyers.



4. Assign Exclusive Price Lists to Customers or Reps:

  • In the Allowed Rep Price Lists or Allowed Buyer Price Lists column, enter the exact name of the column you tagged as Exclusive Price.
  • For example, if you named your exclusive price column "West Coast Warehouse," enter "West Coast Warehouse" in this field.
  • Ensure that the names match exactly. Any discrepancy will prevent the customer/rep from accessing the correct price list.


5. Add Additional Price Lists (Optional):

  • If you want to assign multiple price lists to a customer or rep, you can separate each price list name with a comma.
  • For example, if a customer should have access to both the "Wholesale Price" and "5% Special Price", enter "Wholesale Price, 5% Special Price" in the Allowed Rep Price Lists or Allowed Buyer Price Lists column.



6. Handling General Price Lists:

  • If the customer or rep should have access to General Price Lists in addition to the exclusive ones, you must also add those to the Allowed Rep Price Lists or Allowed Buyer Price Lists column.
  • Note: If you leave the column blank, the customer or rep will have access to all general price lists by default.
  • Once you enter any price list names in this column, the customer/rep will only be able to view the price lists you’ve specified, so make sure to add any relevant general price lists as well.


Key Points to Remember:

  • Exclusive Price Lists allow you to assign custom pricing to specific customers or reps.
  • General Price Lists are accessible to all customers unless restricted by the Allowed Rep Price Lists or Allowed Buyer Price Lists column.
  • If you want customers or reps to have access to multiple price lists, use commas to separate the list names.
  • Ensure the column names are entered exactly as they appear in your product table to avoid errors.



By following these steps, you can create Exclusive Price Lists tailored to your specific customers and reps, ensuring they see the appropriate pricing in AMP.