Import Addresses

Ok so i recently imported a bunch of users into wp and had to import their additional addresses, here is the inset i used to add the info. It is fake info but you get the idea. This includes TWO address sets, 1111 includes ONE address and 1112 includes THREE addresses with the first one set as the default address.

INSERT INTO wp_usermeta
(user_id, meta_key, meta_value) 
VALUES
('1111','wc_multiple_shipping_addresses','a:1:{i:0;a:11:{s:19:"shipping_first_name";s:8:"Fakename";s:18:"shipping_last_name";s:8:"Morefake";s:16:"shipping_company";s:0:"";s:16:"shipping_country";s:2:"US";s:18:"shipping_address_1";s:13:"312 20th St N";s:18:"shipping_address_2";s:0:"";s:13:"shipping_city";s:10:"birmingham";s:14:"shipping_state";s:7:"Alabama";s:17:"shipping_postcode";s:5:"35203";s:27:"shipping_address_is_default";s:4:"true";s:5:"label";s:1:"1";}}'),
('1112','wc_multiple_shipping_addresses','a:3:{i:0;a:11:{s:19:"shipping_first_name";s:5:"Sarah";s:18:"shipping_last_name";s:5:"SMITH";s:16:"shipping_company";s:0:"";s:16:"shipping_country";s:2:"US";s:18:"shipping_address_1";s:21:"12345 STATE HWY 111 S";s:18:"shipping_address_2";s:0:"";s:13:"shipping_city";s:5:"FakeC";s:14:"shipping_state";s:5:"Texas";s:17:"shipping_postcode";s:5:"77777";s:27:"shipping_address_is_default";s:4:"true";s:5:"label";s:1:"1";}{i:1;a:11:{s:19:"shipping_first_name";s:5:"Sarah";s:18:"shipping_last_name";s:5:"SMITH";s:16:"shipping_company";s:0:"";s:16:"shipping_country";s:2:"US";s:18:"shipping_address_1";s:12:"11111 CR 123";s:18:"shipping_address_2";s:0:"";s:13:"shipping_city";s:5:"FakeC";s:14:"shipping_state";s:5:"Texas";s:17:"shipping_postcode";s:5:"77777";s:27:"shipping_address_is_default";s:5:"false";s:5:"label";s:1:"2";}{i:2;a:11:{s:19:"shipping_first_name";s:9:"FirstName";s:18:"shipping_last_name";s:8:"LastName";s:16:"shipping_company";s:0:"";s:16:"shipping_country";s:2:"US";s:18:"shipping_address_1";s:17:"123 Some Address";s:18:"shipping_address_2";s:0:"";s:13:"shipping_city";s:4:"City";s:14:"shipping_state";s:5:"State";s:17:"shipping_postcode";s:5:"77777";s:27:"shipping_address_is_default";s:5:"false";s:5:"label";s:1:"3";}}');

Let me know if you have any questions, i just put this all together for importing from Zen Cart so i have a little bit of experience converting from zen cart to wordpress.

• This topic was modified 7 years, 4 months ago by RobertGomez.
• This topic was modified 7 years, 4 months ago by RobertGomez.