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 and I want to load them into WooCommerce. Iwill paste the rows below. The columns are [name, SKU, price, category,description, image link, and for variable rows a size or color]. Do notcreate anything yet.
[paste the rows]
First pass, change nothing: read the sheet, map each column to the matchingproduct field, and show me the first [5] products exactly as they would becreated. Flag any row missing a name or price so I can fix it, and list anyproduct 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 canonly create simple products, so list the variable rows separately and I willadd 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 mewhat landed. Then add the size or color variations for the variable rowsunder the IDs I give you. At the end, give me the id for every product andvariation 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.