Selling Abroad from Your Online Shop: Localised Prices, Currency Fees, Duties at Checkout, International Shipping & Returns
Price and ship for customers in other countries: local price points, currency conversion fees, duties paid by buyer or seller, shipping and returns from abroad, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you run the numbers of a fictional online tea shop that sells to three invented foreign markets. You convert orders at the mid-rate with XLOOKUP and take off spread and payout fees, turn converted prices into charm prices with CEILING and round prices with MROUND, apply fictional duty-free thresholds with IF and compare duty-paid with duty-unpaid landed prices. You read a two-way shipping rate card with INDEX/MATCH, measure return rates with COUNTIFS and AVERAGEIFS, promise delivery dates with WORKDAY, score and rank markets with SUMPRODUCT and RANK.EQ and finish with break-even orders and a chart.
Lessons
- Currency Conversion: What You Really Receive from a Foreign Order Pro
- Localised Price Points: Charm Prices and Round Prices per Market Pro
- Duties & Import Taxes at Checkout: Duty-Paid vs Duty-Unpaid Offers Pro
- International Shipping: Zone Rate Cards, Free-Shipping Thresholds and the Gap Pro
- Returns from Abroad: Return Rates, Return Shipping and Refunds Without a Return Pro
- Delivery Promise: Handling + Transit Working Days and the Late Share Pro
- Market Comparison: Average Order Value, Contribution per Order and a Weighted Score Pro
- Expansion Check: Fixed Costs per Market, Break-Even Orders and the Verdict Pro