SET FOREIGN_KEY_CHECKS=0;

INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('location_address1', 'Company', '', '*Your company address*', 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="vendor1@example.com" AND `order_id` IS null));
INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('location_state', 'Company', '', 576, 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="vendor1@example.com" AND `order_id` IS null));
INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('location_city', 'Company', '', 'New York', 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="vendor1@example.com" AND `order_id` IS null));
INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('location_zipcode', 'Company', '', '10001', 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="vendor1@example.com" AND `order_id` IS null));
INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('location_country', 'Company', '', 'US', 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="vendor1@example.com" AND `order_id` IS null));
INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('origin_use_company', 'Company', '', '1', 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="vendor1@example.com" AND `order_id` IS null));

INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('location_address1', 'Company', '', '*Your company address*', 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="partner2@example.com" AND `order_id` IS null));
INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('location_state', 'Company', '', 576, 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="partner2@example.com" AND `order_id` IS null));
INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('location_city', 'Company', '', 'New York', 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="partner2@example.com" AND `order_id` IS null));
INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('location_zipcode', 'Company', '', '10001', 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="partner2@example.com" AND `order_id` IS null));
INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('location_country', 'Company', '', 'US', 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="partner2@example.com" AND `order_id` IS null));
INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('origin_use_company', 'Company', '', '1', 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="partner2@example.com" AND `order_id` IS null));

INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('location_address1', 'Company', '', '*Your company address*', 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="seller3@example.com" AND `order_id` IS null));
INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('location_state', 'Company', '', 576, 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="seller3@example.com" AND `order_id` IS null));
INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('location_city', 'Company', '', 'New York', 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="seller3@example.com" AND `order_id` IS null));
INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('location_zipcode', 'Company', '', '10001', 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="seller3@example.com" AND `order_id` IS null));
INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('location_country', 'Company', '', 'US', 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="seller3@example.com" AND `order_id` IS null));
INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('origin_use_company', 'Company', '', '1', 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="seller3@example.com" AND `order_id` IS null));

INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('location_address1', 'Company', '', '*Your company address*', 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="merchant4@example.com" AND `order_id` IS null));
INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('location_state', 'Company', '', 576, 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="merchant4@example.com" AND `order_id` IS null));
INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('location_city', 'Company', '', 'New York', 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="merchant4@example.com" AND `order_id` IS null));
INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('location_zipcode', 'Company', '', '10001', 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="merchant4@example.com" AND `order_id` IS null));
INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('location_country', 'Company', '', 'US', 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="merchant4@example.com" AND `order_id` IS null));
INSERT INTO `%%XC%%_config` (`name`, `category`, `type`, `value`, `orderby`, `vendor_id`) VALUES ('origin_use_company', 'Company', '', '1', 0, (SELECT `profile_id` FROM `%%XC%%_profiles` WHERE `login`="merchant4@example.com" AND `order_id` IS null));


SET FOREIGN_KEY_CHECKS=1;
