Shopify Bulk Upload

商业运营需配置 API Key

批量上传商品至 Shopify，自动读取 Excel/CSV 数据创建产品、图片、变体、价格和库存。适用场景：① 批量上架新品；② 从其他平台迁移商品；③ 批量更新已有商品信息。

电商运营

404

下载量

安装量

收藏量

★ 5.0

综合评分ⓘ

概述

更多信息

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:

FieldRequiredDescriptiontitle✅Product titledescription✅Product description (HTML supported)vendor✅Brand/Supplierproduct_type✅Product typeprice✅Pricecompare_at_price❌Original price (for showing discount)sku✅SKU codeinventory_quantity❌Stock quantityweight❌Weight (unit: kg)weight_unit❌Weight unit: kg, g, lb, ozstatus❌active, draft, archivedtags❌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:

bash

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_inventory permissions
Install app → Get Access Token

3. Install Dependencies#

bash

cd scripts
pip install -r requirements.txt

4. Run Upload Script#

bash

python shopify_bulk_upload.py

Output Results#

After completion:

logs/upload.log - Upload log
logs/error.log - Error details
output/products_created.json - Successfully created products
output/products_failed.json - Failed products

Configuration#

Edit scripts/config.py to customize:

python

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
}