1. Documentation /
  2. Price and Stock Import

Price and Stock Import

Installation

↑ Back to top

Download, install and activate the extension.

It is strongly recommended you initially use a staging/development environment and test the extension before use on a production website.

If you haven’t already, connect your store to your WooCommerce account. This ensures you get extension update notifications when available.

Quick start guide

↑ Back to top
  • Perform the installation steps above
  • From the Products menu in your dashboard select Price and Stock Import
  • Click the export button to download a CSV of all product price and stock data
  • Make changes to the CSV using spreadsheet software and save as a plain text CSV
  • Select the file and click import test
  • Review the data to check the data which will be updated
  • Return to the previous page and click the import button
  • Import will begin and progress will be shown, do not close the window but you can work in other browser tabs while waiting for it to complete
  • Once the import has completed your price/stock data will be updated

Import/export

↑ Back to top

Introduction

↑ Back to top

Price and Stock Import allows you to easily update product price and stock in your store from an easy to understand CSV spreadsheet.

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.

Usage

↑ Back to top
  • From the Products menu in your dashboard select Price and Stock Import
  • Click the export button to download a CSV of all product price and stock data
  • Make changes to the CSV using spreadsheet software and save as a plain text CSV
  • Select the file and click import test
  • Review the data to check the data which will be updated
  • Return to the previous page and click the import button
  • Import will begin and progress will be shown, do not close the window but you can work in other browser tabs while waiting for it to complete
  • Once the import has completed your price/stock data will be updated

The manage stock setting in WooCommerce > Settings > Products > Inventory must be enabled for stocks to be imported and therefore this setting will automatically be enabled upon importing if it is currently disabled.

If a product is updated from no previous stock level (e.g. manage stock disabled) to now having a stock level and the product did not previously have manage stock enabled this will be enabled on the product automatically during import.

Price and stock import screen
Exported CSV being edited in spreadsheet software

Modes

↑ 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)

BETA functionality

↑ Back to top

We may occasionally include BETA functionality, this is highlighted with a (BETA) label. Functionality with this label should be used with caution and is only recommended to be tested on a staging/development environment. The functionality is included so users can test the functionality/provide feedback before it becomes stable, at which point the (BETA) label will be removed. Note that there may be occasions where BETA functionality is determined unsuitable for use and removed entirely.

Caching

↑ Back to top

If you are using any form of caching then it is recommended that the cache lifespan/expiry should be set to 10 hours or less. This is recommended by most major caching solutions to avoid potential issues with WordPress nonces.

Screen sizes

↑ Back to top
  • Frontend: Where elements may be displayed they will fit within the screen width
  • Backend: Where interfaces may be displayed it is recommended to use a desktop computer with a resolution of 1920×1080 or higher, for lower resolutions any interfaces will attempt to fit within the screen width but some elements may be close together and/or larger than the screen width

Translation

↑ Back to top

We generally recommend Loco Translate to translate and/or adapt text strings within this product.

Works with

↑ Back to top

Where we have explicitly stated this product works with another product, this should only be assumed accurate if you are using the version of the other product which was the latest at the time the latest version of this product was released. This is because, while usually unlikely, the other product may have changed functionality which effects this product.

FAQs

↑ Back to top

How long do imports take?

↑ Back to top

This depends on how many rows you importing and the performance of your hosting, generally each row will take approx 0.5-1 seconds to import.

Do I need to import all my products?

↑ Back to top

The exported CSV includes all your products, but you don’t need to include the rows which haven’t been changed, these can be removed from your CSV to be imported but ensure you keep first row containing the column headings. Removing rows which haven’t been changed will make importing your CSV much faster.

Does it work with WooCommerce Subscription product types?

↑ Back to top

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

Is it compatible with a specific theme?

↑ Back to top

This extension will generally be compatible with most themes. There may be a small number of themes that are fully or partially incompatible due to clashes in functionality and/or if the theme has removed or adapted core WooCommerce functionality. If you would like to know if a specific theme will be compatible before purchase then please contact us and we can advise, it may not be possible for us to determine this e.g. if the theme requires a license and/or several configuration steps. In this scenario you are welcome to purchase and test this extension with the theme and if there is a a compatibility issue you can take advantage of the refund policy for this extension.

Is it compatible with a specific extension/plugin?

↑ Back to top

This extension will generally be compatible with most extensions/plugins. There may be a small number of extensions/plugins that are fully or partially incompatible due to clashes in functionality and/or if the extension/plugin has removed or adapted core WooCommerce functionality. If you would like to know if a specific extension/plugin will be compatible before purchase then please contact us and we can advise, it may not be possible for us to determine this e.g. if the extension/plugin requires a license and/or several configuration steps. In this scenario you are welcome to purchase and test this extension with the other extension/plugin and if there is a a compatibility issue you can take advantage of the refund policy for this extension.

Is it compatible with a specific page builder?

↑ Back to top

This extension will generally be compatible with most page builders. There may be a small number of page builders that are fully or partially incompatible due to clashes in functionality and/or if the page builder has removed or adapted core WooCommerce functionality. If you would like to know if a specific page builder will be compatible before purchase then please contact us and we can advise, it may not be possible for us to determine this e.g. if the page builder requires a license and/or several configuration steps. In this scenario you are welcome to purchase and test this extension with the page builder and if there is a a compatibility issue you can take advantage of the refund policy for this extension.

Support

↑ Back to top

If you need any further assistance with this extension please contact us. Please note that extension support does not include providing assistance with any custom development requirements as per the WooCommerce support policy.