Hi Zenners,
This is driving me slightly nuts: I am preparing a spreadsheet for a mass upload of products. The information sources are a pricelist based on an excel spreadsheet (super easy to modify for a mass upload) and a product catalog based on a PDF.
The only iniformation I need to extract from the PDF is the product description. The descriptions are generally a paragraph of text and a feature list.
I am having serious difficulty scraping the product info in to the spreadsheet in a way that doesn't lose it's formating and look terrible once it is in. I'm not seeking to preserve font styling or colors, just the spacing and bullets.
I'm finding that, for the projects I have completed so far, most suppliers seem to use PDF as a means of digitally distributing their product catalogs. This is a terrible digital format for interchange of information. I'm hoping there may be other Zenners who have had a similar exerience who may be able to shed some light on how to manage this?
If I have to go in to every product in Zen Cart to correct the formating of the description text, it kinda defeats the object of having a mass upload in the first place.
Any ideas welcomed!
Regards,
Ked
Bookmarks