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