I have a user table with a record of
images containing a list of user-uploaded images.
I then have a product table with a record of
sku, and (a list of)
images that’s compiled from a list of imported data from an external API.
My user images are named as the same as the SKU of the individual products.
I want to match these images to their respective SKUs.
001.png should match with SKU001.
002.png should match with SKU002.
2135_5.png should match with SKU2135_5.
So on and so forth!
I have tried to modify the products:last item, where the product constraint is tied to the user, using: add images = do a search for user’s image’s filename:filtered, where filtered is set to the following:
However, contains results in a yes/no.
Instead I need it to select the actual file and upload that file.
ie, if the file contains the product’s SKU: upload 001.png!
not, if the file contains the product’s SKU: yes
What would be the best way to get this going? Thanks!