2020-10-22 01:00:01.888 CDT [21017] FATAL:  database "egroves" does not exist
2020-10-22 10:39:02.874 CDT [64535] ERROR:  invalid input syntax for type integer: ""
2020-10-22 10:39:02.874 CDT [64535] STATEMENT:  SELECT customer_p21.customer_id, customer_p21.customer_name, customer_p21.company_id,
												customer_p21.mail_address1, customer_p21.mail_address2, customer_p21.mail_address3,
												customer_p21.mail_city, customer_p21.mail_state, customer_p21.mail_zip,
												customer_p21.sales_rep_id, customer_p21.currency_desc, customer_p21.mail_country,
												customer_web_data.customer_uid, COALESCE(integrations.taker_id,customer_web_data.taker_id) AS taker_id,
												customer_web_data.email_invoices_to, customer_web_data.integrations_customer,
												customer_web_data.ariba_network_id, customer_p21.currency_id,
												customer_web_data.punch_out_enabled, customer_web_data.punch_out_type,
												customer_web_data.hook_url,
												customer_web_data.display_logo_flag, customer_web_data.customer_logo_image,
												crib_info.ship_to_id, crib_info.contract_no, crib_info.sales_location_id, crib_info.source_location_id,
												crib_info.order_pricing_method, crib_info.usage_pricing_method,
												COALESCE(crib_info.contact_id, 1109) AS contact_id,
												crib_info.use_customer_po, customer_p21.legacy_id,
												crib_info.import_file_type, crib_info.confirmation_email_address,
												COALESCE(integrations.taker_email_address, groves_users.email_address) AS taker_email_address,
												crib_info.import_approved
										  FROM customer_p21
										  LEFT JOIN customer_web_data
										  ON customer_p21.customer_id = customer_web_data.customer_id
												AND customer_p21.company_id = customer_web_data.company_id
										  LEFT JOIN integrations
										  ON integrations.customer_id = customer_p21.customer_id
												AND integrations.integration_status = 'ACTIVE'
										  LEFT JOIN crib_info
										  ON crib_info.integration_id = integrations.integration_id
												AND crib_status = 'ACTIVE'
												AND crib_info.delete_flag = 'N'
										  LEFT JOIN groves_users
										  ON groves_users.taker_id = customer_web_data.taker_id
										  WHERE customer_p21.delete_flag = 'N'
										  AND customer_p21.customer_id = $1 
2020-10-22 10:39:02.893 CDT [64535] ERROR:  invalid input syntax for type integer: ""
2020-10-22 10:39:02.893 CDT [64535] STATEMENT:  SELECT source_location_id FROM source_location_overrides where customer_id = $1 and item_id = $2
2020-10-22 10:39:02.915 CDT [64535] ERROR:  invalid input syntax for type integer: ""
2020-10-22 10:39:02.915 CDT [64535] STATEMENT:  INSERT INTO order_header ( username, customer_id, customer_name, customer_po_number, taker_id,
										ship_instructions_1, ship_instructions_2, order_date, email_address, ship_to_name, ship_to_addr1,
										ship_to_addr2, ship_to_city, ship_to_state, ship_to_zip, bill_to_name, bill_to_addr1,
										bill_to_addr2, bill_to_city, bill_to_state, bill_to_zip, status, payment_method, cc_type, cc_owner,
										cc_number, cc_expires_month, cc_expires_year, consignment_replenishment_order, po_order, ship_to_number,
										contact_id, contact_name, contract_id, approved, ship_to_addr3, location_id, shipping_method_id,
										company_id, consignment_usage_order, sales_location_id, source_location_id )
								   VALUES ( $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16,
								   		$17, $18, $19, $20, $21, $22, $23, $24, $25, '\x', '\x', '\x', $26, $27, $28,
								   		$29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39 )
2020-10-22 13:56:39.639 CDT [58071] ERROR:  relation "ariba_cxml_request" does not exist at character 320
2020-10-22 13:56:39.639 CDT [58071] STATEMENT:  UPDATE punchout_cxml_request
	                SET order_id = A.order_id
	                FROM
	                (
	                              SELECT order_header.order_id, TRIM(order_header.customer_po_number) AS customer_po_number
	                              FROM order_header
	                              INNER JOIN ariba_cxml_request
	                              ON TRIM(order_header.customer_po_number) = TRIM(punchout_cxml_request.reference_no)
	                              WHERE request_processed = 'Y'
	                              AND punchout_cxml_request.order_id IS NULL
	                              AND TRIM(order_header.customer_po_number) = 7300003585
	                )A
	                WHERE TRIM(punchout_cxml_request.reference_no) = A.customer_po_number
	                AND punchout_cxml_request.request_processed = 'Y'
	                AND punchout_cxml_request.order_id IS NULL
2020-10-22 14:02:48.334 CDT [61537] ERROR:  operator does not exist: text = bigint at character 661
2020-10-22 14:02:48.334 CDT [61537] HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
2020-10-22 14:02:48.334 CDT [61537] STATEMENT:  UPDATE punchout_cxml_request
	                SET order_id = A.order_id
	                FROM
	                (
	                              SELECT order_header.order_id, TRIM(order_header.customer_po_number) AS customer_po_number
	                              FROM order_header
	                              INNER JOIN punchout_cxml_request
	                              ON TRIM(order_header.customer_po_number) = TRIM(punchout_cxml_request.reference_no)
	                              WHERE request_processed = 'Y'
	                              AND punchout_cxml_request.order_id IS NULL
	                              AND TRIM(order_header.customer_po_number) = 7300003585
	                )A
	                WHERE TRIM(punchout_cxml_request.reference_no) = A.customer_po_number
	                AND punchout_cxml_request.request_processed = 'Y'
	                AND punchout_cxml_request.order_id IS NULL
2020-10-22 21:03:06.024 CDT [4957] LOG:  checkpoints are occurring too frequently (29 seconds apart)
2020-10-22 21:03:06.024 CDT [4957] HINT:  Consider increasing the configuration parameter "max_wal_size".
2020-10-22 22:02:52.896 CDT [53312] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-22 22:02:52.896 CDT [53312] DETAIL:  Key (item_id)=(DEW D28715) already exists.
2020-10-22 22:02:52.896 CDT [53312] STATEMENT:  INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
					manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
					category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
					company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
					benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
					alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
					height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
					category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
					category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
					item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
					item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
					item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
					item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
					item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
					item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
					item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
					brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('DEW D28715', '5164', 'IDW_9581535', 'Black+Decker® D28715', 'D28715', 'Stanley Black & Decker',
					'Black+Decker®', 'Power Tools', 'Cutting & Forming Power Tools', 'Power Saws', 'Chop Saws & Cut-Off Saws',
					'', '', '14" ABRASIVE CHOP SAW', 'CHOP SAW,14 ABR 15A 3800 RPM (OLD# DW871)', 'Black+Decker® Chop Saw, 14 in Dia Blade, 1 in Arbor/Shank, 4000 rpm Speed, Cutting Capacity: 5 in Round, 4-1/2 x 6-1/2 in Rectangular, 45 deg Pivoting Fence Angle, 5-1/2 hp, 15 A, Steel Housing Material, Horizontal D-Handle Handle, 21 in L Dimensions', 'Black+Decker® D28715 Chop Saw With Quick Change™ Keyless Blade Change System, 14 in Dia Blade, 5 in Round, 4-1/2 x 6-1/2 in Rectangular Cutting',
					'Black+Decker D28715 Chop Saw With Quick Change Keyless Blade Change System, 14 in Dia Blade, 5 in Round, 4-1/2 x 6-1/2 in Rectangular Cutting ; Stanley Black Decker ; BlackDecker ; D28715 ; 028877571041 ; Chop Saws & Cut-Off Saws', 'GROVES', 'EA', '173.7500', '304.8200', '45.880000000000',
					'1.0000', '• Exclusive QUICK-FENCE™ is a 45 deg, adjustable fence designed for fast and accurate angle cuts without using a wrench<br>• Ergonomically designed D-handle provides a more comfortable hand position reducing fatigue and increasing productivity<br>• Heavy duty lock down pin allows head of the saw to be locked in the carrying position without the use of a chain<br>• Spindle lock allows user to make wheel changes quickly and easily, saving time and money<br>• Adjustable spark guard allows user to channel sparks<br>• Quick-Change™ blade change system increases productivity by providing the user the ability to change wheels without a wrench<br>• Quick Lock vise allows for fast clamping on different size materials to increase productivity<br>• Extra wide solid steel base provides increased stability when cutting longer material, the four pre-drilled holes in the base allow easy bolt down to any work bench, the solid steel base also allows user to weld jigs or stops directly to the base<br>• Heavy duty compression spring provides smooth movement and greater durability than torsion springs<br>• Large cutting capacity (5 in round, 4-1/2 x 6-1/2 in rectangle) provides the ability to cut a wide variety of materials<br>• Easily accessible brushes allow for convenient servicing on the worksite to minimize downtime', 'Y', '27112709', '', '14" ABRASIVE CHOP SAW', 'bec2f2a8567efece2d146bb27228a62d76491589986e36628a1191d78dc6ebc5',
					'Each', '', '', '028877571041', 'US', '23.38',
					'in', '16.5', 'in', '15.36', 'in', '45.85', 'lb', '',
					'', '3625210000', 'Chop Saws & Cut-Off Saws', '3600000000', '3634000000', '3633120000',
					'3625210000', '', '', 'SAW CHOP BARE TOOL 14IN DIA 1IN 4000RPM', '', '',
					'Black_Decker_D28715.jpg', 'Black_Decker_D28715_DET.jpg', 'Black_Decker_D28715_HR.jpg', 'FILE', '', '',
					'', '', '', '', '',
					'', '', '', '', '', '',
					'', '', '', 'Black_Decker_D28715_Instruction_Sheet.pdf', 'FILE',
					'Instruction/Installation Manual', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', 'Withdrawn from IDW',
					'4196', '8697', '', '', '1AUY9', '2', '2', '304.8200'	)
2020-10-22 22:02:54.429 CDT [53312] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-22 22:02:54.429 CDT [53312] DETAIL:  Key (item_id)=(DEW DW130V) already exists.
2020-10-22 22:02:54.429 CDT [53312] STATEMENT:  INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
					manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
					category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
					company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
					benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
					alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
					height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
					category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
					category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
					item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
					item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
					item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
					item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
					item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
					item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
					item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
					brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('DEW DW130V', '5226', 'IDW_9080929', 'Black+Decker® DW130V', 'DW130V', 'Stanley Black & Decker',
					'Black+Decker®', 'Power Tools', 'Holemaking & Fastening Power Tools', 'Power Drills', 'Electric Drills',
					'', '', '1/2" VSR 550 RPM/REV SPADE HANDLE DRILL', '1/2 VSR 550 rpm/rev SPAD DRILL', 'DeWALT® Spade Handle Drill Kit, Heavy Duty, 1/2 in Chuck, Keyed Chuck, 0 to 550 rpm Speed, 120 VAC, 9 A, Plastic Housing Material, Spade Handle, Black/Silver/Yellow, Variable Speed Reversible Switch Control, 15-1/2 in Overall Length', 'DeWALT® DW130V Heavy Duty Spade Handle Drill Kit, 1/2 in Keyed Chuck, 120 VAC, 0 to 550 rpm Speed, 15-1/2 in OAL',
					'DW130V Corded Reversible Spade Handle Drill, 1/2 in Keyed Chuck, 120 VAC, 0 to 550 rpm Speed, 15-1/2 in OAL ; Stanley Black Decker ; DeWALT ; DW130V ; 028877497372 ; Electric Drills', 'GROVES', 'EA', '158.1600', '277.4700', '8.000000000000',
					'1.0000', '• Variable speed reversible switch reduces air bubbles when mixing mud and offers greater control when drilling<br>• 0 to 550 rpm provides increased torque for drilling and mud mixing<br>• 9 A, 120 VAC motor provides enough power for any jobsite application<br>• 7.5 lb increases user productivity and decreases user fatigue<br>• Soft grip handle for increased comfort<br>• 2-position rear spade handle and 3-position side handle gives greater control for all drilling and mixing applications', 'Y', '27112703', 'The DW130V 1/2 in spade handle drill features variable-speed reversible switch to reduce air bubbles when mixing mud. 120 V motor delivers 0 to 550 rpm to increase torque for drilling and mud mixing. Lightweight and comfortable grip to minimize down time', '1/2" VSR 550 RPM/REV SPADE HANDLE DRILL', '7f7134b9981d99f9a39a7766a11d4c331a888899b078c41ff1b70c79a1f25a01',
					'Each', '', '', '028877497372', 'MX', '10.88',
					'in', '4.88', 'in', '13.06', 'in', '8.7', 'lb', '',
					'', '3625350000', 'Electric Drills', '3600000000', '3636000000', '3635120000',
					'3625350000', '', '', 'DRILL HDL SPADE 1/2IN KEYED 120VAC KIT', '', '',
					'IDW_IMAGE_b10d49159fa2456726eeb5ad17e38db506d7790b6a33ae4ceb44d2668dec1cc6.jpg', 'IDW_IMAGE_b10d49159fa2456726eeb5ad17e38db506d7790b6a33ae4ceb44d2668dec1cc6_DET.jpg', 'IDW_IMAGE_b10d49159fa2456726eeb5ad17e38db506d7790b6a33ae4ceb44d2668dec1cc6_HR.jpg', 'FILE', 'DeWALT_DW130V_1.jpg', 'DeWALT_DW130V_1_DET.jpg',
					'DeWALT_DW130V_1_HR.jpg', 'FILE', 'DeWALT_DW130V.jpg', 'DeWALT_DW130V_DET.jpg', 'DeWALT_DW130V_HR.jpg',
					'FILE', '', '', '', '', '',
					'', '', '', 'DeWALT_DW130V_Technical_Drawing.pdf', 'FILE',
					'Full Engineering Drawing', 'DeWALT_DW130V_Manual.pdf', 'FILE', 'Instruction/Installation Manual', 'DeWALT_DW130V_Installation_Instruction_Sheet.pdf',
					'FILE', 'Instruction/Installation Manual', '', '', '',
					'', '', '', '', 'Active',
					'4196', '6664', '', '', '', '0', '2', '277.4700'	)
2020-10-22 22:02:55.971 CDT [53312] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-22 22:02:55.971 CDT [53312] DETAIL:  Key (item_id)=(DEW DW317K) already exists.
2020-10-22 22:02:55.971 CDT [53312] STATEMENT:  INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
					manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
					category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
					company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
					benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
					alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
					height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
					category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
					category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
					item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
					item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
					item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
					item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
					item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
					item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
					item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
					brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('DEW DW317K', '5260', 'IDW_9105849', 'Black+Decker® DW317K', 'DW317K', 'Stanley Black & Decker',
					'Black+Decker®', 'Power Tools', 'Cutting & Forming Power Tools', 'Power Saws', 'Jig Saws',
					'Electric Jig Saws', '', 'VS COMPACT JIGSAW 5.5A - KEYLESS', 'VS Compact Jigsaw 5.5A - Ke', 'Black+Decker® Jig Saw Kit, Compact Heavy Duty, Kit, Cutting Capacity: 1 in, Bevel Capacity: 45 deg, 1 in Stroke Length, 0 to 3100 spm Strokes per Minute, 120 VAC, 5.5 A, Plastic Housing Material, Top Handle Handle, Corded Cord, Variable Speed Trigger Control, 9-1/4 in Overall Length', 'Black+Decker® DW317K Compact Heavy Duty Jig Saw Kit, 120 VAC, 9-1/4 in OAL',
					'DW317K Compact Electric Jig Saw Kit, 120 VAC, For Blade Shank: U-Shank/T-Shank, 9-1/4 in OAL ; Stanley Black Decker ; DeWALT ; DW317K ; 028877493107 ; Electric Jig Saws', 'GROVES', 'EA', '94.5000', '165.7800', '9.800000000000',
					'1.0000', '• 5.5 A motor deliver powerful cuts in the hardest materials<br>• All metal gear case provides superior durability on a professional site<br>• Keyless, lever action blade clamp for quick and easy blade changes<br>• 4-position orbital action provides control of cut quality and speed<br>• Variable speed delivers 0 to 3100 spm for optimal cutting speed<br>• Shoe bevels 0 to 45 deg for beveled cuts', 'Y', '27112709', 'The DW317K jig saw kit has a powerful 5.5 A motor with variable-speed to deliver up to 3,100 spm. The 4-position orbital action provides faster, more aggressive cuts. A keyless blade clamp makes changing blades quick and easy and bevel detents at 0 and 45 deg help ensure accurate beveling.', 'VS COMPACT JIGSAW 5.5A - KEYLESS', '4f6be1858ed711aa2b42214015892d43f52393c173e0c839ebc77cd83a28b5f1',
					'Each', '', '', '028877493107', 'MX', '12.125',
					'in', '5.625', 'in', '8.75', 'in', '7.4', 'lb', '',
					'', '3625440000', 'Electric Jig Saws', '3600000000', '3634000000', '3633120000',
					'3633121200', '3625440000', '', 'KIT SAW JIG ELEC KIT 120VAC U-SHK/T-SHK', '', '',
					'IDW_IMAGE_d6cb45d1babab6c809265e563c2fd74284baec9e8e618289fbe36e4b775d300a.jpg', 'IDW_IMAGE_d6cb45d1babab6c809265e563c2fd74284baec9e8e618289fbe36e4b775d300a_DET.jpg', 'IDW_IMAGE_d6cb45d1babab6c809265e563c2fd74284baec9e8e618289fbe36e4b775d300a_HR.jpg', 'FILE', 'DeWALT_DW317K_4.jpg', 'DeWALT_DW317K_4_DET.jpg',
					'DeWALT_DW317K_4_HR.jpg', 'FILE', 'DeWALT_DW317K_1.jpg', 'DeWALT_DW317K_1_DET.jpg', 'DeWALT_DW317K_1_HR.jpg',
					'FILE', 'DeWALT_DW317K.jpg', 'DeWALT_DW317K_DET.jpg', 'DeWALT_DW317K_HR.jpg', 'FILE', '',
					'', '', '', 'DeWALT_DW317K_Installation_Instruction_Sheet.pdf', 'FILE',
					'Instruction/Installation Manual', 'DeWALT_DW317K_Manual.pdf', 'FILE', 'Instruction/Installation Manual', 'DeWALT_DW317K_Technical_Drawing.pdf',
					'FILE', 'Full Engineering Drawing', '', '', '',
					'', '', '', '', 'Active',
					'4196', '6664', '', '', '', '0', '2', '165.7800'	)
2020-10-22 22:02:55.994 CDT [53312] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-22 22:02:55.994 CDT [53312] DETAIL:  Key (item_id)=(DEW DW331K) already exists.
2020-10-22 22:02:55.994 CDT [53312] STATEMENT:  INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
					manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
					category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
					company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
					benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
					alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
					height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
					category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
					category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
					item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
					item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
					item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
					item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
					item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
					item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
					item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
					brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('DEW DW331K', '5262', 'IDW_14538951', 'DeWALT® DW331K', 'DW331K', 'Stanley Black & Decker',
					'DeWALT®', 'Power Tools', 'Cutting & Forming Power Tools', 'Power Saws', 'Jig Saws',
					'Electric Jig Saws', '', 'VS PREMIUM JIGSAW 6.5A - KEYLESS', 'VS ORB. ACT. JIGSAW KIT W/KLS BLD CNG 5.8AMP', 'DeWALT® Electric Jig Saw Kit, Kit, Bevel Capacity: 0/15/30/45 deg, 1 in Stroke Length, 500 to 3100 spm Strokes per Minute, 120 VAC, 6.5 A, Metal Housing Material, Extra Large Rubber Grip Handle, Corded Cord, Variable Speed Trigger Control, For Blade Shank Type: T-Shank, 9-1/4 in Overall Length', 'DeWALT® DW331K Electric Jig Saw Kit, 120 VAC, For Blade Shank: T-Shank, 9-1/4 in OAL',
					'Black+Decker DW331K Heavy Duty Jig Saw Kit, 120 VAC, 9-1/4 in OAL ; Stanley Black Decker ; BlackDecker ; DW331K ; 028877452050 ; Electric Jig Saws', 'GROVES', 'EA', '131.7800', '231.1900', '6.400000000000',
					'1.0000', '• Powerful 6.5 A motor delivers the cutting power needed for the most demanding materials<br>• Variable speed delivers 500 to 3100 spm for optimal cutting speed for a variety of applications<br>• Keyless, lever action blade clamp for quick and easy blade changes<br>• All metal gear case and keyless blade lever enhance tool durability in a professional shop environment<br>• 4-position orbital action provides control of cut quality and speed<br>• Positive bevel detents ensure accuracy at the most common angles 0 deg, 15 deg, 30 deg and 45 deg<br>• Extra large rubber grip dampens vibration and provides comfort during prolonged use<br>• Integrated dust blower maintains visibility of cut line<br>• Non-marring plastic shoe cover protects soft or glossy materials from scratches from the shoe<br>• Accepts T-shank blades for optimal holding power and professional results<br>• Counter balance mechanism reduces vibration and user fatigue<br>• Keyless shoe bevel<br>• 6.4 lb tool weight', 'Y', '27112734', 'The DeWALT® has a 6.5 A motor and four position orbital action enabling the DW331K jig saw to make fast cuts through hardwoods, thin gauge metals, plastics and fiberglass. the saw delivers accurate, perpendicular cuts without engaging any additional buttons or blade clamping devices. The XL keyless blade clamp lever is located on the front of the unit where it can be reached with ease and offer quick blade changes for maximized productivity. the shoe bevels to 45 deg and includes a no-mar shoe cover to protect materials from scratching.', 'VS PREMIUM JIGSAW 6.5A - KEYLESS', '66c5bb43e604f0948c9e3c448b787b7b90706c3a6ed2ecb4934d47f390ab2ede',
					'Kit', '', '', '028877452050', 'US', '13.5',
					'in', '4.5', 'in', '14.5', 'in', '11.09', 'lb', '',
					'', '3625440000', 'Electric Jig Saws', '3600000000', '3634000000', '3633120000',
					'3633121200', '3625440000', '', 'KIT SAW JIG KIT 120VAC 9-1/4IN 1IN 6.5A', '', '',
					'IDW_IMAGE_a76316f02951d6c5b9a8484a48d8cab22b65312b3b4e8bf62d808eb46db6f1e1.jpg', 'IDW_IMAGE_a76316f02951d6c5b9a8484a48d8cab22b65312b3b4e8bf62d808eb46db6f1e1_DET.jpg', 'IDW_IMAGE_a76316f02951d6c5b9a8484a48d8cab22b65312b3b4e8bf62d808eb46db6f1e1_HR.jpg', 'FILE', 'Black_Decker_DW331K_2.jpg', 'Black_Decker_DW331K_2_DET.jpg',
					'Black_Decker_DW331K_2_HR.jpg', 'FILE', 'Black_Decker_DW331K_1.jpg', 'Black_Decker_DW331K_1_DET.jpg', 'Black_Decker_DW331K_1_HR.jpg',
					'FILE', 'Black_Decker_DW331K.jpg', 'Black_Decker_DW331K_DET.jpg', 'Black_Decker_DW331K_HR.jpg', 'FILE', '',
					'', '', '', 'Black_Decker_DW331K_Installation.pdf', 'FILE',
					'Instruction/Installation Manual', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', 'Withdrawn from IDW',
					'4196', '8697', '', '', '5TB89', '2', '2', '231.1900'	)
2020-10-22 22:02:56.203 CDT [53312] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-22 22:02:56.203 CDT [53312] DETAIL:  Key (item_id)=(DEW DW4514B5) already exists.
2020-10-22 22:02:56.203 CDT [53312] STATEMENT:  INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
					manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
					category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
					company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
					benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
					alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
					height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
					category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
					category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
					item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
					item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
					item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
					item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
					item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
					item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
					item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
					brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('DEW DW4514B5', '5281', 'IDW_14538909', 'DeWALT® DW4514B5', 'DW4514B5', 'Stanley Black & Decker',
					'DeWALT®', 'Abrasives', 'Cut-Off & Grinding', 'Cut-Off & Grinding Wheels', 'Depressed Center Wheels',
					'', '', '4 1/2"X1/4"X7/8" METAL GRINDING WHEEL 5', '4-1/2 x 1/4 x 7/8 Ge', 'DeWALT® High Performance™ Guaranteed Tough® Depressed Center Grinding Wheel, Flat, 4-1/2 in Wheel Diameter, 1/4 in Wheel, 7/8 in Center Hole, Arbor Connector, 24 Grit, Coarse Grade, Aluminum Oxide Abrasive, Wheel Type Number: Type 27, 13300 rpm Maximum, Resin Bond, Applicable Materials: Stainless Steel, Ferrous and Non-Ferrous Metal, Wheel Hardness: R, Black/Yellow Wheel, Reinforced: Yes, Specifications Met: ANSI Specified', 'DeWALT® High Performance™ Guaranteed Tough® DW4514B5 Flat Depressed Center Grinding Wheel, 4-1/2 in Dia x 1/4 in THK, 7/8 in Center Hole, 24 Grit, Aluminum Oxide Abrasive',
					'HP DW4514B5 Flat Depressed Center Wheel, 4-1/2 in Dia x 1/4 in THK, 7/8 in Center Hole, 24 Grit, Aluminum Oxide Abrasive ; Stanley Black Decker ; DeWALT ; DW4514B5 ; 028877509440 ; Depressed Center Wheels', 'GROVES', 'EA', '5.5900', '9.8100', '6.800000000000',
					'1.0000', '• High performance aluminum oxide grain for long life and high material removal<br>• High grain concentration for aggressive grinding action and smoother running wheels<br>• Proprietary material mix ensures durable long life wheels<br>• 3 full sheets of fiberglass for added durability and safety<br>• Grinding wheels grind and shape a variety of metals and non-ferrous materials', 'Y', '23131503', 'Crafted from high performance aluminum oxide grain for durability and optimal material removal, DeWALT® Type 27 HP™ metal grinding wheels grind and shape a variety of metals and non-ferrous materials. High grain concentration for aggressive grinding action and smooth running wheels.', '4 1/2"X1/4"X7/8" METAL GRINDING WHEEL 5', '99b1d644dfe3763ec0874be7d9a4f1a3ca6ce4c1e78aa2c9834f285b44f500ac',
					'Each', '', '', '028877509440', 'US', '4.5',
					'in', '1.438', 'in', '4.5', 'in', '1.7', 'lb', '',
					'', '1012120000', 'Depressed Center Wheels', '1000000000', '1025000000', '1017200000',
					'1012120000', '', '', 'WHEEL CTR DEPRESSED 4-1/2IN 1/4IN 7/8IN', '', '',
					'DeWALT_DW4514.jpg', 'DeWALT_DW4514_DET.jpg', 'DeWALT_DW4514_HR.jpg', 'FILE', '', '',
					'', '', '', '', '',
					'', '', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', 'High Material Removal and Grinding', 'Withdrawn from IDW',
					'4196', '6664', '', '', '', '0', '2', '9.8100'	)
2020-10-22 22:02:56.243 CDT [53312] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-22 22:02:56.243 CDT [53312] DETAIL:  Key (item_id)=(DEW DW4623) already exists.
2020-10-22 22:02:56.243 CDT [53312] STATEMENT:  INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
					manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
					category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
					company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
					benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
					alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
					height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
					category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
					category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
					item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
					item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
					item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
					item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
					item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
					item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
					item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
					brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('DEW DW4623', '5285', 'IDW_14538911', 'DeWALT® DW4623', 'DW4623', 'Stanley Black & Decker',
					'DeWALT®', 'Abrasives', 'Cut-Off & Grinding', 'Cut-Off & Grinding Wheels', 'Depressed Center Wheels',
					'', '', '5"X1/4"X5/8"-11 METAL GEN PURP GRIND WHL', '5X1/4X5/8-11 TP.27 GRIND WHEEL', 'DeWALT® High Performance™ Guaranteed Tough® Depressed Center Grinding Wheel, Flat, 5 in Wheel Diameter, 1/4 in Wheel, Threaded Arbor Connector, 24 Grit, Coarse Grade, Aluminum Oxide Abrasive, Wheel Type Number: Type 27, 12200 rpm Maximum, Resin Bond, Applicable Materials: Stainless Steel, Ferrous and Non-Ferrous Metal, 5/8-11 Center Hole Thread, Wheel Hardness: R, Black Wheel, Reinforced: Yes, Specifications Met: ANSI Specified', 'DeWALT® High Performance™ Guaranteed Tough® DW4623 Flat Depressed Center Grinding Wheel, 5 in Dia x 1/4 in THK, 24 Grit, Aluminum Oxide Abrasive',
					'HP DW4623 Flat Depressed Center Wheel, 5 in Dia x 1/4 in THK, 24 Grit, Aluminum Oxide Abrasive ; Stanley Black Decker ; DeWALT ; DW4623 ; 028874046238 ; Depressed Center Wheels', 'GROVES', 'EA', '2.5300', '4.4400', '.550000000000',
					'1.0000', '• Tested high performance aluminum oxide grain for long life and high material removal<br>• High grain concentration for aggressive grinding action and smoother running wheels<br>• Proprietary material mix ensures durable long life wheels and to maximize the wheels lifespan and help you minimize tool replacement costs<br>• 3 full sheets of fiberglass for added durability and safety<br>• Grinding wheels grind and shape a variety of metals and non-ferrous materials<br>• High performance metal grinding wheel is a professional solution for a range of grinding applications<br>• With a high grain concentration, you are assured of aggressive grinding action and smoother running wheels, no matter what the job', 'Y', '23131503', '', '5"X1/4"X5/8"-11 METAL GEN PURP GRIND WHL', 'd5ff119c612b0f7955517408518127b82fed66c1756450bb7b82bbf2457be958',
					'Each', '', '', '028874046238', 'CA', '5.0',
					'in', '0.75', 'in', '5.0', 'in', '0.61', 'lb', '',
					'', '1012120000', 'Depressed Center Wheels', '1000000000', '1025000000', '1017200000',
					'1012120000', '', '', 'WHEEL CTR DEPRESSED 5IN 1/4IN THD 24 R', '', '',
					'DeWALT_DW4514.jpg', 'DeWALT_DW4514_DET.jpg', 'DeWALT_DW4514_HR.jpg', 'FILE', '', '',
					'', '', '', '', '',
					'', '', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', 'High Material Removal and Grinding', 'Withdrawn from IDW',
					'4196', '6664', '', '', '', '0', '2', '4.4400'	)
2020-10-22 22:02:56.257 CDT [53312] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-22 22:02:56.257 CDT [53312] DETAIL:  Key (item_id)=(DEW DW4624) already exists.
2020-10-22 22:02:56.257 CDT [53312] STATEMENT:  INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
					manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
					category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
					company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
					benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
					alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
					height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
					category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
					category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
					item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
					item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
					item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
					item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
					item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
					item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
					item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
					brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('DEW DW4624', '5286', 'IDW_8298018', 'DeWALT® DW4624', 'DW4624', 'Stanley Black & Decker',
					'DeWALT®', 'Abrasives', 'Cut-Off & Grinding', 'Cut-Off & Grinding Wheels', 'Depressed Center Wheels',
					'', '', 'GENERAL PURPOSE METAL CUTTING WHEEL', '6 x 1/4 x 7/8 Genera', 'DeWALT® HP™ Depressed Center Wheel, Flat, 6 in Wheel Diameter, 1/4 in Wheel, 7/8 in Center Hole, Arbor Connector, 24 Grit, Very Coarse Grade, Aluminum Oxide Abrasive, Wheel Type Number: Type 27, 10100 rpm Maximum, Resin Bond, Applicable Materials: Stainless Steel and Ferrous Metals, Wheel Hardness: R, Yellow Wheel, Specifications Met: ANSI Specified', 'DeWALT® HP™ DW4624 Flat Depressed Center Wheel, 6 in Dia x 1/4 in THK, 7/8 in Center Hole, 24 Grit, Aluminum Oxide Abrasive',
					'HP DW4624 Flat Depressed Center Wheel, 6 in Dia x 1/4 in THK, 7/8 in Center Hole, 24 Grit, Aluminum Oxide Abrasive ; Stanley Black Decker ; DeWALT ; DW4624 ; 028877321646 ; Depressed Center Wheels', 'GROVES', 'EA', '2.1031', '3.6900', '1.000000000000',
					'1.0000', '• High performance aluminum oxide grain for long life and high material removal<br>• Proprietary material mix ensures durable long life wheels<br>• High grain concentration for aggressive grinding action and smoother running wheels<br>• 3 full sheets of fiberglass for durability and safety', 'Y', '31191600', 'Crafted from high performance aluminum oxide grain for durability and optimal material removal, DeWALT® Type 27 HP™ metal grinding wheels grind and shape a variety of metals and non-ferrous materials. High grain concentration for aggressive grinding action and smooth running wheels.', 'GENERAL PURPOSE METAL CUTTING WHEEL', 'dadcbc213d73e39411ec6210ae69fbe2b869bbaa56d25cb13056e2a24e73c566',
					'Each', '', '', '028877321646', 'CN', '6.0',
					'in', '0.75', 'in', '6.0', 'in', '0.49', 'lb', '',
					'', '1012120000', 'Depressed Center Wheels', '1000000000', '1025000000', '1017200000',
					'1012120000', '', '', 'WHEEL GRINDING CTR DEPRESSED 6IN 1/4IN R', '', '',
					'IDW_IMAGE_010fb4355871f6167441db19c9fb43e7f3344facf6b60f220490b3adad9b1e81.jpg', 'IDW_IMAGE_010fb4355871f6167441db19c9fb43e7f3344facf6b60f220490b3adad9b1e81_DET.jpg', 'IDW_IMAGE_010fb4355871f6167441db19c9fb43e7f3344facf6b60f220490b3adad9b1e81_HR.jpg', 'FILE', 'DeWALT_DW4523.jpg', 'DeWALT_DW4523_DET.jpg',
					'DeWALT_DW4523_HR.jpg', 'FILE', '', '', '',
					'', '', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', 'General Purpose, Heavy Duty Deburring and Blending Applications', 'Active',
					'4196', '6664', '', '', '', '0', '2', '3.6900'	)
2020-10-22 22:02:56.895 CDT [53312] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-22 22:02:56.895 CDT [53312] DETAIL:  Key (item_id)=(DEW DW5816) already exists.
2020-10-22 22:02:56.895 CDT [53312] STATEMENT:  INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
					manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
					category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
					company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
					benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
					alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
					height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
					category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
					category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
					item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
					item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
					item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
					item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
					item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
					item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
					item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
					brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('DEW DW5816', '24363', 'IDW_8275888', 'Black+Decker® DW5816', 'DW5816', 'Stanley Black & Decker',
					'Black+Decker®', 'Cutting Tools & Metalworking', 'Holemaking', 'Drill Bits', 'Masonry Drill Bits',
					'Hammer Drill Bits', '', '7/8" X 16" X 21-1/2" HIGH IMPACT SDS MAX', '', 'DeWALT® Guaranteed Tough® High Impact Carbide™ 4-Cutter Masonry Drill Bit, 4-Cutter, 7/8 in, 21-1/2 in Overall Length, 16 in Cutting Depth, 4 Flutes, Spiral Flute, 16 in Flute Length, 45/64 in Shank, SDS Max® Shank, Rock Carbide® Point, Right Hand Cutting, Carbide Cutting Edge, HSS, Bright, Silver, Applicable Materials: Rock, Concrete and Masonry', 'DeWALT® Guaranteed Tough® High Impact Carbide™ DW5816 4-Cutter 4-Cutter Masonry Drill Bit, 7/8 in Drill Bit, 45/64 in SDS Max® Shank, 16 in D Cutting, Carbide Cutting Edge, 21-1/2 in OAL',
					'HIGH IMPACT CARBIDE DW5816 Hammer Drill Bit, 7/8 in Drill Bit, 45/64 in SDS-Max Shank, 16 in D Cutting, Carbide Cutting Edge, 21-1/2 in OAL ; Stanley Black Decker ; DeWALT ; DW5816 ; 028874058163 ; Hammer Drill Bits', 'GROVES', 'EA', '45.2200', '49.9817', '.000000000000',
					'1.0000', '• Extreme durability: IRON BLAST TECHNOLOGY™ strengthens the bit<br>• Stands up to rebar strikes: Redesigned head geometry to withstand rebar strikes<br>• 2X longer life: Full carbide head in 4 cutter design<br>• Wear mark indicator: for accurate diameter of holes', 'Y', '27112801', 'SDS Max high impact carbide four cutter drill bits are manufactured with IRON BLAST TECHNOLOGY™, a process that strengthens the bit to resist fatigue and results in extreme durability. The redesigned, four cutter carbide head offers 2X longer life and even stands up to rebar strikes. These bits are made in Germany and are GUARANTEED TOUGH® - so tough that we are offering a NO BREAK GUARANTEE. If you have our bits, we have your back.', '7/8" X 16" X 21-1/2" HIGH IMPACT SDS MAX', '95d5c9c4d751dde8675f02456e305f158021c037ea133ea9fba3b7ba77dd5ada',
					'Each', '', '', '028874058163', 'US', '21.5',
					'in', '23.25', 'in', '', '', '8.4', 'lb', '',
					'', '1623360000', 'Hammer Drill Bits', '1600000000', '414100000000', '1623750000',
					'1623751100', '1623360000', '', 'BIT DR MSNRY 7/8IN 45/64IN SDS MAX® 16IN', '', '',
					'IDW_IMAGE_494d4efcd41d4f0d4dd83f7e481e2521ccb8e51fd0b8d42af7a7fc344203d766.jpg', 'IDW_IMAGE_494d4efcd41d4f0d4dd83f7e481e2521ccb8e51fd0b8d42af7a7fc344203d766_DET.jpg', 'IDW_IMAGE_494d4efcd41d4f0d4dd83f7e481e2521ccb8e51fd0b8d42af7a7fc344203d766_HR.jpg', 'FILE', 'DeWALT_DW5806.jpg', 'DeWALT_DW5806_DET.jpg',
					'DeWALT_DW5806_HR.jpg', 'FILE', '', '', '',
					'', '', '', '', '', '',
					'', '', '', 'DeWALT_DW5223_Warranty.pdf', 'FILE',
					'Warranty Information', 'DeWALT_DW5801_Specification_Sheet.pdf', 'FILE', 'Specification Sheet', 'IDW_DOCUMENT_1480738069695.pdf',
					'FILE', 'Catalog', '', '', '',
					'', '', '', 'For all brands of SDS max rotary hammers including DeWALT®, Bosch® and Hilti®', 'Withdrawn from IDW',
					'4196', '8697', '', '', '', '10', '6', '79.3300'	)
2020-10-22 22:02:57.070 CDT [53312] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-22 22:02:57.070 CDT [53312] DETAIL:  Key (item_id)=(DEW DW8002) already exists.
2020-10-22 22:02:57.070 CDT [53312] STATEMENT:  INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
					manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
					category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
					company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
					benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
					alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
					height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
					category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
					category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
					item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
					item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
					item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
					item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
					item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
					item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
					item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
					brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('DEW DW8002', '5331', 'IDW_11941686', 'DeWALT® DW8002', 'DW8002', 'Stanley Black & Decker',
					'DeWALT®', 'Abrasives', 'Cut-Off & Grinding', 'Cut-Off & Grinding Wheels', 'Cut-Off Wheels',
					'', '', '14"X 7/64" X 1"BAR CUTTER CHOPSAW WHEEL', '14X7/64X1 BAR CUTTING CH SAW WHEEL,10/BX', 'DeWALT® HP™ Chop Saw Wheel, Flat, 14 in Wheel Dia, 7/64 in Wheel Thickness, 1 in Center Hole, 24 Grit, Coarse Grade, Aluminum Oxide Abrasive, 4300 rpm Maximum, Resin Bond, Applicable Materials: Ferrous Metals, Wheel Type Number: Type 1, Wheel Hardness: S, For Use With: Chop Saws and Stationary Tools, Yes Reinforced', 'DeWALT® HP™ DW8002 Flat Chop Saw Wheel, 14 in Dia x 7/64 in THK, 1 in Center Hole, 24 Grit, Aluminum Oxide Abrasive',
					'HP DW8002 Flat Chop Saw Wheel, 14 in Dia x 7/64 in THK, 1 in Center Hole, 24 Grit, Aluminum Oxide Abrasive ; Stanley Black Decker ; DeWALT ; DW8002 ; 028874080027 ; Cut-Off Wheels', 'GROVES', 'EA', '4.3900', '7.7000', '.990000000000',
					'1.0000', '• High performance aluminum oxide grain for long life and fast cutting<br>• Proprietary material mix ensures durable long life wheels<br>• High grain concentration for aggressive cutting action and smoother running wheels<br>• 2 full sheets of fiberglass for durability and safety', 'Y', '27112802', '', '14"X 7/64" X 1"BAR CUTTER CHOPSAW WHEEL', 'ebfb8b53d54e24bfdb70a20a32eb2581436260f47acc3b8231b3ea1577140fb7',
					'Each', '', '', '028874080027', 'CA', '14.0',
					'in', '0.109', 'in', '14.0', 'in', '1.2', 'lb', '',
					'', '1012110000', 'Cut-Off Wheels', '1000000000', '1025000000', '1017200000',
					'1012110000', '', '', 'WHEEL SAW CHOP 14IN 7/64IN 1IN 24 AL OXD', '', '',
					'DeWALT_DW8001.jpg', 'DeWALT_DW8001_DET.jpg', 'DeWALT_DW8001_HR.jpg', 'FILE', '', '',
					'', '', '', '', '',
					'', '', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', 'Fabrication Cutting Applications', 'Withdrawn from IDW',
					'4196', '6664', '', '', '', '11', '2', '7.7000'	)
2020-10-22 22:02:57.188 CDT [53312] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-22 22:02:57.188 CDT [53312] DETAIL:  Key (item_id)=(DEW DW8308) already exists.
2020-10-22 22:02:57.188 CDT [53312] STATEMENT:  INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
					manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
					category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
					company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
					benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
					alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
					height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
					category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
					category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
					item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
					item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
					item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
					item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
					item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
					item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
					item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
					brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('DEW DW8308', '5337', 'IDW_11941762', 'DeWALT® DW8308', 'DW8308', 'Stanley Black & Decker',
					'DeWALT®', 'Abrasives', 'Coated Abrasives', 'Coated Abrasive Discs', 'Coated Abrasive Flap Discs',
					'', '', '4-1/2" X 7/8" Z60 T29 FLAP DISC', '4-1/2 x 7/8 60 Grit Zi', 'DeWALT® HP™ Coated Flap Disc, Contaminant-Free Heavy Duty, 4-1/2 in Diameter Disc, 7/8 in Center Hole, 60 Grit, Medium Grade, Zirconia Alumina Abrasive, Type 29 Disc, Fiberglass Backing, 13300 rpm Maximum, Black/Yellow', 'DeWALT® HP™ DW8308 Contaminant-Free Heavy Duty Coated Flap Disc, 4-1/2 in Dia, 7/8 in Center Hole, 60 Grit, Medium Grade, Zirconia Alumina Abrasive, Type 29 Disc',
					'HP DW8308 Contaminant-Free Heavy Duty Coated Flap Disc, 4-1/2 in Dia, 7/8 in Center Hole, 60 Grit, Medium Grade, Zirconia Alumina Abrasive, Type 29 Disc ; Stanley Black Decker ; DeWALT ; DW8308 ; 028877310442 ; Coated Abrasive Flap Discs', 'GROVES', 'EA', '2.3000', '4.0351', '.550000000000',
					'1.0000', '• Zirconia grit enables 3X faster material removal than fiber resin metal sanding discs<br>• Premium abrasive cloth provides up to 15X longer life than fiber resin metal sanding discs<br>• Type 29 fiberglass backing provides grinding angle of 20 to 25 deg', 'Y', '31191506', 'Designed for grinding angles of 20 to 25 deg, DeWALT® Type 29 HP™ flap discs quickly remove material with aggressive grinding action. Featuring zirconia grit, which removes material 3 times fast than fiber resin metal sanding discs, each disc is packed with a premium abrasive cloth that lasts 15 times long than fiber resin metal sanding discs.', '4-1/2" X 7/8" Z60 T29 FLAP DISC', 'b69ac58bda62b1f7035eb46d9e302e5175cafede4fbf764769150fd66d6396af',
					'Each', '', '', '028877310442', 'TR', '4.59',
					'in', '0.45', 'in', '4.59', 'in', '0.231', 'lb', '',
					'', '1010170000', 'Coated Abrasive Flap Discs', '1000000000', '1010000000', '1010280000',
					'1010170000', '', '', 'DISC FLAP 4-1/2IN 7/8IN 36 MDM TYPE 29', '', '',
					'IDW_IMAGE_ad7103212844258884f3233ea457fd5d2aba0e324ef47ebd02a21e4d9ccbd74c.jpg', 'IDW_IMAGE_ad7103212844258884f3233ea457fd5d2aba0e324ef47ebd02a21e4d9ccbd74c_DET.jpg', 'IDW_IMAGE_ad7103212844258884f3233ea457fd5d2aba0e324ef47ebd02a21e4d9ccbd74c_HR.jpg', 'FILE', '', '',
					'', '', '', '', '',
					'', '', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', 'Active',
					'4196', '6664', '', '', '', '5', '2', '4.0351'	)
2020-10-22 22:02:57.230 CDT [53312] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-22 22:02:57.230 CDT [53312] DETAIL:  Key (item_id)=(DEW DW8312) already exists.
2020-10-22 22:02:57.230 CDT [53312] STATEMENT:  INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
					manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
					category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
					company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
					benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
					alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
					height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
					category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
					category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
					item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
					item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
					item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
					item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
					item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
					item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
					item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
					brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('DEW DW8312', '5340', 'IDW_14539072', 'DeWALT® DW8312', 'DW8312', 'Stanley Black & Decker',
					'DeWALT®', 'Abrasives', 'Coated Abrasives', 'Coated Abrasive Discs', 'Coated Abrasive Flap Discs',
					'', '', 'FLAP DISC', '4-1/2X5/8-11 Z60 ZIRC FLAP DISC', 'DeWALT® High Performance™ Flap Disc, Contaminant-Free, 4-1/2 in Diameter Disc, 5/8-11 Center Hole Thread, 60 Grit, Medium Grade, Zirconia Alumina Abrasive, Type 29 Disc, Fiberglass Backing, 13300 rpm Maximum', 'DeWALT® High Performance™ DW8312 Contaminant-Free Flap Disc, 4-1/2 in Dia Disc, 60 Grit, Medium Grade, Zirconia Alumina Abrasive, Type 29 Disc',
					'High Performance DW8312 Contaminant-Free Flap Disc, 4-1/2 in Dia Disc, 60 Grit, Medium Grade, Zirconia Alumina Abrasive, Type 29 Disc ; Stanley Black Decker ; DeWALT ; DW8312 ; 028877310480 ; Coated Abrasive Flap Discs', 'GROVES', 'EA', '2.8200', '4.9500', '.450000000000',
					'1.0000', '• Zirconia grit enables 3X faster material removal than fiber resin metal sanding discs<br>• Premium abrasive cloth provides up to 15X longer life than fiber resin metal sanding discs<br>• Type 29 fiberglass backing provides grinding angle of 20 to 25 deg', 'Y', '31191506', 'Designed for grinding angles of 20 to 25 deg, DeWALT® type 29 hp flap discs quickly remove material with aggressive grinding action. Featuring zirconia grit, which removes material 3 times fast than fiber resin metal sanding discs, each disc is packed with a premium abrasive cloth that lasts 15 times long than fiber resin metal sanding discs.', 'FLAP DISC', '890075a88a04247aa2f226acdc5729e84f4a35f14b0f0a0bb9cd47cc0a319ec2',
					'Each', '', '', '028877310480', 'TR', '4.5',
					'in', '1.187', 'in', '4.5', 'in', '0.339', 'lb', '',
					'', '1010170000', 'Coated Abrasive Flap Discs', '1000000000', '1010000000', '1010280000',
					'1010170000', '', '', 'DISC FLAP CTD 4-1/2IN 5/8-11 60 MDM', '', '',
					'DeWALT_DW8312.jpg', 'DeWALT_DW8312_DET.jpg', 'DeWALT_DW8312_HR.jpg', 'FILE', '', '',
					'', '', '', '', '',
					'', '', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', 'Weld Blending, Removing Weld Slag, Deburring, Surface Finishing and Preparation, Edge Blending and Chamfering', 'Withdrawn from IDW',
					'4196', '6664', '', '', '', '6', '2', '4.9500'	)
2020-10-22 22:02:57.245 CDT [53312] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-22 22:02:57.245 CDT [53312] DETAIL:  Key (item_id)=(DEW DW8313) already exists.
2020-10-22 22:02:57.245 CDT [53312] STATEMENT:  INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
					manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
					category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
					company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
					benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
					alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
					height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
					category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
					category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
					item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
					item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
					item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
					item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
					item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
					item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
					item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
					brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('DEW DW8313', '5341', 'IDW_11941767', 'DeWALT® DW8313', 'DW8313', 'Stanley Black & Decker',
					'DeWALT®', 'Abrasives', 'Coated Abrasives', 'Coated Abrasive Discs', 'Coated Abrasive Flap Discs',
					'', '', 'FLAP DISC', '4-1/2X5/8-11 Z80 ZIRC FLAP DISC', 'DeWALT® HP™ Coated Flap Disc, Contaminant-Free Heavy Duty, 4-1/2 in Diameter Disc, 5/8-11 Center Hole Thread Size, 80 Grit, Medium Grade, Zirconia Alumina Abrasive, Type 29 Disc, Fiberglass Backing, 13300 rpm Maximum, Black/Yellow', 'DeWALT® HP™ DW8313 Contaminant-Free Heavy Duty Coated Flap Disc, 4-1/2 in Dia, 80 Grit, Medium Grade, Zirconia Alumina Abrasive, Type 29 Disc',
					'High Performance DW8313 Contaminant-Free Flap Disc, 4-1/2 in Dia Disc, 80 Grit, Medium Grade, Zirconia Alumina Abrasive, Type 29 Disc ; Stanley Black Decker ; DeWALT ; DW8313 ; 028877310497 ; Coated Abrasive Flap Discs', 'GROVES', 'EA', '2.8200', '4.9500', '.450000000000',
					'1.0000', '• Zirconia grit enables 3X faster material removal than fiber resin metal sanding discs<br>• Premium abrasive cloth provides up to 15X longer life than fiber resin metal sanding discs<br>• Type 29 fiberglass backing provides grinding angle of 20 to 25 deg', 'Y', '31191506', 'Designed for grinding angles of 20 to 25 deg, DeWALT® Type 29 HP™ flap discs quickly remove material with aggressive grinding action. Featuring zirconia grit, which removes material 3 times fast than fiber resin metal sanding discs, each disc is packed with a premium abrasive cloth that lasts 15 times long than fiber resin metal sanding discs.', 'FLAP DISC', '7261b5b7f92f7213619cfa9915de7871c0179312a24785c0056dface1869cdc1',
					'Each', '', '', '028877310497', 'TR', '4.5',
					'in', '1.187', 'in', '4.5', 'in', '0.23', 'lb', '',
					'', '1010170000', 'Coated Abrasive Flap Discs', '1000000000', '1010000000', '1010280000',
					'1010170000', '', '', 'DISC FLAP 4-1/2IN 80 MDM TYPE 29 5/8-11', '', '',
					'IDW_IMAGE_ec6f95b30433ae58bd5af305df463bbe8aac5afa1a60857d9f1250e0d1e9ff04.jpg', 'IDW_IMAGE_ec6f95b30433ae58bd5af305df463bbe8aac5afa1a60857d9f1250e0d1e9ff04_DET.jpg', 'IDW_IMAGE_ec6f95b30433ae58bd5af305df463bbe8aac5afa1a60857d9f1250e0d1e9ff04_HR.jpg', 'FILE', 'IDW_IMAGE_ec6f95b30433ae58bd5af305df463bbe8aac5afa1a60857d9f1250e0d1e9ff04.jpeg', 'IDW_IMAGE_ec6f95b30433ae58bd5af305df463bbe8aac5afa1a60857d9f1250e0d1e9ff04_DET.jpeg',
					'IDW_IMAGE_ec6f95b30433ae58bd5af305df463bbe8aac5afa1a60857d9f1250e0d1e9ff04_HR.jpeg', 'FILE', '', '', '',
					'', '', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', 'Withdrawn from IDW',
					'4196', '6664', '', '', '', '1166', '2', '4.9500'	)
2020-10-22 22:02:57.636 CDT [53312] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-22 22:02:57.636 CDT [53312] DETAIL:  Key (item_id)=(DEW DW9154) already exists.
2020-10-22 22:02:57.636 CDT [53312] STATEMENT:  INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
					manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
					category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
					company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
					benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
					alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
					height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
					category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
					category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
					item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
					item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
					item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
					item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
					item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
					item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
					item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
					brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('DEW DW9154', '5377', 'IDW_14775229', 'DeWALT® DW9154', 'DW9154', 'Stanley Black & Decker',
					'DeWALT®', 'Cutting Tools & Metalworking', 'Saw Blades', 'Circular Saw Blades', '',
					'', '', '6-1/2IN 24TOOTH DEWALT CORDLESS BLADE', 'BLADE,6-1/2 24T FRAMING DW9154', 'DeWALT® Guaranteed Tough® Circular Saw Blade, Cordless Small Diameter, 6-1/2 in Diameter, 0.039 in Thickness, 5/8 in Arbor, ATB Teeth, 24 Teeth, 20 deg Tooth Angle, 7000 rpm Maximum, 2-3/16 in Cutting Depth, 0.059 in Kerf, Carbide Cutting Edge, Carbide Blade, Applicable Materials: Nail Embedded Wood', 'DeWALT® Guaranteed Tough® DW9154 Cordless Small Diameter Circular Saw Blade, 6-1/2 in Dia x 0.039 in THK, 5/8 in Arbor, Carbide Blade, 24 Teeth',
					'Guaranteed Tough DW9154 Cordless Small Diameter Circular Saw Blade, 6-1/2 in Dia x 0.039 in THK, 5/8 in Arbor, Carbide Blade, 24 Teeth ; Stanley Black Decker ; DeWALT ; DW9154 ; 028877311029 ; Circular Saw Blades', 'GROVES', 'EA', '13.2700', '23.2900', '.410000000000',
					'1.0000', '• Tougher tungsten carbide stays sharper longer<br>• Thin kerf for fast and smooth cutting action<br>• All blades feature 5/8 in arbor with diamond knock out<br>• Specially formulated anti-stick coating minimizes friction and gum up for smoother cuts<br>• Ribbed heat vents allow blade to run cooler, reducing blade flexing and binding', 'Y', '27112802', 'Featuring tungsten carbide teeth for maximum durability and a thin kerf for fast, smooth cuts, DeWALT® small diameter Construction™ saw blades power through a variety of building materials with ease. Ribbed heat vents allow blades to run at cooler temperatures, reducing blade flexing and binding. anti-stick coating minimizes friction and gum-up.', '6-1/2IN 24TOOTH DEWALT CORDLESS BLADE', '7a5cf5cf657bef382b5a80748c353514318fe3f156e7833c808a45c919a7c7b5',
					'', '', '', '028877311029', 'US', '',
					'', '', '', '', '', '', '', '',
					'', '3622170000', 'Circular Saw Blades', '1600000000', '1649000000', '3622170000',
					'', '', '', 'BLADE SAW CIRCULAR 6-1/2IN 0.039IN 5/8IN', '', '',
					'DeWALT_DW3161.jpg', 'DeWALT_DW3161_DET.jpg', 'DeWALT_DW3161_HR.jpg', 'FILE', 'DeWALT_DW3161_1.jpg', 'DeWALT_DW3161_1_DET.jpg',
					'DeWALT_DW3161_1_HR.jpg', 'FILE', '', '', '',
					'', '', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', 'For general purpose ripping and cross cutting in wood, finished plywood, prefinished materials and other building materials', 'Withdrawn from IDW',
					'4196', '6664', '', '', '', '0', '2', '23.2900'	)
2020-10-22 22:02:57.651 CDT [53312] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-22 22:02:57.651 CDT [53312] DETAIL:  Key (item_id)=(DEW DW9155) already exists.
2020-10-22 22:02:57.651 CDT [53312] STATEMENT:  INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
					manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
					category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
					company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
					benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
					alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
					height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
					category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
					category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
					item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
					item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
					item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
					item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
					item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
					item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
					item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
					brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('DEW DW9155', '44549', 'IDW_11941778', 'DeWALT® DW9155', 'DW9155', 'Stanley Black & Decker',
					'DeWALT®', 'Cutting Tools & Metalworking', 'Saw Blades', 'Circular Saw Blades', '',
					'', '', '6-1/2IN 18 TOOTH DEWALT CORDLESS BLADE', '', 'DeWALT® Small Diameter Cordless Circular Saw Blade, Small Diameter Cordless, Series: Series 20™, 6-1/2 in Diameter, 0.039 in Thickness, 5/8 in Arbor, Alternate Top Bevel Teeth, 18 Teeth, 20 deg Tooth Angle, 7000 rpm Maximum, 2-3/16 in Cutting Depth, 0.059 in Kerf, Carbide Cutting Edge, Steel Blade, Applicable Materials: Wood', 'DeWALT® DW9155 Series 20™ Small Diameter Cordless Small Diameter Cordless Circular Saw Blade, 6-1/2 in Dia x 0.039 in THK, 5/8 in Arbor, Steel Blade, 18 Teeth',
					'DW9155 Series 20 Small Diameter Cordless Small Diameter Cordless Circular Saw Blade, 6-1/2 in Dia x 0.039 in THK, 5/8 in Arbor, Steel Blade, 18 Teeth ; Stanley Black Decker ; DeWALT ; DW9155 ; 028877311012 ; Circular Saw Blades', 'GROVES', 'EA', '7.2165', '12.6600', '.300000000000',
					'1.0000', '• Tougher tungsten carbide stays sharper longer<br>• Specially formulated anti stick coating minimizes friction and gum-up for smoother cuts<br>• Ribbed heat vents allow blade to run cooler, reducing blade flexing and binding<br>• Thin kerf for fast and smooth cutting action<br>• All blades feature 5/8 in arbor with diamond knock-out<br>• Saw blades power through a variety of building materials with ease', 'Y', '27112802', '', '6-1/2IN 18 TOOTH DEWALT CORDLESS BLADE', '9ea67701563a4e715093e7a81487cac9f1d39d19c9024a016efbfcb2d7062246',
					'Each', '', '', '028877311012', 'CN', '8.75',
					'in', '0.1', 'in', '8.187', 'in', '0.75', 'lb', '',
					'', '3622170000', 'Circular Saw Blades', '1600000000', '1649000000', '3622170000',
					'', '', '', 'BLADE SAW CIRCULAR 6-1/2IN 0.039IN 5/8IN', '', '',
					'DeWALT_DW3174.jpg', 'DeWALT_DW3174_DET.jpg', 'DeWALT_DW3174_HR.jpg', 'FILE', 'DeWALT_DW3174_1.jpg', 'DeWALT_DW3174_1_DET.jpg',
					'DeWALT_DW3174_1_HR.jpg', 'FILE', '', '', '',
					'', '', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', 'Withdrawn from IDW',
					'4196', '6664', '', '', '', '0', '2', '12.6600'	)
2020-10-22 22:02:58.754 CDT [53312] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-22 22:02:58.754 CDT [53312] DETAIL:  Key (item_id)=(DEW DWM120K) already exists.
2020-10-22 22:02:58.754 CDT [53312] STATEMENT:  INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
					manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
					category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
					company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
					benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
					alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
					height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
					category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
					category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
					item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
					item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
					item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
					item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
					item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
					item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
					item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
					brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('DEW DWM120K', '5412', 'IDW_10560199', 'Black+Decker® DWM120K', 'DWM120K', 'Stanley Black & Decker',
					'Black+Decker®', 'Power Tools', 'Cutting & Forming Power Tools', 'Power Saws', 'Portable Band Saws',
					'Electric Portable Band Saws', '', 'HEAVY DUTY VARIABLE SPEED DEEP CUT PORTA', 'Heavy Duty Variable Speed D 10AMP 5 DEEP CUT', 'Black+Decker® Portable Band Saw, Deep Cut Heavy Duty, Kit, Cutting Capacity: 5 x 4-3/4 in, 44.875 x 0.5 x 0.02 in Blade, 100 to 350 fpm Speed, 120 VAC, 10 A, Multi-Position Bale Handle, Corded Cord, 21 in L Dimensions', 'Black+Decker® DWM120K Deep Cut Heavy Duty Portable Band Saw, 5 x 4-3/4 in Cutting, 44.875 x 0.5 x 0.02 in Blade, 120 VAC, 100 to 350 fpm Speed',
					'DWM120K Deep Cut Heavy Duty Portable Band Saw Kit, 5 in Round, 5 x 4-3/4 in Rectangular Cutting, 44.875 x 0.5 x 0.02 in Blade, 120 VAC, 100 to 350 fpm Speed ; Stanley Black Decker ; DeWALT ; DWM120K ; 885911048507 ; Electric Portable Band Saws', 'GROVES', 'EA', '289.5900', '584.2598', '24.400000000000',
					'1.0000', '• Motor designed with power to withstand any jobsite application<br>• Serviceable steel shroud and rubber bumpers allow guards to withstand jobsite abuse without damage<br>• Integrated hang hook allows user to hang the saw without damaging front handle or castings<br>• Multi-position adjustable large front handle offers the user plenty of hand space for a more accurate cut<br>• Blade tracking adjustment increases blade life by providing better blade tracking<br>• Durable and adjustable material guide allows user to adjust for various jobsite materials<br>• Externally replaceable brushes allow for quick repairs on the jobsite<br>• LED sight light allows the user to see cut line in dark jobsite environment<br>• Variable speed dial allows user to vary speed for specific materials and various applications<br>• Superior balance and ergonomics allows for more accurate cuts and less user fatigue<br>• Dual bearing blade guide rollers increase durability in the blade support system<br>• Ergonomic soft grip back handle provides comfort during use<br>• Blade changing lever loosens blade tension to allow for blade change', 'Y', '27112709', '', 'HEAVY DUTY VARIABLE SPEED DEEP CUT PORTA', 'beadc0393a21f3778af68090174493531e8cae3503ddb0dce9ec3c747b772efd',
					'Each', '', '', '885911048507', 'CN', '14.25',
					'in', '7.94', 'in', '23.5', 'in', '23.75', 'lb', '',
					'', '3625540000', 'Electric Portable Band Saws', '3600000000', '3634000000', '3633120000',
					'3633121400', '3625540000', '', 'KIT SAW BAND PORT KIT 120VAC 10A RBR/STL', '', '',
					'IDW_IMAGE_1a8b1ebfef4b64ff68bc5a8ba4a0621985d06d7e94214641a9f8f9cf3149db00.jpg', 'IDW_IMAGE_1a8b1ebfef4b64ff68bc5a8ba4a0621985d06d7e94214641a9f8f9cf3149db00_DET.jpg', 'IDW_IMAGE_1a8b1ebfef4b64ff68bc5a8ba4a0621985d06d7e94214641a9f8f9cf3149db00_HR.jpg', 'FILE', 'DeWALT_DWM120K.jpg', 'DeWALT_DWM120K_DET.jpg',
					'DeWALT_DWM120K_HR.jpg', 'FILE', '', '', '',
					'', '', '', '', '', '',
					'', '', '', 'DeWALT_DWM120_Manual.pdf', 'FILE',
					'Instruction/Installation Manual', 'DeWALT_DWM120_Technical_Drawing.pdf', 'FILE', 'Full Engineering Drawing', '',
					'', '', '', '', '',
					'', '', '', '', 'Active',
					'4196', '6664', '', '', '', '0', '2', '584.2598'	)
2020-10-22 22:03:17.353 CDT [53312] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-22 22:03:17.353 CDT [53312] DETAIL:  Key (item_id)=(DRK 04578) already exists.
2020-10-22 22:03:17.353 CDT [53312] STATEMENT:  INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
					manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
					category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
					company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
					benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
					alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
					height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
					category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
					category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
					item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
					item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
					item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
					item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
					item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
					item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
					item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
					brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('DRK 04578', '5973', 'FS_00202', 'Vanish® 90158', '90158', 'Sealed Air',
					'Vanish®', 'Chemicals', 'Cleaners', 'Bathroom, Tile & Toilet Cleaners', '',
					'', '', 'TOILET BOWL CLEANER', 'VANISH BOWL CLEANER (ACID) 32-OZ., 12/CS  (REPLACED OBSOLETE 90158)', 'Vanish® Bowl and Bathroom Cleaner, Non-Acid, 32 oz Container, Trigger Spray Bottle Container, Liquid Form, Fresh Odor/Scent, Clear Blue, 2% VOC, 6.5 to 7.5 pH, 1 Specific Gravity, Composition: n-Alkyl Dimethyl Benzyl Ammonium Chloride, Isopropyl Alcohol', 'Vanish® 90158 Non-Acid Bowl and Bathroom Cleaner, 32 oz Trigger Spray Bottle, Liquid Form, Fresh Odor/Scent, Clear Blue',
					'90158 Non-Acid Bowl and Bathroom Cleaner, 32 oz Trigger Spray Bottle, Liquid Form, Fresh Odor/Scent, Clear Blue ; Sealed Air ; Vanish ; 90158 ; 15200148 ; 019800901585 ; Bathroom, Tile & Toilet Cleaners', 'GROVES', 'EA', '2.3460', '4.1200', '2.400000000000',
					'1.0000', '• Cleans and disinfects in one step<br>• Powerful quaternary detergent thickened liquid for toilet bowls, urinals and general purpose bathroom cleaning and disinfecting<br>• Bactericidal, virucidal, odor neutralizer and deodorizer', 'Y', '', '', 'TOILET BOWL CLEANER', 'd9f3969abaaeda415fd7848af33cb476a74cc1c65bae48108dd6cfe1e187fdee',
					'', '', '', '', '', '',
					'', '', '', '', '', '', '', '0.0',
					'', '1514160000', 'Bathroom, Tile & Toilet Cleaners', '1500000000', '1514000000', '1514160000',
					'', '', '', 'Toilet Bowl Cleaner', '', '',
					'', '', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', 'Active',
					'4629', '7998', '', '', '', '1', '2', '4.1200'	)
2020-10-22 22:05:06.263 CDT [53312] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-22 22:05:06.263 CDT [53312] DETAIL:  Key (item_id)=(LTH LED P4BM) already exists.
2020-10-22 22:05:06.263 CDT [53312] STATEMENT:  INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
					manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
					category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
					company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
					benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
					alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
					height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
					category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
					category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
					item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
					item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
					item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
					item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
					item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
					item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
					item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
					brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('LTH LED P4BM', '10515', 'GROVES_10515', 'Leatherman® LED P4BM', 'LED P4BM', 'Leatherman Tool Group',
					'Leatherman®', 'Portable Lighting & Flashlights', 'Flashlights', 'Flashlights - Handheld', '',
					'', '', 'LED Flashlight', 'P4 BLUEMOON LL CLIP LIGHT 16 LUMEN, 27 METER', 'P4BM', 'LED Flashlight',
					'Leatherman® LED P4BM; Portable Lighting & Flashlights; Flashlights; Flashlights - Handheld; LED Flashlight', 'GROVES', 'EA', '14.3800', '25.2300', '.150000000000',
					'1.0000', '• The P4BM is super skinny to get into tight places and only weighs about two ounces, so it won’t pull your pockets open.<br>• Blue Moon Focus System', 'Y', '', '', 'LED Flashlight', 'a69dc3b2a8e576b7e981d82b4f04a191e72647122ed2bf1ffa489f2c71b68210',
					'', '', '', '', '', '',
					'', '', '', '', '', '', '', '0.0',
					'', '131211000000', 'Flashlights - Handheld', '490000000000', '1143130000', '131211000000',
					'', '', '', 'LED Flashlight', '', '',
					'GBTHX2MZJEAV.jpg', '', '', 'URL', 'GBTHX2MZJEAW.jpg', '',
					'', 'URL', '', '', '',
					'', '', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', 'Active',
					'4063', '8112', '', '', '', '0', '2', '25.2300'	)
2020-10-22 22:07:24.812 CDT [53312] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-22 22:07:24.812 CDT [53312] DETAIL:  Key (item_id)=(SAF JS1500-38R) already exists.
2020-10-22 22:07:24.812 CDT [53312] STATEMENT:  INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
					manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
					category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
					company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
					benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
					alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
					height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
					category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
					category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
					item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
					item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
					item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
					item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
					item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
					item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
					item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
					brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('SAF JS1500-38R', '18170', 'GROVES_18172', 'Saf-Tech CJS15RB-M', 'CJS15RB-M', 'Saf-Tech',
					'Saf-Tech', 'Safety & Security', 'Personal Protective Equipment (PPE)', 'Clothing', 'Work Clothing',
					'Coveralls & Overalls', '', 'Nomex Coveralls', 'INTL LOGO NOMEX CVRL/ROYAL BLUE-SZ. 38 REG.', 'Saf-Tech CJS15RB-M CJS1500 Contractor Coverall, Medium, Royal Blue, Indura®, 38 to 40 in Chest, 29.5 in L Inseam', 'Saf-Tech CJS15RB-M CJS1500 Contractor Coverall, Medium, Royal Blue, Indura®, 38 to 40 in Chest, 29.5 in L Inseam',
					'Saf-Tech CJS15RB-M; Safety & Security; Personal Protective Equipment (PPE); Clothing; Work Clothing; Coveralls & Overalls; Saf-Tech CJS15RB-M CJS1500 Contractor Coverall, Medium, Royal Blue, Indura®, 38 to 40 in Chest, 29.5 in L Inseam', 'GROVES', 'EA', '75.1200', '131.7900', '2.000000000000',
					'1.0000', '• Lay down collar<br>• A sewn bi-swing back<br>• Elastic waist inserts and hemmed sleeves with snap closures<br>• It has bar tacked reinforcements at the stress points<br>• A 2-way Nomex® brass break away zipper and double stitched reinforcements', 'Y', '', 'Saf-Tech CJS15RB-M CJS1500 Contractor Coverall, Medium, Royal Blue, Indura®, 38 to 40 in Chest, 29.5 in L Inseam', 'Nomex Coveralls', 'f17ddb7d878005ee442cfa51e18f60f79688d96ecac067a24048c439040ee317',
					'', '', '', '', '', '',
					'', '', '', '', '', '', '', '',
					'', '1163111811', 'Coveralls & Overalls', '1100000000', '1163000000', '1163110000',
					'1163111800', '1163111811', '', 'Saf-Tech CJS15RB-M CJS1500 Contractor Coverall, Medium, Royal Blue, Indura®, 38 to 40 in Chest, 29.5 in L Inseam', '', '',
					'GROVES_18172.jpg', 'GROVES_18172_DET.jpg', 'GROVES_18172_HR.jpg', 'FILE', '', '',
					'', '', '', '', '',
					'', '', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', '',
					'', '', '', '', 'Active',
					'4165', '7245', '', '', '', '0', '2', '131.7900'	)
2020-10-22 22:07:56.519 CDT [53312] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-22 22:07:56.519 CDT [53312] DETAIL:  Key (item_id)=(SCA 400012S) already exists.
2020-10-22 22:07:56.519 CDT [53312] STATEMENT:  INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
					manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
					category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
					company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
					benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
					alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
					height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
					category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
					category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
					item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
					item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
					item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
					item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
					item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
					item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
					item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
					brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('SCA 400012S', '18955', 'GROVES_18956', 'TORK® 400012', '400012', 'Svenska Cellulosa Aktiebolaget',
					'TORK®', 'Janitorial & Facility Maintenance', 'Personal Care', 'Hand Cleaners', '',
					'', '', 'Premium Luxury Soft Liquid Soap', 'TORK PREMIUM LIQUID SOAP DELUXE PINK 1 LITER', 'TORK® 400012 Premium Luxury Soft Liquid Soap, 33.82 oz, Purple, Soft Rose', 'TORK® 400012 Premium Luxury Soft Liquid Soap, 33.82 oz, Purple, Soft Rose',
					'400012 Luxury Premium Liquid Soap, 1 L Nominal, Bottle Package, Liquid Form, Pleasant Odor/Scent, Clear Violet ; Svenska Cellulosa Aktiebolaget ; TORK ; 400012 ; 073286625752 ; Liquid Soap', 'GROVES', 'CS', '32.5000', '57.0200', '2.100000000000',
					'1.0000', '• Tork Premium Luxury Soft Liquid Soap has multiple layers of ingredients to insure a superior hand washing.<br>• Hand feel is enhanced by the use of additives like Aloe Vera to prevent dried out hands.<br>• Portion Control - dispenser prevents overuse, dispenses 1 ml every time.<br>• High capacity - the 1-liter bottle allows for 1000 hand washes.<br>• Unique Pump - innovative technology prevents the dispenser from dripping and clogging.<br>• Collapsible refill - 70% less waste.<br>• Sealed system - guaranteed quality plus hygienic! 1 time use pump - extra hygienic!<br>• Refilling done in 1 second - ”load and flow”.', 'Y', '', 'Tork Luxury Soft Liquid Soap has multiple layers of ingredients to insure a superior handwashing. Our new premium formula is gentle on skin but mild enough for frequent hand washing. Suitable for Tork Skincare dispensers for soap and hand sanitizers, with proven easy-to- use design, promote good hand hygiene for all visitors.', 'Premium Luxury Soft Liquid Soap', '90be69f7acab5899ed71e878f03264b50e2482fc1256b66566a6f99a6ff67eaf',
					'1/PK, 6/CT', '', '', '073286625752', '', '11.4',
					'in', '10.8', 'in', '8.3', 'in', '', '', '1036.8',
					'cu-in', '2518340000', 'Liquid Soap', '2500000000', '2518000000', '2518340000',
					'', '', '', 'SOAP LIQ 1 L BTL LIQ PLEASANT CLEAR V', '', '',
					'TORK_400012.jpg', 'TORK_400012_DET.jpg', 'TORK_400012_HR.jpg', 'FILE', '', '',
					'', '', '', '', '',
					'', '', '', '', '', '',
					'', '', '', 'TORK_400012_SDS.pdf', 'FILE',
					'SDS', 'TORK_400012_Specification_Sheet.pdf', 'FILE', 'Specification Sheet', '',
					'', '', '', '', '',
					'', '', '', '', 'Active',
					'4678', '7949', '', '', '', '0', '2', '57.0200'	)
2020-10-22 22:08:25.263 CDT [53312] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-22 22:08:25.263 CDT [53312] DETAIL:  Key (item_id)=(SVK6851120) already exists.
2020-10-22 22:08:25.263 CDT [53312] STATEMENT:  INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
					manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
					category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
					company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
					benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
					alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
					height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
					category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
					category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
					item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
					item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
					item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
					item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
					item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
					item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
					item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
					brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('SVK6851120', '147963', 'UNISDK023308', 'Sandvik Coromant 6851129', '6851129', 'Sandvik Coromant',
					'Sandvik Coromant', 'Cutting Tools & Metalworking', 'Indexable Cutting Tools', 'Indexable Milling', 'Indexable End Mills',
					'Indexable Square-Shoulder End Mills', '', 'RA390-013O13-07L', '', 'Sandvik Coromant Shoulder Milling Cutter, Series: CoroMill® 390, 3/4 in Cutting Dia, 4.3307 in Overall Length, 0.2283 in Maximum Depth of Cut, RA390..Oxx..-07 Insert, 5 Inserts, Insert Compatibility: 390R-07, 3/4 in Shank Dia, Straight Shank, 3.3465 in Shank Length, Right Hand Cutting, ANSI Code: RA390-019O19-07H, ISO Code: RA390-019O19-07H, 90 deg Lead Angle, Yes, Steel', 'Sandvik Coromant 6851129 CoroMill® 390 Shoulder Milling Cutter, ANSI Code: RA390-019O19-07H, 3/4 in Dia Cutting, Straight Shank, RA390..Oxx..-07 Insert, Right Hand Cutting, 90 deg Lead Angle, 0.2283 in Max Depth of Cut',
					'6851129 CoroMill 390 Shoulder Milling Cutter, ANSI Code: RA390-019O19-07H, 3/4 in Dia Cutting, Straight Shank, RA390..Oxx..-07 Insert, Right Hand Cutting, 90 deg Lead Angle, 0.2283 in Max Depth of Cut ; Sandvik Coromant ; 6851129 ; Indexable Square-Shoulder End Mills', 'GROVES', 'EA', '210.2400', '368.8420', '.020000000000',
					'1.0000', '', 'Y', '', 'Your "go to" cutter, the CoroMill® 390 is one tool for a wide variety of component features and materials. Including a wide selection of corner radii and insert sizes for various cutting depth requirements, the reliable CoroMill® 390 can mill almost any shape required. The most versatile CoroMill® shoulder milling cutter is perfect for mixed production.', 'RA390-013O13-07L', '90b851707d80d8f23cf5b755966ca5b77f6fb077d78f96e112834e085620c9b7',
					'1/PK', '', '', '', 'SE', '4.4488',
					'in', '1.3779', 'in', '1.3779', 'in', '0.5467', 'lb', '',
					'', '1633230000', 'Indexable Square-Shoulder End Mills', '1600000000', '1658000000', '1633000000',
					'1633170000', '1633230000', '', 'CUTTER MILLING SHLDR 3/4IN STR RH 90DEG', '', '',
					'Sandvik_6851018.jpg', 'Sandvik_6851018_DET.jpg', 'Sandvik_6851018_HR.jpg', 'FILE', 'Sandvik_6851169_1.jpg', 'Sandvik_6851169_1_DET.jpg',
					'Sandvik_6851169_1_HR.jpg', 'FILE', 'Sandvik_6851018_1.jpg', 'Sandvik_6851018_1_DET.jpg', 'Sandvik_6851018_1_HR.jpg',
					'FILE', 'Sandvik_5745376_2.jpg', 'Sandvik_5745376_2_DET.jpg', 'Sandvik_5745376_2_HR.jpg', 'FILE', '',
					'', '', '', 'Sandvik_5747275_Catalog.pdf', 'FILE',
					'Catalog', '', '', '', '',
					'', '', '', '', '',
					'', '', '', 'Pre-Machining and Finishing', 'Active',
					'5239', '12154', '', '', '', '0', '2', '368.8420'	)
2020-10-22 22:14:50.584 CDT [56862] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-22 22:14:50.584 CDT [56862] DETAIL:  Key (item_id)=(DEW DW8308) already exists.
2020-10-22 22:14:50.584 CDT [56862] STATEMENT:  INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
									category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
									category_name_level_6, company_id, image_name, publish) VALUES ('DEW DW8308', '5337', 'IDW_11941762', 'Abrasives',
									'Coated Abrasives', 'Coated Abrasive Discs', 'Coated Abrasive Flap Discs',
									'', '', 'GROVES', 'IDW_IMAGE_ad7103212844258884f3233ea457fd5d2aba0e324ef47ebd02a21e4d9ccbd74c.jpg', 'Y')
2020-10-22 22:14:50.592 CDT [56862] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-22 22:14:50.592 CDT [56862] DETAIL:  Key (item_id)=(DEW DW8312) already exists.
2020-10-22 22:14:50.592 CDT [56862] STATEMENT:  INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
									category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
									category_name_level_6, company_id, image_name, publish) VALUES ('DEW DW8312', '5340', 'IDW_14539072', 'Abrasives',
									'Coated Abrasives', 'Coated Abrasive Discs', 'Coated Abrasive Flap Discs',
									'', '', 'GROVES', 'IDW_IMAGE_869df552091742a109267360b8ecb7f2ff91044343ab6bdc540b5e152f9e94ca.jpg', 'Y')
2020-10-22 22:14:50.596 CDT [56862] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-22 22:14:50.596 CDT [56862] DETAIL:  Key (item_id)=(DEW DW8313) already exists.
2020-10-22 22:14:50.596 CDT [56862] STATEMENT:  INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
									category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
									category_name_level_6, company_id, image_name, publish) VALUES ('DEW DW8313', '5341', 'IDW_11941767', 'Abrasives',
									'Coated Abrasives', 'Coated Abrasive Discs', 'Coated Abrasive Flap Discs',
									'', '', 'GROVES', 'IDW_IMAGE_ec6f95b30433ae58bd5af305df463bbe8aac5afa1a60857d9f1250e0d1e9ff04.jpg', 'Y')
2020-10-22 22:14:51.836 CDT [56862] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-22 22:14:51.836 CDT [56862] DETAIL:  Key (item_id)=(DEW DW8002) already exists.
2020-10-22 22:14:51.836 CDT [56862] STATEMENT:  INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
									category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
									category_name_level_6, company_id, image_name, publish) VALUES ('DEW DW8002', '5331', 'IDW_11941686', 'Abrasives',
									'Cut-Off & Grinding', 'Cut-Off & Grinding Wheels', 'Cut-Off Wheels',
									'', '', 'GROVES', 'IDW_IMAGE_e41fc1e3425abde3dae2118dba53fafa4fb18f7b6f01312c8bb00aa023c0f62f.jpg', 'Y')
2020-10-22 22:14:52.249 CDT [56862] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-22 22:14:52.249 CDT [56862] DETAIL:  Key (item_id)=(DEW DW4514B5) already exists.
2020-10-22 22:14:52.249 CDT [56862] STATEMENT:  INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
									category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
									category_name_level_6, company_id, image_name, publish) VALUES ('DEW DW4514B5', '5281', 'IDW_14538909', 'Abrasives',
									'Cut-Off & Grinding', 'Cut-Off & Grinding Wheels', 'Depressed Center Wheels',
									'', '', 'GROVES', 'IDW_IMAGE_1320027c998858f1248af955faf3864b2ca1fb4e8749b1cd7d2d3a0f2a7bb408.jpg', 'Y')
2020-10-22 22:14:52.267 CDT [56862] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-22 22:14:52.267 CDT [56862] DETAIL:  Key (item_id)=(DEW DW4623) already exists.
2020-10-22 22:14:52.267 CDT [56862] STATEMENT:  INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
									category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
									category_name_level_6, company_id, image_name, publish) VALUES ('DEW DW4623', '5285', 'IDW_14538911', 'Abrasives',
									'Cut-Off & Grinding', 'Cut-Off & Grinding Wheels', 'Depressed Center Wheels',
									'', '', 'GROVES', 'IDW_IMAGE_0e123f1bc99c04851782e11c13cc98710c7991eec0a4e9af059f4c016dd97d57.jpg', 'Y')
2020-10-22 22:14:52.271 CDT [56862] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-22 22:14:52.271 CDT [56862] DETAIL:  Key (item_id)=(DEW DW4624) already exists.
2020-10-22 22:14:52.271 CDT [56862] STATEMENT:  INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
									category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
									category_name_level_6, company_id, image_name, publish) VALUES ('DEW DW4624', '5286', 'IDW_8298018', 'Abrasives',
									'Cut-Off & Grinding', 'Cut-Off & Grinding Wheels', 'Depressed Center Wheels',
									'', '', 'GROVES', 'IDW_IMAGE_010fb4355871f6167441db19c9fb43e7f3344facf6b60f220490b3adad9b1e81.jpg', 'Y')
2020-10-22 22:14:54.528 CDT [56862] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-22 22:14:54.528 CDT [56862] DETAIL:  Key (item_id)=(DRK 04578) already exists.
2020-10-22 22:14:54.528 CDT [56862] STATEMENT:  INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
									category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
									category_name_level_6, company_id, image_name, publish) VALUES ('DRK 04578', '5973', 'FS_00202', 'Chemicals',
									'Cleaners', 'Bathroom, Tile & Toilet Cleaners', '',
									'', '', 'GROVES', 'Vanish_90158.jpg', 'Y')
2020-10-22 22:14:55.747 CDT [56862] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-22 22:14:55.747 CDT [56862] DETAIL:  Key (item_id)=(DEW DW5816) already exists.
2020-10-22 22:14:55.747 CDT [56862] STATEMENT:  INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
									category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
									category_name_level_6, company_id, image_name, publish) VALUES ('DEW DW5816', '24363', 'IDW_8275888', 'Cutting Tools & Metalworking',
									'Holemaking', 'Drill Bits', 'Masonry Drill Bits',
									'Hammer Drill Bits', '', 'GROVES', 'IDW_IMAGE_d602536e0c393730a7695daca6e5cb2df0ebaf062306640b32d91a95e6ee7ca2.jpg', 'Y')
2020-10-22 22:15:05.092 CDT [56862] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-22 22:15:05.092 CDT [56862] DETAIL:  Key (item_id)=(SVK6851120) already exists.
2020-10-22 22:15:05.092 CDT [56862] STATEMENT:  INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
									category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
									category_name_level_6, company_id, image_name, publish) VALUES ('SVK6851120', '147963', 'UNISDK023308', 'Cutting Tools & Metalworking',
									'Indexable Cutting Tools', 'Indexable Milling', 'Indexable End Mills',
									'Indexable Square-Shoulder End Mills', '', 'GROVES', 'Sandvik_6851018.jpg', 'Y')
2020-10-22 22:15:07.989 CDT [56862] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-22 22:15:07.989 CDT [56862] DETAIL:  Key (item_id)=(DEW DW9154) already exists.
2020-10-22 22:15:07.989 CDT [56862] STATEMENT:  INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
									category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
									category_name_level_6, company_id, image_name, publish) VALUES ('DEW DW9154', '5377', 'IDW_14775229', 'Cutting Tools & Metalworking',
									'Saw Blades', 'Circular Saw Blades', '',
									'', '', 'GROVES', 'DeWALT_DW3174.jpg', 'Y')
2020-10-22 22:15:07.993 CDT [56862] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-22 22:15:07.993 CDT [56862] DETAIL:  Key (item_id)=(DEW DW9155) already exists.
2020-10-22 22:15:07.993 CDT [56862] STATEMENT:  INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
									category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
									category_name_level_6, company_id, image_name, publish) VALUES ('DEW DW9155', '44549', 'IDW_11941778', 'Cutting Tools & Metalworking',
									'Saw Blades', 'Circular Saw Blades', '',
									'', '', 'GROVES', 'DeWALT_DW3174.jpg', 'Y')
2020-10-22 22:15:23.503 CDT [56862] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-22 22:15:23.503 CDT [56862] DETAIL:  Key (item_id)=(SCA 400012S) already exists.
2020-10-22 22:15:23.503 CDT [56862] STATEMENT:  INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
									category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
									category_name_level_6, company_id, image_name, publish) VALUES ('SCA 400012S', '18955', 'GROVES_18956', 'Janitorial & Facility Maintenance',
									'Personal Care', 'Hand Cleaners', '',
									'', '', 'GROVES', 'TORK_400012.jpg', 'Y')
2020-10-22 22:15:29.383 CDT [56862] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-22 22:15:29.383 CDT [56862] DETAIL:  Key (item_id)=(LTH LED P4BM) already exists.
2020-10-22 22:15:29.383 CDT [56862] STATEMENT:  INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
									category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
									category_name_level_6, company_id, image_name, publish) VALUES ('LTH LED P4BM', '10515', 'GROVES_10515', 'Portable Lighting & Flashlights',
									'Flashlights', 'Flashlights - Handheld', '',
									'', '', 'GROVES', 'GROVES_10514.jpg', 'Y')
2020-10-22 22:15:29.679 CDT [56862] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-22 22:15:29.679 CDT [56862] DETAIL:  Key (item_id)=(DEW D28715) already exists.
2020-10-22 22:15:29.679 CDT [56862] STATEMENT:  INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
									category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
									category_name_level_6, company_id, image_name, publish) VALUES ('DEW D28715', '5164', 'IDW_9581535', 'Power Tools',
									'Cutting & Forming Power Tools', 'Power Saws', 'Chop Saws & Cut-Off Saws',
									'', '', 'GROVES', 'IDW_IMAGE_7f51a541786ab0563d59f80b20a7c8995acb56269bc529aae35b39d7a2ec351e.jpg', 'Y')
2020-10-22 22:15:29.726 CDT [56862] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-22 22:15:29.726 CDT [56862] DETAIL:  Key (item_id)=(DEW DW317K) already exists.
2020-10-22 22:15:29.726 CDT [56862] STATEMENT:  INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
									category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
									category_name_level_6, company_id, image_name, publish) VALUES ('DEW DW317K', '5260', 'IDW_9105849', 'Power Tools',
									'Cutting & Forming Power Tools', 'Power Saws', 'Jig Saws',
									'Electric Jig Saws', '', 'GROVES', 'IDW_IMAGE_d6cb45d1babab6c809265e563c2fd74284baec9e8e618289fbe36e4b775d300a.jpg', 'Y')
2020-10-22 22:15:29.730 CDT [56862] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-22 22:15:29.730 CDT [56862] DETAIL:  Key (item_id)=(DEW DW331K) already exists.
2020-10-22 22:15:29.730 CDT [56862] STATEMENT:  INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
									category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
									category_name_level_6, company_id, image_name, publish) VALUES ('DEW DW331K', '5262', 'IDW_14538951', 'Power Tools',
									'Cutting & Forming Power Tools', 'Power Saws', 'Jig Saws',
									'Electric Jig Saws', '', 'GROVES', 'IDW_IMAGE_a76316f02951d6c5b9a8484a48d8cab22b65312b3b4e8bf62d808eb46db6f1e1.jpg', 'Y')
2020-10-22 22:15:29.757 CDT [56862] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-22 22:15:29.757 CDT [56862] DETAIL:  Key (item_id)=(DEW DWM120K) already exists.
2020-10-22 22:15:29.757 CDT [56862] STATEMENT:  INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
									category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
									category_name_level_6, company_id, image_name, publish) VALUES ('DEW DWM120K', '5412', 'IDW_10560199', 'Power Tools',
									'Cutting & Forming Power Tools', 'Power Saws', 'Portable Band Saws',
									'Electric Portable Band Saws', '', 'GROVES', 'IDW_IMAGE_1a8b1ebfef4b64ff68bc5a8ba4a0621985d06d7e94214641a9f8f9cf3149db00.jpg', 'Y')
2020-10-22 22:15:29.944 CDT [56862] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-22 22:15:29.944 CDT [56862] DETAIL:  Key (item_id)=(DEW DW130V) already exists.
2020-10-22 22:15:29.944 CDT [56862] STATEMENT:  INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
									category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
									category_name_level_6, company_id, image_name, publish) VALUES ('DEW DW130V', '5226', 'IDW_9080929', 'Power Tools',
									'Holemaking & Fastening Power Tools', 'Power Drills', 'Electric Drills',
									'', '', 'GROVES', 'IDW_IMAGE_b10d49159fa2456726eeb5ad17e38db506d7790b6a33ae4ceb44d2668dec1cc6.jpg', 'Y')
2020-10-22 22:15:33.951 CDT [56862] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-22 22:15:33.951 CDT [56862] DETAIL:  Key (item_id)=(SAF JS1500-38R) already exists.
2020-10-22 22:15:33.951 CDT [56862] STATEMENT:  INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
									category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
									category_name_level_6, company_id, image_name, publish) VALUES ('SAF JS1500-38R', '18170', 'GROVES_18172', 'Safety & Security',
									'Personal Protective Equipment (PPE)', 'Clothing', 'Work Clothing',
									'Coveralls & Overalls', '', 'GROVES', 'GROVES_18172.jpg', 'Y')
2020-10-22 22:21:31.352 CDT [57160] ERROR:  missing FROM-clause entry for table "temp_item_specs" at character 344
2020-10-22 22:21:31.352 CDT [57160] STATEMENT:  update item_specs
						set number_value = A.number_value
						from
						(
							SELECT item_id, spec_name, spec_value, spec_uom,
								CASE WHEN isnumeric(REPLACE(REPLACE(item_specs.spec_value, '-', ''), '/', '')) = TRUE THEN
									CASE WHEN item_specs.spec_value LIKE '%/%' THEN
										CASE WHEN item_specs.spec_value NOT LIKE '%-%' AND temp_item_specs.spec_value NOT LIKE '%/0%' 
											AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '/', '' ))) / length( '/' ) = 1 THEN
											fraction_to_decimal(item_specs.spec_value)::REAL
										 WHEN item_specs.spec_value NOT LIKE '%/%-%' AND temp_item_specs.spec_value NOT LIKE '%/0%' 
											AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '-', '' ))) / length( '-' ) = 1
											AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '/', '' ))) / length( '/' ) = 1 THEN
											fraction_to_decimal(item_specs.spec_value)::REAL
										ELSE NULL
										END
									ELSE
										CASE WHEN item_specs.spec_value NOT LIKE '%-%' THEN
											item_specs.spec_value::REAL
										ELSE NULL
										END
									END
								ELSE NULL
								END as number_value
							FROM public.item_specs
							where number_value is null
							and CASE WHEN isnumeric(REPLACE(REPLACE(item_specs.spec_value, '-', ''), '/', '')) = TRUE THEN
									CASE WHEN item_specs.spec_value LIKE '%/%' THEN
										CASE WHEN item_specs.spec_value NOT LIKE '%-%' AND temp_item_specs.spec_value NOT LIKE '%/0%' 
											AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '/', '' ))) / length( '/' ) = 1 THEN
											fraction_to_decimal(item_specs.spec_value)::REAL
										 WHEN item_specs.spec_value NOT LIKE '%/%-%' AND temp_item_specs.spec_value NOT LIKE '%/0%' 
											AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '-', '' ))) / length( '-' ) = 1
											AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '/', '' ))) / length( '/' ) = 1 THEN
											fraction_to_decimal(item_specs.spec_value)::REAL
										ELSE NULL
										END
									ELSE
										CASE WHEN item_specs.spec_value NOT LIKE '%-%' THEN
											item_specs.spec_value::REAL
										ELSE NULL
										END
									END
								ELSE NULL
								END is not null
	
							group by  item_id, spec_name, spec_value, spec_uom,
							CASE WHEN isnumeric(REPLACE(REPLACE(item_specs.spec_value, '-', ''), '/', '')) = TRUE THEN
									CASE WHEN item_specs.spec_value LIKE '%/%' THEN
										CASE WHEN item_specs.spec_value NOT LIKE '%-%' AND temp_item_specs.spec_value NOT LIKE '%/0%' 
											AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '/', '' ))) / length( '/' ) = 1 THEN
											fraction_to_decimal(item_specs.spec_value)::REAL
										 WHEN item_specs.spec_value NOT LIKE '%/%-%' AND temp_item_specs.spec_value NOT LIKE '%/0%' 
											AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '-', '' ))) / length( '-' ) = 1
											AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '/', '' ))) / length( '/' ) = 1 THEN
											fraction_to_decimal(item_specs.spec_value)::REAL
										ELSE NULL
										END
									ELSE
										CASE WHEN item_specs.spec_value NOT LIKE '%-%' THEN
											item_specs.spec_value::REAL
										ELSE NULL
										END
									END
								ELSE NULL
								END
						)A
						where trim(item_specs.spec_name) = trim(A.spec_name)
						and trim(item_specs.spec_value) = trim(A.spec_value)
						and trim(item_specs.item_id) = trim(A.item_id) 
2020-10-22 23:13:02.686 CDT [6083] ERROR:  invalid input syntax for type integer: ""
2020-10-22 23:13:02.686 CDT [6083] STATEMENT:  SELECT customer_p21.customer_id, customer_p21.customer_name, customer_p21.company_id,
												customer_p21.mail_address1, customer_p21.mail_address2, customer_p21.mail_address3,
												customer_p21.mail_city, customer_p21.mail_state, customer_p21.mail_zip,
												customer_p21.sales_rep_id, customer_p21.currency_desc, customer_p21.mail_country,
												customer_web_data.customer_uid, COALESCE(integrations.taker_id,customer_web_data.taker_id) AS taker_id,
												customer_web_data.email_invoices_to, customer_web_data.integrations_customer,
												customer_web_data.ariba_network_id, customer_p21.currency_id,
												customer_web_data.punch_out_enabled, customer_web_data.punch_out_type,
												customer_web_data.hook_url,
												customer_web_data.display_logo_flag, customer_web_data.customer_logo_image,
												crib_info.ship_to_id, crib_info.contract_no, crib_info.sales_location_id, crib_info.source_location_id,
												crib_info.order_pricing_method, crib_info.usage_pricing_method,
												COALESCE(crib_info.contact_id, 1109) AS contact_id,
												crib_info.use_customer_po, customer_p21.legacy_id,
												crib_info.import_file_type, crib_info.confirmation_email_address,
												COALESCE(integrations.taker_email_address, groves_users.email_address) AS taker_email_address,
												crib_info.import_approved
										  FROM customer_p21
										  LEFT JOIN customer_web_data
										  ON customer_p21.customer_id = customer_web_data.customer_id
												AND customer_p21.company_id = customer_web_data.company_id
										  LEFT JOIN integrations
										  ON integrations.customer_id = customer_p21.customer_id
												AND integrations.integration_status = 'ACTIVE'
										  LEFT JOIN crib_info
										  ON crib_info.integration_id = integrations.integration_id
												AND crib_status = 'ACTIVE'
												AND crib_info.delete_flag = 'N'
										  LEFT JOIN groves_users
										  ON groves_users.taker_id = customer_web_data.taker_id
										  WHERE customer_p21.delete_flag = 'N'
										  AND customer_p21.customer_id = $1 
2020-10-22 23:13:02.732 CDT [6083] ERROR:  invalid input syntax for type integer: ""
2020-10-22 23:13:02.732 CDT [6083] STATEMENT:  INSERT INTO order_header ( username, customer_id, customer_name, customer_po_number, taker_id,
										ship_instructions_1, ship_instructions_2, order_date, email_address, ship_to_name, ship_to_addr1,
										ship_to_addr2, ship_to_city, ship_to_state, ship_to_zip, bill_to_name, bill_to_addr1,
										bill_to_addr2, bill_to_city, bill_to_state, bill_to_zip, status, payment_method, cc_type, cc_owner,
										cc_number, cc_expires_month, cc_expires_year, consignment_replenishment_order, po_order, ship_to_number,
										contact_id, contact_name, contract_id, approved, ship_to_addr3, location_id, shipping_method_id,
										company_id, consignment_usage_order, sales_location_id, source_location_id )
								   VALUES ( $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16,
								   		$17, $18, $19, $20, $21, $22, $23, $24, $25, '\x', '\x', '\x', $26, $27, $28,
								   		$29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39 )