Hello!
Does the automatic synchronization allow me to update a product value that is linked to a formula?
I have an Excel file consisting of these sheets:
“load”, where I manually enter the product code and the number of pieces of that product in stock in my offline shop
“unload”, where I manually enter the product code and the number of pieces of that product I sold in my offline shop
“woocommerce unload”, where I want to have the product code and the number of pieces sold online
“warehouse” where each product corresponds to a number (automatically calculated using an Excel formula) that is the difference between the pieces indicated in the “load” sheet and those in the “unload” and “woocommerce unload” sheets.
What I need is a communication of this type:
– WooCommerce must put up for sale the number of products indicated in the “warehouse” sheet
– When a sale occurs on the website, it must be reflected in the “woocommerce unload” sheet.
Is it possible to do that with just this plugin?
Thank you very much