Thank you for your time and help, we have found a solution.
Thank you csnlima, after saving to csv from Google Sheet it works.
One last thing is there an option to delete all products per import? So that each import will have a new list of products. I am aware that you can do bulk action delete 20 or more products using woocommerce UI manually, but takes along time to delete over 1000 records.
Please let me know if there is a quicker way, thank you.
Thanks for the reply Oyadeyi, I am having issues now with the WooCommerce CSV import. It will not use my prefer CSV Delimiter. It keep using comma even I change it to | pipe character. I am using Version 6.1.1 Can you please advice me what I can do?
