Bulk-import products from a spreadsheet

WooCommerceAdvanced~45 minUpdated

Before you start

A connected store with the WooCommerce integration enabled and its product write abilities on, plus media upload if your sheet has image links. Create product only makes simple products, so for a variable row you add the empty variable product in WooCommerce first and the agent then adds its variations. Image links must point straight at the file: a link that redirects is refused.

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.

The prompt
I have a spreadsheet of products and I want to load them into WooCommerce. I
will paste the rows below. The columns are [name, SKU, price, category,
description, image link, and for variable rows a size or color]. Do not
create anything yet.
[paste the rows]
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. You can
only create simple products, so list the variable rows separately and I will
add those as empty variable products in WooCommerce and give you their IDs.
Once I approve the sample, create the simple products in batches of [20],
pulling in each image from its link, and pause after every batch to show me
what landed. Then add the size or color variations for the variable rows
under the IDs I give you. At the end, give me the id for every product and
variation you created.

Why this is safe to run

The whole first pass is planning. Reading the pasted rows 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.

How it works

  1. Read the spreadsheet columns you name and map each one to a product field, changing nothing.
  2. Create any global attributes the sheet needs that do not exist on the store yet.
  3. Show a sample of the first few products exactly as they would be created, and wait for your approval.
  4. Create the approved simple products as drafts in small batches, pulling in each image from its link.
  5. List the variable rows for you to add in WooCommerce as empty variable products, then build their variations under the IDs you give it.
  6. Report the id of every product and variation it created, batch by batch.

Questions

Will this touch products I already have?
No. It only creates new products from the rows you hand it. Nothing already in your catalog is updated or deleted, and you approve a sample before the first batch runs.
Can it import variable products?
Only the variations. The Create product tool makes simple products and refuses a variable one. For each variable row you add the empty product in WooCommerce, set to Variable product with its attributes ticked Used for variations, and the agent then creates the variations under it from your sheet.
What happens to a row that is missing a name or price?
The agent flags incomplete rows in the dry run and skips them instead of creating a broken product, so you can fix the sheet and rerun just those rows.