gaspower

August 11, 2007

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

No products_model field in record. This line was not imported: | | | | | | | | | | | | | | | | | | |

August 11, 2007

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

August 11, 2007

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

August 8, 2007

Thank you,

I will check it in Firefox and see if there is an error.

Thank you

August 7, 2007

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

August 6, 2007

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

August 5, 2007

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

August 4, 2007

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

Released under the GNU General Public License

*/

?>

<?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");

?>

August 2, 2007

Hello,

I found the answer here:

http://www.oscommerce.com/forums/index.php?sho...mp;#entry923577

JR

August 2, 2007

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

August 2, 2007

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

July 27, 2007

Hello,

I see the error, missing "," on cost and msrp.

Sorry about that,

JR

July 27, 2007

File uploaded.

Temporary filename: /tmp/phpEWZ1Ye

User filename: Test Upload Small.txt

Size: 1474

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

July 25, 2007

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

July 25, 2007

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

July 25, 2007

Thank you

JR

July 25, 2007

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

July 18, 2007

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

July 4, 2007

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

June 14, 2007

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

June 14, 2007

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

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">

<head>

</head>

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

<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">

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

</table></td>

<tr>

<tr>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

<?php

if ($sendto != false) {

?>

<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>

<?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>

</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>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<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>

<?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>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<tr>

</tr>

<?php

for ($i=0, $n=sizeof($confirmation['fields']); $i<$n; $i++) {

?>

<tr>

</tr>

<?php

}

?>

</table></td>

</tr>

</table></td>

</tr>

<?php

}

?>

<tr>

</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>

</tr>

<tr>

<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>

</tr>

<?php

}

?>

<tr>

<tr>

<?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>

</tr>

<tr>

<tr>

<tr>

</tr>

</table></td>

<tr>

</tr>

</table></td>

<tr>

</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>

</tr>

</table></td>

</tr>

</table></td>

<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">

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

</table></td>

</tr>

</table>

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

<br>

</body>

</html>

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

June 11, 2007

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

May 13, 2007

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

December 28, 2006

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

December 24, 2006

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

gaspower

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by gaspower

Easy Populate & Products Attributes

Easy Populate & Products Attributes

Strange Import Problem

Discounts Not Showing On New Added Product

Discounts Not Showing On New Added Product

Discounts Not Showing On New Added Product

Quick Price Update Image Directory

Help With new_products Prices Not Correct

USPS Method 2.76 Not Saving

USPS Method 2.76 Not Saving

Margin Report More Listings

Help With 1136 - Column count doesn't match error

Help With 1136 - Column count doesn't match error

Help With Custom Fields

Help With Custom Fields

Help With Custom Fields

Help With Custom Fields

USPS 2.76 Error on Database

Quick Questions Before I Install

1171 Error

Checkout_confirmation Page Not Working

No Discount Coupons Module In Modules/Order Total

No Discount Coupons Module In Modules/Order Total

Help With USPS 28D Contribution

Fancier Invoice & Packingslip v1.0

Browse

Activity