Anyone using a spreadsheet as the source of truth for what they need to buy?

I have a buying list in Google Sheets with the products/MPNs I’m looking for, how many I need, max price, condition, etc. It changes pretty regularly, so the sheet has basically become my source of truth. The annoying part is actually sourcing from it. I’m still taking what’s in the sheet and manually updating searches on ebay and a couple other places whenever something changes. For anyone managing a decent number of products, do you keep the buying list separate like this or have you found a way to have your searches work off the same data?