=== Products Stock Manager with Excel for WooCommerce Inventory ===
Contributors: wpcodefactory, anbinder, karzin, omardabbas
Tags:  update stock, stock export, stock manager, stock management, inventory, excel, stock , woocommerce
Requires at least: 3.0.1
Requires PHP: 8.1
Tested up to: 6.8
Stable tag: 3.0.3
License: GPLv2 or later
License URI: http://www.gnu.org/licenses/gpl-2.0.html

Update your WooCommerce Products Stock inventory and Prices with the power of Excel
== Description ==

= Products Stock Manager with Excel for WooCommerce plugin gives the ability to update your stock inventory and prices with the power of excel  =

The Plugin extends WooCommerce and allows you to update easily your Simple products based on SKU or ID stock and prices , automatically update with CRON job / Sync (**[PRO Version](https://extend-wp.com/product/products-stock-manager-excel-woocommerce "Products Stock Manager with Excel for WooCommerce PRO")**) .
It is using a predefined **excel template** that you can easily locate in its **Settings** Page or otherwise use its **Export** functionality to get the right Template. In the Pro version you can also predefine the mapping in plugin settings page.
Moreover, you will get **Stock Report** for your Business Management Purposes
In the (**[PRO Version](https://extend-wp.com/product/products-stock-manager-excel-woocommerce "Products Stock Manager with Excel for WooCommerce PRO")**) you can automate the Process of Update with Excel from Remote Location eg Google Spreadsheet, update and export Variable products and variations.

= How I can benefit from Stock Manager inventory  =

* Fast Update by ID or SKU simple products with the Power of Excel
* Locate the ID and SKU of your products easily by using the Export feature in Excel in the right format
* Stock Report for your Stock Management Purposes
* Run your Business Faster! Automatically update Stock & Prices with Cron at a certain defined time with Cron Job(**[PRO Version](https://extend-wp.com/product/products-stock-manager-excel-woocommerce "Products Stock Manager with Excel for WooCommerce PRO")**)

**[GET Products Stock Manager with Excel for WooCommerce PRO to update automatically or manually both Simple & Variable Products ](https://extend-wp.com/product/products-stock-manager-excel-woocommerce "Products Stock Manager with Excel for WooCommerce PRO")**

= DETAILED FEATURES =
* Update with Excel Simple Products stock number, stock status, regular price, sale price
* new:  You can also easily update stock as the sum of values from multiple excel rows for the same product.
* Export to Excel the right format needed to update back Simple Products SKU, ID, stock number, stock status, regular price, sale price (plus Title for better product identification even not used during import)
* Get Products Stock Number in a Report you can also shortlist

**[GET PRO VERSION HERE](https://extend-wp.com/product/products-stock-manager-excel-woocommerce "Products Stock Manager with Excel for WooCommerce PRO")**

= PRO Plugin Features =

* Update manually with Excel Variable Products Stock Number, Stock Status, Regular Price, Sale Price
* Predefine the mapping of Excel columns to product fields and choose what to update
* Export to Excel both Simple & Variable Products SKU, ID, stock number, stock status, regular price, sale price - the right format needed to update back
* Export to Excel both Simple & Variable Products extra product fields if needed such as title, description, dimensions, taxonomies etc
* Automatically Update using a Cron Job  / Sync stock using an Excel placed in a Remote Location. Google Spreadsheets "published on the web" xlsx is also supported to save you time and keep you in track.
* Define Update frequency, Exact Time for execution of auto update
* Added setting to calculate the sumn of stock number of a product in case of duplicate entries in excel
* Added setting to set 0 (zero) stock for all products before update

[youtube https://www.youtube.com/watch?v=x7k0K-INp4Y&rel=0]

**[GET PRO VERSION HERE](https://extend-wp.com/product/products-stock-manager-excel-woocommerce "Products Stock Manager with Excel for WooCommerce PRO")**

== Installation ==

1. Upload the plugin files to the `/wp-content/plugins` directory and unzip, or install the plugin through the WordPress plugins screen directly.
2. Activate the plugin through the 'Plugins' screen in WordPress
3. Go to WooCommerce / Stock Manager

== Frequently Asked Questions ==

= How to how to build my excel template? =
Download a sample excel file from Update Screen of plugin settings. The fields updated are predefined and follow the exact excel template

= How to update stock and prices via excel? =
You can either go to Export screen first and get an excel of your products. Other option is to download a sample excel file from Update Screen of plugin settings. The fields updated are predefined and follow the exact excel template

= Can I automatically update at certain time ? =
This is available in the [PRO Version](https://extend-wp.com/product/products-stock-manager-excel-woocommerce "Products Stock Manager with Excel for WooCommerce PRO")

= Can I update Product variations? =
This is available in the [PRO Version](https://extend-wp.com/product/products-stock-manager-excel-woocommerce "Products Stock Manager with Excel for WooCommerce PRO")

== Screenshots ==

1. Backend Update Page
2. Backend Export Page
3. Backend Report Page
4. Backend Settings Page

== Changelog ==

= 3.0.3 - 16/09/2025 =
* WC tested up to: 10.1.

= 3.0.2 - 10/06/2025 =
* Fix - Fix plugin icon.

= 3.0.1 - 06/06/2025 =
* Dev - Updated plugin icon and banner.

= 3.0.0 - 28/05/2025 =
* Fix - Translation loading fixed.
* Dev - Plugin settings moved to the "WPFactory" menu.
* Dev - "Recommendations" added.
* Dev - Code refactoring and cleanup.
* WC tested up to: 9.8.
* Tested up to: 6.8.

= 2.1 =
* PhpSpreadsheet updated to 3.4.0, requires PHP 8.1, checked woo 9.5 and 6.7.1 WP compatibility.

= 1.8 =
* Fix compatibility with PHP 8.0.6.

= 1.7 =
* Fix sale price update. Add update for modified on post for each change.

= 1.6 =
* Fixed bug updating _price when sale or regular price is set to zero in the excel.

= 1.5 =
* Fixed bug updating sale price.

= 1.4 =
* 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 ).

= 1.3 =
* Check compatibility.

= 1.2 =
* Added functionality for replacing stock number with the sum of values from multiple excel rows for the same product.

= 1.1 =
* Fix check whether product exists based on ID or SKU from excel for thrown error.

= 1.0 =
* Initial release.

== Upgrade Notice ==

= 2.1 =
PhpSpreadsheet updated to 3.4.0, requires PHP 8.1, checked woo 9.5 and 6.7.1 WP compatibility.
