I’m trying to set up an automation that scans a local xlsx file containing product information, parses the data and then creates new products/updates existing products according to the changes in WooCommerce.
I’m extracting a string from a spreadsheet cell which is delimited by a command a space. They’re relative URLs to images for WooCommerce products. I’ve been able to convert this single string into an array using JS split which has returned multiple values which I can then map in the WooCommerce node.
However, is there a way to set the number of images to be imported by the WooCommerce node by how many values are in the array? Is it also possible to assign each value in the array to the next incremental number?
On the last node you’ll see that I’ve manually added images and assigned each value from the array. This strikes me as poor practice as oftentimes I will have more or fewer images, so this (in my eyes) should dynamically adjust according to the number of values.
- n8n version: 0.175.1
- Database you’re using (default: SQLite): default
- Running n8n with the execution process [own(default), main]:
- Running n8n via [Docker, npm, n8n.cloud, desktop app]: Docker