cancel
Showing results for 
Search instead for 
Did you mean: 

Price change from database read

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Price change from database read

Given a base price for a catalog item-

 

We need to take a membership number and apply a fixed discount.  No change if void or not a valid number.  The membership number comes from a database table.  The database is refreshed weekly.

 

We need to add a variable local fee depending on the location of the buyer- but the location is customized as a Chapter.  Perhaps all customers could be put into a customer group as the basis for adding the fee- if all customers can be forced to choose a Chapter from a drop-down during registration.

 

Essentially, we need to alter prices based on customized customer registration field data compared to a database table.