Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Multiple Flat Rate Shipping Options


Rajmahall

Recommended Posts

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:

ECommerce, Custom CMS, and Web Design from Chicago Creative Design

Link to comment
Share on other sites

  • 4 weeks later...

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 by clea023
Link to comment
Share on other sites

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

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

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!?

ECommerce, Custom CMS, and Web Design from Chicago Creative Design

Link to comment
Share on other sites

I was hiding from the vampires :-)

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

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!

Link to comment
Share on other sites

  • 4 weeks later...

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.

Link to comment
Share on other sites

  • 1 month later...
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");

Link to comment
Share on other sites

  • 1 year later...

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 by Alexander75
T-shirt metal, sweatshirts metal, articles, interviews on band metal and more ...
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...