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','1','Yes','No','1','bfd5a25543a7674655ad137e44975cc7','shirts/','','test__cat1','','','','Shirts','','','Shirts','','');
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','8dc034be8c44a04ebe2efd232d12bd6d','pants-and-skirts/','','test__cat2','','','','Pants and Skirts','','','Pants and Skirts','','');
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','68eeb2a58efb2421a1eac83a35575865','accessories/','','test__cat4','','','','Accessories','','','Accessories','','');
SET @catalog_test__cat4 = 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','bd0421b827d0e19c88253fb1e9f5e48e','dresses/','','test__cat5','','','','Dresses','','','Dresses','','');
SET @catalog_test__cat5 = 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__cat4,@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','0','1','0','2014-07-04 13:47:30','0.000','0','4dd77652256b262f670089c2cbe34e31','accessories/dg-sunglasses/','','test_product01','','','','','0','0.00','0.00','0.00','Local','','','DG Sunglasses','','','','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_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','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:30','4.000','23','c8fa5d4262efedb02c14dd38aca3252a','shirts/quarter-sleeve-blazer/','','test_product02','','','','','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__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','Black\r\nWhite\r\nBeige');
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','1','1','0','2014-07-04 13:47:30','3.000','25','94354138bac1932e46f03013c3354ef3','pants-and-skirts/beige-high-wasted-skirt/','','test_product03','','','','','0','0.00','0.00','0.00','Local','','','Beige High Wasted Skirt','','','','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','S\r\nM\r\nL\r\nXl\r\nXXL');
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','0','1','0','2014-07-04 13:47:30','5.000','27','2967bea547e5110aaf25295d6947e3ac','accessories/coach-sunglasses-and-bracelet/','','test_product04','','','','','0','0.00','0.00','0.00','Local','','','Coach Sunglasses and Bracelet','','','','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_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__cat5,@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','1','1','0','2014-07-04 13:47:30','4.000','28','6ba0c0bed11b3b3d335b2fada0d0b656','dresses/floral-dress/','','test_product05','','','','','0','0.00','0.00','0.00','Local','','','Floral 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__cat5,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','S\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__cat5,@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','1','1','0','2014-07-04 13:47:30','3.000','23','41d1a2d7a31015ce8ebaf414bdfefb0b','dresses/floral-strapless-dress/','','test_product06','','','','','0','0.00','0.00','0.00','Local','','','Floral Strapless 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__cat5,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','S\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__cat2,@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','0','1','0','2014-07-04 13:47:30','5.000','25','6d07b4de03022a7793ba2064a0f904e6','pants-and-skirts/torn-acid-wash-jeans/','','test_product07','','','','','0','0.00','0.00','0.00','Local','','','Torn Acid Wash 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__cat2,1);
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','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:30','4.000','27','d627e07114e6333704e7989d74b511e8','shirts/cotton-blazer/','','test_product08','','','','','0','0.00','0.00','0.00','Local','','','Cotton 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__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','S\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\nNavy Blue');
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','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','0','1','0','2014-07-04 13:47:30','3.000','28','b8bc9db72229ed436f0325eeb0a558c6','accessories/chanel-sun-glasses/','','test_product09','','','','','0','0.00','0.00','0.00','Local','','','Chanel 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__cat4,1);
INSERT INTO products_families_content (pf_id,pid) VALUES (@family_1,@pid);
INSERT INTO products (cid,`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__cat5,'Yes','Tangible','No','No','Yes','No','No','No','Hide','0','0','0.00','No','No','','35.00000','40.00000','0.00000','0.00000','0.00000','0.00000','-1.00000','0','No','0','2','1','0','0000-00-00 00:00:00','0.000','0','fd9ab7414f3b755fb0c9f40aa309df8b','dresses/business-dress/','','test_product10','','','','','0','0.00','0.00','0.00','Local','','','Business 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','0','','','','','','','','','','','','New','','','','','','','','0','');
SET @pid = LAST_INSERT_ID();
INSERT INTO products_categories (pid, cid, is_primary) VALUES (@pid,@catalog_test__cat5,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','S\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','Black\r\nGreen\r\nWhite\r\nYellow');
