πŸ–ΌοΈ

QR Code Generator

Generate batch QR codes from Excel links with optional logo embedding.

Image ⭐ Beginner ⏱️ 3 minutes

😫 The Pain Point

You need 1,000 QR stickers for your product inventory. Each QR leads to myshop.com/product/{id}. Generating them one by one online is slow.

πŸš€ Agentic Solution

A Batch QR Generator that reads your product list and outputs branded QR images.

Key Features:

  • Logo Embed: Put your brand logo in the center.
  • High Resolution: 1000x1000px suitable for printing.
  • Batch Mode: Generate from Excel data.

βš”οΈ Phase 1: Commander (Quick Fix)

For a quick batch.

Prompt:

β€œI have an Excel products.xlsx with columns β€˜Product_ID’ and β€˜URL’. Write a Python script using qrcode and Pillow to:

  1. Generate: QR code for each URL.
  2. Logo: Embed β€˜logo.png’ in the center (optional).
  3. Size: 500x500 pixels.
  4. Error Correction: High (to survive logo obstruction).
  5. Output: Save as qr_codes/{Product_ID}.png.

Print progress.”

Result: Branded QR codes for all products.

πŸ—οΈ Phase 2: Architect (Permanent Tool)

Engineering Prompt:

**Role:** Python Tool Developer
**Task:** Create a "Batch QR Code Generator".

**Requirements:**
1.  **GUI:**
    *   Select Excel data source.
    *   Column dropdowns for Content and Filename.
    *   Logo file picker (optional).
    *   Size slider.
    *   Color pickers (foreground/background).
    *   Progress bar.

2.  **Logic:**
    *   Use qrcode with error_correction=H.
    *   Paste logo at center.
    *   Handle large batches efficiently.

3.  **Deliverables:**
    *   `qr_gen.py`
    *   `run.bat`, `run.sh`
    *   `requirements.txt`

🧠 Prompt Decoding

  • Error Correction H: High level allows 30% of QR to be covered (by logo) and still be scannable.

πŸ› οΈ Instructions

  1. Install: pip install qrcode pillow pandas
  2. Copy Prompt β†’ Run.

Related Workflows

Explore other categories

πŸ“¬

Get Started with Agentic Working

Subscribe to receive updates from AgenticWorking.io

πŸ“– Free eBook Guide πŸ“¦ 7 Ready-to-use Scripts πŸ”” Weekly Tips

No spam, unsubscribe anytime. Join 1,000+ subscribers.