REPLACE INTO ?:products (product_id, product_code, product_type, status, company_id, list_price, amount, weight, length, width, height, shipping_freight, low_avail_limit, timestamp, updated_timestamp, usergroup_ids, is_edp, edp_shipping, tracking, free_shipping, zero_price_action, is_pbp, is_op, is_oper, is_returnable, return_period, avail_since, out_of_stock_actions, localization, min_qty, max_qty, qty_step, list_qty_count, tax_ids, age_verification, age_limit, options_type, exceptions_type, details_layout, shipping_params, parent_product_id) VALUES (278, 'TSHIRT1', 'P', 'A', 1, 75.00, 90, 0.000, 0, 0, 0, 0.00, 0, 1504253345, 1504254135, '0', 'N', 'N', 'B', 'N', 'R', 'N', 'N', 'N', 'Y', 10, 0, 'N', '', 0, 0, 0, 0, '', 'N', 0, '', '', 'bigpicture_template', 'a:5:{s:16:\"min_items_in_box\";i:0;s:16:\"max_items_in_box\";i:0;s:10:\"box_length\";i:0;s:9:\"box_width\";i:0;s:10:\"box_height\";i:0;}', 0);
REPLACE INTO ?:products (product_id, product_code, product_type, status, company_id, list_price, amount, weight, length, width, height, shipping_freight, low_avail_limit, timestamp, updated_timestamp, usergroup_ids, is_edp, edp_shipping, tracking, free_shipping, zero_price_action, is_pbp, is_op, is_oper, is_returnable, return_period, avail_since, out_of_stock_actions, localization, min_qty, max_qty, qty_step, list_qty_count, tax_ids, age_verification, age_limit, options_type, exceptions_type, details_layout, shipping_params, parent_product_id) VALUES (279, 'TSHIRT2', 'V', 'A', 1, 75.00, 90, 0.000, 0, 0, 0, 0.00, 0, 1504253345, 1504254020, '0', 'N', 'N', 'B', 'N', 'R', 'N', 'N', 'N', 'Y', 10, 0, 'N', '', 0, 0, 0, 0, '', 'N', 0, '', '', 'bigpicture_template', 'a:5:{s:16:\"min_items_in_box\";i:0;s:16:\"max_items_in_box\";i:0;s:10:\"box_length\";i:0;s:9:\"box_width\";i:0;s:10:\"box_height\";i:0;}', 278);
REPLACE INTO ?:products (product_id, product_code, product_type, status, company_id, list_price, amount, weight, length, width, height, shipping_freight, low_avail_limit, timestamp, updated_timestamp, usergroup_ids, is_edp, edp_shipping, tracking, free_shipping, zero_price_action, is_pbp, is_op, is_oper, is_returnable, return_period, avail_since, out_of_stock_actions, localization, min_qty, max_qty, qty_step, list_qty_count, tax_ids, age_verification, age_limit, options_type, exceptions_type, details_layout, shipping_params, parent_product_id) VALUES (280, 'TSHIRT3', 'P', 'A', 1, 50.00, 90, 0.000, 0, 0, 0, 0.00, 0, 1504253345, 1504254057, '0', 'N', 'N', 'B', 'N', 'R', 'N', 'N', 'N', 'Y', 10, 0, 'N', '', 0, 0, 0, 0, '', 'N', 0, '', '', 'bigpicture_template', 'a:5:{s:16:\"min_items_in_box\";i:0;s:16:\"max_items_in_box\";i:0;s:10:\"box_length\";i:0;s:9:\"box_width\";i:0;s:10:\"box_height\";i:0;}', 0);
REPLACE INTO ?:products (product_id, product_code, product_type, status, company_id, list_price, amount, weight, length, width, height, shipping_freight, low_avail_limit, timestamp, updated_timestamp, usergroup_ids, is_edp, edp_shipping, tracking, free_shipping, zero_price_action, is_pbp, is_op, is_oper, is_returnable, return_period, avail_since, out_of_stock_actions, localization, min_qty, max_qty, qty_step, list_qty_count, tax_ids, age_verification, age_limit, options_type, exceptions_type, details_layout, shipping_params, parent_product_id) VALUES (281, 'TSHIRT4', 'V', 'A', 1, 75.00, 0, 0.000, 0, 0, 0, 0.00, 0, 1504253345, 1504253883, '0', 'N', 'N', 'B', 'N', 'R', 'N', 'N', 'N', 'Y', 10, 0, 'N', '', 0, 0, 0, 0, '', 'N', 0, '', '', 'bigpicture_template', 'a:5:{s:16:\"min_items_in_box\";i:0;s:16:\"max_items_in_box\";i:0;s:10:\"box_length\";i:0;s:9:\"box_width\";i:0;s:10:\"box_height\";i:0;}', 280);
REPLACE INTO ?:products (product_id, product_code, product_type, status, company_id, list_price, amount, weight, length, width, height, shipping_freight, low_avail_limit, timestamp, updated_timestamp, usergroup_ids, is_edp, edp_shipping, tracking, free_shipping, zero_price_action, is_pbp, is_op, is_oper, is_returnable, return_period, avail_since, out_of_stock_actions, localization, min_qty, max_qty, qty_step, list_qty_count, tax_ids, age_verification, age_limit, options_type, exceptions_type, details_layout, shipping_params, parent_product_id) VALUES (282, 'TSHIRT5', 'P', 'A', 1, 75.00, 90, 0.000, 0, 0, 0, 0.00, 0, 1504253345, 1504254102, '0', 'N', 'N', 'B', 'N', 'R', 'N', 'N', 'N', 'Y', 10, 0, 'N', '', 0, 0, 0, 0, '', 'N', 0, '', '', 'bigpicture_template', 'a:5:{s:16:\"min_items_in_box\";i:0;s:16:\"max_items_in_box\";i:0;s:10:\"box_length\";i:0;s:9:\"box_width\";i:0;s:10:\"box_height\";i:0;}', 0);
REPLACE INTO ?:products (product_id, product_code, product_type, status, company_id, list_price, amount, weight, length, width, height, shipping_freight, low_avail_limit, timestamp, updated_timestamp, usergroup_ids, is_edp, edp_shipping, tracking, free_shipping, zero_price_action, is_pbp, is_op, is_oper, is_returnable, return_period, avail_since, out_of_stock_actions, localization, min_qty, max_qty, qty_step, list_qty_count, tax_ids, age_verification, age_limit, options_type, exceptions_type, details_layout, shipping_params, parent_product_id) VALUES (283, 'TSHIRT6', 'V', 'A', 1, 75.00, 0, 0.000, 0, 0, 0, 0.00, 0, 1504253345, 1504254252, '0', 'N', 'N', 'B', 'N', 'R', 'N', 'N', 'N', 'Y', 10, 0, 'N', '', 0, 0, 0, 0, '', 'N', 0, '', '', 'bigpicture_template', 'a:5:{s:16:\"min_items_in_box\";i:0;s:16:\"max_items_in_box\";i:0;s:10:\"box_length\";i:0;s:9:\"box_width\";i:0;s:10:\"box_height\";i:0;}', 282);
REPLACE INTO ?:products (product_id, product_code, product_type, status, company_id, list_price, amount, weight, length, width, height, shipping_freight, low_avail_limit, timestamp, updated_timestamp, usergroup_ids, is_edp, edp_shipping, tracking, free_shipping, zero_price_action, is_pbp, is_op, is_oper, is_returnable, return_period, avail_since, out_of_stock_actions, localization, min_qty, max_qty, qty_step, list_qty_count, tax_ids, age_verification, age_limit, options_type, exceptions_type, details_layout, shipping_params, parent_product_id) VALUES (284, 'TSHIRT7', 'V', 'A', 1, 75.00, 0, 0.000, 0, 0, 0, 0.00, 0, 1504253345, 1504254252, '0', 'N', 'N', 'B', 'N', 'R', 'N', 'N', 'N', 'Y', 10, 0, 'N', '', 0, 0, 0, 0, '', 'N', 0, '', '', 'bigpicture_template', 'a:5:{s:16:\"min_items_in_box\";i:0;s:16:\"max_items_in_box\";i:0;s:10:\"box_length\";i:0;s:9:\"box_width\";i:0;s:10:\"box_height\";i:0;}', 282);

REPLACE INTO ?:product_prices (product_id, price, percentage_discount, lower_limit, usergroup_id) VALUES (278, 30.00, 0, 1, 0);
REPLACE INTO ?:product_prices (product_id, price, percentage_discount, lower_limit, usergroup_id) VALUES (279, 30.00, 0, 1, 0);
REPLACE INTO ?:product_prices (product_id, price, percentage_discount, lower_limit, usergroup_id) VALUES (281, 37.00, 0, 1, 0);
REPLACE INTO ?:product_prices (product_id, price, percentage_discount, lower_limit, usergroup_id) VALUES (280, 36.00, 0, 1, 0);
REPLACE INTO ?:product_prices (product_id, price, percentage_discount, lower_limit, usergroup_id) VALUES (282, 23.99, 0, 10, 0);
REPLACE INTO ?:product_prices (product_id, price, percentage_discount, lower_limit, usergroup_id) VALUES (282, 25.99, 0, 5, 0);
REPLACE INTO ?:product_prices (product_id, price, percentage_discount, lower_limit, usergroup_id) VALUES (282, 27.99, 0, 1, 0);
REPLACE INTO ?:product_prices (product_id, price, percentage_discount, lower_limit, usergroup_id) VALUES (283, 23.99, 0, 10, 0);
REPLACE INTO ?:product_prices (product_id, price, percentage_discount, lower_limit, usergroup_id) VALUES (283, 25.99, 0, 5, 0);
REPLACE INTO ?:product_prices (product_id, price, percentage_discount, lower_limit, usergroup_id) VALUES (283, 27.99, 0, 1, 0);
REPLACE INTO ?:product_prices (product_id, price, percentage_discount, lower_limit, usergroup_id) VALUES (284, 23.99, 0, 10, 0);
REPLACE INTO ?:product_prices (product_id, price, percentage_discount, lower_limit, usergroup_id) VALUES (284, 25.99, 0, 5, 0);
REPLACE INTO ?:product_prices (product_id, price, percentage_discount, lower_limit, usergroup_id) VALUES (284, 27.99, 0, 1, 0);

REPLACE INTO ?:images_links (pair_id, object_id, object_type, image_id, detailed_id, type, position) VALUES(1159, 278, 'product', 0, 1396, 'A', 0);
REPLACE INTO ?:images_links (pair_id, object_id, object_type, image_id, detailed_id, type, position) VALUES(1160, 278, 'product', 0, 1397, 'M', 0);
REPLACE INTO ?:images_links (pair_id, object_id, object_type, image_id, detailed_id, type, position) VALUES(1161, 279, 'product', 0, 1398, 'M', 0);
REPLACE INTO ?:images_links (pair_id, object_id, object_type, image_id, detailed_id, type, position) VALUES(1162, 279, 'product', 0, 1399, 'A', 0);
REPLACE INTO ?:images_links (pair_id, object_id, object_type, image_id, detailed_id, type, position) VALUES(1163, 279, 'product', 0, 1400, 'A', 0);
REPLACE INTO ?:images_links (pair_id, object_id, object_type, image_id, detailed_id, type, position) VALUES(1164, 280, 'product', 0, 1401, 'M', 0);
REPLACE INTO ?:images_links (pair_id, object_id, object_type, image_id, detailed_id, type, position) VALUES(1165, 280, 'product', 0, 1402, 'A', 0);
REPLACE INTO ?:images_links (pair_id, object_id, object_type, image_id, detailed_id, type, position) VALUES(1166, 281, 'product', 0, 1403, 'A', 0);
REPLACE INTO ?:images_links (pair_id, object_id, object_type, image_id, detailed_id, type, position) VALUES(1167, 281, 'product', 0, 1404, 'M', 0);
REPLACE INTO ?:images_links (pair_id, object_id, object_type, image_id, detailed_id, type, position) VALUES(1168, 282, 'product', 0, 1405, 'M', 0);
REPLACE INTO ?:images_links (pair_id, object_id, object_type, image_id, detailed_id, type, position) VALUES(1169, 283, 'product', 0, 1406, 'M', 0);
REPLACE INTO ?:images_links (pair_id, object_id, object_type, image_id, detailed_id, type, position) VALUES(1170, 283, 'product', 0, 1407, 'A', 0);
REPLACE INTO ?:images_links (pair_id, object_id, object_type, image_id, detailed_id, type, position) VALUES(1171, 284, 'product', 0, 1406, 'M', 0);
REPLACE INTO ?:images_links (pair_id, object_id, object_type, image_id, detailed_id, type, position) VALUES(1172, 284, 'product', 0, 1407, 'A', 0);


REPLACE INTO ?:images (image_id, image_path, image_x, image_y) VALUES(1396, 't-13.jpg', 2400, 2838);
REPLACE INTO ?:images (image_id, image_path, image_x, image_y) VALUES(1397, 't-6.jpg', 400, 543);
REPLACE INTO ?:images (image_id, image_path, image_x, image_y) VALUES(1398, 't-3.jpg', 400, 543);
REPLACE INTO ?:images (image_id, image_path, image_x, image_y) VALUES(1399, 't-10.jpg', 1000, 1182);
REPLACE INTO ?:images (image_id, image_path, image_x, image_y) VALUES(1400, 't-11.jpg', 700, 700);
REPLACE INTO ?:images (image_id, image_path, image_x, image_y) VALUES(1401, 't-4.jpg', 2300, 2415);
REPLACE INTO ?:images (image_id, image_path, image_x, image_y) VALUES(1402, 't-12.jpg', 1500, 1500);
REPLACE INTO ?:images (image_id, image_path, image_x, image_y) VALUES(1403, 't-8.jpg', 1500, 1500);
REPLACE INTO ?:images (image_id, image_path, image_x, image_y) VALUES(1404, 't-2.jpg', 2300, 2415);
REPLACE INTO ?:images (image_id, image_path, image_x, image_y) VALUES(1405, 't-7.jpg', 1500, 1500);
REPLACE INTO ?:images (image_id, image_path, image_x, image_y) VALUES(1406, 't-5.jpg', 1500, 1500);
REPLACE INTO ?:images (image_id, image_path, image_x, image_y) VALUES(1407, 't-9.jpg', 700, 700);

REPLACE INTO ?:product_features (feature_id, feature_code, company_id, purpose, feature_style, filter_style, feature_type, categories_path, parent_id, display_on_product, display_on_catalog, display_on_header, status, position, comparison) VALUES (549, '', 1, 'group_catalog_item', 'dropdown_images', 'checkbox', 'S', '', 0, 'Y', 'Y', 'N', 'A', 10, 'Y');
REPLACE INTO ?:product_features (feature_id, feature_code, company_id, purpose, feature_style, filter_style, feature_type, categories_path, parent_id, display_on_product, display_on_catalog, display_on_header, status, position, comparison) VALUES (548, '', 1, 'group_variation_catalog_item', 'dropdown_labels', 'checkbox', 'S', '', 0, 'Y', 'Y', 'N', 'A', 20, 'Y');

REPLACE INTO ?:product_feature_variants (variant_id, feature_id, url, position) VALUES (1193, 548, '', 1);
REPLACE INTO ?:product_feature_variants (variant_id, feature_id, url, position) VALUES (1194, 548, '', 2);
REPLACE INTO ?:product_feature_variants (variant_id, feature_id, url, position) VALUES (1195, 548, '', 3);
REPLACE INTO ?:product_feature_variants (variant_id, feature_id, url, position) VALUES (1196, 548, '', 6);
REPLACE INTO ?:product_feature_variants (variant_id, feature_id, url, position) VALUES (1197, 548, '', 5);

REPLACE INTO ?:product_feature_variants (variant_id, feature_id, url, position) VALUES (1198, 549, '', 1);
REPLACE INTO ?:product_feature_variants (variant_id, feature_id, url, position) VALUES (1199, 549, '', 2);
REPLACE INTO ?:product_feature_variants (variant_id, feature_id, url, position) VALUES (1200, 549, '', 3);
REPLACE INTO ?:product_feature_variants (variant_id, feature_id, url, position) VALUES (1201, 549, '', 4);

REPLACE INTO ?:product_filters (filter_id, categories_path, company_id, feature_id, position, field_type, status, round_to, display_count, display) VALUES (313, '', 1, 549, 0, '', 'A', '0.01', 10, 'Y');
REPLACE INTO ?:product_filters (filter_id, categories_path, company_id, feature_id, position, field_type, status, round_to, display_count, display) VALUES (312, '', 1, 548, 0, '', 'A', '0.01', 10, 'Y');

REPLACE INTO ?:product_variation_groups (id, code, created_at, updated_at) VALUES (10, 'PV-27186628F', 1545294915, 1545294915);

REPLACE INTO ?:product_variation_group_features (feature_id, purpose, group_id) VALUES (548, 'group_variation_catalog_item', 10);
REPLACE INTO ?:product_variation_group_features (feature_id, purpose, group_id) VALUES (549, 'group_catalog_item', 10);

REPLACE INTO ?:product_variation_group_products (product_id, group_id, parent_product_id) VALUES (278, 10, 0);
REPLACE INTO ?:product_variation_group_products (product_id, group_id, parent_product_id) VALUES (279, 10, 278);
REPLACE INTO ?:product_variation_group_products (product_id, group_id, parent_product_id) VALUES (280, 10, 0);
REPLACE INTO ?:product_variation_group_products (product_id, group_id, parent_product_id) VALUES (281, 10, 280);
REPLACE INTO ?:product_variation_group_products (product_id, group_id, parent_product_id) VALUES (282, 10, 0);
REPLACE INTO ?:product_variation_group_products (product_id, group_id, parent_product_id) VALUES (284, 10, 282);
REPLACE INTO ?:product_variation_group_products (product_id, group_id, parent_product_id) VALUES (283, 10, 282);

REPLACE INTO ?:product_popularity (product_id, viewed, added, total) VALUES (280, 10, 5, 55);
REPLACE INTO ?:product_popularity (product_id, viewed, added, total) VALUES (282, 10, 4, 50);
REPLACE INTO ?:product_popularity (product_id, viewed, added, total) VALUES (278, 7, 0, 21);
