概述

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_inventory permissions
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 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:

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

版本历史

共 1 个版本

v1.0.3 当前

2026-05-12 05:34 安全安全

安全检测

腾讯云安全 (Keen)

安全，无风险

查看报告

腾讯云安全 (Sanbu)