📊 Import/Export Manager

Export: Click "Export Products" to download all products as CSV
Import: Click "Import Products", upload CSV, optionally check "Update existing records"

Required columns: sku, name, price

Optional columns: product_id, model, description, meta_title, meta_description, meta_keyword, quantity, status, category_ids, weight, dimensions, images

category_ids format: Comma-separated numbers like "1,5,12"

status: 1 = enabled, 0 = disabled

Export: Click "Export Categories"
Import: Click "Import Categories", upload CSV

Required columns: name

Optional columns: category_id, description, meta_title, meta_description, meta_keyword, parent_id, sort_order, status

parent_id: 0 for top-level category, or ID of parent category for subcategories

Export: Click "Export Attributes"
Import: Click "Import Attributes", upload CSV

Required columns: name

Optional columns: attribute_id, sort_order

Export: Click "Export Product Attributes"
Import: Click "Import Product Attributes", upload CSV

Required columns: product_id, attribute_name, attribute_value

attribute_name must match existing attribute exactly (case-sensitive)

attribute_value is the actual value like "Red", "Large", "Cotton"

Click "Export Master" to download everything in one file:

• All products with category assignments
• All categories with parent relationships
• All attributes
• All product-attribute links

File has section markers: [PRODUCTS], [CATEGORIES], [ATTRIBUTES], [PRODUCT_ATTRIBUTES]

Click "Import Master", upload master file

System automatically:

• Processes sections in correct order
• Preserves all relationships (products → categories, products → attributes)
• Shows real-time progress for each section

1. Export products
2. Edit prices in Excel
3. Save as CSV
4. Import with "Update existing" checked

1. Note category ID (e.g., 5)
2. Export products
3. For each product, edit category_ids: "1,7" becomes "1,7,5"
4. Import with "Update existing" checked

1. Click "Export Master"
2. Save file with descriptive name: backup_2024-12-02.csv
3. Keep for disaster recovery or migrations

1. Empty all tables (or use fresh database)
2. Click "Import Master"
3. Upload backup file
4. Wait for completion (shows progress)