Challenge & Solution
I was contacted by Almac Imports to collaborate in the creation and maintenance of their products catalogue.
The first main objective for this project was to automate, as much as possible, the process of importing, formatting, and updating content. With over 1300 SKUs and more than 600 clickable images, updated yearly, manual insertion was not a feasible option.
To fulfil this objective a pipeline of custom text processing macros were created to convert spreadsheet data into InDesign readable files. A set of personalised InDesign scripts were also developed to expand automation beyond the application stock capabilities.
The second main objective was to support the US and Canada markets. This consisted of having a US focused catalogue in English and with prices in US dollars. For Canada two catalogues would be needed, one in English and the other in French, both with prices in Canadian dollars.
To reach this objective it was crucial to tag the language and currency data of each SKU entry. Doing so allowed switching between, and exporting, the three catalogue variants with ease. Multiple techniques were used to automate this tagging process, and the text formatting, wherever possible.