I am trying to insert billing & shipping address for some existing orders.
We had a product mistakenly set as virtual product and some customers purchased it. Now I need to manually insert their shipping addresses (and maybe billing address) into the order. Is there any plugin to do this or maybe I can update in database?
I tried to create new entry in
sales_order_address table but it doesn't work.
Any hint would be appreciated, thank you in advance!