Per Weight Unit Shipping

[mikeel100]

You and I went through a very long discussion on handling shipping for my website last year.

You recommended http://ceon.net/software/business/ze...vanced-shipper and I have not used that software, but I think maybe it's time to give it a second and very serious look.

If you have a simple fix for my current situation, I'll use it...otherwise, the solution may be in Ceon Advanced Shipper.

[Ajeh]

You say there is something for:

SHIP_METHOD can be Individual Shipping, UPS RATES, or Free Shipping

Is that a field in the table:
products

that holds this information?

[mikeel100]

It is not in zen_products; however, I could create a new column in zen_products that does contain the type of shipping that applies to the individual products.

I am a little cautious about changing any of the fields, code, or tables in the basic zen cart program...will adding a column to zen_products mess with the basic programming?

If I add the ship_method column to zen_products, which shopping cart, paypal, or other files would I need to modify to tell the checkout process to only show one shipping method?

Thanks again for your help.

[Ajeh]

Once you have a field in the table:
products (or in your case zen_products)

you can test for that field in your shipping modules ...

Using a field such as:
products_shipping

I would make it a tinyint 1:

ALTER TABLE products ADD products_shipping tinyint(1) DEFAULT '0';

In your case use:

ALTER TABLE zen_products ADD products_shipping tinyint(1) DEFAULT '0';

Then use 0 for Normal shipping for UPS and 1 for FREE SHIPPING! freeshipper and 2 for Per Unit perweightunit ...

You made need a programmer to help you set up the field on the import method you use ...

Now you can test the order in the shipping modules to see what kinds of Products are in there ...

NOTE: there will be several parts to this as you have Products with UPS shipping and Per Unit perweight shipping and when you have a Mixed cart for both you need your UPS to calculate the both the quote from UPS and then the Per Unit perweightunit cost has to be added on ...

The shipping weight can be adjust in the class for shipping to remove the weight from the Products for products_shipping 2 so that the quote weight for UPS is correct then utilize the weight removed for Per Unit perweightunit ...

You will need quite a few customizations for this, but it can be done ...

[mikeel100]

Thanks, I started the mods in my test cart last night...will have to study the shipping, shopping cart, and paypal modules in depth to see where I need the changes. I appreciate your insight and guidance.

If I find a solution, I will post it here.

[Ajeh]

You should be able to do everything in the shipping modules and the shipping class file and not need to touch paypal ...

[mikeel100]

Thanks.

[RonGin]

Hello, I am having a hard time figuring out shipping rates. I have the free shipping option now fixed (thank you). My cart shows the free shipping with just a handling charge, but under that it has best way which is less than the free shipping with handling charge.
I think I have the per weight all messed up. product weight is 1 ounce so I put 0.16 in product weight in catalog, now in per weight i put 10:0.16 is this right or wrong?
Thanks for the help
Ron

[Ajeh]

The Product Weight is added in pounds ... so 1 ounce is 0.0625 ...

I am not following where you are adding this when you say:

now in per weight i put 10:0.16 is this right or wrong?

[RonGin]

Hello,
OK and thank you, the weight is corrected and the free option shipping seem to be working. But if I add a item that is not free shipping it adds this into free shipping now.
Also if I just purchase an item with out free shipping I am getting this error now [ Error Your available shipping options have changed. Please re-select your desired shipping method. ]

Thank you again
Ron