zone rates configuring by price and not weight

I started out with the zone rate configured by price then to fix another issue I changed it to weight so I could multiply my cost by the correct percentage to calculate shipping as this is how I am charged. This way the bottom line price of shipping would not be affected when using group pricing as if I used a percentage of retail price it would affect my shipping. Anywhoo....

When I changed the settings to configure by weight it is continuing to figure by price. What can I do to fix this?

Could you go to the Modules ... Shipping ... and click on Zone Rates zones and post what is in the right panel?

Thanks for your help and sorry I have this same issue going in two different threads.

Below is the copied right panel

Zone Based Rates

Enable Zones Method
True

Calculation Method
Weight

Tax Class
--none--

Tax Basis
Shipping

Sort Order
0

Skip Countries, use a comma separated list of the two character ISO country codes

Zone 1 Countries
US

Zone 1 Shipping Table
29.99:10.5,499.99:29%,5000:15%

Zone 1 Handling Fee
0

Handling Per Order or Per Box Zone 1 (when by weight)
Order

Zone 2 Countries
U1

Zone 2 Shipping Table
29.99:20,5000:70%

Zone 2 Handling Fee
0

Handling Per Order or Per Box Zone 2 (when by weight)
Order

Zone 3 Countries
CA

Zone 3 Shipping Table
29.99:20,5000:45%

Zone 3 Handling Fee
0

Handling Per Order or Per Box Zone 3 (when by weight)
Order

So you are wanting the breaks on weight to be:
29.99lbs $10.5
499.99lbs 29%
5000lbs 15%

Yes because I'm using my "weight" field to calculate my shipping based off of my cost. I had originally done it off of retail value but it decreases the shipping cost when I added the group pricing add on. That's when it went wrong - it won't change from calculating price to calculating from the weight field.

I did add numbers (my cost) to the weight field in the product edit area.

On Zone 2, what country do you think is:
U1

When you say it is not working, what is not working?

What are you expecting on the Shipping Costs?

What are your Settings in the Configuration ... Shipping/Packaging ...

If you want to use Weights then make sure your Maximum Weight is as high as your Highest weight ...

If you do not want to add more to the Weight, be sure to set your Tare Rates to 0:0 ...

I had to make my own country for a zone that only covered Alaska, Virgin Islands, Guam, Puerto Rico, and Hawaii and I named it U1

It's not working because even though I selected "weight" as the calculation method it is still using price.

Weight (my cost) for Item A is 15 whereas price is 30 - - - If I put 3 of item A into the cart the price (retail) will be 90 and weight (my cost from supplier) is 45. Rate is 29% so I want shipping to be 29% of order weight which should come out to 13.05 but instead comes out to 26.10

In the Shipping/Packaging I listed 5000 as max weight and 0:0 on the package percentage

For some reason the system is just not switching over from price to weight. I even added a new test item and still going off of price vs weight.

While I have your attention (assuming I do still) is there a way to disable all the countries I don't need without deleting them in case I want to use them at a later date? BTW - I do appreciate your help. I can add to and edit whatever I'm told to but as to make changes on my own - I'm totally ignorant.

Which Zone is giving the wrong shipping rate?

If you are using Zones on your Shipping and using the Zone Rates zones for the method, you could set all the Countries that you do NOT ship to in the:

Skip Countries, use a comma separated list of the two character ISO country codes

Then, if there is no Shipping there is not way to checkout ...

This still allows Grandma in the UK to ship a shinny new crutch to Tiny Tim in New York ... :cool:

Glad I asked that question - I hadn't even thought about someone out of my shipping area sending something to someone in it.

As far as what zone doesn't work - I haven't got past testing the first one yet. I'm considering just using the clones of the perweightunit then using a low order fee but that will collect too much for orders just under my 29.99 mark and it doesn't look as good but I have to go pick up my daughter from Pre-k.

Thanks for all of your help. I don't think its a zone issue - just something preventing it from calculating from the weight field instead of the price field - it obviously works from the price field with the same zones. Any suggestions are appreciated and I'll respond when I get back.

No matter what I tried I could not get the zone rate to calculate using the weight times a percentage but it did use the weight to calculate shipping if I used whole numbers rather than percentages. It was a pain but I calculated up to 500 in increments of 5 (as to come as close as possible to actual shipping charged using an excel spreadsheet and notepad++

Talk about a lot of variable...
35:10.5,40:12,45:13.5,50:15,55:16.5,60:18,65:19.5,70:21,75:22.5,80:24,85:25.5,90:27,95:28.5,100:30,105:31.5,110:33,115:34.5,120:36,125:37.5,130:39,135:40.5,140:42,145:43.5,150:45,155:46.5,160:48,165:49.5,170:51,175:52.5,180:54,185:55.5,190:57,195:58.5,200:60,205:61.5,210:63,215:64.5,220:66,225:67.5,230:69,235:70.5,240:72,245:73.5,250:75,255:76.5,260:78,265:79.5,270:81,275:82.5,280:84,285:85.5,290:87,295:88.5,300:90,305:91.5,310:93,315:94.5,320:96,325:97.5,330:99,335:100.5,340:102,345:103.5,350:105,355:106.5,360:108,365:109.5,370:111,375:112.5,380:114,385:115.5,390:117,395:118.5,400:120,405:121.5,410:123,415:124.5,420:126,425:127.5,430:129,435:130.5,440:132,445:133.5,450:135,455:136.5,460:138,465:139.5,470:141,475:142.5,480:144,485:145.5,490:147,495:148.5,500:150

And that's just for one zone!