Datamerge scripts to generate a product category on the same page

Question

Hello everyone,

I need to generate a price list containing thousands of references each week. I would like to automate the process with an InDesign script. My current challenge is to generate a list of products for the same category in single record template and to start a new page for the next category. Ideally, I would like to have the category name at the top of each page. Is there a script available for this or another way to proceed?

Here is an example on how my excel looks like:

PAGE CAT	CODE ITEM	DESCRIPTION	MOQ	UNIT	PRICE
HERBS	XITAV100	CHILLED ITA ESCAROLE SALAD - insalata scarola 3.5kg/CASE		KG	108
HERBS	XITAV099	CHILLED ITA ENDIVE SALAD 3-3.5KG/CASE		KG	120
LETTUCE	XITAV102	CHILLED ITA RED/GREEN GENTILINA SALAD 2KG/CASE		KG	100

Thank you for your help

Mike Witherell · Accepted Answer

Hi Melody,Datamerge can only merge a linear spreadsheet, one entry after the other. It does not have the ability to make/sort categorizations. But if you make separate .csv spreadsheets per category, you can work sequentially thru your categories. If you have many categories, tho, this semi-manual approach will take more time. There are a number of 3rd-party plugin softwares to expand what DataMerge can do, for example:https://emsoftware.com/products/incatalog/

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded