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 UploadCopied!

  • 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 InterfaceCopied!

  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 UploadCopied!

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

Step-by-Step InstructionsCopied!

  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
    • Use the property mapping feature to map your custom field names to our expected field names
  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 TemplateCopied!

Your CSV file should include these required columns:

Column Description Example
product_id Unique product identifier prod_12345
name Product name Ergonomic Office Chair
description Product description Premium office chair with lumbar support
price Product price 299.99
currency Currency code USD
image_url Primary image URL https://example.com/images/chair.jpg

Optional columns include:

Column Description Example
categories Product categories (comma-separated) Furniture,Office
tags Product tags (comma-separated) ergonomic,comfortable
inventory_count Stock quantity 42
variant_id Variant identifier var_789
variant_attributes Variant details (JSON string) {"color":"Black","size":"Large"}

Sample CSVCopied!

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 UploadCopied!

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

JSON Upload InstructionsCopied!

  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 FormatCopied!

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 ProgressCopied!

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 ErrorsCopied!

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

Property MappingCopied!

Youzu.ai expects product data with specific attribute names, but we understand that your data may use different naming conventions. Our property mapping feature allows you to easily map your property names to our expected format without changing your original data.

Using Property Mapping in the DashboardCopied!

  1. During the CSV or JSON import process, after uploading your file, you'll see the Property Mapping section
  2. The system will attempt to automatically map recognized fields
  3. For any fields that need manual mapping, use the dropdown selectors to choose the corresponding Youzu.ai attribute

Example Property MappingCopied!

Your Property Name Youzu.ai Expected Property
item_id product_id
title name
long_description description
retail_price price
primary_image image_url
product_type categories
product_attributes metadata

Saving Mapping TemplatesCopied!

If you frequently import data with the same structure:

  1. After configuring your mappings, click Save Mapping Template
  2. Give your template a descriptive name (e.g., "Shopify Export Format")
  3. For future imports, select your saved template from the dropdown menu

Tips for Successful ImportsCopied!

  1. Start small - Test with a small batch of products before doing a full import
  2. Validate your data - Check your CSV or JSON file format before uploading
  3. Use high-quality images - Include clear, high-resolution product images
  4. Include rich descriptions - Detailed product descriptions improve AI recognition
  5. Add multiple categories - Proper categorization enhances product discovery

Exporting ProductsCopied!

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

For further assistance with manual product uploads, contact our support team at support@youzu.ai.