Jump to content

Individual product shipping value.


Recommended Posts

Guest pataslak

what is the change you made on view_cart.php

no instruction in ship_price.php about this file but

you distribute a new file view_cart.php who is different from the original.

Link to comment
Share on other sites

  • 1 month later...

Guest illvisual

I know it says this mod will calculate shipping based on individual products but out of curiousity can it also do it based on the individual product's options?

Link to comment
Share on other sites

  • 2 months later...
Guest USCableCom.com

Well, help is needed here. I am brand new to PHP / SQL and have no programming experience, but I can pretty much figure out the basics just by looking at the code.

I have installed the individual shipping mod AND used the shipping mod install program and even looked in the database to verify that the new line for the shipping field is there.

This is what is happening...

I made all 4 shipping fields in the catagries $0.00

I made the shipping for the items $10.00

I added items to cart, checked out, and ALL shipping is $0.00

The shipping is not geting added in. What is going on and how can I get it to work?

The only thing I may have incorrect is the mod for the file order.php - The mod line numbers did not match up so this is how I added it in...

// first get shipping prices from category

$sel_cat = "select cat_id from ".$prefix."store_inventory where product = '$product'";

$result_sel_cat = mysql_query($sel_cat);

$row_cat = mysql_fetch_array($result_sel_cat);

$cat_id = $row_cat[cat_id];

$sel_ship = "select * from ".$prefix."store_category where cat_id = '$cat_id'";

$result_sel_ship = mysql_query($sel_ship);

$row_ship = mysql_fetch_array($result_sel_ship);

$per_ship = $row_ship[$per_shipment];

$per_it = $row_ship[$per_item];

// Individual item shipping prices

$item_ship_price = "select ship_price from ".$prefix."store_inventory where product = '$product'";

$result_item_ship_price = mysql_query($item_ship_price);

$row = mysql_fetch_array($result_item_ship_price);

$ship_price = $row[ship_price];

// select highest per_ship or per_int_ship and multiply item_ship or item_int_ship

$total_per_item = ($per_it * $quantity) + $total_per_item;

if($per_ship>$max_per_ship){$max_per_ship=$per_ship;}

}// ends loop for each product

Any help on how to fix this?

Link to comment
Share on other sites

This is what is happening...

I made all 4 shipping fields in the catagries $0.00

I made the shipping for the items $10.00

I added items to cart, checked out, and ALL shipping is $0.00

The shipping is not geting added in. What is going on and how can I get it to work?

The only thing I may have incorrect is the mod for the file order.php - The mod line numbers did not match up so this is how I added it in...

    // first get shipping prices from category

$sel_cat = "select cat_id from ".$prefix."store_inventory where product = '$product'";

$result_sel_cat = mysql_query($sel_cat);

$row_cat = mysql_fetch_array($result_sel_cat);

$cat_id = $row_cat[cat_id];

$sel_ship = "select * from ".$prefix."store_category where cat_id = '$cat_id'";

$result_sel_ship = mysql_query($sel_ship);

$row_ship = mysql_fetch_array($result_sel_ship);

$per_ship = $row_ship[$per_shipment];

$per_it = $row_ship[$per_item];

// Individual item shipping prices

$item_ship_price = "select ship_price from ".$prefix."store_inventory where product = '$product'";

$result_item_ship_price = mysql_query($item_ship_price);

$row = mysql_fetch_array($result_item_ship_price);

$ship_price = $row[ship_price];

// select highest per_ship or per_int_ship and multiply item_ship or item_int_ship

$total_per_item = ($per_it * $quantity) + $total_per_item;

if($per_ship>$max_per_ship){$max_per_ship=$per_ship;}

    }// ends loop for each product

Any help on how to fix this?

The sape happend to me...

Any suggestion?

Link to comment
Share on other sites

Guest qdpie.com

You're not reading all the install instructions. You forgot to do this.

// Add After

//  // select highest per_ship or per_int_ship and multiply item_ship or item_int_ship

//  $total_per_item = ($per_it * $quantity) + $total_per_item;

$total_per_item_ship = ($ship_price * $quantity) + $total_per_item_ship;

 

// Line 444 before additions, 450 after (REPLACE)

$total_ship = $total_per_item + $max_per_ship; (WITH)

$total_ship = $total_per_item + $max_per_ship + $total_per_item_ship;

Link to comment
Share on other sites

Guest USCableCom.com

// Add After

//  // select highest per_ship or per_int_ship and multiply item_ship or item_int_ship

//  $total_per_item = ($per_it * $quantity) + $total_per_item;

$total_per_item_ship = ($ship_price * $quantity) + $total_per_item_ship;

Ok, thanks... But I DID do everything that the instructions stated. But the part that I quoted above are NOT IN the instructions.

I added and now all is working great! Thanks again!

Link to comment
Share on other sites

Ok, i have read all of these posts, d/l the mods installed everything and now I'm getting this error on my checkout screen:

checkout-error.gif

No shipping costs are being displayed either.

Any help would be greatly appreciated.

Thanks,

Sean

Link to comment
Share on other sites

Guest qdpie.com

Looks like you messed something up when editing or forgot to add something. Your sql error is because you're trying to call for something that doesn't exist. See what the query is on line 433 of order.php.

Link to comment
Share on other sites

  • 1 month later...

:) ok. I am a bit confused. I had no problem adding the entry in the database but what is the deal with the english.inc.php file??

Link to comment
Share on other sites

You're not reading all the install instructions. You forgot to do this.

// Add After

//  // select highest per_ship or per_int_ship and multiply item_ship or item_int_ship

//  $total_per_item = ($per_it * $quantity) + $total_per_item;

$total_per_item_ship = ($ship_price * $quantity) + $total_per_item_ship;

 

// Line 444 before additions, 450 after (REPLACE)

$total_ship = $total_per_item + $max_per_ship; (WITH)

$total_ship = $total_per_item + $max_per_ship + $total_per_item_ship;

where exactely are we supposed to add that??

Link to comment
Share on other sites

maybe someone could post (for download) the correct additions to the files needed to add this to Cubecart. The only thing I was able to do was set the ship_price in the database. :)

Link to comment
Share on other sites

  • 2 weeks later...
  • 1 month later...
  • 3 weeks later...
  • 1 month later...

i cannot download this file, it doesn't exist. Does anyone have it? If so please PM me also in case i cannot find the post again later.

edit: nevermind, i managed to find it.

Link to comment
Share on other sites

  • 2 weeks later...

I have installed this mod and now have a question.

I have not gotten any errors but I do have a strange problem. I made the modification and conducted a test-order. Once I completed the test order, I returned to the site a while later, and found that the item I had purchased was still listed as being in my shopping cart.

Is this an issue anyone else is having with this mod or am I having problems in other areas of my store?

**UPDATE**

The item I use to test my purchase remains in the shopping cart even after I log-out as a specific customer and become a guest. I can log-out, close the browser window, wait 30min - 1hr, come back and the item I purchased is still in the cart. How is this possible? I have modified my cookie settings to last only 5min, is there something I changed when I added this mod?

Thanks for putting something like this out for all to use,

Jon

www.490skateboards.com :)

Link to comment
Share on other sites

  • 1 month later...

I just installed this mod and I also have the problem that it lets me add the shipping price to the individual item OK but when it calculates the total shipping in order.php it does not add it to the total shipping amount. (The shipping held on the category is calculated correctly.)

I already have the Free shipping over a certain amount mod installed (although it is currently disabled) so am not sure if I have the code to add the individual product shipping amount in the right place.

The altered section of code looks like this :

// first get shipping prices from category

$sel_cat = "select cat_id from ".$prefix."store_inventory where product = '$product'";

$result_sel_cat = mysql_query($sel_cat);

$row_cat = mysql_fetch_array($result_sel_cat);

$cat_id = $row_cat[cat_id];

// Individual item shipping prices

$item_ship_price = "select ship_price from ".$prefix."store_inventory where product = '$product'";

$result_item_ship_price = mysql_query($item_ship_price);

$row = mysql_fetch_array($result_item_ship_price);

$ship_price = $row[ship_price];

 

$sel_ship = "select * from ".$prefix."store_category where cat_id = '$cat_id'";

$result_sel_ship = mysql_query($sel_ship);

$row_ship = mysql_fetch_array($result_sel_ship);

$per_ship = $row_ship[$per_shipment];

$per_it = $row_ship[$per_item];

// select highest per_ship or per_int_ship and multiply item_ship or item_int_ship

$total_per_item = ($per_it * $quantity) + $total_per_item;

$total_per_item_ship = ($ship_price * $quantity) + $total_per_item_ship;

if($per_ship>$max_per_ship){$max_per_ship=$per_ship;}

    }// ends loop for each product

                $cart_total=$cart->cart_total($prefix,$session,$sale);

  $total_ship = $total_per_item + $max_per_ship + $total_per_item_ship;

  $pre_total_tax = $cart_total * ($site_tax/100);

  $payable = $cart_total + $total_ship + $pre_total_tax;

   

  $total_ship = sprintf("%.2f", $total_ship);

  $pre_total_tax = sprintf("%.2f", $pre_total_tax);

  $payable = sprintf("%.2f", $payable);

Can anyone point out where it's wrong please ?

Thanks

Link to comment
Share on other sites

Don't know what's happening with this but it seems to have miraculously started working Ok now ! I wonder whether it could be a problem with caching ?

Edited by Jaz
Link to comment
Share on other sites

  • 2 weeks later...
Guest Bitz'n'Batz

Hi there sorry to butt into this but as anyone had a problem adding products after installing this mod as i cant add any products since i put it in. It say my product was successfull but when i go to my categorys there is nowt there?

Its ok sorted it!!!

Edited by Bitz'n'Batz
Link to comment
Share on other sites

I find the additional Mod very useful. Have upload the scrip and it work fine except for one problem.

When payment is made using PayPal and additional shipping charge is being added and I wonder where the amount comes from.

Any help greatly appreciated

William

Link to comment
Share on other sites

  • 3 weeks later...

Hi,

I've wrote a shipping by weight mod. All products have a set weight, and there are some new admin screens so you can add in your shipping options. Next Day, 3 Day, Normal, etc, with different prices are different weights. And the customer can then choose the delivery service on the checkout page.

http://www.philcartmell.com/services/cubec...dification.html

I charge £25 to install this onto your server, or £15 if you want the instructions/files.

Kind Regards

Phil

Link to comment
Share on other sites

  • 3 months later...
Guest the newborn

The link doesnt work for this file and i really need it lol, can anybody help?

Thanks in advance B)

Link to comment
Share on other sites




×
×
  • Create New...