I have a client website in Drupal 6 (the first Drupal site I'd done, actually) which has a number of products in Ubercart. The client is a church organization, and one of the products is a donation (using the Ubercart Donation Product sub-module).
The checkout uses the simplest shipping method available and calculates shipping on total PRICE, with discounts for orders over a set of break points.
Well, they just got and order for two products totaling $15, and a donation of $500. Of course, the shipping was calculated on the $515 and the shipping was more than the products cost!
I've scoured the Ubercart forums and haven't found much help. I found a number of others with the same issue, but no clear answers--at least none that didn't involve some programming beyond my own means.
So I thought I would post here... to see if anyone locally had any suggestions. Or, if anyone with Ubercart and/or programming experience would like to step in as a consultant.
And help would be most welcome.
Comments
An idea
Roger,
I'm not familiar with using the "simplest shipping method" but if you edit the donation product's shippable checkbox by unchecking it.
(The text beside it says: "Product and its derivatives are shippable.")
Does that override the shipping calculation on total price?
Already un-checked
Thanks for the thought. That option was already unchecked, so the shipping was added despite that.
It's been awhile since I built that site and--it being the only time Id ever used Ubercart--I've been struggling to remember everything I'd done to set it up (early onset dementia is setting in). So my description of "simplest shipping method" wasn't very helpful.
The client didn't want to use any of the standard services to calculate the rate (UPS, USPS). Their preference was to set a scale of price totals and shipping rates based on total price points. So I used the Ubercart Table Quote sub-module to create a table of totals that set the shipping rate for each order. To confuse matters a bit, there are also discounts applied for orders on select products based on the number of units ordered.
So it's not using a flat rate or any of the weight-based models for shipping. I guess that--since the shipping is based on price totals--that's probably the cause. I just don't know how to exclude the donations from the shipping costs.
Roger
_________________
Art has gone to the dogs
GoodeGallery.com
If you can specify which
If you can specify which products have a discount and your shipping is based on the order total, can you apply a discount on just those donations? Can you specify the amount of discount as a specific dollar amount for donation products?
For example:
If your shipping rate is for every $10 bucks spent, shipping is $1.
Your customer orders two products totaling $15 plus a $500 donation, the total order amount would be $566.50.($51.50 in shipping)
If you can apply a discount of $50 when that $500 donation product is ordered, then the order total calculation would be $15 + ($500-$50) + $51.50 = $516.50
May need a complete re-work
The Shipping Quotes table is set up with break points... (per the clients request) ie:
$1-$24.99 =$5.95 shipping
$25-$59.99 =$8.95 shipping
$60-$139.99 =$10.95 shipping
etc.
The discounts are set up like this:
5% discount on select products at 20-60 units
10% discount on select products at 60-100 units
etc.
And the Donation Product is set up so that the "customer" can set any figure for a donation, rather than pre-defined donation amounts.
I think what you propose could work, but it would mean revising the entire setup. I'm not sure they'd go for that. In my inexperience, I may have screwed myself on this setup.
Roger
_________________
Art has gone to the dogs
GoodeGallery.com
yikes
I'd propose a re-work.
I don't think it'd take very long to re-work your configuration.
The shipping amounts are probably old and need to be updated anyway with today's ridiculous gas prices.
Can I help?
Hi Roger,
I'm starting an Ubercart implementation soon, and starting to learn it in depth. I'd love to help if you have to re-work. I've got a lot of programming experience, so I might be able to help with customization, or working through the D7 maturing process if you decide to upgrade to Uber7. For me, it would help me learn Ubercart outside the vacuum, and see a practical application. I'm also interested to see if and how customization can be designed to survive upgrades. Maybe an add on module is something we could put together, especially since you are seeing similar complaints, but no solutions on the forums. A sub-module might be welcomed and popular in the community.
BTW, if this is a paid gig, I accept payment in beer, if you don't mind signing a 1040-XX (pronounced Ten Forty Dos Equis).
See you Thursday? We can talk about it after the meeting.
Boz
www.EcoBoro.com
I have the Ubercart book and
I have the Ubercart book and can bring it to the meeting if I can find it, :) your more than welcome to borrow it if you want too. I would also suggest checking out ubercart.org if you have not already done so that site has a wealth of information and a forum that you can post too.
Mary M.
I have an Ubercart bok, too
Is it the PacktPub book "Drupal e-commerce with Ubercart 2.x"? I bought that one back when I was setting this site up. I've searched on the ubercart site for answers but mostly came up with others having the same or similar issue.
It may end up needing a re-do to make it more flexible than the way they had me set it up originally.
Roger
_________________
Art has gone to the dogs
GoodeGallery.com