How to Add Products from a Spreadsheet with Max AI

Updated
Feature Availability User Permissions Time to Complete Skill Level
Launch, Grow, Scale and Trial. Not available on Free Store owner, or a team member who has Max AI in their sidebar and can manage products About 10 minutes Beginner

Summary

Overview: If your product list doesn't follow Prosperna's import template, you don't have to rearrange it. Attach the CSV file to the Merchandiser agent in Max AI, and Max reads it row by row, works out what each column means, and shows you the products it will add. Nothing is saved until you click Approve, and everything it adds comes in as an unpublished draft.

Prerequisites:

  • Max AI set up and AI Credits in your balance. See How to Get Started with Max AI.
  • A store location, because products are stocked per location. See How to Add Your Store Location.
  • Your product list saved as a CSV file, with a header row and at least one row of products.

Step-by-Step Instructions

Step 1: Open the Merchandiser

  1. In the sidebar, click Max AI.
  2. On Choose who you want to work with to get started., click Start chatting on the Merchandiser card. If you're already in a chat, click the agent button in the message box and choose Merchandiser.

Step 2: Attach your file

  1. In the message box, click the + button, then Media Library (the paperclip).
  2. In the media library, switch the type list to Documents. Pick your CSV file, or upload it first if it isn't there yet.

Your file can have any columns, in any order, with any names. You don't need Prosperna's template.

Step 3: Ask Max to add the products

In the same message, say what you want and anything Max needs to know about your columns, for example:

Add the products in this file to my store. SRP is the price and Dealer is the cost.

Max shows its progress as it works: Reading your file…, then Working out your [number] columns…, then Checking [number] products with your store…

Step 4: Answer anything Max still needs

Your store needs a category for every product, and shipping needs a package size and weight. If your file doesn't have them, Max asks you once, in a single message, for:

  • one category to put the products in, and
  • one typical package size in centimetres and weight in grams, for example 20 x 15 x 10 cm, 500 g.

Answer in the chat and Max carries on with the same file.

Step 5: Check what Max read

Max replies with:

  • how it read each of your columns, for example SRP → Price, with a sample value from your first row
  • every product it's ready to add, with its price, category, stock and how many images it found
  • any rows that can't be added, each with the row number and the reason

Read this list before you approve. If a column was read wrongly, decline and tell Max how to read it, for example Cost is the dealer price. Max prepares the file again.

Step 6: Approve

  1. Above the message box, a card marked Needs your approval asks Add [number] products as unpublished drafts? Check the table of products on it.
  2. Click Approve to add them, or Decline to add nothing.

If you decline, Max replies No problem, nothing was added. and you can tell it how to read the file differently.

Step 7: Review and publish

After you approve, Max copies any image links (up to 5 per product) into your Media Library, saves the products in batches, and finishes with a summary: how many were added as unpublished drafts, any saved with a note, and any that weren't saved.

The products are drafts, so shoppers see nothing yet. Open Products → Inventory to review them and publish the ones you want to sell, or ask Max to publish them. See How to Edit, Publish or Delete a Product.

Verify It Worked

Success criteria:

  • Max's summary reads Done. [number] product(s) added as unpublished drafts.
  • The new products appear in Products → Inventory, unpublished.

Troubleshooting

Common errors

  • "Import products feature is only available to paid plan merchants.": your store is on the Free plan. Subscribe to Launch, Grow or Scale first.
  • "Only CSV files can be imported for now. Save the sheet as CSV and attach it again.": the file isn't a CSV. In your spreadsheet app, save or export as CSV and attach the new file.
  • "The file is not readable text. Save it as CSV (UTF-8) and attach it again.": the file couldn't be read as text. Save it as CSV with UTF-8 encoding.
  • "The file has no rows under its header.": the file has column names but no products. Add your rows and attach it again.
  • "I could not find that file in your Media Library. Attach it again." or "I could not download that file. Attach it again.": attach the file once more.
  • "Could not read the columns. Please try again.": Max couldn't work out your columns. Send the message again, and say what the important columns mean.
  • "No row could become a product." or "The store refused every row.": no row had enough to make a product, or your store turned them all down. Max lists the reasons; the most common are a missing product name and a price above the store's limit.
  • A row says "Product SKU already exists in the database.": you already have a product with that SKU. Change the SKU in the file, or leave it out.
  • A row says the price is above ₱3,500,000: that's the highest price a product can have. Lower it in the file and attach it again.

Limitations & considerations

  • Only the first 500 rows of a file are read. Send the rest as a second file.
  • Products added this way are always simple physical products. They can't carry variants: extra rows that share a product add images only. For variants, use Prosperna's import template instead (see How to Import Products in Bulk).
  • Products are always added unpublished. They're never published straight from the file.
  • This adds new products. It doesn't update products you already have. To update existing products, export them and use the template import (see How to Import Products in Bulk).
  • Image links in your file are copied into your Media Library, up to 5 per product. A link Max can't open is noted against the product, and the product is still saved.
  • Each import uses AI Credits.
  • Max shows one approval card at a time.

Next Steps & Related Resources


Need more help? For more information and assistance, please send an email to support@prosperna.com.

Last Updated: 11/20/2026