WooCommerce Cost of Goods Importer

Cost of Goods Sold (COGS) is a core WooCommerce feature, off by default. Turn it on at WooCommerce → Settings → Advanced → Features → “Cost of Goods Sold.” Once it's on, the product CSV importer and exporter read and write a “Cost of goods” column; while the feature is off, that column is ignored even if it's in the file.

Upload a sheet with a SKU column and a cost column (common names like “Cost”, “Cost Price” or “Wholesale Cost” are matched automatically). If your file also has a price column, the tool shows the margin those costs imply.

1. 01

   Turn on the feature

   WooCommerce → Settings → Advanced → Features → “Cost of Goods Sold.” Costs won't import without this.

2. 02

   Upload your cost sheet

   A SKU column and a cost column are enough. Choose whether the rows are simple products or variations.

3. 03

   Re-import

   Download the file and import it at Products → All Products → Import with “Update existing products” checked. Rows are matched by SKU.

• If the Cost of Goods Sold feature is off, the imported cost column is silently ignored, not an error.
• Rows with no SKU, or no usable number in the cost column, are skipped and listed so you can fix the source file.
• For a variation's cost, set “These rows are” to Variations and use each variation's own SKU, not the parent's.