Skip to main content

From Outdated PDF to Live Product Record

Most building products manufacturers already generate cut sheets from product data. The problem is that the PDF is a snapshot. Once anything changes a finish, dimension, image, or certification), the file on the website is wrong until someone updates it by hand. Automated cut sheet generation means the PDF rebuilds itself from the golden product record, so nobody has to keep it up to date by hand.

I've talked with many customers and prospects in the building products industry. Some of the most interesting conversations started with a question about cut sheets. Here are real-world examples of the problems people in plumbing fixtures, brick manufacturing, HVAC, lumber, and hardware distribution have raised.

What a cut sheet is, and why yours is out of date

A cut sheet is a single-product PDF carrying the details a contractor, dealer, or architect needs:

  • Dimensions
  • Materials
  • Performance ratings
  • Certifications
  • Installation notes
  • Product image

Depending on who is asking, this might be a spec sheet, a tech sheet, a sell sheet, or a product data sheet. Yours is out of date because it was generated once from a product record that has since changed, and no one has re-run it.

A marketing lead at a plumbing fixtures manufacturer described the situation during an evaluation call. They have something automated, except that it isn't: it builds the spec sheet into the PDF, but it doesn't update in real time. Her word for the arrangement was "improvised."

The same tool served as their product information management system, fed their website, and exported a price book running to several hundred pages. It also omitted fields and reverted to superseded values, so when they pulled data out, they couldn't be confident it held everything they had put in. Every downstream document inherited that uncertainty.

This is typical of the conversations we have with building products distributors and manufacturers. Most of them already have a template. The sheet is wrong because the template ran once, on data nobody fully trusts.

The bottleneck is keeping the cut sheet up to date. Producing the first cut sheet is rarely where teams get stuck. The effort is all of the revisions (sometimes hundreds), and that work usually lands on one person who is already stretched thin rather than showing up in a budget line.

At a brick and tile manufacturer, the marketing specialist watching a sheet generate live in a demo said plainly that she does a lot of that work by hand. That is the honest baseline across several of these teams: a designer or catalog coordinator who rebuilds every sheet by hand, and whose to-do list sets the real publishing schedule.

At a B2B hardware distributor with roughly 130,000 SKUs, the constraint is organizational. Product managers and field agents enter supplier product data into an older back-end system. Marketing then pulls it from that system, reworks it, and rebuilds the sales sheet. The marketing lead described himself as sitting at "the complete end of the line," dependent on the web team and the product information system to change anything at the source. He could not fix the data going in, only rebuild the sheet coming out.

For any web-to-print setup, meaning any system that builds documents from live product data rather than from a design file, the test is not whether it can produce this document. The test is: when a product detail changes, what updates, and does anyone have to remember to start it?

Missing content gets discovered when you build the sheet, which is too late

The second problem creeps up on many companies. A gap in the product data doesn't make any noise when someone enters the record. You only find it when you sit down to build the sheet, and the piece you need is just missing.

The hardware distributor's marketing lead described exactly this: he goes to build a sales sheet, checks what has been imported into the information system, and finds the application photo missing. The sheet is blocked, the person who could supply the image is elsewhere, and the deadline is today. Compare that with an HVAC distributor looking at the same problem from the other end. Ahead of their demo, they asked for a report on products needing technical drawings. Same gap, but weeks earlier, in a work queue instead of at a deadline.

That difference is worth more than any template feature. If the product record defines which documents and images each product requires, you can report on data completeness and answer questions like:

  • Which products lack a technical drawing?
  • Which lack an installation guide?
  • Which have an image but no rated performance data?

A sheet is only as easy to update in bulk as the data model it relies on

Most web-to-print projects stall after the first template, and the reason is usually the data model rather than the design. Generating a category of sheets in one run is straightforward. Keeping those sheets up to date is the hard part. When a finish is discontinued, or a price goes up, you want to make that change once so it shows up on every product it touches, not update a hundred products one at a time and then rebuild each cut sheet by hand.

Building materials & supplies product data models make this especially hard because products come in so many variants. At the plumbing fixtures manufacturer, every product carries one of a few dozen finishes, and those finishes fall into price groups. The systems integrator running their evaluation asked the question that actually mattered: how do we apply a percentage increase across a whole price group? Their SKUs are built by stringing codes together, with the leading digits representing the spout style, the handle style, the flow rate, then the finish. A few thousand parent products become well over 100,000 sellable SKUs.

At a shower systems manufacturer, one pan in one size fans out across drain positions, then multiplies again when drain covers are added. Their own phrase for the result was a matrix.

The order of the work matters. First, organize your product data so that finishes, sizes, and options are set up once and shared across the products that use them. Next, make sure your team can change a price or a finish across an entire group of products in one go. Only then automate the cut sheets. Do it the other way around, and you end up with a nice-looking template and someone still updating products one at a time.

Two kinds of documents, two sets of tools

Building products companies produce two kinds of printed documents, each requiring different tooling. The first kind is templated: cut sheets, spec sheets, installation guides, and warranty cards, where a designer builds the layout once and never has to touch it again. The second is designed: the several-hundred-page price book, the dealer catalog, and the piece an architect will judge on how it looks, where a designer will want to adjust the layout by hand and should be able to.

Buyers rarely name this split. They come at it by asking about tools. A flooring manufacturer's project lead, mid-evaluation, asked whether updating PDFs required additional plugins or software. A global electrical protection manufacturer asked whether, since they build datasheets in Adobe InDesign, there was a way to connect InDesign to the PIM.

The accurate answer has two halves. Pimcore's Web to Print module handles templated documents like cut sheets without separate print software. It generates print documents from product data and turns them into PDFs, including multi-page catalogs with chapters, subchapters, and a table of contents. Designed documents built in InDesign take a different route: they run through an InDesign connector, which lays out pages using a set of rules, so your existing templates need some rework. Worth knowing before you plan the project, because the cost and the workflow both differ. If the designed catalog is the bigger prize, print automation covers that path in more detail.

Who actually uses the sheet

Distribution changes what the template has to do, because the person using the sheet is usually not the person who published it. A branch rep, a distributor, and an architect or engineer each want a different version of the same document, and that has to come from one template, not a folder of copies.

An HVAC distributor asked whether a generated sheet could list only the branches holding stock, which turns a generic document into a locally useful one. A brick manufacturer wanted its internal sales team to pull up a product in a portal and email it straight to a customer. A third idea worth copying: the moment someone signs off on a product change, the sheet rebuilds itself and the version on your website updates with it, so nobody has to remember to do it. These are experience portal ideas more than print ideas, and they only work when the sheet pulls from your current product information rather than a copy someone saved months ago.

There's a closely related problem worth mentioning. A power tool manufacturer I spoke with keeps roughly a hundred distributor templates in Excel, each set up differently and changing often. Filling them in means loading data into the PIM, exporting it, and emailing every file back in that distributor's format. It's really the same job as the cut sheet: one set of product information, shaped a hundred different ways, for a hundred different customers. The fix is the same too. Pimcore's Data Hub sends each distributor their product information in the format they ask for, automatically, so nobody has to do a hundred exports by hand.

FAQ

Can cut sheets be generated in bulk for an entire category?

Yes. You assign templates per category, and they pull from the product record, so you can generate a whole category in one run rather than product by product. Generation can also be triggered by events, such as content approval or an image change, so files refresh without anyone remembering to rebuild them.

Do we need extra software to generate spec sheets from our product data?

For templated documents such as cut sheets, tech sheets, and straightforward catalogs, you don't need separate print software. Pimcore's Web to Print module turns them into PDFs from the product record. Heavily designed marketing pieces built in Adobe InDesign take a separate path, using a Pimcore/Adobe connector available in the Pimcore Extensions Store.

Can a generated sheet show only the locations that stock the product?

Yes. As long as Pimcore can access your branch or regional availability data, wherever it lives today, the sheet can use it. If you don't have a good place for that data yet, you can store it in Pimcore. The template decides which relationships and attributes to show, so a sheet can show stocking branches, regional pricing, or a local contact block while you keep one golden record for each product.

Can we keep our existing InDesign catalog templates?

Layout work stays in InDesign and designers keep manual control of the page. Templates are adapted to the connector's rule set rather than dropped in unchanged, so budget for that rework when you scope the project. This path suits the price book and the dealer catalog, where a designer wants a hand in every page. It is usually the wrong tool for per-SKU cut sheets. You want those as automated as possible, so they rebuild on their own whenever the product data changes, without waiting for a designer to open a file.

How do we update a price across a whole group of products?

Through batch editing on the product records in Pimcore, not on the PDF documents. Say your prices are set by finish, with brushed nickel and matte black in a higher price group than chrome. When the brushed nickel and matte black price group goes up 5%, you change it once, and every product in those finishes picks up the new price. The cut sheets then rebuild from the updated data.

See how this works on your own catalog

The fastest way to know whether this holds for your product data is to see your own SKUs turned into cut sheets. Book a demo, bring a sample of your catalog, and we will show you your cut sheets generated from live data.

Coming Next

Get a demo fitting your requirements

Book a free guided tour with an expert, or explore on your own.
Try Pimcore Yourself
Receive direct access to a demo with pre-filled data across various modules.

We will use your personal data solely to process your request. For a better localized experience, we might share your data with certified solution partners in your geographical region. For more information, please read our privacy policy.

Back
Back