Donnelly’s – CatalogStudio

donnellysClothing Company Creates Custom Catalogs With Print Catalog Software from Questudio In Just A Few Clicks

One-on-one marketing is the next best thing to personal interaction with a customer. Wouldn’t you like to receive a catalog that contained just the things you need? Even amidst a busy marketing season, CatalogStudio makes this possible.

School uniform time is one busy season for parents, children, and last but not the least uniform manufacturers/designers. Donnelly’s Clothing, one of the pioneers in school uniforms in Rhode Island, caters to the needs of hundreds of schools in the United States for their uniform supplies. During the uniform season, they send out custom catalogs to their target audience throughout the country.

Donnelly’s contacted Questudio looking for an efficient way to customize catalogs. They wanted a system where they would be able to select a school from the database and within a couple of clicks be able to generate a mini catalog containing all the uniform details for boys and girls in K-12 grade. This includes the details of summer and winter uniforms, their images, prices, school logos etc.

Making Mini Catalogs Is A Simple Two-Step Process:

With CatalogStudio’s built-in PDF generator, creating aesthetically appealing mini catalogs is as easy as the snap of a finger. Once you have a master template designed and saved in the template gallery, users can select the desired products using the PDF wizard, choose the appropriate template, and in a couple of clicks have a mini catalog pop up on the screen which can be shared, collaborated, emailed, thereby playing the role of a marketing tool.

Questudio’s Catalog Experts designed a PDF template for Donnelly’s that you would be able to bind all the data from CatalogStudio and have it flow into a report which would come out in a format as desired by the company’s marketing team. The PDF is a sample catalog showing how all the data from ERP has been binded and flown into an easily readable marketing document.

Donnelly’s store their data in an ERP system which when exported does not come out in an easy-to-read flat format but rather in a CSV format. Nine interlinked CSV files would be exported from the system in a data extract. The name of schools would be coded in one of the CSV files and the actual names would be mapped on another CSV file. This applied to prices, images, and descriptions. They also had codes to mention whether the prices belong to the current uniform season or the new uniform season. This was quite challenging and in order to map the codes with the related fields, complex stored procedures had to be written and it went through an exhaustive round of testing.

One of the requirements from Donnelly’s was that they should be able to clear out all the data from the database any time a fresh import was done and only retain the data from the latest import, as prices are constantly changing. This was done in minutes by the database experts at Questudio.

At the end of the project, it was a job well done for Questudio and a step ahead for the Marketing team at Donnelly’s Clothing.