Bulk-import products from a spreadsheet

Loading a product catalog by hand is the job everyone dreads: open the New Product screen, paste a name, set a price, pick a category, upload an image, save, repeat two hundred times. Somewhere around row thirty the attention goes and the typos start.

This hands the repetitive part to the agent and keeps the sheet as your source of truth. It reads your columns, shows you a few finished products before it commits, and creates everything as a draft so nothing goes live until you have looked at it.

I have a spreadsheet of products at [products.csv] and I want to load them
into WooCommerce. The columns are [name, SKU, price, category, description,
image, and for variable rows a size or color]. Do not create anything yet.

First pass, change nothing: read the sheet, map each column to the matching
product field, and show me the first [5] products exactly as they would be
created. Flag any row missing a name or price so I can fix it, and list any
product attribute the sheet needs that does not exist on the store yet.

Create everything as a draft so nothing goes live until I review it. Once I
approve the sample, create the products in batches of [20], uploading each
image and building the size or color variations for variable rows, and pause
after every batch to show me what landed. At the end, give me the id and edit
link for every product you created.

Why this is safe to run

The whole first pass is planning. Reading the sheet and mapping columns creates nothing, so you see finished-looking products as a sample before a single one exists. Anything half-filled gets flagged and set aside rather than turned into a broken listing.

When the writing starts, every product lands as a draft, so nothing reaches a shopper until you publish it, and a draft you do not want is a trash away. The WooCommerce abilities are off until you enable them, every create is checked against the manage-WooCommerce capability of the user you bound the agent to, and every one lands in the Activity Log with the product it made. The batch pauses give you a natural place to stop if the first twenty do not look right.

Already connected? You do not have to paste this. Ask your agent for the “bulk-import products from a spreadsheet” recipe, or just point it at your sheet, and it runs the same dry-run-then-batches flow on your own store.