INSERT INTO catalog (`parent`,`level`,`priority`,`is_visible`,`list_subcats`,`list_subcats_images`,`url_hash`,`url_default`,`url_custom`,`key_name`,`meta_title`,`meta_description`,`category_header`,`name`,`description`,`description_bottom`,`category_path`,`exactor_euc_code`,`avalara_tax_code`) VALUES ('0','2','5','Yes','No','1','6aa467924c08aa8c8b9d539001e4b08b','men/','','test__cat1','','','','Men','','','Men','','');
SET @catalog_test__cat1 = LAST_INSERT_ID();
INSERT INTO catalog (`parent`,`level`,`priority`,`is_visible`,`list_subcats`,`list_subcats_images`,`url_hash`,`url_default`,`url_custom`,`key_name`,`meta_title`,`meta_description`,`category_header`,`name`,`description`,`description_bottom`,`category_path`,`exactor_euc_code`,`avalara_tax_code`) VALUES ('0','1','5','Yes','No','1','2b1e3a892bf27674e3bc000d81276e56','boys/','','test__cat2','','','','Boys','','','Boys','','');
SET @catalog_test__cat2 = LAST_INSERT_ID();
INSERT INTO catalog (`parent`,`level`,`priority`,`is_visible`,`list_subcats`,`list_subcats_images`,`url_hash`,`url_default`,`url_custom`,`key_name`,`meta_title`,`meta_description`,`category_header`,`name`,`description`,`description_bottom`,`category_path`,`exactor_euc_code`,`avalara_tax_code`) VALUES ('0','1','5','Yes','No','1','6358643d3170deb870eac89dd1433419','women/','','test__cat3','','','','Women','','','Women','','');
SET @catalog_test__cat3 = LAST_INSERT_ID();
INSERT INTO catalog (`parent`,`level`,`priority`,`is_visible`,`list_subcats`,`list_subcats_images`,`url_hash`,`url_default`,`url_custom`,`key_name`,`meta_title`,`meta_description`,`category_header`,`name`,`description`,`description_bottom`,`category_path`,`exactor_euc_code`,`avalara_tax_code`) VALUES ('0','1','5','Yes','No','1','dcfabe80026cfe905b1d081316c59de4','girls/','','test__cat4','','','','Girls','','','Girls','','');
SET @catalog_test__cat4 = LAST_INSERT_ID();
INSERT INTO manufacturers (`is_visible`,`url_hash`,`url_default`,`url_custom`,`manufacturer_code`,`manufacturer_name`,`image`,`meta_title`,`meta_description`) VALUES ('1','','','','test__mfg1','Great Creations','','','');
SET @man_test__mfg1 = LAST_INSERT_ID();
INSERT INTO manufacturers (`is_visible`,`url_hash`,`url_default`,`url_custom`,`manufacturer_code`,`manufacturer_name`,`image`,`meta_title`,`meta_description`) VALUES ('1','','','','test__mfg2','Made in USA','','','');
SET @man_test__mfg2 = LAST_INSERT_ID();
INSERT INTO products_families (`name`) VALUES ('Product Family Example');
SET @family_1 = LAST_INSERT_ID();
INSERT INTO products (cid,manufacturer_id,`is_visible`,`product_type`,`is_hotdeal`,`is_home`,`is_taxable`,`is_doba`,`is_locked`,`inventory_control`,`inventory_rule`,`stock`,`stock_warning`,`weight`,`free_shipping`,`digital_product`,`digital_product_file`,`price`,`price2`,`price_level_1`,`price_level_2`,`price_level_3`,`shipping_price`,`estimated_shipping_price`,`tax_class_id`,`call_for_price`,`priority`,`attributes_count`,`min_order`,`max_order`,`added`,`rating`,`reviews_count`,`url_hash`,`url_default`,`url_custom`,`product_id`,`product_sku`,`product_upc`,`product_gtin`,`product_mpn`,`gift_quantity`,`dimension_width`,`dimension_length`,`dimension_height`,`image_location`,`image_url`,`image_alt_text`,`title`,`meta_title`,`meta_description`,`overview`,`description`,`lock_fields`,`ebay_cat_id`,`amazon_id`,`amazon_id_type`,`amazon_item_condition`,`google_item_condition`,`google_product_type`,`google_online_only`,`google_availability`,`google_gender`,`google_color`,`google_material`,`google_pattern`,`google_size`,`google_age_group`,`yahoo_path`,`pricegrabber_item_condition`,`pricegrabber_part_number`,`pricegrabber_category`,`nextag_part_number`,`nextag_category`,`nextag_item_condition`,`avalara_tax_code`,`exactor_euc_code`,`enable_recurring_billing`,`recurring_billing_data`) VALUES (@catalog_test__cat2,@man_test__mfg1,'Yes','Tangible','No','Yes','Yes','No','No','No','Hide','0','0','2.00','No','No','','58.00000','0.00000','0.00000','0.00000','0.00000','0.00000','-1.00000','0','No','0','2','1','0','2014-07-04 13:47:00','0.000','0','d5091719a075452851ad8333734c10ef','boys/striped-pull-over/','','test_product01','','','','','0','0.00','0.00','0.00','Local','','','Striped Pull Over','','','','Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a, tellus. Phasellus viverra nulla ut metus varius laoreet. Quisque rutrum. Aenean imperdiet.','','0','','0','11','new','','','','','','','','','','','New','','','','','New','','','0','');
SET @pid = LAST_INSERT_ID();
INSERT INTO products_categories (pid, cid, is_primary) VALUES (@pid,@catalog_test__cat2,1);
INSERT INTO products_attributes (pid,`attribute_type`,`gaid`,`is_modifier`,`is_active`,`priority`,`track_inventory`,`name`,`caption`,`text_length`,`options`) VALUES (@pid,'select','0','No','Yes','5','1','Size','Size','0','XS\r\nS\r\nM\r\nL\r\nXL');
INSERT INTO products_attributes (pid,`attribute_type`,`gaid`,`is_modifier`,`is_active`,`priority`,`track_inventory`,`name`,`caption`,`text_length`,`options`) VALUES (@pid,'select','0','No','Yes','5','1','Color','Color','0','Red\r\nBlack\r\nWhite\r\nBlue\r\nGreen\r\nNavy\r\nMaroon');
INSERT INTO products_families_content (pf_id,pid) VALUES (@family_1,@pid);
INSERT INTO products (cid,manufacturer_id,`is_visible`,`product_type`,`is_hotdeal`,`is_home`,`is_taxable`,`is_doba`,`is_locked`,`inventory_control`,`inventory_rule`,`stock`,`stock_warning`,`weight`,`free_shipping`,`digital_product`,`digital_product_file`,`price`,`price2`,`price_level_1`,`price_level_2`,`price_level_3`,`shipping_price`,`estimated_shipping_price`,`tax_class_id`,`call_for_price`,`priority`,`attributes_count`,`min_order`,`max_order`,`added`,`rating`,`reviews_count`,`url_hash`,`url_default`,`url_custom`,`product_id`,`product_sku`,`product_upc`,`product_gtin`,`product_mpn`,`gift_quantity`,`dimension_width`,`dimension_length`,`dimension_height`,`image_location`,`image_url`,`image_alt_text`,`title`,`meta_title`,`meta_description`,`overview`,`description`,`lock_fields`,`ebay_cat_id`,`amazon_id`,`amazon_id_type`,`amazon_item_condition`,`google_item_condition`,`google_product_type`,`google_online_only`,`google_availability`,`google_gender`,`google_color`,`google_material`,`google_pattern`,`google_size`,`google_age_group`,`yahoo_path`,`pricegrabber_item_condition`,`pricegrabber_part_number`,`pricegrabber_category`,`nextag_part_number`,`nextag_category`,`nextag_item_condition`,`avalara_tax_code`,`exactor_euc_code`,`enable_recurring_billing`,`recurring_billing_data`) VALUES (@catalog_test__cat2,@man_test__mfg2,'Yes','Tangible','No','Yes','Yes','No','No','No','Hide','0','0','2.00','No','No','','42.00000','49.00000','0.00000','0.00000','0.00000','0.00000','-1.00000','0','No','0','2','1','0','2014-07-04 13:47:00','4.000','23','6b2127be674c2ec7f999f7b344351134','boys/cargo-shorts/','','test_product02','','','','','0','0.00','0.00','0.00','Local','','','Cargo Shorts','','','','Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a, tellus. Phasellus viverra nulla ut metus varius laoreet. Quisque rutrum. Aenean imperdiet.','','0','','0','11','new','','','','','','','','','','','New','','','','','New','','','0','');
SET @pid = LAST_INSERT_ID();
INSERT INTO products_categories (pid, cid, is_primary) VALUES (@pid,@catalog_test__cat2,1);
INSERT INTO products_attributes (pid,`attribute_type`,`gaid`,`is_modifier`,`is_active`,`priority`,`track_inventory`,`name`,`caption`,`text_length`,`options`) VALUES (@pid,'select','0','No','Yes','5','1','Size','Size','0','XS\r\nS\r\nM\r\nL\r\nXL');
INSERT INTO products_attributes (pid,`attribute_type`,`gaid`,`is_modifier`,`is_active`,`priority`,`track_inventory`,`name`,`caption`,`text_length`,`options`) VALUES (@pid,'select','0','No','Yes','5','1','Color','Color','0','Red\r\nBlack\r\nWhite\r\nBlue\r\nGreen\r\nNavy\r\nMaroon');
INSERT INTO products_families_content (pf_id,pid) VALUES (@family_1,@pid);
INSERT INTO products (cid,manufacturer_id,`is_visible`,`product_type`,`is_hotdeal`,`is_home`,`is_taxable`,`is_doba`,`is_locked`,`inventory_control`,`inventory_rule`,`stock`,`stock_warning`,`weight`,`free_shipping`,`digital_product`,`digital_product_file`,`price`,`price2`,`price_level_1`,`price_level_2`,`price_level_3`,`shipping_price`,`estimated_shipping_price`,`tax_class_id`,`call_for_price`,`priority`,`attributes_count`,`min_order`,`max_order`,`added`,`rating`,`reviews_count`,`url_hash`,`url_default`,`url_custom`,`product_id`,`product_sku`,`product_upc`,`product_gtin`,`product_mpn`,`gift_quantity`,`dimension_width`,`dimension_length`,`dimension_height`,`image_location`,`image_url`,`image_alt_text`,`title`,`meta_title`,`meta_description`,`overview`,`description`,`lock_fields`,`ebay_cat_id`,`amazon_id`,`amazon_id_type`,`amazon_item_condition`,`google_item_condition`,`google_product_type`,`google_online_only`,`google_availability`,`google_gender`,`google_color`,`google_material`,`google_pattern`,`google_size`,`google_age_group`,`yahoo_path`,`pricegrabber_item_condition`,`pricegrabber_part_number`,`pricegrabber_category`,`nextag_part_number`,`nextag_category`,`nextag_item_condition`,`avalara_tax_code`,`exactor_euc_code`,`enable_recurring_billing`,`recurring_billing_data`) VALUES (@catalog_test__cat2,@man_test__mfg1,'Yes','Tangible','No','No','Yes','No','No','No','Hide','0','0','2.00','No','No','','78.00000','0.00000','0.00000','0.00000','0.00000','0.00000','-1.00000','0','No','0','2','1','0','2014-07-04 13:47:00','3.000','25','23524fb4ac6c9ea521a2966605eb4cfc','boys/button-down-sweater/','','test_product03','','','','','0','0.00','0.00','0.00','Local','','','Button Down Sweater','','','','Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a, tellus. Phasellus viverra nulla ut metus varius laoreet. Quisque rutrum. Aenean imperdiet.','','0','','0','11','new','','','','','','','','','','','New','','','','','New','','','0','');
SET @pid = LAST_INSERT_ID();
INSERT INTO products_categories (pid, cid, is_primary) VALUES (@pid,@catalog_test__cat2,1);
INSERT INTO products_attributes (pid,`attribute_type`,`gaid`,`is_modifier`,`is_active`,`priority`,`track_inventory`,`name`,`caption`,`text_length`,`options`) VALUES (@pid,'select','0','No','Yes','5','1','Size','Size','0','XS\r\nS\r\nM\r\nL\r\nXL');
INSERT INTO products_attributes (pid,`attribute_type`,`gaid`,`is_modifier`,`is_active`,`priority`,`track_inventory`,`name`,`caption`,`text_length`,`options`) VALUES (@pid,'select','0','No','Yes','5','1','Color','Color','0','Red\r\nBlack\r\nWhite\r\nBlue\r\nGreen\r\nNavy\r\nMaroon');
INSERT INTO products_families_content (pf_id,pid) VALUES (@family_1,@pid);
INSERT INTO products (cid,manufacturer_id,`is_visible`,`product_type`,`is_hotdeal`,`is_home`,`is_taxable`,`is_doba`,`is_locked`,`inventory_control`,`inventory_rule`,`stock`,`stock_warning`,`weight`,`free_shipping`,`digital_product`,`digital_product_file`,`price`,`price2`,`price_level_1`,`price_level_2`,`price_level_3`,`shipping_price`,`estimated_shipping_price`,`tax_class_id`,`call_for_price`,`priority`,`attributes_count`,`min_order`,`max_order`,`added`,`rating`,`reviews_count`,`url_hash`,`url_default`,`url_custom`,`product_id`,`product_sku`,`product_upc`,`product_gtin`,`product_mpn`,`gift_quantity`,`dimension_width`,`dimension_length`,`dimension_height`,`image_location`,`image_url`,`image_alt_text`,`title`,`meta_title`,`meta_description`,`overview`,`description`,`lock_fields`,`ebay_cat_id`,`amazon_id`,`amazon_id_type`,`amazon_item_condition`,`google_item_condition`,`google_product_type`,`google_online_only`,`google_availability`,`google_gender`,`google_color`,`google_material`,`google_pattern`,`google_size`,`google_age_group`,`yahoo_path`,`pricegrabber_item_condition`,`pricegrabber_part_number`,`pricegrabber_category`,`nextag_part_number`,`nextag_category`,`nextag_item_condition`,`avalara_tax_code`,`exactor_euc_code`,`enable_recurring_billing`,`recurring_billing_data`) VALUES (@catalog_test__cat4,@man_test__mfg2,'Yes','Tangible','No','No','Yes','No','No','No','Hide','0','0','2.00','No','No','','81.00000','0.00000','0.00000','0.00000','0.00000','0.00000','-1.00000','0','No','0','2','1','0','2014-07-04 13:47:00','5.000','27','7d281b1f60c0c5a617565bf63bc3e46c','girls/summer-dress/','','test_product04','','','','','0','0.00','0.00','0.00','Local','','','Summer Dress','','','','Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a, tellus. Phasellus viverra nulla ut metus varius laoreet. Quisque rutrum. Aenean imperdiet.','','0','','0','11','new','','','','','','','','','','','New','','','','','New','','','0','');
SET @pid = LAST_INSERT_ID();
INSERT INTO products_categories (pid, cid, is_primary) VALUES (@pid,@catalog_test__cat4,1);
INSERT INTO products_attributes (pid,`attribute_type`,`gaid`,`is_modifier`,`is_active`,`priority`,`track_inventory`,`name`,`caption`,`text_length`,`options`) VALUES (@pid,'select','0','No','Yes','5','1','Color','Color','0','Red\r\nBlack\r\nWhite\r\nBlue\r\nGreen\r\nNavy\r\nMaroon');
INSERT INTO products_attributes (pid,`attribute_type`,`gaid`,`is_modifier`,`is_active`,`priority`,`track_inventory`,`name`,`caption`,`text_length`,`options`) VALUES (@pid,'select','0','No','Yes','5','1','Size','Size','0','XS\r\nS\r\nM\r\nL\r\nXL');
INSERT INTO products_families_content (pf_id,pid) VALUES (@family_1,@pid);
INSERT INTO products (cid,manufacturer_id,`is_visible`,`product_type`,`is_hotdeal`,`is_home`,`is_taxable`,`is_doba`,`is_locked`,`inventory_control`,`inventory_rule`,`stock`,`stock_warning`,`weight`,`free_shipping`,`digital_product`,`digital_product_file`,`price`,`price2`,`price_level_1`,`price_level_2`,`price_level_3`,`shipping_price`,`estimated_shipping_price`,`tax_class_id`,`call_for_price`,`priority`,`attributes_count`,`min_order`,`max_order`,`added`,`rating`,`reviews_count`,`url_hash`,`url_default`,`url_custom`,`product_id`,`product_sku`,`product_upc`,`product_gtin`,`product_mpn`,`gift_quantity`,`dimension_width`,`dimension_length`,`dimension_height`,`image_location`,`image_url`,`image_alt_text`,`title`,`meta_title`,`meta_description`,`overview`,`description`,`lock_fields`,`ebay_cat_id`,`amazon_id`,`amazon_id_type`,`amazon_item_condition`,`google_item_condition`,`google_product_type`,`google_online_only`,`google_availability`,`google_gender`,`google_color`,`google_material`,`google_pattern`,`google_size`,`google_age_group`,`yahoo_path`,`pricegrabber_item_condition`,`pricegrabber_part_number`,`pricegrabber_category`,`nextag_part_number`,`nextag_category`,`nextag_item_condition`,`avalara_tax_code`,`exactor_euc_code`,`enable_recurring_billing`,`recurring_billing_data`) VALUES (@catalog_test__cat4,@man_test__mfg1,'Yes','Tangible','Yes','Yes','Yes','No','No','No','Hide','0','0','2.00','No','No','','56.00000','0.00000','0.00000','0.00000','0.00000','0.00000','-1.00000','0','No','0','2','1','0','2014-07-04 13:47:00','4.000','28','ea7f085117ea2c9a08c0ae72f91c1129','girls/hearts-tee/','','test_product05','','','','','0','0.00','0.00','0.00','Local','','','Hearts Tee','','','','Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a, tellus. Phasellus viverra nulla ut metus varius laoreet. Quisque rutrum. Aenean imperdiet.','','0','','0','11','new','','','','','','','','','','','New','','','','','New','','','0','');
SET @pid = LAST_INSERT_ID();
INSERT INTO products_categories (pid, cid, is_primary) VALUES (@pid,@catalog_test__cat4,1);
INSERT INTO products_attributes (pid,`attribute_type`,`gaid`,`is_modifier`,`is_active`,`priority`,`track_inventory`,`name`,`caption`,`text_length`,`options`) VALUES (@pid,'select','0','No','Yes','5','1','Size','Size','0','XS\r\nS\r\nM\r\nL\r\nXL\r\n');
INSERT INTO products_attributes (pid,`attribute_type`,`gaid`,`is_modifier`,`is_active`,`priority`,`track_inventory`,`name`,`caption`,`text_length`,`options`) VALUES (@pid,'select','0','No','Yes','5','1','Color','Color','0','Red\r\nBlack\r\nWhite\r\nBlue\r\nGreen\r\nNavy\r\nMaroon');
INSERT INTO products_families_content (pf_id,pid) VALUES (@family_1,@pid);
INSERT INTO products (cid,manufacturer_id,`is_visible`,`product_type`,`is_hotdeal`,`is_home`,`is_taxable`,`is_doba`,`is_locked`,`inventory_control`,`inventory_rule`,`stock`,`stock_warning`,`weight`,`free_shipping`,`digital_product`,`digital_product_file`,`price`,`price2`,`price_level_1`,`price_level_2`,`price_level_3`,`shipping_price`,`estimated_shipping_price`,`tax_class_id`,`call_for_price`,`priority`,`attributes_count`,`min_order`,`max_order`,`added`,`rating`,`reviews_count`,`url_hash`,`url_default`,`url_custom`,`product_id`,`product_sku`,`product_upc`,`product_gtin`,`product_mpn`,`gift_quantity`,`dimension_width`,`dimension_length`,`dimension_height`,`image_location`,`image_url`,`image_alt_text`,`title`,`meta_title`,`meta_description`,`overview`,`description`,`lock_fields`,`ebay_cat_id`,`amazon_id`,`amazon_id_type`,`amazon_item_condition`,`google_item_condition`,`google_product_type`,`google_online_only`,`google_availability`,`google_gender`,`google_color`,`google_material`,`google_pattern`,`google_size`,`google_age_group`,`yahoo_path`,`pricegrabber_item_condition`,`pricegrabber_part_number`,`pricegrabber_category`,`nextag_part_number`,`nextag_category`,`nextag_item_condition`,`avalara_tax_code`,`exactor_euc_code`,`enable_recurring_billing`,`recurring_billing_data`) VALUES (@catalog_test__cat4,@man_test__mfg2,'Yes','Tangible','No','No','Yes','No','No','No','Hide','0','0','2.00','No','No','','78.00000','0.00000','0.00000','0.00000','0.00000','0.00000','-1.00000','0','No','0','2','1','0','2014-07-04 13:47:00','3.000','23','3ceba3d1cac6467cd5d6f7654f3cabeb','girls/velour-pants/','','test_product06','','','','','0','0.00','0.00','0.00','Local','','','Velour Pants','','','','Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a, tellus. Phasellus viverra nulla ut metus varius laoreet. Quisque rutrum. Aenean imperdiet.','','0','','0','11','new','','','','','','','','','','','New','','','','','New','','','0','');
SET @pid = LAST_INSERT_ID();
INSERT INTO products_categories (pid, cid, is_primary) VALUES (@pid,@catalog_test__cat4,1);
INSERT INTO products_attributes (pid,`attribute_type`,`gaid`,`is_modifier`,`is_active`,`priority`,`track_inventory`,`name`,`caption`,`text_length`,`options`) VALUES (@pid,'select','0','No','Yes','5','1','Color','Color','0','Red\r\nBlack\r\nWhite\r\nBlue\r\nGreen\r\nNavy\r\nMaroon');
INSERT INTO products_attributes (pid,`attribute_type`,`gaid`,`is_modifier`,`is_active`,`priority`,`track_inventory`,`name`,`caption`,`text_length`,`options`) VALUES (@pid,'select','0','No','Yes','5','1','Size','Size','0','XS\r\nS\r\nM\r\nL\r\nXL\r\n');
INSERT INTO products_families_content (pf_id,pid) VALUES (@family_1,@pid);
INSERT INTO products (cid,manufacturer_id,`is_visible`,`product_type`,`is_hotdeal`,`is_home`,`is_taxable`,`is_doba`,`is_locked`,`inventory_control`,`inventory_rule`,`stock`,`stock_warning`,`weight`,`free_shipping`,`digital_product`,`digital_product_file`,`price`,`price2`,`price_level_1`,`price_level_2`,`price_level_3`,`shipping_price`,`estimated_shipping_price`,`tax_class_id`,`call_for_price`,`priority`,`attributes_count`,`min_order`,`max_order`,`added`,`rating`,`reviews_count`,`url_hash`,`url_default`,`url_custom`,`product_id`,`product_sku`,`product_upc`,`product_gtin`,`product_mpn`,`gift_quantity`,`dimension_width`,`dimension_length`,`dimension_height`,`image_location`,`image_url`,`image_alt_text`,`title`,`meta_title`,`meta_description`,`overview`,`description`,`lock_fields`,`ebay_cat_id`,`amazon_id`,`amazon_id_type`,`amazon_item_condition`,`google_item_condition`,`google_product_type`,`google_online_only`,`google_availability`,`google_gender`,`google_color`,`google_material`,`google_pattern`,`google_size`,`google_age_group`,`yahoo_path`,`pricegrabber_item_condition`,`pricegrabber_part_number`,`pricegrabber_category`,`nextag_part_number`,`nextag_category`,`nextag_item_condition`,`avalara_tax_code`,`exactor_euc_code`,`enable_recurring_billing`,`recurring_billing_data`) VALUES (@catalog_test__cat3,@man_test__mfg1,'Yes','Tangible','No','No','Yes','No','No','No','Hide','0','0','2.00','Yes','No','','24.00000','26.00000','0.00000','0.00000','0.00000','0.00000','-1.00000','0','No','0','1','1','0','2014-07-04 13:47:00','5.000','25','9fc95a9e2f7f8d73e0600887431f17f2','women/solid-dress/','','test_product07','','','','','0','0.00','0.00','0.00','Local','','','Solid Dress','','','','Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a, tellus. Phasellus viverra nulla ut metus varius laoreet. Quisque rutrum. Aenean imperdiet.','','0','','0','11','new','','','','','','','','','','','New','','','','','New','','','0','');
SET @pid = LAST_INSERT_ID();
INSERT INTO products_categories (pid, cid, is_primary) VALUES (@pid,@catalog_test__cat3,1);
INSERT INTO products_attributes (pid,`attribute_type`,`gaid`,`is_modifier`,`is_active`,`priority`,`track_inventory`,`name`,`caption`,`text_length`,`options`) VALUES (@pid,'select','0','No','Yes','5','1','Size','Size','0','XS\r\nS\r\nM\r\nL\r\nXL');
INSERT INTO products_families_content (pf_id,pid) VALUES (@family_1,@pid);
INSERT INTO products (cid,manufacturer_id,`is_visible`,`product_type`,`is_hotdeal`,`is_home`,`is_taxable`,`is_doba`,`is_locked`,`inventory_control`,`inventory_rule`,`stock`,`stock_warning`,`weight`,`free_shipping`,`digital_product`,`digital_product_file`,`price`,`price2`,`price_level_1`,`price_level_2`,`price_level_3`,`shipping_price`,`estimated_shipping_price`,`tax_class_id`,`call_for_price`,`priority`,`attributes_count`,`min_order`,`max_order`,`added`,`rating`,`reviews_count`,`url_hash`,`url_default`,`url_custom`,`product_id`,`product_sku`,`product_upc`,`product_gtin`,`product_mpn`,`gift_quantity`,`dimension_width`,`dimension_length`,`dimension_height`,`image_location`,`image_url`,`image_alt_text`,`title`,`meta_title`,`meta_description`,`overview`,`description`,`lock_fields`,`ebay_cat_id`,`amazon_id`,`amazon_id_type`,`amazon_item_condition`,`google_item_condition`,`google_product_type`,`google_online_only`,`google_availability`,`google_gender`,`google_color`,`google_material`,`google_pattern`,`google_size`,`google_age_group`,`yahoo_path`,`pricegrabber_item_condition`,`pricegrabber_part_number`,`pricegrabber_category`,`nextag_part_number`,`nextag_category`,`nextag_item_condition`,`avalara_tax_code`,`exactor_euc_code`,`enable_recurring_billing`,`recurring_billing_data`) VALUES (@catalog_test__cat3,@man_test__mfg2,'Yes','Tangible','Yes','No','Yes','No','No','No','Hide','0','0','2.00','No','No','','299.00000','0.00000','0.00000','0.00000','0.00000','0.00000','-1.00000','0','No','0','2','1','0','2014-07-04 13:47:00','4.000','27','1910615431d87a0febc3ebcb7e71a1fc','women/quarter-sleeve-blazer/','','test_product08','','','','','0','0.00','0.00','0.00','Local','','','Quarter Sleeve Blazer','','','','Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a, tellus. Phasellus viverra nulla ut metus varius laoreet. Quisque rutrum. Aenean imperdiet.','','0','','0','11','new','','','','','','','','','','','New','','','','','New','','','0','');
SET @pid = LAST_INSERT_ID();
INSERT INTO products_categories (pid, cid, is_primary) VALUES (@pid,@catalog_test__cat3,1);
INSERT INTO products_attributes (pid,`attribute_type`,`gaid`,`is_modifier`,`is_active`,`priority`,`track_inventory`,`name`,`caption`,`text_length`,`options`) VALUES (@pid,'select','0','No','Yes','5','1','Size','Size','0','XS\r\nS\r\nM\r\nL\r\nXL');
INSERT INTO products_attributes (pid,`attribute_type`,`gaid`,`is_modifier`,`is_active`,`priority`,`track_inventory`,`name`,`caption`,`text_length`,`options`) VALUES (@pid,'select','0','No','Yes','5','1','Color','Color','0','Red\r\nBlack\r\nWhite\r\nBlue\r\nGreen\r\nNavy\r\nMaroon');
INSERT INTO products_families_content (pf_id,pid) VALUES (@family_1,@pid);
INSERT INTO products (cid,manufacturer_id,`is_visible`,`product_type`,`is_hotdeal`,`is_home`,`is_taxable`,`is_doba`,`is_locked`,`inventory_control`,`inventory_rule`,`stock`,`stock_warning`,`weight`,`free_shipping`,`digital_product`,`digital_product_file`,`price`,`price2`,`price_level_1`,`price_level_2`,`price_level_3`,`shipping_price`,`estimated_shipping_price`,`tax_class_id`,`call_for_price`,`priority`,`attributes_count`,`min_order`,`max_order`,`added`,`rating`,`reviews_count`,`url_hash`,`url_default`,`url_custom`,`product_id`,`product_sku`,`product_upc`,`product_gtin`,`product_mpn`,`gift_quantity`,`dimension_width`,`dimension_length`,`dimension_height`,`image_location`,`image_url`,`image_alt_text`,`title`,`meta_title`,`meta_description`,`overview`,`description`,`lock_fields`,`ebay_cat_id`,`amazon_id`,`amazon_id_type`,`amazon_item_condition`,`google_item_condition`,`google_product_type`,`google_online_only`,`google_availability`,`google_gender`,`google_color`,`google_material`,`google_pattern`,`google_size`,`google_age_group`,`yahoo_path`,`pricegrabber_item_condition`,`pricegrabber_part_number`,`pricegrabber_category`,`nextag_part_number`,`nextag_category`,`nextag_item_condition`,`avalara_tax_code`,`exactor_euc_code`,`enable_recurring_billing`,`recurring_billing_data`) VALUES (@catalog_test__cat3,@man_test__mfg1,'Yes','Tangible','Yes','No','Yes','No','No','No','Hide','0','0','2.00','No','No','','199.00000','0.00000','0.00000','0.00000','0.00000','0.00000','-1.00000','0','No','0','1','1','0','2014-07-04 13:47:00','3.000','28','949904b7b21fdfc695686dab41117b21','women/floral-pants/','','test_product09','','','','','0','0.00','0.00','0.00','Local','','','Floral Pants','','','','Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a, tellus. Phasellus viverra nulla ut metus varius laoreet. Quisque rutrum. Aenean imperdiet.','','0','','0','11','new','','','','','','','','','','','New','','','','','New','','','0','');
SET @pid = LAST_INSERT_ID();
INSERT INTO products_categories (pid, cid, is_primary) VALUES (@pid,@catalog_test__cat3,1);
INSERT INTO products_attributes (pid,`attribute_type`,`gaid`,`is_modifier`,`is_active`,`priority`,`track_inventory`,`name`,`caption`,`text_length`,`options`) VALUES (@pid,'select','0','No','Yes','5','1','size','Size','0','XS\r\nS\r\nM\r\nL\r\nXL');
INSERT INTO products_families_content (pf_id,pid) VALUES (@family_1,@pid);
INSERT INTO products (cid,manufacturer_id,`is_visible`,`product_type`,`is_hotdeal`,`is_home`,`is_taxable`,`is_doba`,`is_locked`,`inventory_control`,`inventory_rule`,`stock`,`stock_warning`,`weight`,`free_shipping`,`digital_product`,`digital_product_file`,`price`,`price2`,`price_level_1`,`price_level_2`,`price_level_3`,`shipping_price`,`estimated_shipping_price`,`tax_class_id`,`call_for_price`,`priority`,`attributes_count`,`min_order`,`max_order`,`added`,`rating`,`reviews_count`,`url_hash`,`url_default`,`url_custom`,`product_id`,`product_sku`,`product_upc`,`product_gtin`,`product_mpn`,`gift_quantity`,`dimension_width`,`dimension_length`,`dimension_height`,`image_location`,`image_url`,`image_alt_text`,`title`,`meta_title`,`meta_description`,`overview`,`description`,`lock_fields`,`ebay_cat_id`,`amazon_id`,`amazon_id_type`,`amazon_item_condition`,`google_item_condition`,`google_product_type`,`google_online_only`,`google_availability`,`google_gender`,`google_color`,`google_material`,`google_pattern`,`google_size`,`google_age_group`,`yahoo_path`,`pricegrabber_item_condition`,`pricegrabber_part_number`,`pricegrabber_category`,`nextag_part_number`,`nextag_category`,`nextag_item_condition`,`avalara_tax_code`,`exactor_euc_code`,`enable_recurring_billing`,`recurring_billing_data`) VALUES (@catalog_test__cat1,@man_test__mfg2,'Yes','Tangible','No','No','Yes','No','No','No','Hide','0','0','2.00','No','No','','34.00000','39.00000','0.00000','0.00000','0.00000','0.00000','-1.00000','0','No','0','2','1','0','2014-07-04 13:47:00','5.000','23','815e9fbe4f07e7a0403debef1d8ec35b','men/skinny-jeans/','','test_product10','','','','','0','0.00','0.00','0.00','Local','','','Skinny Jeans','','','','Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a, tellus. Phasellus viverra nulla ut metus varius laoreet. Quisque rutrum. Aenean imperdiet.','','0','','0','11','new','','','','','','','','','','','New','','','','','New','','','0','');
SET @pid = LAST_INSERT_ID();
INSERT INTO products_categories (pid, cid, is_primary) VALUES (@pid,@catalog_test__cat1,1);
INSERT INTO products_attributes (pid,`attribute_type`,`gaid`,`is_modifier`,`is_active`,`priority`,`track_inventory`,`name`,`caption`,`text_length`,`options`) VALUES (@pid,'select','0','No','Yes','5','1','Size','Size','0','XS\r\nS\r\nM\r\nL\r\nXL');
INSERT INTO products_attributes (pid,`attribute_type`,`gaid`,`is_modifier`,`is_active`,`priority`,`track_inventory`,`name`,`caption`,`text_length`,`options`) VALUES (@pid,'select','0','No','Yes','5','1','Color','Color','0','Red\r\nBlack\r\nWhite\r\nBlue\r\nGreen\r\nNavy\r\nMaroon');
INSERT INTO products (cid,manufacturer_id,`is_visible`,`product_type`,`is_hotdeal`,`is_home`,`is_taxable`,`is_doba`,`is_locked`,`inventory_control`,`inventory_rule`,`stock`,`stock_warning`,`weight`,`free_shipping`,`digital_product`,`digital_product_file`,`price`,`price2`,`price_level_1`,`price_level_2`,`price_level_3`,`shipping_price`,`estimated_shipping_price`,`tax_class_id`,`call_for_price`,`priority`,`attributes_count`,`min_order`,`max_order`,`added`,`rating`,`reviews_count`,`url_hash`,`url_default`,`url_custom`,`product_id`,`product_sku`,`product_upc`,`product_gtin`,`product_mpn`,`gift_quantity`,`dimension_width`,`dimension_length`,`dimension_height`,`image_location`,`image_url`,`image_alt_text`,`title`,`meta_title`,`meta_description`,`overview`,`description`,`lock_fields`,`ebay_cat_id`,`amazon_id`,`amazon_id_type`,`amazon_item_condition`,`google_item_condition`,`google_product_type`,`google_online_only`,`google_availability`,`google_gender`,`google_color`,`google_material`,`google_pattern`,`google_size`,`google_age_group`,`yahoo_path`,`pricegrabber_item_condition`,`pricegrabber_part_number`,`pricegrabber_category`,`nextag_part_number`,`nextag_category`,`nextag_item_condition`,`avalara_tax_code`,`exactor_euc_code`,`enable_recurring_billing`,`recurring_billing_data`) VALUES (@catalog_test__cat1,@man_test__mfg1,'Yes','Tangible','No','No','Yes','No','No','No','Hide','0','0','2.00','No','No','','12.00000','0.00000','0.00000','0.00000','0.00000','0.00000','-1.00000','0','No','0','2','1','0','2014-07-04 13:47:00','4.000','25','de65fee47ef277fae9561ffc21426010','men/plain-tee/','','test_product11','','','','','0','0.00','0.00','0.00','Local','','','Plain Tee','','','','Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a, tellus. Phasellus viverra nulla ut metus varius laoreet. Quisque rutrum. Aenean imperdiet.','','0','','0','11','new','','','','','','','','','','','New','','','','','New','','','0','');
SET @pid = LAST_INSERT_ID();
INSERT INTO products_categories (pid, cid, is_primary) VALUES (@pid,@catalog_test__cat1,1);
INSERT INTO products_attributes (pid,`attribute_type`,`gaid`,`is_modifier`,`is_active`,`priority`,`track_inventory`,`name`,`caption`,`text_length`,`options`) VALUES (@pid,'select','0','No','Yes','5','1','Size','Size','0','XS\r\nS\r\nM\r\nL\r\nXL');
INSERT INTO products_attributes (pid,`attribute_type`,`gaid`,`is_modifier`,`is_active`,`priority`,`track_inventory`,`name`,`caption`,`text_length`,`options`) VALUES (@pid,'select','0','No','Yes','5','1','Color','Color','0','Red\r\nBlack\r\nWhite\r\nBlue\r\nGreen\r\nNavy\r\nMaroon\r\n');
INSERT INTO products (cid,manufacturer_id,`is_visible`,`product_type`,`is_hotdeal`,`is_home`,`is_taxable`,`is_doba`,`is_locked`,`inventory_control`,`inventory_rule`,`stock`,`stock_warning`,`weight`,`free_shipping`,`digital_product`,`digital_product_file`,`price`,`price2`,`price_level_1`,`price_level_2`,`price_level_3`,`shipping_price`,`estimated_shipping_price`,`tax_class_id`,`call_for_price`,`priority`,`attributes_count`,`min_order`,`max_order`,`added`,`rating`,`reviews_count`,`url_hash`,`url_default`,`url_custom`,`product_id`,`product_sku`,`product_upc`,`product_gtin`,`product_mpn`,`gift_quantity`,`dimension_width`,`dimension_length`,`dimension_height`,`image_location`,`image_url`,`image_alt_text`,`title`,`meta_title`,`meta_description`,`overview`,`description`,`lock_fields`,`ebay_cat_id`,`amazon_id`,`amazon_id_type`,`amazon_item_condition`,`google_item_condition`,`google_product_type`,`google_online_only`,`google_availability`,`google_gender`,`google_color`,`google_material`,`google_pattern`,`google_size`,`google_age_group`,`yahoo_path`,`pricegrabber_item_condition`,`pricegrabber_part_number`,`pricegrabber_category`,`nextag_part_number`,`nextag_category`,`nextag_item_condition`,`avalara_tax_code`,`exactor_euc_code`,`enable_recurring_billing`,`recurring_billing_data`) VALUES (@catalog_test__cat1,@man_test__mfg2,'Yes','Tangible','No','No','Yes','No','No','No','Hide','0','0','2.00','No','No','','29.00000','0.00000','0.00000','0.00000','0.00000','0.00000','-1.00000','0','No','0','0','1','0','2014-07-04 13:47:00','3.000','27','fc4409fee7b68ce54e6c1b23085d6403','men/sun-glasses/','','test_product12','','','','','0','0.00','0.00','0.00','Local','','','Sun Glasses','','','','Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, eleifend ac, enim. Aliquam lorem ante, dapibus in, viverra quis, feugiat a, tellus. Phasellus viverra nulla ut metus varius laoreet. Quisque rutrum. Aenean imperdiet.','','0','','0','11','new','','','','','','','','','','','New','','','','','New','','','0','');
SET @pid = LAST_INSERT_ID();
INSERT INTO products_categories (pid, cid, is_primary) VALUES (@pid,@catalog_test__cat1,1);
