affiliate_campaign_insert.sql

affiliate_campaign_insert.sql

TRUNCATE mageplaza_affiliate_campaign;

INSERT INTO `mageplaza_affiliate_campaign` (`campaign_id`, `name`, `description`, `status`, `website_ids`, `affiliate_group_ids`, `from_date`, `to_date`, `display`, `sort_order`, `conditions_serialized`, `actions_serialized`, `commission`, `discount_action`, `discount_amount`, `discount_qty`, `discount_step`, `discount_description`, `free_shipping`, `apply_to_shipping`, `created_at`, `updated_at`, `apply_discount_on_tax`, `customer_group_ids`, `stop_rules_processing`)
VALUES
	(1, 'FHCB Affiliates', 'Default program for the Family Home Christian Books system.', 1, '1', '1,2,3,4,5,6', NULL, NULL, 1, 0, '{\"type\":\"Magento\\\\SalesRule\\\\Model\\\\Rule\\\\Condition\\\\Combine\",\"attribute\":null,\"operator\":null,\"value\":\"1\",\"is_value_processed\":null,\"aggregator\":\"all\",\"conditions\":[{\"type\":\"Magento\\\\SalesRule\\\\Model\\\\Rule\\\\Condition\\\\Product\\\\Found\",\"attribute\":null,\"operator\":null,\"value\":\"1\",\"is_value_processed\":null,\"aggregator\":\"all\",\"conditions\":[{\"type\":\"Magento\\\\SalesRule\\\\Model\\\\Rule\\\\Condition\\\\Product\",\"attribute\":\"category_ids\",\"operator\":\"()\",\"value\":\"3,6,28,30,29,33,31,32,34,7,35,36,37,38,42,9,10,12,11,39,40,41,43,16,8,13\",\"is_value_processed\":false,\"attribute_scope\":\"\"}]}]}', '{\"type\":\"Magento\\\\SalesRule\\\\Model\\\\Rule\\\\Condition\\\\Product\\\\Combine\",\"attribute\":null,\"operator\":null,\"value\":true,\"is_value_processed\":null,\"aggregator\":\"all\"}', '{\"tier_1\":{\"type\":\"1\",\"value\":\"25\",\"type_second\":\"1\",\"value_second\":\"25\",\"name\":\"Tier 1\"}}', 'by_percent', 0.0000, 0, 0, NULL, NULL, 0, '2020-09-09 22:50:18', '2021-08-18 13:59:10', 0, '0,1', 0);