CSV export import E commerce

I have been testing the CSV export/import in the product collection inside the e commerce, I am wondering why it is existed if you can’t import any CSV file whatever the template is, even exporting one ready product from the list and changing the name then try to import the list again ending up that the list is not supported, why there is big gap between the CMS collections of WF and the e commerce one as if they are from two different platforms!

I already have shop of more than 500 products on WF using Foxy, shall I now enter them manually one by one if i want to shift to WF! this weakness won’t let any serious shops to move to WF.