1. Documentation
  2. Plugins
  3. WooCommerce
  4. Extensions

Price & Stock Import

Overview ↑ Back to top

Price & Stock Import allows you to easily update product price and stock in your WooCommerce store.

You simply export all your product’s price and stock data in one click, open the exported CSV on your computer, make changes to the price and stock data and import. There aren’t endless of columns of data to understand as it shows basic product identifiers with price and stock columns only.

Getting Started ↑ Back to top

  1. Install the extension via your WordPress dashboard
  2. Go to Price & Stock Import from the Products menu on the left of your dashboard
  3. Use the export button to download a CSV of all your products
  4. Make changes to the price and stock data in your exported CSV
  5. Import the changed CSV, you can even run a test before the import to check the data is okay
Main screen
Testing an import

Working with your CSV export ↑ Back to top

This extension uses the CSV format for exports and imports and therefore can be used with any spreadsheet software which supports the CSV format (such as Excel, LibreOffice, OpenOffice, etc) – when you have finished making changes to your CSV ready to import you need to ensure the spreadsheet is saved in the same format it was exported (CSV). If you’ve performed spreadsheet software specific calculations or formatting you’d like to keep then you could still keep a master version as required for use in your spreadsheet software.

Example CSV being edited

Mode ↑ Back to top

There are 2 modes which effect your export and import to match products in your CSV to products in your store:

  • ID exports products showing the ID as the first column
  • SKU exports products showing the SKU as the first column – should only be used if all products in your store have a unique SKU
Mode setting

Notes ↑ Back to top

This extension is only for updating price and stock of products which already exist and supports all standard product types which are included in the WooCommerce plugin.

Always take a backup of your store before running an import.

FAQs ↑ Back to top

Does it work with WooCommerce Subscriptions? ↑ Back to top

Yes, the importer allows simple and variable subscription product types to have any stock and regular/sale prices imported.

WooCommerce - the most customizable eCommerce platform for building your online business.

  • 30 day money back guarantee
  • Support teams across the world
  • Safe & Secure online payment