Video summary

Crie seu Site de Achadinhos e Ganhe Comissões como Afiliado

Main summary

Key takeaways

Business

Business idea / strategy (affiliate sales via “bargain bin” storefront)

Problem observed

Many people start selling online but quit because:

  • They don’t see results
  • Current affiliate methods are too friction-heavy (e.g., long captions and copying/pasting purchase links)

Proposed solution

Build a branded affiliate storefront that behaves like a real e-commerce category store.

  • Visitors browse categories and use search
  • They see product cards (photo, title, price, description)
  • They click a single “buy” button
  • The button redirects to the destination marketplace (Amazon, Mercado Livre, Shopee, Magalu, etc.) using the creator’s affiliate link, so you earn commission

Core framework / process (playbook-style)

Product → Marketplace → Affiliate link → Storefront → Redirect

Operational workflow using automation

  • Keep product/offer data in a Google Sheets spreadsheet
  • A website (“Plan Loja, versão bargain”) automatically pulls data from Sheets
  • When you update prices/coupons/inventory status in Sheets, the storefront refreshes after a short delay

Tooling & system architecture (how it’s built)

Free asset

  • A Google spreadsheet template: “Plan Loja” (bargain version)

Website front-end

  • Static HTML + JavaScript
    • index.html
    • config.js
  • Hosted on a regular web host

Hosting required

  • Web hosting (example: Hostinger)
  • A domain (the video mentions a free domain for 1 year under certain plans)

Key update mechanism

  • The storefront reads CSV feeds generated from published Sheets tabs (e.g., “settings” and “products”).
  • The demonstration shows that when you change a product price in Sheets, the storefront updates shortly after.

Store features (what drives conversion)

  • Categories / menu
  • Search bar (filters products related to the query)
  • Product cards
    • Multiple images
    • Title, price, description
  • Promo pricing
    • Crossed-out original price
    • Promotional price styling
  • Coupons
    • Coupon code entry
    • Optional coupon expiration date
  • Video embedding (optional)
  • Redirect CTA
    • Button text customizable per marketplace (e.g., “buy on Amazon”, “buy on Hotmart”)
    • Clicking redirects to the marketplace using your affiliate link

Step-by-step go-live operations (actionable)

1. Download and edit the spreadsheet

Tabs include:

  • Configuration / Settings

    • Store name, logo URL
    • WhatsApp number
    • Social usernames
    • Message header
    • Colors
    • Banner URL
    • CNPJ/address/email
    • Optional tracking pixel

  • Products

    • Product activation toggle
    • Physical vs digital
    • Marketplace platform (e.g., Magalu)
    • Category / subcategory
    • Title, description
    • Price & promo price
    • Coupon + expiry
    • Affiliate link
    • Button text
    • Video URL
    • Images (URLs)
    • Display order
    • Featured flag

2. Prepare the product image assets

  • Upload images to Google Drive
  • Set sharing to “anyone with the link”
  • Copy each image URL into the spreadsheet image fields

3. Publish Sheets data for the website to read

  • Publish/share each tab as:
    • “values separated by commas” (CSV)
  • Copy and save the generated CSV links

4. Host the storefront

  • Use web hosting (recommended: Hostinger)
  • Choose a plan suggested in the video:
    • Premium, because it includes free domain registration for 1 year

5. Deploy the two files

Upload into the hosting “public HTML” area:

  • index.html
  • config.js

6. Configure spreadsheet feed links in config.js

Paste the CSV links for:

  • settings spreadsheet
  • catalog / product spreadsheet

7. Domain propagation

  • Domain activation may take up to 24 hours
  • Preview may work earlier via a temporary URL

8. Ongoing merchandising

  • Start by adding 2–3 products for testing
  • Scale afterward
  • Update prices/promos/coupons in Sheets to automatically change storefront contents

Concrete example / case demonstration included

Example product: “Ninja blender”

  • The video changes the promo price in the spreadsheet (e.g., to R$699)
  • The storefront reflects the updated price after the sync delay

Example flow

  • Clicking “buy” on the storefront redirects to the chosen marketplace
  • The marketplace example depends on the platform/affiliate link (Shopee/Amazon/Mercado Livre/Magalu are referenced)

Metrics / KPIs / targets

Business KPIs

  • The subtitle/text provides no explicit KPIs such as:
    • CAC, LTV, churn
    • conversion rate, commission rate targets
    • revenue goals

Operational timing metrics mentioned

  • Spreadsheet → website sync delay: seconds to ~1 minute
  • DNS/domain propagation: up to 24 hours
  • Domain creation benefit: 1 year free domain registration (plan advantage)

Investing/markets (high-level only)

  • The focus is on reducing upfront cost via:
    • Free domain for 1 year (plan benefit)
  • The video also mentions an additional 10% discount coupon for Hostinger (code provided in the video)

Presenters / sources

  • Presenter: Darlan Evandro
  • Tools / sources referenced:
    • Plan Loja (planiloj.com.br)
    • Google Sheets / Google Drive
    • Canva
    • Hostinger
    • Affiliate marketplaces (examples mentioned: Shopee, Amazon, Mercado Livre, Magalu, Hotmart)
    • Brazilian tax ID CNPJ (included in template fields)

Original video