johnalbertini14-glitch Shopify Bulk Upload Tool
A powerful tool to bulk upload products to your Shopify store from Excel/CSV files.
Features
- ✅ Read Excel/CSV product data
- ✅ Create products with multiple images
- ✅ Support product variants (color, size, etc.)
- ✅ Auto image upload processing
- ✅ Inventory management
- ✅ Error logging and retry
- ✅ Incremental update by SKU
- ✅ Upload progress display
Quick Start
1. Prepare Product Data File
Prepare product data in assets/products.xlsx or assets/products.csv:
| Field | Required | Description |
|---|---|---|
| title | ✅ | Product title |
| description | ✅ | Product description (HTML supported) |
| vendor | ✅ | Brand/Supplier |
| product_type | ✅ | Product type |
| price | ✅ | Price |
| compare_at_price | ❌ | Original price (for showing discount) |
| sku | ✅ | SKU code |
| inventory_quantity | ❌ | Stock quantity |
| weight | ❌ | Weight (unit: kg) |
| weight_unit | ❌ | Weight unit: kg, g, lb, oz |
| status | ❌ | active, draft, archived |
| tags | ❌ | Tags (comma separated) |
| images | ❌ | Image URLs (comma separated, multiple) |
| variant_title | ❌ | Variant name (e.g., Color, Size) |
| option1_name | ❌ | Variant option 1 name (e.g., Color) |
| option1_value | ❌ | Variant option 1 value (e.g., Red) |
| option2_name | ❌ | Variant option 2 name (e.g., Size) |
| option2_value | ❌ | Variant option 2 value (e.g., M) |
2. Configure Shopify API
Configure in .env file:
SHOPIFY_STORE_URL=https://your-store.myshopify.com
SHOPIFY_ACCESS_TOKEN=your_access_token
SHOPIFY_API_VERSION=2024-01
To get Access Token:
- Login to Shopify Admin
- Go to Settings → Apps and sales channels → Develop apps
- Create App → Configure Admin API scopes
- Check
write_products,write_inventorypermissions - Install app → Get Access Token
3. Install Dependencies
cd scripts
pip install -r requirements.txt
4. Run Upload Script
python shopify_bulk_upload.py
Output Results
After completion:
logs/upload.log- Upload loglogs/error.log- Error detailsoutput/products_created.json- Successfully created productsoutput/products_failed.json- Failed products
Configuration
Edit scripts/config.py to customize:
CONFIG = {
"batch_size": 10, # Products per batch
"retry_count": 3, # Retry attempts on failure
"retry_delay": 2, # Retry interval (seconds)
"image_timeout": 30, # Image upload timeout (seconds)
"default_status": "active" # Default product status
}
Documentation
- Shopify Admin API: See references/shopify-api.md
- Template example: See assets/products-template.csv
Requirements
- Python 3.8+
- pandas
- requests
- python-dotenv
- openpyxl