Find/Change in InDesign depending on xls or csv content

[helsvensk]

Hi,

I've got some problem to be solved :

There's an existing InDesign Document (Catalogue) with more than 300 Pages and an xls file with >1600 Article Numbers in one column and Prices in the other.

So, is there any way to automatically search in the indd for an article number from the xls and then, if found, change or replace the price in the indd with the one from the xls?

Thx in advance

[Loic.Aigon]

Yes you can. In so many ways actually but one would be to export Excel to CSV, then given column 1 is ref, column 2 is price and the CSV hosts data like

|     sku     |     price          |

------------------------------

145253     |     19,99$     |

------------------------------

Then you would parse the CSV line by line, use GREP or TEXT Find/Replace to change prices.

Loic

[Loic.Aigon]

Actually my answer was not totally effective and I think Uwe ´ s answer is more precise. Indeed you would need to have a connection between sku and price.

[FRIdNGE]

Hi,

I second Loïc of course! … but I would be curious to see the layout because you need to have a kind of link between the product sku and its price!

Thanks for a screenshot!

Best,

Michel, from FRIdNGE

[Laubender]

https://forums.adobe.com/people/Michel+%5BFRIdNGE%5D  wrote

…because you need to have a kind of link between the product sku and its price!

Hi Michel,

yes, there should be a unique relationship between sku number and price tag.

Some formatting maybe. A paragraph style that is only used for this perhaps…

Regards,
Uwe

[Kasyan Servetsky]

If you are on Windows, check out the Version with find-change list taken directly from the Excel (XLSX-file) script the at top of this page which should be run as a secondary script from the Batch processor.

It looks quite close to what you need.

—Kas

[bartolomic]

Can you please explain it oce  again? Have exactly same problem to solve and look for some tipps, but cannot find anything, which would work.... 

[Stefan Rakete]

Hi helsvensk,

for this kind of problem you should keep track of:

1. the article numbers in the document that are not in the Excel file.

2. The article numbers in the Excel files that are missing in the document

Thanks Stefan

[Dave Creamer of IDEAS]

Have you thought of using a third-party plugin? Some can provide live links to an actual database rather than an Excel file (although they can do that too). Some can automate image insertion too. 

These include Em Software InCatalog, 65bit Easy Catalog, and Teacup Software Datalinker.