Skip to main content
Participant
February 10, 2025
Question

How to import prices from csv to indesign catalog?

  • February 10, 2025
  • 1 reply
  • 566 views

Hello, I have no experience to skript. However, my problem is: I have designed a catalog for a client. In the past it contained no prices, only the product descriptions, names, pictures etc.

The client used to add a separate price list (.xls) to the catalogue, so that he didn´t have to print the whole catalog new, when prices changed.

However, now he does want to reprint the catalog with the included prices (we are talking about several hundret prices, the catalog has 72 pages ... ).

Question is, whether I can somehow add fields (manually) to the existing indesign Document, that will tell InDesign to automatically grab the price for the specific product-ID I want from the CSV pricelist?

So that, when the pricelist changes next year (with prices in a different order, due to deletion of old products and newly added products), it will still find the right price via the product-ID?

 

Is there any easy way to do this? Neither Adobe Help nor ChatGPT give me an answer on this one ... 

Thank you so much! Holger

1 reply

Mike Witherell
Community Expert
Community Expert
February 10, 2025
Participant
February 10, 2025

Thank you for the speedy answer! However – I have already gone through data-merge, and it doesn´t semm to help me, because it is good for creating mailing labels etc. What I need is a way to find that specific price for a specific product ID within the CSV. I suppose I need some sort of skript that will read the CSV, find the desired product-ID and import the price from that row.

Robert at ID-Tasker
Legend
February 10, 2025

@holger_0552 

 

Can you post a screenshot - with edges visible and hidden characters visible as well.

 

If your current INDD file is somehow "organised" - then I have a tool that can do this.

 

Isn't free - and Windows only - but I can give you access to the full version for a few days and of course guide you what to do.