Spreadsheet Import

Spreadsheet Import allows you to upload products using a CSV or Excel file. This is ideal when you have existing product data or need to process products from image URLs.

Import Types

Image URL Import

Upload a spreadsheet with image URLs:

• merchi.ai downloads images from URLs
• Processes them to generate content
• Creates products with your provided data

Scrape Import

Upload a spreadsheet with product page URLs:

• merchi.ai visits each page
• Extracts images and existing content
• Generates enhanced descriptions

Preparing Your Spreadsheet

File Formats

Supported formats:

• CSV (.csv)
• Excel (.xls, .xlsx)

Required Columns

For Image URL Import:

Column	Description
product_id	Unique product identifier
image_url	URL to the product image

For Scrape Import:

Column	Description
product_id	Unique product identifier
url	Product page URL to scrape

Optional Columns

You can include any additional columns that would help generate better content. Here are some examples:

Column	Description
category	Product category/taxonomy
brand	Brand name
title	Existing title (can be enhanced)
description	Existing description
price	Product price
sku	Alternative product identifier

Feel free to add any other columns with information that would be useful for content generation—the more context you provide, the better the output will be.

Import Process

Step 1: Select Import Type

1. Go to Add Products
2. Choose Product Spreadsheet or Scrape Spreadsheet

Step 2: Upload File

1. Click to browse or drag and drop
2. Select your CSV or Excel file
3. Wait for file to be parsed

Step 3: Map Columns

The importer will show detected columns:

1. Verify column mappings
2. Map required fields (product_id, image_url/url)
3. Map any additional fields you want to use

Step 4: Select Model

Choose the AI model for processing:

• Select from available models
• Different models may produce different results

Step 5: Start Import

1. Review your settings
2. Click Start Import
3. Wait for processing to complete

Image URL Requirements

For Image URL Import:

• URLs must be publicly accessible
• Direct links to image files
• Supported formats: JPEG, PNG, GIF, WebP, AVIF, TIFF, BMP, SVG

Example URLs:

https://example.com/images/product-001.jpg
https://cdn.mystore.com/products/SKU123/main.png

Column Mapping

Automatic Detection

The importer attempts to detect columns:

• Recognizes common column names
• Suggests appropriate mappings
• Shows preview of data

Manual Mapping

For unrecognized columns:

1. Select the target field from dropdown
2. Verify sample data looks correct
3. Skip columns you don’t need

Multiple Images

To import multiple images per product:

• Use separate rows for each image
• Keep the same product_id
• Different image_url for each row

Example:

product_id,image_url
SKU-001,https://example.com/sku001-front.jpg
SKU-001,https://example.com/sku001-back.jpg
SKU-001,https://example.com/sku001-detail.jpg
SKU-002,https://example.com/sku002-main.jpg

Best Practices

Data Quality

• Ensure URLs are valid and accessible
• Use consistent product IDs
• Clean up data before import
• Remove duplicates

Image Quality

• Use high-resolution image URLs
• Verify images are publicly accessible
• Test a few URLs before bulk import

Start Small

• Test with 5-10 products first
• Verify results meet expectations
• Then import larger batches

Troubleshooting

Images Not Downloading

• Verify URLs are publicly accessible
• Check for authentication requirements
• Ensure URLs aren’t blocked

Mapping Issues

• Check column headers for typos
• Verify data format in cells
• Try renaming columns to match expected names

Import Failures

• Check spreadsheet for errors
• Verify all required columns present
• Look for special characters in data

After Import

Once import completes:

1. Go to All Products View
2. Filter to see new products
3. Review generated content
4. Approve or edit as needed