Warehouse_products - search for any sku that contains a certain phrase

Hi there!

I was just curious if there’s any way to search for items in a warehouse that have a specific string in their sku.

I was planning on using the warehouse_products query and filter by sku, but I can’t seem to find how to filter for a partial match, or searching for skus that contain a certain string.

I’m just trying to find anything that ends in a certain set of letters.

For example, if I have 3 skus: 12452-dogtoy-abc, 65235-phone, and 73452-cattoy-abc, I’d like to know if there’s something I can search to return both 12452-dogtoy-abc and 73452-cattoy-abc.

Thanks!

Hello @aadam!

I appreciate your patience.

I’m looking into this, checking if there’s a native way to apply a wildcard to any query. In case I can’t find one, we can always post a feature request to add it.

Have a nice day!
Tomas

1 Like

Hello @aadam!
Unfortunately, at the moment, we do not support the use of wildcards for filtering queries. However, I can create a feature request on your behalf.
Have a nice day!
TomasFD

Thanks for the update.

If you could create a feature request, that’d be greatly appreciated!

2 Likes