Forcing a Stock Reset
Woosage uses a local database to keep track of Sage stock changes and adds new products stock positions when added to Sage with PTW set.
Following installation, under normal circumstances, Woosage will only push stock changes to the website if they change in Sage, and then only if it differs from the website, as the website will maintain product stock positions for orders, provided that track stocking is enabled as shown below.
If you have made manual changes to your website stock you may want to have Woosage get all stock positions from Sage for all web products, which can be done as follows.
Check that Update stock on setup is enabled in Woosage50>Settings>Advanced and enable if not (this setting can be left enabled)
Click Save Settings
On the device (PC or server) where the Woosage50Service is installed, remove the Woosage database as follows.
Open Services and Stop the Woosage50Service
Locate and select the woosage50.db file in C:\ProgramData\Woosage50Service
Click Delete (you may need administrator rights for this)
Open Services and Start the Woosage50Service
On the website go to Woosage50>Processing>Orders
Click Run Now
This will force Woosage to get all stock positions from Sage, add them to a new database then, where different from the website positions, update them on the website.
Note, if stock tracking is not enabled in the website product Woosage cannot update it. In this case Woosage will update a custom field called Free Stock, which is visible in the Product>Sage data section. If stock tracking is subsequently enabled Woosage will immediately update the stock quantity without waiting for the orders cycle to run.
Related Articles
Stock Updates
The Pro version of Woosage uses Sage as a stock master and will update WooCommerce with any updated stock quantities for products on the website. The Sage products that will have their stock level pushed to the website are marked with a Publish to ...Woosage50 Professional - Stock Updates
The Professional version of Woosage50 has the option to update website stock quantities using Sage as a stock master by enabling stock updates in the product settings. Stock Update Process Sage products that are to be updated on the website are ...Negative Stock & Backorders
In order to allow backorders on the website and to keep the stock synchronised you must allow Sage to have negative stock amounts and set each product on the website to allow backorders. If both are enabled then the website will reduce stock beyond ...Variable Product Stock and Price Update Considerations
Variable products can be seen as a hierarchy, with the Variable Product as the parent and the Product Variations as the children. Within WooCommerce each element (i.e. the parent variable product and each child variation) has a SKU and a number of ...Product Codes (AKA SKU or Stock Codes)
Sage Code Restrictions. A requirement of Woosage is that the SKU codes in WooCommerce must match the Product (Stock) codes on Sage in order to process orders and update website products. While WooCommerce can have SKU codes up to 255 characters in ...