1. In Cubecart Admin, you can change the Stock Level on any product. Need our sister Retail Store to be synched each time this happesns so that the same Product Code in Retail Store then has the same Stock Level as that Product in Wholesale.
2. A tool (php/mysql script) that will read all the Inventory records in Wholesale Store and find the matching Product Codes in Retail, correcting any non-matching Stock Levels in Retail. Needs to take care of overloading Mysql as the ProductCode is not an Index, perhaps by pausing/operating at low priority, also produce a report of the corrections made.
Both items, as usual, to be delivered as edit instructions so I can add the mods myself.