Ubercart

Thank you for this module David! It seems to work well. I wonder if this should be rolled into the main package download and/or into the flat rate quote module as additional functionality. When I downloaded the flat rate module I just assumed that you could set multiple flat rates based on order totals or total weight which you cannot - at this time anyhow. In my mind, there are very few instances where a single flat rate for an entire store is all that useful.

seems that the shipping_method callback methods now (as of alpha7c) expect a slightly different return value. i had to patch my ratequote module in the uc_ratequote_quote and uc_ratequote_quote_order functions, making this simple change:

this module has proven extremely useful in working through a fairly complex table-based shipping rates scenario for a soon-to-be-live site i've been working on.

attached is a patch which extends the basic functionality of the module to support percentage-based shipping rates in the table. the feature is very simplistic, merely adding a 'percent' field to the table entries, which gets used if the 'amount' is left blank (0):

please excuse the debug info, and the (possibly?) crufty bits leftover from the alpha7c updates..

here's some critical feedback on the ratequote module, but also on the shipping API in general, and how it could work better. this is based on our experience implementing the shipping quotes feature for SCW, who have an existing set of options used by customers ordering through their catalog.

DISCLAIMER: the following patch is a one-off solution to the requirements of the client we built this site for! DO NOT apply this patch unless you understand how to subsequently modify the relevant code to apply to your site! Also note that the patch was rolled after the one above which adds percentage-based rates, so you may have to tweak it manually if you are not using that patch.

the ratequote module posted above did most of what we needed, except for the option of calculating percentage-based rates for certain ranges, and also offering multiple shipping options, including Rush/Overnight as well as different rates for Canada and International shipping addresses. The final thing we needed was integration with the discounts module.

to accomplish this, i added elements to the array of 'accessorials' provided by the module (see hook_shipping_method, one for each available shipping option. then in the "quote" callback, we determine which methods apply (based on the country of the delivery address), and return an array of quotes based on these.

the quotes themselves are all based on the table rates defined by the module, but all the "nonstandard" options have a fixed rate added to this (+$15 for Rush, +$30 for Overnight, +$12 for Canada, +$40 for Int'l). in the case of US-based shipping, customers are provided 3 different options, whereas Canada/International don't have rush/overnight options.

important to note here is that the new per-country functionality implemented in the alpha7c updates to the shipping methods API/UI was not so useful to us, since it did not allow us to define a group of countries as "other" for the International shipping rates (ie. anything that's not Canada/US). also, the geoshipping module looks promising, but didn't provide the core "table rate" functionality we needed from this module.

ideally, this would be accomplished in a more elegant/abstract way, so that the administrator could define the different 'accessorial' options, and their effect. at base, being able to add a fixed amount to the table rate would be good; being able to define different table rates per option would be better. also, the admin should be able to define "regions" and then map these different options onto them at the more fine-grained level, rather than at the level of the entire quote module.

finally, the attached patch adds a bit of code to calculate the shipping rate on the order total *after* discounts are applied. again, this is a specific requirement of the SCW site, and should probably be a configurable weight/ordering feature, if the discounts module is enabled. this bit of code was stolen from here, and seems to work nicely so far.

anyway, we hope this proves useful to somebody, and welcome feedback, especially in terms of alternative approaches or ways to integrate these ideas into ubercart/uc_ratequote going forward. i noticed as i was writing this that there's a new worldquotes module released which appears to do some of what we wanted here- the question still seems to be integrating the two (apparently) different methods in the way we've accomplished here.

We will be applying the above patches and features as much as possible for a new version. Stay tuned, in the next day or so.

I forgot to post the updated module.

i've finally gotten around to updating our site to alpha8 (trying to catch up to beta7!), and have found myself stuck trying to get the ratequote module to behave nicely with the new workflow_ng module integration. has anyone been able to make this work?

following lyle's suggestion, i've stolen the uc_usps_configuration hook and replaces usps with ratequote, but when i go to the checkout, i see no quote methods returned. any hints or insight on how to debug this or what might be going wrong here are greatly appreciated!

i promise to post a fresh and working copy of the module when i get these issues sorted out!

thanks!

This module is great. I'm testing it out on D5, UC1rc4.

The way it was set up, it was doing a node_load and then pulling the "sell_price" from the nodes. This didn't work for me as the total was off when kits were in the cart and thus shipping was off.

I changed some of the logic to just use the price * qty. This gives me the correct shipping quote on both kits and regular products.

I also moved the logic from PHP to SQL to get the rate within the min/max parameters. This seems to work for me, your feedback would be very welcomed.

Thanks,
Shane

Tried using the latest version (http://www.ubercart.org/contrib/355#comment-5313) in Drupal 5.5 with Ubercart 1.0RC4 with two options:

min     max         flat  percent
0.00    99.99       5     0
100.00  1000000.00  0     0

However it would only ever pick the first option regardless of the order total.

Interestingly, after applying the patch in http://www.ubercart.org/contrib/355#comment-17550 it now works.

Hi,

I'm setting up a store where the only shipping method is Rate Quote. I'm using ubercart-5.x-1.0-rc4 with Rate Quote 1.01. When I tried placing my first order and pressing "Click to calculate shipping", I kept getting a vague error. Flat rate shipping worked, so I started comparing the two modules.

One thing that was missing was a section called Workflow-ng hooks. I took the code out of the flat rate module and modified it for the rate quote module and I got my shipping quotes to come out. To be honest, I don't know what exactly all this code does, I just narrowed the problem area and make a reasonable guess at adapting the code. Here's what I added to uc_ratequote.module in case it helps anyone else out. Also in case this is not the best solution

/******************************************************************************
 * Workflow-ng Hooks                                                          *
 ******************************************************************************/

/**
 * Implementation of hook_configuration().
 *
 * Connect the quote action with the quote event.
 */
function uc_ratequote_configuration() {
  $enabled = variable_get('uc_quote_enabled', array());
  $configurations = array();
  $action = workflow_ng_use_action('uc_quote_action_get_quote', array(
    '#label' => t('Fetch a shipping quote'),
  ));

  $configurations['uc_ratequote_get_quote'] = array(
      '#label' => t('Shipping quote via Rate Quote Shipping'),
      '#event' => 'get_quote_from_ratequote',
      '#module' => 'uc_ratequote',
      '#active' => $enabled['ratequote'],
    );
  $configurations['uc_ratequote_get_quote'] = workflow_ng_configure($configurations['uc_ratequote_get_quote'], $action);

  return $configurations;
}

This module works fine for me, Ubercart 1.0, Ratequote 1.01 with the shipping percentage patch, and the new uc_ratequote_configuration() {not sure if it made a difference).

EDIT:

If anyone is looking for an easy way to do BOTH flat rate AND a percentage fee, after applying the patch, open uc_ratequote.module and starting at line 287 comment out the if/else statements and add "$rate + " to the front of the $rate = declaration.

CODE (bold text is what is not commented):
# if ($rate > 0) {
# $quotes[] = array('rate' => $rate, 'format' => uc_currency_format($rate), 'option_label' => $method['ratequote']['quote']['accessorials'][0]);
# } else {
# $rate = $total * ($percent / 100);
$rate = $rate + ( $total * ($percent / 100) );
$quotes[] = array('rate' => $rate, 'format' => uc_currency_format($rate), 'option_label' => $method['ratequote']['quote']['accessorials'][0]);
# }

I'm using this contrib's version posted by webmasterkai on Tue, 10/23/2007, with drupal 5.9 and ubercart 5.x-1.0.

Unfortunately I couldn't get the module to work, since I got the following error, when I try to put Order Minimum: € 0.00, Order Maximum: € 49.99, Shipping Rate: € 10.00, Shipping Percentage: % 0. For Euro values, it is ok to use the decimal separator "."; I am also getting errors in the Checkout Page:

user warning: Unknown column 'percent' in 'field list' query: INSERT INTO shop_uc_ratequotes (min, max, rate, percent) VALUES (0, 49.99, 10, 0) in /var/www/vhosts/mywebsite.com/subdomains/shop/httpdocs/includes/database.mysql.inc on line 172.

I had a previous version of this module installed and forgot running update.php. So the problem was solved running update.php. Module is now working fine.

I don't even see the percentage field on the Rate Quote page. What am I forgetting to do? I have uploaded the files to the modules folder, and when I went to the update.php file, it says there are no updates available for this module.

Any suggestions?

I had enabled the Flat Rate module instead of the Rate Quote module. Working like a charm for me now.

Whats the current status on this module?

Last time i used it, it needed patching and whatnot. But this was May 2008, and ubercart was still on RC4 or RC5.

Did anything change?

Where can I find Drupal 6 version for this module? Ubercart Percent Rate with Minimum Rate quotations are not reliable jet.