close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Some content not showing up

Thread began 10/20/2009 2:38 pm by toby379423 | Last modified 12/02/2009 3:03 pm by toby379423 | 5245 views | 26 replies

Jason ByrnesWebAssist

yeah, this is a bit tricky. PowerStore is not set up to Force users to register, or to force them to login before they can checkout. because of this, the discount would only be applied to users that did register and then logged in prior to checking out.

you would need to add a recordset to the confirm page:

SELECT COUNT(orders.OrderID) as OrderCount
FROM orders
ON orders.OrderUserID = users.userID
WHERE users.userID = paramUserID

in the parameters section, add a new parameter as:
Name: paramUserID
data Type: Numeric
default Value: -1
Runtime value: $_SESSION['UserID']

This will count the orders that have been placed for the logged in user.

Now add a set session value server behavior.

Set the trigger to if the recordset is not empty
set the name to OrderCount
for the value, click the lightning bolt and select the orderCount recordset column.

Now in eCart create the discount. set the trigger to:
If session variable exists "OrderCount"

and based on session value:
If the Session Variable "OrderCount" has a value "=" to a value of "0"

set the discount to based on cart subtotal:
cart Subtotal "Times" "0.10"

remeber, power store will not be able to force the discount to be applied.

It will only apply if:
1) they register before placing the first order
2) They login in before placing the first order
3) It is the first order.

since power store doesn't force registering or loging in, it is up to the shopper to do thiose things to get the discount.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...