New 
PopTheTop
-
Posts
879 -
Joined
-
Last visited
Posts posted by PopTheTop
-
-
hi
i just wanted to know if anyone can help out....
after installing the admin notes mod, is it possible that certain cations by the admin can be added to the customer notes automatically?
in other words both of the following can be done but the second is by far the easiest way:
i) admin sends 25% discount coupon via email to customer. the admin then goes to admin notes, customer details and manually types it down to keep track of what he has given and to whom.
ii) admin sends 25% discount voucher to customer and when the 'submit' button is pressed it not only send the discount voucher but also send the details of the email (whole or part, along with ccgv details including date of expiry for cert etc) to the customer notes or admin notes
this is very handy for when individual emails are sent out with customer specific information - IF it can be updated automatically when submit is pressed
as the database exists this could be done using simple instructions - please advise
thanks :-)
Yes, that is very possible but I do not have the time to do it right now.
-
ok, I got it working, but I have a slight bug where the MODULE_PAYMENT_ECHECK_TEXT_MEMO says on the check, where do I fix that little bug at?-- done alot of php editing tonight / today code is runinng together.
Thanks for the nice add on .
It is in admin\includes\languages\english\orders.php
make sure you uploaded it and that you uploaded it into your admin\includes\languages\english\orders.php
-
I have a MOD that send me e-mails whenever there is an error on my site or someone tries to hack into the site, like try to get into the Admin.
For months now, I have been getting this e-mail when Google visits my site and sometimes MSNBot for various product pages and so on...
------------------------------------------- Site: http://www.popthetop.com Error Code: 404 - File or Page Not Found Occurred: 08/28/2005 7:55:44 Requested URL: http://www.popthetop.com/catalog/product_info.php%3Fcurrency%3DUSD&products_id%3D324&fr=AM0D2pquQxgKeI9frlt5U5R8v6OCmDEu09vJmtrY-N41AAAAAAAAAAA User IP Address: 66.249.65.66 User Agent: Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) Referer: -------------------------------------------
As you can see, Google is trying to load pages that the links have converted = signs and question marks.
%3F is supposed to be ?
%3D is supposed to be =
If I turn
http://www.popthetop.com/catalog/product_info.php%3Fcurrency%3DUSD&products_id%3D324&fr=AM0D2pquQxgKeI9frlt5U5R8v6OCmDEu09vJmtrY-N41AAAAAAAAAAA
into this
http://www.popthetop.com/catalog/product_info.php?currency=USD&products_id=324&fr=AM0D2pquQxgKeI9frlt5U5R8v6OCmDEu09vJmtrY-N41AAAAAAAAAAA
The links work.
Is there any way to fix this so that the correct pages get loaded? Is there any way to convert %3F to ? and %3D to = when a page loads?
-
I installed this a while back yet forgot to mention the problem I was having - it's nothing major, but it kind of defeats the whole point of having the module if it isn't working!
Basically, whenever there is an order the old text version of the invoice still goes out to the customer, not the "fancier" version. My settings on the e-mail page are shown in the image below:
Hmm, looks like you have 2 thing contridicting one another.
Your E-mail Options should look like this...
What is the line that sets a template called fancy.php? You have 2 template settings there. This must be your problem.
-
I am having some big problems and wonder if this has been looked into or if anyone knows how to add this on...
I have products that have options the customer can add. For instance, I sell a 12 volt portable air conditioner for $39.95 with 4 options to choose from:
1) Igloo Family 25qt Cooler (+ $29.95)
2) AC / DC Converter (+ $24.95)
3) Portable Power Pack (+ $59.95)
4) PVC Air Flow Elbow (+ $3.95)
My problem is this, #1, 2 and 3 above add quit a bit of shipping for me to ship. #3 is really heavy and cost me the most. But at checkout, shipping is only added for the weight of the item itself so I am loosing a lot of money when my customers buy the extra options. Usually just break even and sometimes process that sale at a small loss.
How can I get extra shipping to be added to the options?
-
Ok, I removed the two snippets of code you recommended, but that brings me back to the first problem. The Print Invoice button opens up a page with no invoice information. And the breadcrumb trail at the top ends with the following: NAVBAR_TITLE_1 > NAVBAR_TITLE_2 > NAVBAR_TITLE_3 >
Something's still amiss...
Looks to me that you either failed to upload all the files, uploaded them in BINARY mode instead of ASCII mode or uploaded the files in the wrong folders.
Some files have the same name and go in both the catalog side and the admin side.
I suggest uploading your files again and make certain you are uploading them into the correct folders on the server.
Also, check your paths. My store is in the catalog sub folder of my domain. (http://www.popthetop.com/catalog). If your store is in any other sub folder than catalog, then you may have to update the paths in the contribution. Some code may be calling files in the /catalog folder, I forget.
-
I got froogle data feed to work on one of my stores but I am having problems with a different one.. and I didn't know how to search for the answer.
I have a store where the database name are like
peacem_categories instead of categories
peacem_products instead of products
etc.....
and I don't understand enoght of the calling the databate table to change it in the froogle.php
Thank you very much
noppie
peacem_categories = categories
Call it by calling categories
peacem_ is just a prefix.
-
Would it be in modules/email_invoice/email_invoice.php
and change
$ei_image_dir = HTTP_SERVER . DIR_WS_CATALOG . DIR_WS_IMAGES;
to something like
$ei_image_dir = HTTP_SERVER . DIR_WS_mysubfolder . DIR_WS_IMAGES;
and then add to configure php
define('DIR_WS_mysubfolder', '/home/YOUR_DOMAIN/public_html/mysubfolder/'); ?
Or am I totally lost here? Because I must say I'm not good at this...so help is all I've got!
Yes, you can do that.
-
For the Fancier Invoice & Packing slip V6.1 contribution I am having a little problem.
The packing slip looks and prints fine but the Invoice appears to be a little messed up. What I am getting is this:
=====================================================
INVOICE_TEXT_ORDER INVOICE_TEXT_NUMBER_SIGNINVOICE_TEXT_COLON 5 INVOICE_TEXT_DATE_OF_ORDERINVOICE_TEXT_COLON 08/21/2005 Payment Method: Check/Money Order
=====================================================
in the box that contains the order number, date and payment method info.
I have not edited or touched the invoice.php in any way, just did an up load from the contribution folder on my computer.
I have scaned the invoice.php but cant seem to find any problem and my eyes are getting tired...any help would be appreciated.
thanks
jer37
Did you install the language files? And did you install ALL of them in the CORRECT folders? You have them in both catalog/admin/includes/languages AND catalog/includes/languages.
-
Hello...Sorry to bother...I've worked a lot to install this contrib...I've messed some things, but finally got them together...It workes! Excpet for one thing. I'm sure it's something that I missed. I'm very tired and I can't think right now...maybe in the morning I'll se the problem better. But in case I'm totally stupid :D...could you help?
In the email, why does it look like
this???
Thanks a lot in advance...
Check your paths. Right-click on the missing images and look at the path they are calling through properties. If your store is not in the catalog sub folder, then this is probably your problem.
-
It looks like when you copied PopOnTop's code there was a mod you didn't have installed, namely the Back Orders mod. I don't know if it has anything to do with this mod (I am about to install it) but you should probably back up your file and remove the following:
<!-- backorder addition --> <?php $orders_history_backorder_query = tep_db_query("select backorders from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . (int)$HTTP_GET_VARS['order_id'] . "'"); $orders_history_backorder = tep_db_fetch_array($orders_history_backorder_query); if (tep_not_null($orders_history_backorder['backorders'])) { ?> ? ? ? ? ? ? ? <tr> ? ? ? ? ? ? ? ? ? ?<td colspan="3" align="left" valign="top" class="order_infobox_heading"><b>BACKORDER INSTRUCTIONS:</b></td> ? ? ? ? ? ? ? </tr> ? ? ? ? ? ? ? <tr> ? ? ? ? ? ? ? ? ? ?<td valign="top" class="product_infobox_data" width="114"><br> <strong><?php echo tep_date_short($order->info['date_purchased']); ?></strong></td> ? ? ? ? ? ? ? ? ? ?<td colspan="2" valign="top" class="product_infobox_data"><br><?php echo tep_db_output($orders_history_backorder['backorders']); ?></td> ? ? ? ? ? ? ? </tr> ? ? ? ? ? ? ? <tr> ? ? ? ? ? ? ? ? ? ?<td colspan="3"><?php echo tep_draw_separator('pixel_trans.gif', '100', '20'); ?></td> ? ? ? ? ? ? ? </tr> <?php } ?> <!-- end backorder addition -->And Find and remove:
, osh.backorders
Hopefully that helps.
Yep, that will do it for you.
-
Ok, I am having a small issue and can't seem to hunt it down.? I changed the /languages/english/invoice.php and packingslip.php with our JPG logo.? But when we go to the admin side and click on the packing slip and invoice, the logo does not show.? the path is correct /admin/images/logo.jpg
i used to have our logo and renamed it oscommerce.gif and it worked.? so do we need to make sure the logo is just named oscommerce.gif at all times?
Try using the path catalog/admin/images/logo.jpg or images/logo.jpg
Chances are that images/logo.jpg is the one you need to use.
Take a look at the border paths and use the same path that they use.
This is my setting and my store is located at www.xxx.com/catalog/admin/...
//Change this to match your logo image and foler it is in define('INVOICE_IMAGE', 'images/pop-the-top_logo1.gif'); -
Good to hear.
Still no ideas on what's wrong with my Print Invoice function, huh?
Jason
No, not really. It should load the invoice. Try re-uploading the template files and the print_invoice file. If you want, I can send you a direct copy of mine for you to use. In fact, here it is anyway... try it out.
print_my_invoice.php
<?php /* $Id: print_my_invoice.php,v 6.0 2005/06/01 23:03:52 PopTheTop Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); if (!tep_session_is_registered('customer_id')) { $navigation->set_snapshot(); tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL')); } if (!isset($HTTP_GET_VARS['order_id']) || (isset($HTTP_GET_VARS['order_id']) && !is_numeric($HTTP_GET_VARS['order_id']))) { tep_redirect(tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL')); } $orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where orders_id = '" . tep_db_input($oID) . "'"); $customer_info_query = tep_db_query("select customers_id from " . TABLE_ORDERS . " where orders_id = '". (int)$HTTP_GET_VARS['order_id'] . "'"); $customer_info = tep_db_fetch_array($customer_info_query); if ($customer_info['customers_id'] != $customer_id) { tep_redirect(tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL')); } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ORDERS_PRINTABLE_INFO); $breadcrumb->add(NAVBAR_TITLE_1, tep_href_link(FILENAME_ACCOUNT, '', 'SSL')); $breadcrumb->add(NAVBAR_TITLE_2, tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL')); $breadcrumb->add(sprintf(NAVBAR_TITLE_3, $HTTP_GET_VARS['order_id']), tep_href_link(FILENAME_ORDERS_PRINTABLE_INFO, 'order_id=' . $HTTP_GET_VARS['order_id'], 'SSL')); require(DIR_WS_CLASSES . 'order.php'); $order = new order($HTTP_GET_VARS['order_id']); $date = date('M d, Y'); ?> <!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 STORE_NAME; ?> <?php echo INVOICE_TEXT_INVOICE; ?> <?php echo INVOICE_TEXT_NUMBER_SIGN; ?><?php echo date("y"); ?><?php echo INVOICE_TEXT_DASH; ?><?php echo $order_id;; ?></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" onload="window.print();return false"> <!-- body_text //--> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td align="left"><?php echo '<input type="image" src="' . INVOICE_IMAGE . '" width="' . INVOICE_IMAGE_WIDTH . '" height="' . INVOICE_IMAGE_HEIGHT . '" " alt="' . INVOICE_IMAGE_ALT_TEXT . '">'; ?></td> <TD ALIGN="right" VALIGN="top"><FONT COLOR="#006699" SIZE="2" FACE="Verdana"><strong><?php echo INVOICE_TEXT_INVOICE; ?> <?php echo INVOICE_TEXT_NUMBER_SIGN; ?> <?php echo date("y"); ?><?php echo INVOICE_TEXT_DASH; ?><?php echo $order_id; ?><BR><?php echo $date; ?></strong></font></TD> </tr> <tr> <td colspan="2"> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <TD COLSPAN="2" ALIGN="right" class="smallAddressBlue_INVOICE"><FONT FACE="Verdana" SIZE="1" COLOR="#006699"><strong><?php echo nl2br(STORE_NAME_ADDRESS); ?></strong></font></TD> </tr> <tr> <TD> <table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr> <td colspan="4"> <table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr> <td width="10%"><hr size="2"></td> <td align="center" class="pageHeading_INVOICE"><em><b><?php echo INVOICE_TEXT_INVOICE; ?></b></em></td> <td width="100%"><hr size="2"></td> </tr> </table></td> </tr> <tr> <td colspan="4"><?php echo tep_draw_separator('pixel_trans.gif', '100', '5'); ?></td> </tr> <tr> <td width="3"> </td> <td valign="top"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="11"><img src="images/borders/maingrey_01.gif" width="11" height="16" alt=""></td> <td background="images/borders/maingrey_02.gif"><img src="images/borders/maingrey_02.gif" width="24" height="16" alt="" ></td> <td width="19"><img src="images/borders/maingrey_03.gif" width="19" height="16" alt=""></td> </tr> <tr> <td background="images/borders/maingrey_04.gif"><img src="images/borders/maingrey_04.gif" width="11" height="21" alt=""></td> <td align="center" bgcolor="#F2F2F2"> <table width="100%" border="0" cellspacing="0" cellpadding="0" class="main_INVOICE"> <tr> <td align="left" valign="top" class="order_infobox_heading_INVOICE"><b><?php echo ENTRY_SOLD_TO; ?></b></td> </tr> <tr> <td class="order_infobox_data_INVOICE"> <?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td> </tr> <tr> <td class="order_infobox_data_INVOICE"> <?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br> '); ?></td> </tr> <tr> <td class="order_infobox_data_INVOICE"> <?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="order_infobox_data_INVOICE"> <?php echo $order->customer['telephone']; ?></td> </tr> <tr> <td class="order_infobox_data_INVOICE"> <?php echo $order->customer['email_address']; ?></td> </tr> <tr> <td class="order_infobox_data_INVOICE"><?php echo tep_draw_separator('pixel_trans.gif', '1', '7'); ?></td> </tr> </table></td> <td background="images/borders/maingrey_06.gif"><img src="images/borders/maingrey_06.gif" width="19" height="21" alt=""></td> </tr> <tr> <td><img src="images/borders/maingrey_07.gif" width="11" height="18" alt=""></td> <td background="images/borders/maingrey_08.gif"><img src="images/borders/maingrey_08.gif" width="24" height="18" alt=""></td> <td><img src="images/borders/maingrey_09.gif" width="19" height="18" alt=""></td> </tr> </table></td> <td width="45"> </td> <td valign="top"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="11"><img src="images/borders/mainwhite_01.gif" width="11" height="16" alt=""></td> <td background="images/borders/mainwhite_02.gif"><img src="images/borders/mainwhite_02.gif" width="24" height="16" alt=""></td> <td width="19"><img src="images/borders/mainwhite_03.gif" width="19" height="16" alt=""></td> </tr> <tr> <td background="images/borders/mainwhite_04.gif"><img src="images/borders/mainwhite_04.gif" width="11" height="21" alt=""></td> <td align="center" bgcolor="#FFFFFF"> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main_INVOICE"> <tr> <td align="left" valign="top" class="order_infobox_heading_INVOICE"><b><?php echo ENTRY_SHIP_TO; ?></b></td> </tr> <tr> <td class="order_infobox_data_INVOICE"> <?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td> </tr> <tr> <td class="order_infobox_data_INVOICE"> <?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br> '); ?></td> </tr> <tr> <td class="order_infobox_data_INVOICE"> <?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="order_infobox_data_INVOICE"> </td> </tr> <tr> <td class="order_infobox_data_INVOICE"> </td> </tr> <tr> <td class="order_infobox_data_INVOICE"><?php echo tep_draw_separator('pixel_trans.gif', '1', '7'); ?></td> </tr> </table></td> <td background="images/borders/mainwhite_06.gif"><img src="images/borders/mainwhite_06.gif" width="19" height="21" alt=""></td> </tr> <tr> <td><img src="images/borders/mainwhite_07.gif" width="11" height="18" alt=""></td> <td background="images/borders/mainwhite_08.gif"><img src="images/borders/mainwhite_08.gif" width="24" height="18" alt=""></td> <td><img src="images/borders/mainwhite_09.gif" width="19" height="18" alt=""></td> </tr> </table></td> </tr> </table></TD> </tr> <tr> <TD COLSPAN="2"><?php echo tep_draw_separator('pixel_trans.gif', '100', '15'); ?></td> </tr> <tr> <TD COLSPAN="2"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="9"> </td> <td> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="11"><img src="images/borders/maingrey_01.gif" width="11" height="16" alt=""></td> <td background="images/borders/maingrey_02.gif"><img src="images/borders/maingrey_02.gif" width="24" height="16" alt="" ></td> <td width="19"><img src="images/borders/maingrey_03.gif" width="19" height="16" alt=""></td> </tr> <tr> <td background="images/borders/maingrey_04.gif"><img src="images/borders/maingrey_04.gif" width="11" height="21" alt=""></td> <td align="center" bgcolor="#F2F2F2"> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main_INVOICE"> <tr> <td width="33%" class="order_infobox_data_INVOICE"><strong> <?php echo INVOICE_TEXT_ORDER; ?> <?php echo INVOICE_TEXT_NUMBER_SIGN; ?><?php echo INVOICE_TEXT_COLON; ?></strong> <?php echo tep_db_input( $order_id); ?></td> <td width="33%" class="order_infobox_data_INVOICE"><strong> <?php echo INVOICE_TEXT_DATE_OF_ORDER; ?><?php echo INVOICE_TEXT_COLON; ?> </strong><?php echo tep_date_short($order->info['date_purchased']); ?></td> <?php if (tep_not_null($order->info['cc_number'])) { $this->cc_card_number_less_middle_digits = substr($order->info['cc_number'], 0, 4) . str_repeat('x', (strlen($order->info['cc_number']) - 8)) . substr($order->info['cc_number'], -4); ?> <td class="order_infobox_data_INVOICE"><span class="order_infobox_heading_INVOICE"> <b><?php echo ENTRY_PAYMENT_METHOD; ?></b></span> <?php echo $order->info['payment_method']; ?> (<?php echo $order->info['cc_type']; ?>)<br> <?php echo tep_draw_separator('pixel_trans.gif', '100%', '6'); ?><br> <span class="order_infobox_heading_INVOICE"> <b><?php echo ENTRY_PAYMENT_CC_NUMBER; ?></b></span> <?php echo $this->cc_card_number_less_middle_digits; ?></td> <?php } else { ?> <td class="order_infobox_data_INVOICE"><span class="order_infobox_heading_INVOICE"> <b><?php echo ENTRY_PAYMENT_METHOD; ?></b></span> <?php echo $order->info['payment_method']; ?></td> <?php } ?> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '7'); ?></td> </tr> </table></td> <td background="images/borders/maingrey_06.gif"><img src="images/borders/maingrey_06.gif" width="19" height="21" alt=""></td> </tr> <tr> <td><img src="images/borders/maingrey_07.gif" width="11" height="18" alt=""></td> <td background="images/borders/maingrey_08.gif"><img src="images/borders/maingrey_08.gif" width="24" height="18" alt=""></td> <td><img src="images/borders/maingrey_09.gif" width="19" height="18" alt=""></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <TD COLSPAN="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '20'); ?></td> </tr> <tr> <TD COLSPAN="2" align="center"> <table border="0" width="98%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow_INVOICE"> <td colspan="2" class="dataTableHeadingContent_INVOICE"> <font color="#000000"><?php echo TABLE_HEADING_PRODUCTS; ?></font></td> <td WIDTH="80" class="dataTableHeadingContent_INVOICE"><font color="#000000"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></font></td> <td WIDTH="80" align="right" class="dataTableHeadingContent_INVOICE"><font color="#000000"><?php echo TABLE_HEADING_UNIT_PRICE; ?></font></td> <TD WIDTH="80" ALIGN="right" CLASS="dataTableHeadingContent_INVOICE"><font color="#000000"><?php echo TABLE_HEADING_TOTAL; ?></font> </TD> </tr> <?php for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) { echo ' <tr class="dataTableRow_INVOICE">' . "\n" . ' <td class="dataTableContent_INVOICE" valign="top" align="right">' . $order->products[$i]['qty'] . ' x</td>' . "\n" . ' <td class="dataTableContent_INVOICE" valign="top">' . $order->products[$i]['name']; if (isset($order->products[$i]['attributes']) && (($k = sizeof($order->products[$i]['attributes'])) > 0)) { for ($j = 0; $j < $k; $j++) { echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value']; if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')'; echo '</i></small></nobr>'; } } echo ' </td>' . "\n" . ' <td WIDTH="80" class="dataTableContent_INVOICE" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n"; echo ' <td WIDTH="80" class="dataTableContent_INVOICE" align="right" valign="top">' . $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) . '</td>' . "\n" . ' <td WIDTH="80" class="dataTableContent_INVOICE" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ' </b></td>' . "\n"; echo ' </tr>' . "\n"; } ?> <tr> <td align="right" colspan="5"> <table border="0" cellspacing="0" cellpadding="2"> <?php for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) { echo ' <tr>' . "\n" . ' <td align="right" class="smallText_INVOIVE">' . $order->totals[$i]['title'] . '</td>' . "\n" . ' <td align="right" class="smallText_INVOIVE">' . $order->totals[$i]['text'] . '</td>' . "\n" . ' </tr>' . "\n"; } ?> </table></td> </tr> </table></td> </tr> <!-- ORDER COMMENTS CODE STARTS HERE //--> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '18'); ?></td> </tr> <tr> <TD> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="9"> </td> <td> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="11"><img src="images/borders/maingrey_01.gif" width="11" height="16" alt=""></td> <td background="images/borders/maingrey_02.gif"><img src="images/borders/maingrey_02.gif" width="24" height="16" alt="" ></td> <td width="19"><img src="images/borders/maingrey_03.gif" width="19" height="16" alt=""></td> </tr> <tr> <td background="images/borders/maingrey_04.gif"><img src="images/borders/maingrey_04.gif" width="11" height="21" alt=""></td> <td align="center" bgcolor="#F2F2F2"> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main"> <!-- backorder addition --> <?php $orders_history_backorder_query = tep_db_query("select backorders from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . (int)$HTTP_GET_VARS['order_id'] . "'"); $orders_history_backorder = tep_db_fetch_array($orders_history_backorder_query); if (tep_not_null($orders_history_backorder['backorders'])) { ?> <tr> <td colspan="3" align="left" valign="top" class="order_infobox_heading"><b>BACKORDER INSTRUCTIONS:</b></td> </tr> <tr> <td valign="top" class="product_infobox_data" width="114"><br> <strong><?php echo tep_date_short($order->info['date_purchased']); ?></strong></td> <td colspan="2" valign="top" class="product_infobox_data"><br><?php echo tep_db_output($orders_history_backorder['backorders']); ?></td> </tr> <tr> <td colspan="3"><?php echo tep_draw_separator('pixel_trans.gif', '100', '20'); ?></td> </tr> <?php } ?> <!-- end backorder addition --> <tr> <td colspan="3" align="left" valign="top" class="order_infobox_heading"><b>ORDER COMMENTS:</b></td> </tr> <?php $statuses_query = tep_db_query("select os.orders_status_name, osh.date_added, osh.comments, osh.backorders from " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh where osh.orders_id = '" . (int)$HTTP_GET_VARS['order_id'] . "' and osh.orders_status_id = os.orders_status_id and os.language_id = '" . (int)$languages_id . "' order by osh.date_added"); while ($statuses = tep_db_fetch_array($statuses_query)) { echo ' <tr>' . "\n"; echo ' <td valign="top" class="product_infobox_data" width="114"><br> <strong>' . tep_date_short($statuses['date_added']) . '</strong></td>' . "\n"; echo ' <td valign="top" class="product_infobox_data" width="85"><br>' . $statuses['orders_status_name'] . '</td>' . "\n"; echo ' <td valign="top" class="product_infobox_data"><br>' . (empty($statuses['comments']) ? ' ' : nl2br(tep_output_string_protected($statuses['comments']))) . '</td>' . "\n"; echo ' </tr>' . "\n"; } ?> <tr> <td colspan="3"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '7'); ?></td> </tr> </table> </td> <td background="images/borders/maingrey_06.gif"><img src="images/borders/maingrey_06.gif" width="19" height="21" alt=""></td> </tr> <tr> <td><img src="images/borders/maingrey_07.gif" width="11" height="18" alt=""></td> <td background="images/borders/maingrey_08.gif"><img src="images/borders/maingrey_08.gif" width="24" height="18" alt=""></td> <td><img src="images/borders/maingrey_09.gif" width="19" height="18" alt=""></td> </tr> </table> </td> </tr> </table> <!-- ORDER COMMENTS CODE ENDS HERE //--> <br> <CENTER><span class="smallText_INVOIVE"><FONT FACE="Verdana" COLOR="#006699"><strong><?php echo INVOICE_TEXT_THANK_YOU; ?><BR><?php echo STORE_NAME; ?><BR><?php echo STORE_URL_ADDRESS; ?></strong></font></span></CENTER> <!-- body_text_eof //--> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> -
The SQL error is no longer there...
-
Forgive me if this has already been answered...I've looked around and haven't found an answer myself. When a customer clicks on the Print Invoice button, a window pops up, but with no invoice information. The site shell looks fine, but there's no invoice content. Everything else seems to be working great.
I'm using Fancy Invoice V6.1
The URL that pops up when the mouse is over the Print Invoice Button is:
Run script "popupPrintReceipt('https://www.kimandjason.com/shop/print_my_invoice.php?order_id=9&osCsid=4ce407b7a6fee00e928f67dd0be6d42c')"
Also the breadcrumb trail at the top goes like this: Home >> Lemonade Stand >> NAVBAR_TITLE_1 >> NAVBAR_TITLE_2 >> NAVBAR_TITLE_3
Not sure what I missed but thanks in advance for your help!
Jason
Look at the path/code being called for that pop-up page to be printed.
It is opening:
https://www.kimandjason.com/shop/print_my_invoice.php/order_id/14?osCsid=4ce407b7a6fee00e928f67dd0be6d42c
Instead of
https://www.kimandjason.com/shop/print_my_invoice.php?order_id=14&osCsid=4ce407b7a6fee00e928f67dd0be6d42c
Look at the bold.
By the way, in the catagory looking at the product lists, when you click on your BUY button, you get the following SQL error. To bypass it, you have to view the product and THEN hit add to wagon (cart).
-
I am getting this same error Did you find a fix? I haven't been able to find one on the form
It is telling you that it can not find the file. Therefore, it is telling you to check your paths. Is your store in the sub folder called "catalog"? If not, then there is your problem.
Edit line number 255 and look at the path it is calling.
-
You the man!
-
PopTheTop,
Thanks for your help. The changes you mentioned worked like a charm. As for the parse error - I had created a second template trying to match my invoice (Professional Invoice & Packaging Slip Contribution). As you can tell, it didn't work :'( I made the change back to your original and all works good.
Now I just need to add the comments - shouldn't be too hard! :D
I appreciate your help!
Brad
If you download and use the templates found in http://www.oscommerce.com/community/contributions,2861 then you should be OK. I have the comments in them already and I think there are 4 templates with it that you can use. They should still work for you but if not, you can compare the templates with your templates and see how I added the comments and such.
-
Hey I just made a test order and your template file is screwed up. It states this when you try to open it...
Parse error: parse error, unexpected '<', expecting ',' or ';' in /home/bwdand14/public_html/catalog/includes/modules/email_invoice/templates/invoice.php on line 28 -
PopTheTop,
My web address is as follows: www.bwdandassociates.com
Settings for DIR_WS_IMAGES:
/catalog/includes/configure.php --> define('DIR_WS_IMAGES', '/catalog/images/');
/catalog/admin/includes/configure.php --> define('DIR_WS_ADMIN', '/catalog/admin/'); and then define('DIR_WS_IMAGES', 'images/'); and then define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');
Let me know if you need anything else.
Brad
Make your /catalog/includes/configure.php -->
define('DIR_WS_IMAGES', 'images/');Make your /catalog/admin/includes/configure.php -->
define('DIR_WS_ADMIN', '/admin/'); -
What is your website address and also, what is the setting for: DIR_WS_IMAGES in your config files?
-
Hello,
I have installed the latest email mod but am having issues with my logo being visible in the email. When I utilized the stock invoice.php <---that was included in the mod, it was giving me the same issue - red X image. I have attempted to make full URL changes with no luck. Does someone know how to resolve this issue?
Also, any plans on getting "Professional Invoice & Packaging Slip" contribution to work? I like that layout the best but for the life of me, I cannot get the body to look similar.
Thanks in advance,
Brad
In your e-mails, are they in HTML format? And if so, have you right-clicked on the missing image and chose properties? That will display the URL address for the image and you can see if it is correct or not.
Go to http://www.oscommerce.com/community/contributions,2861 for my version of the Professional Invoice & Packaging Slip.
-
-
Yeah, i just got it working with Oscommerce today. Need to do some more testing to make sure its stable.
Its a lot less hassle than some of the other WYSIWYG editors, im also planning on writing some custom buttons for it and removing others.
That's great! I was looking at it too but I just do not have the time right now to mess with in. let us know what you think about it and please tell us what to do.
[Contribution] Admin Notes
in General Add-Ons Support
Posted
You have to call the $cInfo->customers_notes from the customers database table in addition to the tables in orders.