Shipping being added too many times

I have got a paypal add to cart working, and I have three shipping costs depending upon where the customer lives. I have UK, Europe and Rest of the world. These shipping prices are automatically set by the database when the customer logs in. This all works fine.

My issue is that if the customer buys more than one item, the shipping cost is added twice. I need the shipping cost to be added only once. How do I do this? I understand that there is a flat rate shipping facility within paypal itself, but that flat rate needs to be fed from my database. Is there a way of doing this?

Thanks.

In the eCart shipping rule, set the calculation to use a flat rate calculation.

Where can I find that? I have looked through the bindings and through the code, but can't see anything for eCart. Does the paypal add to cart free tool have basic eCart functionality then?

I've attached the pages just in case you need to indicate which lines need changing.

Thanks.

I have just gone through the process of creating a new dummy store, but can't find the flat rate shipping option within the wizard of the free tools add to cart.

I can either enter a value, or have the DB apply the value. I don't see how I can get the shipping value to apply only once.

sorry, i missed that this was for free tools.

change the shipping hidden element:
<input type="hidden" name="shipping" value="<?php echo $row_rs_users['fld_srPRICE']; ?>" />


to handling_cart:
<input type="hidden" name="handling_ cart" value="<?php echo $row_rs_users['fld_srPRICE']; ?>" />

see this page for more details on the variable reference for paypal add to cart buttons:
https://developer.paypal.com/webapps/developer/docs/classic/paypal-payments-standard/integration-guide/Appx_websitestandard_htmlvariables/

Excellent... works a treat!

Quick question about the "handling_cart" value for PayPal

I've got it working, but the odd item in their inventory may need extra postage because of its weight. For some reason, I can't get it to apply to the shopping cart even though I do have a value in place.

I have these hidden shipping fields in my form:

<input type="hidden" name="no_shipping" value="0" />
<input type="hidden" name="handling_cart" value="<?php echo $_SESSION['USES_selectshipping']; ?>" />
<input type="hidden" name="shipping2" value="<?php echo $row_rs_products['ProductShipping']; ?>" />

Does the value "handling_cart" disable the ability to add an extra shipping cost to individual items? From memory, extra per item shipping costs were being added to the cart prior to adding the value "handling_cart".

Thanks.

name the hidden variable shipping.

The shipping variable is a base shipping rate for the item, the shipping2 variable is for an additional per item rate. for a quantity of more than 1.

so shipping = 2.50
and shipping2 = 50

would charge 3.00 on a quantity of 2.

OK, so it only applies if you have more than one of the very same product in the cart, rather than just more than one of any product in the cart!

Hmm... not quite what I need.

I was hoping there might be a way where I can set a flat shipping price for numerous products as I have with the handling_cart variable, but then if the customer adds a product that is very heavy the shipping price goes up to accommodate that one particular item.

Is there a way you know of to achieve this?

Thanks

No, there is not a way I know of to do this using PayPal add to cart buttons, i suggest using eCart instead.