If you operate a global business with customers in multiple languages, you can dynamically generate invoice PDFs in your customers' preferred languages using one invoice template.
This article describes the process of setting up and generating invoice PDFs in multiple languages.
Only text-based merge fields are translated using the translation profile based on the locale in customer's communication profile. If the locale is not found for a customer, the original value is used.
Date and numeric merge fields are formatted based on the locale in the customer's communication profile.
A Zuora tenant can contain 5000 translations for invoice PDFs. If you upload multiple translation profiles, the sum of all the translated merge field values should be less than 5000 rows.
This feature is in Limited Availability. If you wish to have access to the feature, submit a request at Zuora Global Support.
To generate invoice PDFs in multiple languages:
Take the following two-phase process to enable invoice translation in your tenant.
A merge field value can be translated if all of the following are true about the merge field:
See Merge Fields for Invoices for the names, types, and translatability of merge fields.To create and upload a translation profile:
In the Translation Profile Detail section, click export. A sample translation file is downloaded.
The translation file contains only the MergeFieldName and OriginalValue columns.
MergeFieldName: Merge Field Name as it appears in the invoice template
OriginalValue: The value given in the language of your tenant. The maximum allowed length is 500 characters.
Add a language you want to translate to in each of the remaining columns. Type the language code in the column heading, e.g. de-DE. The language codes are case-sensitive. You need to type exactly as shown in the list below. The maximum allowed length is 500 characters.
Save the translation file. If you use Microsoft Excel to edit the translation file, save the file in the Windows Comma Separated (.csv) format.
Do not save in the MS-DOS Comma Separated (.csv) format.
You must save the translation file in the UTF-8 Format.
In the Import Translation Profile section, click Choose File, select the translation CSV file, and click import.
Review the import summary and click OK.
Click and select a language in the translation file to review the translation.
Now you can manage invoice template files and generate invoice PDF as described in Customize Invoice Templates Using Word Mail Merge.
With the example translation profile below, the two merge fields would render translated values since these were the only two provided in the translation profile. All other merge fields would be displayed in the default language used in the product catalog.
|Best Product Ever||Meilleur Produit Jamais||Beste Product aller Zeiten|
|Best Product Ever - |
|Meilleur Produit Jamais - Edition d'Or||Beste Produkt aller Zeiten - Gold Edition|
In addition to the supported merge fields, you can translate the following strings using the SPECIAL.PPOC merge field:
The above SPECIAL.PPOC strings are suffixes appended to invoice item names for a proration, a prepayment, an overage, or a credit. For example, the prorated invoice item name would be "XXX -- Proration" for the invoice item named, "XXX". Invoice items with the SPECIAL.PPOC suffixes are translated separately from the regular invoice item names.
SPECIAL.PPOC is not a true mail merge field and can not be used in invoice templates.
Do not use any of the above SPECIAL.PPOC strings at the end of your charge names, or the charge name may be incorrectly translated.
The following is an example translation profile for the special merge fields.
The language country codes are comprised of two arguments separated by a dash, for example fr-CA is French Canadian:
Invoice template merge fields can be translated into the following languages.
Do not use Excel on Mac systems to create a translation profile file for multi-byte languages. The characters may not be saved correctly.
We recommend Google Spreadsheet or a plain text editor, such as Sublime, to create a translation profile on Mac.