Posted by stockliasteroid on May 13, 2009 at 7:46pm
| Project: | Table Quote - Shipping cost based on total ranges |
| Version: | 6.x-2.0 |
| Component: | Code |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | reviewed & tested by the community |
| Issue tags: | ubercart uc_tablequote |
Issue Summary
I needed to be able to support multiple shipping tables (i.e. Standard Shipping, 2nd Day Air, Next Day Air, etc), so I updated the module to support it. With these two patches applied, it will allow you to create multiple shipping tables, with the quote "method" specified for each. So, you could have one that allows quotes based on weight, and another that quotes based on order total. Each has it's own shipping table, so you can charge different prices for different shipping methods. You can also title your tables so that when customers check out out they see the appropriate title (2nd Day Air, Next Day Air, etc).
| Attachment | Size |
|---|---|
| uc_tablequote.module.patch | 15.58 KB |
| uc_tablequote.install.patch | 1.58 KB |
Comments
#1
Hi,
Witch version you are used? I try patch 5.x-1.0 versio, but result is:
8 out of 13 hunks FAILED -- saving rejects to file uc_tablequote.module.rej#2
Sorry, I hadn't checked in on this for a while. My patch is rolled against the 2.0 version for D6.
#3
Hi,
This function is what I need for website as well, but after I applied the patches, click into the quote methods I can't create the tables and got the following shown up:
in the general settings
user warning: Table 'test.uc_tablequote_methods' doesn't exist query: SELECT * FROM uc_tablequote_methods ORDER BY weight ASC in C:\test\sites\default\modules\uc_tablequote\uc_tablequote.module on line 160.
in the weight/order quote
user warning: Table 'test.uc_tablequote_methods' doesn't exist query: SELECT * FROM uc_tablequote_methods ORDER BY weight ASC in C:\test\sites\default\modules\uc_tablequote\uc_tablequote.module on line 46.
I am using D6 and 2.0
#4
interesting update. Has there been any updates?
#5
I had the same problem as paullu618 after installing the patches (the module patch didn't successfully work, so I went into the .rej file and updated the module file manually, had to make a few changes on the uc_tablequote_shipping_method() function)
So I looked into the code and found that the function uc_tablequote_update_1() hadn't run and the uc_tablequote_methods table hadn't been created.
#6
Thankyou stockliasteroid for making this patch. It was exactly what I needed to move from a million flatrate methods to several neat tables with weight brackets.
I too had problems applying stock's patch but managed to apply the changes written into your patch manually and having briefly tested the changes all seems to be working fine.
I created a couple of new patches based on the ones above (see attached), and having tested them I am able to apply them ok.
I have made a couple of amendments in the uc_tablequote.install patch so that the schema for the new uc_tablequote_methods table is run when the module is first installed, and the additional field is also added to the uc_tablequote table, and dropped when the module is uninstalled.
I hope this helps someone.
#7
Previously, with a single table it was necessary to create a large max rate to handle the upper limit - eg 20kg to 9999kg = $50, otherwise a quote of $0.00 is returned.
If using multiple tables then doesn't make sense to have to create large max limit for each as the methods may have different upper limits, so although one method may keep a high max to act as the fallback shipping, it would be useful for quotes to not be returned at all if the order total weight > max of the highest quote.
I will create a patch to cover this.
#8
Excellent idea having multiple shipping tables as this approach allows a lot of flexibility for each country. I am using it to fill in Royal Mail rates in the UK by uploading CVS into the database with phpadmin as the Migrate module still doesn't have a hook (destination) for uc table quote.
I tested the table quote module with the uc_marketplace module to provide another method (additional to Flat rate and UPSP) to sellers from different countries in Europe. However, I noticed uc_marketplace might need to add this quote method.
The uc table quote module allows to use shipping quotes from one place and send to many places. With uc marketplace, features can be extended from many places to send to many places. Or in other words, a British seller will need to create 27 tables (for each of the 26 European country and UK) with 12 options. But this can be extended to allow to each European country seller (27) to send to the other (26) and its own country with 12 options (Special delivery 9:00 am, Special delivery next day, Express 24, Express 48, First class, Second class, Standard parcels according to 6 types of weights) by using their local post office services in each country. It would be good that sellers of each country can see the amount they have been paid for shipping costs as the uc marketplace (http://drupal.org/project/ubercart_marketplace) allows it.
Are there any plans to include this feature?
Many thanks
#9
subscribing
#10
subscribing
#11
This one is actually becoming quite important for me, and also seems a very logical and natural structure. Any chance of it being committed soon? If there's more work that needs to be done, I'd love to help.
#12
subscribing
#13
Thanks for this patch. I agree with #11 in that it would be great if it would be committed to dev. Would make elaborate shipping schemes much simpler.
#14
This patch still has many performance problems which I fixed elsewhere. I'm working now on a unified version.
#15
Yes, I gathered as much. Great news you are working on a unified version. Thanks a lot in advance!
#16
subscribing
#17
Do autopoietic's patches still work for the 6.x.2.x.dev version?
I tried patching it but Netbeans showed error it's not patchable...
#18
subscribing
#19
Is there any update on this multiple shipping? I need something like this to ship to multiple regions in the US.
#20
Good module... best patch... but don't work... :(
#21
This works perfectly, I just wish I could do percentage of the price for orders more than $300.
#22
the patch at #6 worked against 6.x-2.0
Will post a blog latter for express creation of multiple tables.
#23
Anybody know How to get User's shipping to address value in this module?
I would like to have a try to make shipping quotes country and/or zone dependant.
#24
#25
cybershan, you can just set up the triggers around the users shipping address to use the table that you want to use.
#26
I'm trying to set it up for my purpose which is the calculation of seafreight space / cost.
However my price is based on length width and hight and not really the weight. And I count per 0,5 m3
I want the customer to fill in his dimensions and the site will calculate the rate. Is that possible?
#27
Hi to all,
I'm the current maintainer of Tablequote. As I'm too busy at the moment on other projects, I'm open to patches and OK to accept a co-maintainer. Let me know if you're interessed.
#28
seems the variable details can get the shipping address.
#29
subscribing