PopTheTop Posted October 29, 2004 Share Posted October 29, 2004 Has anyone found a way to send order invoices in HTML format? Meaning, they have tables and such that actually look like an invoice and not just order details like it is being sent now. I tried the ONLY 2 in the Contributions but they are in a different language and I can not understand them or install them. L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
OSCommerceSurgeon Posted November 2, 2004 Share Posted November 2, 2004 Has anyone found a way to send order invoices in HTML format? Meaning, they have tables and such that actually look like an invoice and not just order details like it is being sent now. I tried the ONLY 2 in the Contributions but they are in a different language and I can not understand them or install them. <{POST_SNAPBACK}> Hi Pop, In order to send invoices in HTML format the option must be set to true in the Admin section under email. I dont think you even have to install any contributions in order to get HTML formatted emails. The tricky part is that a person receiving the email must have HTML viewing turned on in their email client otherwise it will be a bunch of tags mixed into your message. I can build you a custom HTML invoice if you need something very specific but if you just need the stock invoice formatted nicer you should be able to do that through the admin section and see what happens when an invoice is sent using the HTML formatted that comes with OSCommerce. Hope that helps While I'm operating on OSCommerce, I don't have to worry about silly vitals or forgetting to turn off the ane..the.. no wait I remember aes....thetic, or right I've got it Anaesthetic Link to comment Share on other sites More sharing options...
PopTheTop Posted November 3, 2004 Author Share Posted November 3, 2004 I am looking for a custom HTML invoice to send. But to the best of my knowledge, when you have the HTML turned on in the Admin, it will send one e-mail. That e-mail will be displayed in HTML format and if the receiver can not see HTML e-mails, then it will display the stock non HTML e-mail. Try looking at the source code of an HTML e-mail from osC. It should look something like this... Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Dear Scott We wish to welcome you to BMBZ Tuningwerks. With your account, you can now take part in the various services we have to offer you. Some of these services include: Permanent Cart - Any products added to your online cart remain there until you remove them, or check them out. Address Book - We can now deliver your products to another address other than yours! This is perfect to send birthday gifts direct to the birthday-person themselves. Order History - View your history of purchases that you have made with us. Products Reviews - Share your opinions on products with our other customers. For help with any of our online services, please email the store-owner: [email protected] Sincerely, BMBZ Team Store Owner http://www.bmbz.com This email address was given to us by you or by one of our customers. If you did not signup for an account, or feel that you have received this email in error, please send an email to [email protected] --=_9fa2b2326cc777cce3000242d3716fba Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <html><head><meta http-equiv=3D"Content-Type" content=3D"text/html; charset= =3Diso-8859-1" /> <base href=3D"http://www.bmbz.com/" /><style type=3D"text= /css">.body {background-color:#ffffff; color:#000000; font-family:Verdana, = Arial, Helvetica, sans-serif;}a:link {color:#0066cc;}a:hover {background-co= lor:#eeeecc; color:#0066cc;}a:visited {color:#0066cc;}.holder {background-c= olor:#f9f9f9; border:1px solid #9a9a9a; font-size:9px; text-align:left; wid= th:550px;}.header {font-size:10px; padding:0px; width:550px;}.content {font= -size:10px; padding:5px; width:550px;}.content-line {padding:5px;}.coupon-b= lock {padding:5px; border:1px solid #cccccc;background-color: #FFFF99;}.cou= pon-code {font-weight:bold;}.gv-block {padding:5px; border:1px solid #ccccc= c;background-color: #99FF99;}.gv-code {font-weight:bold;}.footer {border-to= p:1px solid #9a9a9a; font-size:9px; margin-top:10px; text-align:center; wid= th:550px;}.extra-info {background-color:#cccc99; border:1px solid #9a9a9a; = font-size:10px; margin-top:10px; padding:5px; width:550px;}.extra-info-bol= d {font-weight:bold;}.disclaimer {background-color:#f9f9f9; border:1px soli= d #cccccc; font-size:10px; margin-top:10px; padding:5px; width:550px;}.dis= claimer1 {color:#666666; padding:5px;}.disclaimer1 a:link {color:#666666;}.= disclaimer1 a:visited {color:#666666;}.disclaimer2 {color:#666666; padding:= 5px}.copyright {border-bottom:0px solid #9a9a9a; padding:5px;}</style></hea= d><body class=3D"body"><div class=3D"holder"> <!-- Header Section --> <di= v class=3D"header"> <img src=3D"email/header.jpg" alt=3D"logo" /> </div> = <!-- Content Section --> <div class=3D"content"> <div class=3D"content= -line">Dear Scott<br /><br /></div> <div class=3D"content-line">We wish = to welcome you to <strong>BMBZ Tuningwerks</strong>.<br /><br /></div><!--T= he following only get populated if they're enabled! --><!-- end gv/coupon s= ection --> <div class=3D"content-line">With your account, you can now ta= ke part in the <strong>various services</strong> we have to offer you. Some= of these services include:<br /><br /><li><strong>Permanent Cart</strong> = - Any products added to your online cart remain there until you remove them= , or check them out.<br /><br /><li><strong>Address Book</strong> - We can = now deliver your products to another address other than yours! This is perf= ect to send birthday gifts direct to the birthday-person themselves.<br /><= br /><li><strong>Order History</strong> - View your history of purchases th= at you have made with us.<br /><br /><li><strong>Products Reviews</strong> = - Share your opinions on products with our other customers.<br /><br /></di= v> <div class=3D"content-line">For help with any of our online services,= please email the store-owner: <a href=3D"mailto:[email protected]">[email protected]= om </a><br /><br /><br />Sincerely,<br /><br /><br /><br />BMBZ Team<br /><= br />Store Owner<br /><br /><br /><br /><a href=3D"http://www.bmbz.com/">ht= tp://www.bmbz.com</a><br /><br /><br /><br /></div> </div> </div> <!-- F= ooter Section --> <div class=3D"footer"> <div class=3D"copyright">Copyr= ight © 2004 <a href=3D"http://www.zen-cart.com" target=3D"_blank">Zen = Cart</a>. Powered by <a href=3D"http://www.zen-cart.com" target=3D"_blank">= Zen Cart</a></div> </div><div class=3D"disclaimer"> <div class=3D"disclai= mer1">This email address was given to us by you or by one of our customers.= If you did not signup for an account, or feel that you have received this = email in error, please send an email to <a href=3D"mailto:[email protected]">ma= [email protected] </a> </div> <div class=3D"disclaimer2">This e-mail is sent in = accordance with the US CAN-SPAM Law in effect 01/01/2004. Removal requests = can be sent to this address and will be honored and respected.</div></div><= /body></html> --=_9fa2b2326cc777cce3000242d3716fba-- L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
OSCommerceSurgeon Posted November 4, 2004 Share Posted November 4, 2004 well OsCommerce is definately configured to send an HTML email because there is a bunch of HTML tags in there, it only sends one email containing plain text or an HTML formatted body. On the account.php page after the customer signs up it calls a function called: tep_mail(), this function is in your general.php file and it is pasted below: function tep_mail($to_name, $to_email_address, $email_subject, $email_text, $from_email_name, $from_email_address) { if (SEND_EMAILS != 'true') return false; // Instantiate a new mail object $message = new email(array('X-Mailer: osCommerce Mailer')); // Build the text version $text = strip_tags($email_text); if (EMAIL_USE_HTML == 'true') { $message->add_html($email_text, $text); } else { $message->add_text($text); } // Send message $message->build_message(); $message->send($to_name, $to_email_address, $from_email_name, $from_email_address, $email_subject); } As you see it only sends one email in either plain text or HTML. Since its sending it in HTML because you pasted the source of the email, the next thing to look at is your email client. Which email client are you using to read your emails with? Is HTML viewing turned on or off in your client? Is there a reminder on your website that you send HTML emails to your customers and that they should turn this option on in there client? Im not sure if this addresses your question but it looks as though OSComerce is sending correctly but your client has the HTML viewing option turned off, thus the reason for all the tags instead of nice formatting While I'm operating on OSCommerce, I don't have to worry about silly vitals or forgetting to turn off the ane..the.. no wait I remember aes....thetic, or right I've got it Anaesthetic Link to comment Share on other sites More sharing options...
PopTheTop Posted November 5, 2004 Author Share Posted November 5, 2004 No no no... The quoted e-mail above was from another osC web store, not mine. I know how to turn it on or off. I know how to send the HTML e-mails too. If you want to send HTML e-mails, the mail sending program of osC needs to send BOTH the stock non HTML AND the HTML e-mail in the same message. The quote I have above is the source code from one e-mail. As you can see, both are in there. If your e-mail program allows HTML e-mail, then the HTML e-mail will be displayed. If it does not, then the stock non HTML e-mail part will be displayed. ------------ WAIT... I just processed a test order in HTML format and it is doing just that. At least you do not have to worry about your e-mails not being read by some people. It works for both non HTML and HTML e-mail programs. I tried it wil Outlook Express and my HTML server mail. Here is a copy of that e-mail from my site. By looking at the source, you will see that both types are in there. To: "Ginny Moore" <[email protected]> Subject: Pop-the-top Trading Post Order #10136087 From: "Scott Moore" <[email protected]> MIME-Version: 1.0 X-Mailer: osCommerce Mailer Content-Type: multipart/alternative; boundary="=_ef7e6e36d1867a0e9887b9bfa5dea59e" Message-Id: <[email protected]> Date: Thu, 04 Nov 2004 21:55:33 -0500 --=_ef7e6e36d1867a0e9887b9bfa5dea59e Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Pop-the-top Trading Post ------------------------------------------------------ Order Number: 10136087 Detailed Invoice: https://www.popthetop.com/catalog/account_history_info.php?order_id=10136087 Date Ordered: November 04, 2004 Products ------------------------------------------------------ 1 x Test Item CD (PTT-000) = $8.95 ------------------------------------------------------ Sub-Total: $8.95 US Postal Service (Priority Mail - 2 to 3 Days): $3.85 MO Sales Tax 7.1%: $0.64 Total: $13.44 Delivery Address ------------------------------------------------------ Ginny Moore 13 Algonquin Circle Hillsboro, MO 63050 United States Billing Address ------------------------------------------------------ Ginny Moore 13 Algonquin Circle Hillsboro, MO 63050 United States Payment Method ------------------------------------------------------ Mail Check or Money Order Make Payable To: Scott Moore Send To: Pop-the-top Trading Post 13 Algonquin Circle Hillsboro, MO 63050 419-710-5712 Your order will not ship until we receive payment. --=_ef7e6e36d1867a0e9887b9bfa5dea59e Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Pop-the-top Trading Post<br>-----------------------------------------------= -------<br>Order Number: 10136087<br>Detailed Invoice: https://www.poptheto= p.com/catalog/account_history_info.php?order_id=3D10136087<br>Date Ordered:= November 04, 2004<br><br>Products<br>-------------------------------------= -----------------<br>1 x Test Item CD (PTT-000) =3D $8.95<br>--------------= ----------------------------------------<br>Sub-Total: $8.95<br>US Postal S= ervice (Priority Mail - 2 to 3 Days): $3.85<br>MO Sales Tax 7.1%: $0.64<br>= Total: $13.44<br><br>Delivery Address<br>----------------------------------= --------------------<br>Ginny Moore<br>13 Algonquin Circle<br>Hillsboro, MO= 63050<br>United States<br><br>Billing Address<br>----------------------= --------------------------------<br>Ginny Moore<br>13 Algonquin Circle<br>H= illsboro, MO 63050<br>United States<br><br>Payment Method<br>-----------= -------------------------------------------<br>Mail Check or Money Order<br= ><br>Make Payable To: Scott Moore<br><br>Send To:<br>Pop-the-top Trading Po= st<br>13 Algonquin Circle<br>Hillsboro, MO 63050<br>419-710-5712<br><br>You= r order will not ship until we receive payment.<br><br> --=_ef7e6e36d1867a0e9887b9bfa5dea59e-- L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
PopTheTop Posted November 5, 2004 Author Share Posted November 5, 2004 Now, let's get back to the original question here... Has anyone found a way to send order invoices in HTML format? Meaning, they have tables and such that actually look like an invoice and not just order details like it is being sent now. I tried the ONLY 2 in the Contributions but they are in a different language and I can not understand them or install them. L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
Guest Posted April 28, 2005 Share Posted April 28, 2005 Did you figure this out? Link to comment Share on other sites More sharing options...
PopTheTop Posted April 28, 2005 Author Share Posted April 28, 2005 Did you figure this out? <{POST_SNAPBACK}> No not yet. The only contribution released is in a different language and I can not figure it out. L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
saborchulo Posted April 28, 2005 Share Posted April 28, 2005 Do you mean sending a copy of the invoice like you get on the admin side when you click the invoice button? Link to comment Share on other sites More sharing options...
PopTheTop Posted April 28, 2005 Author Share Posted April 28, 2005 Do you mean sending a copy of the invoice like you get on the admin side when you click the invoice button? <{POST_SNAPBACK}> Yes, that is what I mean. Instead of getting this: Pop-the-top Trading Post------------------------------------------------------ Order Number: 12345678 Detailed Invoice: https://www.popthetop.com......... Date Ordered: April 27, 2005 Products ------------------------------------------------------ 1 x DVD & VHS Video Stabilizer (QI-DV01) = $69.95 ------------------------------------------------------ Sub-Total: $69.95 US Postal Service (1 x 1.9lbs) (Priority Mail): $5.70 Total: $75.65 Delivery Address ------------------------------------------------------ Customer Name 123 Anystreet City, ST 12345 United States Billing Address ------------------------------------------------------ Customer Name 123 Anystreet City, ST 12345 United States Payment Method ------------------------------------------------------ Credit Card You get this as the e-mail: L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
saborchulo Posted April 28, 2005 Share Posted April 28, 2005 Right I get what you are saying. Let me see what I can do. Link to comment Share on other sites More sharing options...
DVBHardware Posted April 29, 2005 Share Posted April 29, 2005 Yes, that is what I mean. Instead of getting this:You get this as the e-mail: Keep an eye on "PDF Invoice V1.4". I was wanting the same thing but to send a PDF invoice to the email address listed in the order page. I contacted the author and he seem to be working on it and should have a release in a couple of days. Jimmy I'm not a coder just a splicer. Link to comment Share on other sites More sharing options...
PopTheTop Posted April 29, 2005 Author Share Posted April 29, 2005 But that is not what I want due to the added bandwidth. HTML e-mail invoice is what I want. L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
saborchulo Posted May 2, 2005 Share Posted May 2, 2005 Here you go guys Email Invoice Mod This will take the invoice.php file on the admin side, generate the html and send it to your customer at order entry. Let me know what you think. Link to comment Share on other sites More sharing options...
PopTheTop Posted May 2, 2005 Author Share Posted May 2, 2005 I am installing it now so I will let you know in a short while. L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
PopTheTop Posted May 2, 2005 Author Share Posted May 2, 2005 Here you go guysEmail Invoice Mod This will take the invoice.php file on the admin side, generate the html and send it to your customer at order entry. Let me know what you think. <{POST_SNAPBACK}> Ok, installed it and these are my results... If I set flag in Admin to send HTML invoices to 1 and set Send MIME HTML E-mails to true, I get no changes. The e-mails sent are HTML, but in the stock osC format. If I set flag in Admin to send HTML invoices to true and set Send MIME HTML E-mails to true, I get the following error massage when I click on the Confirm Order button: Warning: Cannot modify header information - headers already sent by (output started at /home/popthet/public_html/catalog/admin/includes/languages/english/invoice.php:73) in /home/popthet/public_html/catalog/includes/functions/general.php on line 30 ============== I have catalog/includes/modules/email_invoice permissions set to 777 I have catalog/includes/modules/email_invoice/temp_cache.php permissions set to 777 I do not have a catalog/includes/local/configure.php file so I used the one supplied with this contribution and I have the following set: define('DIR_FS_ADMIN', '/home/popthet/public_html/catalog/admin/'); Line 73 in admin/includes/languages/english/invoice.php is at the very bottom, just below the final ?> Any ideas? L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
saborchulo Posted May 2, 2005 Share Posted May 2, 2005 Yes the flag should be set to true. I will make that clear in the instructions, I apologize for not mentioning that. I noticed from the screen shot that you have done some modification to the look of your invoice. Have you made a lot of changes to the invoice.php language file? The reason I mention this is because with the OSC 2.2-MS2 installation I have the invoice.php doesn't even have a line 73. If wouldn't mind taking a look at your invoice.php language file to see what may be happening, but that language file should not be outputting anything directly, which is what that error appears to be implying. Link to comment Share on other sites More sharing options...
PopTheTop Posted May 4, 2005 Author Share Posted May 4, 2005 Yes the flag should be set to true. I will make that clear in the instructions, I apologize for not mentioning that. I noticed from the screen shot that you have done some modification to the look of your invoice. Have you made a lot of changes to the invoice.php language file? The reason I mention this is because with the OSC 2.2-MS2 installation I have the invoice.php doesn't even have a line 73. If wouldn't mind taking a look at your invoice.php language file to see what may be happening, but that language file should not be outputting anything directly, which is what that error appears to be implying. <{POST_SNAPBACK}> Yes, I have modified it because I have my Fancier Invoice & Packingslip MOD installed. What it was is that I had an extra space after the last ?> so I just deleted that and all is well. I have just installed the latest update to this new contribution and seems to work great all but 1 major thing - If you send the HTML invoices out, someone viewing their e-mails through a web mail server or e-mail program with HTML e-mails turned off then the invoice is all screwed up. This is because there are no line breaks, they are stripped from the invoice for the non-HTML part. Looking at my source code from an HTML invoice e-mail, this is what it looks like... Return-path: <[email protected]> Envelope-to: [email protected] Delivery-date: Tue, 03 May 2005 20:24:41 -0400 Received: from nobody by server13.imagelinkusa.net with local (Exim 4.41) id 1DT7gv-0006Zx-Ij for [email protected]; Tue, 03 May 2005 20:24:41 -0400 To: "PopTheTop.com" <[email protected]> Subject: Pop-the-top Trading Post Order #10136286 From: "Test Account" <[email protected]> MIME-Version: 1.0 X-Mailer: osCommerce Mailer Content-Type: multipart/alternative; boundary="=_abcded453b9caed3fa8caa94089f187c" Message-Id: <[email protected]> Date: Tue, 03 May 2005 20:24:41 -0400 --=_abcded453b9caed3fa8caa94089f187c Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Pop-the-top Trading Post Invoice #05-10136286a:link { font-family: Verdana, Arial, sans-serif; font-size: 10px; color: #000000; font-weight: normal; text-decoration: none; }a:visited { font-family: Verdana, Arial, sans-serif; font-size: 10px; color: #000000; font-weight: normal; text-decoration: none; }a:active { font-family: Verdana, Arial, sans-serif; font-size: 10px; color: #000000; font-weight: normal; text-decoration: none; }a:hover { font-family: Verdana, Arial, sans-serif; font-size: 10px; color: #000000; font-weight: normal; text-decoration: underline; }body { background-color: #ffffff; color: #000000; margin: 0px; }.headerBar { background-color: #B3BAC5; }.headerBarContent { font-family: Verdana, Arial, sans-serif; font-size: 10px; color: #ffffff; font-weight: bold; padding: 2px; }.columnLeft { background-color: #F0F1F1; border-color: #999999; border-width: 1px; border-style: solid; padding: 2px; }.pageHeading { font-family: Verdana, Arial, sans-serif; font-size: 18px; color: #727272; font-weight: bold; }.pageHeadingsmall { font-family: Verdana, Arial, sans-serif; font-size: 12px; color: #727272; font-weight: bold; }.pageHeadingsmaller { font-family: Verdana, Arial, sans-serif; font-size: 11px; color: #727272; font-weight: bold; }.dataTableHeadingRow { background-color: #C9C9C9; }.dataTableHeadingContent { font-family: Verdana, Arial, sans-serif; font-size: 10px; color: #ffffff; font-weight: bold; }.dataTableRow { background-color: #F0F1F1; }.dataTableContent { font-family: Verdana, Arial, sans-serif; font-size: 10px; color: #000000; }FORM { display: inline; }CHECKBOX, INPUT, RADIO, SELECT, TEXTAREA, FILE { font-family: Verdana, Arial, sans-serif; font-size: 11px; }.formArea { background-color: #f8f8f9; border-color: #7b9ebd; border-style: solid; border-width: 1px; }.formAreaTitle { font-family: Tahoma, Verdana, Arial, sans-serif; font-size: 12px; font-weight: bold; }.attributes-odd { background-color: #f4f7fd; }.attributes-even { background-color: #ffffff; }.specialPrice { color: #ff0000; }.oldPrice { text-decoration: line-through; }.fieldRequired { font-family: Verdana, Arial, sans-serif; font-size: 10px; color: #ff0000; }.smallText { font-family: Verdana, Arial, sans-serif; font-size: 10px; }.main { font-family: Verdana, Arial, sans-serif; font-size: 12px; } Invoice # 05-10136286May 03, 2005 Pop-the-top Trading Post13 Algonquin CircleHillsboro, MO 63050419-710-5712 Invoice SOLD TO: Test Account 123 Any St. Apt A Hillsboro, Missouri 63050 United States 419-710-5712 [email protected] SHIP TO: Test Account 123 Any St. Apt A Hillsboro, Missouri 63050 United States Order #: 10136286 Date of Order: 05/03/2005 Payment: Check or Money Order Products SKU # Unit Price Total 1 x Test Item - FREE Shipping (hidden) PTT-002 $1.00 $1.00 Sub-Total: $1.00 Shipping: $0.00 Total: $1.00 ORDER COMMENTS: No comments have been left for this order Thank you for shopping atPop-the-top Trading Posthttp://www.popthetop.com --=_abcded453b9caed3fa8caa94089f187c Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <html><head><title>Pop-the-top Trading Post Invoice #05-10136286</title><st= yle type=3D"text/css">a:link { font-family: Verdana, Arial, sans-serif; fon= t-size: 10px; color: #000000; font-weight: normal; text-decoration: none; }= a:visited { font-family: Verdana, Arial, sans-serif; font-size: 10px; color= : #000000; font-weight: normal; text-decoration: none; }a:active { font-fam= ily: Verdana, Arial, sans-serif; font-size: 10px; color: #000000; font-weig= ht: normal; text-decoration: none; }a:hover { font-family: Verdana, Arial, = sans-serif; font-size: 10px; color: #000000; font-weight: normal; text-deco= ration: underline; }body { background-color: #ffffff; color: #000000; margi= n: 0px; }.headerBar { background-color: #B3BAC5; }.headerBarContent { font-= family: Verdana, Arial, sans-serif; font-size: 10px; color: #ffffff; font-w= eight: bold; padding: 2px; }.columnLeft { background-color: #F0F1F1; border= -color: #999999; border-width: 1px; border-style: solid; padding: 2px; }.pa= geHeading { font-family: Verdana, Arial, sans-serif; font-size: 18px; color= : #727272; font-weight: bold; }.pageHeadingsmall { font-family: Verdana, Ar= ial, sans-serif; font-size: 12px; color: #727272; font-weight: bold; }.page= Headingsmaller { font-family: Verdana, Arial, sans-serif; font-size: 11px; = color: #727272; font-weight: bold; }.dataTableHeadingRow { background-color= : #C9C9C9; }.dataTableHeadingContent { font-family: Verdana, Arial, sans-se= rif; font-size: 10px; color: #ffffff; font-weight: bold; }.dataTableRow { b= ackground-color: #F0F1F1; }.dataTableContent { font-family: Verdana, Arial,= sans-serif; font-size: 10px; color: #000000; }FORM { display: inline; }CHE= CKBOX, INPUT, RADIO, SELECT, TEXTAREA, FILE { font-family: Verdana, Arial, = sans-serif; font-size: 11px; }.formArea { background-color: #f8f8f9; border= -color: #7b9ebd; border-style: solid; border-width: 1px; }.formAreaTitle { = font-family: Tahoma, Verdana, Arial, sans-serif; font-size: 12px; font-weig= ht: bold; }.attributes-odd { background-color: #f4f7fd; }.attributes-even {= background-color: #ffffff; }.specialPrice { color: #ff0000; }.oldPrice { t= ext-decoration: line-through; }.fieldRequired { font-family: Verdana, Arial= , sans-serif; font-size: 10px; color: #ff0000; }.smallText { font-family: V= erdana, Arial, sans-serif; font-size: 10px; }.main { font-family: Verdana, = Arial, sans-serif; font-size: 12px; }</style></head><body marginwidth=3D"0"= marginheight=3D"0" topmargin=3D"0" bottommargin=3D"0" leftmargin=3D"0" rig= htmargin=3D"0" bgcolor=3D"#FFFFFF"><table border=3D"0" width=3D"100%" cells= pacing=3D"0" cellpadding=3D"2"> <tr> <td align=3D"left"><img src=3D"http:= //www.popthetop.com/catalog/images/pop-the-top_logo1.gif" border=3D"0" alt= =3D"Click HERE toDisplay or Hidethe Order Comments box below for printing" = width=3D"238" height=3D"54" hspace=3D"10"></td> <TD ALIGN=3D"right" VALIG= N=3D"top"><FONT FACE=3D"Verdana" SIZE=3D"2" COLOR=3D"#006699"><strong>Invoi= ce # 05-10136286<BR>May 03, 2005</strong></font> <br><br><span class=3D"p= ageHeadingSM"><FONT FACE=3D"Verdana" SIZE=3D"1" COLOR=3D"#006699"><strong>P= op-the-top Trading Post<br />13 Algonquin Circle<br />Hillsboro, MO 63050<b= r />419-710-5712</strong></font></span> </TD> </tr> <tr> <td colspan= =3D"2"> <table border=3D"0" width=3D"100%" cellspacing=3D"0" cellpadding= =3D"0"> <tr> <TD> <table width=3D"100%" border=3D"0" cellspacing=3D= "0" cellpadding=3D"2"> <tr> <td colspan=3D"4"> <table wi= dth=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"2"> <t= r> <td width=3D"10%"><hr size=3D"2"></td> <td align= =3D"center" class=3D"pageHeading" NOWRAP><em><b>Invoice</b></em></td> = <td width=3D"100%"><hr size=3D"2"></td> </tr> </t= able> </td> </tr> <tr> <td colspan=3D"4"><img s= rc=3D"http://www.popthetop.com/catalog/images/pixel_trans.gif" width=3D"100= " height=3D"5" alt=3D""></td> </tr> <tr> <td wid= th=3D"3"> </td> <td valign=3D"top"> <table width=3D"100= %" border=3D"0" cellpadding=3D"0" cellspacing=3D"0"> <tr> = <td width=3D"11"><img src=3D"http://www.popthetop.com/catalo= g/images/borders/maingrey_01.gif" width=3D"11" height=3D"16" alt=3D""></td>= <td background=3D"http://www.popthetop.com/catalog/images= /borders/maingrey_02.gif"><img src=3D"http://www.popthetop.com/catalog/imag= es/borders/maingrey_02.gif" width=3D"24" height=3D"16" alt=3D"" ></td> = <td width=3D"19"><img src=3D"http://www.popthetop.com/catalog/= images/borders/maingrey_03.gif" width=3D"19" height=3D"16" alt=3D""></td> = </tr> <tr> <td background=3D"= http://www.popthetop.com/catalog/images/borders/maingrey_04.gif"><img src= =3D"http://www.popthetop.com/catalog/images/borders/maingrey_04.gif" width= =3D"11" height=3D"21" alt=3D""></td> <td align=3D"center" = bgcolor=3D"#F2F2F2"> <table width=3D"100%" border=3D"0" cellspacing= =3D"0" cellpadding=3D"0" class=3D"main"> <tr> = <td align=3D"left" valign=3D"top"><b>SOLD TO:</b></td> = </tr> <tr> <td>= <img src=3D"http://www.popthetop.com/catalog/images= /pixel_trans.gif" width=3D"1" height=3D"5" alt=3D""></td> = </tr> <tr> <td NOWRAP> = ; Test Account <br> 123 Any St.<br>= Apt A<br> Hillsboro, Missour= i 63050<br> United States</td> = </tr> <tr> <td> &= nbsp; <img src=3D"http://www.popthetop.com/catalog/images/pixel_trans.= gif" width=3D"1" height=3D"10" alt=3D""></td> </tr> = <tr> <td NOWRAP> = ; 419-710-5712</td> </tr> <t= r> <td NOWRAP> test@popthetop= .com</td> </tr> <tr> = <td><img src=3D"http://www.popthetop.com/catalog/images/pixel_tr= ans.gif" width=3D"1" height=3D"7" alt=3D""></td> </tr>= </table> </td> <td background= =3D"http://www.popthetop.com/catalog/images/borders/maingrey_06.gif"><img s= rc=3D"http://www.popthetop.com/catalog/images/borders/maingrey_06.gif" widt= h=3D"19" height=3D"21" alt=3D""></td> </tr> <= tr> <td><img src=3D"http://www.popthetop.com/catalog/image= s/borders/maingrey_07.gif" width=3D"11" height=3D"18" alt=3D""></td> = <td background=3D"http://www.popthetop.com/catalog/images/border= s/maingrey_08.gif"><img src=3D"http://www.popthetop.com/catalog/images/bord= ers/maingrey_08.gif" width=3D"24" height=3D"18" alt=3D""></td> = <td><img src=3D"http://www.popthetop.com/catalog/images/borders/maingr= ey_09.gif" width=3D"19" height=3D"18" alt=3D""></td> </tr> = </table> </td> <td width=3D"45"> </td> = <td valign=3D"top"> <table width=3D"100%" border=3D"0= " cellpadding=3D"0" cellspacing=3D"0"> <tr> = <td width=3D"11"><img src=3D"http://www.popthetop.com/catalog/images/borde= rs/mainwhite_01.gif" width=3D"11" height=3D"16" alt=3D""></td> = <td background=3D"http://www.popthetop.com/catalog/images/borders/main= white_02.gif"><img src=3D"http://www.popthetop.com/catalog/images/borders/m= ainwhite_02.gif" width=3D"24" height=3D"16" alt=3D""></td> = <td width=3D"19"><img src=3D"http://www.popthetop.com/catalog/images/borde= rs/mainwhite_03.gif" width=3D"19" height=3D"16" alt=3D""></td> = </tr> <tr> <td background=3D"http://www.= popthetop.com/catalog/images/borders/mainwhite_04.gif"><img src=3D"http://w= ww.popthetop.com/catalog/images/borders/mainwhite_04.gif" width=3D"11" heig= ht=3D"21" alt=3D""></td> <td align=3D"center" bgcolor=3D"#= FFFFFF"> <table width=3D"100%" border=3D"0" cellpadding=3D"0" cells= pacing=3D"0" class=3D"main"> <tr> = <td align=3D"left" valign=3D"top"><b>SHIP TO:</b></td> = </tr> <tr> <td> = <img src=3D"http://www.popthetop.com/catalog/images/pixel_trans= .gif" width=3D"1" height=3D"5" alt=3D""></td> </tr> = <tr> <td NOWRAP> = ; Test Account <br> 123 Any St.<br> = Apt A<br> Hillsboro, Missouri 63050<b= r> United States</td> </tr> = <tr> <td> <= img src=3D"http://www.popthetop.com/catalog/images/pixel_trans.gif" width= =3D"1" height=3D"10" alt=3D""></td> </tr> = <tr> <td> </td> = </tr> <tr> <td= > </td> </tr> = <tr> <td><img src=3D"http://www.popthetop.com/ca= talog/images/pixel_trans.gif" width=3D"1" height=3D"7" alt=3D""></td> = </tr> </table> </td> <td ba= ckground=3D"http://www.popthetop.com/catalog/images/borders/mainwhite_06.gi= f"><img src=3D"http://www.popthetop.com/catalog/images/borders/mainwhite_06= .gif" width=3D"19" height=3D"21" alt=3D""></td> </tr> = <tr> <td><img src=3D"http://www.popthetop.com/cat= alog/images/borders/mainwhite_07.gif" width=3D"11" height=3D"18" alt=3D""><= /td> <td background=3D"http://www.popthetop.com/catalog/im= ages/borders/mainwhite_08.gif"><img src=3D"http://www.popthetop.com/catalog= /images/borders/mainwhite_08.gif" width=3D"24" height=3D"18" alt=3D""></td>= <td><img src=3D"http://www.popthetop.com/catalog/images/b= orders/mainwhite_09.gif" width=3D"19" height=3D"18" alt=3D""></td> = </tr> </table> </td> </tr> </t= able> </TD> </tr> <tr> <TD COLSPAN=3D"2"><img src=3D"http://ww= w.popthetop.com/catalog/images/pixel_trans.gif" width=3D"100" height=3D"15"= alt=3D""></td> </tr> <tr> <TD COLSPAN=3D"2"> <table wi= dth=3D"100%" border=3D"0" cellpadding=3D"0" cellspacing=3D"0"> <= tr> <td width=3D"9"> </td> <td> <tab= le width=3D"100%" border=3D"0" cellpadding=3D"0" cellspacing=3D"0"> = <tr> <td width=3D"11"><img src=3D"http://www.popthetop= .com/catalog/images/borders/maingrey_01.gif" width=3D"11" height=3D"16" alt= =3D""></td> <td background=3D"http://www.popthetop.com/cata= log/images/borders/maingrey_02.gif"><img src=3D"http://www.popthetop.com/ca= talog/images/borders/maingrey_02.gif" width=3D"24" height=3D"16" alt=3D"" >= </td> <td width=3D"19"><img src=3D"http://www.popthetop.com= /catalog/images/borders/maingrey_03.gif" width=3D"19" height=3D"16" alt=3D"= "></td> </tr> <tr> <td background= =3D"http://www.popthetop.com/catalog/images/borders/maingrey_04.gif"><img s= rc=3D"http://www.popthetop.com/catalog/images/borders/maingrey_04.gif" widt= h=3D"11" height=3D"21" alt=3D""></td> <td align=3D"center" = bgcolor=3D"#F2F2F2"> <table width=3D"100%" border=3D"0" cellpadding= =3D"0" cellspacing=3D"0" class=3D"main"> <tr> <td w= idth=3D"33%" NOWRAP> <b>Order #:</b> 10136286</td> <td= width=3D"33%" NOWRAP> <b>Date of Order: </b>05/03/2005</td> = <td> <b>Payment:</b> Check or Money Order</td> = </tr> <tr> <td><img src=3D"http://www.popt= hetop.com/catalog/images/pixel_trans.gif" width=3D"1" height=3D"7" alt=3D""= ></td> </tr> </table> </td> <td bac= kground=3D"http://www.popthetop.com/catalog/images/borders/maingrey_06.gif"= ><img src=3D"http://www.popthetop.com/catalog/images/borders/maingrey_06.gi= f" width=3D"19" height=3D"21" alt=3D""></td> </tr> = <tr> <td><img src=3D"http://www.popthetop.com/catalog/images/b= orders/maingrey_07.gif" width=3D"11" height=3D"18" alt=3D""></td> = <td background=3D"http://www.popthetop.com/catalog/images/borders/maing= rey_08.gif"><img src=3D"http://www.popthetop.com/catalog/images/borders/mai= ngrey_08.gif" width=3D"24" height=3D"18" alt=3D""></td> <td><i= mg src=3D"http://www.popthetop.com/catalog/images/borders/maingrey_09.gif" = width=3D"19" height=3D"18" alt=3D""></td> </tr> </tabl= e> </td> </tr> </table> </td> </= tr> <tr> <TD COLSPAN=3D"2"><img src=3D"http://www.popthetop.com/catal= og/images/pixel_trans.gif" width=3D"1" height=3D"15" alt=3D""></td> </tr= > <tr> <TD COLSPAN=3D"2"><img src=3D"http://www.popthetop.com/cata= log/images/pixel_trans.gif" width=3D"1" height=3D"10" alt=3D""></td> <= /tr> <tr> <TD COLSPAN=3D"2" align=3D"center"> <table border=3D"0= " width=3D"98%" cellspacing=3D"0" cellpadding=3D"2"> <tr class=3D"d= ataTableHeadingRow"> <td class=3D"dataTableHeadingContent" colsp= an=3D"2"> <font color=3D"#000000">Products</font></td> <td = WIDTH=3D"80" class=3D"dataTableHeadingContent"><font color=3D"#000000">SKU = #</font></td> <td WIDTH=3D"80" class=3D"dataTableHeadingContent"= align=3D"right"><font color=3D"#000000">Unit Price</font></td> = <TD WIDTH=3D"80" ALIGN=3D"right" CLASS=3D"dataTableHeadingContent"><font co= lor=3D"#000000">Total</font> </TD> </tr> <tr class=3D"dat= aTableRow"> <td class=3D"dataTableContent" valign=3D"top" align=3D"r= ight">1 x</td> <td class=3D"dataTableContent" valign=3D"top" NO= WRAP>Test Item - FREE Shipping (hidden) </td> <td WIDTH= =3D"80" class=3D"dataTableContent" valign=3D"top">PTT-002</td> <td= WIDTH=3D"80" class=3D"dataTableContent" align=3D"right" valign=3D"top">$1.= 00</td> <td WIDTH=3D"80" class=3D"dataTableContent" align=3D"right= " valign=3D"top"><b>$1.00 </b></td> </tr> <tr> <td al= ign=3D"right" colspan=3D"5"> <table border=3D"0" cellspacing=3D"0" cellp= adding=3D"2"> <tr> <td align=3D"right" class=3D"smallText"= >Sub-Total:</td> <td align=3D"right" class=3D"smallText">$1.00</td= > </tr> <tr> <td align=3D"right" class=3D"smallTex= t">Shipping:</td> <td align=3D"right" class=3D"smallText">$0.00</t= d> </tr> <tr> <td align=3D"right" class=3D"smallTe= xt"><b>Total:</b></td> <td align=3D"right" class=3D"smallText"><b>= $1.00</b></td> </tr> </table> </td> </tr> </ta= ble></td> </tr></table> <br><br> <table width=3D"100%" border=3D"= 0" cellpadding=3D"0" cellspacing=3D"0"> <tr> <td width=3D"9"> = </td> <td> <table width=3D"100%" border=3D"0" cellpadding=3D"= 0" cellspacing=3D"0"> <tr> <td width=3D"11"><img src=3D"ht= tp://www.popthetop.com/catalog/images/borders/maingrey_01.gif" width=3D"11"= height=3D"16" alt=3D""></td> <td background=3D"http://www.popthet= op.com/catalog/images/borders/maingrey_02.gif"><img src=3D"http://www.popth= etop.com/catalog/images/borders/maingrey_02.gif" width=3D"24" height=3D"16"= alt=3D"" ></td> <td width=3D"19"><img src=3D"http://www.popthetop= .com/catalog/images/borders/maingrey_03.gif" width=3D"19" height=3D"16" alt= =3D""></td> </tr> <tr> <td background=3D"http://ww= w.popthetop.com/catalog/images/borders/maingrey_04.gif"><img src=3D"http://= www.popthetop.com/catalog/images/borders/maingrey_04.gif" width=3D"11" heig= ht=3D"21" alt=3D""></td> <td align=3D"center" bgcolor=3D"#F2F2F2">= <table width=3D"100%" border=3D"0" cellpadding=3D"0" cellspacing= =3D"0" class=3D"main"> <tr> <td width=3D"95%" NOWRAP>&= nbsp;<b>ORDER COMMENTS:</b><br><br></td> </tr> <tr> = <td align=3D"center" width=3D"95%"> <table width=3D"95%"= border=3D"0" cellpadding=3D"0" cellspacing=3D"0"> <tr> = <td width=3D"95%" class=3D"smallText"> <table width=3D"1= 00%" border=3D"0" cellpadding=3D"0" cellspacing=3D"0" class=3D"main"> = <tr> <td width=3D"100%" align=3D"left" valign=3D"to= p" class=3D"smallText">No comments have been left for this order</td> = </tr> </table> </td> </tr> = </table> </td> </tr> <tr> = <td><img src=3D"http://www.popthetop.com/catalog/images/pixel_trans.gif"= width=3D"1" height=3D"7" alt=3D""></td> </tr> </table> = </td> <td background=3D"http://www.popthetop.com/catalog/= images/borders/maingrey_06.gif"><img src=3D"http://www.popthetop.com/catalo= g/images/borders/maingrey_06.gif" width=3D"19" height=3D"21" alt=3D""></td>= </tr> <tr> <td><img src=3D"http://www.popthetop.c= om/catalog/images/borders/maingrey_07.gif" width=3D"11" height=3D"18" alt= =3D""></td> <td background=3D"http://www.popthetop.com/catalog/ima= ges/borders/maingrey_08.gif"><img src=3D"http://www.popthetop.com/catalog/i= mages/borders/maingrey_08.gif" width=3D"24" height=3D"18" alt=3D""></td> = <td><img src=3D"http://www.popthetop.com/catalog/images/borders/main= grey_09.gif" width=3D"19" height=3D"18" alt=3D""></td> </tr> = </table> </td> </tr> </table><br><CENTER><span class=3D"= smallText"><FONT FACE=3D"Verdana" COLOR=3D"#006699"><strong>Thank you for s= hopping at<BR>Pop-the-top Trading Post<BR>http://www.popthetop.com</strong>= </font></span></CENTER></body></html> --=_abcded453b9caed3fa8caa94089f187c-- L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
PopTheTop Posted May 4, 2005 Author Share Posted May 4, 2005 The stock osC invoice needs to be sent for the non-html part of the e-mail in case this happens. ie... --=_abcded453b9caed3fa8caa94089f187c Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Pop-the-top Trading Post ------------------------------------------------------ Order Number: 101362 Detailed Invoice: https://www.popthetop.com/catalog/account_history_info.php?order_id=101362 Date Ordered: May 03, 2005 Products ------------------------------------------------------ 1 x Test Item - FREE Shipping (hidden) (PTT-002) = $1.00 ------------------------------------------------------ Sub-Total: $1.00 Shipping: $0.00 Total: $1.00 Billing Address ------------------------------------------------------ Test Account 123 Any St. Apt A Hillsboro, MO 63050 United States Payment Method ------------------------------------------------------ Check or Money Order Make Payable To: Scott Moore Send To: Pop-the-top Trading Post 13 Algonquin Circle Hillsboro, MO 63050 Your order will not ship until we receive payment. --=_abcded453b9caed3fa8caa94089f187c Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <html><head><title>Pop-the-top Trading Post Invoice #05-10136286</title><st= yle type=3D"text/css">a:link { font-family: Verdana......... L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
PopTheTop Posted May 4, 2005 Author Share Posted May 4, 2005 I just incorporated this contribution into my Fancier Invoice & Packingslip v5.0 contribution. Thanks for the help and your great work! L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
saborchulo Posted May 4, 2005 Share Posted May 4, 2005 LOL, good deal man. When I had requests from people to send the email similar to the fancy invoice I realized that the person asking for this mod was the one who created the fancy invoice mod! LOL As for your last comment, yea, for people that can't receive HTML emails (or choose not to) the plain text should still go to them, which is just a matter of generating both versions and sending them within the email boundaries which I believe can be done through the email class. I will modify the script to do this so people who get plain text will see the plain text and html clients will see the html. Link to comment Share on other sites More sharing options...
sak7180 Posted May 4, 2005 Share Posted May 4, 2005 Here you go guysEmail Invoice Mod This will take the invoice.php file on the admin side, generate the html and send it to your customer at order entry. Let me know what you think. <{POST_SNAPBACK}> on trying to run it, PHpmyadmin did not allow me to add your record. this is the message that was displayed, #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `configuration` ( `configuration_id` , `configurati I also tried running ei_sql.sql as text file, same message. I am no expert in mysql. could anybody make something out of this or have experienced this. I downloaded the email invoice version 1.1. I can try manually inserting in phpmyadmin but would like your thoughts on it before. Link to comment Share on other sites More sharing options...
sak7180 Posted May 4, 2005 Share Posted May 4, 2005 on trying to run it, PHpmyadmin did not allow me to add your record. this is the message that was displayed, #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `configuration` ( `configuration_id` , `configurati I also tried running ei_sql.sql as text file, same message. I am no expert in mysql. could anybody make something out of this or have experienced this. I downloaded the email invoice version 1.1. I can try manually inserting in phpmyadmin but would like your thoughts on it before. <{POST_SNAPBACK}> I just tried adding it manually and it has worked so first stage done. I have configured them is admin as well. now. Thanks. will now move to next stage. keep you updated, cheers. Link to comment Share on other sites More sharing options...
sak7180 Posted May 4, 2005 Share Posted May 4, 2005 I just tried adding it manually and it has worked so first stage done. I have configured them is admin as well. now. Thanks. will now move to next stage. keep you updated, cheers. <{POST_SNAPBACK}> Is that right checkout_process.php. i did follow your readme text. // lets start with the email confirmation /****************************************************** * Email Invoice 1.0. * Author Contact: [email protected] ******************************************************/ if (EMAIL_INVOICE == 'true') { require(DIR_WS_MODULES . EMAIL_INVOICE_DIR . FILENAME_EMAIL_INVOICE); } else { /**** End of Email Invoice Mod Snippet ****/ /*========================================*/ $email_order = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $insert_id . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $insert_id, 'SSL', false) . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG) . "\n\n"; if ($order->info['comments']) { $email_order .= tep_db_output($order->info['comments']) . "\n\n"; } $email_order .= EMAIL_TEXT_PRODUCTS . "\n" . EMAIL_SEPARATOR . "\n" . $products_ordered . EMAIL_SEPARATOR . "\n"; for ($i=0, $n=sizeof($order_totals); $i<$n; $i++) { $email_order .= strip_tags($order_totals[$i]['title']) . ' ' . strip_tags($order_totals[$i]['text']) . "\n"; } if ($order->content_type != 'virtual') { $email_order .= "\n" . EMAIL_TEXT_DELIVERY_ADDRESS . "\n" . EMAIL_SEPARATOR . "\n" . tep_address_label($customer_id, $sendto, 0, '', "\n") . "\n"; } $email_order .= "\n" . EMAIL_TEXT_BILLING_ADDRESS . "\n" . EMAIL_SEPARATOR . "\n" . tep_address_label($customer_id, $billto, 0, '', "\n") . "\n\n"; if (is_object($$payment)) { $email_order .= EMAIL_TEXT_PAYMENT_METHOD . "\n" . EMAIL_SEPARATOR . "\n"; $payment_class = $$payment; $email_order .= $payment_class->title . "\n\n"; if ($payment_class->email_footer) { $email_order .= $payment_class->email_footer . "\n\n"; } } /*=======================================================================*/ /**** Email Invoice Mod Snippet ****/ } /**** End of Email Invoice Mod Snippet ****/ /*=======================================================================*/ Link to comment Share on other sites More sharing options...
saborchulo Posted May 4, 2005 Share Posted May 4, 2005 Yea that is the file to edit. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.