phalancs Posted March 17, 2005 Share Posted March 17, 2005 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 Quote ---Freakstyler in the Hood! Link to comment Share on other sites More sharing options...
phalancs Posted March 17, 2005 Share Posted March 17, 2005 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. Quote ---Freakstyler in the Hood! Link to comment Share on other sites More sharing options...
cbeaudry Posted March 17, 2005 Share Posted March 17, 2005 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? Quote Link to comment Share on other sites More sharing options...
Extremest Posted March 17, 2005 Share Posted March 17, 2005 I had the same problem I just followed the directions in the above posts to fix it. Quote Link to comment Share on other sites More sharing options...
cbeaudry Posted March 17, 2005 Share Posted March 17, 2005 Got it....I had to go back to post 173 to get both the products_shipping and the subsequent shipping_methods tables to register. Those instructions should be updated..... :-" Quote Link to comment Share on other sites More sharing options...
crashwave Posted March 17, 2005 Share Posted March 17, 2005 Got it....I had to go back to post 173 to get both the products_shipping and the subsequent shipping_methods tables to register. Those instructions should be updated..... :-" <{POST_SNAPBACK}> DONE :thumbsup: Quote q_|_|| _|9~~J >-o>-o q_|_|| )| q_|| ) Link to comment Share on other sites More sharing options...
PopTheTop Posted March 18, 2005 Share Posted March 18, 2005 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? Quote 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 More sharing options...
giftmaster Posted March 18, 2005 Share Posted March 18, 2005 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 Quote Link to comment Share on other sites More sharing options...
oldworldcharms Posted March 20, 2005 Share Posted March 20, 2005 Anyone know how I put the shipping charge on the shopping_cart.php under the subtotal and then it shows the total? Thanks Elizabeth Quote Link to comment Share on other sites More sharing options...
oldworldcharms Posted March 22, 2005 Share Posted March 22, 2005 Is it possible in the admin to change it so the zip code is automatically entered. Enter it elsewhere one time and it is added. I would like to keep it for the update but would like to autofil. thanks Quote Link to comment Share on other sites More sharing options...
Guest Posted March 22, 2005 Share Posted March 22, 2005 (edited) 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 March 22, 2005 by dfrb26dett Quote Link to comment Share on other sites More sharing options...
dootch Posted March 22, 2005 Share Posted March 22, 2005 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted March 23, 2005 Share Posted March 23, 2005 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 :) Quote Link to comment Share on other sites More sharing options...
Guest Posted March 24, 2005 Share Posted March 24, 2005 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 :) <{POST_SNAPBACK}> Ah, nevermind! It's fixed now thanks to a brainy boyfriend. Quote Link to comment Share on other sites More sharing options...
Guest Posted March 25, 2005 Share Posted March 25, 2005 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? Quote Link to comment Share on other sites More sharing options...
Fourbit Posted March 25, 2005 Share Posted March 25, 2005 (edited) 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 March 25, 2005 by Fourbit Quote Link to comment Share on other sites More sharing options...
Guest Posted March 25, 2005 Share Posted March 25, 2005 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 <{POST_SNAPBACK}> 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 Quote Link to comment Share on other sites More sharing options...
PopTheTop Posted March 25, 2005 Share Posted March 25, 2005 Yeah, but did you add it to the SQL database? Open your phpMyAdmin and verify that you have the TABLE 'products_shipping' Quote 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 More sharing options...
RojanUK Posted April 8, 2005 Share Posted April 8, 2005 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, Quote RojanUK Link to comment Share on other sites More sharing options...
[MaDBuCe] Posted April 10, 2005 Share Posted April 10, 2005 (edited) 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 April 10, 2005 by [MaDBuCe] Quote People aren't afraid of how bad you are, People are afraid of how good you are. Link to comment Share on other sites More sharing options...
haru Posted April 11, 2005 Share Posted April 11, 2005 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. Quote Link to comment Share on other sites More sharing options...
heygidday Posted April 13, 2005 Share Posted April 13, 2005 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 Quote Link to comment Share on other sites More sharing options...
luckybike Posted April 14, 2005 Share Posted April 14, 2005 (edited) 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 April 14, 2005 by luckybike Quote Link to comment Share on other sites More sharing options...
kris10ized Posted April 16, 2005 Share Posted April 16, 2005 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: Quote Link to comment Share on other sites More sharing options...
luckybike Posted April 17, 2005 Share Posted April 17, 2005 My business is seasonal and I have become to busy to install this mod myself, I'm willing to pay for the install. Email me with quotes at ksarasch @ kc.rr.com I need this done ASAP and am willing to pay top dollar. Kai Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.