Jump to content

gaspower

Members
  • Content count

    453
  • Joined

  • Last visited

Everything posted by gaspower

  1. Hello, Update to above post. This is the output I get when I try to load one more item: The Plus123sct shows in new products for August, but does not show in categories list or anywhere else. I have to manually delete it with a database program? Thanks JR File uploaded. Temporary filename: /tmp/phpQSWXX8 User filename: EP2007Aug11-1212.txt Size: 757 | NOV07007 | Novarossi | Novarossi | | 07007.jpg | 40 | 100 | 0.3 | | 8/11/2007 | Warner | Engine Par | 07007.jpg | Vehicle | 07007.jpg | 2.1cc | plus123sct | Taxable Go | Active Updated | Plus123SCT | Novarossi | Novarossi | | plus123sct | 500 | 100 | 3 | | 8/11/2007 | Warner | Engines | plus123sct | Vehicle | plus123sct | 2.1cc | plus123sct | Taxable Go | Active Updated No products_model field in record. This line was not imported: | | | | | | | | | | | | | | | | | | |
  2. Hello, I have used the v2.76 on my sites and it works great, and I see now version 2.76e which has the category image import. Thanks this will save lots of time. The issue I have is that when I up load the file, products do not show up, but show in the database? I manually entered one item in OSC and did the download, and that file is correct, all items linked correctly. I change a price on that one file and up loaded and it works fine. But, as soon as I add one item to the text file with excel, it says imported fine, but item does not show up in OSC, but does in the database? I do have SPPC installed, but have it turned off in EP2.76e. I also have safe output off? I have it down to the basics. Thanks JR
  3. Hello, I have sued the v 2.76 on my sites and it works great, and I see now version 2.76e which has the category image import. Thanks this will save lots of time. The issue I have is that when I up load the file, products do not show up, but show in the database? I manually entered one item in OSC and did the download, and that file is correct, all items linked correctly. I change a price on that one file and up loaded and it works fine. But, as soon as I add one item to the text file with excel, it says imported fine, but item does not show up in OSC, but does in the database? I do have SPPC installed, but have it turned off in EP2.76e. I also have safe output off? I have it down to the basics. Thanks JR
  4. Thank you, I will check it in Firefox and see if there is an error. Thank you
  5. Hello JanZ, First thank you for the effort and reply, very much appreciated. I tried the above to the admin/categories, but when the button is pressed nothing happens? Thanks JR
  6. Hello JanZ, Thank you for the response. I do understand the fields in the admin/categories, but I guess my question is, can there be a way of just having a percentage discount, so if product is added, the pricing on the site will always be based on the discount off the retail? Again, thank you and a fantastic contribution. Thanks JR
  7. Hello, Thanks for this forum. I have been using quick price updates for a while and it works great. I just adjusted my directory structure in OSC to have separate image directories for each manufacture. Now when I use Quick Price, the image is broken, since normally all images are catalog/images. I can I get Quick Price to see the images in their correct directory structure? Thanks JR
  8. Hello, I have been using SPPC 4.16 on multiple shops and it works great. And on this site using MS2.2 RC1 all is working fine except for file new_products.php. The page loads fine, but the pricing on the page shows full retail on all groups. Pricing for groups throughout the rest of the site is working fine. The template is a little different and is not allowing for the pricing to be correct. If anyone could help me with the code, it would be much appreciated. Thanks JR <?php /* $Id: new_products.php,v 1.0 2004/01/09 22:49:58 hpdl Exp $ template-faq.com, Inc http://www.template-faq.com Copyright © 2004 template-faq.com, Inc Released under the GNU General Public License */ ?> <!-- new_products //--> <?php $info_box_contents = array(); $info_box_contents[] = array('text' => sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B'))); new contentBoxHeading($info_box_contents, "Center"); if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) { $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS); } else { $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS); } $row = 0; $col = 0; $info_box_contents = array(); while ($new_products = tep_db_fetch_array($new_products_query)) { $product_query = tep_db_query("select products_name, products_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$new_products['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); $product = tep_db_fetch_array($product_query); if ($new_price = tep_get_products_special_price($new_products['products_id'])) { $products_price = '<s>' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($new_products['products_tax_class_id'])) . '</span>'; } else { $products_price = '<b>' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])) . '</b>'; } #PR Build product information box $product_info_str = '<table border="0" cellspacing="0" cellpadding="0" class="hl_product_box" onmouseover="this.className=\'hl_product_box_over\'" onmouseout="this.className=\'hl_product_box\'"><tr><td valign="top">'; $product_info_str .= '<table border="0" cellspacing="0" cellpadding="0" class="productBoxHeading_tb"><tr>'; $product_info_str .= '<td class="productBoxHeadingLcorner"> </td>'; $product_info_str .= '<td class="productBoxHeading">'.'</td>'; $product_info_str .= '<td class="productBoxHeadingRcorner"> </td>'; $product_info_str .= '</tr></table>'; $product_info_str .= '<table border="0" cellspacing="0" cellpadding="0" class="productBoxOuter"><tr>'; $product_info_str .= '<td class="productBoxLSide"></td>'; $product_info_str .= '<td height=100% valign="top" class="productBoxMSide">'; $product_info_str .= '<table border="0" width="100%" cellspacing="0" cellpadding="0" class="productBox" valign="top"><tr><td align="left">'; $product_info_str .= '<table width="100%" cellspacing="0" cellpadding="3"><tr><td align="left">'; $product_info_str .= '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>'; $product_info_str .= '</td><td align="left">'; $product_info_str .= '<div class="productBoxName"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $product['products_name'] . '</a></div><br>'; $product_info_str .= ' <table width="100%" cellspacing="0" cellpadding="0">'; $product_info_str .= ' <tr><td align="right" width="11">'; $product_info_str .=' <img src="'. DIR_WS_TEMPLATE_IMAGES .'az_price_tag_l.gif" border="0" class="noborder" />'; $product_info_str .= ' </td><td align="center" class="productBoxPrice">'; $product_info_str .= $products_price ; $product_info_str .= ' </td><td align="left" width="10">'; $product_info_str .=' <img src="'. DIR_WS_TEMPLATE_IMAGES .'az_price_tag_r.gif" border="0" class="noborder" />'; $product_info_str .= ' </td></tr>'; $product_info_str .= ' </table>'; $product_info_str .= '</td></tr></table>'; $product_info_str .= '</td>'; $product_info_str .= '</tr></table>'; $product_info_str .= '</td><td class="productBoxRSide"> </td></tr></table>'; $product_info_str .= '<table border="0" cellspacing="0" cellpadding="0" class="productBoxBottom_tb"><tr>'; $product_info_str .= '<td align="left"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . '<img src="'. DIR_WS_TEMPLATE_IMAGES .'az_more_info.gif" border="0" class="noborder" />' . '</a></td>'; $product_info_str .= '<td align="right"><a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $new_products['products_id']) . '">' . '<img src="'. DIR_WS_TEMPLATE_IMAGES .'az_buy_now.gif" border="0" class="noborder" />' . '</a></td>'; $product_info_str .= '</tr></table>'; $product_info_str .= '</td></tr></table>'; $product_info_str .= '<table border="0" width="100%" cellspacing="0" cellpadding="0" class="productBottomLine" valign="top">'; $product_info_str .= '<tr><td>'; $product_info_str .= '</td></tr></table>'; $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="50%" valign="top"', 'text' => $product_info_str); $col ++; if ($col > 2) { $col = 0; $row ++; } else { $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="product_middle_line"', 'text' => '<img src="'. DIR_WS_TEMPLATE_IMAGES .'az_prod_vrt_line.gif" alt="" />'); $col ++; } } new newProductsBox($info_box_contents, true, "Center"); ?> <!-- new_products_eof //-->
  9. gaspower

    USPS Method 2.76 Not Saving

    Hello, I found the answer here: http://forums.oscommerce.com/index.php?sho...mp;#entry923577 JR
  10. Hello, I am installing USPS method version 2.76 with pricing updates. But when I installed the contribution all is fine, but for some reason it will not save the configuration in the modules? It keeps setting back to the module install of usps default before any account information is installed? I did the sql ALTER TABLE `configuration` CHANGE `set_function` `set_function` TEXT. Thanks JR
  11. Hello, I have install version 2.56a and it works great. Just one question, when it outputs to the screen, it just lists six at one time. How do you get it to list more per page? Thanks JR
  12. Hello, I see the error, missing "," on cost and msrp. Sorry about that, JR
  13. File uploaded. Temporary filename: /tmp/phpEWZ1Ye User filename: Test Upload Small.txt Size: 1474 | AIRM11 | rrp.gif | M11 | M11 Radio | | 150 | 5 | | 7/27/2007 | 10 | Airtronics | Radios | Systems | | Taxable Go | Active | 10 | 100 Updated | DYN2000 | dyn2000.jp | Turbo Fuel | Turbo Fuel | | 8.49 | 0.3 | | 7/26/2007 | 10 | Dynamite | Accessorie | Fuel Bottl | | Taxable Go | Active | 4.99 | 9.95 !New Product! 1136 - Column count doesn't match value count at row 1 INSERT INTO products ( products_model, products_image, products_price, products_cost, products_msrp, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( 'dyn2000.jpg', 'DYN2000', '8.49', '1', CURRENT_TIMESTAMP, "7/26/2007 14:26", NULL, '1', '0.3', '10', '4.99' '9.95' '3') Hello, I did a download from the sit with EP to get the layout and had one item on the site (AIRM11). As soon as I add any other items, approx ten items to test, I get the above error? I am dowlnoading in Tab format, and saving as Tab format. I changed the value in products_model to (20) to allow for larger names. Thank you JR
  14. Hello, I have install EP2.76 and works fantastic, thank you. But now I am trying to have it add a field (products_cost), and it is not working. In the instructions is stats to look at ep_create_file_layout, but this file is not contained in the download. Can someone please advise me on how to add the field to Easy Populate. Thanks JR
  15. gaspower

    Help With Custom Fields

    Hello, Thank you for the reply. I did use compare and merge just to move the cost items over and thats were it breaks? Thanks JR
  16. gaspower

    Help With Custom Fields

    Hello, Sorry to bother you, but I tried it and it breaks the site. It actually has more than what I need. I already have a cost field and just need to add it to EP. Thanks JR
  17. gaspower

    Help With Custom Fields

    Thank you JR
  18. Hello, I am to use the following query statement, when using the USPS Methods, ALTER TABLE `configuration` CHANGE `set_function` `set_function` VARCHAR( 555 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; But I get this error in the results screen, Error Code : 1074 Too big column length for column 'set_function' (max = 255). Use BLOB instead (0 ms taken) How can I get around this error? Version of sql is 3.23. Thanks JR
  19. Hello, I would like to install this contribution, but I have one question before I install. I have added extra database fields such as (bins). This field is a number so when a customer orders products, and bin number is added to each product line so I know where to pull product. When I install this contribution, will it all read and pull this field? Thanks JR
  20. gaspower

    1171 Error

    Hello, Not sure what happened, but now I get this error, 1171 - All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead CREATE TABLE IF NOT EXISTS discount_coupons_to_orders ( coupons_id VARCHAR(32) NOT NULL DEFAULT '', orders_id INT(11) DEFAULT '0', PRIMARY KEY (coupons_id,orders_id) ) [TEP STOP] Thanks JR
  21. Hello, I finally was able to get the contribution installed and all looks and works great but one item. When the system gets to checkout_confirmation.php I get a blank screen. I have pasted that file below, in hope someone can see what was left out. Thanks JR <?php /* $Id: checkout_confirmation.php,v 1.139 2003/06/11 17:34:53 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); // if the customer is not logged on, redirect them to the login page if (!tep_session_is_registered('customer_id')) { $navigation->set_snapshot(array('mode' => 'SSL', 'page' => FILENAME_CHECKOUT_PAYMENT)); tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL')); } // if there is nothing in the customers cart, redirect them to the shopping cart page if ($cart->count_contents() < 1) { tep_redirect(tep_href_link(FILENAME_SHOPPING_CART)); } // avoid hack attempts during the checkout procedure by checking the internal cartID if (isset($cart->cartID) && tep_session_is_registered('cartID')) { if ($cart->cartID != $cartID) { tep_redirect(tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL')); } } // if no shipping method has been selected, redirect the customer to the shipping method selection page if (!tep_session_is_registered('shipping')) { tep_redirect(tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL')); } if (!tep_session_is_registered('payment')) tep_session_register('payment'); if (isset($HTTP_POST_VARS['payment'])) $payment = $HTTP_POST_VARS['payment']; 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']); } //kgt - discount coupons if (!tep_session_is_registered('coupon')) tep_session_register('coupon'); //this needs to be set before the order object is created, but we must process it after $coupon = tep_db_prepare_input($HTTP_POST_VARS['coupon']); //end kgt - discount coupons // load the selected payment module require(DIR_WS_CLASSES . 'payment.php'); $payment_modules = new payment($payment); require(DIR_WS_CLASSES . 'order.php'); $order = new order; $payment_modules->update_status(); if ( ( is_array($payment_modules->modules) && (sizeof($payment_modules->modules) > 1) && !is_object($$payment) ) || (is_object($$payment) && ($$payment->enabled == false)) ) { tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode(ERROR_NO_PAYMENT_MODULE_SELECTED), 'SSL')); } if (is_array($payment_modules->modules)) { $payment_modules->pre_confirmation_check(); } //kgt - discount coupons if( tep_not_null( $coupon ) && is_object( $order->coupon ) ) { //if they have entered something in the coupon field $order->coupon->verify_code(); if( MODULE_ORDER_TOTAL_DISCOUNT_COUPON_DEBUG != 'true' ) { if( !$order->coupon->is_errors() ) { //if we have passed all tests (no error message), make sure we still meet free shipping requirements, if any if( $order->coupon->is_recalc_shipping() ) tep_redirect( tep_href_link( FILENAME_CHECKOUT_SHIPPING, 'error_message=' . urlencode( ENTRY_DISCOUNT_COUPON_SHIPPING_CALC_ERROR ), 'SSL' ) ); //redirect to the shipping page to reselect the shipping method } else { if( tep_session_is_registered('coupon') ) tep_session_unregister('coupon'); //remove the coupon from the session tep_redirect( tep_href_link( FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode( implode( ' ', $order->coupon->get_messages() ) ), 'SSL' ) ); //redirect to the payment page } } } else { //if the coupon field is empty, unregister the coupon from the session if( tep_session_is_registered('coupon') ) { //we had a coupon entered before, so we need to unregister it tep_session_unregister('coupon'); //now check to see if we need to recalculate shipping: require_once( DIR_WS_CLASSES.'discount_coupon.php' ); if( discount_coupon::is_recalc_shipping() ) tep_redirect( tep_href_link( FILENAME_CHECKOUT_SHIPPING, 'error_message=' . urlencode( ENTRY_DISCOUNT_COUPON_SHIPPING_CALC_ERROR ), 'SSL' ) ); //redirect to the shipping page to reselect the shipping method } } //end kgt - discount coupons // load the selected shipping module require(DIR_WS_CLASSES . 'shipping.php'); $shipping_modules = new shipping($shipping); require(DIR_WS_CLASSES . 'order_total.php'); $order_total_modules = new order_total; // Stock Check $any_out_of_stock = false; if (STOCK_CHECK == 'true') { for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { if (tep_check_stock($order->products[$i]['id'], $order->products[$i]['qty'])) { $any_out_of_stock = true; } } // Out of Stock if ( (STOCK_ALLOW_CHECKOUT != 'true') && ($any_out_of_stock == true) ) { tep_redirect(tep_href_link(FILENAME_SHOPPING_CART)); } } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CHECKOUT_CONFIRMATION); $breadcrumb->add(NAVBAR_TITLE_1, tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL')); $breadcrumb->add(NAVBAR_TITLE_2); ?> <!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"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="0" cellpadding="0" class="maincont_tb"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top" class="maincont_left_td"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="0" class="leftbar_tb"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top" class="maincont_mid_td"><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> </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"> <?php if ($sendto != false) { ?> <td width="30%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="main"><?php echo '<b>' . HEADING_DELIVERY_ADDRESS . '</b> <a href="' . tep_href_link(FILENAME_CHECKOUT_SHIPPING_ADDRESS, '', 'SSL') . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a>'; ?></td> </tr> <tr> <td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, ' ', '<br>'); ?></td> </tr> <?php if ($order->info['shipping_method']) { ?> <tr> <td class="main"><?php echo '<b>' . HEADING_SHIPPING_METHOD . '</b> <a href="' . tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL') . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a>'; ?></td> </tr> <tr> <td class="main"><?php echo $order->info['shipping_method']; ?></td> </tr> <?php } ?> </table></td> <?php } ?> <td width="<?php echo (($sendto != false) ? '70%' : '100%'); ?>" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <?php if (sizeof($order->info['tax_groups']) > 1) { ?> <tr> <td class="main" colspan="2"><?php echo '<b>' . HEADING_PRODUCTS . '</b> <a href="' . tep_href_link(FILENAME_SHOPPING_CART) . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a>'; ?></td> <td class="smallText" align="right"><b><?php echo HEADING_TAX; ?></b></td> <td class="smallText" align="right"><b><?php echo HEADING_TOTAL; ?></b></td> </tr> <?php } else { ?> <tr> <td class="main" colspan="3"><?php echo '<b>' . HEADING_PRODUCTS . '</b> <a href="' . tep_href_link(FILENAME_SHOPPING_CART) . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a>'; ?></td> </tr> <?php } for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { echo ' <tr>' . "\n" . ' <td class="main" align="right" valign="top" width="30">' . $order->products[$i]['qty'] . ' x</td>' . "\n" . ' <td class="main" valign="top">' . $order->products[$i]['name']; if (STOCK_CHECK == 'true') { echo tep_check_stock($order->products[$i]['id'], $order->products[$i]['qty']); } if ( (isset($order->products[$i]['attributes'])) && (sizeof($order->products[$i]['attributes']) > 0) ) { for ($j=0, $n2=sizeof($order->products[$i]['attributes']); $j<$n2; $j++) { echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'] . '</i></small></nobr>'; } } echo '</td>' . "\n"; if (sizeof($order->info['tax_groups']) > 1) echo ' <td class="main" valign="top" align="right">' . tep_display_tax_value($order->products[$i]['tax']) . '%</td>' . "\n"; echo ' <td class="main" align="right" valign="top">' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . '</td>' . "\n" . ' </tr>' . "\n"; } ?> </table></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main"><b><?php echo HEADING_BILLING_INFORMATION; ?></b></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 width="30%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="main"><?php echo '<b>' . HEADING_BILLING_ADDRESS . '</b> <a href="' . tep_href_link(FILENAME_CHECKOUT_PAYMENT_ADDRESS, '', 'SSL') . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a>'; ?></td> </tr> <tr> <td class="main"><?php echo tep_address_format($order->billing['format_id'], $order->billing, 1, ' ', '<br>'); ?></td> </tr> <tr> <td class="main"><?php echo '<b>' . HEADING_PAYMENT_METHOD . '</b> <a href="' . tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL') . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a>'; ?></td> </tr> <tr> <td class="main"><?php echo $order->info['payment_method']; ?></td> </tr> </table></td> <td width="70%" valign="top" align="right"><table border="0" cellspacing="0" cellpadding="2"> <?php if (MODULE_ORDER_TOTAL_INSTALLED) { $order_total_modules->process(); echo $order_total_modules->output(); } ?> </table></td> </tr> </table></td> </tr> <?php if (is_array($payment_modules->modules)) { if ($confirmation = $payment_modules->confirmation()) { ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main"><b><?php echo HEADING_PAYMENT_INFORMATION; ?></b></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" cellspacing="0" cellpadding="2"> <tr> <td class="main" colspan="4"><?php echo $confirmation['title']; ?></td> </tr> <?php for ($i=0, $n=sizeof($confirmation['fields']); $i<$n; $i++) { ?> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main"><?php echo $confirmation['fields'][$i]['title']; ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main"><?php echo $confirmation['fields'][$i]['field']; ?></td> </tr> <?php } ?> </table></td> </tr> </table></td> </tr> <?php } } ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php if (tep_not_null($order->info['comments'])) { ?> <tr> <td class="main"><?php echo '<b>' . HEADING_ORDER_COMMENTS . '</b> <a href="' . tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL') . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a>'; ?></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 class="main"><?php echo nl2br(tep_output_string_protected($order->info['comments'])) . tep_draw_hidden_field('comments', $order->info['comments']); ?></td> </tr> </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="0"> <tr> <td align="right" class="main"> <?php if (isset($$payment->form_action_url)) { $form_action_url = $$payment->form_action_url; } else { $form_action_url = tep_href_link(FILENAME_CHECKOUT_PROCESS, '', 'SSL'); } echo tep_draw_form('checkout_confirmation', $form_action_url, 'post'); if (is_array($payment_modules->modules)) { echo $payment_modules->process_button(); } echo tep_image_submit('button_confirm_order.gif', IMAGE_BUTTON_CONFIRM_ORDER) . '</form>' . "\n"; ?> </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_draw_separator('pixel_silver.gif', '1', '5'); ?></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%"><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><?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%"><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="checkoutBarFrom"><?php echo '<a href="' . tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL') . '" class="checkoutBarFrom">' . CHECKOUT_BAR_DELIVERY . '</a>'; ?></td> <td align="center" width="25%" class="checkoutBarFrom"><?php echo '<a href="' . tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL') . '" class="checkoutBarFrom">' . CHECKOUT_BAR_PAYMENT . '</a>'; ?></td> <td align="center" width="25%" class="checkoutBarCurrent"><?php echo CHECKOUT_BAR_CONFIRMATION; ?></td> <td align="center" width="25%" class="checkoutBarTo"><?php echo CHECKOUT_BAR_FINISHED; ?></td> </tr> </table></td> </tr> </table></td> <!-- body_text_eof //--> <td width="<?php echo BOX_WIDTH; ?>" valign="top" class="maincont_right_td"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="0" class="rightbar_tb"> <!-- 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'); ?>
  22. Hello, Thanks for the advice, but I just had a chance to go through the new install of discount coupons again, verified all statements and I still get the below error. I also still do not get the discount link in the module/order total? Error under catalog / Discount Coupons 1146 - Table 'rcbulkbearings.discount_coupons' doesn't exist select count(*) as total from discount_coupons cd --------- Error under Reports / Discount Coupons 1146 - Table 'rcbulkbearings.discount_coupons' doesn't exist select count(*) as total from discount_coupons AS dc left join discount_coupons_to_orders AS dcto ON dc.coupons_id = dcto.coupons_id Thanks JR
  23. Hello, I just installed v3.0 and it ask at the end of the installation to run Modules/Order Total Discount Coupons? I have nothing showing up in that box in admin showing Discount Coupons? Thanks JR
  24. Hello, I have installed USPS 28d, and used the files it supplied and copied them over. When I switch to admin/shipping there is no buttons to edit the shipping? Thanks JR
  25. gaspower

    Fancier Invoice & Packingslip v1.0

    Hello, I am trying to install Fancier Invoice, but having a little issue with getting the border images to show. I am sure it is because I do not have the path set correctly in configure.php. My complete path to catalog from root is: /var/www/domain.com/htdocs/catalog (catalog) /var/www/domain.com/htdocs/admin (admin) Fancier Invoice asks for absolute, can someone tell me what the correct path may be. // Folder Definitions define('DIR_FS_ADMIN', '/htdocs/admin/'); // absolute path required define('EMAIL_INVOICE_DIR', 'email_invoice/'); define('INVOICE_TEMPLATE_DIR', 'templates/'); // Email Invoice File Definitions define('FILENAME_EMAIL_INVOICE', 'email_invoice.php'); define('FILENAME_EMAIL_CACHE_FILE', 'temp_cache.php'); define('FILENAME_ORDERS_INVOICE', 'invoice.php'); ----------------- Below is what I get whn I click on the invoice button under order view. I did add a directory catalog/admin and uploaded all corresponding files? When I click on one of the broken images as a view image, I get; http://www.domain.com/images/borders/maingrey_02.gif But should be; http://www.domain.com/catalog/images/borders/maingrey_02.gif Some reason it is not putting "catalog"?? Thanks JR
×