Fancier Invoice & Packingslip v1.0

[compusys]

Just upgraded to version 6, am I imagining it, or is there a bunch of language defines missing for the new print_my_invoice.php contributed by MrRim

[Guest]

Version 6...

 

Nice work...

 

Got an error on the print invoice page

 

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

select backorders from orders_status_history where orders_id = '216'

[TEP STOP]

Am I alone ?

[compusys]

yeah.. there appears to be some sort of reference to a 'backorder' contribution in the code.

I'm predicting a re-release of print_my_invoice.php v6.0 ;) with new language defines and 'backorder' code weeded out.

[Guest]

yeah.. there appears to be some sort of reference to a 'backorder' contribution in the code.

I'm predicting a re-release of print_my_invoice.php v6.0 ;) with new language defines and 'backorder' code weeded out.

<{POST_SNAPBACK}>

 

 

Here's the missing define to include/language/english.print_my_order.php

 

define('TABLE_HEADING_PRODUCTS', 'Article');

define('TABLE_HEADING_PRODUCTS_MODEL', 'Model');

define('TABLE_HEADING_UNIT_PRICE', 'Price Unit');

define('TABLE_HEADING_TOTAL', 'Total Price');

define('ENTRY_SOLD_TO', 'Sold to');

define('ENTRY_SHIP_TO', 'Send to');

define('INVOICE_TEXT_INVOICE', 'Invoice');

define('INVOICE_TEXT_NUMBER_SIGN', 'n?');

define('INVOICE_TEXT_ORDER', 'Order');

define('INVOICE_TEXT_DATE_OF_ORDER', 'Date of order');

define('INVOICE_TEXT_COLON', ':');

define('INVOICE_TEXT_DASH', '/');

define('ENTRY_PAYMENT_METHOD', 'Payment mode: ');

[ksaun]

This contrib assumes you are using the directory www.yoursite.com/catalog

 

If you do not use the catalog directory and instead place your files in the root or some other directory, do a search for the word catalog and remove or replace it in the file.

<{POST_SNAPBACK}>

 

What file do I make the changes to?? :huh:

[AWWWW.WAHWAH]

Here's the missing define to include/language/english.print_my_order.php

 

define('TABLE_HEADING_PRODUCTS', 'Article');

define('TABLE_HEADING_PRODUCTS_MODEL', 'Model');

define('TABLE_HEADING_UNIT_PRICE', 'Price Unit');

define('TABLE_HEADING_TOTAL', 'Total Price');

define('ENTRY_SOLD_TO', 'Sold to');

define('ENTRY_SHIP_TO', 'Send to');

define('INVOICE_TEXT_INVOICE', 'Invoice');

define('INVOICE_TEXT_NUMBER_SIGN', 'n?');

define('INVOICE_TEXT_ORDER', 'Order');

define('INVOICE_TEXT_DATE_OF_ORDER', 'Date of order');

define('INVOICE_TEXT_COLON', ':');

define('INVOICE_TEXT_DASH', '/');

define('ENTRY_PAYMENT_METHOD', 'Payment mode: ');

<{POST_SNAPBACK}>

 

There are still some missing defines after adding these. We'll see what Poppa says. :D

[PopTheTop]

Just upgraded to version 6, am I imagining it, or is there a bunch of language defines missing for the new print_my_invoice.php contributed by MrRim

<{POST_SNAPBACK}>

 

 

You are correct, I added the wrong language file to the package. I have added it in and will upload version 6.0a in a little bit...

[PopTheTop]

yeah.. there appears to be some sort of reference to a 'backorder' contribution in the code.

I'm predicting a re-release of print_my_invoice.php v6.0 ;) with new language defines and 'backorder' code weeded out.

<{POST_SNAPBACK}>

 

 

You must have ESP :-"

[PopTheTop]

Fancier Invoice & Packingslip v6.0a

Full Package Release

 

Updates:

- Added in the correct language define for print_my_invoice.php

- Removed a section of coding from the Backorders MOD

 

http://www.oscommerce.com/community/contributions,2861

[fatmcgav]

Fancier Invoice & Packingslip v6.0a

Full Package Release

 

Updates:

- Added in the correct language define for print_my_invoice.php

- Removed a section of coding from the Backorders MOD

 

http://www.oscommerce.com/community/contributions,2861

<{POST_SNAPBACK}>

Hey there,

I'm having a problem with one of the SQL statements that needs to be added to the db:

INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Template file you will be using for HTML invoices to the customer<BR><BR><i>invoice.php</i> - Stock osC look<BR><i>html_invoice.php</i> - HTML version<BR><i>box_invoice.php</i> - HTML version<BR><BR>', 12, 0, NULL, NOW(), '', '');

If i try to add it, it says that the column count doesnt match. I tried adding it manually, and cant get it to match up.

 

Any ideas on what code i need to use?

 

 

Cheers

Fatmcgav

[AWWWW.WAHWAH]

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 'from orders_status os, orders_status_history osh where osh.orde

 

select os.orders_status_name, osh.date_added, osh.comments, from orders_status os, orders_status_history osh where osh.orders_id = '296' and osh.orders_status_id = os.orders_status_id and os.language_id = '1' order by osh.date_added

 

Getting this in the screen after pressing Print Invoice in Customer history on the front end, not the admin side.

[PopTheTop]

Hey there,

I'm having a problem with one of the SQL statements that needs to be added to the db:

If i try to add it, it says that the column count doesnt match. I tried adding it manually, and cant get it to match up.

 

Any ideas on what code i need to use?

Cheers

Fatmcgav

<{POST_SNAPBACK}>

 

Use this one...

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Default E-Mailed HTML Invoice Template', 'EMAIL_TEMPLATE_FILE', 'html_invoice.php', 'Template file you will be using for HTML invoices to the customer<BR><BR><i>invoice.php</i> - Stock osC look<BR><i>html_invoice.php</i> - HTML version<BR><i>box_invoice.php</i> - HTML version<BR><BR>', 12, 0, NULL, NOW(), '', '');

[fatmcgav]

Use this one...

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Default E-Mailed HTML Invoice Template', 'EMAIL_TEMPLATE_FILE', 'html_invoice.php', 'Template file you will be using for HTML invoices to the customer<BR><BR><i>invoice.php</i> - Stock osC look<BR><i>html_invoice.php</i> - HTML version<BR><i>box_invoice.php</i> - HTML version<BR><BR>', 12, 0, NULL, NOW(), '', '');

<{POST_SNAPBACK}>

Yep, that did it.

 

Cheers

[PopTheTop]

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 'from orders_status os, orders_status_history osh where osh.orde

 

select os.orders_status_name, osh.date_added, osh.comments, from orders_status os, orders_status_history osh where osh.orders_id = '296' and osh.orders_status_id = os.orders_status_id and os.language_id = '1' order by osh.date_added

 

Getting this in the screen after pressing Print Invoice in Customer history on the front end, not the admin side.

<{POST_SNAPBACK}>

 

 

What version did you install? Was it the latest version 6.0a or 6.0b?

[Guest]

Same problem as above, downloaded 6.0a and updated install file to 6.0b

 

Inserted this in SQL:

INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Send HTML or Text Invoices to Customers', 'EMAIL_INVOICE', 'true', 'If this is enabled, order invoices will be sent to the customer in HTML format.<br><br>Enabled = true<br>Disabled = false<br><br>To use this, you must have HTML E-mails enabled.<br><br>', '12', '0', NULL , NOW( ) , '',  "tep_cfg_select_option(array('true', 'false'),");
INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Default E-Mailed HTML Invoice Template', 'EMAIL_TEMPLATE_FILE', 'html_invoice.php', 'Template file you will be using for HTML invoices to the customer<BR><BR><i>invoice.php</i> - Stock osC look<BR><i>html_invoice.php</i> - HTML version<BR><i>box_invoice.php</i> - HTML version<BR><BR>', 12, 0, NULL, NOW(), '', '');

[AWWWW.WAHWAH]

What version did you install? Was it the latest version 6.0a or 6.0b?

<{POST_SNAPBACK}>

 

It was 6.0a. I did not do the SQL instructions ... all I did was upload the new files from 6.0a. Do I need to? If so I went ahead and did the SQL update from the 6.0b instructions.

 

Basically I have kept the same SQL install from 5.5ish. Up to this time all I have been doing is uploading the new version files, that's it. This only started happening with 6.0.

 

Regards

 

p.s. with the SQL instructions for 6.0b, I still get the above same error.

[PopTheTop]

Same problem as above, downloaded 6.0a and updated install file to 6.0b

 

Inserted this in SQL:

INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Send HTML or Text Invoices to Customers', 'EMAIL_INVOICE', 'true', 'If this is enabled, order invoices will be sent to the customer in HTML format.<br><br>Enabled = true<br>Disabled = false<br><br>To use this, you must have HTML E-mails enabled.<br><br>', '12', '0', NULL , NOW( ) , '', ?"tep_cfg_select_option(array('true', 'false'),");
INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Default E-Mailed HTML Invoice Template', 'EMAIL_TEMPLATE_FILE', 'html_invoice.php', 'Template file you will be using for HTML invoices to the customer<BR><BR><i>invoice.php</i> - Stock osC look<BR><i>html_invoice.php</i> - HTML version<BR><i>box_invoice.php</i> - HTML version<BR><BR>', 12, 0, NULL, NOW(), '', '');

<{POST_SNAPBACK}>

 

 

Not sure then because that is the correct SQL import commands. You may want to go into your database manually and delete them both, then import them again.

 

1) Load up the database, click on configuration on the left panel of the screen.

 

2) Then click on the BROWSE tab at the top right side of the screen.

 

3) Then click on the configuration_group_id column header to sort by configuration_group_id

 

4) Scroll down to you get to all the group 12. Find the 2 imported SQL stuff there and delete/drop them.

 

Then re-import the SQL commands as in the installation instructions.

 

Other than that, I do not know how to help you.

[fatmcgav]

Hey there,

 

This may seem like a quite a silly question, but does this contrib only display HTML emails for the original invoice email, and not the order update emails?

 

IT's just that when i've been doing some test orders, i only recieve the original invoice email in HTML format, and not any of the subsequent order-update emails. Have i missed a step, or does this contrib only HTML the original invoice?

 

If it does only HTML the order invoice, is it possible to HTML the order-update emails aswell, as I just feel it would look better if the same format was used throughout the emails....

 

Cheers

Fatmcgav

[kunal247]

Hey there,

 

This may seem like a quite a silly question, but does this contrib only display HTML emails for the original invoice email, and not the order update emails?

 

IT's just that when i've been doing some test orders, i only recieve the original invoice email in HTML format, and not any of the subsequent order-update emails. Have i missed a step, or does this contrib only HTML the original invoice?

 

If it does only HTML the order invoice, is it possible to HTML the order-update emails aswell, as I just feel it would look better if the same format was used throughout the emails....

 

Cheers

Fatmcgav

<{POST_SNAPBACK}>

I also noticed the same problem and was going to post the same question.

Any solution to this available for updates?

 

Regards,

Kunal

[atwist]

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 'from orders_status os, orders_status_history osh where osh.orde

 

select os.orders_status_name, osh.date_added, osh.comments, from orders_status os, orders_status_history osh where osh.orders_id = '296' and osh.orders_status_id = os.orders_status_id and os.language_id = '1' order by osh.date_added

 

Getting this in the screen after pressing Print Invoice in Customer history on the front end, not the admin side.

<{POST_SNAPBACK}>

 

I am also getting this error and its a new install

[Guest]

I have now re-imported the SQL commands, no luck... :(

 

Found a small typo in catalog/print_my_invoice.php i says INVOIVE:

 

Line 316:

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

 

Replace with:

<CENTER><span class="smallText_INVOICE"><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>

[kunal247]

I have now re-imported the SQL commands, no luck... :(

 

Found a small typo in catalog/print_my_invoice.php i says INVOIVE:

 

Line 316:

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

 

Replace with:

<CENTER><span class="smallText_INVOICE"><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>

<{POST_SNAPBACK}>

I dont even seem to have those lines you have quoted.

Where are they suposed to go in the page?

[AWWWW.WAHWAH]

I have now re-imported the SQL commands, no luck... :(

 

Found a small typo in catalog/print_my_invoice.php i says INVOIVE:

 

Line 316:

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

 

Replace with:

<CENTER><span class="smallText_INVOICE"><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>

<{POST_SNAPBACK}>

 

Yah ... I found three in the same file.

[Guest]

My mistake, I didn't check the CSS properly...

 

The lines I posted was 316...

 

But never mind, I just doublechecked and found ".smallText_INVOIVE" in the CSS. I missed that :blush:

[sinryder]

Are you talking about PayPal IPN or just the stock PayPal payment module that comes with osC? It works fantastic with the stock PayPal payment module that comes with osC but there are those here who do have problems with both PayPal IPN contributions for some reason.

<{POST_SNAPBACK}>

 

 

 

hey budy i am running paypal ipn v3.1 and it not working with it :(