What if Analysis for South African eCommerce Stores

You've listed a new bracelet range, set your prices, and opened your spreadsheet because one question won't leave you alone. If I lower the price a little, will I sell enough extra units to make up for it? If courier fees jump, will my margin disappear? If a payment issue hits on payday weekend, how much revenue could I lose?

That's where what if analysis helps. It gives you a safe place to test decisions before you make them in your real store. For South African online sellers, that matters more each year because online retail in South Africa expanded by about 35% in 2024 while offline retail grew by only 2.5%, which shows how quickly buyer behaviour is shifting online, according to the Online Retail in South Africa 2025 report draft. If you want to make better pricing and cost decisions, it also helps to get your business's financial GPS so your store choices connect back to a simple financial plan.

Table of Contents

• Introduction to What If Analysis
• Understanding What If Analysis
  • The five parts that matter
  • Why beginners get confused
• Comparing What If Analysis Methods
  • Side by side comparison
  • When each method makes sense
• How to Run What If Analysis in Spreadsheets
  • Build a simple store model first
  • Use Scenario Manager for named versions
  • Use Data Tables for quick ranges
  • Use Goal Seek for target outcomes
• Ecommerce Scenarios for South African Stores
  • Pricing changes for handmade products
  • Shipping and payment risk scenarios
  • Promotions and repeat sales
• Practical Templates and Common Mistakes
  • What if analysis template overview
  • Mistakes that trip up beginners
• Integrating What If Analysis into Shopstar Decisions
• Conclusion and Next Steps

Introduction to What If Analysis

A beginner usually starts with a guess. “This price feels right.” “This shipping fee seems fair.” “This discount should bring in more orders.” The trouble is that ecommerce has moving parts, and one small change can affect everything else.

What if analysis is the habit of testing those changes before you commit. You begin with your current numbers, or your best estimate if you're still launching, then you change one input or a few inputs and watch what happens to the result. For a small jewellery seller, that could mean changing price, packaging cost, delivery fee, or discount level.

Start with the question that keeps you stuck. Then build a small model around that question only.

It's not a South Africa-only method. It's a general business tool used in spreadsheets to compare possible outcomes so you can make calmer decisions.

Understanding What If Analysis

A good way to think about what if analysis is to imagine a recipe. Your final dish depends on the ingredients you put in. If you add more sugar, less butter, or a different flour, the result changes. A business model works the same way. Your result depends on the numbers you feed into it.

IBM describes what-if analysis as a universal financial modelling technique that starts with a baseline and often uses three scenario assumption sets to simulate business impact, using tools such as Excel's Scenario Manager and Data Tables in the process of analysis and comparison, as explained in IBM's guide to what-if analysis.

The five parts that matter

Most beginners understand this faster when it's broken into a short sequence:

1. Set your baseline
   This is your starting version. It includes your expected sales, product cost, delivery cost, fees, and profit.

2. Pick the variables
   These are the numbers you might change. Price is a common one. Shipping cost is another. Discount offers also belong here.

3. Change the inputs
   You test a different value. Then you test another one. You can do this one by one or in grouped scenarios.

4. Watch the outputs
   Outputs are the answers your sheet gives back, such as revenue, gross profit, or margin.

5. Read the result properly
   The goal isn't to find a magical answer. It's to see which input matters most and where your risk sits.

Why beginners get confused

Many new sellers mix up inputs and outputs. Here's the easy rule.

• Inputs are numbers you control or estimate, like price or courier cost.
• Outputs are numbers the sheet calculates, like profit.
• Baseline is your starting version before any changes.
• Scenario is one tested version of your business.

Practical rule: Don't change five things at once when you're learning. Change one or two first so you can see what caused the result.

If you treat your spreadsheet like a choose-your-own-path map, what if analysis becomes much less scary. Each path starts with a different decision. The spreadsheet shows where each path could lead.

Comparing What If Analysis Methods

Excel gives you a few built-in ways to test scenarios. You don't need to know all of them on day one, but you should know what each one is good at.

There aren't South Africa-specific invention dates for what if analysis. Its wider business adoption came through Excel's Data Tab, where tools such as Scenario Manager and Data Tables let people change inputs and observe outputs in a financial model, as outlined in this guide to what-if analysis in Excel.

Side by side comparison

Method	Best use	What it feels like	Limitation
Scenario Manager	Testing several combinations of inputs	Saving different versions of your store plan	Slower to learn at first
Data Tables	Seeing how one or two variables affect a result	Sweeping through a range quickly	Best for simpler comparisons
Goal Seek	Finding the input needed to reach a target	Working backwards from the answer	Only solves for one changing input at a time

When each method makes sense

Scenario Manager works well when your handmade skincare store has several moving parts at once. You might want one version for normal trading, one for holiday promos, and one for higher courier and packaging costs. Instead of rewriting values each time, you save these versions and switch between them.

Data Tables are useful when you want to test a range. If you're not sure what bracelet price to use, a data table can show how different price points affect profit. It's a practical next step after reading about price elasticity for ecommerce sellers, because it helps you turn that pricing idea into a model you can inspect.

Goal Seek is the simplest to explain. You tell Excel the result you want, then ask it to figure out the input needed to get there. If you want a certain profit margin, Goal Seek tries to find the price that gets you there.

For store owners who also want to connect these pricing tests to campaign planning, this guide on Implementing predictive marketing strategies is a useful follow-on read because it shows how forecast thinking can support marketing choices too.

If your question starts with “which version is better?”, use Scenario Manager. If it starts with “what happens across a range?”, use Data Tables. If it starts with “what must I charge to hit this target?”, use Goal Seek.

How to Run What If Analysis in Spreadsheets

A spreadsheet doesn't need to be fancy. It needs to be organised. If you're just starting, make one clean sheet with your key inputs at the top and your results below.

Build a simple store model first

Start with rows like these:

• Selling price
• Product cost
• Packaging cost
• Delivery cost
• Payment fee
• Expected orders
• Revenue
• Total cost
• Profit
• Margin

Put your assumptions in one area, then use formulas for the results. Keep input cells visually separate from formula cells. You can colour the input cells lightly so you know what can be changed.

If you already track performance in a dashboard, your historical order patterns and product trends can help you set a more realistic baseline. A useful place to review your current data is sales reports in Shopstar Insights.

Use Scenario Manager for named versions

Scenario Manager is useful when you want to save a few versions of your store plan.

1. Open Excel.
2. Click the Data tab.
3. Choose What-If Analysis.
4. Select Scenario Manager.
5. Click Add.
6. Name the scenario. Use plain names like “Base”, “High Shipping”, or “Promo Weekend”.
7. Select the cells that will change, such as price, delivery cost, and discount.
8. Enter the values for that scenario.
9. Save it, then repeat for your other versions.
10. Use Show to switch between them.

A beginner often forgets to use clear names. Don't call a scenario “Option 1” or “Test B”. Call it what it means.

Use Data Tables for quick ranges

Data Tables are easier when you want to compare a spread of values.

For a one-variable table:

1. Put a list of possible prices in one column.
2. Link the top corner of the table to your profit formula.
3. Highlight the full table range.
4. Go to Data, then What-If Analysis, then Data Table.
5. Set the column input cell to your price input cell.
6. Excel fills the table with the matching results.

For a two-variable table, place one set of values across the top row and another set down the first column. Then link the corner cell to the result formula and choose both row and column input cells.

Check before you run: If the results look strange, the problem is usually the selected range or the wrong input cell.

A short video can make the clicks easier to follow:

Use Goal Seek for target outcomes

Goal Seek is best when you know the result you want but not the input required.

Here's the logic:

• You have a formula cell for margin or profit.
• You tell Excel the target result.
• You choose one input cell to adjust, such as selling price.

The steps are short:

1. Click the result cell that contains your formula.
2. Open Data.
3. Click What-If Analysis.
4. Choose Goal Seek.
5. In Set cell, select your formula cell.
6. In To value, enter your target result.
7. In By changing cell, choose the input cell Excel should adjust.
8. Click OK.

If Goal Seek returns an odd answer, check whether your formula is correct first. Goal Seek only works with the logic you've built into the sheet.

Ecommerce Scenarios for South African Stores

The most useful what if analysis questions are local and practical. They come from daily selling problems, not textbook examples. For South African makers and small retailers, pricing, delivery, promotions, and payment reliability are usually the first pressure points.

Pricing changes for handmade products

Say you sell handmade earrings. Your first instinct might be to cut the price if sales feel slow. What if analysis helps you test that idea before you slash your margin.

Build one version with your current price. Then create a second version with a lower price and a third with a higher price. Watch not just revenue, but also profit per order. A cheaper product can bring more orders and still leave you with less money at the end if your costs stay stubbornly high.

This matters even more in a market that's growing quickly. South Africa's online retail turnover is projected to exceed R130 billion by the end of 2025 and capture nearly 10% of the total retail market, according to the Online Retail in South Africa 2025 report coverage. More online demand creates opportunity, but it also increases pricing pressure because shoppers can compare stores fast.

Shipping and payment risk scenarios

Shipping can steadily erode profit. A seller often sets one flat shipping fee, then discovers that some orders cost much more to deliver than expected. What if analysis lets you test low-cost, normal, and high-cost delivery cases so you can see which products can absorb that cost and which ones can't.

Payment reliability is another local risk that deserves its own scenario. Existing content rarely deals with this clearly, yet 34% of ecommerce transactions fail due to gateway issues in the South African context discussed by the World Bank document on digital payments and ecommerce barriers. For a small store, that means you should model a payment-failure scenario, not just a perfect-sales scenario.

A simple version might compare:

• Normal trading with expected orders and usual conversion
• Payment disruption where failed payments reduce completed sales
• Recovery plan where you follow up abandoned or failed orders quickly

If you want ideas for what happens after a failed sale or missed purchase, a strong next read is this customer win-back strategy playbook, because some lost orders can still be recovered later.

Promotions and repeat sales

Discounts feel exciting because they create movement. But they can also train buyers to wait for specials. That's why your model should compare promo scenarios against non-promo weeks.

Useful questions include:

• Discount impact. Does a sale still protect your margin after fees and shipping?
• Bundle offers. Does bundling increase average order value enough to justify the offer?
• Cash timing. Can you still pay suppliers if the promo lowers profit per order?

If you're trying to keep these decisions healthy over time, it helps to pair your scenario work with cash flow management for ecommerce, because a profitable-looking promo can still strain your business if cash timing is poor.

A good ecommerce model doesn't ask only “Will this sell?” It also asks “Will this still work after costs, delays, and failed payments?”

Practical Templates and Common Mistakes

Beginners do better with templates than with blank sheets. A template reduces decision fatigue and helps you focus on the question instead of the layout.

What if analysis template overview

Template Name	Purpose	Key Features
Pricing test template	Compare different selling prices	Baseline price area, alternative price inputs, profit output
Margin calculator	See how costs affect profit	Separate input cells for product, packaging, delivery, and fees
Shipping scenario template	Test delivery cost changes	Normal, high-cost, and custom shipping cases
Promotion planner	Compare promo and non-promo periods	Discount input, order estimate, final profit comparison
Payment failure model	Test sales loss under failed payment conditions	Baseline sales view, disrupted sales version, recovery notes

Mistakes that trip up beginners

The first common mistake is changing the wrong cell. If you type over a formula cell instead of an input cell, the whole model can break.

The second is poor labelling. If you don't name your scenarios clearly, you won't remember which version was meant to represent what. Keep names plain and obvious.

A few more are worth checking every time:

• Mixed assumptions. Don't compare one version that includes free shipping with another version that also changes price, unless that's intentional.
• Broken references. If a formula points to the wrong cell, your output won't mean much.
• Too much complexity. Start small. One product line is enough for your first model.
• No notes. Add short notes beside your assumptions so future-you knows what you were thinking.

Small models are easier to trust than complicated models you don't understand.

Integrating What If Analysis into Shopstar Decisions

A spreadsheet only helps if you use it to make real choices. Once you've tested your scenarios, move the useful outputs into a simple decision routine. Keep a short list of the inputs you tested, the outputs you watched, and the action you plan to take.

South African Treasury guidelines say analytics tools should clearly define inputs, outputs, and performance measures, so decisions are based on validated results rather than guesswork, as explained in the Treasury guidance on technical specifications and performance measures. That's a useful rule even for a small online shop.

A practical workflow looks like this:

• Review weekly. Check one key scenario each week.
• Set a trigger. If margin drops below your comfort level, pause and retest.
• Keep evidence. Save your assumptions and final outputs.
• Link decisions. Match scenario results to pricing, stock, and promotion plans.

Conclusion and Next Steps

What if analysis helps you stop guessing. You test a price before changing it. You model shipping pressure before it eats your profit. You check promo ideas before they become expensive mistakes.

Start small. Build one baseline sheet. Test one scenario this week. Then save your assumptions so you can improve the model as your store grows. The more often you use it, the more natural it becomes. A calm, simple spreadsheet can save you from rushed decisions.

---

If you're ready to turn your ideas into a real online store, Shopstar gives South African makers a simple way to start selling with local payments, shipping, inventory tools, and an easy dashboard that doesn't feel overwhelming when you're just getting started.