Page 1 of 2 12 LastLast
Results 1 to 10 of 14
  1. #1
    Join Date
    Jan 2009
    Posts
    107
    Plugin Contributions
    0

    Default Adding Freight Shipping for specific items based on State Location

    A few of our items are shipped via Freight carrier. And with that being said, they are fllat rates to each specific state. There is also a factor of a residential fee, which I can add as an attribute.

    Example: Alabama $133.00 Florida $145.00 Maine $168.00 and so forth. I was thinking of adding each state as an attribute, but then the customer could always pick a lower priced location like Alabama and be shipped to Florida based on their actual address.

    Any suggestions would be great!

  2. #2
    Join Date
    Jan 2009
    Posts
    107
    Plugin Contributions
    0

    Default Re: Adding Freight Shipping for specific items based on State Location

    I suppose another means would be to take an average of all states for each specific item and do it that way. And then just bump up the weight in the product listing to hit that amount. Now with that being said, how would I remove the weight showing on the product page as well as on the shipping estimator?

    Since for example to hit my average shipping on the product im testing with, it will have to be 145lbs. And the actual product is no more than 25lbs.

    ANY thoughts/suggestions would be great.

  3. #3
    Join Date
    Jan 2009
    Posts
    107
    Plugin Contributions
    0

    Default Re: Adding Freight Shipping for specific items based on State Location

    TTT for per state/per item config reply

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Adding Freight Shipping for specific items based on State Location

    How many items are priced special by state?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  5. #5
    Join Date
    Jan 2009
    Posts
    107
    Plugin Contributions
    0

    Default Re: Adding Freight Shipping for specific items based on State Location

    Thanks for the reply.

    I would say right now under 50, but might go higher as the weeks go on.

  6. #6
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Adding Freight Shipping for specific items based on State Location

    You could add a new table and design it to contain the products_id and zone/state and cost data so a look up can be done and if found, that amount would be added to the shipping ...

    This would allow you to customize the cost on a per product per state level ...

    It could then be added in to any of the shipping modules ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  7. #7
    Join Date
    Jan 2009
    Posts
    107
    Plugin Contributions
    0

    Default Re: Adding Freight Shipping for specific items based on State Location

    How would I go about creating a new table? Any links would be great

  8. #8
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Adding Freight Shipping for specific items based on State Location

    You would use phpMyAdmin to add the table and new fields to your database ...

    Create a new table such as:
    products_shipping_per_zone

    Then add in the fields that you need ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  9. #9
    Join Date
    Jan 2009
    Posts
    107
    Plugin Contributions
    0

    Default Re: Adding Freight Shipping for specific items based on State Location

    While working with Linda today, I got my Table setup.

    When I run an Run SQL query/queries on any other Table with no addition filters selected, I see the table structure. However when I do that for the table we created, no table shows other than:

    MySQL returned an empty result set (i.e. zero rows). (Query took 0.0034 sec)
    SQL query:
    SELECT *
    FROM `products_shipping_per_zone`
    WHERE 1
    LIMIT 0 , 30

    Not sure how to proceed and dont want to keep bothering Linda.

  10. #10
    Join Date
    Mar 2006
    Location
    Australia
    Posts
    289
    Plugin Contributions
    3

    Default Re: Adding Freight Shipping for specific items based on State Location

    Hi there
    I assume that you have phpmyadmin installed on your server (mine is available from my cpanel login). In phpmyadmin you can see your structure and also add fields etc. Alternatively the proper syntax is:
    describe table_name eg DESCRIBE products_shipping_per_zone to see the structure of the table and show tables will give you a list of all tables to double check your table name

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. v138a Calculating shipping for heavy items freight by truck
    By icecold in forum Built-in Shipping and Payment Modules
    Replies: 2
    Last Post: 5 Apr 2012, 10:35 PM
  2. Adding extra shipping charge to specific items
    By kevinoneil68 in forum General Questions
    Replies: 1
    Last Post: 22 Nov 2011, 02:21 AM
  3. How do I assign FREE or DISCOUNTED SHIPPING to specific items or based on total?
    By hugozc in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 29 Nov 2009, 11:48 PM
  4. Free shipping for specific items
    By narsaw in forum Setting Up Specials and SaleMaker
    Replies: 2
    Last Post: 4 Jun 2006, 03:19 AM
  5. Shipping based on # items, service, location?
    By Kreation in forum Built-in Shipping and Payment Modules
    Replies: 4
    Last Post: 16 May 2006, 01:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR