SKU Bulk Generator Specifications
Comprehensive guide to SKU pattern syntax, automatic webhook triggers, catalog batch limits, and Shopify API integration.
1. System Overview
App architecture & scopes2. Token Syntax
Pattern placeholder variables3. Webhooks & Sync
Auto-generation triggers1. System Overview & Shopify Scopes
SKU Bulk Generator is built on Next.js, Node.js background workers, and PostgreSQL. It interfaces directly with Shopify via the official GraphQL Admin API (version 2026-07) to query catalog structures and mutate product variant SKU attributes.
Required Shopify OAuth Scopes:
- ✓ write_products (Used to update SKU strings on ProductVariants)
- ✓ read_products (Used to query titles, options, vendors, and types)
- ✓ read_inventory (Used to verify multi-location SKU alignment)
2. Rule Pattern Token Syntax Reference
You can combine tokens, custom literal strings, and separators (hyphen -, underscore _, slash /, or none) to form your SKU template.
| Token Syntax | Description | Sample Output |
|---|---|---|
| {VENDOR} | Product Vendor initials or name | URBAN |
| {PRODUCT_TITLE} | First N characters of Product Title | JACKET |
| {OPTION_1} | Value of 1st Variant Option (e.g. Size) | LARG |
| {OPTION_2} | Value of 2nd Variant Option (e.g. Color) | BLUE |
| {AUTO_INC} | Sequential counter with padding (0001) | 0042 |
| {BARCODE} | Existing barcode/UPC string | 8492048291 |
3. Automated Webhooks & Rate-Limit Safety
SKU Bulk Generator uses Shopify mandatory webhooks (products/create, products/update) registered via GraphQL webhook subscriptions.
GraphQL Leaky Bucket Safety
Batch mutations automatically throttle according to Shopify cost limits (50 points/sec) to avoid rate limit HTTP 429 exceptions.
1-Click Rollback Logs
Every bulk update captures a pre-execution JSON snapshot of variant SKUs, enabling instant rollback if rules are misconfigured.