MediaHound Posted July 26, 2007 Share Posted July 26, 2007 (edited) Hi, I had posted this in the general help forum, reposting here for more targeted exposure... I need help configuring my shipping charges! This is for a store selling dry aquarium goods, as well as livestock. And that's where it gets tricky. :blink: Dry goods should go by a pricing table (see below). Livestock should cost $55 to ship up to 3 livestock items. And we want to offer the ability to overnight livestock if the destination is Florida for $17 instead of $55. (but that's the least of my problems right now) Our shipping fees for dry goods are as follows: Order totals Shipping Charge 0-$30.00 $7.25 $30.01-$60.00 $8.25 $60.01-$100.00 $9.99 $100.01-$175.00 $11.99 Over $175 $13.99 so I created the "Table Rate" array: 30:7.25,60:8.25,100:9.99,175:11.99:175:13.99 I have created a tax class under Locations / Taxes -> Tax Classes and called it "Livestock" And I've gone in the database and updated all the livestock items with this new tax class, all livestock products_tax_class_id went from 0 to 2 However, at checkout, it's not forcing livestock with the $55 and the dry goods to use the table of rates, rather, the site is giving the buyer the choice to pay $7.25 or $55 when he wants to checkout with some livestock in the cart So my question is: How can I set this shop up to force the livestock surcharge WHILE STILL charging the table rate for the drygoods? Should I create a new tax class for "DryGoods" and update all the dry products to be in this new tax class? And then assign the table rate to that class? I have already setup a flat rate that assigns a $55 for tax class: Livestock If someone can shed some light on this for, that would be fantastic and greatly appreciated. I hope someone who's familiar with setting up challenging shipping rates will be able to suggest the proper way I should set my shop, or what contrib I should install, etc. I have a feeling I might need to mod my installation to honor these out of the ordinary shipping rules. But what mod is best? Thank you so much! ... and ps I'm not sure if I should be doing this in Tax Classes, if that's where I should be messing around with this to begin with... Edited July 26, 2007 by MediaHound Quote Link to comment Share on other sites More sharing options...
MediaHound Posted July 27, 2007 Author Share Posted July 27, 2007 I'm using the MVS contribution in case anyone stumbles upon this thread and has a similar problem... http://www.oscommerce.com/community/contributions,4129 wish me good luck :) Quote Link to comment Share on other sites More sharing options...
New 
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.