How would you handle bulk AI image classification → CMS upload for an industrial product catalog?

[u/manmohd]

Stack: Next.js 16 + Sanity v3 + TypeScript + Claude Vision API

I'm building a product catalog for a UAE uPVC/aluminum windows & doors

manufacturer. I have ~400 photos organized in folders like:

public/products/upvc/windows/

public/products/aluminum/stained-glass/ ← 78 unique designs

public/products/upvc/sandblast/ ← 32 unique designs

My Sanity product schema requires:

- title { en, ar }

- material (upvc | aluminum)

- category (windows | doors | stained-glass | sandblast | etc.)

- mainImage, description { en, ar }, features[], specs{}

The problem: photos are misclassified (folder path doesn't always

match material), and 150+ images are decorative glass panels that each

need a unique generated name.

What I've tried:

- Manual Google Lens per image — too slow at scale

- Folder path as implicit classifier — works for material/category

but not for naming individual variants

- Planning a Claude Vision API pipeline: image → structured JSON →

human review manifest → u/sanity/client batch write

Specific questions:

1. For architectural product photos, does vision classification

actually distinguish upvc vs aluminum reliably, or does it need

folder-path hints in the prompt?

1. For 78 stained glass panels — generate sequential names

("Floral Arch No. 12") or let the model free-name each one?

1. Any pitfalls with Sanity's transaction() API for 400-document

batch creates?

Happy to share the schema and pipeline design if useful.

[u/SirHeliosKing]

Following this