Skip to content

Instantly share code, notes, and snippets.

@mircobabini

mircobabini/wc-sell-or-ship-to-specific-countries-europe.sql

Forked from pascalknecht/query.sql
Last active February 9, 2023 08:27
Show Gist options
  • Save mircobabini/5facfe50347f082e137b63ef75a7b4a8 to your computer and use it in GitHub Desktop.
Save mircobabini/5facfe50347f082e137b63ef75a7b4a8 to your computer and use it in GitHub Desktop.
Download ZIP
WooCommerce sell/ship EU Countries only (small area, extended area or the whole continent)
Raw
wc-sell-or-ship-to-specific-countries-europe.sql
# Sell to specific EU countries only
UPDATE `wp_options` SET `option_value`='specific' WHERE option_name = 'woocommerce_allowed_countries';
UPDATE `wp_options` SET `option_value`='a:30:{i:0;s:2:"AT";i:1;s:2:"BE";i:2;s:2:"BG";i:3;s:2:"HR";i:4;s:2:"CY";i:5;s:2:"CZ";i:6;s:2:"DK";i:7;s:2:"EE";i:8;s:2:"FI";i:9;s:2:"FR";i:10;s:2:"DE";i:11;s:2:"GR";i:12;s:2:"HU";i:13;s:2:"IE";i:14;s:2:"IM";i:15;s:2:"IT";i:16;s:2:"JE";i:17;s:2:"LV";i:18;s:2:"LT";i:19;s:2:"LU";i:20;s:2:"MT";i:21;s:2:"NL";i:22;s:2:"PL";i:23;s:2:"PT";i:24;s:2:"RO";i:25;s:2:"SK";i:26;s:2:"SI";i:27;s:2:"ES";i:28;s:2:"SE";i:29;s:2:"GB";}' WHERE option_name = 'woocommerce_specific_allowed_countries';
# Ship to specific EU countries only
UPDATE `wp_options` SET `option_value`='specific' WHERE option_name = 'woocommerce_ship_to_countries';
UPDATE `wp_options` SET `option_value`='a:30:{i:0;s:2:"AT";i:1;s:2:"BE";i:2;s:2:"BG";i:3;s:2:"HR";i:4;s:2:"CY";i:5;s:2:"CZ";i:6;s:2:"DK";i:7;s:2:"EE";i:8;s:2:"FI";i:9;s:2:"FR";i:10;s:2:"DE";i:11;s:2:"GR";i:12;s:2:"HU";i:13;s:2:"IE";i:14;s:2:"IM";i:15;s:2:"IT";i:16;s:2:"JE";i:17;s:2:"LV";i:18;s:2:"LT";i:19;s:2:"LU";i:20;s:2:"MT";i:21;s:2:"NL";i:22;s:2:"PL";i:23;s:2:"PT";i:24;s:2:"RO";i:25;s:2:"SK";i:26;s:2:"SI";i:27;s:2:"ES";i:28;s:2:"SE";i:29;s:2:"GB";}' WHERE option_name = 'woocommerce_specific_ship_to_countries';
# EU short list
# a:30:{i:0;s:2:"AT";i:1;s:2:"BE";i:2;s:2:"BG";i:3;s:2:"HR";i:4;s:2:"CY";i:5;s:2:"CZ";i:6;s:2:"DK";i:7;s:2:"EE";i:8;s:2:"FI";i:9;s:2:"FR";i:10;s:2:"DE";i:11;s:2:"GR";i:12;s:2:"HU";i:13;s:2:"IE";i:14;s:2:"IM";i:15;s:2:"IT";i:16;s:2:"JE";i:17;s:2:"LV";i:18;s:2:"LT";i:19;s:2:"LU";i:20;s:2:"MT";i:21;s:2:"NL";i:22;s:2:"PL";i:23;s:2:"PT";i:24;s:2:"RO";i:25;s:2:"SK";i:26;s:2:"SI";i:27;s:2:"ES";i:28;s:2:"SE";i:29;s:2:"GB";}
# EU plus Vatican, San Marino, Monaco, France islands
# a:34:{i:0;s:2:"AT";i:1;s:2:"BE";i:2;s:2:"BG";i:3;s:2:"CY";i:4;s:2:"HR";i:5;s:2:"DK";i:6;s:2:"EE";i:7;s:2:"FI";i:8;s:2:"FR";i:9;s:2:"DE";i:10;s:2:"GR";i:11;s:2:"IE";i:12;s:2:"IM";i:13;s:2:"IT";i:14;s:2:"JE";i:15;s:2:"LV";i:16;s:2:"LT";i:17;s:2:"LU";i:18;s:2:"MT";i:19;s:2:"MC";i:20;s:2:"NL";i:21;s:2:"PL";i:22;s:2:"PT";i:23;s:2:"GB";i:24;s:2:"CZ";i:25;s:2:"RO";i:26;s:2:"MF";i:27;s:2:"SM";i:28;s:2:"SK";i:29;s:2:"SI";i:30;s:2:"ES";i:31;s:2:"SE";i:32;s:2:"HU";i:33;s:2:"VA";}
# EU continent
# a:52:{i:0;s:2:"AL";i:1;s:2:"AD";i:2;s:2:"AM";i:3;s:2:"AT";i:4;s:2:"AZ";i:5;s:2:"BY";i:6;s:2:"BE";i:7;s:2:"BA";i:8;s:2:"BG";i:9;s:2:"HR";i:10;s:2:"CY";i:11;s:2:"CZ";i:12;s:2:"DK";i:13;s:2:"EE";i:14;s:2:"FI";i:15;s:2:"FR";i:16;s:2:"GE";i:17;s:2:"DE";i:18;s:2:"GR";i:19;s:2:"HU";i:20;s:2:"IS";i:21;s:2:"IE";i:22;s:2:"IM";i:23;s:2:"IT";i:24;s:2:"JE";i:25;s:2:"KZ";i:26;s:2:"LV";i:27;s:2:"LI";i:28;s:2:"LT";i:29;s:2:"LU";i:30;s:2:"MK";i:31;s:2:"MT";i:32;s:2:"MD";i:33;s:2:"MC";i:34;s:2:"ME";i:35;s:2:"NL";i:36;s:2:"NO";i:37;s:2:"PL";i:38;s:2:"PT";i:39;s:2:"RO";i:40;s:2:"RU";i:41;s:2:"SM";i:42;s:2:"RS";i:43;s:2:"SK";i:44;s:2:"SI";i:45;s:2:"ES";i:46;s:2:"SE";i:47;s:2:"CH";i:48;s:2:"TR";i:49;s:2:"UA";i:50;s:2:"GB";i:51;s:2:"VA";}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment