[Released] Prof. Invoice and Packingslip

my product on my webshop are in 2 languages, English and dutch.
When generating packing slip the text is in english (same as admin language) but my productlines are in dutch. How can I get these productlines also in english on the packing slip?

thanks!

JonathanRR wrote:my product on my webshop are in 2 languages, English and dutch.
When generating packing slip the text is in english (same as admin language) but my productlines are in dutch. How can I get these productlines also in english on the packing slip?

thanks!

This is because you Admin has the English as language while the order has been placed using the Dutch language.
Switch your Admin to Dutch and voila.

I have a shop in 4 languages​​, I can not change every time administration language when I want to generate invoice in different languages​​.

qnxmore wrote:I have a shop in 4 languages​​, I can not change every time administration language when I want to generate invoice in different languages​​.

Then you should hire someone that will code "something" to make it work for you

Then use this simple admin language switcher: http://osworx.net/de/downloads/cat_view ... qmod-files

This VQMod will place a select field with all active languages at the top of the admin section (beside the menus) -and can be used from every page:

Hi Osworx,

Thanks for the plugin. I used it but when I select another language nothing is changing. Still uses the default language.

I'm using Opencart 1.5.4.1. Any idea how to fix this?

Thanks in advance!

Thank you, OSWorX, but something is wrong, now I have drop down menu, but if I change language, nothing is happened. Admin language is not changing and half invoice's is still in default language. Maybe save button is missing?
I use v. 1.5.2.1

Hello all,

I am really sorry for the troubles!

Please download the file again and override the installed.
Just realized (2012.11.30 - 23:12) that I have forgotten an important part in the .xml - now it should work as expected.

Perfect solution v 1.5.2.1 is OK! Tested!

Yes, it's works like charm, and I think, it's resolv many many admins problems

qnxmore wrote:Yes, it's works like charm, and I think, it's resolv many many admins problems

Thanks.
To keep this thread clean, I have created a new: http://forum.opencart.com/viewtopic.php?f=131&t=90194

Hallo,

I need some help. I downloaded Prof.Invoice_Packingslip_1.5.1.3 (http://www.opencart.com/index.php?route ... on_id=4121), and installed on Opencard 1.5.4.1. At the beginning it worked perfectly. Now it keeps on poping up problems,

1, error log appears, each time the button is clicked.
2013-02-12 21:05:23 - PHP Notice: Undefined index: order_id in ..admin/controller/sale/order.php on line 294
2013-02-12 21:05:23 - PHP Notice: Undefined index: order_id in ..admin/controller/sale/order.php on line 299
2, Under sales/order, if view an order, a mistake appears as
Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in ..admin/view/template/sale/order_info.tpl on line 11
While Edit is working fine.

3, Os_commerce_invoice does not show any order ID. It should be able to generate somewhere, but I do not find it anymore.

Any help is very much appreciated!

hey... i get this error in vqmod log on opencart v1.5.4 any idea how may i fix this?

thanks alot

work with v15.2.1?

Don't think so.

please help this has messed up other extensions , i have deleted this mod and still causing problems

BTW , works fine on v15.21 , but has messed other extensions up ? even after deleting extension?

Now sorted , even though had renamed the VQMOD file, it was still causing problems, have now deleted it.

this worked fine v1.5.2.1 , just conflicted with other extensions, can you help make it work?

I have opencart 1.5.4.1
i have installed VQMOD of this work http://www.opencart.com/index.php?route ... ame=bgill0

now problem is that i can't change the logo even after replacing logo.png with my company logo .

Major problem is that it show invoice date of current date . i want invoice date same date when i generated invoice number
how can we do that please tell me ?

Hi,
Ive installed this mod from the link: http://www.opencart.com/index.php?route ... ame=bgill0

and its working just fine on opencart v1.5.6 except the language on the buttons but that can be fixed easily.

Ive tried every step from the guide below for sku.. but they are not showing up.. can you please tell me how to get it done on 1.5.6
thanks.

afwollis wrote:for those who want to see SKU...

the changes are almost the same for both "mods"

step #0 (one for both)
open

Code: Select all

admin/model/sale/order.php

after (near the end of file)

Code: Select all

public function getTotalSalesByYear($year) {
      	$query = $this->db->query("SELECT SUM(total) AS total FROM `" . DB_PREFIX . "order` WHERE order_status_id > '0' AND YEAR(date_added) = '" . (int)$year . "'");

		return $query->row['total'];
	}

add

Code: Select all

	/* webme - get sku - for osC-invoice or Packingslip - mod - start */
	public function wbm_getSKU($prodID) {
		$query = $this->db->query("SELECT `sku` FROM `" . DB_PREFIX . "product` WHERE `product_id` = '".(int)$prodID."' LIMIT 1");
		
		return $query->row['sku'];
	}
	/* webme - get sku - for osC-invoice or Packingslip - mod - end */

...in their invoices

step #1
open

Code: Select all

admin/controller/sale/order.php

find function

Code: Select all

public function osc_invoice() {

inside it
after

Code: Select all

$this->data['column_comment'] = $this->language->get('column_comment');

add

Code: Select all

$this->data['column_sku'] = $this->language->get('column_sku');

scroll down
after (somewhere around the line 1109)

Code: Select all

						'model'    => $product['model'],

add

Code: Select all

						'sku'    => $this->model_sale_order->wbm_getSKU($product['product_id']),

step #2
open

Code: Select all

admin/language/english/sale/osc_order.php

add anywhere

Code: Select all

$_['column_sku']         = 'SKU';

step #3
open

Code: Select all

admin/view/template/sale/osc_order_invoice.tpl

after

Code: Select all

<td class="dataTableHeadingContent-invoice"><?php echo $column_model; ?></td>

add

Code: Select all

<td class="dataTableHeadingContent-invoice"><?php echo $column_sku; ?></td>

after

Code: Select all

<td class="dataTableContent" valign="top"><?php echo $product['model']; ?></td>

add

Code: Select all

<td class="dataTableContent" valign="top"><?php echo $product['sku']; ?></td>

replace

Code: Select all

<td colspan="8" align="right"><br> <table border="0" cellpadding="2" cellspacing="0">

to

Code: Select all

<td colspan="9" align="right"><br> <table border="0" cellpadding="2" cellspacing="0">

OC_osC-invoice_packingslip_sku_001.png

...in their packingslips

step #1
open

Code: Select all

admin/controller/sale/order.php

find function

Code: Select all

public function packingslip() {

inside it
add

Code: Select all

$this->data['column_sku'] = $this->language->get('column_sku');

after

Code: Select all

$this->data['column_comment'] = $this->language->get('column_comment');

scroll down
after (somewhere around the line 1327)

Code: Select all

						'model'    => $product['model'],

add

Code: Select all

						'sku'    => $this->model_sale_order->wbm_getSKU($product['product_id']),

step #2
open

Code: Select all

admin/language/english/sale/packingslip.php

add anywhere

Code: Select all

$_['column_sku']         = 'SKU';

step #3
open

Code: Select all

admin/view/template/sale/order_packingslip.tpl

after

Code: Select all

<td class="dataTableHeadingContent-invoice"><?php echo $column_model; ?></td>

add

Code: Select all

<td class="dataTableHeadingContent-invoice"><?php echo $column_sku; ?></td>

after

Code: Select all

<td class="dataTableContent" valign="top"><?php echo $product['model']; ?></td>

add

Code: Select all

<td class="dataTableContent" valign="top"><?php echo $product['sku']; ?></td>

OC_osC-invoice_packingslip_sku_002.png

November 2013 - Official Support for this Mod has been STOPPED!

There is a Free alternative over on the Dutch forums.

http://forum.opencart.com/viewtopic.php ... 75#p424675