> ## Documentation Index
> Fetch the complete documentation index at: https://docs.drmanhlinhmd.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Wordpress import guide

# WordPress/WooCommerce Product Import Guide

**Version:** 1.0
**Last Updated:** 2025-01-10
**Author:** Claude Code Strategic Planner

***

## 📋 Table of Contents

1. [Pre-Import Checklist](#1-pre-import-checklist)
2. [Import Methods Overview](#2-import-methods-overview)
3. [Method A: WP All Import Plugin](#3-method-a-wp-all-import-plugin-recommended)
4. [Method B: WooCommerce REST API](#4-method-b-woocommerce-rest-api)
5. [Method C: Native CSV Import](#5-method-c-native-csv-import-via-woocommerce)
6. [Post-Import Actions](#6-post-import-actions)
7. [Troubleshooting](#7-troubleshooting)
8. [Reference Files](#8-reference-files)

***

## 1. Pre-Import Checklist

### ✅ Backup Database

**CRITICAL:** Always backup before importing!

```bash theme={null}
# Via WP-CLI
wp db export --path=/path/to/wordpress backup_$(date +%Y%m%d_%H%M%S).sql

# Via phpMyAdmin
1. Log in to phpMyAdmin
2. Select your WordPress database
3. Click "Export" tab
4. Choose "Quick" export method
5. Click "Go"

# Via cPanel
1. Backup → Backup Wizard
2. Select "MySQL Database"
3. Download backup
```

### ✅ Check Product Categories

Ensure categories exist before importing:

```bash theme={null}
# List existing categories
wp term list category --format=table --path=/path/to/wordpress

# Create missing categories
wp term create category "Tên-Danh-Mục" --description="Mô tả" --slug="slug" --path=/path/to/wordpress
```

**Required Categories for This Project:**

* Meso
* Filler
* Căng Chỉ
* \[Other categories from your data]

### ✅ Verify Image URLs

Check if image URLs are accessible:

```bash theme={null}
# Test a sample URL
curl -I https://example.com/image.jpg

# Bulk check (requires jq)
cat products.json | jq -r '.[].image' | while read url; do
  curl -s -o /dev/null -w "%{http_code} $url\n" "$url"
done
```

### ✅ Test with 1-2 Products First

**ALWAYS** test with a small batch before full import:

```bash theme={null}
# Extract first 2 products for testing
jq '.[:2]' docs/new_products_to_add.json > test_import.json
```

***

## 2. Import Methods Overview

| Method            | Difficulty | Speed          | Reliability | Best For                      |
| ----------------- | ---------- | -------------- | ----------- | ----------------------------- |
| **WP All Import** | ⭐⭐ Easy    | 🚀 Fast        | ✅ Very High | Large imports, complex data   |
| **REST API**      | ⭐⭐⭐ Medium | 🚀🚀 Very Fast | ✅ High      | Developers, automation        |
| **Native CSV**    | ⭐ Easy     | 🐢 Slow        | ⚠️ Medium   | Simple imports, small batches |

**Recommendation:** Use **WP All Import** for this project due to complex pricing structures.

***

## 3. Method A: WP All Import Plugin (Recommended)

### 3.1 Installation

```bash theme={null}
# Download WP All Import
wget https://downloads.wordpress.org/plugin/wp-all-import.3.6.6.zip

# Install via WP-CLI
wp plugin install wp-all-import --activate --path=/path/to/wordpress

# Install WooCommerce Add-On
wp plugin install wp-all-import-woocommerce --activate --path=/path/to/wordpress
```

**Or via WordPress Admin:**

1. Plugins → Add New
2. Search "WP All Import"
3. Install & Activate
4. Install "WP All Import - WooCommerce Add-On"

### 3.2 Step-by-Step Import

#### Step 1: Prepare JSON File

Convert your JSON to WP All Import compatible format:

```bash theme={null}
# Convert new_products_to_add.json
cat > /tmp/import_prepare.js << 'EOF'
const data = require('/Users/tannguyen/Documents/fullstack/triseo.drmanhlinhmd.com/docs/new_products_to_add.json');

// WP All Import format
const wpFormat = data.map(product => ({
  post_title: product.name,
  post_content: product.description || '',
  post_excerpt: product.short_description || product.name,
  post_status: 'publish',
  post_type: 'product',

  // WooCommerce fields
  meta: {
    _sku: product.sku || product.slug,
    _regular_price: product.price,
    _sale_price: product.sale_price || '',
    _price: product.sale_price || product.price,
    _stock: product.stock || 0,
    _manage_stock: product.manage_stock ? 'yes' : 'no',
    _backorders: product.backorders || 'no',
    _sold_individually: product.sold_individually ? 'yes' : 'no',
    _weight: product.weight || '',
    _length: product.length || '',
    _width: product.width || '',
    _height: product.height || '',
    _product_url: product.external_url || '',
    _button_text: product.external_button_text || 'Buy Now',
    _downloadable: product.downloadable ? 'yes' : 'no',
    _virtual: product.virtual ? 'yes' : 'no',
    _product_image_gallery: product.gallery_images.join(','),
  },

  // Categories
  categories: product.categories.map(cat => ({
    name: cat
  })),

  // Images
  images: [product.image],

  // Attributes
  attributes: product.attributes || []
}));

console.log(JSON.stringify(wpFormat, null, 2));
EOF

node /tmp/import_prepare.js > /tmp/wp_import.json
```

#### Step 2: Start Import

1. Navigate to: **All Import → New Import**
2. **\[SCREENSHOT: Select "Upload a file"]**
3. Choose: `wp_import.json`
4. Click **"Upload file and continue"**

#### Step 3: Configure Import

**\[SCREENSHOT: Drag & Drop template builder]**

**Post Title:**

* Drag `{name}` to **Title** field

**Content:**

* Drag `{description}` to **Content** field
* Drag `{short_description}` to **Excerpt** field

**Images:**

* Drag `{image}` to **Images** field
* Enable **"Download images externally"**
* Enable **"Use as featured image"**

#### Step 4: WooCommerce Fields

Click **"Configure WooCommerce Settings"**

**\[SCREENSHOT: WooCommerce field mapping]**

| WP All Import Field | Source Field     | Notes          |
| ------------------- | ---------------- | -------------- |
| SKU                 | `{sku}`          | Must be unique |
| Regular Price       | `{price}`        | Required       |
| Sale Price          | `{sale_price}`   | Optional       |
| Stock               | `{stock}`        | Default: 0     |
| Manage Stock        | `{manage_stock}` | yes/no         |
| Backorders          | `{backorders}`   | no/notify/yes  |

#### Step 5: Categories

**\[SCREENSHOT: Category mapping]**

* Drag `{categories}` to **Product Categories**
* Select: **"Match by name"**
* Enable: **"Create categories if they don't exist"**

#### Step 6: Import Options

**\[SCREENSHOT: Import settings]**

```
☑ Create new products
☐ Update existing products (matched by SKU)
☐ Auto-detect existing products
☐ Delete products that are no longer in the file
```

**Processing Mode:**

* Choose: **"Process in background"** (recommended for >100 products)

#### Step 7: Run Import

Click **"Continue & Run Import"**

**\[SCREENSHOT: Progress bar]**

* Monitor progress in real-time
* Receive email when complete

### 3.3 Advanced Features

#### Automatic Scheduling

```php theme={null}
// Schedule auto-import every hour
add_filter('wp_all_import_cron_schedules', function($schedules) {
    $schedules['hourly'] = [
        'interval' => 3600,
        'display' => 'Once Hourly'
    ];
    return $schedules;
});
```

#### Custom Field Mapping

```php theme={null}
// Add custom logic during import
add_action('pmxi_saved_post', function($post_id) {
    // Update product after import
    $product = wc_get_product($post_id);

    // Add custom meta
    update_post_meta($post_id, '_import_date', current_time('mysql'));

    // Set default attributes
    $product->set_default_attributes([
        'color' => 'red'
    ]);
    $product->save();
});
```

***

## 4. Method B: WooCommerce REST API

### 4.1 Setup Authentication

```bash theme={null}
# Generate API keys via WordPress CLI
wp user api-key create 1 --description="Product Import" --permissions=read_write --path=/path/to/wordpress
```

**Or via Admin:**

1. WooCommerce → Settings → Advanced → REST API
2. Click **"Add Key"**
3. Description: "Product Import"
4. Permissions: **Read/Write**
5. Click **"Generate API Key"**
6. **COPY** Consumer Key & Secret (you won't see them again!)

### 4.2 Prepare Import Script

Create `/tmp/import_products.js`:

```javascript theme={null}
const WooCommerceAPI = require('woocommerce-api');
const fs = require('fs');

// Configuration
const WooCommerce = new WooCommerceAPI({
  url: 'https://yoursite.com',
  consumerKey: 'YOUR_CONSUMER_KEY',
  consumerSecret: 'YOUR_CONSUMER_SECRET',
  wpAPI: true,
  version: 'wc/v3'
});

// Load products
const products = JSON.parse(
  fs.readFileSync('/Users/tannguyen/Documents/fullstack/triseo.drmanhlinhmd.com/docs/new_products_to_add.json')
);

// Transform to WooCommerce format
const transformProduct = (product) => ({
  name: product.name,
  slug: product.slug,
  type: product.type || 'simple',
  status: 'publish',
  description: product.description || '',
  short_description: product.short_description || product.name,
  sku: product.sku || product.slug,
  regular_price: product.price.toString(),
  sale_price: product.sale_price ? product.sale_price.toString() : '',
  manage_stock: product.manage_stock || false,
  stock_quantity: product.stock || 0,
  categories: product.categories.map(cat => ({ name: cat })),
  images: [
    {
      src: product.image,
      name: product.name
    }
  ],
  attributes: product.attributes || [],
  meta_data: [
    {
      key: '_external_url',
      value: product.external_url || ''
    },
    {
      key: '_external_button_text',
      value: product.external_button_text || 'Buy Now'
    }
  ]
});

// Import function
async function importProducts() {
  const results = {
    success: [],
    failed: []
  };

  for (const product of products) {
    try {
      const response = await WooCommerce.postAsync('products', transformProduct(product));
      const result = JSON.parse(response.toJSON().body);

      console.log(`✅ Imported: ${product.name}`);
      results.success.push({
        name: product.name,
        id: result.id,
        sku: result.sku
      });

      // Rate limiting: wait 500ms between requests
      await new Promise(resolve => setTimeout(resolve, 500));

    } catch (error) {
      console.error(`❌ Failed: ${product.name}`);
      console.error(error.message);
      results.failed.push({
        name: product.name,
        error: error.message
      });
    }
  }

  // Save results
  fs.writeFileSync('/tmp/import_results.json', JSON.stringify(results, null, 2));
  console.log('\n📊 Import Summary:');
  console.log(`✅ Success: ${results.success.length}`);
  console.log(`❌ Failed: ${results.failed.length}`);
}

// Run import
importProducts();
```

### 4.3 Run Import Script

```bash theme={null}
# Install dependencies
npm install woocommerce-api

# Run import
node /tmp/import_products.js

# Check results
cat /tmp/import_results.json
```

### 4.4 Update Existing Products

```javascript theme={null}
// Check if product exists by SKU
async function checkProductExists(sku) {
  const response = await WooCommerce.getAsync(`products?sku=${sku}`);
  const products = JSON.parse(response.toJSON().body);
  return products.length > 0 ? products[0].id : null;
}

// Update or create
async function upsertProduct(product) {
  const existingId = await checkProductExists(product.sku);
  const data = transformProduct(product);

  if (existingId) {
    console.log(`🔄 Updating: ${product.name}`);
    await WooCommerce.putAsync(`products/${existingId}`, data);
  } else {
    console.log(`➕ Creating: ${product.name}`);
    await WooCommerce.postAsync('products', data);
  }
}
```

### 4.5 Batch Import (WooCommerce 3.0+)

```javascript theme={null}
// Batch import (100 products at a time)
async function batchImport(products) {
  const batchSize = 100;
  const batches = Math.ceil(products.length / batchSize);

  for (let i = 0; i < batches; i++) {
    const batch = products.slice(i * batchSize, (i + 1) * batchSize);

    console.log(`\n📦 Processing batch ${i + 1}/${batches}`);

    const response = await WooCommerce.postAsync('products/batch', {
      create: batch.map(transformProduct)
    });

    console.log(`✅ Batch ${i + 1} complete`);
  }
}
```

***

## 5. Method C: Native CSV Import via WooCommerce

### 5.1 Prepare CSV Template

Create `/tmp/products_import.csv`:

```csv theme={null}
ID,Type,SKU,Name,Published,Featured,Visibility in catalog,Short description,Description,Tax status,Tax class,In stock?,Stock,Backorders,Sold individually?,Weight (kg),Length (cm),Width (cm),Height (cm),Allow customer reviews?,Purchase note,Sale price,Regular price,Categories,Tags,Images,Attribute 1 name,Attribute 1 value,Attribute 1 visible,Attribute 1 global,Attribute 2 name,Attribute 2 value,Attribute 2 visible,Attribute 2 global,Download 1 name,Download 1 URL,Download 1 limit,Meta: _external_url,Meta: _external_button_text
,simple,BRUNO-001,Bruno Vassari Product 1,1,0,visible,"Short desc here","Full description here",taxable,,1,0,no,0,,,,1,,,990000,1200000,"meso,filler","https://example.com/image.jpg",Color,Red,1,1,Size,Large,1,1,,,,https://external.com/buy,Buy Now
```

### 5.2 Convert JSON to CSV

Create `/tmp/json_to_csv.py`:

```python theme={null}
#!/usr/bin/env python3
import json
import csv

# Load JSON
with open('/Users/tannguyen/Documents/fullstack/triseo.drmanhlinhmd.com/docs/new_products_to_add.json') as f:
    products = json.load(f)

# CSV headers
headers = [
    'ID', 'Type', 'SKU', 'Name', 'Published', 'Featured',
    'Visibility in catalog', 'Short description', 'Description',
    'Tax status', 'Tax class', 'In stock?', 'Stock', 'Backorders',
    'Sold individually?', 'Weight (kg)', 'Length (cm)', 'Width (cm)',
    'Height (cm)', 'Allow customer reviews?', 'Purchase note',
    'Sale price', 'Regular price', 'Categories', 'Tags', 'Images',
    'Attribute 1 name', 'Attribute 1 value', 'Attribute 1 visible',
    'Attribute 1 global', 'Meta: _external_url', 'Meta: _external_button_text'
]

# Convert to CSV
with open('/tmp/products_import.csv', 'w', newline='', encoding='utf-8') as f:
    writer = csv.DictWriter(f, fieldnames=headers)
    writer.writeheader()

    for p in products:
        row = {
            'ID': '',
            'Type': p.get('type', 'simple'),
            'SKU': p.get('sku', p.get('slug', '')),
            'Name': p.get('name', ''),
            'Published': 1,
            'Featured': 0,
            'Visibility in catalog': 'visible',
            'Short description': p.get('short_description', ''),
            'Description': p.get('description', ''),
            'Tax status': 'taxable',
            'Tax class': '',
            'In stock?': 1 if p.get('stock', 0) > 0 else 0,
            'Stock': p.get('stock', 0),
            'Backorders': p.get('backorders', 'no'),
            'Sold individually?': 'yes' if p.get('sold_individually') else 'no',
            'Weight (kg)': p.get('weight', ''),
            'Length (cm)': p.get('length', ''),
            'Width (cm)': p.get('width', ''),
            'Height (cm)': p.get('height', ''),
            'Allow customer reviews?': 1,
            'Purchase note': '',
            'Sale price': p.get('sale_price', ''),
            'Regular price': p.get('price', ''),
            'Categories': ','.join(p.get('categories', [])),
            'Tags': '',
            'Images': p.get('image', ''),
            'Attribute 1 name': '',
            'Attribute 1 value': '',
            'Attribute 1 visible': 1,
            'Attribute 1 global': 1,
            'Meta: _external_url': p.get('external_url', ''),
            'Meta: _external_button_text': p.get('external_button_text', 'Buy Now')
        }
        writer.writerow(row)

print(f'✅ Converted {len(products)} products to CSV')
```

Run conversion:

```bash theme={null}
python3 /tmp/json_to_csv.py
```

### 5.3 Import via WooCommerce

1. Navigate to: **WooCommerce → Products → Import**
2. **\[SCREENSHOT: CSV upload screen]**
3. Choose `products_import.csv`
4. Click **"Upload file and continue"**

### 5.4 Map CSV Columns

**\[SCREENSHOT: Column mapping screen]**

**Required Mappings:**

* Name → Name
* SKU → SKU
* Regular price → Regular price
* Categories → Categories
* Images → Images

### 5.5 Run Import

Click **"Run Import"**

**\[SCREENSHOT: Import progress]**

***

## 6. Post-Import Actions

### 6.1 Verify Prices

```bash theme={null}
# Check all imported prices
wp post list --post_type=product --format=table --fields=ID,post_title --path=/path/to/wordpress | \
while read line; do
  id=$(echo $line | awk '{print $1}')
  regular=$(wp post meta get $id _regular_price --path=/path/to/wordpress)
  sale=$(wp post meta get $id _sale_price --path=/path/to/wordpress)
  echo "$id | $regular | $sale"
done
```

### 6.2 Check Sale Prices

```bash theme={null}
# Find products with sale price > regular price
wp wc product list --fields=id,name,regular_price,sale_price --path=/path/to/wordpress | \
awk -F, '{if ($4 > $3) print $0}'
```

### 6.3 Test Product Pages

```bash theme={null}
# Generate list of URLs to test
wp post list --post_type=product --format=ids --path=/path/to/wordpress | \
while read id; do
  slug=$(wp post get $id --field=permalink --path=/path/to/wordpress)
  echo "$slug"
done > /tmp/product_urls.txt

# Test with curl
cat /tmp/product_urls.txt | while read url; do
  status=$(curl -s -o /dev/null -w "%{http_code}" "$url")
  echo "$status - $url"
done
```

### 6.4 Update Inventory

```bash theme={null}
# Set inventory management
wp post list --post_type=product --format=ids --path=/path/to/wordpress | \
while read id; do
  wp post meta update $id _manage_stock 'yes' --path=/path/to/wordpress
  wp post meta update $id _stock '100' --path=/path/to/wordpress
done
```

### 6.5 Regenerate Thumbnails

```bash theme={null}
# Regenerate all product images
wp media regenerate --yes --path=/path/to/wordpress
```

### 6.6 Clear Cache

```bash theme={null}
# Clear object cache
wp cache flush --path=/path/to/wordpress

# Clear CDN cache (if using)
# Example for Cloudflare via API
curl -X DELETE "https://api.cloudflare.com/client/v4/zones/ZONE_ID/purge_cache" \
  -H "Authorization: Bearer API_TOKEN" \
  -H "Content-Type: application/json" \
  --data '{"purge_everything":true}'
```

***

## 7. Troubleshooting

### 7.1 Common Issues

#### Issue: Images Not Importing

**Symptoms:**

* Products imported but no images
* Broken image icons

**Solutions:**

1. **Check image URL accessibility:**

```bash theme={null}
curl -I https://example.com/image.jpg
# Should return 200 OK
```

2. **Enable "Download images externally":**
   * WP All Import: Images section → Enable "Download externally hosted images"

3. **Check file permissions:**

```bash theme={null}
# Fix upload directory permissions
chmod 755 /path/to/wordpress/wp-content/uploads
chown www-data:www-data /path/to/wordpress/wp-content/uploads
```

4. **Increase memory limits:**

```php theme={null}
// Add to wp-config.php
define('WP_MEMORY_LIMIT', '512M');
```

#### Issue: Duplicate SKUs

**Symptoms:**

* Import fails with "SKU already exists"
* Products not updating

**Solutions:**

1. **Find duplicates:**

```sql theme={null}
SELECT meta_value, COUNT(*) as count
FROM wp_postmeta
WHERE meta_key = '_sku'
AND meta_value != ''
GROUP BY meta_value
HAVING count > 1;
```

2. **Remove duplicates:**

```sql theme={null}
DELETE p1 FROM wp_posts p1
INNER JOIN wp_posts p2
WHERE p1.ID > p2.ID
AND p1.post_type = 'product'
AND p1.post_title = p2.post_title;
```

3. **Update import strategy:**
   * Enable "Update existing products"
   * Match by: SKU

#### Issue: Categories Not Mapping

**Symptoms:**

* Products import but no categories
* All products in "Uncategorized"

**Solutions:**

1. **Check category slugs:**

```bash theme={null}
wp term list category --format=table --path=/path/to/wordpress
```

2. **Create missing categories:**

```bash theme={null}
# From CSV
while IFS=, read -r name slug; do
  wp term create category "$name" --slug="$slug" --path=/path/to/wordpress
done < categories.csv
```

3. **Verify mapping:**
   * WP All Import: Categories → Match by "name" (not slug)
   * Enable "Create categories if they don't exist"

#### Issue: Import Timeout

**Symptoms:**

* Import stops after 30-60 seconds
* Only some products imported

**Solutions:**

1. **Increase PHP limits:**

```php theme={null}
// In wp-config.php
@ini_set('max_execution_time', '300');
@ini_set('upload_max_filesize', '50M');
@ini_set('post_max_size', '50M');

// In .htaccess
php_value max_execution_time 300
php_value upload_max_filesize 50M
php_value post_max_size 50M
```

2. **Use background processing:**
   * WP All Import: Enable "Process in background"
   * Set lower batch size: 50 products per batch

3. **Split large files:**

```bash theme={null}
# Split JSON into 100-product chunks
split -l 100 products.json chunk_
```

#### Issue: Special Characters Not Displaying

**Symptoms:**

* Vietnamese characters show as question marks
* Accented letters broken

**Solutions:**

1. **Check database charset:**

```sql theme={null}
SHOW VARIABLES LIKE 'character_set%';
-- Should be: utf8mb4
```

2. **Convert to UTF-8:**

```bash theme={null}
# Convert CSV to UTF-8
iconv -f ISO-8859-1 -t UTF-8 products.csv > products_utf8.csv
```

3. **Set charset in wp-config.php:**

```php theme={null}
define('DB_CHARSET', 'utf8mb4');
define('DB_COLLATE', 'utf8mb4_unicode_ci');
```

### 7.2 Error Codes Reference

| Error Code                               | Meaning                | Solution                          |
| ---------------------------------------- | ---------------------- | --------------------------------- |
| `woocommerce_rest_product_invalid_sku`   | SKU already exists     | Use unique SKU or update existing |
| `woocommerce_rest_invalid_image`         | Invalid image URL      | Check URL returns 200 OK          |
| `woocommerce_rest_invalid_category`      | Category doesn't exist | Create category first             |
| `woocommerce_rest_product_missing_price` | Price required         | Add regular\_price                |
| `500 Internal Server Error`              | Server error           | Check PHP error logs              |

### 7.3 Enable Debug Mode

```php theme={null}
// In wp-config.php
define('WP_DEBUG', true);
define('WP_DEBUG_LOG', true);
define('WP_DEBUG_DISPLAY', false);

// Check logs
tail -f /path/to/wordpress/wp-content/debug.log
```

***

## 8. Reference Files

### 8.1 Data Sources

**New Products to Add:**

```
/Users/tannguyen/Documents/fullstack/triseo.drmanhlinhmd.com/docs/new_products_to_add.json
```

**Bruno Vassari Products:**

```
/Users/tannguyen/Documents/fullstack/triseo.drmanhlinhmd.com/docs/bruno_vassari_wp_products.json
```

### 8.2 File Formats

#### Expected JSON Structure

```json theme={null}
[
  {
    "name": "Product Name",
    "slug": "product-slug",
    "sku": "PROD-001",
    "type": "simple",
    "description": "Full product description",
    "short_description": "Short excerpt",
    "price": "1000000",
    "sale_price": "990000",
    "manage_stock": true,
    "stock": 50,
    "categories": ["Category 1", "Category 2"],
    "image": "https://example.com/image.jpg",
    "images": [
      "https://example.com/image1.jpg",
      "https://example.com/image2.jpg"
    ],
    "attributes": [
      {
        "name": "Color",
        "value": "Red",
        "visible": true,
        "variation": false
      }
    ]
  }
]
```

### 8.3 Quick Reference Commands

```bash theme={null}
# List all products
wp wc product list --fields=id,name,sku,price,stock --path=/path/to/wordpress

# Get product by SKU
wp wc product get --sku=BRUNO-001 --path=/path/to/wordpress

# Delete all products (DANGER!)
wp wc product delete $(wp wc product list --format=ids --path=/path/to/wordpress) --force

# Export products to CSV
wp wc product export --path=/path/to/wordpress > products_export.csv

# Count products
wp wc product list --format=count --path=/path/to/wordpress
```

***

## 9. Best Practices

### ✅ DO:

* Always backup before importing
* Test with 2-5 products first
* Use unique SKUs
* Optimize images before import (max 1500px, under 500KB)
* Clean data before import (remove special chars, trim spaces)
* Use background processing for >100 products
* Monitor server resources during import
* Keep import logs for troubleshooting

### ❌ DON'T:

* Import thousands of products without testing
* Use spaces or special chars in SKUs
* Skip category creation
* Ignore error messages
* Import during peak traffic hours
* Forget to clear cache after import
* Assume everything worked without verification

***

## 10. Support Resources

**Documentation:**

* [WP All Import Docs](https://www.wpallimport.com/documentation/)
* [WooCommerce REST API](https://woocommerce.github.io/woocommerce-rest-api-docs/)
* [Native CSV Import](https://woocommerce.com/documentation/importing-woocommerce-products-csv/)

**Tools:**

* WP-CLI: [https://wp-cli.org/](https://wp-cli.org/)
* WooCommerce CLI: [https://github.com/woocommerce/wp-cli-cli](https://github.com/woocommerce/wp-cli-cli)

**Community:**

* WordPress.org Forums
* WooCommerce Slack Community
* Stack Overflow (tag: woocommerce)

***

## Appendix A: Import Workflow Checklist

### Before Import:

* [ ] Backup database
* [ ] Backup uploads folder
* [ ] Verify image URLs accessible
* [ ] Create all categories
* [ ] Test with 1-2 products
* [ ] Review JSON structure
* [ ] Clean data (remove duplicates, fix SKUs)

### During Import:

* [ ] Monitor progress
* [ ] Check for errors
* [ ] Verify server resources
* [ ] Watch error logs

### After Import:

* [ ] Verify product count
* [ ] Check sample products
* [ ] Test prices (regular & sale)
* [ ] Verify categories
* [ ] Test product pages
* [ ] Check images load
* [ ] Update inventory
* [ ] Clear cache
* [ ] Test checkout
* [ ] Revoke API keys (if used)

***

**End of Guide**

For questions or issues, refer to troubleshooting section or consult WordPress/WooCommerce documentation.