Invalid address id at add to cart

Ask Question

Asked 2 years, 3 months ago

Modified 2 years, 3 months ago

Viewed 33 times

I have getting error Invalid address id at add to cart , issue with only migration customer

Any solution to resolve this issue

asked Sep 6, 2022 at 11:27

Manoj Pal

1,0578 silver badges18 bronze badges

What version of Magento are you running?
– MagePal Extensions
Commented Sep 6, 2022 at 13:13
What do you mean by it only affects migrated customers? Take a look at magento.stackexchange.com/questions/196101/… ... you may need to write a SQL script to delete all the address id for the migrated customer since they don't exist in the current magento
– MagePal Extensions
Commented Sep 6, 2022 at 13:25
Magetno version is 2.3.3-p1
– Manoj Pal
Commented Sep 6, 2022 at 13:47
Have you any SQL script to delete all the address of migrated customer ?
– Manoj Pal
Commented Sep 6, 2022 at 13:48
try something like select * from customer_entity where `default_shipping` not in (select entity_id from customer_address_entity) for both default_shipping and default_billing. Once you validate that the result is what you want to fixed then change the sql to update customer_entity set default_shipping = null where `default_shipping` not in (select entity_id from customer_address_entity)
– MagePal Extensions
Commented Sep 6, 2022 at 14:09

| Show 1 more comment

0 Your Answer

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.