FREE E-COMMERCE PLANNING LEARNING PATH

WikiFree original practice workbook

The storefront lab

CASE STATUS: fictional/synthetic teaching material. Do not present the example as real research, employment experience or measured business performance.

OUTCOME
Create a small e-commerce concept, product page, checkout test plan and unit-economics worksheet with a measurable pilot decision.

BEFORE YOU START
Arithmetic and basic writing. A spreadsheet or paper; no store subscription or payment account.

CASE
The fictional Maple Craft Shop considers a starter craft kit. Price is 30 units, product cost 12, packaging 2, payment/fulfillment allowance 3 and shipping subsidy 4 per order. A pilot has fixed setup cost 90. All amounts are synthetic, not current platform prices.

INPUTS
Item,Units per order
Selling price,30
Product cost,12
Packaging,2
Payment and fulfillment allowance,3
Shipping subsidy,4


ENTRY CHECK

Question: Is revenue the same as contribution?

Self-check: No. Subtract defined variable costs.

Question: Does an attractive page prove demand?

Self-check: No.

Question: What makes a pilot measurable?

Self-check: A stated hypothesis, limit and success/stop criteria.

STAGE 1: Define the customer and offer

Prerequisite: Arithmetic and basic writing. A spreadsheet or paper; no store subscription or payment account.

Instruction: Choose one customer situation and the problem the product addresses. State the kit contents, intended use and exclusions. Treat demand as a hypothesis until evidence exists. A small e-commerce plan becomes easier to test when it avoids a broad catalog and focuses on a specific, clearly described offer.

Practice task: Write the target situation, offer promise and five assumptions requiring evidence.

Deliverable: A customer and offer brief.

Acceptance check: The offer names a concrete kit and does not use invented testimonials or demand figures.

If stuck: Replace everyone interested in crafts with a defined use situation.

Record your work, decisions and evidence:




Record your result against the acceptance check:



STAGE 2: Calculate the order contribution

Prerequisite: Bring your previous output: A customer and offer brief.

Instruction: Unit contribution equals selling price minus the defined variable costs. Here costs total 21 and contribution is 9 per order. Covering fixed pilot setup cost of 90 requires ten such orders before any unmodeled costs. This is a simplified contribution calculation, not net profit or a forecast of actual sales.

Practice task: Build the worksheet and test shipping subsidy rising from 4 to 7. State which costs are still excluded.

Deliverable: A unit-economics and sensitivity worksheet.

Acceptance check: Baseline contribution is 9 and simplified break-even is 10 orders; higher shipping makes contribution 6 and break-even 15.

If stuck: Do not call contribution net profit or omit the assumptions behind break-even.

Record your work, decisions and evidence:




Record your result against the acceptance check:



STAGE 3: Draft the product and checkout journey

Prerequisite: Bring your previous output: A unit-economics and sensitivity worksheet.

Instruction: A product page should explain what arrives, suitability, price assumptions, delivery expectations and the next step. A checkout plan needs clear totals and recoverable errors. This exercise uses a mockup and test cases, not a live payment flow. Do not collect payment details or promise operational policies that have not been decided.

Practice task: Draft a product page and sketch a three-step checkout with a review-total screen and an invalid-address recovery state.

Deliverable: A product page draft and checkout storyboard.

Acceptance check: The order total is visible before the final action and errors have a recovery route.

If stuck: Avoid hidden charges in the mockup; label unresolved shipping or policy decisions.

Record your work, decisions and evidence:




Record your result against the acceptance check:



STAGE 4: Plan fulfillment and customer communication

Prerequisite: Bring your previous output: A product page draft and checkout storyboard.

Instruction: The promise continues after checkout. Map picking, packing, dispatch and the customer update, with owners and exception handling. A stock shortage should trigger a truthful response rather than a false dispatch confirmation. Return and cancellation policies need appropriate real-world review before launch; the learning artifact can identify those decisions without inventing legal terms.

Practice task: Create an order workflow and two exception messages for delayed dispatch and unavailable stock.

Deliverable: A fulfillment and exception plan.

Acceptance check: Every order state has an owner and messages match the actual state.

If stuck: Do not label an order shipped when only its packing task is complete.

Record your work, decisions and evidence:




Record your result against the acceptance check:



STAGE 5: Design a small launch experiment

Prerequisite: Bring your previous output: A fulfillment and exception plan.

Instruction: A pilot needs a hypothesis, limited audience, resource limit and evidence that could change the decision. Separate demand indicators from paid completed orders and record cancellations. Set a spending cap in the plan without actually purchasing ads. Choose a next action based on both demand and contribution rather than a single traffic number.

Practice task: Write a two-week pilot plan with a hypothetical cost cap, tracked events and stop/continue criteria.

Deliverable: A bounded e-commerce pilot decision brief.

Acceptance check: The criteria connect completed orders and contribution to the stated assumptions.

If stuck: Do not count page views as proof that the unit economics work.

Record your work, decisions and evidence:




Record your result against the acceptance check:



WORKED CASE
At the teaching price, contribution is 30−12−2−3−4=9 per order. Ten orders cover the 90-unit fixed setup assumption. If shipping subsidy rises to 7, contribution falls to 6 and the same threshold becomes 15 orders.

FINAL PROJECT
Deliver the offer brief, economics worksheet, product page, checkout storyboard, fulfillment map and pilot plan. Explain the decision if only eight baseline-contribution orders complete and two more cancel.

REQUIRED CRITICAL CHECK
The worksheet distinguishes revenue, variable contribution and fixed cost, and the mockup does not imply a working payment service.

SCORING
Score each of the five stage acceptance checks from 0–16 (0 missing/incorrect; 8 partially supported; 16 complete and evidenced). Score the final integrated project from 0–20 (0 missing; 10 incomplete handover; 20 complete, reproducible and consistent with the case). Target: at least 80/100 AND the critical check must pass. A total score never overrides a failed critical check.

SCOPE LIMIT
This is store planning and a synthetic pilot exercise, not a live shop launch, legal policy set or profit guarantee.

SOURCES AND ACCESS
Assigned public videos can be watched free. Complete the original case in a text editor, on paper or in a spreadsheet you already have. No paid course, exam or provider certificate is included.

Free Digital Marketing and E-commerce Course by Google
WikiFree: https://wikifree.com/courses/google-digital-marketing-ecommerce-free-video-course/
Official source: https://www.youtube.com/playlist?list=PLTZYG7bZ1u6qDuyxKfDrvzJRFnjalX32r
Why selected: Google public e-commerce lessons supply store, acquisition and customer-experience context; the kit economics and pilot case are original.

Stage 1 selected lessons:

22. Introduction to e-commerce and online stores (37:44)
https://www.youtube.com/watch?v=fbBwPFoBTs4&list=PLTZYG7bZ1u6qDuyxKfDrvzJRFnjalX32r&index=22

37. How to Do Market Research for Your Online Store (2:48)
https://www.youtube.com/watch?v=LUtK5M8dLeo&list=PLTZYG7bZ1u6qDuyxKfDrvzJRFnjalX32r&index=37

Stage 3 selected lessons:

23. Learn about online stores (32:12)
https://www.youtube.com/watch?v=p7YA2j2XYUM&list=PLTZYG7bZ1u6qDuyxKfDrvzJRFnjalX32r&index=23

Stage 4 selected lessons:

25. Engage customers with an online store (17:28)
https://www.youtube.com/watch?v=l2DvTFiCaNM&list=PLTZYG7bZ1u6qDuyxKfDrvzJRFnjalX32r&index=25

26. Introduction to building customer loyalty online (31:48)
https://www.youtube.com/watch?v=jASPsLUNrgA&list=PLTZYG7bZ1u6qDuyxKfDrvzJRFnjalX32r&index=26

Stage 5 selected lessons:

24. Ads and campaigns in e-commerce (38:32)
https://www.youtube.com/watch?v=UIHNa3kab4Q&list=PLTZYG7bZ1u6qDuyxKfDrvzJRFnjalX32r&index=24

28. Analyze trends for an online store (25:43)
https://www.youtube.com/watch?v=4MzB-yIlF0s&list=PLTZYG7bZ1u6qDuyxKfDrvzJRFnjalX32r&index=28

REUSE
Original WikiFree teaching text and synthetic fixtures are supplied for personal learning and adaptation with attribution. Provider lessons remain on their original sites and retain their own terms. No provider certificate is included.