Help With YellowFreight Table Rate Shipping

[TesterServers]

Hello,

I have a YellowFreight (now named "YRC") table rate chart, but I'm not sure how to implement it into the store zones.


I'm trying to implement it into my store but I'm confused as to how am I suppose to set it up to calculate the shipping prices for the continental 48 U.S. States.

I used a query from this site that created the lower 48 states zones for my store. The problem is that I'm not sure how would I use the table like below to calculate the shipping.

Another issue I have is that the table below is for (per 100 lbs). and some of my products are the same.

Shipping cost is based on weight+zip code.

Looking at the last row in the table below (zip code 01025), the cost is $84.82 PER 100 lbs. So, if the item weigh 200 lbs, the shipping cost would be

$203.34. I need to figure out how to achieve that.


ZIP1 = ORIGIN zip code
DEST = destination zip code starting range
RANGE = destination zip code ending range
ST = state <<<---------------------------------- (do I need this in the table since I have the "lower 48 states" zone created?)
CLS = shipping class <<<---------------------------------- (I don't need this field)
MIN = minimum shipping charge <<<------------------------ (I don't need this field)
L5C = less than 500 lbs. Freight is 150 lbs + up to 499 lbs.
5C = 500 lbs. to 999 lbs.
1M = 1,000 lbs to 1,999 lbs.
2M = 2,000 lbs to 4,999 lbs.
5M = 5,000 lbs to 9,999 lbs.
10M = 10,000 lbs to 19,999 lbs.
20M = 20,000 lbs to 29,999 lbs.
30M = 30,000 lbs to 39,999 lbs.
40M = 40,000 lbs to 40,001 lbs.
=====================================


FOR ZIP 30635 GA (OUTBOUND) <<<<----- Zip code where products come from. Shipping to the lower 48 U.S. states.


ZIP1|DEST|RANGE|ST|CLS|MIN|L5C|5C|1M|2M|5M|10M|20M|30M|40M

30635|01000|01001|MA|0050|279.51|101.67|84.82|66.06|54.07|41.72|40.85|38.75|38.7 5|38.75
30635|01002|01002|MA|0050|280.05|102.09|85.21|66.39|54.35|41.92|41.04|38.99|38.9 9|38.99
30635|01003|01004|MA|0050|279.51|101.67|84.82|66.06|54.07|41.72|40.85|38.75|38.7 5|38.75
30635|01005|01005|MA|0050|277.51|101.17|84.44|65.79|53.86|41.54|40.67|38.63|38.6 3|38.63
30635|01006|01009|MA|0050|279.51|101.67|84.82|66.06|54.07|41.72|40.85|38.75|38.7 5|38.75
30635|01010|01010|MA|0050|280.05|102.09|85.21|66.39|54.35|41.92|41.04|38.99|38.9 9|38.99
30635|01011|01025|MA|0050|279.51|101.67|84.82|66.06|54.07|41.72|40.85|38.75|38.75|38.75


*this table covers all the lower 48 states and zip codes.
*this price table is for items that are 150 lbs and more.
*this price table is only for certain categories/products.


Thanks for your help!


Kevin

[TesterServers]

What I should have mentioned earlier is that I have a .cgi script that I put codes together and with the help from another person around 6 years or so that works on my old site.

The .cgi script that I have will give the total shipping cost based on the zip code that they enter in. Now that I'm using Zen Cart, I need a shipping cost calculation that will give a freight shipping cost based on the WEIGHT+ZIP..... shipping from ZIP CODE 30635 GA

I wish there was an easy way to ship based on the zip+weight.

Most of my items weigh OVER 150 lbs, and I only ship to the lower 48 states. Remember, 150+ lbs is considered freight. I do use UPS on my site and it seems to work, except when the weight is 150 lbs, the UPS calculator won't give me a shipping quote because they don't ship over 150 lbs an item. So I use the shippers that my suppliers use, so I don't have to be calling them for shipping quotes. I base the shipping cost of the item from the supplier's zip code.

My other issue while doing this is that I have 2 different suppliers and my items ship from 2 different zip codes, but in the store, you can only have one zip code by default. I believe I saw a mod for it. I'll have to double-check that one.

From the table in the first thread, to be able to implement it on the store will solve any freight rates in the U.S.A. all that is needed is a table rate chart from the shipper's zip code.

My supplier's use

YRC(formally YellowFreight)
UPS
FedEx
FedExFreight

Like I said, the UPS mod I'm using seem to work ok until the weight of the items get to 150 lbs.

The YRC is what I am in desperate need of getting to work.


Thanks

[TesterServers]

UPDATE: I just thought of a temporary solution. I'll just copy the input form into each of the products page and the form will already contain the item no#. However, the shipping cost won't be added to the cart, but at least customers can get the shipping quote immediately.

What I really need is a way to convert that .cgi file into .php. Updating the shipping table can be done in a few minutes time, so I'm not concerned about that.

I'm still brainstorming on how to get it working inside of the store.

[TesterServers]

I found a promising solution here at YRC web site. The problem I now have is that I'm not sure of the blue bold part of the code below. The code is suppose to get a rate quote from a hyperlink I'm to add to my website.

Full page at YRC: http://www.yrc.com/e_commerce/hyperlinks.html#quote

Blue = I don't understand
Red = I don't need
Green = Hidden Fields

https://my.yrc.com/dynamic/national/servlet?
CONTROLLER=com.rdwy.ec.rexcommon.proxy.http.controller.
PublicProxyController&redir=/tfq504
&O_CITY= nnnnnnnnnnnnnnnnnnnnnnnnn
&O_STATE=nn&O_ZIP=nnnnnn&O_CTRY=nnn
&D_CITY= nnnnnnnnnnnnnnnnnnnnnnnnn
&D_STATE=nn&D_ZIP=nnnnnn
&D_CTRY=nnn&WGT1=nnnnnn
&CLASS1=nnnn&OPT_SS=off&OPT_NTFY=off
&OPT_HAZM=off&OPT_ID=off&OPT_IP=off
&OPT_HOMD=off&OPT_HOMP=off
&OPT_LFTO=off&OPT_LFTD=off
&OPT_COD=off&COD=0.00&PU_DATE=nn/nn/nn
&CURRENCY=nnn&COMPUTE=QUOTE
&DISPLAY=PAGE

REQUIRED parameters:

O_CITY = Origin City
O_STATE = Origin State
O_ZIP = Origin ZIP
O_CTRY = Origin Country
D_CITY = Destination City
D_STATE = Destination State
D_ZIP = Destination ZIP
D_CTRY = Destination Country
WGT1 = Weight of the Shipment -Note:Up to six weights/classes can be entered (e.g., use WGT2 CLASS2)
CLASS1 = Freight Class (e.g., 50, 77.5)
PU_DATE = Pickup Date
CURRENCY = Rated Currency display in U.S. or Canadian dollars(USD or CAD)

==============END CODE INFO===============

If I'm to make a hyperlink do I need to make a form and add the fields and such to form?

Also, I'm confused as to the ACTION and POST method according to the above. I'm not sure how I'm suppose to insert the link.

Any help greatly appreciated.


Thanks

Kevin

[TesterServers]

I have created a form on a test site at

http://testing-servers.com/yrc-shipping-link-form.php

and when I submit the form it doesn't display any rates. The code I've used from YRC to make the form is below:

<table width="200" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><form id="form1" name="form1" method="post" action="https://my.yrc.com/dynamic/national/servlet?CONTROLLER=com.rdwy.ec.rexcommon.proxy.http.controller.PublicProxyController&amp;redir=/tfq504">
      <p>
        <input name="O_CITY" type="hidden" id="O_CITY" value="Columbus" />
        <input name="O_STATE" type="hidden" id="O_STATE" value="MS" />
        <input name="O_ZIP" type="hidden" id="O_ZIP" value="39703" />
        <input name="O_CTRY" type="hidden" id="O_CTRY" value="USA" />
        <input name="D_CTRY" type="hidden" id="D_CTRY" value="USA" />
        <input name="WGT1" type="hidden" id="WGT1" value="200" />
        <input name="CLASS1" type="hidden" id="CLASS1" value="50" />
        <input name="CURRENCY" type="hidden" id="CURRENCY" value="USD" />
        <input name="DISPLAY2" type="hidden" id="DISPLAY2" value="PAGE" />
      </p>
      <p><label></label>
        <label for="textfield">City</label>
        <input type="text" name="D_CITY" id="D_CITY" />
        &nbsp;</p>
      <p>
        <label for="label">State</label>
        <input name="D_STATE" type="text" id="label" size="10" maxlength="2" />
      </p>
      <p>
        <label for="label2">Zip Code</label>
        <input type="text" name="D_ZIP" id="label2" />
      </p>
      <p>
        <label for="textfield">PU Date</label>
        <input type="text" name="PU_DATE" id="PU_DATE" />
      </p>
      <p>
        <label for="Submit">Submit</label>
        <input type="submit" name="DISPLAY" value="Submit" id="DISPLAY" />
      </p>
    </form>
      <p>&nbsp;</p>
    <p>&nbsp;</p></td>
  </tr>
</table>

The YRC shipping code is listed here:
http://www.yrc.com/e_commerce/hyperlinks.html#quote
but I don't know why it's not giving me the rates. If I hit the"Back" button on the web site to go back to the page to get the quote and put in the same data, it displays the rate.

What am I doing wrong?

Thanks for your help.

[TesterServers]

Problem Solved!

The form was missing a field/value which was

COMPUTE=QUOTE

The form works and displays the shipping quotes and other info I hid in the form.


Kevin.

[TesterServers]

Hello,

I finally got my YRC shipping rate working properly and I have a question.

When a person fills out the form on my site they have to fill in a date in the format of 03/28/11 then hit the "submit" button to get a shipping quote.

My question is how can I create a hidden date field that automatically inserts a date 7 days ahead before or when the form is submitted?

Since my customers won't know the exact date their product will ship out, I rather that field get filled out automatically, so that the customer doesn't have to bother with it.

Any help appreciated.


Kevin

[TesterServers]

Hello,

I am using the shipping hyperlink from YRC yrc.com/e_commerce/hyperlinks.html

and everything is working fine on my site, but the problem I have is that when the person submits the form, it takes them to YRC and at the same time they are leaving my site. I can set the link to open in another tab or window, but that's not what I need.

I am in need of a way for the customer to get the shipping quote and add it to their shopping cart somehow. I'm not sure how to do this because the cart will have to read that shipping quote page somehow.

I also want for the person to get their quote and still be on my shopping cart at the same time. I was thinking about frames, but I'm not sure if it'll work with Zen Cart or not.

Any ideas as to how I can achieve this?


Thanks


Kevin