Is maintaining a detailed product cost spreadsheet beneficial?

Shopify Discussion
1

Hi there

I had created a spreadsheet previously that listed: Product Name, SKU, Supplier, product cost, shipping cost, shipping method, Total cost, sell price, profit, and compare at price. Is this something anyone else does? Am I creating more work for myself, because it has to be updated every time there is a price change. Or does anyone download a CSV file for the same purpose?? Any help is appreciated. Thanx

Laurie

2

Hi @Laurie_Collins this seems a bit of a XY problem

What is the goal with this question.

WHY are you doing this., that isn’t served by just downloading the product CSV via the export/import.

Is this an external supplier price change, etc etc.

If it’s a bunch of changes are you using excel formulas to speed things along before the import.

Does the supplier have an api to aid automation.

etc etc

3

Hi @Laurie_Collins !

If you are open to use a third party app, I might have a great solution for your problem! Our App DataChamp allows you to easily export the data you have listed in your spreadsheet. Once your reports are set up, you can run them automatically, so you do not have to update them by yourself!

You can download your reports as a CSV File, Excel, Spreadsheet and many more. If you would require any help with the set up of the app, just contact us!

Hopefully we could help you with your concern!