I have a production instance of Magento which is running on version 18.104.22.168, and I have another instance of Magento which is running on version 22.214.171.124.
I am trying to export customers from the production instance into the new instance from Magento admin panel System=>Import/Export Area.
When trying to import the CSV file into the new instance I face many errors mainly due to the emptiness of some columns such as postcode for some customer. so I have filled all of them with "0" values. And right now when I try to import I get the following error : "E-mail and website combination is not found in rows: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10......"
My Questions are:
What might be the problem due to? and how can I resolve this?
Can I achieve the same thing by importing the customer tables via PHPMyAdmin instead of Magento admin panel? If yes, Do I need to import all tables that start with **customer_?**