Closed piotrekkaminski closed 5 years ago
From @magento-engcom-team on October 9, 2017 11:30
@robin31, thank you for your report. We've created internal ticket(s) MAGETWO-81270 to track progress on the issue.
This has been covered in 2.3-develop by https://github.com/magento/magento2/commit/f06e173d86ee4ee3ed9da5e44f9e05b44b7736f6 and in 2.2-develop by https://github.com/magento/magento2/pull/11968
From @robin31 on February 14, 2017 13:42
When using module-customer-import-export/Model/Import/Customer.php to update existing customers, attributes that are in customer_entity and are not in the data to update will be nullified. For instance, updating customer name and or group through the importer would empty that customers password / rp_roken etc. This happens because in the _saveCustomerEntities function all fields of the customer are passed to insertOnDuplicate function.
Preconditions
Steps to reproduce
Expected result
Actual result
Resolution
In the function call on vendor/magento/module-customer-import-export/Model/Import/Customer.php:264 $this->customerFields should not be passed to the insertOnDuplicate function. The logic of insertOnDuplicate would then automatically build the query for the fields that are actually in the update data.
Query that now is beeging generated when updating customers:(
group_id
,store_id
,created_at
,updated_at
,entity_id
,firstname
,lastname
,gender
,email
):Query that should have been generated when updating customers
group_id
,store_id
,created_at
,updated_at
,entity_id
,firstname
,lastname
,gender
,email
:Copied from original issue: magento/magento2#8548