Products Stock Manager with Excel for WooCommerce

On Sale!

Product Stock Manager for WooCommerce with Excel – Update Simple & Variable WooCommerce Products Easily! Automate the Process!

  • Update Simple and Variable Products Stock Number, Status & Prices with Excel b ased on SKU or ID
  • Automate the Update Process with Cron Job with remote excel or google spreadsheets
  • Options to selectively map excel columns or what to update
  • Export easily the in the right Excel format your Product Info
  • Get Reports of your Product Stocks to never lose track
  • get free version or product stock manager with excel for woocommerce in wordpress.org
Clear
License Renewals: 40% off
License

, ,

Support

6 months (48 hours SLA)

Updates

6 months

WordPress Tested

6.7

Minimum PHP Version

8.1

Description

Aren’t you petrified of updating all products stock one by one after your sales of your retail shop? Struggling to keep track of your stock in your eshop sales? Luckily for you, those days are long gone!

Products Stock Manager with Excel for WooCommerce lets you update your Eshop Stock & Prices Easily – also automatic via Cron Job!

This Ajax driven plugin is very easy to use. All your product Stock, Regular Price, Sale Price to update  will be implemented on the spot, without any delay or inaccuracy. Update based on SKU or PRODUCT ID, EXPORT in the correct Excel Format right away. Moreover, you can easily predefine the Excel Columns in the plugins Settings page for your flexibility. And Products Stock Manager with Excel for WooCommerce will also provide you reporting of your stocked Products, along with the ability to automate the process of Updating with Cron Job. Lastly added, auto update via a google spreadsheet is also supported!

...What Our Customers Say...

More than 5000 happy customers trust our solutions & we keep doing our best for their & your satisfaction

  • Products Stock Manager with Excel for WooCommerce Products Stock Manager with Excel for WooCommerce
    5 out of 5
    Very easy to update my products stock with this plugin!

  • Products Stock Manager with Excel for WooCommerce Products Stock Manager with Excel for WooCommerce
    5 out of 5
    I can easily update my products from google sheets! Love it

  • Products Stock Manager with Excel for WooCommerce Products Stock Manager with Excel for WooCommerce
    5 out of 5
    Very easy to use and change my products stock ! The right tool for WooCommerce!

Products Stock Manager with Excel for WooCommerce KEY BENEFITS

 

Update Product Import for Simple & Variable Products !

Instead of updating products Stock and Prices individually, with this plugin you have the opportunity to update UNLIMITED products at a single time. You can update simple products or variable stock and price based on SKU or PRODUCT ID. You can also easily update stock as the sum of values from multiple excel rows for the same product.

 

Export the right Simple & Variable product data to Update

You can easily export Simple and Variable Products Stock, Prices, SKU, ID, title which are the necessary fields of the Correct Excel Formatt for updating. Along with this you can also Export several other fields for your further consideration. Updating WooCommerce Products Stock has never been easier!
The form is submitted through AJAX, so there is no page reloading.

 

Get Report of Stocked Products for your Management Purposes

You will also get basic reporting of your Stocked Products, which you can easily shortlist via Search functionality to keep track of your shop and never face problem with Out of Stock products

 

Automate Update Process with Cron Job!

What could be easier than determining when you want your product stock and/or prices to be updated Automatically? Rather than updating manually, you can use the Plugin settings to define the frequency of updating, define an Excel File Url location and let the software run the Update Process automatically via Cron Job.  As simple as that!

Products Stock Manager with Excel for WooCommerce will save you Time!

Get it here

 

Handle Unlimited Products with Ease!

Our script runs on the background with Ajax technology and is all well optimized to run forever! No more Server or PHP timeouts. You can therefore update as many products you want with no issues!

Supported Fields

The fields that are updated via Products Stock Manager with Excel for WooCommerce are Stock Number, Stock Status, Regular Price and Sales Price. There is also great flexibility, in terms of the supported exports fields of Products Stock Manager with Excel for WooCommerce. Besides the Title, Content & Excerpt, you can also export Status, Author ID, Slug, Product Categories and Tags, Custom Taxonomies like brands, SKU and Weight, Regular and Discounted prices, Stock available, Dimensions (width, length, height) , Downloadable, Virtual, Featured Image, Product Gallery, Upsell IDS, Crossell IDS, Purchase Note, Variation Description, Product Attributes. The latter includes colors, sizes etc.

 

14-day-money-back-gurantee

100% No-risk Money Back Guarantee!

If the plugin doesn't meet your requirements, you can get a refund within 14 days of purchase.

Get it Now

How to Update WooCommerce Products Stock Number from Google Spreadsheet

How to update and manage Stock based on multiple excel rows for WooCommerce product?

Activate the Pro version of the plugin

The pro version is a standalone plugin - you download it from the link in your order email, upload in Wordpress & Activate it. Once installed you go to the Settings Page of Products Stock Manager with Excel for WooCommerce ( WooCommerce / Stock Manager) and insert you license Number provided in the order email as well.

How can I build my Excel File Template for Update Products Stock?

You can either Export your Products which provide the Right Excel Format as the necessary columns are placed first even if you export more fields.
Alternatively, you can download a Sample Excel file from Update screen of the plugin

How to map my excel columns to product fields?

The plugin uses a prefefined template which you can export in sample excel , however, in the Settigns page you can map the Excel Columns to the fields you are updating. Doing this is so easy , just add the Letter of the Excel Column. Also mark if you actually wish to update on of the 4 fields stock number, stock status, regular price or sale price.

How to Automate the Process of Update

You need to go to Plugin settings Page : WooCommerce / Stock Manager / Settings tab

  • Set Auto Import with Cron : Yes
  • Set Auto Import Excel URL : this is the url you will place your Excel file for automatic update
  • Set Import Frequency : set this according to your needs - hourly, daily etc
  • Set Import Time: set an exact time the update process will be starting

How to use Google Spreadheet to auto update stock and prices?

You need to select the option "Publish on the web" in your Google Spreadsheet.
Go to FILE / SHARE / PUBLISH TO THE WEB, from dropwdown select Output as Microsoft Excel.
The plugin needs to read an xlsx file. View more here

Version 3.6 24-11-2024

  • phpspreadsheet updated to 3.4 version
  • PHP 8.1 IS REQUIRED

version 3.5 - 06-02-2024

  • added 5 and 10 minutes intervals to cron update

version 3.4 - 28-01-2024

  • php 8 compatibility fix with cron update

version 3.3 - 13-01-2024

  • js fix

version 3.2 - 21-12-2023

  • hpos support

version 3.1 - 05-12-2023

  • updated cron job fetch to curl

version 3.0 - 24-03-2023

  • bug fix when id column not exist in excel

version 2.9 - 22-08-2022

  • fix  PHP VERSION 8.0.6

version 2.8 - 24-07-2022

  • fix  - update date of post and variation
  • fix sale price update

version 2.7 - 10-03-2022

  • fix  - update phpspreadsheet library for PHP 8.0.6 compatibility

version 2.6 - 09-02-2022

  • fix bug for _price when adding 0 (zero) for regular or sale price

version 2.5 - 19-01-2022

  • Remove Sale price by adding 0 to excel cell
  • Fix Setting stock to zero by adding 0 to excel cell
  • Fix updating prices and stock number with values less than zero ( 0 )

version 2.4 - 19-11-2021

  • add setting to calculate the sum of stock for same product in excel - multiple rows
  • add setting to set stock as zero before product stock update  / manually or with cron

version 2.3 - 25-05-2021

  • add functionality for replacing stock number with the sum of values from multiple excel rows for the same product

version 2.1 - 25-05-2021

  • fix cron feature on import based on SKU

version 2.0 - 28/07/2020

  • fix variable products export
  • add mapping of excel columns in settings page
  • How to update Stock based on multiple excel rows for same product?

You can check the setting in the plugin settings page . Once this done, your stock for each product will be updated based on the SUM of values in the different excel rows that concern the same product. Here is a sample excel file

  • How can I build my Excel File?

You can either Export your Products which provide the Right Excel Format as the necessary columns are placed first even if you export more fields.
Alternatively, you can download a Sample Excel file from Update screen of the plugin

 

  • How to map my excel columns to product fields?

The plugin uses a prefefined template which you can export in sample excel , however, in the Settigns page you can map the Excel Columns to the fields you are updating. Doing this is so easy , just add the Letter of the Excel Column. Also mark if you actually wish to update on of the 4 fields stock number, stock status, regular price or sale price.

You may also like…