Table Quote module

Contrib type: 
Module
Moderation: 
Not ready for moderation
Status: 
Complete and working
Compatibility: 
Ubercart 1.x
Compatibility: 
Ubercart 2.x

This module is strongly based on uc_ratequote.module. the main difference from uc_ratequote.module is that it can add a shipping type based on weight or order total.
I've now also attached the italian translation and the pot file for other languages.
UPDATE: I've modiefied the module: now it works with attributes.
D6 UPGRADE: I've attached the module for drupal 6.
There is now a project page on drupal.org.

AttachmentSize
uc_tablequote_po.zip5.39 KB
uc_tablequote.zip5.21 KB
D6-uc_tablequote.zip3.41 KB

Does this module account for weight in product attributes?

Example :

Product weight of 0.2kg or 0.4kg (by adding an additional 0.2kg in the attribute options)

Bands of : 0kg - 0.999kg = £4 and 1kg - 20kg £6

Product with weight of 0.2kg should require 5 to move into the heavier band
Product with 0.4kg should only require 3.

I still have to chnage the product quantity to 5 to reach the second band. Product attribute weights seem to be getting ignored.

Übercart 2 version under way?

Hi!

An updated version for Übercart 2/Drupal 6 would be the best possible Xmas gift that I could get. Smiling
I'd really propose that this module would be included into the Übercart core.

The module looks simple, but I know too little about Drupal's inner workings to be able to port it. If someone would port this one for Drupal 6 ie. Übercart 2 by the end of this year I'll pay them 200euro. If you can't quite make it, just contact me and we'll see what my needs are then. Smiling

Merry Xmas and a Happy New Year!

cheers, Simon

hallo dj_mystic82, for now

hallo dj_mystic82,
for now this module doesn't consider the attributes: it only consider the product weight or product sell price without the options incrementes (if any exist). so if you have:
0kg - 0.999kg = £4
1kg - 20kg = £6
and the product A is 0.5kg with an attribute option of a 1.5kg extra, the shipping cost is £4 and not £6.

anyway thankyou for your post, because I didn't considered the attributes at all.. Sad
now I'm trying to change the code of the module. for now I'm testing it on a local server, and with the changes I've made it works with attributes only if the method selected is weight. I'm having problems if the method is order total.
my post is here:
http://www.ubercart.org/forum/development/8250/productsell_price_when_th...

I'll upload the module when it is ok.

nicola

Re: Does this module account for weight in product attributes?

I've modified the code: now it has to work with attributes and options.
but if you find errors, please advise me.

nicola

Another D6 request

Would absolutely love it if someone could port this module to Drupal 6 for Ubercart version 2.

Its the only outstanding item keeping me from changing my oscommerce store to Ubercart.

Confirming my offer above, please join in everyone who want this

I hereby confirm that I'd still need this module for Übercart 2/Drupal 6 and would still be able to pay the 200euro mentioned above, provided that this could be done within a couple of weeks. Please raise a hand everyone who'd love to have it, and if you're ready to pay anything for having it done... post it here, and we'll raise money for it together. Smiling

SimOn - Web solutions & interface design
http://simon.fi

Re: Re: Does this module account for weight in product attribute

Hi fivepoints, thanks for looking into this for me. Could you point me to where I can download the updated module? The one at the top of this thread appears to be the same as I downloaded originally (5.x.1.5).

I have another query, although this may be taking the needs of this module too far. I have another site where weight bands apply as before. This would apply to the UK. Then there would be the same set of weight bands, but different prices to delivery overseas.

Eg bands :
0 - 5kg = £3.99 for UK and £5.99 for Europe
5kg - 10kg = £4.99 for UK and £8.99 for Europe

I've been looking at using flat rate and workflow-ng, but the cart weight calculations do not seem to work right.

Re: Confirming my offer above, please join in everyone who want

I do find it slightly strange that someone has offered money for this module to be upgraded to D6, and no one has stepped forward. Not that I am judging anyone btw...just dissapointed that this great cart doesnt have a more active community Sad

Does this need more money inducement for someone to take up the mantle on porting this module?

Re: Re: Confirming my offer above, please join in everyone who w

So are you up for the job? Eye-wink

SimOn - Web solutions & interface design
http://simon.fi

Half-way done port to Übercart2 anyone wants to continue?

Hi!

I got a half-way ported version of the module, if anyone wants to continue... just check it out.
The 200euro offer is still valid for anybody who gets this thing working! But it probably won't be for long since I soon need to roll up my sleeves myself in order to find a solution, even though I don't really have time to dive into the the inner workings of this. So if anybody wants to take on this project, please let me know immediately.

cheers, Simon

SimOn - Web solutions & interface design
http://simon.fi

AttachmentSize
Half-way done Übercart 2/Drupal 6 port of the Table quote module, by Joey Janisheck.6.14 KB

Re: Half-way done port to Übercart2 anyone wants to continue?

I've done the upgrade for D6. the module seems to work well.
anyway, let me know if there are problems.

thanks
nicola

Hi Nicola, Yay! This was

Hi Nicola,

Yay! This was about the last thing preventing me from converting from oscommerce to ubercart. Thank you! Seems to work fine based on some simple tests in my demo store.

Quick question: is there a way to have multiple table quote methods? For example:

1. Normal mail
0-100 = 0.50
101-500 = 2.00
500 - 10000 = 6.00

2. Courier
0-5000 = 4.00
5000-10000 = 5.00

Thanks again for the D6 conversion.

Re: Hi Nicola, Yay! This was

Yes, same here. I would be interested in this. A durty way of doing it is by cloning the module and renaming it for every new "shipment table".

[QUOTE] Hi Nicola, Yay! This

Quote:

Hi Nicola,

Yay! This was about the last thing preventing me from converting from oscommerce to ubercart. Thank you! Seems to work fine based on some simple tests in my demo store.

Quick question: is there a way to have multiple table quote methods? For example:

1. Normal mail
0-100 = 0.50
101-500 = 2.00
500 - 10000 = 6.00

2. Courier
0-5000 = 4.00
5000-10000 = 5.00

Thanks again for the D6 conversion.

not for now Sad
but it would be a great feature!
but for now if you need multiple tables you can use for example flatrate module with workflow-ng (maybe not so simple to configure, but I think it could works).

Clone

Flatrate + workflow-ng is horrible; I originally tried that route, but your module is much much better.

I think that #13 has the best solution: I am going to try make a clone of the tablequote module with a different name (tablequote renamed to tablequote2 in all files).

Must be missing some clue

JOnob, Could you (or just anybody) please share your cloned version, because I don't even manage to have it appear as module. I must be missing some clue here.

Second table quote method

I just spent 10 minutes hacking this and I think I managed to get it working fine.

Basically what I did was:
-Find all instances of "tablequote" in the module files and replaced it with "tablequote2".
-Line 39 of uc_tablequote2.module - I changed "Shipping cost" to "Second shipping method". If you wanted, you could change these to something like "24 hour courier" (in the original table_quote module) and "48 hour courier" (in the new tablequote2 module).

The only thing that I have not yet managed to figure out is how to show the second table quote method in drupal's admin menu - so I couldnt actually enter any figures for the second method via drupal. To get around this, I went into phpmyadmin and manually loaded up some values into the uc_tablequote2 table.

But other than the above, it seems that both quotes are generated correctly. I havent spent a lot of time on this and its >very< hacky way of doing things, so dont blame me if it bombs your whole site.

AttachmentSize
uc_tablequote2.zip3.37 KB

Re: Second table quote method

your solution is good but if a shop admin needs a third shipping table?
I think we have to give the possibility to add infinites tables, based on courier types and/or regions.

for now I've uploaded the module on drupal.org Smiling

Re: Re: Second table quote method

Yeah, if you use my method, then each each tablequote will need another module and a new table...it will work, but is bad coding and implementation in all respects.

The correct way to do it would be to alter the uc_tablequote table and add another column called "method" (or something similar) and then modify the uc_tablequote functions to allow for multiple methods, each of which can be configured independantly.

Great module

Works like a charm with 6.10 and Ubercart 6.2-beta5.

Really a great jump from the old workflow-ng method.

Thanks a lot.

Edition

Hello all.

Does anybody know a way to edit existing Shipping Rates ?

I need my customer to be able to change the rates, from time to time, when thay change for a given weight range. I'd rather not delete all ranges and recreate them.

Thanks