Bulk import products from a spreadsheet with AI

Turn a supplier spreadsheet, catalog, or Google Sheet into WooCommerce products with prices, categories, and images, brought in as drafts you review before they go live.

Difficulty Intermediate

Time ~15 min

Tools rest_api, upload_media

Prerequisites

A connected site with WooCommerce active, your product data in a spreadsheet or document, and a backup if the store already has orders.

The prompt

Import these products into my WooCommerce store: [paste your spreadsheet rows, or attach the file, or share the Google Sheet].

Map the columns like this: [Name to product name, Price to regular price, SKU to sku, Category to product category, Image to product image URL, Description to short description]. If a category does not exist yet, create it first and then assign the product to it. If an image is given as a URL, pull it into the media library and set it as the product image.

Create everything as draft first so nothing goes live yet. When you are done, list every product you created with its price, SKU, and category so I can spot-check them, and tell me the total count. Do not publish or change any of my existing products.

Already connected to WPVibe?

Skip the copy-paste. Just ask your AI for the “Bulk import products from a spreadsheet with AI” recipe, or describe the task, and WPVibe runs these steps on your own site.

You have a product catalog sitting in a spreadsheet, a supplier PDF, or a shared Google Sheet, and getting it into WooCommerce means either typing every product in by hand or wrestling with a paid import plugin and its column-mapping screens. SKUs, categories, and image matching are exactly where those imports tend to break, so the file stays on your desktop.

Paste or attach your catalog and WPVibe turns each row into a WooCommerce product with its price, SKU, description, category, and image over the REST API. It creates the categories that do not exist yet, pulls images in from a URL, and can bring the whole batch in as drafts first so you review everything before a single product goes live.

Tell it which spreadsheet column maps to which field, then hand it the file. Ask it to import as drafts and to list every product it created with the price and category so you can spot-check a handful before you publish the batch. Keep a backup first if you are importing into a store that already has live orders.

Outcome

Your catalog loaded into WooCommerce as draft products with prices, SKUs, categories, and images, ready for you to review and publish.