WooCommerce4 min read

How to Import WooCommerce Products from Excel With Only a Name and Stock Quantity

You can import products into WooCommerce with just a name and stock quantity. Follow this example to create four drafts from an Excel file, verify their quantities and confirm that their prices are blank.

WooCommerce product spreadsheet ready for import

1. Download the two-column Excel file

The Products worksheet has one header row and four sample products. Stock quantity uses whole numbers. The zero in the Oak Cutting Board row is intentional.

The four products in the example workbook
Product nameStock quantity
Ceramic Mug12
Linen Tote Bag7
Oak Cutting Board0
Glass Carafe4

2. Upload the workbook and map both columns

With WooCommerce and the Cormak.app plugin active, open Products → Fill with AI ✦ → Import a file. Use Choose a file to upload the XLSX. Select Products as the sheet and check that Header row is 1.

Map Product name to Product name and Stock quantity to Stock quantity. Check the preview for all four rows. A dash in the price column means the draft’s regular price will be empty.

Cormak importer mapping Product name and Stock quantity from the Products sheet and previewing four rows with blank prices
Both columns are mapped. The preview shows four products, stock quantities of 12, 7, 0 and 4, and blank prices.

3. Create four drafts without AI

Clear all selected fields under Texts and leave How many photos set to No photos. When the button reads “Create drafts · 0 credits”, click it.

Wait for the four products to finish, then open the edit links or go to Products → All Products → Drafts. Creating drafts this way uses zero credits and works without a Cormak account.

WooCommerce Products list showing four drafts with quantities 12, 7, 0 and 4 and blank prices
The four imported products are drafts. The Oak Cutting Board has zero stock, and the price column is empty for every row.

4. Verify stock and blank prices

Open Ceramic Mug. In Product data → Inventory, check that Track stock quantity for this product is enabled and Quantity is 12. Under General, check that Regular price and Sale price are both empty.

WooCommerce Inventory tab showing stock management enabled and quantity 12 for Ceramic Mug
In Product data → Inventory, Ceramic Mug has stock tracking enabled and a quantity of 12.

Repeat for Linen Tote Bag (7), Oak Cutting Board (0) and Glass Carafe (4). Confirm each product has Draft status. Set the selling price and check the stock, shipping weight and product details before publishing.

5. Add product content when you’re ready

The file import is complete once the drafts are saved. To generate descriptions or photos, connect Cormak, select the drafts under All Products, and choose Fill with Cormak.app from Bulk actions. Review the selected fields and credit estimate before clicking Start. Check the generated copy, categories, attributes and photos for accuracy before publishing.

PRACTICE OVER THEORY

Turn the next step into one sentence.

Try Cormak Free 5 AI credits monthly · no credit card required