Quick Submit

The flow

1. You paste product URLs (AliExpress or competitor Shopify stores) on the Product Import page.
2. You pick one or more target brands (SOERA, ZEYA, SOKYND, OLANE).
3. Each URL becomes a Pending row in Airtable “Product Imports”.
4. Every 15 min, a cron job on the VPS picks them up, scrapes the source, generates unique AI content per brand, and creates a draft product in each store’s Shopify admin.
5. You review drafts in Product Imports (this app) or directly in Shopify, then publish.

Multi-brand rules

• Source is scraped once per URL; content is regenerated uniquely per brand. Titles and descriptions differ across brands — not copies.
• Title generator enforces a luxury brand blacklist (~90 trademarked names like Celine, Chanel, Dior, Tiffany, Stella, Vera, Kate) to avoid legal/PPC conflicts.
• First-name uniqueness per brand — the AI fetches existing products for that vendor and avoids reusing names.

Status lifecycle

A row stuck on Error can be re-queued by flipping status back to Pending in Airtable.

Pricing (fixed per product type)

Compare-at price is randomized per product at 20 / 25 / 30% off to look like a natural sale.

What gets set on every draft

• Category — Shopify Standard Taxonomy (Dresses, Coats & Jackets, Clothing Tops…), mapped from the product type
• Fit Active Segment metafield = 3 (required by the SOERA theme)
• Age group = Adults / Target gender = Female (Shopify Taxonomy metaobjects)
• Images — full gallery from source (Apify + direct HTML fallback); variant images are assigned by AI color detection for multi-color products
• Inventory = 10,000 per variant
• Status = Draft (never live until you publish)

Supported URL types

• AliExpress — any product URL (Apify scrapes; falls back to direct HTML if Apify returns too few images)
• Shopify stores — any product URL from any public Shopify store (no API key needed)
• Shopify collections — paste a collection URL; the pipeline expands it into individual product rows

Troubleshooting

“URL was already imported or in progress”

Dup detection: the URL is already a row in Airtable with any non-Error status. Check Product Imports.

Submit stuck on “queued…” for a brand

The cron runs every 15 min. If it stays “queued” for much longer, the row may be in Error. Check the table and look for a red error message.

Wrong images / too few images

Some AliExpress products are geo-restricted — Apify returns only 1 image and the HTML fallback may also fail. Ping @Paul to handle manually.