✓ Verified ✍️ Content Creation ✓ Enhanced Data

Shopify Bulk Upload

Bulk upload products to Shopify stores.

Rating: 4.1 (59 reviews)
Downloads: 917 downloads
Version: 1.0.0

Overview

Bulk upload products to Shopify stores.

✨Key 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

Complete Documentation

View Source →

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:

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
}

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

Installation

Terminal bash


openclaw install shopify-bulk-upload

Copied!

💻Code Examples

SHOPIFY_API_VERSION=2024-01

shopifyapiversion2024-01.txt

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

python shopify_bulk_upload.py

python-shopifybulkuploadpy.txt

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

example.sh

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

example.py

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
}