How to add additional costs to a product and add it as a sum charge in the cart

I've got shop that sells different kinds of bottles (wine, whisky, vodka,etc). Some of the bottle have a recycling fee. The amount of the fee differs from product to product.

What I need to achive is adding the recyling fee multiplied with the amount of each of the products added to the cart. All the recycling fees of all products should be shown as a sum in a charge row in the cart (just like a shipping tax):

product1 5x 5 cents
product2 3x 10 cents
product1 8x 0 cents
...
recyling tax: 55 cents
...

I can't find a way to achieve this. Can anyone please give me a hint how to solve this problem?

create a new cart column to hold the recycle fee. for the sake of example, call the column "RecycleFee"


then in the cart object, add a new calculation as:
Name: RecycleTotal
[RecycleFee] * [Quantity]


On the charges tab, add a new charge.

set the trigger to Total number of items in cart greater than 0

for the calculation use:
"Based on column Subtotal"
Subtotal of Column "RecycleTotal" "Plus" "0"

Works perfectly. Thanks Jason!

ASP / VBScript / DW8 / eCart 4.5.2

We are looking for a similar solution but for a flat rate gift wrap option for products. We've copied the example above, as it sounded exactly like what we're after, but RecycleTotal isn't appearing in the sub-total of column drop-down menu?

Including the GiftWrapFee cart column we've created we have 8 other custom columns - is there a limit? If so, might this be causing the problem?

Are we approaching this correctly? There is a flat fee of £3.95, per item, for gift wrapping so we were trying to add the checkbox as a currency value but were having problems with it when users don't select gift wrapping and, therefore, no numerical value was being applied.

Would appreciate some guidance on how best to add a gift wrap option.
Thank you.
NJ

This is no limit to the number of cart columns you can add.

You should have a cart column named giftwrap, set the checked value for this column to 1

on the charges tab, create a new charge as:

Trigger:
"Number Of Items With A Specific Column Value"
If the Total Number of items where "giftwrap" has a value of "1" is ">" a value of "0"

calculation:
"Based on items with a specific value"
Total of "Quantity" where "giftwrap" has a value of "1" "times" "3.95"

Hi Jason,

Thank you for getting back in touch on this.
We're getting as far as this...

Originally Said By: Jason Byrnes

  calculation:
"Based on items with a specific value"
Total of "Quantity" where "giftwrap" has a value of "1" "times" "3.95"  

...but there is no "giftwrap" in the drop down menu at the "Total of "Quantity" where "giftwrap" has a value of "1" "times" "3.95".
Our other 8 custom columns are in the drop-down though.

Delete WinFileCache (or whatever it's called! :o) ) and try again?

Thank you.
NJ

You need to add a column named giftwrap on the columns section.

in the add to cart buttons, make that column editable as a checkbox.

set the checked value to 1.

then you will be able to make the Charges rule work.

Hi Jason. Something must have gone astray in our thinking / operating here...

We added a new column called "AddGiftWrap" in the eCart Object columns section. We selected type "number" for this as nothing else seemed appropriate.

In the Add to Cart behaviour, in the Bindings section, our new column AddGiftWrap is there but the only "Updateable" options are "hidden field", "text field" and "select list". There is no option for checkbox. :o(

So...we proceeded with adding it as an updateable text field and then we manually changed it to a checkbox...
<input type="checkbox" name="BFcart_1_AddGiftWrap_Add" value="1" />

This, as you suggested, allows us to create the Charges rule but now, when we click the Add to Cart button we get this error, similar to an error we were previously getting:

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'cDbl'
/babyfish2013/WA_eCart/BFcart_VB.asp, line 34

Line 34 is:
retVal.AddGiftWrap = cDbl(itemAddGiftWrap)

We believe that when the checkbox isn't checked (when a customer doesn't require gift wrapping) then no value is being passed and, therefore, we are thrown the type mismatch error because it is looking for a numerical value.

Perhaps you can see a glaring error in all of this? Really appreciate your help. Thank you.
NJ

Instead of using the Number data type, use text.

In actual fact, it doesn't matter if the checked value is "Y" or "1" or anything else.

The calculation rule wont necessarily treat it as a number, it is just used as a flag, so the data type is not really important. By using text for the data type it will allow for a blank valuer (when giftware is not needed).

I have recreated a column called AddGiftWrap in the eCart Object and have selected "text" as its data type.
When we go back into the Add to Cart behaviour though there is still no option for a checkbox; just "hidden field", "text field" and "select list".

Whichever one I choose it doesn't add a checkbox to the page it adds either a hidden field, a text field or a select list. Was I right in assuming that I'd need to manually change this to a checkbox?

I feel like I'm not grasping this at all. Hope you can help.
Thank you.
NJ