1-Click Product Ingestion, "Fill with AI" & Vendure Catalog Sync
Connect supplier CSVs, Shopify stores, TikTok Shop feeds, and product photos directly to Vendure Headless Commerce and PostgreSQL. Automatically generate high-converting titles, direct-response hooks, Cartesian option groups, and verified specs with Gemini 2.5 Pro Multimodal Vision.
Fill with AI → Products → Catalog → Vendure → PostgreSQL Database
How supplier spreadsheets and product photos transform into fully enriched Vendure catalog entities and TypeORM database tables with zero manual entry.
Image & Feed Dropzone
Uploads product photos or supplier CSVs to Vendure mutation CreateAssets. Stores file in PostgreSQL asset table, generating featuredAssetId and WebP previews.
Feature & Copy Generation
Gemini 2.5 Pro analyzes image pixels and uses Google Search grounding to inspect competitor listings, drafting the 8 core Vendure custom fields (hook, persona, materials, specs).
Variant Auto-Generation
addCustomOptionGroup creates Option Groups (Size, Color). Computes cartesian product to generate individual ProductVariant entities with generated SKUs and stock units.
ACID Ledger & Live Chat
Persists to PostgreSQL tables (product, product_variant). Broadcasts via Super API webhooks to Super Chat for 1-click in-chat quotations and bank slip reconciliation.
Multimodal "Fill with AI"
Extracts product colors, textures, materials, and form factors directly from uploaded photos with Gemini 2.5 Pro multimodal vision.
Automated Variant Matrix
Computes cartesian product of sizes, colors, and materials. Generates structured SKUs and stockOnHand allocations automatically.
Competitor Search Grounding
Queries live Google Search results to identify competitor terminology, price benchmarks, and customer-proven product descriptions.
Universal CSV & Excel Import
Intelligently maps inconsistent supplier columns (Barcode, EAN, Retail, Wholesale, QTY) to standardized Vendure entity models.
Marketplace Real-Time Sync
Two-way inventory mirroring with Shopify, TikTok Shop, and WooCommerce, preventing overselling across high-volume chat channels.
Direct-Response Social Copy
Generates 8 high-converting Vendure fields: hooks, customer personas, sensory usage scenarios, and bulleted benefit specs.
Instant Chat Quoting
Ingested SKUs are instantly searchable by sales reps and AI bots inside Super Chat, enabling 1-click quotations and bank transfers.
High-Res Asset Pipeline
Automates background normalization, WebP compression, aspect ratio fitting, and CDN caching for sub-second mobile loading.
PostgreSQL TypeORM Integrity
ACID-compliant relational schema maintaining foreign keys across products, option groups, assets, and multi-currency orders.
Vendure Product & Option Group Ledger
Live catalog ledger reflecting products ingested via CSV, Shopify, TikTok Shop, and AI image extraction. Explore Cartesian variants, pricing, stockOnHand, and custom fields.
|
Product Title & SKU
↕
|
Ingestion Source | Category |
Variants
↕
|
Base Price
↕
|
Stock On Hand
↕
|
Fill with AI | Super Chat Sync | Drilldown |
|---|---|---|---|---|---|---|---|---|
|
Onyx Trail Runner Pro V4
SKU: RUN-ONX-4 • ID: #1042
|
Shopify API | Footwear | 12 Variants | ฿2,890 | 420 Units | Enriched (8/8) | Live in Chat | |
|
Direct-Response Hook & Description
"All-weather grip meets cloud-rebound cushioning for urban marathoners."
Dual-compound Vibram Megagrip sole co-engineered with alpine athletes. High energy return with zero slip on wet asphalt.
Target Persona & Usage Scenario
Who it's for: Trail & road runners seeking high energy return and zero blister friction.
When it's used: Imagine powering through wet asphalt and rocky climbs with total foot stability.
Materials & Bullet Specs
• Recycled ripstop mesh upper (breathable)
• Vibram Megagrip outsole (32% traction lift)
• Supercritical EVA foam (68% rebound)
Weight: 285g | Heel Drop: 8mm
Option Matrix & Database Entities
Option Groups: Size (8,9,10,11) × Color (Onyx, White, Grey)
Cartesian Variants: 12 Active SKUs
Product.id: 1042 | featuredAssetId: 8841
|
||||||||
|
Botanical Barrier Bio-Hydration Serum
SKU: SER-BIO-30 • ID: #1043
|
Photo Upload | Beauty & Skin | 4 Variants | ฿1,450 | 850 Units | Enriched (8/8) | Live in Chat | |
|
Direct-Response Hook & Description
"72-hour moisture lock with 5-ceramide barrier repair for sensitive skin."
Multi-weight hyaluronic acid penetrates 5 dermal layers. Clinically tested 0.00 irritation rating.
Target Persona & Usage Scenario
Who it's for: Urban professionals battling AC dryness, redness, and pollution stress.
When it's used: Imagine soothing immediate redness with 3 silky drops right after morning cleansing.
Materials & Bullet Specs
• 5-Ceramide Complex (restores lipid matrix)
• Centella Asiatica (42% redness drop)
• Airless pump dispenser (zero active oxidation)
Volume: 30ml / 50ml | pH 5.5
Option Matrix & Database Entities
Option Groups: Volume (30ml, 50ml) × Dispenser (Dropper, Pump)
Cartesian Variants: 4 Active SKUs
Product.id: 1043 | featuredAssetId: 8842
|
||||||||
|
Apex Halo 75% Wireless Mechanical Keyboard
SKU: KB-APX-75 • ID: #1044
|
CSV / Excel Feed | Electronics | 6 Variants | ฿3,690 | 310 Units | Enriched (8/8) | Live in Chat | |
|
Direct-Response Hook & Description
"Gasket-mounted thock acoustics with triple-mode wireless connectivity."
Anodized CNC aluminum casing paired with pre-lubed Gateron Pro switches and 5-layer acoustic dampening foam.
Target Persona & Usage Scenario
Who it's for: Software engineers and keyboard enthusiasts seeking acoustic perfection.
When it's used: Imagine satisfying, whisper-smooth typing sessions without disturbing open-office colleagues.
Materials & Bullet Specs
• Gasket mount + 5-layer sound foam (marble sound)
• Tri-mode 2.4GHz / BT 5.2 / Type-C (sub-1ms latency)
• Hot-swap 5-pin sockets (swap switches in seconds)
Battery: 4000mAh (240h) | Weight: 980g
Option Matrix & Database Entities
Option Groups: Switch (Red, Brown, Blue) × Color (Grey, Cream)
Cartesian Variants: 6 Active SKUs
Product.id: 1044 | featuredAssetId: 8843
|
||||||||
|
Komorebi Organic Waffle Linen Bedset
SKU: LIN-KOM-B • ID: #1045
|
Shopify API | Home & Living | 6 Variants | ฿4,200 | 195 Units | Enriched (8/8) | Live in Chat | |
|
Direct-Response Hook & Description
"Temperature-regulating French flax linen pre-washed for cloud-like softness from day one."
Breathable waffle honeycomb weave provides 3x more airflow than traditional cotton. Gets softer with every wash.
Target Persona & Usage Scenario
Who it's for: Hot sleepers and interior design lovers craving airy, breathable luxury.
When it's used: Imagine slipping into cool, breathable sheets that stay naturally crisp and dry all night.
Materials & Bullet Specs
• 100% Certified French Flax Linen (175 GSM)
• Pre-washed stone enzyme finish (zero shrinkage)
• Deep 38cm elastic pocket (fits pillowtop beds)
Duvet: 220x240cm | Fitted: 180x200cm
Option Matrix & Database Entities
Option Groups: Bed Size (Queen, King) × Color (Taupe, Matcha, Sand)
Cartesian Variants: 6 Active SKUs
Product.id: 1045 | featuredAssetId: 8844
|
||||||||
|
AeroShield Waterproof Summer Shell Jacket
SKU: JKT-AERO-W • ID: #1046
|
TikTok Shop | Apparel | 12 Variants | ฿2,190 | 540 Units | Enriched (8/8) | Live in Chat | |
|
Direct-Response Hook & Description
"Ultralight packable storm protection engineered for tropical rain and Songkran splashes."
20D DWR Toray Ripstop Nylon with YKK AquaGuard zippers. Packs down smaller than a smartphone.
Target Persona & Usage Scenario
Who it's for: Commuters and outdoor adventurers needing pocket-sized rain security.
When it's used: Imagine staying completely dry in sudden monsoon downpours, then folding the jacket into your palm.
Materials & Bullet Specs
• 15,000mm hydrostatic head (storm waterproof)
• YKK AquaGuard taped seams (zero water seepage)
• Microporous membrane (vents body sweat vapor)
Weight: 145g | Pack Size: 12x8cm
Option Matrix & Database Entities
Option Groups: Size (S, M, L, XL) × Color (Midnight, Olive, Coral)
Cartesian Variants: 12 Active SKUs
Product.id: 1046 | featuredAssetId: 8845
|
||||||||
|
Barista Craft Dual-Boiler Espresso Machine
SKU: COF-BC-DB • ID: #1047
|
CSV / Excel Feed | Home & Living | 3 Variants | ฿24,500 | 48 Units | Enriched (8/8) | Live in Chat | |
|
Direct-Response Hook & Description
"Commercial PID dual boilers with rotary pump for cafe-grade espresso and microfoam at home."
Simultaneous extraction and steaming with 0.2°C temperature precision. Solid brass 58mm commercial group head.
Target Persona & Usage Scenario
Who it's for: Home baristas and boutique cafe owners demanding precise thermal stability.
When it's used: Imagine pulling rich, syrupy espresso shots while simultaneously steaming velvet microfoam for latte art.
Materials & Bullet Specs
• Independent dual 1.8L boilers (simultaneous brew/steam)
• Digital PID thermal control (±0.2°C stability)
• Commercial rotary pump (whisper-quiet pre-infusion)
Dimensions: 340x420x400mm | Weight: 26kg
Option Matrix & Database Entities
Option Groups: Body Finish (Matte Black, Brushed Steel, Gloss White)
Cartesian Variants: 3 Active SKUs
Product.id: 1047 | featuredAssetId: 8846
|
||||||||
Interactive "Fill with AI" Simulator
Select a sample product photo or type merchant instructions to observe the live Gemini 2.5 Pro generation of Vendure custom fields, option groups, and Cartesian variant records.
Onboard your entire catalog with zero manual data entry.
Connect your Shopify, TikTok Shop, CSV feeds, or product photos to Vendure and Super Chat in under 2 minutes.