Printable View
I'm using this module and when I go to the checkout and select a quantity of 13 units at 25 lbs each the total per weight unit shipping cost is 13*25= $325. The per weight unit shipping says the formula that is used is Product Quantity * Units (products_weight) * Cost per Unit. Am I doing something wrong? I have the tare weight set at 0 and max units at 5000. Thanks, :wacko:Charles
The Per Unit perweightunit shipping module is designed to take the Total Weight and multiply that by the Rate ...
If you set the Product Weight to 1 and buy 10 and the Per Unit Rate is 1 the charge is:
1 * 10 * 1 = $10.00
If you set the Product Weight to 1.25 and buy 10 and the Per Unit Rate is 1 the charge is:
1.25 * 10 * 1 = $12.50
If you set the Product Weight to 1 and buy 10 and the Per Unit Rate is 2 the charge is:
1 * 10 * 2 = $20.00
If you set the Product Weight to 25 and buy 13 and the Per Unit Rate is 1 the charge is:
13 * 25 * 1 = $325.00
What are you "meaning" the charge to be for this Product?
Thanks for the answer, I understand how it works now. To answer your questions, for each product weight there is a different value (ie: product a = 15lbs whereas product b = 25lbs.) The actual weight I stated in previous email (25lbs) is the weight of 50 rolls of paper cash register receipts inside a shipping box minus the tare weight. Speaking of the tare weight, I read in a previous post that it is not necessary or a factor for shipping by unit? Charles
You want to set the Tare Rates to 0:0 as they are used in a calculation to add weight and you do not want the weight adjusted in any manner ...
The Maximum Weight 5000 is so that the Total Weight is not adjusted in any manner, either ...
My apologies if I've put this question in the wrong place...did a search for "prevent ups rates from displaying during checkout when perweightunit is used" and got no results.
I use freeshipper (zero weight), ups, and perweightunit (flat rate) for shipping on my website.
How do I prevent the ups rates from showing up during checkout when the flat rate shipping applies to the product?
It senseless to display the outrageous UPS rates on a product when the flat rate price is so much cheaper.
You have me a tad confused here ...
You say you want to use:
FREE SHIPPING! freeshipper
UPS ups
Per Unit perweightunit
But then you reference:
perweightunit (flat rate)
Where does the Flat Rate flat come into play here?
When you want to disable the UPS shipping module and use Per Unit perweightunit ... how do you use UPS and Per Unit perweightunit in combination with one another?
You also have Maximum Weight at 5000 ... this means that when Shipping Weight exceeds 70lbs for UPS that UPS will not be able to provide quotes ...
So I am a tad befuddled here ... could you perhaps type really really slow and explain what you are trying to do with your shipping? :lookaroun
I have a few thousand of products that have different flat rate shipping rates, several thousands products with free shipping (zero weight), and many thousands of products with UPS rates...
I have been using freeshipper and UPS successfully for almost a year. In the past, I added shipping cost back into the base price and sale price with my php scripts which enabled me to handled flat rate shipping products as "free shipping" products. Some people may not appreciate that...semantics. So I'm trying to reflect exactly how the shipping prices are handled via my supplier.
I am trying to add perweightunit to handle my products that have flat rate shipping.
When I enabled perweightunit shipping, it caused the UPS shipping price to show up with an outrageously high shipping price on products that have flat rate shipping (because the shipping price is inserted in the weight slot). I need to stop UPS prices from displaying during checkout on products that have flat rate shipping.
On products that do not have flat rate shipping (I.E. UPS rates), the flat rate shipping shows up as an option during checkout as a lower amount than the UPS rates. I do not want flat rate to display on products tagged as UPS shipping.
There are no issues with free shipping...
I hope I've made it clearer than muddy water this time...LOL.
Appreciate your help.
What would be a could indicator in the table:
products
to distinguish which Products uses UPS and which Products use Per Unit perweightunit?
Do you have a field for this? Or can master_categories_id be used for this?
I don't see any "could" indicators in the zen_products table.
The initial table (my_products_dsdi) I import my products and updates in to has columns call "SHIP_METHOD" and "SHIP_PRICE".
SHIP_METHOD can be Individual Shipping, UPS RATES, or Free Shipping
SHIP_PRICE can be 0 - whatever
I'm not sure what you are implying by "can the master_categories_id be used for this".
Thanks.
I see where the confusion may be coming in. I ran across a method of using perweightunit to handle different flat rate shipping charges on Picaflor-Azuls website.
The native Flat Rate shipping module in Zen Cart isn't flexible enough to handle many different rates (without modification) so I was looking for alternatives.
Within perweightunit, setting the shipping cost per unit to 1 and putting the shipping cost into the weight field does enable me to have many different flat rate shipping rates...but it also screws up the UPS module.
So, I hope that clarifies the confusion.
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.
You say there is something for:
Is that a field in the table:Quote:
SHIP_METHOD can be Individual Shipping, UPS RATES, or Free Shipping
products
that holds this information?
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.
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:
In your case use:Code:ALTER TABLE 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 ...Code:ALTER TABLE zen_products ADD products_shipping tinyint(1) DEFAULT '0';
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 ...
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.
You should be able to do everything in the shipping modules and the shipping class file and not need to touch paypal ...
Thanks.
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
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:
Quote:
now in per weight i put 10:0.16 is this right or wrong?
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
How are you marking a Product as Free shipping?
Are you using FREE SHIPPING! freeshipper or Free Shipping Options freeoptions for managing Free shipping?
What are your settings in the Configuration ... Shipping/Packaging ...
Hello, I am using the free shipping option and per unit weight. This is the set up on free shipping option:Enable Free Options Shipping
True
Shipping Cost
0.00
Handling Fee
1.95
Total >=
5.28
Total <=
Weight >=
0.375
Weight <=
0.376
Item Count >=
6
Item Count <=
Tax Class
--none--
Tax Basis
Shipping
Shipping Zone
--none--
Sort Order
1
This is the ship by unit or weight:
Per Unit
Enable Per Weight Unit Shipping
True
Shipping Cost per Unit
(products_weight) * Cost per Unit
Handling Fee
1.95
Handling Per Order or Per Box
Order
Tax Class
--none--
Tax Basis
Shipping
Shipping Zone
--none--
Sort Order
2
Thanks
Ron
I am not sure if I am not following what you are trying to do here or you have an incorrect setting on the Per Unit perweightunit shipping module ... what is your setting for:
The default is 1 for (1 * total weight) + handling fee = shipping costQuote:
Shipping Cost per Unit
NOTE: When using this Shipping Module be sure to check the Tare settings in the Shipping/Packaging and set the Largest Weight high enough to handle the price, such as 5000.00 and the adjust the settings on Small and Large packages which will add to the price as well.
The shipping cost will be used to determine shipping charges based on: Product Quantity * Units (products_weight) * Cost per Unit - in an order that uses this shipping method.
Sorry for all this trouble.
I have one category which I have put into effect free shipping options. In which I am selling 6 pair of earring for $5.28 in which I have set up the free shipping option for, at least it seems I have?
Do you only use one shipping module for the entire cart?
If not then I used the per unit for the rest of the cart, but I am not getting the shipping equation for this I think.
I have an item which weighs say 7 grams or 0.25 of and ounce so how would I get the per unit to handle this?
Then to add this to the equation a customer buys the free shipping option and now buys an item which is not free shipping, is the not free shipping pulling from per unit calculation or free shipping options.
Thank you
Ron
The way the Per Unit preweightunit shipping module is designed is to work based on the Total Weight in the Cart then multiply that by the charge on the Per Unit perweightunit shipping module ...
If you set the unit charge to 1, then what happens is the weight of the Products are multiplied by $1.00, so if you have Product Weight:
1 * 0.00 = $0.00
1 * .25 = $0.25
1 * .50 = $0.50
1 * 17.25 = $17.25
If you set the unit charge to 2, then what happens is the weight of the Products are multiplied by $2.00, so if you have Product Weight:
2 * 0.00 = $0.00
2 *.25 = $0.50
2 *.50 = $1.00
2 * 17.25 = $34.50
The thing to be careful of is when using the Per Unit perweightunit shipping module, in the Configuration ... Shipping/Packaging ... you should set the two Tare Rates to 0:0 and the Maximum Weight to 5000 or higher ...
Hello,
I just tried this and I am still getting just the handling charge of 1.95 no shipping cost in per weight unit shipping module.
do I add the formula 1*.50 in the product add weight box?
I don't see a way to add this into the shipping module itself.
Maybe there is something wrong with my cart?
If I can't get this to work I guess I will try a flat rate shipping charge but the weight vary greatly and this could be a loser if they order to many items.
I don't understand why this is so difficult for me to get.
Sorry
Ron
No on the Per Unit perweightunit just set the value to multiply the weight by, so if you want to multiply the weight by 1 set it to 1 or 1.00 ... if you want to multiply the weight by 2 set it to 2 or 2.00 ...
If you set it to 1 and and the weight in the cart is 3.75, then the shipping cost will be:
1 x 3.75 = $3.75
If you set it to 2 and the weight in the cart is 3.75, then the shipping cost will be:
2 x 3.75 = $7.50
WOW that worked I had the wrong thing in that box:)
However, now the free shipping show up with the ship by unit when checking out, So naturally a customer is goning to choose the fee shipping option.
I thought that if I set the free shipping opton for these 6 pair of earrings that the rest would be charge for shipping in cart, is the free shipping over riding all.
here is my set on free shipping this is for 6 pair of earrings with price totaling 5.28.
Enable Free Options Shipping
True
Shipping Cost
0.00
Handling Fee
1.95
Total >=
5.28
Total <=
Weight >=
0.375
Weight <=
0.376
Item Count >=
6
Item Count <=
Should I have to do more here?
Can you explain your settings a bit more?
These are OR settings and may not be doing what you think they are ... for example I do not understand your Weight settings and I am not sure of the other setting values either for what you are trying to do ...Quote:
Total >=
5.28
Total <=
Weight >=
0.375
Weight <=
0.376
Item Count >=
6
Item Count <=
Have you a link to your site that we could peek at and the products_id for some of these Products?
Hi,
this is a link to the earring category
http://www.stuffwholesale.com/index....ath=25_21_32_6
so if you buy 6 you would get free shipping, but if buy 5 or less you would not get any free shipping.
So I was thinking that the buy putting in the total price of $5.28 that this would not five free shipping for under that price or over that price?
And you would need 6 items plus the price to get free ship.
My problem is I just can not ship one at free ship I need to have the customer purchase a minimum of 6 for this to work.
Thanks
Ron
Hi,
I think I might have it will let you know later but thanks again for all the help with out it I would not have gotten this far.
Ron
Are the only Products that ever qualify for Free Shipping in the category for categories_id 6 when there are 6?
If there are 7, are 7 qualified for Free Shipping? or 8? or 9?
Does everything else in your shop have a shipping charge?
What I am looking for is that if the number of items from categories_id is >= 6 to subtract that weight from the order, thus no shipping charge ...
Currently, the Free Shipping Options freeoptions is using Totals/Weight/Item but it is not managing the categories_id that the products are coming from ...
If you were to create any order, but exclude adding anything from categories_id 6 to the cart, does the Per Unit perweightunit calculate the right shipping cost?
HI, Sad to say my fix did not work:(
The category id_6 is the only category with the free shipping, and yes if they order more than 6 they should get free shipping.
The cart when not using the free shipping option and just the per unit weight option is work right. I do have a couple of item I put on for free ship but I marked them in the product input page and the cart is working fine with that. The problem is when I throw in the category id_6
Thanks
Ron
A few things wrong on your site ... so, let's get things straightened out and cleaned up ...
Many of your Products are marked with excessive weight, this one for instance is 350:
/index.php?main_page=product_info&cPath=18&products_id=1010
Based on how Per Unit perweightunit works, are you wanting to charge $350.00 in shipping?
Next, many of your Products are marked as Product Unit 0, with a variety of Product Minimum. For example, this Umbrella:
/index.php?main_page=product_info&cPath=13&products_id=858
it is set to Product Unit 0 and Product Minimum 10 ...
You cannot order a Product in 0 units ... a Product has to be ordered in real units, such as the default of 1 as you need to buy at least 1 Umbrella and cannot buy 0 umbrellas ...
On the Product Minimum, this is the least number of items that the customer can order of a Product ...
Are you really wanting to force the customer to buy a Minimum of 10 Umbrellas?
Product Weight also has to be thought out on this Product ... you have the Product Weight set to 240, and based on the Per Unit perweightunit shipping module you would be charging the customer $240.00 for each umbrella and if there is a minimum of 10 on the Product Minimum then you would be charging the customer $2400.00 in shipping for 10 Umbrellas ... sounds a bit much ... :lookaroun
Back to the shipping issue ...
On the *other* products that are Free Shipping, as in not in categories_id 6, are you just setting those with Product Weight 0?
On ALL of the Products in categories_id 6, do they ALL weight the same amount? So if I checked for how many of the Products in the shopping cart are from categories_id 6, utilizing the master_categories_id, would they ALL ALWAYS weight the same amount?
The idea is to use just the Per Unit perweightunit shipping module and count how many items are in the cart from categories_id 6 and if it is greater or equal to 6 then reduce the weight of the shopping cart by subtracting out ALL of the Product Weight from Products in categories_id 6, leaving just the weight of everything else in the cart which would then compute the shipping cost ...
Does that seem to make sense?
The products you are referring to in this group is wholesale only and are shipped from china, my guy in china is sending me up date on the wieght which I will correct later, but does this affect the cart shipping if the customer does not put the product in?
now for the problem at hand I will try and answer:
Back to the shipping issue ...
On the *other* products that are Free Shipping, as in not in categories_id 6, are you just setting those with Product Weight 0?
Answer- I was not so I assume from this I should?
On ALL of the Products in categories_id 6, do they ALL weight the same amount? So if I checked for how many of the Products in the shopping cart are from categories_id 6, utilizing the master_categories_id, would they ALL ALWAYS weight the same amount?
answer-I will make them all the same as they are close in wieght but to answer the question no they were different
The idea is to use just the Per Unit perweightunit shipping module and count how many items are in the cart from categories_id 6 and if it is greater or equal to 6 then reduce the weight of the shopping cart by subtracting out ALL of the Product Weight from Products in categories_id 6, leaving just the weight of everything else in the cart which would then compute the shipping cost ...
Does that seem to make sense?
These solution seem to make sense to me but how would we achieve this i have look in the perwieghtunit module and don't see anything there that can be used?
Note: I did answer earlier but I did not see it in here so I am answering again but i think a little better:)
Happy Valentines day to you and the group:cool:
Ron
Just to be sure ... what version of Zen Cart are you running?
cart version is V 1.5.3
Ron
You could try customizing the files:
/includes/classes/shipping.php
and add the code in RED:
and the file:Code:if (is_array($this->modules)) {
$shipping_quoted = '';
$shipping_num_boxes = 1;
$shipping_weight = $total_weight;
// bof:reduce weight if 6 or more in cart from categories_id 6
$reduce_weight = .25; // weight per item
$chk_cat = $_SESSION['cart']->in_cart_check('master_categories_id','6');
if ($chk_cat >= 6) {
$shipping_weight = $shipping_weight - ($chk_cat * $reduce_weight);
}
// eof:reduce weight if 6 or more in cart from categories_id 6
$za_tare_array = preg_split("/[:,]/" , SHIPPING_BOX_WEIGHT);
/includes/modules/shipping/perweightunit.php
Code:// disable only when entire cart is free shipping
if (zen_get_shipping_enabled($this->code)) {
$this->enabled = ((MODULE_SHIPPING_PERWEIGHTUNIT_STATUS == 'True') ? true : false);
}
// bof:reduce weight if 6 or more in cart from categories_id 6
global $shipping_weight;
if ($shipping_weight <= 0) {
$this->enabled = false;
}
// eof:reduce weight if 6 or more in cart from categories_id 6
if ($this->enabled) {
// check MODULE_SHIPPING_PERWEIGHTUNIT_HANDLING_METHOD is in
Sorry I keep hitting the wrong button in this reply to form.
The cart now is only showing free ship even if I add an item which is not free ship. I see the shipping module is now unable to active the perweightunit method, that is probably why.
Sorry for all the trouble
Ron
Take two ...
Remove those changes and try adding these changes in RED:
See if that works better ...Code:function quote($method = '') {
global $order, $shipping_weight, $shipping_num_boxes;
$total_weight_units = $shipping_weight;
// bof: reduce weight if 6 or more in cart from categories_id 6
if ($shipping_weight <= 0) {
return false;
}
// eof: reduce weight if 6 or more in cart from categories_id 6
$this->quotes = array('id' => $this->code,
'module' => MODULE_SHIPPING_PERWEIGHTUNIT_TEXT_TITLE,
'methods' => array(array('id' => $this->code,
'title' => MODULE_SHIPPING_PERWEIGHTUNIT_TEXT_WAY,
'cost' => MODULE_SHIPPING_PERWEIGHTUNIT_COST * ($total_weight_units * $shipping_num_boxes) +
(MODULE_SHIPPING_PERWEIGHTUNIT_HANDLING_METHOD == 'Box' ? MODULE_SHIPPING_PERWEIGHTUNIT_HANDLING * $shipping_num_boxes : MODULE_SHIPPING_PERWEIGHTUNIT_HANDLING) ) ));
Hello, I regret to say that this did not work either. Maybe it just can not be done with out a lot of work on coding, I will keep the cart the way it is and stop the free options if when customer buys 6 I will refund them the money for shipping as a customer loyalty, I don't know.
Thank you for all the efforts and I will watch to see if anything like this comes us which I can use for this program. I will remove the code you gave me.
Ron
Can you give examples of when this did not work so it can be tested, and how you were expecting this to work if it was working right?
Hello, when I would check out with the last code the cart would show free shipping option and ship price option if I remember correctly. threw out this the cart would either show either or options.
I need the cart to show only one ship option at the end showing price to ship the order for both the free ship and the pay ship, not both option together so they can choose. The choices are made when they choose from group id 6 and any other item from other groups.
Thanks
Ron