Why You Shouldn't Use Spreadsheets As A Product Database

[@jorxcore]

Very relevant, glad for the yt recommendation.

[@SolAngelucci]

more sheets more problems, couldn't agree more!

[@bryang1]

I dont disagree with your position fundamentally but many of the arguments you use to make your point arent completely true. For example, when saying that you would need mutiple sheets or workbooks of data to store mutiple versions of your data, implying that you would have to maintain all these sheets / workbooks separately isn't exactly true. If you are using excel you could very easily create a single table which is the "single source of truth" and use power query to read from that table data, transform it to the required output necessary for whatever system it needs to go to and then output it to a different sheet or workbook. This implementation would only require a single button click to refresh all the "other" sheets/workbooks and therefore you only have to maintain the original Table of data. Another example you use is when you said spreadsheets cannot export data in a different format that is required for other systems (ie shopify, amazon, etc..), which is also not completely true. If using google sheets you could, similarly to the power query implementation above, have a single table in your workbook with all your products and use google scripts to not only format the data but also send it to a systems REST api, using urlFetchApp for example.