CSV Import and Export

You can bulk update costs using the built-in CSV Export/Import tools in:
WooCommerce → Settings → Cost of Goods by PixelYourSite

This is the fastest way to update hundreds (or thousands) of products without editing them one by one.

---

Typical workflow (recommended)

1. Export Products CSV
2. Edit the file (Excel / Google Sheets) and add or update costs
3. Import Products CSV back into the plugin
4. (Optional) Recalculate past orders if you want historical profit updated

---

Export

Export Products CSV

Downloads a CSV with your products, including fields like:

• itemID (product/variation ID)
• Name
• costofgoodstype (fix / percent)
• costofgoods_value

Use this when you want to fill in missing costs or change many costs at once.

Export Product Categories CSV

Downloads a CSV for category-level costs (your category fallback rules).
Use this if you prefer to set costs at category level instead of per product.

---

Import

1. Click Download sample CSV (so you keep the correct format).
2. Fill in / edit the fields:
   • itemID
   • costofgoodstype (fix or percent)
   • costofgoods_value (the numeric value)
3. Upload the file using:
   • Import Products CSV (for products/variations), or
   • Import Product Categories CSV (for category costs)

---

Why this is useful

• Update costs for many products in minutes
• Easier to manage costs with your team in a spreadsheet
• Great for importing costs from suppliers or ERP exports
• Avoids manual editing inside WooCommerce product screens