Products Stock Manager with Excel for WooCommerce Inventory

December 29, 2023

Products Stock Manager with Excel for WooCommerce Inventory Plugin

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

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

GET Products Stock Manager with Excel for WooCommerce PRO to update automatically or manually both Simple & Variable Products

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

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

GET PRO VERSION HERE

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

Screenshots

  1. Backend Update Page

    Backend Update Page

  2. Backend Export Page

    Backend Export Page

  3. Backend Report Page

    Backend Report Page

  4. Backend Settings Page

    Backend Settings Page

FAQ

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

Can I update Product variations?

This is available in the PRO Version

Changelog

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

Details

  • Version: 2.0
  • Active installations: 100
  • WordPress Version: 3.0.1
  • Tested up to: 6.4.5
  • PHP Version: 7.1

Ratings


5 Stars
4 Stars
3 Stars
2 Stars
1 Stars