# 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

# 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

# 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

# Extract first 2 products for testing
jq '.[:2]' docs/new_products_to_add.json > test_import.json

# 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

# 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

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

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

// 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();
});

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

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();

# Install dependencies
npm install woocommerce-api

# Run import
node /tmp/import_products.js

# Check results
cat /tmp/import_results.json

// 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);
  }
}

// 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`);
  }
}

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

#!/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')

python3 /tmp/json_to_csv.py

# 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

# 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}'

# 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

# 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

# Regenerate all product images
wp media regenerate --yes --path=/path/to/wordpress

# 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}'

curl -I https://example.com/image.jpg
# Should return 200 OK

# Fix upload directory permissions
chmod 755 /path/to/wordpress/wp-content/uploads
chown www-data:www-data /path/to/wordpress/wp-content/uploads

// Add to wp-config.php
define('WP_MEMORY_LIMIT', '512M');

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

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;

wp term list category --format=table --path=/path/to/wordpress

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

// 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

# Split JSON into 100-product chunks
split -l 100 products.json chunk_

SHOW VARIABLES LIKE 'character_set%';
-- Should be: utf8mb4

# Convert CSV to UTF-8
iconv -f ISO-8859-1 -t UTF-8 products.csv > products_utf8.csv

define('DB_CHARSET', 'utf8mb4');
define('DB_COLLATE', 'utf8mb4_unicode_ci');

// 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

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

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

[
  {
    "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
      }
    ]
  }
]

# 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