Copy Billing Address To Shipping Address Mass Action?

-- HikaShop version -- : 4.1.0
-- Joomla version -- : 3.9.6

Hi

I have recently moved a site over from Wix. In doing so the existing customers were transferred over including their billing address. However this has left the shipping address empty and is causing issues. Is there a way to bulk update the shipping addresses t be the same as the billing address?

Thanks

Dave

Hi,

With a MySQL query in your phpmyadmin:
INSERT INTO #__hikashop_address ( address_type , XXX, YYY, ....) SELECT 'shipping', XXX, YYY FROM #__hikashop_address
where XXX, YYY, ... is to be replaced with the list of the columns of hikashop_address except address_id and address_type.