PDF INVOICE - not showing Phone and Email

[Kaper]

Hello,

 

In 1.6.1.0 i have problem with Invoices. In adress is not shown phone number and email. My address format setting in Countries->xyz(State) looks like:

firstname lastname
company
vat_number
address1
address2
postcode city
Country:name
phone
phone_mobile

 

In 1.6.0.13 it was working fine... I tried it on clean install, and the problem is the same.

 

Thanks for fast help. I think that this is another bug in 1.6.1.0 ...

 

[bellini13]

did you report the issue to their forge?

[Kaper]

How Can I do it please?

[tuk66]

There are 2 new configuration options:

 

PS_INVCE_INVOICE_ADDR_RULES
PS_INVCE_DELIVERY_ADDR_RULES

 

where address format exceptions are set. Currently: ["vat_number","phone","phone_mobile"]

 

 

I like (hidden) surprises!

[Kaper]

And how can i enable them to show it in the INVOICE? Thanks

[tuk66]

Change both configuration records directly in the ps_configuration table to

["vat_number"]

and add

Customer:email

to all address formats.

[balanwindows]

@M4 sir

 

We are facing same problem when we upgraded 1.6.1.0 invoice generated without phone numbers kindly explain easily we tried your method but getting confusing .

please explain step by step

 

thank you .... looking for your solution

[omine]

Same issue here...

 

I found the PS_INVCE_INVOICE_ADDR_RULES into ps_configuration table.

 

The value is 

{"avoid":["vat_number","phone","phone_mobile"]}

I changed to

{"avoid":["vat_number"]}

But nothing happens.. 

Edited July 17, 2015 by omine (see edit history)

[tuk66]

Have you cleared cache?

[omine]

I'm sharing something that worked for me.

PS 1.6.1.0

select * from ps_configuration WHERE `name` LIKE '%PS_INVCE%';

This query returns the parameters below:

PS_INVCE_INVOICE_ADDR_RULES
PS_INVCE_DELIVERY_ADDR_RULES

Both parameters have same value: 

{"avoid":["vat_number","phone","phone_mobile"]}

Change both parameters values to

{"avoid":["vat_number"]}

If wish, can run this query:

update ps_configuration set value = '{"avoid":["vat_number"]}' where `name` = 'PS_INVCE_INVOICE_ADDR_RULES';
update ps_configuration set value = '{"avoid":["vat_number"]}' where `name` = 'PS_INVCE_DELIVERY_ADDR_RULES';

Once done, go to BackOffice

 

1. Address format per country

Localization -> Countries -> [select the country you wish to edit]. Click on button "[edit]"

Into the textarea "Address format", you can edit the parameters to be printed on PDF invoices, etc.

For customers phone, just add "phone" and/or "phone_mobile".
For customer email, add "Customer:email".

On the right side, there's a table with useful buttons. Just click on these buttons to add the codes or type manually.

For my case, this is the complete format:
 

firstname lastname
company
vat_number
Country:name
postcode
State:name city
address1
address2
phone
phone_mobile
Customer:email

Save the changes.

 

 

2. Clear the cache
Advanced Parameters -> Performance -> Click on button located on top right (clear cache)
 

All done.

Download any order invoice to ensure if working well.

 

 

thanks @tuk66

Edited July 17, 2015 by omine (see edit history)

[balanwindows]

Thank you for valuable info . but we unable to find this location

 

select * from ps_configuration WHERE `name` LIKE '%PS_INVCE%';

 

This query returns the parameters below:

PS_INVCE_INVOICE_ADDR_RULES
PS_INVCE_DELIVERY_ADDR_RULES

 

where is it? kindly help to solve this problem

[omine]

I don't understand what is your problem.

You must post details about what is your difficult.

[balanwindows]

Actually

 

we need explain sir, how to add the query ,

 

This query returns the parameters below:

 

PS_INVCE_INVOICE_ADDR_RULES
PS_INVCE_DELIVERY_ADDR_RULES

 

Both parameters have same value: 

{"avoid":["vat_number","phone","phone_mobile"]}

 

 

 

in our control panel when can we find this query .

 

kindly explain sir

 

Thank you

[omine]

You need MySQL Front End to execute the queries.

 

Websites of some popular softwares:

https://www.phpmyadmin.net/

https://www.mysql.com/products/workbench/

http://navicat.com

[Zumo]

It worked for me!

 

Thank you very much @omine! The orders made before fix this bug, don't have the phone, but it appears in the new ones.

[balanwindows]

Yes we using php mysql front end . but we unable to find this code

 

PS_INVCE_INVOICE_ADDR_RULES
PS_INVCE_DELIVERY_ADDR_RULES

 

 

 

can you tell how can we find the table or this query code

 

Thank you

[balanwindows]

Kindly check above our screenshot . there is no table or sql names like

 

PS_INVCE_INVOICE_ADDR_RULES
PS_INVCE_DELIVERY_ADDR_RULES

 

 

where can we find it..

 

 

Thank you

[Zumo]

Hi @balanwindows,

 

I think you are not using the right expression: 

select * from ps_configuration WHERE `name` LIKE '%PS_INVCE%';

Edited July 24, 2015 by Zumo (see edit history)

[balanwindows]

In our myphpadmin do not have this code 

 

PS_INVCE_INVOICE_ADDR_RULES
PS_INVCE_DELIVERY_ADDR_RULES

 

i attached screenshot . check it . and kindly let me know how can add this query

[omine]

I think this is only for version 1.6.1.0 and higher.

 

What is your PrestaShop version?

 

 

And, please, try to be clear and detailed on what are you doing, what are your conditions, etc.. so, we can help more effectively..

Your answers are so vague and bit confused.. 

[balanwindows]

Thank you we found solution and solved ..

[Jacek Es]

balanwindows. How did you fixed this? I also don't have this in setting the ps_configuration. Running PS 1.6.0.8

[Milouze]

Hello,
 
I have an other solution :
 
It's to override the PDF class HTMLTemplatesInvoice.php to change this :

 

$formatted_delivery_address = $this->order_invoice->delivery_address;

 

by this :

 

                $delivery_address = new Address((int)$this->order->id_address_delivery);
                $formatted_delivery_address = AddressFormat::generateAddress($delivery_address, array(), '<br />', ' ');

 

and on your invoices you can see the phone number in delivry adress.

 

And this new params PS_INVCE_INVOICE_ADDR_RULES and PS_INVCE_DELIVERY_ADDR_RULES it is not use in the HTMLTemplateDelivrySlip.php Why ? Good question ?

 

Bye

[mstevanic]

Hi to all..this option (@tuk66) works perfect for me now...finally I have telephone number in my Invoice..great

 

but I have another problem...

 

When someone try to order some product's (e.g 5 or more that that number) in one order,Im recieve

 

this order in two separate pdf invoice (e.g WIIXJXNUI or WIIXJXNUI#1 ) ..why? Thanx for help...Regards..Milorad

Edited October 9, 2015 by mstevanic (see edit history)

[kalithea]

 

Milouze's solution works. Great stuff.

 

[milanojs]

Thanks, working like charm, i have spend like 4 hours getting this thing working, with this like 5 minutes