We're looking for a way to have the retail price automatically created based on the COGS of the product. I found a lot of apps that provide profitability analyses but they are strickly reporting apps and have no function to create pricing from those costs.
We'd like to be able to do the following:
Anybody seen an app that does that?
thanks for sharing, this makes sense. a few questions:
feel free to email me your answers, if you prefer not to post here publicly.
If you can compile those prices with formulas on the Excel file, then you can use this tutorial to just import and update the Price field by SKU: https://excelify.io/2018/02/12/update-shopify-product-by-sku/
Oh, and if you need to import that according to a certain schedule, here's how you do that: https://excelify.io/2018/03/22/schedule-shopify-product-price-update/
This can be easily done with Airtable - you can set prices in bulk to a specific number, or use a formula to set based on a percent increase/decrease or any other logic you want (e.g., take cost and mark up 30%). Check out our overview of how to bulk change Shopify product prices with Airtable