# Different Flat Rate shipping for each item, then discount.

Thread began 2/13/2012 6:56 pm by troyd | Last modified 2/15/2012 12:10 pm by Jason Byrnes | 1101 views | 4 replies |

## 2/13/2012 6:56 pm  |  #1 troyd

### Different Flat Rate shipping for each item, then discount.

I have studied, and even tried several of the shipping steps found here within the forum. But I am stumped.

My client ships at a flat rate, but each item has a different rate?
Shipping rates are stored in a database table. Oh, and this is for a PayPal Standard shopping cart.

The client wants to discount the flat rate by 50% for each item after the first one. AND not start over on a different unique item.

So for example.

Widget 1 = \$10 shipping for the first one.
Then the second, third, fourth would be \$5 shipping each

Widget 2= \$3 shipping
Then the second, third, fourth would be \$1.50 shipping each.

So if they order 2 of Widget 1, shipping would be \$15 total.

But, if they order 1 each of Widget 1 Widget 2, then the higher shipping of \$10 should be applied first, and a discounted shipping of \$1.50 would be added for widget 2.

I'm confused about where I bring this shipping into the calculation and what the rules would be.
Should I use a hidden input and populate it with the shipping amount in the recordset to start with? If so, then what?

Thanks,
TroyD

## 2/14/2012 4:48 pm  |  #2 troyd

FYI. Some progress, but still falling short of completion.

I have the individual shipping rates for each item being added successfully from the recordset into the shopping cart at full shipping amount for 1st, 2nd, 3rd, of each item.

Now I just need to discount the 2nd, 3rd, etc., shipping amount by 50% for each after the first item's full amount for the first.

So far this is where I am at.
Created a new eCart Column called Shipping (binding it in the "eCart add from recordset", to the table column for the shipping amount).

eCart Object:
Calculation tab. New Calculation called "FlatRate" [Quantity] * [Shipping].

Shipping tab.
New rule:
Trigger is-
SubTotal of Quantity > 0
AND Subtotal for any column
If the subtotal of column Quantity is > a value of 0

Calculation-
Based on column subtotal
Subtotal of column FlatRate plus 0

Thanks,
Troy

## 2/15/2012 11:32 am  |  #3 Jason ByrnesWebAssist

this is a tough one because of the requirement of using the highest shipping rate as the base.

you are on the right track with creating the Shipping column and the Flat rate calculation.

to complete this we will need to create code that will determine which is the highest shipping rate and store it in a session variable.

On the cart display page, add the following code just before the doctype tag to do this:

php:
``<?php@session_start();\$_SESSION['highestShipping'] = "0";while (!\$eCart2->EOF())      {    if(\$eCart2->DisplayInfo("Shipping") > \$_SESSION['highestShipping']) \$_SESSION['highestShipping'] = \$eCart2->DisplayInfo("Shipping");    \$eCart2->MoveNext();}\$eCart2->MoveFirst();?>``

this code is using an eCart object named "eCart2" if your eCart object uses a different name, the code will need to be adjusted accordingly.

Next, we will need to create 2 shipping rules:
1) Base shipping:

Trigger:
"Subtotal For Any Column"
If the subtotal of column "Quantity" is ">" a value of "0"

Calculation:
"Falt rate"

php:
``\$_SESSION['highestShipping']``

2) Incremental shipping:
Trigger:
"Subtotal For Any Column"
If the subtotal of column "Quantity" is ">" a value of "1"

Calculation:
"Falt rate"

php:
``(\$this->TotalColumn("FlatRate") - \$_SESSION['highestShipping']) * 0.5``

## 2/15/2012 12:00 pm  |  #4 troyd

Jason,

Wow, that works perfectly. I would have never figured that out. This solves so many problems I was facing.

Thank you so much.

TroyD

## 2/15/2012 12:10 pm  |  #5 Jason ByrnesWebAssist

Glad to hear it is working.

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

## Everything else!

Close Window

Account or customer service questions?

Need technical support?

Content

Layout

Ease of use

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 Window

## We were unable to retrieve the attached file

Close Window

### Attach and remove files

• Text Formatting
• Insert Element
• Block Formatting
• Cancel
Close Window

Close Window

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