This is the third time I have asked about this feature add, there is still no way to bulk edit Supplier SKU, Cost and Tax percentage information so it all can only be done by hand. Even using tools like Matrixifiy it cannot be updated. This is a poorly thought out feature for stores who existed before those fields were added and will prevent us from using Shopify for ordering. Even with the new PO version coming out which was sent in an email today, Sidekick may be able to make a PO, but without having that information in the file I cannot send that PO over to a supplier. We have thousands of SKUs which I would have to add all of that information over to the purchase orders for each field. Then if there is a price update not only do I have to change the price in the bulk inventory editor, I have to remember to go into the supplier and change it manually and individually at that level. It makes that use case entirely unreasonable. The last excuse I was given was that if you receive a product from multiple suppliers the cost price may be different, and even if that is true this is not the solution because with any changes I have to still change at an individual item level in an interface not designed for data entry.
You can always build a small private app for the features you feel are missing or if you need additional functionality. The Admin API covers almost everything, including cost per item, supplier SKU, and tax settings, so nothing is really out of reach.
Maybe? That outside of my daily duties for building something, and if the sidekick is to be believed, "Unfortunately, Matrixify does not support Purchase Orders as an importable/exportable entity — its supported entities are Products, Orders, Customers, Collections, Discounts, etc., but not Purchase Orders. So bulk-populating Supplier SKU via Matrixify isn’t possible either.
Here’s where that leaves you:
-
No bulk path currently exists — neither the Shopify GraphQL API nor Matrixify exposes the Supplier SKU field on purchase order line items for bulk editing.
-
Best workaround today: Export your product SKUs from Matrixify or the bulk editor into a spreadsheet, then use that as a reference while filling in POs — not ideal, but it’s the most structured approach available.
-
Feature requests worth submitting:
-
To Shopify: expose
supplierSkuon theinventoryItemGraphQL API so it can be bulk-written. -
To Matrixify: add Purchase Order entity support to their import/export schema."
-
This was the response I received when askign sidekick for solutions
Hey, Sounds like you’ve already done the homework on this and hit the same walls from every angle. The fact that neither the GraphQL API nor Matrixify expose that field for bulk editing is really the core issue.
I still think a private app is worth considering, not as a side project you build from scratch, but more as a focused script. Something that reads your product spreadsheet and writes the supplier SKU, cost, and tax fields where Shopify won’t let you do it in bulk. Tools like Claude or Codex can help you build that kind of thing in a few sessions, not months. And the best part is you stop depending on Shopify prioritizing this.
Good luck, hope you find a way forward
If there is no API to access Purchase Orders (and this is the reason why Matrixify does not have this functionality), how you suggest Clause or Codex would be able to perform the task?
Honest question - have you looked at other apps besides Matrixify? Specifically ones that fully support Suppliers, Purchase Orders, Product/Supplier related data like costs, SKUs, etc?
Of course, I wouldn’t be saying anything if I didn’t think FyreTrail can solve all of this for you (even the PO emailing). I mean there are some shortcomings that can be added (i.e. Tax % info) and there is better support for these attributes coming soon (within 1-2 weeks?).
That being said, as others have said, Shopify has not opened up the PO API so all apps will need to manage your PO data, but that’s better because it gives the flexibility stores like you need.
I have, and its unfortunate that we have to. We currently do all of our ordering through Inventory Planner. And its a great tool, but it means I have to build the orders twice, once in shopify, once in IP and that leaves gaps for human error. Now that Shopify has shut down Stocky they are adding some of those features into their Shopify backend, but they are not building it out well enough to actually use forcing those third party apps. With the new PO system on its way adding separations for linking POs with Transfers for designating where product goes into different warehouses this makes me want to use those tools, but I still have to input that information into multiple places. They took away a tool for the problem without having a solution and are not fixing problems which inhibit the use of their website, probably stemming from the fact that their developers do not run their own stores and use the product so they have no idea what the actual workflows look like, and the documentation on the workflows they think will happen do not reflect real world scenarios.
You have an amazing point that I emphasize all of the time - running your own store means you understand what stores are up against and can come up with REAL solutions. The app we’ve built is based on running our own store first.
Anyway, I’m stuck on something you said (that our store doesn’t even mess with) - why are you wanting to recreate the POs in Shopify? If you have that app and it allows you to order through it then what is the need to recreate them? Because - you’re right, until Shopify opens up that PO API it leaves things open for human error. You mentioned because it links them to transfers which allows you to designate where product goes into different warehouses, but does Inventory Planner not allow you to do that? Obviously I built that into FyreTrail so knowing where things are going (and where they’re at) is not even an issue.
Some of that comes down to overhead seat cost and some comes down to accountability and communication. Inventory planner is good to make the POs, send them to the suppliers, and do predictive ordering. However, it lacks communication with Shopify and between departments. In the shopify POs we have the full comments timeline where we can leave notes, write out order errors, make notes on backorders or link orders or other POs. That is where the communication between ordering and receiving can have a clear record. IP can push inventory recieve stock into Shopify but has no record to put issues down or extra notes. I believe IP will do the push into different warehouses and you have to link them to the different warehouses you have in Shopify. However right now the workflow does work in having IP hold the public facing side of a PO while on the internal side we can have mulitple Shopify POs linked to a single Public IP PO to combine Special Orders with Stocking Orders so that fulfillment can be fed out of multiple warehouses when changing it in an order. This is necessary because the majority of our suppliers have MOQs which special orders do not always meet and we have our online presence and a brick and mortar store. This can lead to issues of stock getting to the showfloor and being sold while it was supposed to go to a special order, or while an order is being allocated the product is sold in the front of the store at the same time. (I know that that timing seems tight but man it used to happen a lot).
Realistically, we are pushing the bounds of Shopify’s use. We run 2 online stores, 1 brick and mortar, 3 warehouses, and do Special orders on contracts which need to be kept separate for stock designation. We have both physical and digital SOPs to keep things straight and if we could have more digital integration of programs it would be that much easier.
Thank you for describing. You are very well likely pushing the limits. I’m curious about your unique usage though. You’re making all these features and apps work together and spending that extra time doing so. Is there a reason why you aren’t spending the extra money and going the more ERP route?
Well, OK, I’ll stop here. We’re pulling away from your original ask and my curiosity on what you do and how you do it is mostly because I want to support people like you in FyreTrail, but that doesn’t satisfy what you’re trying to get to. Would love to talk more though. If you’re open, look at FyreTrail and maybe we can get you a consolidated solution.
Well, if anyone cares other than the people advertising thier app, there is a solution and its coming if you like it or not.
The next update with Purchase orders and Transfers opens up the ability to Import to Purchase orders and Transfers. My store was one which was forcefully selected to beta test this new update, there are more things wrong with it than right but the silver lining is that you can import. You still cant export the purchase orders and transfers but its a step. I have been emailing daily with the support team trying to get the new update to be usable but it makes the recieving process so much more complicated if you do anything more than run a single in and out store.
Jumping in on this older post because I’m wondering if anyone has found a new tool or workaround since this thread. Any updates on apps or scripts that might now handle bulk edits for Supplier SKU, Cost, or Tax % on purchase orders? Would love to hear what others are doing to manage this more efficiently!
If you already use a secondary plug in then when you get hit with the new update you will have the ability to import directly into your Purchase Orders and you can slowly have it fill in that information as you are making orders over time. Or you can make one big fake order, include your entire library, but you will have to do that for each of you vendors. Its not great, considering we have 200+ vendors we deal with, but it beats going by the 10516 varients we have indivudially.
We do our ordering using Inventory Planner, so that database is being used to create the files to import into shopify. You could also use Matrixify or another exporter to create those files to then feed back into the purchase orders page. Its not great, Shopify doesnt care about usability, and their designers have never had to use the tools they create a single day in their life.
Did you look at FyreTrail for this? Supplier SKU is naturally in bulk edit mode with cost. The only drawback might be Tax % as this is not automatically applied (yet). That being said, if it’s important to you it’s important to me as the developer of FyreTrail.