What does "will not work properly" mean, exactly? How many products on a page?
There are a number of catalog plugins which might work (I've never used any of them), but they are not inexpensive...
When I add the prices to the page, all of the price fields on page 1 populate with the price from the first cell, The second page with the second cell, etc.
The pages have varriyng numbers of items, from 4-8 per page.
I have the data merge set for multiple record layout, but no success.
Multiple records per page only works with single-page templates. If you had a consistent number of prices on each page you could combine them into multiple fields in a single record, but you have a variable number, so Data Merge probably is not going to work for you here.
Is it possible to place a text file? That would mean the prices would need to be in separate frames that could be threaded together, rather than bing directly in the main text flow.
That's not going to work, but thank you for the information. You mentioned in your first reply that their are a number of plugins which may work. I don't mind paying for the right one. Can you point me in the direction of where to look? When I do a Google search it returns many results and I would like to find a reputable supplier for plugins.
The top 3 I see mentioned are Easy Catalog from 65bit software, InCatalog from Em Software, and Smart Catalog from Woodwing.