Install
openclaw skills install afrexai-ecommerce-engineLaunch and scale ecommerce brands with product selection, pricing, multi-channel store setup, and profitability optimization for DTC, marketplace, or hybrid...
openclaw skills install afrexai-ecommerce-engineComplete system for launching, optimizing, and scaling ecommerce businesses — from product selection through multi-channel operations and profitability management. Works for DTC brands, marketplace sellers, and hybrid operations.
business_brief:
brand_name: ""
stage: "idea | launch | growth | scale"
model: "DTC | marketplace | hybrid | dropship | wholesale"
channels: [] # shopify, amazon, ebay, etsy, walmart, tiktok-shop
category: ""
target_customer: ""
avg_order_value_target: "$"
monthly_revenue_target: "$"
current_monthly_revenue: "$"
biggest_challenge: ""
competitive_advantage: ""
Score each product candidate across 5 dimensions:
| Dimension | Weight | Score 1-5 | Criteria |
|---|---|---|---|
| Demand | 25% | _ | Search volume >1K/mo, trending up, not seasonal-only |
| Margin | 25% | _ | >60% gross margin after ALL costs (COGS+shipping+fees+returns) |
| Competition | 20% | _ | <50 direct competitors, no dominant brand >40% share |
| Logistics | 15% | _ | <2lb, non-fragile, no hazmat, easy to ship and store |
| Moat | 15% | _ | Brandable, can differentiate, not easily commoditized |
Score = Σ(weight × score × 4) → scale to 100
Need product sourced?
├── Volume <100 units/month → Domestic wholesale or print-on-demand
├── Volume 100-1000 → Alibaba verified suppliers (Gold+ status, Trade Assurance)
├── Volume 1000+ → Direct factory (attend Canton Fair or hire sourcing agent)
└── Digital product → No sourcing needed (courses, templates, software)
For physical products ALWAYS:
1. Order 3-5 samples from different suppliers
2. Test quality, packaging, shipping time
3. Negotiate MOQ down for first order (mention "trial order, larger orders planned")
4. Get product liability insurance before selling
unit_economics:
sku: ""
selling_price: 0.00
# Cost of Goods
product_cost: 0.00 # Per unit from supplier
shipping_to_warehouse: 0.00 # Freight / unit
packaging: 0.00 # Box, inserts, tape
labeling: 0.00 # FNSKU, barcodes
landed_cost: 0.00 # Sum of above
# Platform Fees (calculate per channel)
referral_fee: 0.00 # Amazon: 8-45% by category
fba_fee: 0.00 # Or 3PL pick/pack
payment_processing: 0.00 # Stripe 2.9%+30¢, PayPal 3.49%+49¢
subscription_fee_per_unit: 0.00 # Shopify plan / units
# Fulfillment
shipping_to_customer: 0.00
packaging_materials: 0.00
# Variable Costs
return_rate: 0.00 # % (fashion 20-30%, electronics 5-10%)
return_cost_per_unit: 0.00 # Return shipping + restock + lost inventory
advertising_cost_per_unit: 0.00 # Total ad spend / units sold (target: <15% of revenue)
# Calculated
total_cost_per_unit: 0.00
gross_profit: 0.00
gross_margin_pct: 0.00 # TARGET: >60% for DTC, >30% for marketplace
contribution_margin: 0.00 # After variable costs
break_even_units: 0 # Fixed costs / contribution margin
| Channel | Pricing Rule | Fee Structure | Margin Target |
|---|---|---|---|
| Own store (Shopify) | Full price, brand premium | 2.9% + 30¢ payment | >65% |
| Amazon | Competitive, Buy Box eligible | 15% referral + FBA | >30% |
| eBay | 5-10% below Amazon | 13% final value | >25% |
| Walmart | Match or beat Amazon | 6-20% referral | >30% |
| Etsy | Premium (handmade perception) | 6.5% transaction + 3% payment | >50% |
| TikTok Shop | Impulse price (<$50) | 5% + 1.8% payment | >40% |
[ ] Domain purchased and connected (use .com, avoid hyphens)
[ ] SSL certificate active (automatic with Shopify)
[ ] Theme selected and customized (Dawn for speed, or premium for $)
[ ] Logo and brand assets uploaded
[ ] Navigation structured (max 7 top-level items)
[ ] Homepage: hero image + value prop + 3 trust badges + featured products + social proof
[ ] Product pages optimized (see Product Page template below)
[ ] Collection pages with filters
[ ] About page (brand story, team, mission)
[ ] Contact page with form + email + phone
[ ] FAQ page (reduces support tickets 30-40%)
[ ] Shipping policy page
[ ] Return policy page (generous = higher conversion)
[ ] Privacy policy + Terms of Service (auto-generated + reviewed)
[ ] Payment gateways configured (Shop Pay + PayPal + Apple Pay + Google Pay)
[ ] Tax settings configured (use automated tax with Avalara)
[ ] Shipping zones and rates configured
[ ] Email flows set up (see Email Automation section)
[ ] Google Analytics 4 installed
[ ] Facebook Pixel installed
[ ] Conversion tracking verified (test purchase)
[ ] Mobile experience tested (60%+ of traffic is mobile)
[ ] Page speed score >70 on Google PageSpeed Insights
[ ] 404 page customized with search + popular products
ABOVE THE FOLD:
├── Product images (7+ images: hero, lifestyle, detail, scale, packaging, infographic, video)
├── Product title (benefit-driven, include primary keyword)
├── Star rating + review count (social proof)
├── Price (with compare-at if applicable)
├── Key benefits (3-4 bullet points with icons)
├── Variant selector (color, size with guide link)
├── Add to Cart button (high contrast, sticky on mobile)
├── Trust badges (secure checkout, free shipping, guarantee)
└── Urgency element (stock count or shipping deadline — only if real)
BELOW THE FOLD:
├── Detailed description (features → benefits → use cases)
├── Size/spec chart
├── Comparison table vs competitors (or vs previous version)
├── Social proof section (UGC photos, testimonials, press mentions)
├── FAQ accordion (5-8 product-specific questions)
├── Reviews section (with photo reviews highlighted)
├── Related products / "Frequently bought together"
└── Sticky ATC bar on scroll (mobile)
Title Formula (200 chars max, front-load keywords):
[Brand] [Primary Keyword] - [Key Benefit] [Material/Size] [Secondary Keyword] for [Use Case]
Bullet Points (5 bullets, each 200-250 chars):
Backend Keywords (250 bytes):
A+ Content (if brand registered):
| Stage | Primary Channels | Budget Allocation | Focus |
|---|---|---|---|
| Launch (0-$10K/mo) | Organic social, influencer seeding, Amazon PPC | 80% paid, 20% organic | Validate product-market fit |
| Growth ($10K-$100K/mo) | Meta Ads, Google Ads, Amazon PPC, email | 60% paid, 25% email, 15% organic | Scale profitable channels |
| Scale ($100K+/mo) | All channels + wholesale + retail | 40% paid, 30% email/SMS, 20% organic, 10% new | Diversify, reduce CAC |
Meta Ads (Facebook/Instagram):
campaign_structure:
testing:
budget: "$20-50/day per ad set"
objective: "Purchase"
targeting: "Broad or 1 interest stack"
creative: "3-5 creatives per ad set"
kill_criteria: "No purchase after 2x AOV spend"
scaling:
method: "Duplicate winning ad sets at 20% budget increase"
frequency: "Every 3-4 days if ROAS holds"
ceiling: "When CPM rises >20% or ROAS drops below target"
creative_types_ranked:
1: "UGC video testimonial (best performer for most DTC)"
2: "Before/after or problem/solution"
3: "Founder story / behind the scenes"
4: "Product demo / unboxing"
5: "Static image with bold text overlay"
metrics_targets:
ctr: ">1.5% (link clicks)"
cpc: "<$2 for <$50 AOV, <$5 for >$50 AOV"
roas: ">3x for <$50 AOV, >2x for >$100 AOV"
frequency: "<3 in 7 days"
Google Ads:
campaign_priority:
1: "Brand search (capture branded traffic, ROAS 10x+)"
2: "Shopping campaigns (product feed optimization critical)"
3: "Non-brand search (high-intent keywords)"
4: "Performance Max (let Google optimize across surfaces)"
5: "YouTube (top-of-funnel, retargeting)"
shopping_feed_optimization:
- Title: include primary keyword + brand + key attribute
- Description: benefit-rich, keyword-natural
- Images: white background, high-res, no text overlay
- Product type: use detailed taxonomy
- GTIN/UPC: always include (improves visibility)
- Custom labels: margin tier, bestseller, seasonal
Amazon PPC:
campaign_structure:
auto_campaign:
purpose: "Keyword discovery"
bid: "Start at $0.50-0.75, adjust weekly"
negatives: "Add irrelevant terms weekly"
manual_exact:
purpose: "Scale proven keywords"
source: "Graduate from auto campaign (>3 orders)"
bid: "Aggressive — these are proven converters"
manual_phrase:
purpose: "Capture long-tail variations"
bid: "Moderate"
sponsored_brands:
purpose: "Brand awareness + cross-sell"
when: "After 10+ reviews and brand registered"
targets:
acos: "<30% for growth, <20% for profit"
tacos: "<12% of total revenue"
SEO for Ecommerce:
Social Commerce:
flow_1_welcome:
trigger: "Email signup"
emails:
- delay: "immediate"
content: "Welcome + discount code + brand story"
- delay: "+1 day"
content: "Best sellers + social proof"
- delay: "+3 days"
content: "Founder story + UGC"
- delay: "+5 days"
content: "Discount reminder (expiring)"
expected_revenue: "20-30% of email revenue"
flow_2_abandoned_cart:
trigger: "Cart abandoned"
emails:
- delay: "+1 hour"
content: "Forgot something? (product image, no discount)"
- delay: "+24 hours"
content: "Social proof + FAQ (overcome objections)"
- delay: "+48 hours"
content: "Last chance + 10% discount or free shipping"
expected_recovery: "5-15% of abandoned carts"
flow_3_browse_abandonment:
trigger: "Viewed product, no add-to-cart"
emails:
- delay: "+2 hours"
content: "Still looking? (product + similar items)"
- delay: "+24 hours"
content: "Reviews for that product"
expected_conversion: "1-3%"
flow_4_post_purchase:
trigger: "Order placed"
emails:
- delay: "immediate"
content: "Order confirmation + what to expect"
- delay: "+3 days"
content: "Shipping update + how to use product (if applicable)"
- delay: "+7 days (after delivery)"
content: "How's your [product]? (review request)"
- delay: "+14 days"
content: "Cross-sell complementary products"
- delay: "+30 days"
content: "Replenishment reminder (if consumable) or VIP program invite"
flow_5_winback:
trigger: "No purchase in 60 days"
emails:
- delay: "immediate"
content: "We miss you + what's new"
- delay: "+7 days"
content: "Exclusive comeback offer (15-20% off)"
- delay: "+14 days"
content: "Last chance before we stop emailing"
after_flow: "If no purchase, move to sunset segment (reduce frequency)"
flow_6_vip:
trigger: "3+ orders OR top 10% by spend"
emails:
- content: "Early access to new products"
- content: "Exclusive VIP-only discounts"
- content: "Birthday/anniversary rewards"
- content: "Referral program with premium incentives"
| Metric | Healthy | Warning | Critical |
|---|---|---|---|
| Open rate | >25% | 15-25% | <15% |
| Click rate | >3% | 1.5-3% | <1.5% |
| Unsubscribe | <0.3% | 0.3-0.5% | >0.5% |
| Revenue per email | >$0.10 | $0.05-0.10 | <$0.05 |
| List growth | >5%/mo | 2-5%/mo | <2%/mo |
Score each test idea:
| Factor | Score 1-5 | Description |
|---|---|---|
| Traffic | _ | How much traffic hits this page? (5 = homepage, 1 = obscure page) |
| Impact | _ | How much will conversion improve? (5 = fundamental change, 1 = minor tweak) |
| Ease | _ | How easy to implement? (5 = copy change, 1 = full redesign) |
| Confidence | _ | How sure are we this will work? (5 = proven elsewhere, 1 = gut feeling) |
Priority Score = Traffic × Impact × Ease × Confidence → Test highest scores first
| Metric | Poor | Average | Good | Excellent |
|---|---|---|---|---|
| Site conversion | <1% | 1-2% | 2-3.5% | >3.5% |
| Add-to-cart rate | <5% | 5-8% | 8-12% | >12% |
| Cart-to-purchase | <30% | 30-50% | 50-65% | >65% |
| Email signup rate | <1% | 1-3% | 3-5% | >5% |
| Return rate | >25% | 15-25% | 8-15% | <8% |
| Repeat purchase | <15% | 15-25% | 25-40% | >40% |
Sales volume?
├── <50 orders/month → Self-fulfill (garage/spare room)
├── 50-500 orders/month → 3PL or FBA
│ ├── Selling on Amazon? → FBA (Buy Box advantage)
│ └── DTC primarily? → 3PL (ShipBob, ShipMonk, Deliverr)
├── 500-5000 orders/month → Hybrid FBA + 3PL
└── 5000+ orders/month → Dedicated 3PL + FBA + own warehouse evaluation
| Days Without Sale | Action |
|---|---|
| 60 days | Flag for review — check listing quality, pricing |
| 90 days | Run clearance promotion (30-50% off) or bundle with A items |
| 120 days | Liquidate at cost (Amazon Outlet, B-stock marketplaces) |
| 180 days | Donate (get tax write-off) or dispose — storage costs exceed value |
| Channel | Response Time Target | Resolution Target |
|---|---|---|
| Live chat | <2 minutes | Same session |
| Email/ticket | <4 hours (business) | <24 hours |
| Social DM | <1 hour | <4 hours |
| Phone | <30 seconds | Same call |
| Amazon messages | <12 hours (24h max or ODR hit) | <24 hours |
Generous returns = higher conversion + higher LTV:
loyalty_program:
type: "points | tiered | VIP | subscription"
points_program:
earn: "1 point per $1 spent"
bonus: "200 points on signup, 100 on review, 500 on referral"
redeem: "100 points = $1 off"
expire: "Never (or 12 months with notice)"
tier_program:
bronze: "0-$200/year → 1x points"
silver: "$200-500/year → 1.5x points + free shipping"
gold: "$500+/year → 2x points + early access + free shipping"
referral:
give: "$15 off first order"
get: "$15 credit after friend's first purchase"
target: "3% of customers refer (good), 5%+ (excellent)"
| Metric | Formula | Target |
|---|---|---|
| Repeat purchase rate | Returning customers / total customers | >25% |
| Purchase frequency | Total orders / unique customers (12 mo) | >2x/year |
| Customer lifetime value | AOV × Purchase frequency × Lifespan | >3x CAC |
| Net Promoter Score | % Promoters (9-10) minus % Detractors (0-6) | >50 |
| Churn rate | Customers lost / starting customers (period) | <5%/month |
weekly_dashboard:
date_range: ""
revenue:
total_revenue: "$"
vs_last_week: "+/- %"
vs_same_week_last_year: "+/- %"
orders: 0
aov: "$"
units_sold: 0
traffic:
sessions: 0
unique_visitors: 0
top_sources:
- source: ""
sessions: 0
conversion_rate: "%"
revenue: "$"
conversion:
site_conversion_rate: "%"
add_to_cart_rate: "%"
cart_to_purchase_rate: "%"
acquisition:
total_ad_spend: "$"
roas: "x"
cac: "$"
new_vs_returning: "% / %"
email_revenue: "$"
email_pct_of_total: "%"
product_performance:
top_5_by_revenue: []
top_5_by_units: []
bottom_5_by_revenue: []
return_rate_by_sku: []
inventory:
days_of_supply_avg: 0
stockout_skus: []
overstock_skus: []
customer:
new_customers: 0
repeat_customers: 0
repeat_rate: "%"
avg_reviews_received: 0
csat_or_nps: 0
action_items:
- item: ""
owner: ""
deadline: ""
Revenue
Gross sales $______
- Discounts $______
- Returns/refunds $______
= Net Revenue $______
Cost of Goods Sold
Product cost $______
Shipping to warehouse $______
Packaging $______
= Total COGS $______
= Gross Profit $______ (target: >60% DTC, >30% marketplace)
Operating Expenses
Advertising $______ (target: <25% of revenue)
Platform fees $______
Software/tools $______
Fulfillment/3PL $______
Customer service $______
Returns processing $______
= Total OpEx $______
= Net Operating Profit $______ (target: >15%)
Cash Flow Note
Inventory investment $______
Accounts payable $______
Cash on hand $______
Runway (months) ______
1. Start on ONE channel — master it (profitable, repeatable)
2. Add channel #2 only when channel #1 is profitable at scale
3. Never launch >1 new channel simultaneously
Recommended sequence for most brands:
DTC-first: Shopify → Amazon → Google Shopping → Walmart → TikTok Shop → Wholesale
Marketplace-first: Amazon → Shopify (DTC) → Walmart → eBay → TikTok Shop
Handmade/Niche: Etsy → Shopify → Amazon Handmade → Wholesale → Faire
[ ] Market research: demand exists for product category
[ ] Regulatory check: certifications, restricted ingredients, labeling requirements
[ ] Tax registration: VAT/GST in target country
[ ] Logistics: FBA international, local 3PL, or cross-border shipping
[ ] Localized listings: native language, local measurements, local price points
[ ] Customer service: support in local language and timezone
[ ] Payment methods: local preferences (iDEAL in NL, Klarna in DE, PIX in BR)
[ ] Returns: local return address or keep-the-item policy for international
| Risk | Prevention | Recovery |
|---|---|---|
| Amazon suspension | ODR <1%, no TOS violations, respond to claims in 24h | Appeal with plan of action (root cause, actions taken, preventive measures) |
| Ad account ban | No misleading claims, diversify creative, follow platform policies | Appeal + diversify to other channels immediately |
| Supplier failure | Dual-source critical SKUs, maintain 30-day safety stock | Activate backup supplier, raise prices temporarily if needed |
| Chargebacks | Clear billing descriptor, easy returns, fraud detection | Dispute with evidence, implement fraud filters (Signifyd, NoFraud) |
| IP complaint | Verify product is not infringing, document supply chain | Respond to complaint, get authorization letter from brand, or delist |
[ ] Business entity formed (LLC or Corp)
[ ] Sales tax registered in nexus states (economic nexus thresholds vary)
[ ] Product liability insurance ($1M minimum)
[ ] Proper labeling (country of origin, materials, care instructions)
[ ] FDA compliance (if food, supplements, cosmetics)
[ ] CPSC compliance (if children's products)
[ ] California Prop 65 warning (if applicable)
[ ] GDPR/CCPA privacy compliance (cookie consent, data handling)
[ ] Terms of service and return policy published
[ ] Trademark filed for brand name and logo
| Dimension | Weight | Score 0-10 | Key Indicators |
|---|---|---|---|
| Product-Market Fit | 15% | _ | Repeat purchase >25%, organic reviews growing, NPS >40 |
| Unit Economics | 15% | _ | Gross margin >50%, LTV:CAC >3:1, positive contribution margin |
| Traffic & Acquisition | 15% | _ | Diversified sources (no channel >50%), CAC trending down, ROAS >3x |
| Conversion | 10% | _ | Site CVR >2%, cart completion >50%, improving MoM |
| Operations | 10% | _ | No stockouts on A items, shipping <2 days, return rate <15% |
| Customer Experience | 10% | _ | Response time <4h, CSAT >4.5/5, churn <5%/mo |
| Email/Retention | 10% | _ | Email >25% of revenue, flows automated, list growing >5%/mo |
| Financial Health | 10% | _ | Net profit >15%, positive cash flow, >3mo runway |
| Brand & Moat | 5% | _ | Trademark filed, brand search growing, differentiated positioning |
Score = Σ(weight × score × 10)
| Command | What It Does |
|---|---|
| "Evaluate this product idea" | Run Product Selection Scorecard |
| "Calculate my unit economics" | Build complete cost stack with margin analysis |
| "Optimize my product listing" | Review and improve title, bullets, images, keywords |
| "Build my email flows" | Design complete automation architecture |
| "Review my ad performance" | Analyze ROAS, CAC, creative performance |
| "Run a CRO audit" | Score current site and prioritize tests |
| "Check my inventory health" | Analyze days of supply, stockouts, dead stock |
| "Build my weekly dashboard" | Generate weekly ecommerce report |
| "Plan my channel expansion" | Recommend next channel with launch checklist |
| "Calculate my P&L" | Generate monthly profit and loss statement |
| "Audit my compliance" | Run legal and platform compliance checklist |
| "Score my ecommerce health" | Run 100-point rubric with recommendations |