close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Product Special Price Limited Time Offer

Thread began 7/15/2009 8:47 am by Kevin373660 | Last modified 7/15/2009 12:09 pm by Kevin373660 | 1110 views | 5 replies |

Kevin373660

Product Special Price Limited Time Offer

With the dynamic eCart configuration I would like to be able to offer special sale/limited time offer price for a specific product. This is instead of a percentage discount. I believe that this was addressed somewhere but now I cannot find the details of how to set up for this option. Should I set up a ProdSpecialPrice column in the Products table? Can someone guide me in the right direction please & thank you?

Sign in to reply to this post

Ray BorduinWebAssist

You can do it however you want to. A ProdSpecialPrice field in the database with a ProdPriceExpires date maybe to make it expire at a certain date. There are many ways you could do it. How do you want it to work?

Sign in to reply to this post

Kevin373660

Yes, using two columns ProdSpecialPrice & ProdPriceExpires date sounds like a good idea. I will include them in the tables and Admin backend to control value and date (timestamp). A simple method to set up would be best. Might be good to show regular price and the special price for the product so the customer can see the benifit. Beyond that I am not sure.

Sign in to reply to this post

Ray BorduinWebAssist

I think at that point you could add both of those values as columns in your cart.. I'll call them Expires and SpecialPrice, then set up a calculation.

UsePrice = ((strtotime([Expires]) > time())?[SpecialPrice]:[Price])

Sign in to reply to this post

Ray BorduinWebAssist

Then I forgot to mention you would also have to update the totalprice calculation:

TotalPrice = ((strtotime([Expires]) > time())?[SpecialPrice]:[Price]) * [Quantity]

Sign in to reply to this post

Kevin373660

Much appreciated Ray! I am still waiting for direction from tech support on the issues with DataAsssit. I have a lot of work once I can move ahead to create user and shopping admin backend. I will update the tables and referance this as soon as I can get using eCart.

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