INSERT INTO `shop_currency` SET `currency_id`=1, `currency_name`='Canadian Dollars', `currency_code`='CAD', `exchange_rate`=1.000000000000000;
INSERT INTO `shop_currency` SET `currency_id`=2, `currency_name`='US Dollars', `currency_code`='USD', `exchange_rate`=0.918726681568410;
UPDATE `sites` SET `currency_id`=1 WHERE `site_id`=1 AND `currency_id` IS NULL;

INSERT INTO `shop_order_status` SET `order_status_id`=1, `order_status_name`='Processing';
INSERT INTO `shop_order_status` SET `order_status_id`=2, `order_status_name`='Shipped';
INSERT INTO `shop_order_status` SET `order_status_id`=3, `order_status_name`='Complete';
INSERT INTO `shop_order_status` SET `order_status_id`=4, `order_status_name`='Rejected';

INSERT INTO `shop_payment_gateways` SET `payment_gateway_id`=1, `site_id`=1, `enabled`=1, `gateway_name`='Interac e-Transfer', `filename`='interac_etransfer', `sort`=1, `configuration`='';
INSERT INTO `shop_payment_gateways` SET `payment_gateway_id`=2, `site_id`=1, `enabled`=0, `gateway_name`='Credit or Debit Card', `filename`='stripe', `sort`=2, `configuration`="private_key=\npublic_key=\n\n";
INSERT INTO `shop_payment_gateways` SET `payment_gateway_id`=3, `site_id`=1, `enabled`=0, `gateway_name`='PayPal', `filename`='paypal_hosted', `sort`=3, `configuration`="business=\nnotify_url=\nreturn=\ncancel_return=\nsandbox=0\n";

INSERT INTO `shop_shipping_gateways` SET `shipping_gateway_id`=1, `site_id`=1, `enabled`=0, `gateway_name`='Choose a Carrier', `filename`='goshippo', `sort`=1, `configuration`='api_key=shippo_live_40cdfb32a669e1b462df412a59adfc0397c9c8dc\naddress=\ncity=\nprovince=ON\npostalcode=\ncountry=CA\ndefault_length=10\ndefault_width=10\ndefault_height=10\ndefault_weight=3\n';
INSERT INTO `shop_shipping_gateways` SET `shipping_gateway_id`=2, `site_id`=1, `enabled`=0, `gateway_name`='Flat Rate', `filename`='flatrate', `sort`=2, `configuration`="rate=20\n";
INSERT INTO `shop_shipping_gateways` SET `shipping_gateway_id`=3, `site_id`=1, `enabled`=1, `gateway_name`='Pickup In Store', `filename`='pickup', `sort`=3, `configuration`='';

INSERT INTO `shop_taxes` SET `tax_id`=1, `site_id`=1, `tax_name`='GST', `tax_percentage`=0.05000, `tax_country`='CA', `tax_province`='AB';
INSERT INTO `shop_taxes` SET `tax_id`=2, `site_id`=1, `tax_name`='GST', `tax_percentage`=0.05000, `tax_country`='CA', `tax_province`='BC';
INSERT INTO `shop_taxes` SET `tax_id`=3, `site_id`=1, `tax_name`='PST', `tax_percentage`=0.07000, `tax_country`='CA', `tax_province`='BC';
INSERT INTO `shop_taxes` SET `tax_id`=4, `site_id`=1, `tax_name`='GST', `tax_percentage`=0.05000, `tax_country`='CA', `tax_province`='MB';
INSERT INTO `shop_taxes` SET `tax_id`=5, `site_id`=1, `tax_name`='PST', `tax_percentage`=0.08000, `tax_country`='CA', `tax_province`='MB';
INSERT INTO `shop_taxes` SET `tax_id`=6, `site_id`=1, `tax_name`='HST', `tax_percentage`=0.13000, `tax_country`='CA', `tax_province`='NB';
INSERT INTO `shop_taxes` SET `tax_id`=7, `site_id`=1, `tax_name`='HST', `tax_percentage`=0.13000, `tax_country`='CA', `tax_province`='NL';
INSERT INTO `shop_taxes` SET `tax_id`=8, `site_id`=1, `tax_name`='GST', `tax_percentage`=0.05000, `tax_country`='CA', `tax_province`='NT';
INSERT INTO `shop_taxes` SET `tax_id`=9, `site_id`=1, `tax_name`='HST', `tax_percentage`=0.15000, `tax_country`='CA', `tax_province`='NS';
INSERT INTO `shop_taxes` SET `tax_id`=10, `site_id`=1, `tax_name`='GST', `tax_percentage`=0.05000, `tax_country`='CA', `tax_province`='NU';
INSERT INTO `shop_taxes` SET `tax_id`=11, `site_id`=1, `tax_name`='HST', `tax_percentage`=0.13000, `tax_country`='CA', `tax_province`='ON';
INSERT INTO `shop_taxes` SET `tax_id`=12, `site_id`=1, `tax_name`='HST', `tax_percentage`=0.14000, `tax_country`='CA', `tax_province`='PE';
INSERT INTO `shop_taxes` SET `tax_id`=13, `site_id`=1, `tax_name`='GST', `tax_percentage`=0.05000, `tax_country`='CA', `tax_province`='QC';
INSERT INTO `shop_taxes` SET `tax_id`=14, `site_id`=1, `tax_name`='QST', `tax_percentage`=0.09975, `tax_country`='CA', `tax_province`='QC';
INSERT INTO `shop_taxes` SET `tax_id`=15, `site_id`=1, `tax_name`='GST', `tax_percentage`=0.05000, `tax_country`='CA', `tax_province`='SK';
INSERT INTO `shop_taxes` SET `tax_id`=16, `site_id`=1, `tax_name`='PST', `tax_percentage`=0.05000, `tax_country`='CA', `tax_province`='SK';
INSERT INTO `shop_taxes` SET `tax_id`=17, `site_id`=1, `tax_name`='GST', `tax_percentage`=0.05000, `tax_country`='CA', `tax_province`='YT';