Rajmahall Posted July 15, 2008 Share Posted July 15, 2008 A merchant would like to use a shipping price model that works like so: USPS Flat Rate, 19.99, one item USPS Flat Rate, 19.99, two items USPS Flat Rate, 29.98, three items Would like to use similar pricing scheme for DHL, FedEx, UPS. I have been able to find out how to use multiple shipping vendors and flat rates. Where I am running into difficulty is the assorted prices for the different quantities of products. If anyone can direct me to a module or some documentation that will accomodate this type of shipping prices, it would be greatly appreciated! I've been searching a bit, and not finding it directly. Thanks again for any assistance. :blink: Quote ECommerce, Custom CMS, and Web Design from Chicago Creative Design Link to comment Share on other sites More sharing options...
clea023 Posted August 9, 2008 Share Posted August 9, 2008 (edited) did you ever get a response on this or figure out a workaround? I have a client who wants per-item shipping rates to be $5.00 for 1 item $7.50 for 2 items $10.00 for >3 items Still scouring trying to find something that will do this. Thanks! Edited August 9, 2008 by clea023 Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted August 9, 2008 Share Posted August 9, 2008 There are 13 pages of shipping contributions Try first item x or Table shipping based on number of items v1.0 or scan through and chose for yourself Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
Rajmahall Posted August 9, 2008 Author Share Posted August 9, 2008 did you ever get a response on this or figure out a workaround? I have a client who wants per-item shipping rates to be $5.00 for 1 item $7.50 for 2 items $10.00 for >3 items Still scouring trying to find something that will do this. Thanks! I think you could make use of the table rate mod at: http://addons.oscommerce.com/info/1718 As far as the specific issue I mentioned, I just found it easiest to make a few simple changes to the one listed above, and create my own mod at: http://addons.oscommerce.com/info/6082 There is also one that might work for you, if you want to use multiple shipping vendors, called the Multiple Vendor Shipping module, or MVS, though the documentation did not make it clear to me if it would really solve my issue specifically and I was on a deadline! Big thanks go to GeoffreyWalton for your excellent post, and I will definitely enjoy having the other useful links that are in your signature. Where were you three weeks ago!? Quote ECommerce, Custom CMS, and Web Design from Chicago Creative Design Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted August 9, 2008 Share Posted August 9, 2008 I was hiding from the vampires :-) Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
clea023 Posted August 10, 2008 Share Posted August 10, 2008 There are 13 pages of shipping contributions... which defines quite a problem for attention-challenged migraineurs like myself: after spending so much time making sure that a shop is aesthetically pleasing and not "ocularly hostile" -- there's only so much scrubbing through page after page of mods / search results that my spoogly eyes can handle before I just have to yield and post a request ;) thank you all for the responses on this. and WOW! those sig-links rock socks! Quote Link to comment Share on other sites More sharing options...
Rajmahall Posted August 10, 2008 Author Share Posted August 10, 2008 I was hiding from the vampires :-) UNDERSTANDABLE! Quote ECommerce, Custom CMS, and Web Design from Chicago Creative Design Link to comment Share on other sites More sharing options...
clea023 Posted August 11, 2008 Share Posted August 11, 2008 http://addons.oscommerce.com/info/6082my server prefers the first version. Works like a charm!many thanks for a great mod! This is exactly what I needed and then some :) Quote Link to comment Share on other sites More sharing options...
tjblevins Posted September 4, 2008 Share Posted September 4, 2008 I get a wierd sql error after adding a shipping zone. Don't get the same error on the standard table shipping module. 1146 - Table 'database.USPSTABLE_ZONES_TO_GEO_ZONES' doesn't exist select zone_id from USPSTABLE_ZONES_TO_GEO_ZONES where geo_zone_id = '2' and zone_country_id = '' order by zone_id Any ideas? it seems like this file opperates just like table.php and is probably a copy but I am just missing something. Everytime I set a shipping zone and save I get this error. Quote Link to comment Share on other sites More sharing options...
realhotstuff Posted October 9, 2008 Share Posted October 9, 2008 I get a wierd sql error after adding a shipping zone. Don't get the same error on the standard table shipping module. 1146 - Table 'database.USPSTABLE_ZONES_TO_GEO_ZONES' doesn't exist select zone_id from USPSTABLE_ZONES_TO_GEO_ZONES where geo_zone_id = '2' and zone_country_id = '' order by zone_id Any ideas? it seems like this file opperates just like table.php and is probably a copy but I am just missing something. Everytime I set a shipping zone and save I get this error. Go to the uspstable.php (under module, not languages). At line 41 $check_query = tep_db_query("select zone_id from " . USPSTABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_SHIPPING_USPSTABLE_ZONE . "' and zone_country_id = '" . $order->delivery['country']['id'] . "' order by zone_id"); change it to: $check_query = tep_db_query("select zone_id from zones_to_geo_zones where geo_zone_id = '" . MODULE_SHIPPING_USPSTABLE_ZONE . "' and zone_country_id = '" . $order->delivery['country']['id'] . "' order by zone_id"); Quote Link to comment Share on other sites More sharing options...
Alexander75 Posted August 30, 2010 Share Posted August 30, 2010 (edited) Hi ;) How change text in upstable module according to the price? Example: <= 20 eur --> priority package >= 20 eur --> quick package This is part of code: $table_cost = split("[:,]" , MODULE_SHIPPING_UPSTABLE_COST); $size = sizeof($table_cost); for ($i=0, $n=$size; $i<$n; $i+=2) { if ($order_total <= $table_cost[$i]) { $shipping = $table_cost[$i+1]; break; } } if (MODULE_SHIPPING_UPSTABLE_MODE == 'weight') { $shipping = $shipping * $shipping_num_boxes; } $this->quotes = array('id' => $this->code, 'module' => MODULE_SHIPPING_UPSTABLE_TEXT_TITLE, 'methods' => array(array('id' => $this->code, 'title' => MODULE_SHIPPING_UPSTABLE_TEXT_WAY, 'cost' => $shipping + MODULE_SHIPPING_UPSTABLE_HANDLING))); Thanks a lot ;) Edited August 30, 2010 by Alexander75 Quote T-shirt metal, sweatshirts metal, articles, interviews on band metal and more ... Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.