This might be the wrong way to go about it, but here goes... I need an app that can do partial searches on SKU's in the backend (product admin area?)..
We have around 8.000 products with various SKU codes.
Sometimes because of human error (typos) or simply the manufacturer changing/updating part of the SKU code, I will only have part of the SKU to go by.
Shopify is terrible at searching partial SKU's, to such a degree that we are actively looking at moving our site. But we would lose a lot of functions that we love.
So if someone made / or know of an app, that can search partial SKU's and maybe edit in that app, we would jump on that app.
An example of our SKU’s would look like this: Ly75.T8.M188.8.131.52.OE
We want to be able to search 75.251.OE and still get a result. We currently don’t.
I have tried various apps, none worked for what we needed. So we're a little desperate
That would be amazing if you were able to make something that we could use.
So I've lost track of all of them. But here are some we've tried.
They are by no means bad products. They just can't do what we need.
Bulk Product Edit (Hextom)
Ablestar Bulk Product Editor
I've googlede it a few times, and it looks like we're not the only ones missing this feature.
I just need to be able to find a product with a partial SKU, and then edit it (usually to make it available or unavailable in the store).
Renars here from Matrixify (Excelify).
Seems like you already tried our app, but you sure can filter your export by partial SKUs.
When creating an export in the app, select to export Products and details you need under Products. Then click on the `Filters` button where you can select the `Variant SKU` filter.
Select condition `contains any of` and then in the text field enter your SKU fragments.
The app should export any Products that have Variants whose SKU contains any of the listed fragments you have, so you can filter by multiple fragments in the same export.
I hope that is what you are looking for.
If that is not exactly it please let us know so we can document this as feature request for future development
Thank you for responding to this.
My "problem" with Matrixify is that we have to export to do the editing and searching.
The webshop is part of a physical store that sells zippers, buttons and other sewing accessories. So the stock is being managed by very non-technical women. The stock is also updated almost daily. So it's simply too complicated at the moment to use Matrixify. Anything that is external/exported of Shopify (excel, spreadsheets, etc.) won't work in this particular case.
It's still not entirely what we need. The partial search on SKU works amazingly. But we can't edit the product when we find it in Report Toaster? As far as I can tell...
But it's better than anything else I've been able to find. So now we can actually search our product library, and at the very least see if the product exists in our catalogue.
And I worry that the people who are actually going to be using it, will find it a little complicated to use (as I mentioned, the store is being run by very non-tech people).
But for the time being, we'll use Report Toaster. So thank you for the tip.