Applying Member Discount (registered users) to powerstore
I want to accomplish the following task:
Setup member discount in powerstore (deduct a certain amount when a certain condition is met) using dreamweaver. When the user is not logged in, the total discount is set to zero.
Scenario:
Step 1: A user picks out a product to order from powerstore
Step 2: On the shopping cart page the user sees their selection and it's price.
Step 3: they notice that the member discount is set to zero
Step4: to get the member discount, they just have to log in by entering their user name and password.
Step 5: they are automatically returned to the shopping cart page where a significant discount has been applied to the item.
Object: apply a member discount with an independently determine price for products or each product in powerstore.
Since member discount build customer loyalty and keep customers returning, it will be great to establish this feature to powerstore.
So far, using eCart objects, I've applied discounts for the general users. That is whether they are logged in as registered users or not, they can have certain discounts across the store.
As to the member discount these are the steps I did
Step one: In WAecart object I clicked the discount tab
Step two: selected the plus button
Step three: in the WA discount Wizard I entered "member discount" in the available name field
Step three: I selected "total number of Unique items" in the Rule Trigger under the list of items
Step four: in the Condition, I selected ">" (greater than).
Step five: I pressed the plus (+) button to set the trigger (and the following equation was generated: Total number of items >0
Step six: On the Rule Calculation section I selected " Decreased based on column subtotal" from the list
Step 7: from the column list I select" Total Discount"
I made sure that the "plus" sign is shown in the operators list and "0" was shown in the value field.
This is where I'm stuck.
So far, using eCart objects, I've applied discounts for the general users. That is whether they are logged in as registered users or not, they can have certain discounts across the store.
As to the member discount these are the steps I did
Step one: In WAecart object I clicked the discount tab
Step two: selected the plus button
Step three: in the WA discount Wizard I entered "member discount" in the available name field
Step three: I selected "total number of Unique items" in the Rule Trigger under the list of items
Step four: in the Condition, I selected ">" (greater than).
Step five: I pressed the plus (+) button to set the trigger (and the following equation was generated: Total number of items >0
Step six: On the Rule Calculation section I selected " Decreased based on column subtotal" from the list
Step 7: from the column list I select" Total Discount"
I made sure that "plus" is shown in the operators list and "0" was shown in the value field.
This is where I'm stuck.
After clicking the catalogues page for my server model (products_results.php) and clicking on the recordset WAecart (From Recordset) in the server behavior, and later clicked on the bindings tab I get a mysql error not found in the "default value field".
Question: What am I doing wrong? my server is working well, and my database functions well. Is there another way to proceed with this in powerstore?