I have a WooCommerce online store with about 200 products.
Products all have unique SKU numbers.
Our point of sale system is off-line. We manually extract a comma delimited TXT file. This text file has the following fields,
part number, quantity, price
example of 3 lines.
remember, the document is a text file ie. [url removed, login to view]
All products added to the WooCommerce will match the part number of items in the txt file.
I want to be able to upload this file to my WooCommerce store, and the following should take place after its uploaded.
1) upload file,
2) all stock items should reflect the updated stock quantity.
3) have a tick box to update price. ie. if the box is ticked, then price is updated automatically, and if box is unticked, then the price change field is ignored.
4) if a product is in Draft status, and the stock file shows that this item is in stock. The product should automatically publish.
4) if possible, a results page to say how many items were updated, published, price changed.