INSERT INTO product (sku, name, price, active, upgrade_id, group_id, priority)
SELECT mci.sku, mci.name, 0, 0, mci.upgrade_id, 1, 1
FROM upgrade AS u
JOIN mals_cart_item AS mci
ON u.id = mci.upgrade_id
WHERE u.type_id IS NOT NULL;

INSERT INTO website_info(name, description, img_url, product_id, old_price, is_sale_priced)
SELECT name, "", "", id, 0, 0
FROM product;

/* Dreamcade True Spin 2 */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET price = 99,
active = true,
old_price = 0,
description = "The Dreamcade True Spin 2 spinner with chrome knob and energy storage cylinder. Great for games like Tempest, Warlords and Super Breakout.",
img_url = "images/tooltip/spinner.jpg",
priority = 50,
group_id = 2
WHERE p.sku = "H7J6";

INSERT INTO product_to_arcade_type (product_id, arcade_type_id)
SELECT product.id, arcade_type.id
FROM product
CROSS JOIN arcade_type
WHERE arcade_type.short_name != "4pc" AND arcade_type.short_name != "clw" AND product.sku = "H7J6";

/* Turbo Twist 2 Spinner */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET price = 99,
active = true,
old_price = 0,
description = "Turbo Twist 2 spinner with black dimpled knob and energy storage cylinder. Great for games like Tempest, Warlords and Super Breakout.",
img_url = "images/tooltip/tt2.jpg",
priority = 50,
group_id = 2,
w.name = "Turbo Twist 2 Spinner"
WHERE p.sku = "WX8L";

INSERT INTO product_to_arcade_type (product_id, arcade_type_id)
SELECT product.id, arcade_type.id
FROM product
CROSS JOIN arcade_type
WHERE arcade_type.short_name = "4pc" AND product.sku = "WX8L";

/* Lighted 3 inch Trackball" */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET price = 169,
active = true,
old_price = 189,
description = "Upgrade your 2 1/4 inch trackball to a lighted multi-colored 3 inch trackball that is customizable. Features 3 different patterns and 8 solid colors including: Red, Green, Blue, Yellow, Orange, Purple, Light Blue, Light Purple.",
img_url = "images/tooltip/3inchTrackball.jpg",
is_sale_priced = false,
group_id = 2,
w.name = "3-inch Lighted Trackball",
priority = 40
WHERE p.sku = "UYWG";

INSERT INTO product_to_arcade_type (product_id, arcade_type_id)
SELECT product.id, arcade_type.id
FROM product
CROSS JOIN arcade_type
WHERE arcade_type.short_name != "4pc" AND arcade_type.short_name != "clw" AND product.sku = "UYWG";

/* Custom button colors */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
WHERE p.sku =  "X7L7";

/* Light Gun Pack - With Light Gun Game Pack */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 179,
p.active = true,
w.old_price = 199,
w.description = "Comes with a single Light Gun and 12 games. Includes: alien Attack, Balloon Paradise, Duck Shooter, Zombie Invasion, Gunslinger, Western sheriff, and 6 others! Please note: you must stand at least 3 feet from the monitor to use the light gun.",
w.img_url = "images/cabiocade/V2_BLUE_G500.jpg",
w.is_sale_priced = true,
p.priority = 50,
p.group_id = 3,
w.name = "Light Gun Pack",
w.is_sale_priced = false
WHERE p.sku = "ZQHR";

/* House of the Dead II */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET price = 79,
active = true,
old_price = 99,
description = "The classic zombie shooting game. Use with Light gun or Trackball. Light gun sold separately.",
img_url = "images/tooltip/houseofthedead.jpg",
group_id = 3,
is_sale_priced = true
WHERE p.sku = "1H0E";

/* Virtual 3-D Casino */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 39,
p.active = true,
w.old_price = 59,
w.description = "With over 40 games, this 3-D casino has everything from table games like blackjack and slots to craps machines and video poker.",
w.img_url = "",
w.name = "Virtual Casino pack by Hoyle Casino",
w.is_sale_priced = true
WHERE p.sku = "8VPH";

/* Video Slots Pack */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 35,
p.active = true,
w.old_price = 49,
w.description = "Over 45 actual video slots machines from Bally Gaming. Includes great machines with bonus rounds like Popeye, Blondie and Betty Boop.",
w.img_url = "",
w.name = "Video Slot pack by Bally Gaming",
w.is_sale_priced = true
WHERE p.sku = "M2Q5";

/* Authentic Video Slots */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 29,
p.active = 1,
w.old_price = 49,
w.description = "Includes both 9-line and bonus level video slots, 45 machines total. Each are actual machines you'd see in casinos like Red Hot 7's and Play the Market.",
w.img_url = "",
w.name = "Authentic Video Slot Pack",
w.is_sale_priced = 1
WHERE p.sku = "NCBU";

/* Hoyle Card Game Pack */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 39,
p.active = 1,
w.old_price = 59,
w.description = "From Poker to Old Maid, this pack comes with 20 favorite card games including: Bridge, Hearts, Spades, Pinochle, Crazy Eights and many more.",
w.img_url = "",
w.name = "Hoyle Card Games pack",
w.is_sale_priced = 1
WHERE p.sku = "W427";

/* Wireless Networking Adaptor */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET price = 39,
priority = 30,
active = true,
old_price = 49,
description = "Add a wireless adapter to your upright arcade cabinet to enable you to add more games for free via our exclusive Retro Reload software.",
img_url = "",
is_sale_priced = false,
group_id = 2
WHERE p.sku = "KM2F";

/* Pinball Arcade Pack */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 39,
p.active = true,
w.old_price = 49,
w.description = "Includes 6 classic pinball tables, all compatible
with your Dreamcade®.",
w.img_url = "images/cabiocade/cueball.jpg",
w.is_sale_priced = true
WHERE p.sku = "T9S5";

/* Taito Legends 1 arcade pack */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 149,
p.active = false,
w.old_price = 199,
w.description = "The Taito Legends arcade pack includes 29 classic arcade games. Including classics such as Space Invaders, Bubble Bobble, Elevator Action, Rainbow Islands, and many more",
w.img_url = "images/cabiocade/tlpack.jpg",
w.is_sale_priced = true
WHERE p.sku = "LQWB";

/* Taito Legends 2 arcade pack */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
WHERE p.sku = "V1XX";

/* Q*bert */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 49,
p.active = false,
w.old_price = 59,
w.description = "Includes both the original and enhanced versions of the classic arcade game with over 50 levels. This game does not play in full screen.",
w.img_url = "images/cabiocade/qbert.jpg",
w.is_sale_priced = true
WHERE p.sku = "MO6W";


/* Midway Arcade 2 pack */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 69,
p.active = 1,
w.old_price = 99,
w.description = "Includes 21 classic arcade games from Midway like, Gauntlet 2, APB and Mortal Kombat 1-3. The fighting games are Rated M due to violence.",
w.img_url = "images/cabiocade/midway2.jpg",
w.is_sale_priced = 1
WHERE p.sku = "694S";

/* Golden Tee Golf */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 99,
p.active = 1,
w.old_price = 0,
w.description = "Add the original Golden Tee Golf to your arcade.<br> 
Dream Arcades® is not affiliated with Incredible Technologies or its Golden Tee line of arcades; all support for this add-on pack is provided by Dream Arcades®.",
w.img_url = "images/cabiocade/gtgolf.jpg",
w.is_sale_priced = 0
WHERE p.sku = "NFUD";

/* Mad Dog McCree 1 */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET price = 39,
active = true,
old_price = 59,
description = "Enjoy this classic arcade gun game from Digital Leisure. Includes Mad Dog McCree. Light gun sold separately.",
img_url = "images/tooltip/maddog.jpg",
is_sale_priced = true,
group_id = 3
WHERE p.sku = "574U";

/* Namco 2 Game Pack */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 99,
p.active = 1,
w.old_price = 149,
w.description = "Includes the following games: Dig Dug® Galaga® Galaga 88® Galaxian® Sky Kid® Dragon Spirit® Bosconian® Rolling Thunder® Pole Position® Pole Position II®.",
w.img_url = "images/tooltip/games/namco2.jpg",
w.is_sale_priced = true
WHERE p.sku = "W296";

/* Include Decal Sticker */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET price = 0,
active = true,
old_price = 0,
description = 'If you would like a pair of 13" x 14 1/2" decals for the side of your arcade, we will provide them at no charge. (Note: Decals do not come applied)',
img_url = "images/cabiocade/sideArtNew.jpg",
is_sale_priced = false,
priority = 70,
group_id = 2
WHERE p.sku = "HFA8";

/* Sega Classics Pack */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
WHERE p.sku = "KLE5";

/* Angry Birds */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 29,
p.active = 1,
w.old_price = 49,
w.description = "The original Angry Birds, a challenging physics based demolition game. With over 250 levels and great replay value this game will keep you entertained for hours and hours. You can use the trackball that is included on your arcade to play.",
w.img_url = "images/tooltip/games/angry-birds.jpg",
w.is_sale_priced = 0
WHERE p.sku = "D5X7";

/* Angry Birds: Space */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 29,
p.active = 1,
w.old_price = 49,
w.description = "Add the Space edition of Angry Birds to your arcade. This version of Angry Birds adds new gameplay including planets, gravity, and boss fights. You can use the trackball that is included on your arcade gaming machine to play.",
w.img_url = "images/tooltip/games/angry-birds-space.jpg",
w.is_sale_priced = 0
WHERE p.sku = "SGFD";

/* Angry Birds: Star Wars */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 29,
p.active = 1,
w.old_price = 49,
w.description = "Add the Star Wars edition of Angry Birds to your
arcade. Plays the same as the original but with
added features and characters from the
franchise. You can use the trackball that is
included on your video arcade to play.",
w.img_url = "images/tooltip/games/angry-birds-star-wars.jpg",
w.is_sale_priced = 0
WHERE p.sku = "BJSB";

/* Dream Arcade's Buck Hunter */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 10,
p.active = true,
w.old_price = 40,
w.description = "The newest buck hunting title, with 14 levels of deer hunting action. Dream Arcades® Exclusive. Introductory priced. Light gun sold separately.",
w.img_url = "images/tooltip/games/DreamBuckHunter.jpg",
p.group_id = 3,
w.is_sale_priced = true
WHERE p.sku = "CM9R";

/* Activision Anthology Pack */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 69,
p.active = 1,
w.old_price = 99, 
w.description = "Our newest pack features over 45 classic games, like: Pitfall, River Raid, Chopper Command, and many more!",
w.img_url = "images/cabiocade/activision.jpg",
w.is_sale_priced = 1
WHERE p.sku = "T68P";

/* Capcom Classics Collection */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 89,
p.active = 1,
w.old_price = 99,
w.description = "22 of our most popular games, like Street Fighter II, 1942, Ghosts'n Goblins, Commando, and more!",
w.img_url = "images/cabiocade/capcom.jpg",
w.is_sale_priced = 1
WHERE p.sku = "97AD";

/* Metal Slug Collection */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 39,
p.active = 1,
w.old_price = 49,
w.description = "This collection of games includes the original Metal Slug, Metal Slug X (Metal Slug 2 upgraded), and Metal Slug 3.",
w.img_url = "",
w.is_sale_priced = 0
WHERE p.sku = "SBW8";

/* Sonic Mega Collection Plus */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 39,
p.active = false,
w.old_price = 49,
w.description = "Over a dozen classic Sonic games including Sonic the Hedgehog, Sonic 2, Sonic 3, Sonic & Knuckles, Sonic 3D Blast, Sonic Spinball, Dr. Robotnik's Mean Bean Machine, Blue Sphere, Knuckles in Sonic 2, Sonic 3 & Knuckles, Flicky, Ristar, Comix Zone, and The Ooze.",
w.img_url = "images/tooltip/games/sonicmega.jpg",
w.name = "Sonic Mega Collection Plus",
w.is_sale_priced = false
WHERE p.sku = "J7UH";

/* Sega Genesis and Mega Drive Classics */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 99,
p.active = true,
w.old_price = 199,
w.description = "Feeling nostalgic? At 59 titles, you get endless hours of the classic Genesis gaming that you remember.",
w.img_url = "images/cabiocade/segaGenesisClassics.png",
w.is_sale_priced = false
WHERE p.sku = "ZRIA";

/* + free Wild West Shoot-Out */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
WHERE p.sku = "4F9I";

/* + free Casino and Slots Pack */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
WHERE p.sku = "7DT8";

/* + free Classic Clones Arcade Pack */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
WHERE p.sku = "8FKP";

/* Disguise as a fridge */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET price = 0,
active = true,
old_price = 0,
description = "Giving a surprise gift? We can disguise the shipping box as a fridge at no charge so your loved one will think it's a fridge, not an arcade.",
img_url = "images/tooltip/fridge.jpg",
is_sale_priced = false,
group_id = 2,
priority = 80,
w.name = "Disguise As A Fridge"
WHERE p.sku = "04G6";

/* + 250 included games! */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
WHERE p.sku = "THKS";

/* 1TB Hard Drive Upgrade */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET price = 149,
active = true,
old_price = 199,
description = "Add a huge 1 terabyte hard drive to your stand-up arcade gaming cabinet so you can add thousands of games with our Retro Reload Software.",
img_url = "",
is_sale_priced = false,
priority = 20,
group_id = 2
WHERE p.sku = "HYA1";

/* Angry Birds: Seasons */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 19,
p.active = 1,
w.old_price = 49,
w.description = "Add the Seasons edition of Angry Birds to your arcade cabinet. Plays the same as the original but with added features. You can use the trackball that is included on your video arcade to play.",
w.img_url = "images/tooltip/games/angry-birds-seasons.jpg",
w.is_sale_priced = 0
WHERE p.sku = "NJNX";

/* 4-player Stand-up Upgrade */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET price = 149,
active = true,
old_price = 0,
description = 'With just two bolts and minimal assembly, it’s simple to convert your cocktail arcade machine to the ultimate stand-up for 4-players. It’s the perfect height for not only gaming but also set your beverages on. <span style="font-weight:bold;">Base must be purchased when purchasing the arcade, some assembly required.</span>
<br><br>Raises the arcade 11". <span class="sale-price">This option may delay the shipment of your arcade.</span>',
img_url = "images/tooltip/cocktail_upgrade.jpg",
is_sale_priced = false,
group_id = 2,
w.name = "Turn Your Cocktail Arcade into a 4-player Stand-up"
WHERE p.sku = "1UIG";

INSERT INTO product_to_arcade_type (product_id, arcade_type_id)
SELECT product.id, arcade_type.id
FROM product
CROSS JOIN arcade_type
WHERE arcade_type.short_name = "4pc" AND product.sku = "1UIG";

/* Konami Pack */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 95,
p.active = 0,
w.old_price = 0,
w.description = "Includes 5 Konami classic games: Castlevania, Contra,Super Contra, Castlevania II & Castlevania III.",
w.img_url = "",
w.name = "Konami Pack",
w.is_sale_priced = 0
WHERE p.sku = "FMJJ";

/* Coin Door */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET price = 175,
active = true,
old_price = 225,
description = "Add an authentic coin door with lighted reject button. Accepts quarters, but games are set to free play only. Hearing those coins drop is the ultimate Retro Flashback. <span class='sale-price'>This option may delay the shipment of your arcade.</span>",
img_url = "images/product/SAJU/",
is_sale_priced = false,
w.name = "Add a Coin Door (Non-Functional)",
priority = 60,
group_id = 2
WHERE p.sku = "SAJU";


INSERT INTO product_to_arcade_type (product_id, arcade_type_id)
SELECT product.id, arcade_type.id
FROM product
CROSS JOIN arcade_type
WHERE arcade_type.short_name != "4pc" AND arcade_type.short_name != "clw" AND product.sku = "SAJU";

/* Big Buck Hunter Pro */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 49,
p.active = true,
w.old_price = 99,
w.description = "Play the hit arcade game on your arcade machine. Includes over 150 different levels. Add-on hunts not available.",
w.img_url = "images/tooltip/games/bigbuckhunter.jpg",
p.group_id = 3,
w.is_sale_priced = true 
WHERE p.sku = "FVI7";

/* WWF WrestleMania: The Arcade Game */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 39,
p.active = true,
w.old_price = 0,
w.description = "WWF WrestleMania - 1995 arcade version. Includes 8 classic wrestlers: Bret Hart, The Undertaker, Shawn Michaels, Razor Ramon, Bam Bam Bigelow, Yokozuna, Doink the Clown, and Lex Luger.",
w.img_url = "images/tooltip/games/WWF.jpg",
w.name = "WWF WrestleMania: The Arcade Game",
p.name = "WWF WrestleMania: The Arcade Game",
w.is_sale_priced = false
WHERE p.sku = "ADIT";

/* Mega Man X Collection */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 49,
p.active = 1,
w.old_price = 59,
w.description = "Includes Capcom's Mega Man X 1-6, plus Mega Man Battle and Chase. That's 7 great games for one low price.",
w.img_url = "images/tooltip/games/megamanx.jpg",
w.name = "Mega Man X Collection",
w.is_sale_priced = 0
WHERE p.sku = "V6O8";

/* Street Fighter Anniversary Collection */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 39,
p.active = true,
w.old_price = 49,
w.description = "Includes two classic Street Fighter Games: Hyper Street Fighter II, and Street Fighter III: 3rd Strike.",
w.img_url = "images/tooltip/games/SF3rdStrike.png",
w.is_sale_priced = false
WHERE p.sku = "6DJC";

/* Mad Dog McCree 2 */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET price = 39,
active = true,
old_price = 59,
description = "Enjoy this classic arcade gun game from Digital Leisure. Includes Mad Dog McCree 2. Light gun sold separately.",
img_url = "images/tooltip/games/mdm2.jpg",
is_sale_priced = true,
group_id = 3
WHERE p.sku = "IA9K";

/* The Last Bounty Hunter */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET price = 39,
active = true,
old_price = 59,
description = "Enjoy this classic arcade gun game from Digital Leisure where you hunt down criminals. Light gun sold separately.",
img_url = "images/tooltip/games/lastbounty.jpg",
is_sale_priced = true,
group_id = 3
WHERE p.sku = "0UD7";

/* Area 51 */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET p.price = 59,
p.active = true,
w.old_price = 79,
w.description = "Enjoy this arcade classic where you stop an alien invasion from attacking Area 51! Light gun sold separately.",
w.img_url = "images/tooltip/games/a51.jpg",
p.group_id = 3,
w.is_sale_priced = true
WHERE p.sku = "34MI";

/* Who Shot Johnny Rock? */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET price = 59,
active = true,
old_price = 59,
description = "Enjoy this classic arcade gun game from Digital
Leisure where you solve the murder of Johnny Rock. Light gun sold
separately.",
img_url = "images/tooltip/games/wsjr.jpg",
is_sale_priced = true,
group_id = 3
WHERE p.sku = "5GWA";

/* RGB LED Accent Lighting */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET active = false
WHERE p.sku = "FH9E";

/* Unbreakable NEON Sign */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET active = false
WHERE p.sku = "KIM4";