Can I vibe code Bluestone PIM?

Build an API-first, multi-tenant Product Information Management (PIM) application using Next.js (App Router), Tailwind CSS, Node.js, PostgreSQL, and Prisma ORM.

1. DATA MODEL:
Construct a schema in Prisma for:
- Product: id, sku, status (draft, ready, published), created_at, updated_at.
- AttributeDefinition: id, code, label, type (text, number, boolean, select, json), is_localizable (boolean), is_required (boolean).
- AttributeValue: id, product_id, attribute_id, locale (string, e.g., 'en_US', 'de_DE'), value_text, value_number, value_json.
- Category: id, parent_id, name, slug, path (LTree or string for hierarchical trees).
- ProductCategory: product_id, category_id.
- MediaAsset: id, url, filename, mime_type, file_size.
- ProductMedia: product_id, media_id, position.
- Channel: id, name, type (e.g., 'shopify', 'custom_webhook'), API credentials config JSON.

2. CORE ADMIN UI:
- Build a spreadsheet-style catalog editor using TanStack Table or AG Grid allowing bulk editing of attributes, status changes, and category assignments.
- Provide a locale selector dropdown that dynamically switches localized AttributeValue fields in the table.
- Implement a tree view for managing nested categories with drag-and-drop hierarchy adjustments.
- Build a media library upload modal that posts directly to S3 storage and attaches media objects to SKUs.

3. API & SYNC PIPELINE:
- Create a REST and GraphQL API for public storefront consumption that resolves locale-specific attributes and image asset URLs by product SKU.
- Setup a Redis + BullMQ background worker engine that pushes modified product payloads to external channel APIs (e.g. Shopify GraphQL Admin API).
- Implement exponential backoff, rate limiting, and failure logging per channel sync job.
- Add audit logging that records user_id, attribute_id, old_value, and new_value on every field update.

4. FAILURE HANDLING & SCOPE LIMITS:
- Block publishing if required attributes defined in AttributeDefinition are null for a given locale.
- Gracefully capture channel sync errors without aborting queue progress for valid SKUs.
- OUT OF SCOPE: Real-time inventory reconciliation, warehouse management integrations, and automated machine translation tools.

$ each button prefixes agent-specific run instructions · build your own product, never copy proprietary code, trademarks or designs