Can you calculate bundle pricing in excel?

Asked 3 years ago

Hello everyone! WHo here uses excel for the Shopify store calculations? Is it possible to set up a spreadsheet with formulas in excel so that I can easily calculate new pricing bundles? Thanks!

Pricing strategy Product prices Excel calculations Bundle pricing

Mark Guthrie

Wednesday, February 23, 2022

Yes, you can calculate bundle pricing in Excel to offer different price packages for purchasing several products altogether. You can set up the columns of products, individual product cost, and the bundles you offer, e.g., Bundle1, Bundle2, etc. Then use the SUMPRODUCT formula to calculate the bundle pricing. You can also create a new spreadsheet with prefered formulae settings for seamless price bundling calculations.