|
1
|
|
|
2
|
|
|
3
|
|
|
4
|
|
|
5
|
|
|
6
|
|
|
7
|
|
|
8
|
|
|
9
|
|
|
10
|
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
|
|
11
|
START TRANSACTION;
|
|
12
|
SET time_zone = "+00:00";
|
|
13
|
|
|
14
|
|
|
15
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
16
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
17
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
18
|
/*!40101 SET NAMES utf8mb4 */;
|
|
19
|
|
|
20
|
|
|
21
|
|
|
22
|
|
|
23
|
|
|
24
|
|
|
25
|
|
|
26
|
|
|
27
|
|
|
28
|
|
|
29
|
|
|
30
|
CREATE TABLE `affPrograms` (
|
|
31
|
`id` int(10) UNSIGNED NOT NULL,
|
|
32
|
`affProgram` varchar(128) DEFAULT NULL,
|
|
33
|
`affUrl` varchar(255) DEFAULT NULL,
|
|
34
|
`refUrl` varchar(255) DEFAULT NULL,
|
|
35
|
`PPCdoorway` varchar(255) DEFAULT NULL,
|
|
36
|
`commission` varchar(128) DEFAULT NULL,
|
|
37
|
`paidVia` varchar(128) DEFAULT NULL,
|
|
38
|
`notes` text CHARACTER SET utf8,
|
|
39
|
`disc` varchar(128) DEFAULT NULL,
|
|
40
|
`discText` varchar(128) DEFAULT NULL,
|
|
41
|
`discCode` varchar(128) DEFAULT NULL,
|
|
42
|
`discInstructions` varchar(1024) DEFAULT NULL,
|
|
43
|
`categories` varchar(128) DEFAULT NULL,
|
|
44
|
`type` int(8) DEFAULT NULL
|
|
45
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
46
|
|
|
47
|
|
|
48
|
|
|
49
|
|
|
50
|
|
|
51
|
INSERT INTO `affPrograms` (`id`, `affProgram`, `affUrl`, `refUrl`, `PPCdoorway`, `commission`, `paidVia`, `notes`, `disc`, `discText`, `discCode`, `discInstructions`, `categories`, `type`) VALUES
|
|
52
|
(10, 'Electrum', 'https://www.refersion.com/affiliate/login', 'https://www.electrumpickleball.com/?rfsn=7882298.f1642fa', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '15%', 'PP cgpaypal', '', '20%', '20% off using discount code SWEET20', 'SWEET20', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
|
|
53
|
(9, 'Diadem', 'https://af.uppromote.com/diademsports/login', 'https://diademsports.com?sca_ref=5979421.egJRoZGpGo', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '10%', 'ACH SSB', 'They might raise the commission to SixZero level of 15% if I generate a lot of sales.', '10%', '10% off using discount code DINKER10', 'DINKER10', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
|
|
54
|
(8, 'CRBN', '', 'https://crbnpickleball.com/', '', '', '', '', '10%', '10% off using discount code tanner', 'tanner', 'Enter discount code during checkout.', 'GEAR', 1),
|
|
55
|
(6, 'Civile Pickleball Apparel', 'https://app.simple-affiliate.com/affiliate', 'https://www.civileapparel.com/r?id=0bs6k8', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '???', '???', 'ce@l', '20%', '20% off using discount code CRAIG', 'CRAIG', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
|
|
56
|
(7, 'Courtside Tennis & Pickleball', 'https://af.uppromote.com/courtsidetennisandpickleball/login', 'https://courtsidetennis.com?sca_ref=5592276.HFxhmcFAPB', 'Pickleballdiscountcodes.com', '20%', 'Venmo', 'No discount available, only commission.', '10%', '10% off link sometimes works.', '(none)', 'Click to activate discount.', 'GEAR', 0),
|
|
57
|
(5, 'Bread & Butter Pickleball', 'https://app.impact.com/login.user', 'https://www.bnbpickleball.com/discount/norwalk', 'breadandbutterdiscount.com', '10%', 'ACH', '', '15%', '15% off using discount code NORWALK', 'NORWALK', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
|
|
58
|
(4, 'BALLR Pickleball', 'https://ballrpickleball.com/affiliate-home/affiliate-login/', 'https://ballrpickleball.com/?wpam_id=68', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '10%', 'PP cgpay', '50% off a single paddle coupon after you achieve 3 sales. Ref link credits the commission, customer must enter the code to get the discount.', '10%', '10% off using discount code CHRISBO', 'CHRISBO', 'Enter discount code during checkout.', 'GEAR', 0),
|
|
59
|
(3, 'Aniviia Pickleball', 'None', 'https://www.aniviia.com/discount/ANIVIIA10', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '20%', 'ACH', 'Christine offered to pull a monthly report to show all sales coded to your code, I told her not to bother.', '10%', '$10 off using discount code ANIVIIA10', 'ANIVIIA10', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
|
|
60
|
(2, 'AISO Pickleball', 'https://af.uppromote.com/aiso/login', 'https://aisopickleball.com?sca_ref=6364905.yLdWYQsuPy', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '$5 ', 'PP, p@h', 'ce@l, $20 off personal paddle purchases twice a year.', '10%', '10% off using discount code CleoE10', 'CleoE10', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
|
|
61
|
(1, '11six24 Pickleball', 'https://af.uppromote.com/11six24-pickleball/login', 'https://11six24.com?sca_ref=5549312.EC3PhBWsge', '11six24discount.com', '$10 ', 'Venmo', 'Plus a free paddle every 50 sales.', '$10 ', '$10 off using discount code KELLYJ', 'KELLYJ', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
|
|
62
|
(11, 'Engage', '', 'http://www.engagepickleball.com', '', '', '', '', '20%', '20% off using discount code 20tomasello', '20tomasello', 'Enter code during checkout.', 'GEAR', 1),
|
|
63
|
(12, 'Friday Pickleball', 'None', 'https://fridaypickle.com/discount/FRIDAYFUNN', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '$15 ', 'PP p@h', 'I arranged FRIDAYFUNN to be a $10 discount (two paddles for $90), reducing my commission to $15. No aff link, custom discount code.', '$10 ', 'Second paddle is $20 instead of $30 using discount code FRIDAYFUNN', 'FRIDAYFUNN', 'Click to activate discount. Get two paddles for $90 instead of $100. If you do test these paddles against other $100-$200 paddles, many would choose this paddle. It is A- or better-rated for EVERY categrory instead of being A+ for some categrories and being below-A rated for somecategories, resulting in a lower overall rating. ! $90 FOR TWO OF THESE PADDLES IS THE MOST AWESOME VALUE (as of May 2024) - and they offer a 90-DAY RETURN POLICY, so you have no risk!', 'GEAR', 0),
|
|
64
|
(13, 'Gamma', '', 'http://www.gammasports.com', '', '', '', '', '25%', '25% off using discount code Teresa25', 'Teresa25', 'Enter code during checkout.', 'GEAR', 1),
|
|
65
|
(14, 'Gruvn', '', 'https://gruvn.co?sca_ref=5264884.k3WiqCfNtA', '', '', '', '', '15%', '15% off', '(none)', 'Click to activate discount.', 'GEAR', 1),
|
|
66
|
(15, 'Honolulu Pickleball Company', 'https://af.uppromote.com/4009c8-2/login', 'https://808pickle.com?sca_ref=5644372.AqjuAyEsAx', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '20%', 'Venmo', 'Can purchase one of each model with a 35% discount. Let nina@808pickle.com know when you want some.', '10%', '10% off using discount code SURFERGUY', 'SURFERGUY', 'Enter discount code during checkout.', 'GEAR', 0),
|
|
67
|
(16, 'Invis Sport Glasses', '', 'http://www.invissports.com', '', '', '', '', '15%', '15% off using discount code JILLT15', 'JILLT15', 'Enter discount code during checkout.', 'GEAR', 1),
|
|
68
|
(17, 'Joola Pickleball', '', 'https://joolausa.com/?ref=8190', '', '', '', '', '10%', '10% off using discount code 10EFFECT', '10EFFECT', 'Click to activate discount (or enter code during checkout).', 'GEAR', 1),
|
|
69
|
(18, 'Just Paddles', 'https://www.justpaddles.com/?rfsn=7943331.661ee47', 'https://www.justpaddles.com/?rfsn=7943331.661ee47&promo=HAPPY10', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '4-10%', 'PayPal', 'p@h', '10%', '10% off using discount code HAPPY10', 'HAPPY10', 'Click to activate discount (or enter code during checkout). Excluded: Babolat, Gearbox, HEAD, JOOLA, Selkirk, and Warstic.', 'GEAR', 0),
|
|
70
|
(19, 'Lix Pickleball', 'None', 'https://lixpickleball.com/', '', '', '', '', '$15 ', '$15 off paddles using discount code Xuan15', 'Xuan15', 'Enter code during checkout.', 'GEAR', 0),
|
|
71
|
(20, 'Komodo Pickleball', 'https://komodopickleball.com/affiliate-dashboard/', 'https://komodopickleball.com/ref/137/', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '10%', 'PayPal', 'Code ZALESKI gets 40% off up to 5 paddles when ordred from my email.', '15%', '15% off using discount code CT15', 'CT15', 'Enter code during checkout.', 'GEAR', 0),
|
|
72
|
(21, 'Luxury Pickleball Vacations', 'https://af.uppromote.com/Luxurypickleball/login', 'https://luxurypickleball.com/pages/lux-vacations?sca_ref=5449206.SU9PBgSYcA', 'Direct to referral link, possibly setup a domain later if we get any commissions.', '10%', 'ACH', 'Not clear there would be a net benefit to making people click twice. Lowered Max CPC bid to $0.11 on both platforms.', 'Varies', 'Discount varies by package', '(none)', 'Click to activate discount.', 'GEAR', 0),
|
|
73
|
(22, 'Mark Pickleball', 'https://af.uppromote.com/495311-2/login', 'https://markpickleball.com?sca_ref=5642247.Vclv6MR4XU', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '10%', 'PP cgpay', 'k@g', '10%', '10% off using discount code AMB-HAPPY', 'AMB-HAPPY', 'Enter code during checkout. Their paddles have AMAZING spin, among the best in the world at a lower price!', 'GEAR', 0),
|
|
74
|
(23, 'Neonic Pickleball', 'https://af.uppromote.com/neonic-pickleball/login', 'https://neonicpickleball.com?sca_ref=5691424.rbffbPhXeU', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '15%', 'PP cgpay', 'ce@l', '10%', '10% off using discount code CEDWARDS', 'CEDWARDS', 'Enter discount code during checkout.', 'GEAR', 0),
|
|
75
|
(24, 'OM Pickleball', 'None', 'https://ompickleball.com/', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '20%', 'quarterly check', 'Rep discount 30%: OMxREP. 40% off cosmetic blemish paddles', '10%', '10% off using discount code OMxNAMASTE', 'OMxNAMASTE', 'Enter code during checkout, includes free priority shipping.', 'GEAR', 0),
|
|
76
|
(25, 'Omega Pickleball', '', 'https://omegapickleball.com/', '', '', '', 'Christina', '20%', '20% off using discount code 20Hare', '20Hare', 'Enter code during checkout.', 'GEAR', 1),
|
|
77
|
(26, 'Phantom Pickleball', 'None', 'https://www.phantompickleball.com/', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '$20-$40', 'Zelle', 'c@l, chet edwards, 50% off demos, $20 per Eternal, $30 per Savage/Immortal/Sniper/Goliath and $40 per Trinity sold. Plus an extra 10% on all additional gear purchased.', '20%', '20% off using discount code AMChetE20', 'AMChetE20', 'Enter discount code during checkout.', 'GEAR', 0),
|
|
78
|
(27, 'Pickleball Apes', 'https://af.uppromote.com/pickleballapes/login', 'https://www.pickleballapes.com?sca_ref=5531049.ptrHTRIGeQ', 'pickleballapesdiscountcode.com', '15%', 'ACH', '', '10%', '10% off using discount code Dinker', 'Dinker', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
|
|
79
|
(28, 'Pickleball Clearance', 'https://pickleball-clearance.goaffpro.com/', 'https://www.pickleballclearance.com/?ref=AN7m3ILx4JDd7b', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '5%', 'TBD', '', '10%', '10% off using discount code CHETEWING', 'CHETEWING', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
|
|
80
|
(29, 'Pickleball Superstore', 'https://pickleballsuperstore.com/account', 'https://pickleballsuperstore.com/discount/Kathy-108913', 'Direct to referral link', '10%', 'PP Tier 1: p@h, Tier 2: cgpaypal', 'Tier 1: Connor Brooks, c@l. Tier 2: Kathy Zaleski kazaleski@gmail.com. Pays Tier 1 an extra 4-10% of Tier 2\'s sales, 2% bonus for top-selling affiliates.', '10%', '10% off using discount code Kathy-108913', 'Kathy-108913', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
|
|
81
|
(30, 'ProDrive', 'https://f40c4290-4c50-40a8-99ad-b0bda53185b7.goaffpro.com/', 'https://www.prodrivepickleball.com/?ref=3uPw3tutWQ4NTW', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '15%', 'store credit', 'Can get $50 off one paddle with code Ambassador50off. Insted of getting a free paddle for every 5th time your code is used, you get a store credit for a value of 15% of the sales every time your code is used.', '10%', '10% off using discount code 10PCTOFF', '10PCTOFF', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
|
|
82
|
(31, 'Proton', '', 'https://protonsports.com', '', '', '', '', '20%', '20% off using discount code JOHNKEW', 'JOHNKEW', 'Enter discount code during checkout.', 'GEAR', 1),
|
|
83
|
(32, 'Pro XR Pickleball', 'https://proxrpickleball.com/account/login', 'https://i.refs.cc/FC5yiZVT?smile_ref=eyJzbWlsZV9zb3VyY2UiOiJzbWlsZV91aSIsInNtaWxlX21lZGl1bSI6IiIsInNtaWxlX2NhbXBhaWduIjoicmVmZXJyYWxfcHJvZ3JhbSIsInNtaWxlX2N1c3RvbWVyX2lkIjoyMTAxNjQ5MDc1fQ%3D%3D', 'proxrdiscount.com', '$20 ', 'Store credit via $20 coupon codes.', 'Hopefully they stack.', '$20 ', '$20 off Pro XR (Zane Navratil\'s) pickleball gear', '(none)', 'Click to activate discount.', 'GEAR', 0),
|
|
84
|
(33, 'Ronbus', '', 'https://www.ronbus.com/', '', '', '', '', '10%', '10% off using discount code 10JOHNKEW', '10JOHNKEW', 'Enter discount code during checkout.', 'GEAR', 1),
|
|
85
|
(34, 'Six Zero Pickleball', 'https://af.uppromote.com/six-zero-7668/login', 'https://www.sixzeropickleball.com/collections/paddles?sca_ref=3661223.VM3GFcZKzQ', 'sixzerodiscount.com sixzerodiscountcode.com', '15%', 'PayPal', 'k@g, Both redirect to pickleballdiscountcodes.com, must enter code ZALESKI10 during checkout. I get 15% off.', '10%', '10% off using discount code ZALESKI10', 'ZALESKI10', 'Enter discount code during checkout.', 'GEAR', 0),
|
|
86
|
(35, 'Selkirk', '', 'https://selkirk,com', '', '', '', '', '10%', '10% gift card using discount code ADV-YVONNED', 'ADV-YVONNED', 'Enter discount code during checkout. Get a gift card from selkirk for 10% of your purchase in 7-10 days.', 'GEAR', 1),
|
|
87
|
(36, 'Spartus Pickleball', 'https://af.uppromote.com/gospartus/login', 'https://gospartus.com?sca_ref=5691368.DafinwVk03', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '$10 ', 'PP p@h', 'Use link or enter code CHADSTER during checkout. I can get 20% off a paddle.', '10%', '10% off using discount code CHADSTER', 'CHADSTER', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
|
|
88
|
(37, 'Spinshot Ball Machines', 'https://af.uppromote.com/spinshot-sports-us/login', 'https://spinshotsports.com?sca_ref=6010738.38R57oKnP8', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '8%', 'PP p@h', 'Use link for $100 off.', '$100 ', '$100 off', '(none)', 'Click to activate discount. Best of the best, elevate your game quickly with these, better than Titan.', 'GEAR', 0),
|
|
89
|
(38, 'Titan Ball Machines', '', 'https://titanballmachines.com/john', '', '', '', '', '$100 ', '$100 off', '(none)', 'Click to activate discount. Not as good as Spinshot. but some might want this discount anyway.', 'GEAR', 1),
|
|
90
|
(39, 'TopspinPro Pickleball Training Aid', 'https://topspinpro.com/partners/dashboard/', 'https://topspinpro.com/discount/xuan10/', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '10%', 'PP p@h', 'Use link for 10% off.', '10%', '10% off', '(none)', 'Click to activate discount. Awesome tool to improve anyone\'s game.', 'GEAR', 0),
|
|
91
|
(40, 'Thrive Pickleball', '', 'https://thrivepb.com/', '', '', '', '', '10%', '10% off using discount code PICKLEBALLWILL', 'PICKLEBALLWILL', 'Enter discount code during checkout.', 'GEAR', 1),
|
|
92
|
(41, 'Vatic Pro Pickleball', 'https://af.uppromote.com/vatic-pro/login', 'https://vaticpro.com?sca_ref=5514235.xWA3qqCoNM', 'vaticprodiscountcode.com', '$5-10', 'PayPal', '$5 for Prism paddles, $10 for non-Prism paddles', '$10 ', '$10 off using discount code PHILLYJOE', 'PHILLYJOE', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
|
|
93
|
(42, 'Volair', 'https://volair.refersion.com/affiliate', 'https://www.volair.com/discount/BOSTON64?rfsn=7874724.538479&utm_source=refersion&utm_medium=affiliate&utm_campaign=7874724.538479', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '15%', 'PayPal', 'DO NOT post to coupon sites.', '10%', '10% off using discount code BOSTON64', 'BOSTON64', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
|
|
94
|
(43, 'Xenon', 'None (manual via Noah)', 'https://xenonpaddle.com/discount/pickle10?redirect=%2Fcollections%2Fpickleball-paddles', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '15%', 'ACH (not setup yet)', '$50 each for demos', '$10 ', '$10 off using discount code pickle10', 'pickle10', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0);
|
|
95
|
|
|
96
|
|
|
97
|
|
|
98
|
|
|
99
|
|
|
100
|
|
|
101
|
|
|
102
|
|
|
103
|
|
|
104
|
ADD PRIMARY KEY (`id`);
|
|
105
|
|
|
106
|
|
|
107
|
|
|
108
|
|
|
109
|
|
|
110
|
|
|
111
|
|
|
112
|
|
|
113
|
|
|
114
|
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;
|
|
115
|
COMMIT;
|
|
116
|
|
|
117
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
118
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|
119
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|