Hi David,
GeoIP up and running. DB from 9. December 2014
These are the table fields:
(213, 28, ‘_order_key’, ‘wc_order_5486e11e73493’),
(214, 28, ‘_order_currency’, ‘EUR’),
(215, 28, ‘_prices_include_tax’, ‘no’),
(216, 28, ‘_customer_ip_address’, ‘87.167.220.148’),
(217, 28, ‘_customer_user_agent’, ‘Mozilla/5.0 (Windows NT 6.1; rv:34.0) Gecko/20100101 Firefox/34.0’),
(218, 28, ‘_customer_user’, ‘1’),
(219, 28, ‘_billing_country’, ‘DE’),
(220, 28, ‘_billing_first_name’, ‘Dirk’),
(221, 28, ‘_billing_last_name’, ‘Jarzyna’),
(222, 28, ‘_billing_company’, ”),
(223, 28, ‘_billing_address_1’, ‘Pestaxxxx 99’),
(224, 28, ‘_billing_address_2’, ”),
(225, 28, ‘_billing_postcode’, ‘27749’),
(226, 28, ‘_billing_city’, ‘Delmenhorst’),
(227, 28, ‘_billing_state’, ”),
(228, 28, ‘_billing_email’, ‘xxxxxx@gmail.com’),
(229, 28, ‘_billing_phone’, ‘+99 9999 999999’),
(230, 28, ‘_shipping_country’, ‘DE’),
(231, 28, ‘_shipping_first_name’, ‘Dirk’),
(232, 28, ‘_shipping_last_name’, ‘Jarzyna’),
(233, 28, ‘_shipping_company’, ”),
(234, 28, ‘_shipping_address_1’, ‘Pestaxxxx 99’),
(235, 28, ‘_shipping_address_2’, ”),
(236, 28, ‘_shipping_postcode’, ‘27749’),
(237, 28, ‘_shipping_city’, ‘Delmenhorst’),
(238, 28, ‘_shipping_state’, ”),
(239, 28, ‘_payment_method’, ‘cheque’),
(240, 28, ‘_payment_method_title’, ‘Cheque Payment’),
(241, 28, ‘_order_shipping’, ‘0’),
(242, 28, ‘_order_discount’, ‘0’),
(243, 28, ‘_cart_discount’, ‘0’),
(244, 28, ‘_order_tax’, ‘4.56’),
(245, 28, ‘_order_shipping_tax’, ‘0’),
(246, 28, ‘_order_total’, ‘28.56’),
(247, 28, ‘vat_compliance_country_info’, ‘a:4:{s:6:”source”;s:29:”geoip_detect_get_info_from_ip”;s:4:”data”;s:2:”DE”;s:4:”meta”;a:2:{s:2:”ip”;s:14:”87.167.220.148″;s:4:”info”;O:11:”geoiprecord”:14:{s:12:”country_code”;s:2:”DE”;s:13:”country_code3″;s:3:”DEU”;s:12:”country_name”;s:7:”Germany”;s:6:”region”;s:2:”06″;s:4:”city”;s:8:”Grasberg”;s:11:”postal_code”;s:5:”28879″;s:8:”latitude”;d:53.183300000000002683009370230138301849365234375;s:9:”longitude”;d:8.983300000000014051693142391741275787353515625;s:9:”area_code”;N;s:8:”dma_code”;N;s:10:”metro_code”;N;s:14:”continent_code”;s:2:”EU”;s:11:”region_name”;s:13:”Niedersachsen”;s:8:”timezone”;s:13:”Europe/Berlin”;}}s:15:”taxable_address”;a:4:{i:0;s:2:”DE”;i:1;s:0:””;i:2;s:5:”27749″;i:3;s:11:”Delmenhorst”;}}’),
(248, 28, ‘_recorded_sales’, ‘yes’),
(249, 28, ‘_recorded_coupon_usage_counts’, ‘yes’),
(250, 28, ‘_edit_lock’, ‘1418125753:1’),
(251, 28, ‘_edit_last’, ‘1’),
(252, 28, ‘_transaction_id’, ”),
(253, 28, ‘_download_permissions_granted’, ‘1’),
(254, 28, ‘_completed_date’, ‘2014-12-09 13:49:35’);