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

Applying discounts to a range of products only

Thread began 9/05/2009 4:17 am by Suggs | Last modified 9/11/2009 7:01 am by CraigR | 1367 views | 7 replies |

Suggs

Applying discounts to a range of products only

Hi Folks,

Can you help me set up the discount for a selection of products only. For example, I want to be able to offer discount on a particular category of products, for example out of a whole DIY range, i want to offer the category drills a 10% discount.

Your help will be greatly appreciated.

Regards

Paul

Sign in to reply to this post

Jason ByrnesWebAssist

You would add a new column to the cart object to hold the category. For all Drills, set the value of this column to "drill". if you are going to have different discount amounts for each category, you could also add a new column to hold that value. for each item in the drills category, you would set the discountAmount column to "0.01"

Then create a calculation to calculate the discounted price for drils and the regular price for all others:
truePrice:
(abs([catagory] == 'drills') * ([Price] - ([Price]*[discountAmount]))) + (abs([catagory] != 'drills') * [Price])


and modify the Total Price calculation:
TotalPrice:
((abs([catagory] == 'drills') * ([Price] - ([Price]*[discountAmount]))) + (abs([catagory] != 'drills') * [Price])) * [Quantity]


You can find more information on manipulating prices through calculations here:
ecart_rules.pdf

Sign in to reply to this post

Suggs

Hi Jason

Thanks for this.
Ive created the column called Drills in the eCart object and also created a column called discountAmount.
ive then gone on to creating the calculations as you have stated, replacing the [catagory] with [Drills] the value is to come from a database field called SubCatID which is = 51 for drills.
From this point can you advise. Do i then go into the discounts tab in eCart and create a discount rule? and if so, can you let me know what the process is for this as im not sure how to go about it from here.

Regards

Paul

Sign in to reply to this post

Jason ByrnesWebAssist

No, you just need to create the calculations as I outlined above.

ion your cart display, change the price display with the truePrice calculation.

Sign in to reply to this post

Suggs

Hi Jason,

When I apply the calculation you describe above in eCart calculations box, all it is doing is creating this error:
Parse error: syntax error, unexpected '[' in /home/barkerde/public_html/WA_eCart/stonehouse_PHP.php on line 10


This is without adding any changes to the cart display at this stage.

Line 10 looks like this: $itmObj->TotalPrice = ((abs($itmObj->Rugs == '51') * ($itmObj->Price - ($itmObj->Price*[0.01]))) + (abs($itmObj->Rugs != '51') * $itmObj->Price)) * $itmObj->Quantity;//c

Since we started this thread, we have changed the discount to Rugs instead of drills and the column name in eCart has been setup as Rugs. Also, The SubCatID is 51. How do I assign the column to SubcatID.
Do I do this through the add to cart button?
Thanks

Paul

Sign in to reply to this post

CraigRBeta Tester

Hi Paul, try removing the square brackets around the 0.01.

(also 0.01 will only give a 1% discount, for 10% you want 0.1)

Sign in to reply to this post

Suggs

Hi Craig
Thats worked.
I just need to know how to progress this further.
We now have the calculations in place and they arent crasing out anymore, theres a column called Rugs set in the eCart object, the SubCatID from the recordset has been set to 51. I just need to know how to get the new calculation working to show the discount in the cart based on the SubCatID.
Do I need to link this to the table field in the database and if so, how am i to do this?

Thanks

Paul

Sign in to reply to this post

CraigRBeta Tester

Hi Paul.

Here are the expression which works in a test i have just done...

Where 'Category' is the column added to the eCart object and 'Venice' is the variable from the database.

On the calculations tab of the ecart object i added DiscountedPrice and changed TotalPrice. This is how they look my equivalent of your stonehouse_PHP.php page.

$itmObj->DiscountedPrice = (abs($itmObj->Category == 'Venice') * ($itmObj->Price - ($itmObj->Price*0.1))) + (abs($itmObj->Category != 'Venice') * $itmObj->Price);//c

$itmObj->TotalPrice = ((abs($itmObj->Category == 'Venice') * ($itmObj->Price - ($itmObj->Price*0.1))) + (abs($itmObj->Category != 'Venice') * $itmObj->Price)) * $itmObj->Quantity;//c


I'm a bit confused about 'Rugs', is this the description of SubCatID = 51 ?

Basically, whatever value is passed into the column name you created in the eCart object is what you need in your calculation.

good luck

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