Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Fancier Invoice & Packingslip v1.0


PopTheTop

Recommended Posts

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.

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

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.

 

 

Well, I'm sure my store isn't in the catalog subfolder. I can't check the paths, because in the email when I right click on the images I don't have a "Properties" option. So, please tell me where would I go to change the paths to suit my needs...

 

Thank you very very much!!!

Link to comment
Share on other sites

Well, I'm sure my store isn't in the catalog subfolder. I can't check the paths, because in the email when I right click on the images I don't have a "Properties" option. So, please tell me where would I go to change the paths to suit my needs...

 

Thank you very very much!!!

 

 

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!

Link to comment
Share on other sites

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.

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

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.

 

Bingo

Thanks, I guess I was tired last night, I missed the admin/includes/language files.

I have uploaded them and everything is ok now.

 

jer37

Link to comment
Share on other sites

I hate to come back here and ask for help on this. It should be simple but I cannot find the answer.

 

My invoice looks ok and says invoice on it when printed. The packing slip is the problem. When it prints instead of saying packing slip or where it should say packing slip it says "osCommerce". Everything else on the page looks great.

 

I have checked and rechecked all of the files, when I right click on the page the properties show as catalog/admin/packingslip.php? I have looked that over at least 5 times and cannot see where "osCommerce " is coming from.??

 

Thanks in advance

jer37

Edited by jer37
Link to comment
Share on other sites

I hate to come back here and ask for help on this. It should be simple but I cannot find the answer.

 

My invoice looks ok and says invoice on it when printed. The packing slip is the problem. When it prints instead of saying packing slip or where it should say packing slip it says "osCommerce". Everything else on the page looks great.

 

I have checked and rechecked all of the files, when I right click on the page the properties show as catalog/admin/packingslip.php? I have looked that over at least 5 times and cannot see where "osCommerce " is coming from.??

 

Thanks in advance

jer37

 

 

Got it fixed

Thanks

 

jer37

Link to comment
Share on other sites

Unfortunately, it doesn't work. Any suggestions? I'm beginning to think about restoring a backup and forgetting about this. And I don't want to, because I really like this mod...Please!

 

Me again. Still trying to solve the problem...

I have installed, before this mod, email invoice 1.1 and when I set from admin instead of fancy.php invoice.php I still don't have in the email the customer gets an image (the only one being the banner of my site). Where do I have to go and change the path so that images show. Because I'm happy with either email invoice or fancier invoice (though I prefer the second choice). But I need my images! In the customers account the invoice looks ok, same with print invoice. The only problem is with email.

 

Please don't leave me in this situation. Help a poor stupid woman!!!:D

Link to comment
Share on other sites

(kev2me @ Aug 20 2005, 09:39 AM)

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:

 

CODE
, osh.backorders

 

 

Hopefully that helps.

 

 

Yep, that will do it for you.

 

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

Link to comment
Share on other sites

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.

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

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:

 

e-mailsettings.gif

Link to comment
Share on other sites

Hey thats Good :thumbsup:

 

Im still running one of the earlier versions back when you first came out with it...I stopped at the one that copied the look of the new invoice to the web invoice after customer logs in... (our site was centered & didnt think it would look right)

 

:D This thread is very active :D

 

see ya around B)

 

By the way, I received a PM from one of the team members here and this is what they had to say...

 

"After our team meeting this morning, I've been asked to invite you to join the contributions moderator team. Your responsibilities would be..."

 

I have accepted this invitation so you may start seeing me around more. Thanks to all of you for giving my contributions a chance and allowing me to help when I can!

 

I am not a programmer by trade and only started with PHP last August, but learning more and more each day as you can see just from this contribution alone.

Edited by TCwho
Link to comment
Share on other sites

Does anyone know how to make the packing slips sort on the model number? I'm running in circles lately trying to pack orders, it would be helpful if the packing slips had the products sorted to match how I have products arranged in my warehouse.

 

Thanks in advance.

Link to comment
Share on other sites

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:

 

e-mailsettings.gif

 

 

Hmm, looks like you have 2 thing contridicting one another.

 

Your E-mail Options should look like this...

E-mail_Options.jpg

 

What is the line that sets a template called fancy.php? You have 2 template settings there. This must be your problem.

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

Everything has been working fine until now.

When I try to checkout with a purchase I get this message:

Warning: main(/home/YOUR_DOMAIN/public_html/catalog/admin/includes/languages/english/invoice.php): failed to open stream: No such file or directory in /home/www/hpoawear.com/catalog/includes/modules/email_invoice/email_invoice.php on line 30

 

Warning: main(/home/YOUR_DOMAIN/public_html/catalog/admin/includes/languages/english/invoice.php): failed to open stream: No such file or directory in /home/www/hpoawear.com/catalog/includes/modules/email_invoice/email_invoice.php on line 30

 

Fatal error: main(): Failed opening required '/home/YOUR_DOMAIN/public_html/catalog/admin/includes/languages/english/invoice.php' (include_path='.:/usr/local/lib/php') in /home/www/hpoawear.com/catalog/includes/modules/email_invoice/email_invoice.php on line 30

 

email_invoice.php Line 30 is where I get lost

 

Thanks

jer37

Link to comment
Share on other sites

Everything has been working fine until now.

When I try to checkout with a purchase I get this message:

Warning: main(/home/YOUR_DOMAIN/public_html/catalog/admin/includes/languages/english/invoice.php): failed to open stream: No such file or directory in /home/www/hpoawear.com/catalog/includes/modules/email_invoice/email_invoice.php on line 30

 

Warning: main(/home/YOUR_DOMAIN/public_html/catalog/admin/includes/languages/english/invoice.php): failed to open stream: No such file or directory in /home/www/hpoawear.com/catalog/includes/modules/email_invoice/email_invoice.php on line 30

 

Fatal error: main(): Failed opening required '/home/YOUR_DOMAIN/public_html/catalog/admin/includes/languages/english/invoice.php' (include_path='.:/usr/local/lib/php') in /home/www/hpoawear.com/catalog/includes/modules/email_invoice/email_invoice.php on line 30

 

email_invoice.php Line 30 is where I get lost

 

Thanks

jer37

More problems poping up....wonder whats going on

I am now seeing this on the order confirmation page:

Warning: htmlspecialchars() expects parameter 1 to be string, array given in /home/www/hpoawear.com/catalog/includes/functions/general.php on line 42

Not being that familiar with PHP line 42 in general.php tells me nothing

 

Help

Jer37

Link to comment
Share on other sites

More problems poping up....wonder whats going on

I am now seeing this on the order confirmation page:

Warning: htmlspecialchars() expects parameter 1 to be string, array given in /home/www/hpoawear.com/catalog/includes/functions/general.php on line 42

Not being that familiar with PHP line 42 in general.php tells me nothing

 

Help

Jer37

 

 

OK Disregard....its all fixed

 

jer37

Link to comment
Share on other sites

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.

 

Well, I'm still lost here. I have gone through the installation process again, and everything is uploaded correctly. It appears the problem is with that pesky catalog/print_my_invoice.php file. When I use the one that came with the contribution (v6.1) I downloaded, it doesn't work (Opens up a page with my site shell, but no order content.) When I use the code you posted for me on this board, it works perfect?even opens the Print dialog box?except it has the following error:

 

1054 - Unknown column 'backorders' in 'field list'

 

select backorders from orders_status_history where orders_id = '11'

 

[TEP STOP]

 

Obviously, this is because I don't have the backorder module installed, like someone else here suggested. However, when I remove the parts suggested...

 

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

 

...it went to not working again. Apparently there is some code within that "backorder addition" snippet that is crucial to the rest of the file, although I am not skilled enough to figure it out. Does anyone have any code from print_my_invoice.php from their working store that DOESN'T have the backorder mod installed? I suppose I could try and add that backorder mod, but I'm not sure which one it is...

 

PLease help! Thanks.

Link to comment
Share on other sites

My invoice looks ok and says invoice on it when printed. The packing slip is the problem. When it prints instead of saying packing slip or where it should say packing slip it says "osCommerce". Everything else on the page looks great.

 

I have checked and rechecked all of the files, when I right click on the page the properties show as catalog/admin/packingslip.php? I have looked that over at least 5 times and cannot see where "osCommerce " is coming from.??

 

Thanks in advance

jer37

 

I had this problem fixed but it is back and I cannot remmeber how I fixed it the first time.

 

Help

Link to comment
Share on other sites

  • 2 weeks later...

Hi. i have the same problem as "jbirdink"

 

the problem is that either nothing shows up on the print invoice page besides from the breadcrumb wich is not translated.

 

i have been troubleshooting this problem and i have made theese obervations.

 

if i leave the by mistake comma in place

#####do not use ######

 $statuses_query = tep_db_query("select os.orders_status_name, osh.date_added, osh.comments, 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");

 

the page shows contents but with the known SQL error.

 

at last i figured out that if i put the include column right line at the buttom of my page i get no errors and my print page shows fine, but then i have the right collumn.

 

<!-- 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 //-->
<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

 

 

i hope that it helps someone to fix the problem.

Link to comment
Share on other sites

I have now narrowed it down and i think perhaps it has something to do with the STS contribution.

because i tried to make a call to a coll left file with a difrent name and started to delete the content and i found that this bit of code is essential for me to run the code.

 

my column_right1.php

 

<?php
  // STS: ADD
 $sts_block_name = 'columnleft2columnright';
 require(STS_RESTART_CAPTURE);
 // STS: EOADD
?>

 

and this is my call at the buttom of my print invoice.php

<!-- 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 . 'column_right1.php'); 
require(DIR_WS_INCLUDES . 'application_bottom.php'); 
?>

 

 

the only problems left now is a space to the right and the print options does not pop up automaticaly as they should.

 

again i hope this helps to finding the problem.

 

 

anyone is free to use this little workarround but be aware that it might not work for you and i know of the above errors in this tweak.

Link to comment
Share on other sites

This is doing my head in now...I've looked all over to see why this could be happening.

 

I've got this mod working fine but, the only problem I have is that when an invoice is sent out to a customer, our company logo seems to be showing up as a broken link...looking at the source it shows the path as being;-

 

<td align="left"><img src="my_website_url/catalog//catalog/images/oscommerce.gif

 

Can anyone tell me why the extra /catalog is in the path betwen my web url and the image path?

 

I'm thinking that this is why my logo isn't showing up....prepared to be proved wrong though if anyone knows another reason ;-)

 

All other images show up fine, it's just in the emails.

 

In invoice.php and email_invoice.php I have specified;-

 

// Image Info

define('INVOICE_IMAGE', 'images/oscommerce.gif'); //Change this to match your logo image and foler it is in

 

 

Hopefully someone wil know the answer and then I'm finished

 

TIA for any help.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...