Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[contribution] individual product shipping prices


Recommended Posts

Hi everybody.

 

After all its up and running.

But, there's one strange thing that stil occurs:

 

If I order a product with NO individual shipping costs, i have NO options to change the shipping method.

 

On checkout_shipping then you can only change the address and enter a comment, thats all.

 

The weird thing about it is, that if you order both a product with individual costs and a product without individual costs, then it shows all the shipping options and the text, that says that there is extra charge for the individual shipping.

 

 

Where is the mistake?

 

If have no error messages, so what is wrong?

 

Thanks a lot in advance.

 

MFGK

---Freakstyler in the Hood!

Link to comment
Share on other sites

I have solved it:

 

something in the includes/classes/shipping.php

had to be changed:

 

i read that those lines had to be commented out:

 

if ((tep_get_configuration_key_value('MODULE_SHIPPING_INDVSHIP_STATUS')) && $shiptotal) {
$include_modules[] = array('class'=> 'indvship', 'file' => 'indvship.php');
}

 

but for me they were necessary to be left as this.

 

 

Also according to those lines:

 

if ((tep_get_configuration_key_value('MODULE_SHIPPING_FREESHIPPER_STATUS')) && $cart->show_weight()==0 && $shiptotal = NULL) {

          $include_modules[] = array('class'=> 'freeshipper', 'file' => 'freeshipper.php');

        } else {

        // All Other Shipping Modules

  if(sizeof($products)>$indvcount){

          while (list(, $value) = each($this->modules)) { //todo//try foreach is faster//hadir

 

the line below the "// All Other Shipping Modules"

was not in the new code that was given, but it was in my original code, so i added

it to the new code.

 

Now everything is fine.

---Freakstyler in the Hood!

Link to comment
Share on other sites

Well, I followed the instructions to a "T" and modified all the pages. I also manually created the table "products_shipping" in my database. When that didn't work, I create "table_products_shipping". I've logged out and logged in..

 

The error I get when going to modify a product to add the shipping is:

 

1146 - Table 'databasename.TABLE_PRODUCTS_SHIPPING' doesn't exist

 

SELECT * FROM TABLE_PRODUCTS_SHIPPING WHERE products_id=28

 

[TEP STOP]

 

But it does exist....

 

What should I do?

Link to comment
Share on other sites

Question...

 

I have the older version installed. It works great all the way until you get to the shipping options page. If you have other items, it only shows the individual product shipping price.

 

My questions is this...

Is the latest release done or is it a BETA release? I guess that I just want to know if it is ready to be installed into my site yet or not?

L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Link to comment
Share on other sites

This has been mention a few times in previous post but I will give it a shot again.

This is a great contrubution and it works great for my shop, but........

If someone could create or modifi this to have zones

Example: Produuct XXX $5.00 Zone 1- Washington,Oregon, Idaho

$7.50 Zone 2- California, Nevada,New Mexico,Utah

$8.00 Zone 3- Louisiana, Mississippi,Texas,Florida

 

Product YYY $7.50 Zone 1- Washington,Oregon, Idaho

$8.50 Zone 2- California, Nevada,New Mexico,Utah

$9.50 Zone 3- Louisiana, Mississippi,Texas,Florida

 

And so on.

There is a state based shipping mod but it does not have the abbility to do separete prices per product. A feature I must have.

Any help would be great :thumbsup:

Raymond

Link to comment
Share on other sites

Hi everyone, this mod is great. Thanks again to crashwave for rushing this release for me. I have noticed a problem however. I use the free shipping contribution and I have found that when one item has individual shipping and the other has free shipping the customer gets the regular payment options for the free shipping item instead of the free shipping. :-" mouthfull. Does anyone know how to change this? I've looked it over myself but I guess I'm still not good enough to get it to work :huh: My code is below.

 

if ( defined('MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING') && (MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING == 'true') ) {

$pass = false;

 

switch (MODULE_ORDER_TOTAL_SHIPPING_DESTINATION) {

case 'national':

if ($order->delivery['country_id'] == STORE_COUNTRY) {

$pass = true;

}

break;

case 'international':

if ($order->delivery['country_id'] != STORE_COUNTRY) {

$pass = true;

}

break;

case 'both':

$pass = true;

break;

}

 

$free_shipping = false;

if ( ($pass == true) && ($order->info['total'] >= MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER) ) {

$free_shipping = true;

 

include(DIR_WS_LANGUAGES . $language . '/modules/order_total/ot_shipping.php');

}

} else {

$free_shipping = false;

}

 

if ($free_shipping == false) {

$check_free_shipping_basket_query = tep_db_query("select products_id from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . (int)$customer_id . "'");

while ($check_free_shipping_basket = tep_db_fetch_array($check_free_shipping_basket_query)) {

$check_free_shipping_query = tep_db_query("select products_free_shipping from " . TABLE_PRODUCTS . " where products_id = '" . (int)$check_free_shipping_basket['products_id'] . "'");

$check_free_shipping = tep_db_fetch_array($check_free_shipping_query);

$check_free_shipping_array[] = $check_free_shipping['products_free_shipping'];

}

if (in_array("1", $check_free_shipping_array) && !in_array("0", $check_free_shipping_array)) {

$free_shipping = true;

include_once(DIR_WS_LANGUAGES . $language . '/checkout_shipping.php');

}

}

// process the selected shipping method

if ( isset($HTTP_POST_VARS['action']) && ($HTTP_POST_VARS['action'] == 'process') ) {

if (!tep_session_is_registered('comments')) tep_session_register('comments');

if (tep_not_null($HTTP_POST_VARS['comments'])) {

$comments = tep_db_prepare_input($HTTP_POST_VARS['comments']);

}

 

if (!tep_session_is_registered('shipping')) tep_session_register('shipping');

 

if ( (tep_count_shipping_modules() > 0) || ($free_shipping == true) ) {

if ( (isset($HTTP_POST_VARS['shipping'])) && (strpos($HTTP_POST_VARS['shipping'], '_')) ) {

$shipping = $HTTP_POST_VARS['shipping'];

 

list($module, $method) = explode('_', $shipping);

if ( is_object($$module) || ($shipping == 'free_free') ) {

if ($shipping == 'free_free') {

$quote[0]['methods'][0]['title'] = FREE_SHIPPING_TITLE;

$quote[0]['methods'][0]['cost'] = '0';

} else {

$quote = $shipping_modules->quote($method, $module);

}

if (isset($quote['error'])) {

tep_session_unregister('shipping');

} else {

if ( (isset($quote[0]['methods'][0]['title'])) && (isset($quote[0]['methods'][0]['cost'])) ) {

$shipping = array('id' => $shipping,

'title' => (($free_shipping == true) ? $quote[0]['methods'][0]['title'] : $quote[0]['module'] . ' (' . $quote[0]['methods'][0]['title'] . ')'),

'cost' => $quote[0]['methods'][0]['cost']);

 

tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL'));

}

}

} else {

tep_session_unregister('shipping');

}

}

} else {

$shipping = false;

 

tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL'));

}

}

 

// get all available shipping quotes

$quotes = $shipping_modules->quote();

 

// if no shipping method has been selected, automatically select the cheapest method.

// if the modules status was changed when none were available, to save on implementing

// a javascript force-selection method, also automatically select the cheapest shipping

// method if more than one module is now enabled

if ( !tep_session_is_registered('shipping') || ( tep_session_is_registered('shipping') && ($shipping == false) && (tep_count_shipping_modules() > 1) ) ) $shipping = $shipping_modules->cheapest();

 

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CHECKOUT_SHIPPING);

 

$breadcrumb->add(NAVBAR_TITLE_1, tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL'));

$breadcrumb->add(NAVBAR_TITLE_2, tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL'));

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

<title><?php echo TITLE; ?></title>

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<link rel="stylesheet" type="text/css" href="stylesheet.css">

<script language="javascript"><!--

var selected;

 

function selectRowEffect(object, buttonSelect) {

if (!selected) {

if (document.getElementById) {

selected = document.getElementById('defaultSelected');

} else {

selected = document.all['defaultSelected'];

}

}

 

if (selected) selected.className = 'moduleRow';

object.className = 'moduleRowSelected';

selected = object;

 

// one button is not an array

if (document.checkout_address.shipping[0]) {

document.checkout_address.shipping[buttonSelect].checked=true;

} else {

document.checkout_address.shipping.checked=true;

}

}

 

function rowOverEffect(object) {

if (object.className == 'moduleRow') object.className = 'moduleRowOver';

}

 

function rowOutEffect(object) {

if (object.className == 'moduleRowOver') object.className = 'moduleRow';

}

//--></script>

<script LANGUAGE="JavaScript1.2" SRC="includes/menu_animation.js"></SCRIPT>

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

<!-- coolMenu //-->

<?php require(DIR_WS_INCLUDES . 'coolmenu.php'); ?>

<!-- coolMenu_eof //-->

<!-- header //-->

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<!-- header_eof //-->

 

<!-- body //-->

<table align="center" bgcolor="#FFFFFF" border="0" width="760px" cellspacing="3" cellpadding="3">

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- left_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

<!-- left_navigation_eof //-->

</table></td>

<!-- body_text //-->

<td width="100%" valign="top"><?php echo tep_draw_form('checkout_address', tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL')) . tep_draw_hidden_field('action', 'process'); ?><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

<td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_delivery.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>

</tr>

</table></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<td class="main"><b><?php echo TABLE_HEADING_SHIPPING_ADDRESS; ?></b></td>

</tr>

</table></td>

</tr>

<tr>

<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

<tr class="infoBoxContents">

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

<td class="main" width="50%" valign="top"><?php echo TEXT_CHOOSE_SHIPPING_DESTINATION . '<br><br><a href="' . tep_href_link(FILENAME_CHECKOUT_SHIPPING_ADDRESS, '', 'SSL') . '">' . tep_image_button('button_change_address.gif', IMAGE_BUTTON_CHANGE_ADDRESS) . '</a>'; ?></td>

<td align="right" width="50%" valign="top"><table border="0" cellspacing="0" cellpadding="2">

<tr>

<td class="main" align="center" valign="top"><?php echo '<b>' . TITLE_SHIPPING_ADDRESS . '</b><br>' . tep_image(DIR_WS_IMAGES . 'arrow_south_east.gif'); ?></td>

<td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

<td class="main" valign="top"><?php echo tep_address_label($customer_id, $sendto, true, ' ', '<br>'); ?></td>

<td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<?php

if (tep_count_shipping_modules() > 0) {

?>

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<td class="main"><b><?php echo TABLE_HEADING_SHIPPING_METHOD; ?></b></td>

</tr>

</table></td>

</tr>

<tr>

<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

<tr class="infoBoxContents">

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

<?php

if (sizeof($quotes) > 1 && sizeof($quotes[0]) > 1) {

?>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

<td class="main" width="50%" valign="top"><?php echo TEXT_CHOOSE_SHIPPING_METHOD; ?></td>

<td class="main" width="50%" valign="top" align="right"><?php echo '<b>' . TITLE_PLEASE_SELECT . '</b><br>' . tep_image(DIR_WS_IMAGES . 'arrow_east_south.gif'); ?></td>

<td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

</tr>

<?php

} elseif ($free_shipping == false) {

?>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

<td class="main" width="100%" colspan="2"><?php echo TEXT_ENTER_SHIPPING_INFORMATION; ?></td>

<td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

</tr>

<?php

}

 

if ($free_shipping == true) {

?>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

<td colspan="2" width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

<td class="main" colspan="3"><b><?php echo FREE_SHIPPING_TITLE; ?></b> <?php echo $quotes[$i]['icon']; ?></td>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

</tr>

<tr id="defaultSelected" class="moduleRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="selectRowEffect(this, 0)">

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

<td class="main" width="100%"><?php echo sprintf(FREE_SHIPPING_DESCRIPTION, $currencies->format(MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER)) . tep_draw_hidden_field('shipping', 'free_free'); ?></td>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

</tr>

</table></td>

<td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

</tr>

 

<?php

} else {

$radio_buttons = 0;

for ($i=0, $n=sizeof($quotes); $i<$n; $i++) {

if(($quotes[$i]['id']== 'indvship')&&(sizeof($quotes) > 1 && sizeof($quotes[0]) > 1)){ //hadir//phpmom.com

echo '<tr><td> </td><td width="100%" colSpan="2" class="main">You have '.$shipping_modules->get_indvcount().' product with individual shipping total of '.$shipping_modules->get_shiptotal().'. This total will be ADDED to the shipping method selected.</td><td> </td>

</tr>';}

else{ //hadir//phpmom.com

?>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

<td colspan="2"><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

<td class="main" colspan="3"><b><?php echo $quotes[$i]['module']; ?></b> <?php if (isset($quotes[$i]['icon']) && tep_not_null($quotes[$i]['icon'])) { echo $quotes[$i]['icon']; } ?></td>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

</tr>

<?php

if (isset($quotes[$i]['error'])) {

?>

<tr>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

<td class="main" colspan="3"><?php echo $quotes[$i]['error']; ?></td>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

</tr>

<?php

} else {

for ($j=0, $n2=sizeof($quotes[$i]['methods']); $j<$n2; $j++) {

// set the radio button to be checked if it is the method chosen

$checked = (($quotes[$i]['id'] . '_' . $quotes[$i]['methods'][$j]['id'] == $shipping['id']) ? true : false);

 

if ( ($checked == true) || ($n == 1 && $n2 == 1) ) {

echo ' <tr id="defaultSelected" class="moduleRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="selectRowEffect(this, ' . $radio_buttons . ')">' . "\n";

} else {

echo ' <tr class="moduleRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="selectRowEffect(this, ' . $radio_buttons . ')">' . "\n";

}

?>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

<td class="main" width="75%"><?php echo $quotes[$i]['methods'][$j]['title']; ?></td>

<?php

if ( ($n > 1) || ($n2 > 1) ) {

?>

<td class="main"><?php echo $currencies->format(tep_add_tax($quotes[$i]['methods'][$j]['cost'], (isset($quotes[$i]['tax']) ? $quotes[$i]['tax'] : 0))); ?></td>

<td class="main" align="right"><?php echo tep_draw_radio_field('shipping', $quotes[$i]['id'] . '_' . $quotes[$i]['methods'][$j]['id'], $checked); ?></td>

<?php

} else {

?>

<td class="main" align="right" colspan="2"><?php echo $currencies->format(tep_add_tax($quotes[$i]['methods'][$j]['cost'], $quotes[$i]['tax'])) . tep_draw_hidden_field('shipping', $quotes[$i]['id'] . '_' . $quotes[$i]['methods'][$j]['id']); ?></td>

<?php

}

?>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

</tr>

<?php

$radio_buttons++;

}

}

}

?>

</table></td>

<td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

</tr>

<?php

}

}

?>

</table></td>

</tr>

</table></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<?php

}

?>

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<td class="main"><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>

</tr>

</table></td>

</tr>

<tr>

<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

<tr class="infoBoxContents">

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<td><?php echo tep_draw_textarea_field('comments', 'soft', '60', '5'); ?></td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

<tr class="infoBoxContents">

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

<td class="main"><?php echo '<b>' . TITLE_CONTINUE_CHECKOUT_PROCEDURE . '</b><br>' . TEXT_CONTINUE_CHECKOUT_PROCEDURE; ?></td>

<td class="main" align="right"><?php echo tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE); ?></td>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td width="25%"><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td width="50%" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'checkout_bullet.gif'); ?></td>

<td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td>

</tr>

</table></td>

<td width="25%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td>

<td width="25%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td>

<td width="25%"><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td>

<td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '1', '5'); ?></td>

</tr>

</table></td>

</tr>

<tr>

<td align="center" width="25%" class="checkoutBarCurrent"><?php echo CHECKOUT_BAR_DELIVERY; ?></td>

<td align="center" width="25%" class="checkoutBarTo"><?php echo CHECKOUT_BAR_PAYMENT; ?></td>

<td align="center" width="25%" class="checkoutBarTo"><?php echo CHECKOUT_BAR_CONFIRMATION; ?></td>

<td align="center" width="25%" class="checkoutBarTo"><?php echo CHECKOUT_BAR_FINISHED; ?></td>

</tr>

</table></td>

</tr>

</table></form></td>

<!-- body_text_eof //-->

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- right_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

<!-- right_navigation_eof //-->

</table></td>

</tr>

</table>

<!-- body_eof //-->

 

<!-- footer //-->

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //-->

<br>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'

Edited by dfrb26dett
Link to comment
Share on other sites

I understand in admin the reasoning behind the null and not null for the zip, indiv 1 price , indiv 2 price, but how can I just echo the values into those fields from the db. From the admin point of view I would like to see if those fields are populated with individual shipping prices or is this broken on mine??? On another note an FYI if you put the database entries into the table products and do not create the new table products_shipping as the instrctions mention for older installs you will have a problem because of this piece of code

if (($HTTP_POST_VARS['products_ship_zip'] == '')&&($HTTP_POST_VARS['products_ship_methods_id'] == '')&&($HTTP_POST_VARS['products_ship_price'] == '')&&($HTTP_POST_VARS['products_ship_price_two'] == '')){
tep_db_query("DELETE FROM " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'");

Will delete the whole item from the db when taking out the indiv shipping entries

Link to comment
Share on other sites

Pheeeeeeew, that was a lot of work (and re-work!), but I got it to not show errors.

 

But there still seems to be a problem. When I go into an item in admin, I have these new choices:

 

 

TEXT_PRODUCTS_ZIPCODE null

Indv. Shipping Price: notnull

Each Additional Price: notnull

 

It seems somewhere I didn't do something right, so I don't know how to use my new-fangled settings.

 

I would really appreciate if someone would help.

 

-Jen :)

Link to comment
Share on other sites

Pheeeeeeew, that was a lot of work (and re-work!), but I got it to not show errors.

 

But there still seems to be a problem. When I go into an item in admin, I have these new choices:

TEXT_PRODUCTS_ZIPCODE  null

Indv. Shipping Price:  notnull

Each Additional Price:  notnull

 

It seems somewhere I didn't do something right, so I don't know how to use my new-fangled settings.

 

I would really appreciate if someone would help.

 

-Jen :)

 

 

Ah, nevermind! It's fixed now thanks to a brainy boyfriend.

Link to comment
Share on other sites

I am getting the following error:

 

1146 - Table 'boorooag_p_os1.TABLE_PRODUCTS_SHIPPING' doesn't exist

 

select products_ship_methods_id, products_ship_zip from TABLE_PRODUCTS_SHIPPING where products_id = '0'

 

[TEP STOP]

 

 

I know the table exists - I added it per the instructions. I also modified the two database_tables files as instructed.

 

Any ides?

Link to comment
Share on other sites

Boorooaq,

 

Beth, is it? Looks like the TABLE_PRODUCTS_SHIPPING is not defined. Did you miss this step?

 

Add in includes/database_tables.php define('TABLE_PRODUCTS_SHIPPING', 'products_shipping'); //eof

 

 

Paul

Edited by Fourbit
Link to comment
Share on other sites

Boorooaq,

 

Beth, is it? Looks like the TABLE_PRODUCTS_SHIPPING is not defined. Did you miss this step?

 

Add in includes/database_tables.php define('TABLE_PRODUCTS_SHIPPING', 'products_shipping'); //eof

Paul

 

 

these are the last few lines in the includes/database files

 

define('TABLE_ZONES', 'zones');

define('TABLE_PRODUCTS_SHIPPING','products_shipping');//eof

?>

 

This is correct, right? It is not working

Link to comment
Share on other sites

Yeah, but did you add it to the SQL database? Open your phpMyAdmin and verify that you have the TABLE 'products_shipping'

L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Link to comment
Share on other sites

  • 2 weeks later...

I've got this contrib installed, but am running into a problem.

 

I've entered indiv shipping costs for each product in my shop. What I'm after at the moment is a way to have a discount - preferably in percentages - automatically taken off the total shipping price when a customer buys 2 products or more. For example: 10% discount on shipping when buying 2 products or more. And not just when the customer buys 2x the same product, but also 2 or more different products. Simply a 10% or so discount over the total shipping costs when purchasing 2 or more items.

 

Is this possible and if so, how can I achieve this?

 

Thanks,

RojanUK

Link to comment
Share on other sites

Hi,

 

I think i can use this contrib but i have only a small question.

 

Is it possible that it selects the highest price in a group of products

with individual prices?

 

So we can use it for products from different suppliers and their shippingcosts.

 

 

Thx.

Edited by [MaDBuCe]

People aren't afraid of how bad you are,

People are afraid of how good you are.

Link to comment
Share on other sites

I have tried the prodrate contrib, to use the weight field for fix shipping price.

 

Now, does this works in diffrent currencies, ie, does the shippong price set in Euro (my default currency) calculate iitself in dollars when custommer choose to see prices in $?

 

 

Thanx.

 

Haru.

Link to comment
Share on other sites

I have installed this contribution at the V3.2 level with the added additional shipping field. Databas columns created fine and I think I edited as needed. Everything seems fine, however when I put in an amount in the Individual shipping price or the additional shipping price, then update and check the item again I find the shipping amounts were not saved and are still 0.0000. I guess I missed something, please be patient enough to point out my error. Thanks, Al

Link to comment
Share on other sites

I'm having a similar problem as boorooag, when going to edit a product i get the following message:

 

1146 - Table 'store.PRODUCTS_SHIPPING' doesn't exist

 

SELECT * FROM PRODUCTS_SHIPPING WHERE products_id=32

 

products_shipping is defined in database_tables.php and it is properly registered in the database.

 

I'm using a CreLoaded version of oscommerce.

 

Any help would be appreciated,

 

Kai

Edited by luckybike
Link to comment
Share on other sites

Can anyone help me with this shipping module? Or any of these contributions for that matter. I am just starting my os Commerce... i installed a new one yesterday and am starting to get everything together... I finally understand the layout and everything now i am just looking at these contributions...

 

I am just confused as to where they go. I see they come with instruction, but can anyone explain it in plain english for newbies exactly what you have to do to get this shipping one to work? So sorry i'm sure you get this a lot :blush:

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...