*_This maybe can be done with some crafty use of saved searches I'm not aware of, but I'm thinking combining search results into a CSV via script may be easier, and the final result will be sent via SFTP, same script could combine results easy enough I assume_ For a bit of context we are an apparel manufacturer and wholesaler, our 3rd party B2B platform struggles with the concept of products that 'rollover'/'carry forward' through ranges/seasons. Our items have a multi-select field for seasons, so in a search column you may have singular like "FW20" or multiple like "FW20,SS21" etc. In order to 'trick' the B2B platform we can create duplicate items where season is included in the unique identifier, eg some-sku-fw20, some-sku-ss21 Producing a saved search/csv for each season is obviously easy by filtering to a given season and appending it to the item sku in results. But we need a single csv file to feed to the B2B on a schedule. So question is either: is there a way to "unpivot"/repeat item search lines per value from a multi-select OR how would you go about achieving same in SS2.0? (Not expecting huge detail but modules would use / broad approach be great) 🙂

there probably isnt something simple by the saved search alone unless you are willing to create a custom join through something like parent/child records

All very appreciated @battk 🙂