--
-- Host: localhost    Database: maneattraction
-- ------------------------------------------------------


--
-- Table structure for table `Category`
--

CREATE TABLE `Category` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `protected` int(11) NOT NULL DEFAULT '0',
  `display` int(11) NOT NULL DEFAULT '0',
  `next` int(11) NOT NULL DEFAULT '0',
  `child` int(11) NOT NULL DEFAULT '0',
  `description` blob,
  `short_description` blob,
  `name` varchar(50) DEFAULT NULL,
  `image` varchar(50) DEFAULT NULL,
  `old_id` smallint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Category`
--

INSERT INTO `Category` VALUES (1,0,0,0,17,NULL,NULL,'Top Level',NULL,0),(33,0,1,0,0,'',NULL,'Gift Certificates<br>','',0),(17,0,1,18,0,'<center><img src=\"Images/Logo-Bumble-and-bumble.jpg\"></center>\r\n<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\">\r\n  <tr>\r\n    <td width=\"22%\">\r\n<p> </p>\r\n      <p><img src=\"Images/Bb-Core-Line-1.jpg\" width=\"100\" height=\"150\"></p>\r\n      <p><img src=\"Images/Treatment-10.jpg\" width=\"100\" height=\"169\"></p></td>\r\n    <td width=\"78%\" valign=\"top\"><p> </p>\r\n      <p><font size=\"2\">We are proud to be a Bumble and bumble Network Salon. \r\n        You’ve probably seen it in Vogue and W. Less than 1% of the salons in \r\n        the United States are selected to carry this prestigious line. Additionally \r\n        we are also one of the select few Bumble and bumble Treatment Salons across \r\n        the country. Bb Treatment is a revolutionary new hair care system utilizing \r\n        skin care technology. It takes a holistic approach by treating the root \r\n        cause of your hair and scalp concerns. There are four regimens that our \r\n        stylist will customize for your particular needs. They are; Damaged Therapy \r\n        for chemically treated hair, Dehydration for naturally or environmentally \r\n        dry hair, Scalp Rebalancing for dry, itchy scalp and Density for thinning \r\n        hair. Stop by our salon for a complimentary consultation and prescription \r\n        for your ideal Bumble and bumble home care program. </font></p>\r\n      <p align=\"center\"><a href=\"http://www.bumbleandbumble.com/product/index.tmpl?salon_id=MANE01\" target=\"_blank\">Click Here </a>to purchase Bumble &amp; Bumble products </p>\r\n      <p align=\"center\"><a href=\"http://www.bumbleandbumble.com/product/index.tmpl?salon_id=MANE01\"><img src=\"Images/shopbumble_tall_170x70.gif\" alt=\"Bumble &amp; Bumble Products\" border=\"0\"></a></p></td>\r\n  </tr>\r\n</table>',NULL,'Bumble and Bumble','',0),(18,0,1,33,0,'',NULL,'Aveda','AvedaLogo2009.jpg',0);

--
-- Table structure for table `Inventory`
--

CREATE TABLE `Inventory` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `productID` int(11) NOT NULL DEFAULT '0',
  `categoryID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `categoryID` (`categoryID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=470 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Inventory`
--

INSERT INTO `Inventory` VALUES (367,1,19),(368,2,19),(364,3,19),(365,4,19),(366,5,19),(369,6,19),(371,7,19),(373,8,20),(376,9,20),(375,10,20),(377,11,20),(378,12,20),(380,13,21),(381,14,21),(382,15,21),(383,16,21),(384,17,21),(385,18,21),(386,19,22),(387,20,22),(388,21,22),(389,22,23),(390,23,23),(391,24,23),(392,25,23),(393,26,23),(395,87,36),(394,28,23),(396,29,24),(397,30,24),(398,31,24),(399,32,24),(400,33,24),(401,34,24),(402,35,24),(403,37,25),(404,38,25),(406,41,25),(311,43,26),(409,44,26),(257,46,26),(410,50,27),(411,51,27),(413,53,27),(414,54,27),(415,55,28),(317,86,36),(418,59,28),(419,61,29),(273,63,29),(274,64,29),(420,65,29),(421,66,29),(276,67,29),(278,68,30),(422,69,30),(423,70,30),(424,71,30),(425,72,30),(281,73,30),(426,74,31),(247,75,31),(284,76,31),(427,77,31),(286,78,31),(428,79,32),(222,80,32),(223,81,32),(245,36,24),(313,45,26),(314,48,26),(259,49,26),(412,52,27),(250,39,25),(405,40,25),(407,42,25),(416,56,28),(417,57,28),(270,60,29),(272,62,29),(372,82,19),(379,83,20),(289,84,34),(466,90,33),(467,91,33),(452,93,33),(468,94,17),(469,96,18);

--
-- Table structure for table `Invoice`
--

CREATE TABLE `Invoice` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `purchasedby` int(11) NOT NULL DEFAULT '0',
  `deliverto` int(11) NOT NULL DEFAULT '0',
  `processed` int(11) NOT NULL DEFAULT '0',
  `shiptype` varchar(50) DEFAULT NULL,
  `shipcost` double(8,2) NOT NULL DEFAULT '0.00',
  `comment` blob,
  `cart_total` double(8,2) DEFAULT NULL,
  `tax` double(8,2) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=94 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Invoice`
--

INSERT INTO `Invoice` VALUES (1,'2005-12-12 12:44:37',8,8,1,'UPS',5.00,'',NULL,NULL),(2,'2005-12-14 22:48:02',9,10,1,'UPS',5.00,'Merry Christmas!\r\nLove, \r\nNaomi',NULL,NULL),(3,'2005-12-14 22:53:04',11,12,1,'UPS',5.00,'Merry Xmas!\r\nLove, Naomi',NULL,NULL),(4,'2005-12-17 13:04:26',13,13,1,'UPS',5.00,'',NULL,NULL),(6,'2006-01-16 13:55:12',15,15,1,'UPS',5.00,'',NULL,NULL),(7,'2006-01-17 09:02:31',17,17,1,'UPS',5.00,'',NULL,NULL),(8,'2006-01-22 13:45:36',18,18,1,'UPS',5.00,'',NULL,NULL),(9,'2006-01-23 13:00:57',19,19,1,'UPS',5.00,'Hi Suzanne\r\nHere is my order for the bb.treatment i asked you about a couple of days ago -due to security reasons i dont like to send my creditcard info via email. so could you send me the products i listed up in my mail, for $120.- plus delivery?\r\nTHANK YOU SO MUCH!\r\ntake care',NULL,NULL),(10,'2006-01-25 18:53:20',21,22,1,'UPS',5.00,'Merry Christmas Finally',NULL,NULL),(11,'2006-01-26 20:13:35',23,23,1,'UPS',5.00,'',NULL,NULL),(12,'2006-02-13 11:19:21',25,25,1,'UPS',5.00,'',NULL,NULL),(13,'2006-03-14 17:06:15',28,29,1,'UPS',5.00,'Just a little something to help you relax during your transistion to life in AZ!!',NULL,NULL),(14,'2006-03-14 19:39:52',30,30,1,'UPS',5.00,'',NULL,NULL),(15,'2006-05-03 08:14:46',33,33,1,'UPS',5.00,'',NULL,NULL),(16,'2006-05-05 12:27:24',34,34,1,'UPS',5.00,'',NULL,NULL),(17,'2006-05-09 11:22:39',35,36,1,'UPS',5.00,'Hapy Mothers Day Mom from Regina, Jessica and Leanne',NULL,NULL),(18,'2006-05-13 13:42:28',37,38,1,'UPS',5.00,'',NULL,NULL),(19,'2006-05-24 09:05:42',39,39,1,'UPS',5.00,'',NULL,NULL),(20,'2006-06-02 11:07:41',41,42,1,'UPS',5.00,'',NULL,NULL),(21,'2006-06-02 14:22:46',43,43,1,'UPS',5.00,'',NULL,NULL),(22,'2006-06-02 20:27:04',44,45,1,'UPS',5.00,'thanks',NULL,NULL),(23,'2006-06-03 08:23:48',46,46,1,'UPS',5.00,'',NULL,NULL),(24,'2006-06-06 11:14:34',47,48,1,'UPS',5.00,'',NULL,NULL),(25,'2006-07-02 07:35:15',49,49,1,'UPS',5.00,'',NULL,NULL),(27,'2006-08-27 10:03:17',56,57,1,'UPS',5.00,'Happy Birthday Mom!\r\nWe love you,\r\nDeb & Travis',NULL,NULL),(28,'2006-09-03 10:44:52',58,58,1,'UPS',5.00,'',NULL,NULL),(29,'2006-11-28 15:47:54',63,64,1,'UPS',5.00,'Please enclose a note saying \"Merry Christmas and Happy Birthday, Valerie.  Love, Anita and Don\"',NULL,NULL),(30,'2006-11-28 19:04:02',65,65,1,'UPS',5.00,'',NULL,NULL),(31,'2006-12-01 09:00:55',66,66,1,'UPS',5.00,'',NULL,NULL),(32,'2006-12-04 09:22:22',68,68,1,'UPS',5.00,'',NULL,NULL),(33,'2006-12-10 14:55:56',69,69,1,'UPS',5.00,'',NULL,NULL),(34,'2006-12-10 17:28:03',70,71,1,'UPS',5.00,'Love Lisa & the Holloway\'s',NULL,NULL),(35,'2007-01-27 10:31:30',73,74,1,'UPS',5.00,'Happy Birthday, Baby!!',NULL,NULL),(36,'2007-02-26 10:20:56',75,75,1,'UPS',5.00,'',NULL,NULL),(37,'2007-05-09 20:25:04',78,78,1,'UPS',9.00,'',NULL,NULL),(38,'2007-06-05 13:42:52',79,79,1,'UPS',5.00,'',NULL,NULL),(41,'2007-09-22 15:01:05',85,85,1,'UPS',5.00,'',NULL,NULL),(42,'2007-10-04 09:19:55',87,88,1,'UPS',5.00,'',NULL,NULL),(43,'2007-10-27 21:42:46',89,89,1,'UPS',5.00,'',NULL,NULL),(40,'2007-09-07 11:54:58',84,84,1,'UPS',5.00,'',NULL,NULL),(44,'2007-10-30 10:42:56',90,91,1,'UPS',5.00,'Happy Birthday, Tag! Have a good one! Love, Vanessa',NULL,NULL),(45,'2007-11-05 01:57:40',93,93,1,'UPS',5.00,'',NULL,NULL),(46,'2007-11-25 18:34:51',95,95,1,'UPS',5.00,'',NULL,NULL),(47,'2007-12-02 15:07:26',97,97,1,'UPS',7.00,'',NULL,NULL),(48,'2007-12-05 22:55:04',99,99,1,'UPS',5.00,'',NULL,NULL),(49,'2007-12-06 10:22:49',100,100,1,'UPS',5.00,'',NULL,NULL),(50,'2007-12-18 14:43:24',101,102,1,'UPS',5.00,'So you can get a quality long hair cut that accentuates your style. Merry Christmas from Mom and Laura!',NULL,NULL),(51,'2008-04-18 07:49:05',107,107,1,'UPS',5.00,'',NULL,NULL),(52,'2008-05-09 05:35:43',108,109,1,'UPS',5.00,'Happy Mother\'s Day! Sorry it is late! We love you! Love, Michi and Brian',NULL,NULL),(53,'2008-05-11 08:06:34',110,111,1,'UPS',5.00,'',NULL,NULL),(54,'2008-05-12 11:55:01',112,112,1,'UPS',5.00,'',NULL,NULL),(55,'2008-05-16 03:40:16',113,114,1,'UPS',5.00,'Happy Birthday!!!! WE LOVE YOU! Go get your hair did! Happy Birthday, Vicki!\r\nLove,\r\nMichi and Brian',NULL,NULL),(58,'2008-08-12 17:16:06',121,122,1,'UPS',5.00,'HAPPY BIRTHDAY !',240.00,0.00),(57,'2008-07-23 14:26:51',120,120,1,'UPS',5.00,'',38.00,3.08),(59,'2008-08-21 19:51:18',124,125,1,'UPS',5.00,'Happy Birthday Leslie! I love you and wish I could celebrate with you.  Have a great day! xoxo\r\nJame',50.00,0.00),(64,'2008-12-02 14:25:39',131,132,1,'UPS',5.00,'Congratulations Mrs. Stock!',100.00,0.00),(65,'2008-12-06 13:08:57',133,133,1,'UPS',5.00,'',50.00,0.00),(66,'2008-12-31 14:28:51',134,134,1,'UPS',5.00,'',31.00,2.51),(67,'2009-01-18 20:28:16',136,136,1,'UPS',5.00,'',22.50,1.82),(68,'2009-01-27 00:02:18',137,137,1,'UPS',5.00,'',26.00,2.11),(69,'2009-03-05 08:51:08',138,139,1,'UPS',5.00,'Use this for stress management! ',50.00,0.00),(70,'2009-04-29 14:47:41',140,141,1,'UPS',5.00,'Happy Mothers Day\r\nLove mari and katie',100.00,0.00),(73,'2009-05-07 08:45:54',145,146,1,'UPS',5.00,'Happy mothers day mom- from all of us! You dont need to look anymore beautfiul, but just in case you wanted to pamper yourself',125.00,0.00),(72,'2009-05-05 09:06:53',143,144,1,'UPS',5.00,'Happy Mother\'s Day to our daughter, an exemplar MOM.Love, Harvey and Dana.',240.00,0.00),(75,'2009-07-17 08:43:51',152,153,1,'UPS',5.00,'Happy Birthday, Mom!\r\nLove,\r\nJen and Danielle',75.00,0.00),(76,'2009-07-21 15:48:25',154,154,1,'UPS',5.00,'',50.00,0.00),(77,'2009-08-07 22:40:34',155,155,1,'UPS',5.00,'',45.00,3.65),(78,'2009-09-18 22:08:13',157,157,1,'UPS',5.00,'',45.00,3.65),(79,'2009-10-28 18:18:36',161,162,1,'UPS',5.00,'Happy Birthday! Love from John, Bronson and Mom',227.00,0.00),(80,'2009-12-07 20:58:08',163,163,1,'UPS',5.00,'',150.00,0.00),(81,'2009-12-18 20:42:11',164,164,1,'UPS',5.00,'',200.00,0.00),(82,'2010-04-30 14:14:47',172,173,1,'UPS',5.00,'Happy Mother\'s Day/Early Birthday!',0.00,0.00),(83,'2010-05-03 19:57:31',174,175,1,'UPS',5.00,'Happy Birthday and Happy Mother\'s Day!  We love you! Amy & Family and Libby and Family',100.00,0.00),(84,'2010-05-04 18:39:52',176,177,1,'UPS',5.00,'Happy Birthday with all my love now and forever, and then some  Love, Perry XO',250.00,0.00),(85,'2010-05-09 20:07:52',178,178,1,'UPS',5.00,'',39.00,3.16),(86,'2010-09-27 14:15:14',180,181,1,'UPS',5.00,'',200.00,0.00),(87,'2010-11-06 21:08:30',184,185,1,'UPS',5.00,'',100.00,0.00),(89,'2010-12-11 20:15:31',188,188,1,'UPS',5.00,'',200.00,0.00),(91,'2013-12-05 15:07:12',200,200,1,'UPS',5.00,'',150.00,0.00);

--
-- Table structure for table `Page`
--

CREATE TABLE `Page` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `body` blob,
  `template` int(11) NOT NULL DEFAULT '0',
  `type` int(11) NOT NULL DEFAULT '0',
  `image` varchar(255) DEFAULT NULL,
  `label` varchar(50) DEFAULT NULL,
  `featured` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `linkname` varchar(50) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Page`
--

INSERT INTO `Page` VALUES (1,'<center>\r\n<h3>Welcome to the Mane Attraction Salon<br>Online Store</h3></center>\r\n<p>\r\nOur store features quality salon products from Bumble and Bumble, and Aveda.\r\n<br><br><br><br><br>\r\n<br>\r\n<br>\r\n',3,0,'','Featured Products','','',NULL,NULL);

--
-- Table structure for table `Product`
--

CREATE TABLE `Product` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `sku` varchar(30) DEFAULT NULL,
  `short_description` blob,
  `linkname` varchar(50) DEFAULT NULL,
  `link` blob,
  `alloworder` smallint(6) DEFAULT NULL,
  `instock` smallint(6) DEFAULT NULL,
  `label1` varchar(50) DEFAULT NULL,
  `label2` varchar(50) DEFAULT NULL,
  `price` double(8,2) NOT NULL DEFAULT '0.00',
  `list1` longblob,
  `list2` longblob,
  `image` varchar(255) DEFAULT NULL,
  `prices` longblob,
  `weight` double(8,4) NOT NULL DEFAULT '0.0000',
  `display` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `long_description` blob,
  `shipcost` float(10,2) NOT NULL DEFAULT '0.00',
  `number` smallint(6) NOT NULL DEFAULT '0',
  `notax` smallint(6) DEFAULT NULL,
  `inactive` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=97 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Product`
--

INSERT INTO `Product` VALUES (1,'MINT CLARIFYING SHAMPOO','0','<p>A shampoo especially formulated to remove product, medication or mineral buildup.  This shampoo gives shine and body to dull lifeless hair. (8 oz)</p>',NULL,NULL,1,1,'','',9.00,'','','mintclarifyingshampoo.jpg','',0.0000,1,1,'<p>A shampoo especially formulated to remove product, medication or mineral buildup.  This shampoo gives shine and body to dull lifeless hair.</p>\r\n<p><u><b>Benefits</b></u></p>\r\n<ul>\r\n<li>Removes buildup and coatings from hair products and minerals that can weigh hair down.</li>\r\n<li>Gives hair more body and manageability.</li>  \r\n<li>Leaves the hair shiny, healthy and clean.</li>   \r\n<li>Invigorates and stimulated the scalp</li>\r\n<li>Smells fresh and minty.</li>\r\n</ul>\r\n<p><u><b>Usage</b></u></p>\r\n<p>Initially, every day for one week, then weekly or as needed.<br>\r\nApply on the roots and work out thru to the ends.</p>\r\n\r\n ',0.00,1,NULL,NULL),(2,'BALANCED SHAMPOO','0','<p>A shampoo for normal healthy, hair.  It does not contain waxes or plastics that can build up and weigh hair down.</p>',NULL,NULL,1,1,'Size','',4.00,'2 oz, 8 oz, 16 oz, 32 oz','','balancedshampoo.jpg','4.00, 9.00, 14.00, 23.00',0.1875,1,1,'<p>A shampoo for normal healthy, hair.  It does not contain waxes or plastics that can build up and weigh hair down.</p>\r\n<p><u><b>Benefits</b></u></p>\r\n<ul>\r\n<li>Will not coat or build up on your hair like many other shampoos.</li> \r\n<li>PH balanced.</li>\r\n<li>Will leave hair clean and manageable.</li>\r\n<li>Shampoo is concentrated and lathers well.</li> \r\n<li>Gives hair moisture for the dry Arizona climate.</li>\r\n</ul>\r\n<p><u><b>Usage</b></u></p>\r\n<p>Daily or as needed.<br>\r\nApply on the roots and work out thru to the ends.</p>\r\n\r\n',0.00,2,NULL,NULL),(3,'MOISTURIZING SHAMPOO','0','<p>Contains essential fatty acids, which dry hair needs, and additional conditioners for your hair.  This shampoo is perfect for dry, damaged, colored or permed hair.</p>',NULL,NULL,1,1,'Size','',4.00,'2 oz, 8 oz, 16 oz, 32 oz','','moisturizingshampoo.jpg','4.00, 9.00, 14.00, 23.00',0.1875,1,1,'<p>Contains essential fatty acids, which dry hair needs, and additional conditioners for your hair.  This shampoo is perfect for dry, damaged, colored or permed hair.</p>\r\n<p><u><b>Benefits</b></u></p>\r\n<ul>\r\n<li>Shampoo is color fast. It will keep color from fading.</li>\r\n<li>Will not coat or build up on your hair like many other shampoos.</li>\r\n<li>Good for dry, flaky scalp.</li>\r\n<li>Shampoo is concentrated and lathers well.</li>\r\n<li>Helps keep naturally curly or permed hair from frizzing.</li>\r\n<li>Will minimize split ends.</li>\r\n</ul>\r\n<p><u><b>Usage</b></u></p>\r\n<p>Daily or as needed.<br>\r\nApply on the roots and work out thru to the ends.</p>\r\n',0.00,3,NULL,NULL),(4,'VOLUMIZING SHAMPOO','0','<p>A purifying shampoo synergizes with vitamins and protein for volume.  Our exclusive Volu-PlexTM, with its mix of natural botanicals, works to extract excess oils and sebum build-up that can clog the hair follicles and cause excessive hair loss.  Vitamins A and E soothe and condition the hair, while Panthenol (pro-vitamin B5 ) penetrates the hair shaft to increase hair diameter.</p>',NULL,NULL,1,1,'Size','',9.00,'8 oz, 16 oz','','volumizingshampoo.jpg','9.00, 14.00',0.5000,1,1,'<p>A purifying shampoo synergizes with vitamins and protein for volume.  Our exclusive Volu-PlexTM, with its mix of natural botanicals, works to extract excess oils and sebum build-up that can clog the hair follicles and cause excessive hair loss.  Vitamins A and E soothe and condition the hair, while Panthenol (pro-vitamin B5 ) penetrates the hair shaft to increase hair diameter.</p>\r\n<p><u><b>Benefits</b></u></p>\r\n<ul>\r\n<li>Gives hair more body.</li>\r\n<li>Will make hair thicker.</li>\r\n<li>Safe for permed and color treated hair.</li>  \r\n<li>Will not build-up over extended use.</li> \r\n<li>Shampoo is concentrated and lathers well.</li>\r\n</ul>\r\n<p><b><u>Usage</u></b></p>\r\n<p>Daily or as needed.<br>\r\nApply on the roots and work out thru to the ends.</p>\r\n',0.00,4,NULL,NULL),(5,'SKY VIOLET COLOR ENHANCING SHAMPOO','0','<p>A moisturizing shampoo that will brighten blonde tones.  Will also enhance natural gray color. (8 oz)</p>',NULL,NULL,1,1,'','',14.00,'','','skyvioletcolorshampoo.jpg','',0.6875,1,1,'<p>A moisturizing shampoo that will brighten blonde tones.  Will also enhance natural gray color. (8 oz)</p>\r\n<p><b><u>Benefits</u></b></p>\r\n<ul>\r\n<li>Tones down brassiness.</li>\r\n<li>Brightens blondes.</li>\r\n<li>Rids gray hair of any yellow cast.</li>\r\n</ul>\r\n<p><b><u>Usage</u></b></p>\r\n<p>Use as a second shampoo after using <i>Moisturizing Shampoo</i>.<br>\r\nWeekly or as needed.<br>\r\nWorks best when finished with <i>Transparent Sealer</i>.</p>\r\n',0.00,5,NULL,NULL),(6,'CUSTOM BLENDED COLOR ENHANCING SHAMPOO','0','<p>A moisturizing shampoo that can be used on natural or artificially colored hair.  Custom blended by your stylist this shampoo gently refreshes your color. (8 oz)</p>',NULL,NULL,1,1,'','',14.00,'','','','',0.6875,1,1,'<p>A moisturizing shampoo that can be used on natural or artificially colored hair.  Custom blended by your stylist this shampoo gently refreshes your color. (8 oz)</p>\r\n<p><b><u>Benefits</u></b></p>\r\n<ul>\r\n<li>Richens hair color.</li>\r\n<li>Unique customized color for you.</li>\r\n<li>Adds vibrancy and shine to your hair color.</li>\r\n</ul>\r\n<p><b><u>Usage</u></b></p>\r\n<p>Use as a second shampoo after <i>Moisturizing Shampoo</i>.<br>\r\nWeekly or as needed.<br>\r\nWorks best when finished with <i>Transparent Sealer</i>.</p>\r\n',0.00,6,NULL,NULL),(7,'EINSTEIN SHAMPOO','0','<p>The smarter choice for your dog!  Using human grade ingredients this unique three in one technology has shampoo to cleanse, conditioner to moisturize and a finishing rinse to seal. (8 oz)</p>',NULL,NULL,1,1,'','',15.00,'','','einsteins_shampoo.jpg','',1.1875,1,1,'<p>The smarter choice for your dog!  Using human grade ingredients this unique three in one technology has shampoo to cleanse, conditioner to moisturize and a finishing rinse to seal. (8 oz)</p>\r\n<p><b><u>Benefits</u></b></p>\r\n<ul>\r\n<li>Three in one technology</li>\r\n<li>Finishing rinse seals fur and repels dirt.</li>\r\n<li>Leaves fur silky and shiny</li>\r\n<li>Moisturizer softens and conditions coat.</li>\r\n<li>Shampoo gently cleanses.</li>\r\n<li>A portion of every bottle goes to save animals from the euthanasia list.\r\n</li>\r\n</ul>\r\n<p><b><u>Usage</u></b></p>\r\n<p>Weekly or as needed.<br>\r\nApply on your buddy and finish with a yummy treat.</p>\r\n',0.00,7,NULL,NULL),(8,'PROTEIN REMOISTURIZER','0','<p>Contains hydrolyzed keratin protein to penetrate hair, smoothing hair from the inside out.  Enriched with nutritive vitamin A, D and E plus moisturizers.</p>',NULL,NULL,1,1,'Size','',5.00,'2 oz, 8 oz, 16 oz, 32 oz','','proteinremoisturizer.jpg','5.00, 11.00, 16.00, 25.00',0.1875,1,1,'<p>Contains hydrolyzed keratin protein to penetrate hair, smoothing hair from the inside out.  Enriched with nutritive vitamin A, D and E plus moisturizers.</p>\r\n<p><b><u>Benefits</u></b></p>\r\n<ul>\r\n<li>Lightweight conditioner rinses out clean.</li> \r\n<li>Will not build up or weigh hair down.</li>\r\n<li>Will keep hair color more vibrant and rich.</li>\r\n<li>Improves body and pliability.</li>  \r\n<li>Reduces static and frizz.</li> \r\n<li>Keeps curl stronger and bouncy.</li>\r\n<li>Keeps naturally curly or permed hair from frizzing.</li>\r\n</ul>\r\n<p><b><u>Usage</u></b></p>\r\n<p>After every shampoo.<br>\r\nApply on the ends and work throughout your hair.</p>\r\n',0.00,8,NULL,NULL),(9,'TRIPLE PROTEIN CONDITIONER','0','<p>Deep conditions dry, damaged and chemically treated hair.  Structuring proteins of differing molecular weights penetrates deep within the hair shafts producing benefits that no singular protein can. Rice protein with a low molecular weight penetrates the hair shaft to rebuild and strengthen damaged hair. Corn Protein with a mid-range molecular weight adds body, volume and manageability. Whole Wheat Protein with a high molecular weight adds shine and luster to dull hair.   Holds water in the hair shaft at increased levels. Enriched with 19 amino acids and 14 vitamins essential to hair nutrition.</p>  ',NULL,NULL,1,1,'Size','',19.00,'8 oz','','tripleproteindeepconditioner.jpg','19.00',0.3750,1,1,'<p>Deep conditions dry, damaged and chemically treated hair.  Structuring proteins of differing molecular weights penetrates deep within the hair shafts producing benefits that no singular protein can. Rice protein with a low molecular weight penetrates the hair shaft to rebuild and strengthen damaged hair. Corn Protein with a mid-range molecular weight adds body, volume and manageability. Whole Wheat Protein with a high molecular weight adds shine and luster to dull hair.   Holds water in the hair shaft at increased levels. Enriched with 19 amino acids and 14 vitamins essential to hair nutrition.</p>\r\n<p><b><u>Benefits</u></b></p>\r\n<ul>\r\n<li>Increases hair’s flexibility and elasticity.</li>\r\n<li>Moisturizes dry and brittle hair.</li>\r\n<li>Botanical extracts energize and revitalize depleted, stressed hair.</li> \r\n<li>Reduces static and frizz.</li> \r\n<li>Produces exceptional manageability and a healthy luster.</li> \r\n<li>Contains broad-spectrum sunscreen protection.</li>\r\n</ul>\r\n<p><b><u>Usage</u></b></p>\r\n<p>Weekly or as needed.<br>\r\nFor extremely damaged hair can be used daily prior to <i>Protein Remoisturizer</i>.</p>\r\n\r\n  ',0.00,9,NULL,NULL),(10,'MINT RESCUE HAIR AND SCALP TREATMENT','0','<p>A dual action treatment for hair and scalp.  Contains natural peppermint oil to gently exfoliate and refresh the scalp. A combination of proteins and humectants penetrate the hair shaft, restoring moisture.  Vitamins A, D, and E supply essential nutrients.  Especially effective on thinning hair, dry or damaged hair. (4 oz)</p>',NULL,NULL,1,1,'','',11.00,'','','mintrescue.jpg','',0.3750,1,1,'<p>A dual action treatment for hair and scalp.  Contains natural peppermint oil to gently exfoliate and refresh the scalp. A combination of proteins and humectants penetrate the hair shaft, restoring moisture.  Vitamins A, D, and E supply essential nutrients.  Especially effective on thinning hair, dry or damaged hair. (4 oz)</p>\r\n<p><b><u>Benefits</u></b></p>\r\n<ul>\r\n<li>Leaves hair manageable.</li>\r\n<li>Gives hair great shine and gloss.</li>\r\n<li>Helps prevent split ends.</li>\r\n<li.Rebalances hair and scalps pH.</li>\r\n<li>Refreshes and stimulates the scalp.</li>\r\n</ul>\r\n<p><b><u>Usage</u></b></p>\r\n<p>Weekly or as needed.<br>\r\nApply on the scalp and work throughout your hair.<br>\r\nFor dry flaky scalp apply at the scalp and massage in.<br>\r\nLeave for 5 minutes and rinse.</p>\r\n\r\n',0.00,10,NULL,NULL),(11,'KORTAPLEXX','0','<p>A lightweight protein conditioner.  Active botanicals leave hair healthy and shiny.  Seals the cuticle layer and helps repair split ends.  Contains U.V. protectants. (8 oz)</p>',NULL,NULL,1,1,'','',10.00,'','','kortaplexx.jpg','',0.6875,1,1,'<p>A lightweight protein conditioner.  Active botanicals leave hair healthy and shiny.  Seals the cuticle layer and helps repair split ends.  Contains U.V. protectants. (8 oz)</p>\r\n<p><b><u>Benefits</u></b></p>\r\n<ul>\r\n<li>Great for detangling hair.</li>\r\n<li>Gives hair shine and gloss.</li>\r\n<li>Minimizes color fading due to sun exposure.</li>\r\n<li>Lightweight so it will not weigh hair down.</li>\r\n<li>Protects hair from thermal styling.</li>\r\n</ul>\r\n<p><b><u>Usage</b></u></p>\r\n<p>Spray throughout hair.<br>\r\nComb out hair using a large tooth comb.</p>\r\n\r\n',0.00,11,NULL,NULL),(12,'TRANSPARENT SEALER','0','<p>A lightweight cuticle conditioner.  Contains nutritional botanicals.  Cationic bonding technology allows the conditioner to smooth even the roughest hair (8 oz)</p>',NULL,NULL,1,1,'','',11.00,'','','transparentsealer.jpg','',0.6875,1,1,'<p>A lightweight cuticle conditioner.  Contains nutritional botanicals.  Cationic bonding technology allows the conditioner to smooth even the roughest hair (8 oz)</p>\r\n<p><b><u>Benefits</u></b></p>\r\n<ul>\r\n<li>Seals the cuticle layer of the hair.</li>\r\n<li>Seals in moisture.</li>\r\n<li>Seals in color.</li>\r\n<li>Helps to maintain colors richness and depth.</li>\r\n<li>Gives hair great shine.</li>\r\n<li>Protects the hair.</li>\r\n</ul>\r\n<p><b><u>Usage</u></b></p>\r\n<p>Use after <i>Protein Remoisturizer</i> to seal in moisture.<br>\r\nUse after <i>Color Enhancing Shampoo</i> to seal in color.<br>\r\nApply on the ends and work throughout your hair.</p>\r\n\r\n',0.00,12,NULL,NULL),(13,'VOLUMIZING MIST','0','<p>A lightweight leave-in spray that gives fine, thin and thinning hair volume. Volumizing Mist thickens with amplifiers of panthothenic acid that turn up the volume when used with a blow dryer.  Botanical extracts contained in the Volu-PlexTM purify hair while building body.  Vitamins A and E nourish and soothe the hair as they condition. Formulated with Panthenol (pro-vitamin B5 ) and whole wheat proteins to increase hair’s diameter and provide gloss. Safe for permed and color treated hair.</p>',NULL,NULL,0,1,'Size','',13.00,'4 oz, 16 oz','','volumizingmist.jpg','13.00, 30.00',0.6875,1,1,'<p>A lightweight leave-in spray that gives fine, thin and thinning hair volume. Volumizing Mist thickens with amplifiers of panthothenic acid that turn up the volume when used with a blow dryer.  Botanical extracts contained in the Volu-PlexTM purify hair while building body.  Vitamins A and E nourish and soothe the hair as they condition. Formulated with Panthenol (pro-vitamin B5 ) and whole wheat proteins to increase hair’s diameter and provide gloss. Safe for permed and color treated hair.</p>\r\n<p><b><u>Benefits</u></b></p>\r\n<ul>\r\n<li>Gives hair volume and fullness.</li>\r\n<li>Lightweight, will not weigh hair down.</li>\r\n<li>Prevents ‘fly away’ hair.</li>\r\n<li>Hair will be shinier and more manageable with every use.</li>\r\n<li>Will not weigh hair down or build up over time.</li>\r\n</ul>\r\n<p><b><u>Usage</u></b></p>\r\n<p>Spray liberally at roots and blow dry.</p>	\r\n',0.00,13,NULL,NULL),(14,'BIOGEL MOUSSE','0','<p>A uniquely different, alcohol-free, non-aerosol styling tool, designed to give you the control of a gel in a conditioning mousse. Super enriched with natural botanical extracts of Awapuhi, Aloe Vera, Kiwi, Mango and Passion fruit for never before achieved volume, body and natural shine.  Whole Wheat Protein and Panthenol fortify hair to prevent breakage and dryness. (7 oz)</p>',NULL,NULL,1,1,'','',15.00,'','','biogel.jpg','',0.6250,1,1,'<p>A uniquely different, alcohol-free, non-aerosol styling tool, designed to give you the control of a gel in a conditioning mousse. Super enriched with natural botanical extracts of Awapuhi, Aloe Vera, Kiwi, Mango and Passion fruit for never before achieved volume, body and natural shine.  Whole Wheat Protein and Panthenol fortify hair to prevent breakage and dryness. (7 oz)</p>\r\n<p><b><u>Benefits</u></b></p>\r\n<ul>\r\n<li>Gives hair maximum volume and control.</li>\r\n<li>Conditions as it volumizes.</li>\r\n<li>Gives hair a softer texture.</li>\r\n</ul>\r\n<p><b><u>Usage</u></b></p>\r\n<p>Dispense into palms and emulsify.<br>\r\nApply at roots and work out to the ends.<br>\r\nApply more at the roots for maximum volume.</p>\r\n\r\n',0.00,14,NULL,NULL),(15,'HERBAL MOUSSE','0','<p>This maximum hold conditioning mousse is rich in Panthenol (pro-vitamin B5). An additional blend of herbal extracts including Aloe and Chamomile condition the hair while the mousse provides exceptional hold and volume.  For use on either wet or dry hair, this product is an exceptional tool for getting the right look. (6 oz)</p>',NULL,NULL,1,1,'','',10.00,'','','herbalmousse.jpg','',0.5000,1,1,'<p>This maximum hold conditioning mousse is rich in Panthenol (pro-vitamin B5). An additional blend of herbal extracts including Aloe and Chamomile condition the hair while the mousse provides exceptional hold and volume.  For use on either wet or dry hair, this product is an exceptional tool for getting the right look. (6 oz)</p>\r\n<p><b><u>Benefits</u></b></p>\r\n<ul>\r\n<li>Conditions as it volumizes.</li>\r\n<li>Gives hair a softer texture.</li>\r\n<li>Gives great hold and fullness.</li>\r\n</ul>\r\n<p><b><u>Usage</u></b></p>\r\n<p>Dispense into palms and emulsify.<br>\r\nApply at roots and work out to the ends.</p>\r\n\r\n',0.00,15,NULL,NULL),(16,'GEL','0','<p>Our classic styling gel.  Gives exceptional volume and hold.  Can be used wet and dry to sculpt and spike hair. (2 oz)</p>',NULL,NULL,1,1,'Size','',4.00,'2 oz, 8 oz, 16 oz','','gel.jpg','4.00, 9.00, 14.00',0.1875,1,1,'<p>Our classic styling gel.  Gives exceptional volume and hold.  Can be used wet and dry to sculpt and spike hair. (2 oz)</p>\r\n<p><b><u>Benefits</u></b></p>\r\n<ul>\r\n<li>Contains no alcohol.</li>  \r\n<li>Does not coat or build up.</li>  \r\n<li>Contains no oils.</li>    \r\n<li>Good for sculpted wet looks.</li>\r\n<li>Non flaky formulation.</li>\r\n</ul>\r\n<p><b><u>Usage</u></b></p>\r\n<p>For wet looks apply to damp hair, comb into style and allow to dry naturally.<br>\r\nFor volume apply at roots and style as desired.</p>\r\n\r\n',0.00,16,NULL,NULL),(17,'SLEEK','0','<p>A silicone based straightening balm. This non-chemical straightener transforms curl and frizz into shiny, sleek hair.  Protects your hair as it smoothes and controls. (4 oz)</p>',NULL,NULL,1,1,'','',15.00,'','','sleek.jpg','',0.3750,1,1,'<p>A silicone based straightening balm. This non-chemical straightener transforms curl and frizz into shiny, sleek hair.  Protects your hair as it smoothes and controls. (4 oz)</p>\r\n<p><b><u>Benefits</u></b></p>\r\n<ul>\r\n<li>Makes it easier to straighten and smooth curly hair.</li> \r\n<li>Reduces frizziness.</li>\r\n<li>Gives hair shine.</li>\r\n<li>Protects hair as you blow dry.</li>\r\n</ul>\r\n<p><u><b>Usage</b></u></p>\r\n<p>Apply a generous amount evenly from roots to ends and blow dry.</p>\r\n',0.00,17,NULL,NULL),(18,'ORGANIC BIO EXTENDER','0','<p>An organic styling cream that gives curly or straight hair body while creating texture and definition.  Ingredients include Panthenol and Hydrolyzed Rice Protein to strengthen and thicken hair.  Also has botanical extracts of Burdock, Ivy and Fenugreek. (4 oz)</p>',NULL,NULL,1,1,'','',19.00,'','','organicbioextender.jpg','',0.3125,1,1,'<p>An organic styling cream that gives curly or straight hair body while creating texture and definition.  Ingredients include Panthenol and Hydrolyzed Rice Protein to strengthen and thicken hair.  Also has botanical extracts of Burdock, Ivy and Fenugreek. (4 oz)</p>\r\n<p><b><u>Benefits</u></b></p>\r\n<ul>\r\n<li>Gives hair volume and fullness.</li>\r\n<li>Lightweight cream gives body and texture.</li>\r\n<li>Strengthens and thickens hair.</li> \r\n<li>Certified organic ingredients.</li>\r\n</ul>\r\n<p><u><b>Usage</b></u></p>\r\n<p>Dispense into palms and emulsify.<br>\r\nApply at roots and work out to the ends.</p>\r\n\r\n',0.00,18,NULL,NULL),(19,'FUSION','0','<p>A botanically rich leave in conditioner.  This fusion of silicones and botanicals reduces frizz and texturizes curls. (6 oz)</p>',NULL,NULL,1,1,'','',14.00,'','','fusion.jpg','',0.5625,1,1,'<p>A botanically rich leave in conditioner.  This fusion of silicones and botanicals reduces frizz and texturizes curls. (6 oz)</p>\r\n<p><b><u>Benefits</u></b></p>\r\n<ul>\r\n<li>Conditions as it styles.</li>\r\n<li>Reduces frizz on curly hair.</li>\r\n<li>Defines your curls.</li>\r\n<li>Protects hair from the heat of thermal styling.</li>\r\n<li>Leaves curly hair shiny and manageable.</li>\r\n</ul>\r\n<p><b><u>Usage</b></u></p>\r\n<p>Apply generously from ends to roots.</p>\r\n\r\n',0.00,19,NULL,NULL),(20,'SPRAY SHINE','0','<p>A spray on silicone based cuticle sealant that adds incredible shine and gloss. (4 oz)</p>',NULL,NULL,1,1,'','',12.00,'','','sprayshine.jpg','',0.3125,1,1,'<p>A spray on silicone based cuticle sealant that adds incredible shine and gloss. (4 oz)</p>\r\n<p><b><u>Benefits</u></b></p>\r\n<ul>\r\n<li>Convenient pump spray bottle.</li>  \r\n<li>Gives hair incredible shine.</li>\r\n<li>Protects hair from the heat of thermal styling.</li>\r\n<li>Minimizes color fading.</li>\r\n</ul>\r\n<p><b><u>Usage</u></b></p>\r\n<p>Lightly spray ends and blow dry.</p>\r\n',0.00,20,NULL,NULL),(21,'ORGANIC SILK THERAPY','0','<p>A truly amazing multi purposed serum.  Using silk lipids and silicone technology hair will shine and skin will glow.  Transforms hair giving it renewed vitality and manageability without weighing it down.</p>',NULL,NULL,1,1,'Size','',16.00,'2 oz, 8 oz','','organicsilktherapy.jpg','15.00, 30.00',0.1875,1,1,'<p>A truly amazing multi purposed serum.  Using silk lipids and silicone technology hair will shine and skin will glow.  Transforms hair giving it renewed vitality and manageability without weighing it down.</p>\r\n<p><b><u>Benefits</u></b></p>\r\n<ul>\r\n<li>Leaves hair shiny and manageable.</li>\r\n<li>Removes frizziness from the hair.</li>  \r\n<li>Conditions as you style your hair.</li> \r\n<li>Protects hair from the heat of thermal styling.</li>\r\n<li>Gives the hair texture and separation when used as a finishing product.</li> \r\n<li>Defines the curl when applied and diffused or dried naturally.</li>\r\n<li>Can be used on skin to moisturize.</li>\r\n</ul>\r\n<p><b><u>Usage</u></b></p>\r\n<p>Apply a small amount in palms.<br>\r\nEmulsify and apply to ends with fingertips.</p>\r\n\r\n',0.00,21,NULL,NULL),(22,'Power Spray','0','<p>A flexible hold aerosol hair spray that leaves hair touchable.  Botanical based spray gives a soft hold and allows hair to move freely. (10 oz)</p>',NULL,NULL,1,1,'','',13.00,'','','powerspray.jpg','',0.8125,1,1,'<p>A flexible hold aerosol hair spray that leaves hair touchable.  Botanical based spray gives a soft hold and allows hair to move freely. (10 oz)</p>\r\n<p><b><u>Benefits</u></b></p>\r\n<ul>\r\n<li>Holds hair in place yet hair still moves.</li>\r\n<li>Gives hair volume and control.</li>\r\n<li>Contains conditioning botanical extracts.</li>\r\n<li>Does not feel sticky.</li>\r\n<li>Quick drying.</li>\r\n</ul>\r\n<p><b><u>Usage</u></b></p>\r\n<p>For a soft hold, spray lightly at roots.<br>\r\nFor a stronger hold, spray throughout from roots to ends.</p>\r\n  \r\n',0.00,22,NULL,NULL),(23,'Quick Fix Hair Spray','0','<p>A medium hold non-aerosol hairspray.                           \r\n\r\n<hr width=300 color=\"white\">',NULL,NULL,1,1,'Size','',4.00,'2 oz, 8 oz, 32 oz','','quickfix.jpg','4.00, 10.00, 24.00',0.1875,1,1,'<p>A medium hold non-aerosol hairspray.</p>\r\n<p><b><u>Benefits</u></b></p>\r\n<ul>\r\n<li>100% water soluble.</li>\r\n<li>Will not coat hair.</li>  \r\n<li>Good for all types of hair.</li>  \r\n<li>Slower drying.  Allows you to work with hair, styling it while you spray it on.</li>\r\n</ul>\r\n<p><b><u>Usage</u></b></p>\r\n<p>For hold, spray lightly at roots.<br> \r\nTo style and mold, spray lightly and shape hair as it dries.</p>\r\n\r\n',0.00,23,NULL,NULL),(24,'Molding Mud','0','<p>A unique styling paste for scrunching, texturizing and sculpting. (4 oz)</p>',NULL,NULL,1,1,'','',15.00,'','','mouldingmud.jpg','',0.3750,1,1,'<p>A unique styling paste for scrunching, texturizing and sculpting. (4 oz)</p>\r\n<p><b><u>Benefits</u></b></p>\r\n<ul>\r\n<li>Shampoos out easily.</li>\r\n<li>Can be used wet or dry.</li>  \r\n<li>Gives definition, shape and texture.</li> \r\n<li>Contains sunscreen.</li>\r\n</ul>\r\n<p><b><u>Usage</u></b></p>\r\n<p>Take a small amount and emulsify.<br>\r\nApply at roots and work out to the ends.<br>\r\nApply an additional amount to texturize ends.</p>\r\n\r\n',0.00,24,NULL,NULL),(25,'FOAMATION','0','<p>This unique styling and finishing product begins as a liquid and transforms into a soft styling mousse with the benefits of pomade.  It breaks down the hard edges of a style so you can mold or texturize the hair. (3.75 oz)</p>',NULL,NULL,1,1,'','',13.00,'','','foamation.jpg','',0.6250,1,1,'<p>This unique styling and finishing product begins as a liquid and transforms into a soft styling mousse with the benefits of pomade.  It breaks down the hard edges of a style so you can mold or texturize the hair. (3.75 oz)</p>\r\n<p><b><u>Benefits</u></b></p>\r\n<ul>\r\n<li>Leaves the hair soft and pliable with a brilliant shine.</li>\r\n<li>Two products in one.</li>\r\n<li>Great for molding and texturizing hair.</li>\r\n</ul>\r\n<p><b><u>Usage</u></b></p>\r\n<p>Shake bottle well.<br>	\r\nDispense into palms and emulsify.<br>\r\nApply at roots and work out to the ends.</p>\r\n\r\n',0.00,25,NULL,NULL),(26,'TAFFY','0','<p>This dry pomade gives incredible texture and volume.  Perfect for finer textured hair.  Adds separation and pieceiness. (1.25 oz)</p>',NULL,NULL,1,1,'','',15.00,'','','taffy.jpg','',0.1875,1,1,'<p>This dry pomade gives incredible texture and volume.  Perfect for finer textured hair.  Adds separation and pieceiness. (1.25 oz)</p>\r\n<p><u><b>Benefits</b></u></p>\r\n<ul>\r\n<li>Texturizes and defines shapes.</li>\r\n<li>Non-oily</li>\r\n<li>Dry pomade.</li>\r\n<li>Will not weigh down hair</li>\r\n</ul>\r\n<p><b><u>Usage</u></b></p>\r\n<p>Take a small amount and emulsify in palms.<br>\r\nApply from roots to ends for lift.<br>\r\nApply an additional amount to texturize ends.</p>\r\n\r\n',0.00,26,NULL,NULL),(87,'Multivitamin Hand and Nail Treatment','0','An intense, non-greasy treatment to protect and repair chapped hands while strengthening the nails against splitting and peeling. Provitamin B5 and soothing Algae Extract combine with pure Sweet Almond Oil to help heal dry, rough hands and provide an invisible barrier against environmental damage from weather and sunlight.',NULL,NULL,1,1,'Size','',0.00,'2.5 oz','','multivitaminhand.gif','21.00',0.0000,1,1,'An intense, non-greasy treatment to protect and repair chapped hands while strengthening the nails against splitting and peeling. Provitamin B5 and soothing Algae Extract combine with pure Sweet Almond Oil to help heal dry, rough hands and provide an invisible barrier against environmental damage from weather and sunlight. Licorice Extract and Vitamin C help reduce the appearance of hyperpigmentation (\"age spots\"), while SPF15 sunscreens, including Avobenzone, shield the skin from damaging ultraviolet radiation. Antioxidant extracts of Ginkgo Biloba and Grape Seed plus Vitamin E neutralize free radical activity, guarding against further damage. Fragrance free.',0.00,87,NULL,NULL),(28,'ORGANIC SCULPTING PASTE','0','<p>A matte paste that gives hair amazing separation and control. (2.5 oz)</p>',NULL,NULL,1,1,'','',15.00,'','','organicsculptingpaste.jpg','',0.2500,1,1,'<p>A matte paste that gives hair amazing separation and control. (2.5 oz)</p>\r\n<p><b><u>Benefits</u></b></p>\r\n<ul>\r\n<li>Gives hair spiky, piecey texture</li>\r\n<li>Leaves hair pliable</li>\r\n<li>Hair can be re-molded and re-shaped</li>\r\n<li>Certified organic ingredients</li>\r\n</ul>\r\n<p><b><u>Usage</u></b></p>\r\n<p>Take a small amount and emulsify in palms.<br>\r\nApply from roots to ends for lift.<br>\r\nApply an additional amount to texturize ends.</p>\r\n',0.00,28,NULL,NULL),(29,'ANTI BAC SKIN WASH','0','A naturally foaming, antibacterial face wash designed to deep cleanse the skin of excess oil and impurities without harsh, drying effects.',NULL,NULL,1,1,'size','',0.00,'8 oz, 16 oz','','antibacskinwash.gif','27.50, 41.50',1.0000,1,1,'A naturally foaming, antibacterial face wash designed to deep cleanse the skin of excess oil and impurities without harsh, drying effects. Triclosan helps inhibit bacteria on the skin\'s surface as Salicylic Acid dissolves dead skin debris making it ideal for blemish-prone skin. Contains exclusive <em>Skin Response Complex</em> of Balm Mint, Coneflower and Camphor to soothe and purify the skin. Fragrance free.',0.00,29,NULL,NULL),(30,'DERMAL CLAY CLEANSER','0','A skin-perfecting formula that provides deep cleansing to oily congested skin.',NULL,NULL,1,1,'Size','',0.00,'8 oz, 16 oz','','dermalclaycleanser.gif','27.50, 41.50',1.0000,1,1,'A skin-perfecting formula that provides deep cleansing to oily congested skin. Water-soluble Kaolin and Green clays combine with purifying extracts of Sambucus, Ivy and Lemon to remove excess oils and refine the skin\'s texture. Calming Cucumber and healing Sage soothe irritation, while refreshing Menthol revitalizes even the most tired skin. Fragrance free.',0.00,30,NULL,NULL),(31,'SPECIAL CLEANSING GEL','0','A soap-free, foaming gel designed to thoroughly remove impurities without disturbing the skin\'s natural moisture balance.',NULL,NULL,1,1,'Size','',0.00,'8 oz, 16 oz','','specialcleansinggel.gif','27.50, 41.50',1.0000,1,1,'A soap-free, foaming gel designed to thoroughly remove impurities without disturbing the skin\'s natural moisture balance. Calming Balm Mint and Lavender extracts soothe the skin, while natural Quillaja Saponaria gently foams away toxins and deep-cleanses debris. Fragrance free.',0.00,31,NULL,NULL),(32,'ESSENTIAL CLEANSING SOLUTION','0','A milky cleanser for drier skin conditions to gently lift impurities and remove make-up.',NULL,NULL,1,1,'Size','',0.00,'8 oz, 16 oz','','essentialcleasingsolution.gif','27.50, 41.50',1.0000,1,1,'A milky cleanser for drier skin conditions to gently lift impurities and remove make-up. Water-soluble, this soothing emulsion rinses off easily, leaving the skin refreshingly clean, soft and supple. Fragrance free.',0.00,32,NULL,NULL),(33,'ULTRA CALMING CLEANSER','0','An extremely gentle cleansing gel-cream that combats environmental assault with Dermalogica\'s exclusive Anti-Ozonate Complex.',NULL,NULL,1,1,'Size','',0.00,'8 oz, 16 oz','','ultracalmingcleanser.gif','27.50, 41.50',1.0000,1,1,'An extremely gentle cleansing gel-cream that combats environmental assault with Dermalogica\'s exclusive Anti-Ozonate Complex. Protects and soothes skin sensitized by pollution, temperature extremes, irritating cosmetic products, harsh detergents, chemical exposure, stress, poor diet or hormonal factors. Also contains Lavender, Echinacea and Raspberry extracts for their anti-inflammatory, calming and healing properties. This cleanser is effective enough to remove eye make-up, and can be either rinsed off or gently removed with cotton. Leaves no irritating residue and is formulated for even the most hypersensitive skin that cannot tolerate water. Fragrance free.',0.00,33,NULL,NULL),(34,'THE BAR','0','This is not a soap - it\'s the performance of a Dermalogica cleanser, in a convenient bar form.',NULL,NULL,1,1,'Size','',0.00,'5 oz','','thebar.gif','17.50',0.3750,1,1,'This is not a soap - it\'s the performance of a Dermalogica cleanser, in a convenient bar form. Soap-free, non-animal-derived agents gently remove excess oils and debris without stripping the skin\'s natural moisture barrier. Specially formulated with Tea Tree and Lavender in an acid-balanced base to help avoid contamination. Anti-inflammatory Colloidal Oatmeal, Licorice Extract and Allantoin, plus Vitamins A, C and E, calm, soothe and condition. Fragrance free.',0.00,34,NULL,NULL),(35,'FACE BRUSH','0','Supercharge your Dermalogica cleanser with this ultra-soft brush.',NULL,NULL,1,1,'','',13.00,'','','facebrush.gif','',0.1875,1,1,'Supercharge your Dermalogica cleanser with this ultra-soft brush. Durable, hygienic nylon bristles gently loosen dead skin cells and debris for professional cleansing results. It\'s an ingrown-hair-preventing must for men!',0.00,35,NULL,NULL),(36,'SPONGE CLOTH','0','This revolutionary cloth is gentle enough for even the most sensitized skin.',NULL,NULL,1,1,'','',12.00,'','','spongecloth.gif','',0.0830,1,1,'This revolutionary cloth is gentle enough for even the most sensitized skin.  Use with your favorite Dermalogica cleanser to remove make-up and impurities without irritation.',0.00,36,NULL,NULL),(37,'MULTI ACTIVE TONER','0','Spritz on critical hydration with this refreshing blend of skin-repairing Aloe, moisture-binding humectants plus soothing Lavender, Balm Mint and Arnica.',NULL,NULL,1,1,'Size','',0.00,'8 oz','','multiactivetoner.gif','26.00',0.1875,1,1,'Spritz on critical hydration with this refreshing blend of skin-repairing Aloe, moisture-binding humectants plus soothing Lavender, Balm Mint and Arnica. Use it after cleansing and throughout the day.  Fragrance free.',0.00,37,NULL,NULL),(38,'SOOTHING PROTECTION SPRAY','0','An ultra-calming spray formulated with Dermalogica\'s exclusive Anti-Ozonate Complex to protect skin from reactive ozone while botanicals immediately reduce irritation, redness and inflammation.',NULL,NULL,1,1,'','',7.50,'2 oz, 8 oz','','soothingprotectionspray.gif','7.50, 28.00',0.1250,1,1,'An ultra-calming spray formulated with Dermalogica\'s exclusive Anti-Ozonate Complex to protect skin from reactive ozone while botanicals immediately reduce irritation, redness and inflammation. Shields skin from further environmental assault caused by temperature extremes, pollution, irritating cosmetic products, harsh detergents, chemical exposure, stress, poor diet or hormonal factors. Soothing Green Tea, Canadian Willow Herb, Cucumber, Licorice and Raspberry extracts deliver potent anti-itching, healing and antioxidant properties. Fragrance free.',0.00,38,NULL,NULL),(39,'SKIN PURIFYING WIPES','0','Hygienic, quick cleansing wipes that help purify the skin while removing excess oil and impurities.',NULL,NULL,1,1,'','',15.00,'','','skinpurifyingwipes.gif','',0.1875,1,1,'Hygienic, quick cleansing wipes that help purify the skin while removing excess oil and impurities. Triclosan helps inhibit bacteria on the skin\'s surface. Also, formulated to help skin prone to breakouts. Contains exclusive Skin Response Complex of Balm Mint, Coneflower and Camphor to soothe and purify the skin, while Witch Hazel helps keep the skin clean and fresh. Travel pack goes anywhere, ideal for the gym, beach, and travel. Fragrance free.\r\nEach (20 wipes)\r\n',0.00,39,NULL,NULL),(40,'GENTLE CREAM EXFOLIANT','0','A gentle, non-abrasive exfoliation treatment to thoroughly remove dulling surface debris, dramatically improving skin texture.',NULL,NULL,1,1,'','',33.00,'','','gentlecreamexfoliant.gif','',0.2500,1,1,'A gentle, non-abrasive exfoliation treatment to thoroughly remove dulling surface debris, dramatically improving skin texture. Alpha hydroxy Lactic Acid, beta hydroxy Salicylic Acid and natural fruit enzymes detach dead skin cells, helping to stimulate skin renewal. Conditioning botanical extracts and humectants soothe the skin and combat dryness. Fragrance free. (2.5 oz)',0.00,40,NULL,NULL),(41,'SKIN PREP SCRUB','0','A skin-polishing scrub exfoliant with natural grains that leaves the skin with a smooth, healthy finish.',NULL,NULL,1,1,'','',27.50,'','','skinprepscrub.gif','',0.2500,1,1,'A skin-polishing scrub exfoliant with natural grains that leaves the skin with a smooth, healthy finish. Finely granulated Corn Cob Meal gently removes dulling surface debris, allowing for improved absorption of moisturizing treatments. Comforting botanical extracts of Mallow, Ivy and Cucumber plus soothing Aloe Vera help to prevent over-stimulation of the skin. Fragrance free. (2.5 oz)\r\n',0.00,41,NULL,NULL),(42,'DAILY MICROFOLIANT','0','This unique, Rice-based enzyme powder activates upon contact with water, releasing Papain, Salicylic Acid and Rice Enzymes to smooth the skin and accelerate cell renewal.',NULL,NULL,1,1,'','',45.00,'','','dailymicrofoliant.gif','',0.5000,1,1,'This unique, Rice-based enzyme powder activates upon contact with water, releasing Papain, Salicylic Acid and Rice Enzymes to smooth the skin and accelerate cell renewal. Our unique Skin Brightening Complex of Bearberry, Aspergillus, Grapefruit and Licorice helps to balance uneven skin pigmentation. Active agents derived from Rice Bran and Rice Extract help to regulate melanin production while micro-exfoliating dead cells. A super-soothing blend of Green Tea, Ginkgo and Colloidal Oatmeal calms inflammation, leaving the skin extraordinarily clear and refreshed. Gentle enough to use on a daily basis. Fragrance free. (2.6 oz)',0.00,42,NULL,NULL),(43,'SKIN SMOOTHING CREAM','0','A medium-weight cream that maintains skin\'s moisture balance while improving its texture.',NULL,NULL,1,1,'Size','',0.00,'1.75 oz, 3.5 oz','','skinsmoothingcream.gif','34.00, 49.00',0.1875,1,1,'A medium-weight cream that maintains skin\'s moisture balance while improving its texture. Deep-moisturizing Lecithin and Aloe Gel nourish while extracts of Mallow, Cucumber and Arnica soothe and hydrate the skin, helping to restore suppleness and tone. Antioxidant Grape Seed Extract plus Vitamins A, C and E reduce free radical activity while the light, emulsive protection helps shield against dehydration and pollution. Fragrance free.\r\n1.75 oz	$34.00	3oz\r\n3.5 oz	$49.00	5oz\r\n',0.00,43,NULL,NULL),(44,'OIL CONTROL LOTION','0','A feather-light lotion with technically advanced micro-sponges to absorb oil on the skin\'s surface throughout the day, reducing shine and providing a smooth, matte finish.',NULL,NULL,1,1,'Size','',0.00,'4 oz','','oilcontrollotion.gif','44.50',0.1875,1,1,'A feather-light lotion with technically advanced micro-sponges to absorb oil on the skin\'s surface throughout the day, reducing shine and providing a smooth, matte finish. Formulated with Salicylic Acid to help prevent future breakouts and exclusive Skin Response Complex of Balm Mint, Coneflower and Camphor to soothe and purify the skin. Ideally suited for an oily or acne-prone skin. Fragrance free.',0.00,44,NULL,NULL),(45,'ACTIVE MOIST','0','A lightweight, oil-free lotion for daily moisture protection to actively combat surface dehydration.',NULL,NULL,1,1,'Size','',0.00,'1.75 oz, 3.5 oz','','activemoist.gif','31.50, 44.50',0.1875,1,1,'A lightweight, oil-free lotion for daily moisture protection to actively combat surface dehydration. This sheer, easy-to-apply formula contains Silk Amino Acids and a unique combination of plant extracts to help smooth and improve the skin\'s texture. Natural botanical astringents of Lemon, Watercress, Burdock and Ivy help to refine the skin while soothing extracts of Lavender, Mallow and Cucumber provide deep hydration.\r\n',0.00,45,NULL,NULL),(46,'SHEER MOISTURE spf15','0','This lightweight, oil-free cream provides the ideal combination of moisture to combat dehydration, antioxidants to protect against free radical damage, and UV protection.',NULL,NULL,1,1,'','',36.00,'','','sheermoisture.gif','',0.1875,1,1,'This lightweight, oil-free cream provides the ideal combination of moisture to combat dehydration, antioxidants to protect against free radical damage, and UV protection. Natural Zinc Oxide minerals protect against sunlight and make skin radiant, while extracts from Olive Oil and Walnut Seeds provide antioxidant protection and improve skin texture. A full spectrum sunscreen provides daily solar defense. Fragrance free.\r\n(1.5 oz)',0.00,46,NULL,NULL),(47,'SHEER TINT MOISTURE spf15','0','This lightweight, oil-free cream provides the ideal combination of moisture to combat dehydration, antioxidants to protect against free radical damage, UV protection and long-lasting color.',NULL,NULL,1,1,'Color','',36.00,'Light, Medium, Dark','','sheertintmoisture.gif','',0.1875,1,1,'This lightweight, oil-free cream provides the ideal combination of moisture to combat dehydration, antioxidants to protect against free radical damage, UV protection and long-lasting color. Natural Zinc Oxide minerals protect against sunlight, provide a sheer wash of color and make skin radiant, while extracts from Olives and Walnut Seeds provide antioxidant protection and improve skin texture. A full spectrum sunscreen provides daily solar defense. Fragrance free.  Available in Light, Medium and Dark. (1.5 oz)\r\n',0.00,47,NULL,NULL),(48,'INTENSIVE MOISTURE BALANCE','0','Antioxidant enzyme Superoxide Dismutase, Vitamins A and E, and Ginkgo Biloba help prevent daily damage caused by free radicals.',NULL,NULL,1,1,'Size','',0.00,'1.75 oz, 3.5 oz','','intensivemoisturebalance.gif','35.50, 51.00',0.1875,1,1,'Antioxidant enzyme Superoxide Dismutase, Vitamins A and E, and Ginkgo Biloba help prevent daily damage caused by free radicals. Soothing Coneflower and Hydrocotyl, combined with botanical extracts of Grape Seed and Wild Yam, help repair prematurely aging skin, leaving it firm and smooth. Fragrance free.\r\n',0.00,48,NULL,NULL),(49,'BARRIER REPAIR','0','A unique anhydrous (waterless) moisturizer that melts gently into sensitized skin to soothe and help repair damage caused by environmental aggressions from pollution, temperature extremes, irritating cosmetic products, harsh detergents, chemical exposure, stress, poor diet or hormonal factors.',NULL,NULL,1,1,'','',34.50,'','','barrierrepair.gif','',0.1250,1,1,'A unique anhydrous (waterless) moisturizer that melts gently into sensitized skin to soothe and help repair damage caused by environmental aggressions from pollution, temperature extremes, irritating cosmetic products, harsh detergents, chemical exposure, stress, poor diet or hormonal factors. Formulated with Dermalogica\'s exclusive Anti-Ozonate Complex to protect skin from reactive ozone. Oil of Evening Primrose and emollient silicones provide a velvety feel, while strengthening the skin\'s natural lipid barrier to resist future damage. Shea Butter, Vitamin C and Bisabolol protect skin from dehydration, free radicals and inflammation. Fragrance free. (1.25 oz)',0.00,49,NULL,NULL),(50,'SKIN HYDRATING MASQUE','0','A hydrating, oil-free gel that restores critical moisture to dry skin without unwanted oiliness, helping to restore suppleness and reduce the appearance of fine, dry lines.',NULL,NULL,1,1,'','',33.50,'','','skinhydratingmasque.gif','',0.2500,1,1,'A hydrating, oil-free gel that restores critical moisture to dry skin without unwanted oiliness, helping to restore suppleness and reduce the appearance of fine, dry lines. Calming botanical extracts of Bitter Orange, Hops, Cucumber and Arnica reduce inflammation, while antioxidant Vitamins A, C and E and Pro-Vitamin B5 help to nourish and replenish the skin. Excellent for the delicate eye area. Fragrance free. (2.5 oz)',0.00,50,NULL,NULL),(51,'SKIN REFINING MASQUE','0','A skin-clarifying masque with oil-absorbing Kaolin and Bentonite clays plus Zinc Oxide to remove impurities and refine the skin\'s surface, helping to reduce oily-skin breakouts.',NULL,NULL,1,1,'','',32.50,'','','skinrefiningmasque.gif','',0.2500,1,1,'A skin-clarifying masque with oil-absorbing Kaolin and Bentonite clays plus Zinc Oxide to remove impurities and refine the skin\'s surface, helping to reduce oily-skin breakouts. Soothing botanical extracts of Mallow, Arnica and Cucumber help reduce inflammation while purifying Watercress, Lemon and Ivy revive dull skin. Fragrance free. (2.5 oz)',0.00,51,NULL,NULL),(52,'ANTI-BAC COOLING MASQUE','0','A medicated, soothing masque with cooling Menthol helps to calm blemish-prone skin while fighting bacteria. ',NULL,NULL,1,1,'','',33.50,'','','antibaccoolingmasque.gif','',0.2500,1,1,'A medicated, soothing masque with cooling Menthol helps to calm blemish-prone skin while fighting bacteria. Dermalogica\'s unique Alginated Zinc Triplex helps soothe, purify and fight sebum (oil) production. Naturally antiseptic Tea Tree Oil further aids in purifying the skin, while Green Tea and Licorice help calm inflamed skin and Panthenol promotes skin repair. Essential oils further enhance the calming effects. Fragrance free. (2.5 oz)\r\n',0.00,52,NULL,NULL),(53,'INTENSIVE MOISTURE MASQUE','0','A creamy, moisture-replenishing masque that provides vital nourishment for ultra-dry skin.',NULL,NULL,1,1,'','',36.50,'','','intensivemoisturemasque.gif','',0.2500,1,1,'A creamy, moisture-replenishing masque that provides vital nourishment for ultra-dry skin. Skin-conditioning Evening Primrose Oil and antioxidant Vitamin E restore skin\'s softness and suppleness. Revitalizing plant extracts, Honey and Vitamins A and C bind moisture to the skin, helping to alleviate fine lines and visible dryness. Fragrance free. (2.5 oz)',0.00,53,NULL,NULL),(54,'MULTI VITAMIN POWER RECOVERY MASQUE','0','An intensive masque of concentrated vitamins and botanical extracts to calm environmentally stressed skin.',NULL,NULL,1,1,'','',39.00,'','','multivitaminpowerrecoverymasque.gif','',0.2500,1,1,'An intensive masque of concentrated vitamins and botanical extracts to calm environmentally stressed skin. Firming Vitamin A increases elasticity and moisture content while antioxidant Vitamin C aids in collagen synthesis, restoring suppleness. Vitamin E and Pro-Vitamin B5 promote healthy tissue regeneration, while calming botanical extracts of Licorice, Comfrey and Burdock soothe the skin. Fragrance free. (2.5 oz)',0.00,54,NULL,NULL),(55,'SKIN HYDRATING BOOSTERS','0','Super-saturated hydration for the driest skin conditions, this intensive hydrating fluid revitalizes parched skin.',NULL,NULL,1,1,'','',51.00,'','','skinhydratingbooster.gif','',0.1250,1,1,'Super-saturated hydration for the driest skin conditions, this intensive hydrating fluid revitalizes parched skin. Hydrates, smoothes and minimizes fine lines with a concentrated blend of Hyaluronic Acid, Panthenol, Glycolipids and Algae Extract to restore moisture balance. Fragrance free. (1 oz)',0.00,55,NULL,NULL),(56,'GENTLE SOOTHING BOOSTER','0','A concentrated, oil-free complex of ultra-soothing botanicals to calm and hydrate irritated or sensitized skin. ',NULL,NULL,1,1,'','',43.00,'','','gentlesoothingbooster.gif','',0.1250,1,1,'A concentrated, oil-free complex of ultra-soothing botanicals to calm and hydrate irritated or sensitized skin. Soothing Red Raspberry Extract, healing Honey and calming flower extracts instantly reduce irritation while restoring natural moisture levels. Fragrance free. (1 oz)',0.00,56,NULL,NULL),(57,'EXTRA FIRMING BOOSTER','0','This super-concentrated retexturizing fluid visibly firms and smoothes the skin\'s surface.',NULL,NULL,1,1,'','',43.00,'','','extrafirmingbooster.gif','',0.1250,1,1,'This super-concentrated retexturizing fluid visibly firms and smoothes the skin\'s surface. Seaweed Extract, Vitamin C and Protein Peptides tighten the skin, helping to reinforce the firming effect. Fragrance free. (1 oz)\r\n',0.00,57,NULL,NULL),(59,'SKIN RENEWAL BOOSTER','0','A hydroxy acid concentrate of smoothing Lactic Acid, Salicylic Acid and Hibiscus Extract stimulates cell renewal, exfoliates dead skin cells and improves skin texture.',NULL,NULL,1,1,'','',43.00,'','','skinrenewalbooster.gif','',0.1250,1,1,'A hydroxy acid concentrate of smoothing Lactic Acid, Salicylic Acid and Hibiscus Extract stimulates cell renewal, exfoliates dead skin cells and improves skin texture. Vitamins A and C help reverse signs of photo aging while smoothing skin. Fragrance free. (1 oz)\r\n',0.00,59,NULL,NULL),(60,'MULTIVITAMIN POWER CONCENTRATE','0','This unique skin treatment delivers a concentrated dose of pure vitamins to help reduce the signs of premature aging.',NULL,NULL,1,1,'','',49.50,'','','multivitaminpowerconcentrate.gif','',0.1250,1,1,'This unique skin treatment delivers a concentrated dose of pure vitamins to help reduce the signs of premature aging. Vitamin A increases elasticity and moisture content, firming and strengthening the skin. Antioxidant Vitamin C stimulates natural collagen synthesis to restore suppleness, while Vitamin E promotes healthy tissue regeneration as it slows further cellular damage. Fragrance free. Professional recommendation advised. Includes Free Travel Container. (45 capsules)\r\n',0.00,60,NULL,NULL),(61,'MULTIVITAMIN POWER FIRM FOR THE EYE AND LIP AREA','0','Combat visible lines around the eye and mouth area with this powerful firming complex.',NULL,NULL,1,1,'','',46.00,'','','multivitaminpowerfirmforeyeandliparea.gif','',0.0625,1,1,'Combat visible lines around the eye and mouth area with this powerful firming complex. Seaweed Extract, Vitamins A, C and E, plus a healing shield of Organic Silicones, protect against damage, accelerate repair, strengthen elasticity and improve smoothness.\r\n.5 oz	$44.50	1oz\r\n',0.00,61,NULL,NULL),(62,'MEDICATED CLEARING GEL','0','An overnight medicated treatment to help clear skin and prevent blemishes by sloughing off dead skin cells and reducing sebum (oil) that clogs follicles leading to breakouts. ',NULL,NULL,1,1,'','',33.00,'','','medicatedclearinggel.gif','',0.2500,1,1,'An overnight medicated treatment to help clear skin and prevent blemishes by sloughing off dead skin cells and reducing sebum (oil) that clogs follicles leading to breakouts. Dermalogica\'s unique Alginated Zinc Triplex helps fight bacteria, provides anti-inflammatory benefits to soothe irritated skin and helps regulate sebum production. Exfoliating Salicylic Acid is delivered deep into the follicles to prevent future blemishes. Naturally purifying Tea Tree Oil helps fight future breakouts. Fragrance free. (2 oz)\r\n',0.00,62,NULL,NULL),(63,'SOOTHING EYE MAKE-UP REMOVER','0','An efficient, clean-rinsing make-up remover specially formulated to instantly dissolve all traces of eye and lip make-up, including stubborn mascara.',NULL,NULL,1,1,'','',21.50,'','','soothingeyemakeupremover.gif','',0.3750,1,1,'An efficient, clean-rinsing make-up remover specially formulated to instantly dissolve all traces of eye and lip make-up, including stubborn mascara. Completely oil-free, alcohol-free and water-soluble, this soothing, conditioning gel contains Silk Amino Acids to help strengthen lashes and condition the delicate eyelid area. With no irritation, stinging or oily after-feel, this gentle formula is ideal for contact lens wearers. Fragrance free. (4 oz)',0.00,63,NULL,NULL),(64,'TOTAL EYE CARE spf15','0','A technically advanced eye treatment cream to help protect and repair the delicate eye area.',NULL,NULL,1,1,'','',37.00,'','','totaleyecare.gif','',0.1250,1,1,'A technically advanced eye treatment cream to help protect and repair the delicate eye area. Gentle alpha hydroxy acids smooth while firming plant extracts retexturize the skin, helping to reduce the appearance of puffiness and fine lines. Optical light diffusers help diminish dark circles, instantly restoring translucency and freshness to the skin. A chemical-free sunscreen helps to shield against further damage. Fragrance free. (.75 oz)\r\n',0.00,64,NULL,NULL),(65,'INTENSIVE EYE REPAIR','0','An ultra-rich cream to help diminish dry lines and repair skin damage around the delicate eye area.',NULL,NULL,1,1,'','',42.00,'','','intensiveeyerepair.gif','',0.0625,1,1,'An ultra-rich cream to help diminish dry lines and repair skin damage around the delicate eye area. Skin-replenishing phytonutrients and eye-soothing botanicals of Cucumber, Butcherbroom and Arnica help maintain the skin\'s optimum health and restore suppleness. Wild Yam Extract and healing Pro-Vitamin B5 help repair prematurely aging skin, while antioxidant Vitamins A, C and E plus Grape Seed Extract protect the skin from harmful free radicals. Fragrance free. (.5 oz)',0.00,65,NULL,NULL),(66,'DAY BRIGHT spf15','0','A tri-active system that brightens, illuminates and protects skin during the day.',NULL,NULL,1,1,'','',46.00,'','','daybright.gif','',0.1250,1,1,'A tri-active system that brightens, illuminates and protects skin during the day. Our exclusive Brightening Complex of eleven active botanical brighteners helps balance uneven pigmentation while optical illuminators manipulate light and shadows to create the luminosity associated with healthy skin. An SPF15 protects against further UV-related pigmentation, enhancing treatment results. Fragrance free. (1 oz)',0.00,66,NULL,NULL),(67,'NIGHT BRIGHT','0','This maximum strength, nighttime formula brightens skin and balances uneven pigmentation caused by sun exposure, age spots and hormonal imbalance with our safe, hydroquinone-free Brightening Complex.',NULL,NULL,1,1,'','',48.00,'','','nightbright.gif','',0.1250,1,1,'This maximum strength, nighttime formula brightens skin and balances uneven pigmentation caused by sun exposure, age spots and hormonal imbalance with our safe, hydroquinone-free Brightening Complex. A botanical blend of eleven active brighteners, including Licorice, Bearberry, Rice, Kiwi and Mulberry is combined with Lactic Acid and Vitamin C to help diminish skin discoloration. Fragrance free. Professional recommendation advised. Use nightly for 8 to 10 weeks for visible results. A minimum SPF15 must be used in the daytime. We recommend Day Bright SPF15. (0.75 oz)\r\n',0.00,67,NULL,NULL),(68,'AFTER SUN REPAIR','0','A treatment balm that helps repair damage from exposure to UV sunlight. ',NULL,NULL,1,1,'','',29.00,'','','aftersunrepair.gif','',0.3125,1,1,'A treatment balm that helps repair damage from exposure to UV sunlight. Our Reparative Complex, enriched with a blend of Seaweed Extracts and soothing botanicals, helps protect cell proteins from further damage while restoring the skin\'s condition. Japanese Alder scavenges free radicals and accelerates repair of UV-induced DNA damage while Algae Extracts, Hyaluronic Acid and Glycolipids restore lost moisture to further accelerate the recovery process. A blend of homeopathic herbs including Clove Oil, Szechuan Pepper, Licorice, Mugwort, Lavender, Cucumber, Chamomile and Yucca helps reduce irritation, redness and pain induced by sunburn. Fragrance free. (3.5 oz)\r\n',0.00,68,NULL,NULL),(69,'FULL SPECTRUM BLOCK spf15','0','Sun protection and skin care united in this moisture-rich, water-resistant (40 minutes) sun block for face and body. ',NULL,NULL,1,1,'','',27.00,'','','fullspectrumblock.gif','',0.3750,1,1,'Sun protection and skin care united in this moisture-rich, water-resistant (40 minutes) sun block for face and body. Formulated with the latest sunscreen technology, including Avobenzone, to provide broad spectrum protection against the UVA, UVB and infrared rays that can accelerate premature aging. A powerful antioxidant blend of Grape Seed, Green Tea plus Vitamins A, C and E guards against damaging free radical activity, while anti-inflammatory herbal extracts soothe the skin. Fragrance free. (4 oz)',0.00,69,NULL,NULL),(70,'WATERPROOF SOLAR SPRAY spf25','0','Now you can mist on ultra-waterproof (up to 80 minutes), SPF25 sun protection without drying alcohol. ',NULL,NULL,1,1,'','',29.50,'','','waterproofsolarspray.gif','',0.3750,1,1,'Now you can mist on ultra-waterproof (up to 80 minutes), SPF25 sun protection without drying alcohol. Complete with the latest sunscreen technology, including Avobenzone, this formula absorbs quickly to provide an invisible full-body shield against the damaging UVA, UVB and Infrared rays that can cause dermal damage, premature aging and hair breakage. Antioxidant Vitamins C and E guard against free radical activity, while Grapefruit Oil and organic silicones condition the skin and prevent moisture loss. Fragrance free. (4 oz)\r\n',0.00,70,NULL,NULL),(71,'PROTECTIVE SELF TAN spf15','0','Go bronze...now! This easy-to-apply, instant bronzing cream delivers a sun-kissed glow immediately, while our unique complex stimulates the skin\'s natural tanning process for longer-lasting results.',NULL,NULL,1,1,'','',31.50,'','','protectiveselftan.gif','',0.3750,1,1,'Go bronze...now! This easy-to-apply, instant bronzing cream delivers a sun-kissed glow immediately, while our unique complex stimulates the skin\'s natural tanning process for longer-lasting results. A full-spectrum SPF15 shields your skin from harmful UV rays for the ultimate guilt-free glow. Illuminating bronzing agents show precisely where the tanner has been applied to eliminate streaking, while hydrating botanicals, vitamins and antioxidants moisturize the skin and help prevent free radical damage. Fragrance free. (4 oz)\r\n',0.00,71,NULL,NULL),(72,'SOLAR DEFENSE BOOSTER spf30','0','Change your sun protection as often as the weather! This daily-use, broad spectrum sun block can be used alone, or mixed with your favorite Dermalogica moisturizer or foundation.',NULL,NULL,1,1,'','',33.00,'','','solardefensebooster.gif','',0.1250,1,1,'Change your sun protection as often as the weather! This daily-use, broad spectrum sun block can be used alone, or mixed with your favorite Dermalogica moisturizer or foundation. Formulated with the optimum blend of sunscreens, including Avobenzone, to help protect against the UVA, UVB and Infrared rays that can cause deeper dermal damage. Vitamins A, C and E, help further protect against premature aging. Fragrance free. (1 oz)',0.00,72,NULL,NULL),(73,'SOLAR SHIELD','0','Protects easily burned areas with SPF15 sun protection.',NULL,NULL,1,1,'','',10.00,'','','solarshield.gif','',0.0625,1,1,'Protects easily burned areas with SPF15 sun protection. Shields sensitive areas during swimming with up to 80 minutes of continuous waterproof protection. Botanical extracts combined with natural moisturizers help to soothe and hydrate skin. Provides portable, easy to use protection. (.28 oz)\r\n',0.00,73,NULL,NULL),(74,'ULTRARICH BODY CREAM','0','An ultra-rich, long-lasting body cream to help heal and relieve extra dry skin.',NULL,NULL,1,1,'','',46.00,'','','ultrarichbodycream.gif','',1.2500,1,1,'An ultra-rich, long-lasting body cream to help heal and relieve extra dry skin. This unique liquefying formula is also ideal for all-over, deeply moisturizing body massages. Fortified with Dermalogica\'s Environmental Protection Complex of Glycolipids and Vitamin E to help restore and enhance the barrier function of skin, reducing moisture loss while combating free radical damage. Hyaluronic Acid and Evening Primrose Oil, a concentrated source of skin-smoothing Linoleic Acid, quenches and reconditions thirsty skin while Panthenol aids in cellular repair. Fragrance free. (16 oz)\r\n',0.00,74,NULL,NULL),(75,'STRESS RELIEF TREATMENT OIL','0','An aromatic body treatment oil ideal for massage, bath therapy and deluxe skin conditioning. ',NULL,NULL,1,1,'','',22.50,'','','stressrelieftreatmentoil.gif','',0.3750,1,1,'An aromatic body treatment oil ideal for massage, bath therapy and deluxe skin conditioning. Completely water-soluble, this soothing blend combines advanced Organic Silicones for skin smoothing with calming essential oils of Sandalwood, Lavender, Orange and Clary Sage. Naturally purifying extracts of Tea Tree, Lemon and Ylang-Ylang help to counteract the negative mental effects of stress for the ultimate in relaxation. Fragrance free. (4 oz)\r\n',0.00,75,NULL,NULL),(76,'TOXIN RELIEF TREATMENT OIL','0','An aromatic, detoxifying body treatment oil for massage, bath therapy and deep skin conditioning.',NULL,NULL,1,1,'','',22.50,'','','toxinrelieftreatmentoil.gif','',0.3750,1,1,'An aromatic, detoxifying body treatment oil for massage, bath therapy and deep skin conditioning. Purifying essential oils of Rosemary, Sage, Pine, Juniper and Lemongrass stimulate circulation and help to purge the body of accumulated toxins. This naturally fragrant sweet balsamic oil is water soluble and fortified with invigorating essential oils to alleviate bloating and sluggishness. Fragrance free. (4 oz)',0.00,76,NULL,NULL),(77,'ULTIMATE BUFFING CLOTH','0','A gentle yet effective way to exfoliate the entire body during cleansing.',NULL,NULL,1,1,'','',12.00,'','','ultimatebuffingcloth.gif','',0.1250,1,1,'A gentle yet effective way to exfoliate the entire body during cleansing. Perfect for a \"power cleansing\" treatment when used with Conditioning Body Wash. May be machine washed in the delicate cold wash cycle.\r\n',0.00,77,NULL,NULL),(78,'EXFOLIATING BODY SCRUB','0','Designed for all skin conditions, this creamy, lightly foaming body scrub will dramatically smooth, polish and energize the skin.',NULL,NULL,1,1,'','',28.00,'','','exfoliatingbodyscrub.gif','',0.5000,1,1,'Designed for all skin conditions, this creamy, lightly foaming body scrub will dramatically smooth, polish and energize the skin. Fig, Date and Olive seed powders gently remove dead and dulling cells. Rice Bran and Papaya Enzymes slough off impurities and stimulate cell renewal. Purifying essential oils of Lavender, Orange, Sandalwood and Rosemary condition and invigorate the body while awakening the senses. Fragrance free. (6 oz)',0.00,78,NULL,NULL),(79,'TREATMENT FOUNDATION','0','Our oil-free formula contains antioxidant vitamins and natural humectants to help protect the skin from moisture loss.',NULL,NULL,1,1,'','',32.00,'','','treatmentfoundation.gif','',0.1875,1,1,'Our oil-free formula contains antioxidant vitamins and natural humectants to help protect the skin from moisture loss. Natural, non-sensitizing pigments maintain true color and texture all day without irritating the skin. A full spectrum of eight shades, plus two Color Correctors, makes Treatment Foundation the ideal choice for all skin tones. Includes two hypoallergenic application sponges. Fragrance free. (1.5 oz)\r\n',0.00,79,NULL,NULL),(80,'COLOR CORRECTOR +','0','Naturally pigmented and oil-free, Color Correctors customize your Dermalogica Treatment Foundation for a perfect match.',NULL,NULL,1,1,'','',17.00,'','','colorcorrectorplus.gif','',0.1250,1,1,'Naturally pigmented and oil-free, Color Correctors customize your Dermalogica Treatment Foundation for a perfect match. Select (+), a warm, earthy shade, to deepen your color or add contour to the eyes, brows and cheekbones. (.75 oz)\r\n',0.00,80,NULL,NULL),(81,'COLOR CORRECTOR -','0','Naturally pigmented and oil-free, Color Correctors customize your Dermalogica Treatment Foundation for a perfect match.',NULL,NULL,1,1,'','',17.00,'','','colorcorrectorminus.gif','',0.1250,1,1,'Naturally pigmented and oil-free, Color Correctors customize your Dermalogica Treatment Foundation for a perfect match. Select Color Corrector (-) a light ivory blend, to lighten your color, or conceal blemishes. Fragrance free. Professional recommendation advised. (.75 oz)\r\n',0.00,81,NULL,NULL),(86,'Professional Shave','0','Ultra-smooth shaving remedy that forms a cushion between skin and razor for a close, non-irritating shave. Essential oils, organic silicones and antiseptic camphor soothe and protect the skin. Fragrance free.',NULL,NULL,1,1,'Size','',0.00,'1.25 oz','','professional-shave.gif','17.00',0.0000,1,1,'Ultra-smooth shaving remedy that forms a cushion between skin and razor for a close, non-irritating shave. Essential oils, organic silicones and antiseptic camphor soothe and protect the skin. Fragrance free.',0.00,86,NULL,NULL),(82,'SOY PROTEIN SHAMPOO','0','<p>Soy Protein Shampoo naturally defends hair from the harmful effects of the environment, while at the same time working to retain the hair\'s moisture.  It nourishes hair, giving it strength, softness and body. European studies have found that soy protein reinforces hair and stimulates growth.  Soy offers a \"complete\" protein profile containing the entire essential amino acids. This botanically rich shampoo with soy is designed to restore and strengthen chemically altered, dry, weak or damaged hair. (12 oz)</p>',NULL,NULL,1,1,'','',14.00,'','','soy_protein_shampoo.jpg','',0.9375,1,1,'<p>Soy Protein Shampoo naturally defends hair from the harmful effects of the environment, while at the same time working to retain the hair\'s moisture.  It nourishes hair, giving it strength, softness and body. European studies have found that soy protein reinforces hair and stimulates growth.  Soy offers a \"complete\" protein profile containing the entire essential amino acids. This botanically rich shampoo with soy is designed to restore and strengthen chemically altered, dry, weak or damaged hair. (12 oz)</p>\r\n<p><u><b>Benefits</b></u></p><ul>\r\n<li>Strengthens hair giving it more body.</li>\r\n<li>Shampoo is color fast. It will keep color from fading.</li>\r\n<li>Shampoo is concentrated and lathers well.</li>\r\n<li>Helps keep naturally curly or permed hair from frizzing.\r\n<li>Will minimize split ends.</li>\r\n</ul>',0.00,82,NULL,NULL),(83,'SOY PROTEIN CONDITIONER','0','<p>Soy Protein Conditioner smoothes, detangles, strengthens and protects all hair types and conditions.  This exclusive formulation of soy protein and botanicals infuses extra moisture and protein into the hair.  It strengthens and repairs damaged hair cuticle to prevent breakage and protect hair from environmental damage.  Soy offers a \"complete\" protein profile containing the entire essential amino acids to add volume and fullness. (12 oz)</p>',NULL,NULL,1,1,'','',18.00,'','','soyproteinconditioner.jpg','',0.9375,1,1,'<p>Soy Protein Conditioner smoothes, detangles, strengthens and protects all hair types and conditions.  This exclusive formulation of soy protein and botanicals infuses extra moisture and protein into the hair.  It strengthens and repairs damaged hair cuticle to prevent breakage and protect hair from environmental damage.  Soy offers a \"complete\" protein profile containing the entire essential amino acids to add volume and fullness. (12 oz)</p>\r\n<p><u><b>Benefits</b></u></p>\r\n<ul>\r\n<li>Will keep hair color more vibrant and rich.</li>\r\n<li>Improves body and pliability.  </li>\r\n<li>Adds shine and reduces static and flyaways. </li>\r\n<li>Will minimize split ends and breakage.</li>\r\n<li>Keeps curl stronger and bouncy.</li>\r\n<li>Keeps naturally curly or permed hair from frizzing.\r\n</li></ul>',0.00,83,NULL,NULL),(84,'coming soon - Bumble and Bumble products','0','',NULL,NULL,1,1,'','',0.00,'','','','',0.0000,1,1,'',0.00,84,NULL,NULL),(89,'Day of Beauty Two','0','Package includes: Haircut and Style, Manicure and Pedicure, European Facial, Stress Therapy Massage, Lunch and Make-up Application<br><br>\r\n<a href=\"http://shop.maneattractionsalon.com/pk4/store.pl?view_product=89\">Click for more info</a>',NULL,NULL,1,1,'','',250.00,'','','gift-cert-after.jpg','',0.0000,1,1,'A relaxing Manicure and Pedicure begins your special someone’s day.  All of their worries and tension will melt away with a Stress Therapy Massage and European Facial.  A delicious lunch from one of our critically acclaimed neighbors will satisfy their hunger. Finally, they will get a personalized Haircut and Style from our internationally trained staff.  Beautiful makeup will complete their special day. ',0.00,89,1,NULL),(88,'Day of Beauty One','0','Package includes: Blow Dry and Style, Manicure, European Facial, Lunch and Make-up Application <br><br>\r\n<a href=\"http://shop.maneattractionsalon.com/pk4/store.pl?view_product=88\">Click for more info</a>',NULL,NULL,1,1,'','',160.00,'','','gift-cert-facial.jpg','',0.0000,1,1,'A European Facial and Manicure will begin this relaxing journey.  A soothing neck, back and scalp massage are included with their blow dry and styling.  Makeup will complete their tranquil day.  All of this and a delicious lunch await your special someone.',0.00,88,1,NULL),(90,'Makeover for Her','0','Package includes: Haircut and Style, Color, Highlights, and Make-up Application<br><br>\r\n<a href=\"http://shop.maneattractionsalon.com/pk4/store.pl?view_product=90\">Click for more info</a>',NULL,NULL,1,1,'','',244.00,'','','gift-cert-Cassie.jpg','',0.0000,1,1,'Our internationally trained staff will analyze bone structure, body structure, hair type and lifestyle to recommend the ideal look for your special someone.  Color choices will enhance the shape and texture of their new style and accentuate the positive tones of their skin.  Eyes will be framed by their perfectly arched brows and beautiful makeup will complete their transformation.',0.00,90,1,NULL),(91,'Makeover for Him','0','Package Includes: Haircut and Style, Highlights<br><br>\r\n<a href=\"http://shop.maneattractionsalon.com/pk4/store.pl?view_product=91\">Click for more info</a>',NULL,NULL,1,1,'','',133.00,'','','gift-cert-Mick.jpg','',0.0000,1,1,'A new hair cut will accentuate his rugged good looks and natural highlights will complete the transformation.',0.00,91,1,NULL),(93,'Choose a Gift Certificate Amount','0','Select a specific Gift Certificate Amount.                             <br><br>\r\n<a href=\"http://shop.maneattractionsalon.com/pk4/store.pl?view_product=93\">Click for more info</a>',NULL,NULL,1,1,'Amount','',0.00,'$50 Gift Certificate, $75 Gift Certificate,$100 Gift Certificate, $125 Gift Certificate, $150 Gift Certificate, $175 Gift Certificate, $200 Gift Certificate, $225 Gift Certificate, $250 Gift Certificate','','ma-logo.jpg','50, 75, 100, 125, 150, 175, 200, 225, 250',0.0000,1,1,'Select a specific Gift Certificate Amount.',0.00,93,1,NULL),(94,'Bumble and Bumble','0','<table border=\"0\" cellspacing=\"0\" cellpadding=\"1\">\r\n  <tr>\r\n    <td width=\"121\" valign=\"top\"> \r\n      <p><img src=\"Images/Bb1.gif\"></p>\r\n      <p><img src=\"Images/Bb-Core-Line-1.jpg\" width=\"100\" height=\"150\"></p>\r\n      <p><img src=\"Images/Treatment-10.jpg\" width=\"100\" height=\"169\"></p>\r\n      </td>\r\n    <td width=\"546\" valign=\"top\"><p><font size=\"2\">We are proud to be a Bumble and bumble Network Salon. You’ve probably seen it in Vogue and W. Less than 1% of the salons in the United States are selected to carry this prestigious line. Stop by our salon for a complimentary consultation and prescription for your ideal Bumble and bumble home care program.  </font></p>\r\n      <p align=\"center\"><a href=\"http://www.bumbleandbumble.com/product/index.tmpl?salon_id=MANE01\" target=\"_blank\">Click Here </a>to purchase Bumble & Bumble products </p>\r\n      <p align=\"center\"><a href=\"http://www.bumbleandbumble.com/product/index.tmpl?salon_id=MANE01\"><img src=\"Images/shopbumble_tall_170x70.gif\" alt=\"Bumble & Bumble Products\" border=\"0\"></a></p>      <p> </p></td>\r\n  </tr>\r\n</table>\r\n',NULL,NULL,0,0,'','',0.00,'','','','',0.0000,1,1,'<table border=\"0\" cellspacing=\"0\" cellpadding=\"1\">\r\n  <tr>\r\n    <td width=\"121\" valign=\"top\"> \r\n      <p><img src=\"Images/Bb1.gif\"></p>\r\n      <p><img src=\"Images/Bb-Core-Line-1.jpg\" width=\"100\" height=\"150\"></p>\r\n      <p><img src=\"Images/Treatment-10.jpg\" width=\"100\" height=\"169\"></p>\r\n      </td>\r\n    <td width=\"546\" valign=\"top\"><p><font size=\"2\">We are proud to be a Bumble and bumble Network Salon. You’ve probably seen it in Vogue and W. Less than 1% of the salons in the United States are selected to carry this prestigious line. Stop by our salon for a complimentary consultation and prescription for your ideal Bumble and bumble home care program.  </font></p>\r\n      <p align=\"center\"><a href=\"http://www.bumbleandbumble.com/product/index.tmpl?salon_id=MANE01\" target=\"_blank\">Click Here </a>to purchase Bumble & Bumble products </p>\r\n      <p align=\"center\"><a href=\"http://www.bumbleandbumble.com/product/index.tmpl?salon_id=MANE01\"><img src=\"Images/shopbumble_tall_170x70.gif\" alt=\"Bumble & Bumble Products\" border=\"0\"></a></p>      <p> </p></td>\r\n  </tr>\r\n</table>\r\n',0.00,94,0,NULL),(95,'Dermalogica','0','<p align=\"center\"><img src=\"Images/dermalogica_products.jpg\" width=\"492\" height=\"145\"></p>\r\n<p>For years, Dermalogica\'s formulas have pioneered new  standards for product performance. Using only the finest ingredients available,  all Dermalogica products are non-comedogenic and contain no occlusive mineral  oil or lanolin, no irritating artificial colors or fragrance, and no drying  S.D. alcohol.  For best results, ask our  skin therapist for a complimentary <a href=\"http://www.dermalogica.com/skin_info/fm_images/faceM_hm.asp?location=US&Region=B\">Face  Mapping®</a> consultation – a zone-by-zone analysis for the most targeted skin  care and unsurpassed results!</p>',NULL,NULL,0,1,'','',0.00,'','','','',0.0000,1,1,'<p align=\"center\"><img src=\"Images/dermalogica_products.jpg\" width=\"492\" height=\"145\"></p>\r\n<p>For years, Dermalogica\'s formulas have pioneered new  standards for product performance. Using only the finest ingredients available,  all Dermalogica products are non-comedogenic and contain no occlusive mineral  oil or lanolin, no irritating artificial colors or fragrance, and no drying  S.D. alcohol.  For best results, ask our  skin therapist for a complimentary <a href=\"http://www.dermalogica.com/skin_info/fm_images/faceM_hm.asp?location=US&Region=B\">Face  Mapping®</a> consultation – a zone-by-zone analysis for the most targeted skin  care and unsurpassed results!</p>',0.00,95,0,NULL),(96,'Aveda','0','Aveda\'s professional hair and skin care products give you a fashion-forward look while supporting eco-friendly practices.  Aveda manufactures plant-based hair care, skin care and makeup products. Their botanically based products are better for our staff, our clients as well as the planet.',NULL,NULL,0,0,'','',0.00,'','','AvedaLogo2009.jpg','',0.0000,1,1,'Aveda\'s professional hair and skin care products give you a fashion-forward look while supporting eco-friendly practices.  Aveda manufactures plant-based hair care, skin care and makeup products. Their botanically based products are better for our staff, our clients as well as the planet.',0.00,96,0,NULL);

--
-- Table structure for table `Sale`
--

CREATE TABLE `Sale` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `productID` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `name` varchar(60) DEFAULT NULL,
  `sku` varchar(30) DEFAULT NULL,
  `price` double(8,2) NOT NULL DEFAULT '0.00',
  `label1` varchar(50) DEFAULT NULL,
  `label2` varchar(50) DEFAULT NULL,
  `invoiceID` int(11) NOT NULL DEFAULT '0',
  `notax` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=105 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Sale`
--

INSERT INTO `Sale` VALUES (1,91,1,'Makeover for Him','0',130.00,'','',1,NULL),(2,93,1,'Choose a Gift Certificate Amount','0',75.00,' Gift','',2,NULL),(3,93,1,'Choose a Gift Certificate Amount','0',75.00,' Gift','',3,NULL),(4,88,1,'Day of Beauty One','0',160.00,'','',4,NULL),(6,23,2,'Quick Fix Hair Spray','0',10.00,' 8 oz','',6,NULL),(7,1,3,'MINT CLARIFYING SHAMPOO','0',9.00,'','',7,NULL),(8,93,1,'Choose a Gift Certificate Amount','0',50.00,'Gift','',8,NULL),(9,94,1,'Bumble and Bumble','0',0.00,'','',9,NULL),(10,93,1,'Choose a Gift Certificate Amount','0',50.00,'Gift','',10,NULL),(11,93,1,'Choose a Gift Certificate Amount','0',75.00,' Gift','',11,NULL),(12,93,2,'Choose a Gift Certificate Amount','0',75.00,' Gift','',12,NULL),(13,93,1,'Choose a Gift Certificate Amount','0',75.00,' Gift','',13,NULL),(14,14,1,'BIOGEL MOUSSE','0',15.00,'','',14,NULL),(15,25,3,'FOAMATION','0',13.00,'','',15,NULL),(16,93,1,'Choose a Gift Certificate Amount','0',75.00,' Gift','',16,NULL),(17,88,1,'Day of Beauty One','0',160.00,'','',17,NULL),(18,93,1,'Choose a Gift Certificate Amount','0',50.00,'Gift','',18,NULL),(19,93,1,'Choose a Gift Certificate Amount','0',75.00,' Gift','',18,NULL),(20,18,2,'ORGANIC BIO EXTENDER','0',19.00,'','',19,NULL),(21,93,1,'Choose a Gift Certificate Amount','0',75.00,' Gift','',20,NULL),(22,90,1,'Makeover for Her','0',240.00,'','',20,NULL),(23,93,1,'Choose a Gift Certificate Amount','0',75.00,' Gift','',21,NULL),(24,89,1,'Day of Beauty Two','0',250.00,'','',22,NULL),(25,14,2,'BIOGEL MOUSSE','0',15.00,'','',23,NULL),(26,88,1,'Day of Beauty One','0',160.00,'','',24,NULL),(27,20,1,'SPRAY SHINE','0',12.00,'','',25,NULL),(31,93,1,'Choose a Gift Certificate Amount','0',75.00,' Gift','',29,NULL),(29,88,1,'Day of Beauty One','0',160.00,'','',27,NULL),(30,14,2,'BIOGEL MOUSSE','0',15.00,'','',28,NULL),(32,11,1,'KORTAPLEXX','0',10.00,'','',30,NULL),(33,93,1,'Choose a Gift Certificate Amount','0',75.00,' Gift','',31,NULL),(34,89,1,'Day of Beauty Two','0',250.00,'','',32,NULL),(35,89,1,'Day of Beauty Two','0',250.00,'','',33,NULL),(36,93,2,'Choose a Gift Certificate Amount','0',50.00,'Gift','',34,NULL),(37,89,1,'Day of Beauty Two','0',250.00,'','',35,NULL),(38,93,1,'Choose a Gift Certificate Amount','0',50.00,'$50 Gift Certificate','',36,NULL),(39,44,1,'OIL CONTROL LOTION','0',44.50,'4 oz','',37,NULL),(40,41,2,'SKIN PREP SCRUB','0',27.50,'','',37,NULL),(41,37,1,'MULTI ACTIVE TONER','0',26.00,'8 oz','',37,NULL),(42,30,1,'DERMAL CLAY CLEANSER','0',41.50,' 16 oz','',37,NULL),(43,29,1,'ANTI BAC SKIN WASH','0',41.50,' 16 oz','',37,NULL),(44,45,1,'ACTIVE MOIST','0',44.50,' 3.5 oz','',37,NULL),(45,60,1,'MULTIVITAMIN POWER CONCENTRATE','0',49.50,'','',37,NULL),(46,42,2,'DAILY MICROFOLIANT','0',45.00,'','',38,NULL),(49,1,1,'MINT CLARIFYING SHAMPOO','0',9.00,'','',41,NULL),(48,1,3,'MINT CLARIFYING SHAMPOO','0',9.00,'','',40,NULL),(50,4,1,'VOLUMIZING SHAMPOO','0',9.00,'8 oz','',41,NULL),(51,14,3,'BIOGEL MOUSSE','0',15.00,'','',42,NULL),(52,14,2,'BIOGEL MOUSSE','0',15.00,'','',43,NULL),(53,93,1,'Choose a Gift Certificate Amount','0',50.00,'$50 Gift Certificate','',44,NULL),(54,49,1,'BARRIER REPAIR','0',34.50,'','',45,NULL),(55,54,1,'MULTI VITAMIN POWER RECOVERY MASQUE','0',39.00,'','',45,NULL),(56,29,1,'ANTI BAC SKIN WASH','0',41.50,' 16 oz','',45,NULL),(57,14,3,'BIOGEL MOUSSE','0',15.00,'','',46,NULL),(58,11,3,'KORTAPLEXX','0',10.00,'','',47,NULL),(59,11,2,'KORTAPLEXX','0',10.00,'','',48,NULL),(60,93,1,'Choose a Gift Certificate Amount','0',75.00,' $75 Gift Certificate','',49,NULL),(61,91,1,'Makeover for Him','0',130.00,'','',50,NULL),(62,89,1,'Day of Beauty Two','0',250.00,'','',51,NULL),(63,93,1,'Choose a Gift Certificate Amount','0',50.00,'$50 Gift Certificate','',52,NULL),(64,93,1,'Choose a Gift Certificate Amount','0',50.00,'$50 Gift Certificate','',53,NULL),(65,8,1,'PROTEIN REMOISTURIZER','0',25.00,' 32 oz','',54,NULL),(66,3,1,'MOISTURIZING SHAMPOO','0',23.00,' 32 oz','',54,NULL),(67,93,1,'Choose a Gift Certificate Amount','0',100.00,'$100 Gift Certificate','',55,NULL),(70,90,1,'Makeover for Her','0',240.00,'','',58,NULL),(69,18,2,'ORGANIC BIO EXTENDER','0',19.00,'','',57,NULL),(71,93,1,'Choose a Gift Certificate Amount','0',50.00,'$50 Gift Certificate','',59,NULL),(76,93,1,'Choose a Gift Certificate Amount','0',100.00,'$100 Gift Certificate','',64,NULL),(77,93,1,'Choose a Gift Certificate Amount','0',50.00,'$50 Gift Certificate','',65,NULL),(78,3,2,'MOISTURIZING SHAMPOO','0',4.00,'2 oz','',66,NULL),(79,3,1,'MOISTURIZING SHAMPOO','0',23.00,' 32 oz','',66,NULL),(80,76,1,'TOXIN RELIEF TREATMENT OIL','0',22.50,'','',67,NULL),(81,25,2,'FOAMATION','0',13.00,'','',68,NULL),(82,93,1,'Choose a Gift Certificate Amount','0',50.00,'$50 Gift Certificate','',69,NULL),(83,93,1,'Choose a Gift Certificate Amount','0',100.00,'$100 Gift Certificate','',70,NULL),(86,93,1,'Choose a Gift Certificate Amount','0',125.00,' $125 Gift Certificate','',73,NULL),(85,90,1,'Makeover for Her','0',240.00,'','',72,NULL),(90,14,3,'BIOGEL MOUSSE','0',15.00,'','',77,NULL),(88,93,1,'Choose a Gift Certificate Amount','0',75.00,' $75 Gift Certificate','',75,NULL),(89,93,1,'Choose a Gift Certificate Amount','0',50.00,'$50 Gift Certificate','',76,NULL),(91,14,3,'BIOGEL MOUSSE','0',15.00,'','',78,NULL),(92,90,1,'Makeover for Her','0',227.00,'','',79,NULL),(93,93,1,'Choose a Gift Certificate Amount','0',150.00,' $150 Gift Certificate','',80,NULL),(94,93,1,'Choose a Gift Certificate Amount','0',200.00,' $200 Gift Certificate','',81,NULL),(95,93,1,'Choose a Gift Certificate Amount','0',100.00,'$100 Gift Certificate','',83,NULL),(96,93,1,'Choose a Gift Certificate Amount','0',250.00,' $250 Gift Certificate','',84,NULL),(97,25,3,'FOAMATION','0',13.00,'','',85,NULL),(98,93,1,'Choose a Gift Certificate Amount','0',200.00,' $200 Gift Certificate','',86,NULL),(99,93,1,'Choose a Gift Certificate Amount','0',100.00,'$100 Gift Certificate','',87,NULL),(100,93,1,'Choose a Gift Certificate Amount','0',200.00,' $200 Gift Certificate','',89,NULL),(102,93,1,'Choose a Gift Certificate Amount','0',150.00,' $150 Gift Certificate','',91,NULL);

--
-- Table structure for table `Shipping`
--

CREATE TABLE `Shipping` (
  `carrier` tinytext,
  `method` tinytext,
  `weight` double(16,2) DEFAULT NULL,
  `price` double(16,2) DEFAULT NULL,
  `record_type` tinyint(4) NOT NULL DEFAULT '0',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) DEFAULT NULL,
  `class` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Shipping`
--

INSERT INTO `Shipping` VALUES (NULL,'UPS',1.00,5.00,2,1,NULL,NULL),(NULL,'UPS',2.00,7.00,2,2,NULL,NULL),(NULL,'UPS',3.00,9.00,2,3,NULL,NULL),(NULL,'UPS',4.00,11.00,2,4,NULL,NULL),(NULL,'UPS',5.00,13.00,2,5,NULL,NULL),(NULL,'UPS',7.00,18.00,2,6,NULL,NULL),(NULL,'UPS',10.00,23.00,2,7,NULL,NULL),(NULL,'UPS',20.00,35.00,2,8,NULL,NULL);

--
-- Table structure for table `Shopping`
--

CREATE TABLE `Shopping` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `product` int(11) NOT NULL DEFAULT '0',
  `session` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `label1` tinytext,
  `sitename` tinytext,
  `label2` tinytext,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=661 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Shopping`
--

INSERT INTO `Shopping` VALUES (660,11,1410124575,1,'','maneattraction','');

--
-- Dumping events for database 'maneattraction'
--

--
-- Dumping routines for database 'maneattraction'
--


