Amend Invoice and delivery note by adding database fields created by other add-on modules

Amend Invoice and delivery note by adding database fields created by other add-on modules

Avatar image
Jan 27, 2013
Ben Leung wrote
I have an add-on module from myCollectionPlaces. I have tried to change the invoice layout and sql. However, there is an error saying "Field no found" when I run the invoice. I have changed invoice13.sql and invoice.fr3 in the Report folder.

Please advise what should be the correct steps.

Regards
Reply
3 Answers
Avatar image
Jan 28, 2013
Dmytro Grycelyak agent wrote
Hello Ben,

Thank you for contacting us.

It looks like the field name in the .fr3 file does not match with the the field name in the .sql file.

Also please note that "invoice13.sql" file is responsible for the Invoice structure for PretaShop 1.3.x shopping cart version.

In case you use PrestaShop 1.4.x you should manage "invoice14.sql" and if you use the latest shopping version - 1.5.x then you have to make an appropriate changes in "invoice15.sql".
Feb 04, 2013
123456 wrote
Hello,

I work on prestashop1.4 and want to edit invoice and add barcode in invoice. can anyone send me any module or API that help me to print barcode in invoice.
Avatar image
Feb 05, 2013
Dmytro Grycelyak agent wrote
Hello!

Thank you for you question.

In order to add a barcode to the invoice you have to add the "ean13" field from the "ps_product" table of your database to the "invoice14.sql" file and add a Barcode object to the Inoice.fr3 file to retrieve it: http://screencast.com/t/kkkZzvSGOip