close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

BottomPrice and TopPrice

Thread began 1/02/2010 5:27 pm by jebrandon343719 | Last modified 1/03/2010 9:05 am by Office Guy-172461 | 995 views | 8 replies |

jebrandon343719

BottomPrice and TopPrice

Can someone please explain how the Bottom price (and Top price) work in Power Store.

Thanks

Sign in to reply to this post

Office Guy-172461

If you are talking about a search, they would be the variables used to set the lowest price in a range and the highest price.

For example, if your customer was looking for a gift between $25 - $50:

BottomPrice = 25
and
TopPrice
= 50

Sign in to reply to this post

jebrandon343719

Product Results page

Sorry I wasn't clear. I was refering to the code on the Products_Results page.
There is a condition in the recordset I dont understand, then there is this around line 503
<?php
if($row_WADAProducts["BottomPrice"] > 0) {
echo number_format($row_WADAProducts["BottomPrice"],2);
} else {
echo number_format($row_WADAProducts["ProductWPrice"],2);
}
?>
I dont understand how a bottom or top price gets defines for a product.
Thanks

Sign in to reply to this post

Office Guy-172461

If you go to this page on the PowerStore demo, you will see where the prices are entered.

Products_Search.php

Sign in to reply to this post

jebrandon343719

Thanks

Okay, thanks

Sign in to reply to this post

Office Guy-172461

You're welcome

Sign in to reply to this post

jebrandon343719

Wholesale Price

If you dont mind, I have further question.
I have added an item to the products table for wholesale price (ProductWPrice). The idea is a 'wholesaler' logs in with a email, password and customer number. I have set this up and created a rule - memberlogeddIn. What I was planning was if this rule is passed, the products (& detail) pages will display the wholesale price(ProductWPrice) instead of ProductPrice.

I am not sure how to fit this around the Bottom Price code.

Thanks

Sign in to reply to this post

jebrandon343719

redirect

Hi,
Dont worry about my last post. I have created new Product result and details pages for wholesalers - conditional upon login. I have a new problem - to do with displaying results when a wholesale price is being used and the product has options attached.
I started a new thread for this

- Adding Items to PowerStore Products Table

Cheers

Sign in to reply to this post

Office Guy-172461

Sounds like a good way to go.

Sign in to reply to this post

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

Content

rating

Layout

rating

Ease of use

rating

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...