0

I'm looking for an easier way to look at product images. Currently I individually search for them from a spreadsheet list. This feels tedious so I'm wondering if there is a way to automatically generate this list as main product images in a html file just. I'd just need to reference the website and the list of codes to crawl then.

Thanks for your help

J :)

I don't have any specific js hoping you have some cool idea here is a screenshot of the spreadsheet

NBrown-designer
  • 1
  • 2
  • 1
    How are you getting the products from that website? Is there an API which returns a JSON response? What have you tried, code-wise? If there's no remote API, you mentioned going through a spreadsheet and manually searching for what you need. What about saving that spreadsheet as a CSV file and [parsing it](https://stackoverflow.com/questions/27979002/convert-csv-data-into-json-format-using-javascript)? – FiddlingAway Jan 03 '23 at 13:43
  • Sounds complex. I was thinking it could just be done with HTML and javascript. Don't have any idea or experience with JSON or API – NBrown-designer Jan 03 '23 at 14:06
  • yes I want to read the products from the website. I have a list of the product codes – NBrown-designer Jan 03 '23 at 14:08
  • Can you post the structure of your spreadsheet (columns), and one row, as an example? You can edit your question, and just post it as an image. – FiddlingAway Jan 03 '23 at 14:21
  • Thanks posted above :) – NBrown-designer Jan 03 '23 at 16:37
  • If it's possible, can you also post the structure of the local HTML file? You don't have to post the entire contents, just the part where the products are mentioned. This is needed so that I (or any other SO user) can see how to get the product information from your HTML and to compare it with what you have in your spreadsheet. – FiddlingAway Jan 03 '23 at 19:18
  • I've made something for you to test in the meantime. Let me know if it works for you, and I'll post it as a complete answer, with additional explanations. The fiddle can be [found here](https://jsfiddle.net/xofqsnmL/1/). It assumes a certain structure for your local HTML file. The fiddle expects a CSV file (you can find the contents of it [here](https://pastebin.com/K9zj2xxx) - just copy / paste it into Notepad, and save it as a CSV). – FiddlingAway Jan 03 '23 at 21:00
  • Wow Thanks this looks amazing! I copied it to my desktop, but I've no idea how to generate the products or what to put in the body of the HTML file as I want the product images to auto generate? For example how do I pull specific products from this website? https://www.jdwilliams.co.uk/ – NBrown-designer Jan 06 '23 at 13:15
  • Unfortunately, I can not open that website - it seems that my country is blocked for some reason. – FiddlingAway Jan 07 '23 at 14:24

0 Answers0