Modifying Prestashop invoice template is quite difficult, but thanks to some really nice guys who shared their work, there are a few invoice templates that can be used.
If you like any of these templates you can download them and just replace the .tpl files:
– if you use the DEFAULT theme then you must replace the .tpl files located in /public_html/pdf – if you use a custom theme you need to replace the .tpl files from themes/custom_theme_name/pdf
Supremacy2k wrote an excellent step-by-step guide how to customize the Prestashop invoice template. Starting from their templates you can customize the layout of your invoices to look more professional, but this will require some programming skills. However, following the step-by-step instruction provided in his guide you will be able to create your own invoice.
For Central European languages that use Latin script (Polish, Czech, Slovak, Hungarian, Slovene, Serbian, Croatian, Romanian and Albanian) you need to change the default font in order to display characters correctly. Use Freeserif fon instead of using Helvetica.
You can change the default font by editing the PDFGenerator.php file, located in classes\pdf\PdfGenerator.php and search for:
and replace it with:
Save the file and you are ready to use your new Prestashop invoice template.
You can name this cell MySource. You could then use a formula such as the following to return the random string of characters (broken into individual lines for clarity, but it is still a single formula):
This long formula concatenates eight characters pulled from the cell source entered in A1
There is another approach for this that uses a table that contains all the characters you want in your random text string. Start by placing the number 1 through 62 in a column, one number in each row. To the left of these numbers place your other charactheres – A, B, C, D, E etc. (this should be the same characters you placed in cell A1, using the previous method).
Select both columns of the 63 rows and name it MyTable. You can then use the following formula to generate the random characters (broken into individual lines for clarity, but it is still a single formula)
Attention: Both approaches have one drawback – they are regenerated each time the worksheet is calculated making it impossible to have a single generated random string that will not change on a regular basis. The best way around this is to use a macro that will put the random strings into your workbook starting at a specific cell location
Dim iTemp AsInteger
Dim sNumber AsString
Dim bOK AsBoolean
Loop Until bOK
Run the macro, and whatever is in cells D4:D53 is overwritten by the random values. If you want the values written into a different location, change the Range statement near the beginning of the macro.
If you need to count all cells with numbers you can use the Excel COUNT function which counts cells that contain numbers. Its syntax is: =COUNT(value1, value2,…valueX). value1, value2,…, valueX can be cell references, or values typed into the COUNT formula.
Excel COUNT function example – count numbers in cells A2:A7.
In the cell where you want to count number enter the following formula =COUNT (A2:A7)
Press Enter to complete the formula
The result will be 3, the number of cells that contain numbers.
Cells A2, A4, and A6 aren’t counted, because they contains text
Note: Dates are stored as number, so the COUNT function will include any cells that contain dates.
The Country column represents the data for which you want to create the pie chart (with percentage for each country). You need to add a column and fill it with 1 (this will be used to count how many times each country appears in my Country column).
Select the data from both columns and create a Pivot Table: go to Insert tab and click on the Pivot Table | PivotTable button. You have the option to create the pivot table in the same worksheet or on a new sheet)
On the PivotTable Field List drag Country to Row Labels and Count to Values.
Now select the pivot table data create the pie chart:
Using pivot tables allows you to update the data in the pie chart very easily – all you need is to update the Country column.
If you don’t have an Exchange server you can create an auto-reply template:
Create an auto-reply email template and save it as an Outlook template
Create a message reply to send an automatic reply to your emails. In Tools | Rules and Alerts create a new rule (Start from a blank rule, click Check messages when they arrive)
In Which condition(s) do you want to check? window select the Sent Only To Me
In What do you want to do with the message? window select the Reply using a specific template check box. In the Select A Reply Template dialog box, click the email template that you created as auto-reply template.
Click on the a specific template link to browse for the auto-reply email template. The template should be in the User Templates in File System from the Look In drop down box
Name your rule and click the Finish button.
Please note that this rule will send the reply only one time to each sender (Outlook will save a list of email addresses it has responded to prevent sending repetitive replies, but if the Outlook is closed the list is deleted)