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

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

3 Answers

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.

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