shopify-bulk-upload

TotalClaw 作者 totalclaw

批量上传产品到 Shopify 商店。从 Excel/CSV 读取产品数据，自动创建产品、图像、变体、价格和库存。使用案例：（1）批量上架新产品（2）将产品从其他平台迁移到Shopify（3）批量更新现有产品信息。

安装 / 下载方式

TotalClaw CLI推荐

totalclaw install totalclaw:totalclaw~zhaoteng-qd-shopify-bulk-upload

cURL直接下载，无需登录

curl -fsSL https://skills.taituai.com/api/skills/totalclaw%3Atotalclaw~zhaoteng-qd-shopify-bulk-upload/file -o zhaoteng-qd-shopify-bulk-upload.md

## 概述（中文）

批量上传产品到 Shopify 商店。从 Excel/CSV 读取产品数据，自动创建产品、图像、变体、价格和库存。使用案例：（1）批量上架新产品（2）将产品从其他平台迁移到Shopify（3）批量更新现有产品信息。

## 原文

# 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:

```bash
SHOPIFY_STORE_URL=https://your-store.myshopify.com
SHOPIFY_ACCESS_TOKEN=your_access_token
SHOPIFY_API_VERSION=2024-01
```

To get Access Token:
1. Login to Shopify Admin
2. Go to Settings → Apps and sales channels → Develop apps
3. Create App → Configure Admin API scopes
4. Check `write_products`, `write_inventory` permissions
5. 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
}
```

## Documentation

- Shopify Admin API: See [references/shopify-api.md](references/shopify-api.md)
- Template example: See [assets/products-template.csv](assets/products-template.csv)

## Requirements

- Python 3.8+
- pandas
- requests
- python-dotenv
- openpyxl