Copy Billing Address To Shipping Address Mass Action?

  • Posts: 440
  • Thank you received: 20
  • Hikashop Essential
4 years 9 months ago #307192

-- 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

Please Log in or Create an account to join the conversation.

  • Posts: 81361
  • Thank you received: 13037
  • MODERATOR
4 years 9 months ago #307193

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.

Last edit: 4 years 9 months ago by nicolas.
The following user(s) said Thank You: davec

Please Log in or Create an account to join the conversation.

Time to create page: 0.060 seconds
Powered by Kunena Forum