Manual Dashboard Upload

Manual dashboard upload provides a user-friendly interface for uploading product data directly through the Youzu.ai dashboard. This approach is ideal for smaller catalogs or for testing purposes.

Benefits of Manual Upload

• No coding required - Simple user interface for non-technical users
• Immediate feedback - See upload progress and validation errors in real-time
• Visual confirmation - Preview product data before finalizing the import
• Flexible for testing - Easily experiment with different product data formats

Accessing the Upload Interface

1. Log in to your Youzu.ai dashboard at dashboard.youzu.ai
2. Navigate to Products > Import
3. Select either CSV Upload or JSON Upload based on your data format

CSV Upload

The CSV upload interface allows you to upload product data in a structured tabular format.

Step-by-Step Instructions

1. Prepare your CSV file

   • Ensure your file includes all required columns (see Template below)
   • Save your file as UTF-8 encoded CSV

2. Upload the file

   • Click Choose File or drag and drop your CSV file into the designated area
   • Select your file encoding (default: UTF-8)
   • Choose your column delimiter (default: comma)

3. Review column mapping

   • The system will auto-detect column headers
   • Verify that each column is correctly mapped to the appropriate product attribute
   • Adjust any incorrect mappings using the dropdown selectors

4. Configure import options

   • Select how to handle existing products (update or skip)
   • Choose whether to delete products not included in the import
   • Set image handling preferences

5. Begin import

   • Click Start Import to begin processing your file
   • Monitor the progress bar for real-time feedback

CSV Template

Your CSV file should include these required columns:

Optional columns include:

Sample CSV

product_id,name,description,price,currency,image_url,categories,tags
prod_12345,Ergonomic Office Chair,Premium office chair with lumbar support,299.99,USD,<https://example.com/images/chair.jpg>,"Furniture,Office","ergonomic,comfortable"
prod_67890,Standing Desk,Adjustable height standing desk,499.99,USD,<https://example.com/images/desk.jpg>,"Furniture,Office","standing,adjustable"

JSON Upload

The JSON upload interface allows you to upload more complex product data with nested attributes.

JSON Upload Instructions

1. Prepare your JSON file

   • Structure your file according to the required format below
   • Ensure your file is valid JSON

2. Upload the file

   • Click Choose File or drag and drop your JSON file into the designated area

3. Configure import options

   • Select how to handle existing products (update or skip)
   • Choose whether to delete products not included in the import

4. Begin import

   • Click Start Import to begin processing your file
   • Monitor the progress bar for real-time feedback

JSON Format

Your JSON file should follow this structure:

{
  "products": [
    {
      "product_id": "prod_12345",
      "name": "Ergonomic Office Chair",
      "description": "Premium office chair with lumbar support",
      "price": 299.99,
      "currency": "USD",
      "images": [
        {
          "url": "<https://example.com/images/chair_front.jpg>",
          "position": 1,
          "alt": "Front view of office chair"
        },
        {
          "url": "<https://example.com/images/chair_side.jpg>",
          "position": 2,
          "alt": "Side view of office chair"
        }
      ],
      "categories": ["Furniture", "Office"],
      "tags": ["ergonomic", "office", "comfortable"],
      "variants": [
        {
          "id": "var_789",
          "attributes": {
            "color": "Black",
            "material": "Leather"
          }
        }
      ],
      "metadata": {
        "inventory_count": 42,
        "featured": true
      }
    },
    {
      "product_id": "prod_67890",
      "name": "Standing Desk",
      "description": "Adjustable height standing desk",
      "price": 499.99,
      "currency": "USD",
      "images": [
        {
          "url": "<https://example.com/images/desk.jpg>",
          "position": 1,
          "alt": "Standing desk"
        }
      ],
      "categories": ["Furniture", "Office"],
      "tags": ["standing", "adjustable", "ergonomic"],
      "metadata": {
        "inventory_count": 15,
        "featured": false
      }
    }
  ]
}

Monitoring Import Progress

After starting an import, you can monitor its progress on the import status page:

1. View real-time statistics including:

   • Total products processed
   • Products successfully imported
   • Products with errors
   • Estimated time remaining

2. Once complete, you'll see a summary including:

   • Total import time
   • Number of products added
   • Number of products updated
   • Number of products with errors

Handling Import Errors

If your import has errors, you can download a detailed error report:

1. Click Download Error Report on the import summary page
2. The report will include:
   • Row number (for CSV imports)
   • Product ID
   • Error description
   • Recommended fixes

Common errors include:

• Missing required fields
• Invalid image URLs
• Duplicate product IDs
• Invalid price formats

Exporting Products

You can also export your existing products to use as a template:

1. Navigate to Products > Export
2. Select your desired format (CSV or JSON)
3. Choose which product attributes to include
4. Click Export Products
5. Download the generated file