Description
Warranty
{"id":2095,"brand_id":"121","created_at":"2018-09-13T02:28:47+00:00","updated_at":"2021-10-27T02:44:02+00:00","sku":"MC-0","name":"Piffard Curette 5.625 in Straight 1mm X 2mm Oval","enabled":1,"is_visible":1,"is_bundle":0,"featured":0,"weight":"0.10","shipping_weight":"0.1000","shipping_override":"inherit","special_order":0,"generic_entities":[],"product_attributes":[{"id":32,"name":"GP Description","slug":"GP Description","value":"CURETTE, PIFFARD, NARROW HANDLE, SIZE 0, 1.5MM, MILTEX (NS)","webId":null,"sortOrder":0},{"id":48,"name":"Instrument Style Name","slug":"ta-Instrument Style Name","value":"Piffard","webId":null,"sortOrder":0},{"id":29,"name":"Freezable","slug":"ta-Freezable","value":"Not Freezable","webId":null,"sortOrder":0},{"id":15,"name":"Catalog Description","slug":"Catalog Description","value":"1 x 2mm","webId":null,"sortOrder":1},{"id":17,"name":"CE Marked","slug":"ta-CE Marked","value":"Yes","webId":null,"sortOrder":1},{"id":35,"name":"GP Item Type","slug":"GP Item Type","value":"Sales Inventory","webId":null,"sortOrder":1},{"id":106,"name":"Heat Sensitive","slug":"ta-heat-sensitive","value":"No","webId":null,"sortOrder":1},{"id":44,"name":"Instrument Handle Type","slug":"ta-Instrument Handle Type","value":"Flat","webId":null,"sortOrder":1},{"id":31,"name":"GP Category","slug":"GP Category","value":"INS","webId":null,"sortOrder":2},{"id":39,"name":"HazMat","slug":"ta-Hazardous Shipping Restrictions","value":"Not Hazardous","webId":null,"sortOrder":2},{"id":45,"name":"Instrument Length","slug":"ta-Instrument Length","value":"5.625 in","webId":null,"sortOrder":2},{"id":21,"name":"Country of Origin","slug":"ta-Country of Origin","value":"Germany","webId":null,"sortOrder":2},{"id":38,"name":"GP Use Type","slug":"GP Use Type","value":"REUSABLE","webId":null,"sortOrder":3},{"id":68,"name":"Perishable","slug":"ta-Perishable","value":"No","webId":null,"sortOrder":3},{"id":46,"name":"Instrument Material","slug":"ta-Instrument Material","value":"Stainless Steel","webId":null,"sortOrder":3},{"id":70,"name":"Medical License Required","slug":"ta-Medical License Required","value":"Yes","webId":null,"sortOrder":3},{"id":116,"name":"License Requirements","slug":"license-requirements","value":"90 - Medical License Required","webId":null,"sortOrder":4},{"id":33,"name":"GP Distribution Type","slug":"GP Distribution Type","value":"NONSTOCK","webId":null,"sortOrder":4},{"id":69,"name":"Refrigeration Required","slug":"ta-Refrigeration Required","value":"No","webId":null,"sortOrder":4},{"id":47,"name":"Instrument Shape","slug":"ta-Instrument Shape","value":"Straight","webId":null,"sortOrder":4},{"id":49,"name":"Instrument Tip Configuration","slug":"ta-Instrument Tip Configuration","value":"Oval","webId":null,"sortOrder":5},{"id":52,"name":"Latex Free","slug":"Latex Free","value":"Yes","webId":null,"sortOrder":5},{"id":6,"name":"GP Manufacturer","slug":"GP Manufacturer","value":"MIL - MILTEX","webId":null,"sortOrder":5},{"id":50,"name":"Instrument Tip Size","slug":"ta-Instrument Tip Size","value":"1mm X 2mm","webId":null,"sortOrder":6},{"id":30,"name":"GP Buyer ID","slug":"GP Buyer ID","value":"SeanF","webId":null,"sortOrder":6},{"id":51,"name":"Instrument Type","slug":"Instrument Type","value":"Curette","webId":null,"sortOrder":7},{"id":24,"name":"UOM","slug":"ta-UOM","value":"EACH","webId":null,"sortOrder":7},{"id":81,"name":"Tungsten Carbide","slug":"ta-Tungsten Carbide","value":"No","webId":null,"sortOrder":8},{"id":34,"name":"GP Instrument Sub Category","slug":"GP Instrument Sub Category","value":"DER","webId":null,"sortOrder":8},{"id":73,"name":"SuperCut","slug":"ta-SuperCut","value":"No","webId":null,"sortOrder":9},{"id":36,"name":"GP Primary Vendor","slug":"GP Primary Vendor","value":"MILTEX","webId":null,"sortOrder":9},{"id":109,"name":"GP Item Notes","slug":"item-notes","value":"10\/11\/21 - DISCONTINUED THIS AS A DELASCO ITEM NUMBER. THE EXACT SAME ITEM IS STILL AVAILABLE UNDER THE ACTUAL MILTEX \rITEM 33-16-0 TAB.","webId":null,"sortOrder":12}],"related_products":[],"categories":[{"id":498,"parent_id":136,"name":"Piffard","slug":"piffard","fqn_cache":"Root Category > Shop All > Instruments > Curettes > Piffard"},{"id":553,"parent_id":1,"name":"Sale","slug":null,"fqn_cache":"Root Category > Sale"}],"channels":[{"id":1,"name":"BigCommerce"},{"id":3,"name":"InDesign Full Export"},{"id":4,"name":"CSV Export All Products"},{"id":5,"name":"CSV Export Only Children"}],"barcodes":[],"active_prices":{"BASE":{"base":"BASE","cost":null,"map":null,"msrp":null,"sell_price":{"value":"145.00","starts_at":"2021-01-01T11:36:36+00:00","ends_at":null,"attributes":[]}}},"prices":[{"id":1913,"batch_id":0,"created_at":"2018-09-12T23:45:26+00:00","sell_price":"164.00","booktype":"MASTER","price_book_code":"DGP","starts_at":"2018-09-12T23:45:26+00:00","base":"BASE","author":"DGP"},{"id":6082,"batch_id":0,"created_at":"2019-01-02T12:09:24+00:00","sell_price":"167.25","booktype":"MASTER","price_book_code":"DGP","starts_at":"2019-01-02T12:09:24+00:00","base":"BASE","author":"DGP"},{"id":10254,"batch_id":0,"created_at":"2020-01-05T14:36:18+00:00","sell_price":"172.50","booktype":"MASTER","price_book_code":"DGP","starts_at":"2020-01-05T14:36:18+00:00","base":"BASE","author":"DGP"},{"id":13186,"batch_id":0,"created_at":"2021-01-01T11:36:36+00:00","sell_price":"145.00","booktype":"MASTER","price_book_code":"DGP","starts_at":"2021-01-01T11:36:36+00:00","base":"BASE","author":"DGP"}],"inventory":[{"id":2394,"updated_at":"2021-07-30T16:55:06+00:00","location":"default","type":100,"count_on_hand":1,"count_on_hold":0},{"id":10356,"created_at":"2021-10-08T21:54:13+00:00","updated_at":"2021-10-08T21:54:13+00:00","location":"CENTRAL","count_on_hand":1,"count_on_hold":0}],"children":[],"brand":{"id":121,"name":"Miltex","desc":null,"excluded":0,"exclusion_start_date":null,"exclusion_end_date":null,"exclusion_reason":null,"seo_search_keywords":null,"seo_meta_desc":null,"seo_meta_keywords":null,"seo_title":null,"created_at":"2018-09-13 02:28:45","updated_at":null,"product_count":172},"parent":null,"tags":[{"id":23921,"product_id":"2095","tag_value_en":"SAAD19","created_at":null,"updated_at":null,"version_id":0},{"id":23922,"product_id":"2095","tag_value_en":"ASDS19","created_at":null,"updated_at":null,"version_id":0},{"id":23923,"product_id":"2095","tag_value_en":"AAD20","created_at":null,"updated_at":null,"version_id":0},{"id":23925,"product_id":"2095","tag_value_en":"20SAAD","created_at":null,"updated_at":null,"version_id":0},{"id":23926,"product_id":"2095","tag_value_en":"SALEQ12021","created_at":null,"updated_at":null,"version_id":0}],"assets":[{"id":3916,"asset_type_id":4,"uri_internal":"https:\/\/delasco-assets.s3.amazonaws.com\/c75db27a78db14a12cca9cf2c3274efdd296bfbf8146eb8d4039297649c5e7f4.png","uri_external":"https:\/\/delasco-shared.s3.amazonaws.com\/jasper_export_new\/MC-0-1-1600.png","hash":"c75db27a78db14a12cca9cf2c3274efdd296bfbf8146eb8d4039297649c5e7f4","private":0,"asset_source_date":null,"asset_source":"MC-0-1-1600.png","deleted_at":null,"created_at":null,"updated_at":null,"pivot":{"product_id":2095,"asset_id":3916,"id":3786,"web_id":null,"thumbnail":1,"visible":1,"dim":0,"sort_order":0,"name":null,"desc":null,"alttext":null,"type":null,"deleted_at":null,"created_at":"2018-09-26 00:06:13","updated_at":null}},{"id":3917,"asset_type_id":4,"uri_internal":"https:\/\/delasco-assets.s3.amazonaws.com\/54dbed12e32b0ca1d2aceab2c8aae2d67f48f0b12ca5ab2d9bc76b926fc32e26.png","uri_external":"https:\/\/delasco-shared.s3.amazonaws.com\/jasper_export_new\/MC-0-2-1600.png","hash":"54dbed12e32b0ca1d2aceab2c8aae2d67f48f0b12ca5ab2d9bc76b926fc32e26","private":0,"asset_source_date":null,"asset_source":"MC-0-2-1600.png","deleted_at":null,"created_at":null,"updated_at":null,"pivot":{"product_id":2095,"asset_id":3917,"id":3787,"web_id":null,"thumbnail":0,"visible":1,"dim":0,"sort_order":0,"name":null,"desc":null,"alttext":null,"type":null,"deleted_at":null,"created_at":"2018-09-26 00:06:13","updated_at":null}},{"id":3918,"asset_type_id":4,"uri_internal":"https:\/\/delasco-assets.s3.amazonaws.com\/d0c76029547ded0480fa467bbc2275e7616330c92a6b25a0688a1e8096dbe131.png","uri_external":"https:\/\/delasco-shared.s3.amazonaws.com\/jasper_export_new\/MC-0-3-1600.png","hash":"d0c76029547ded0480fa467bbc2275e7616330c92a6b25a0688a1e8096dbe131","private":0,"asset_source_date":null,"asset_source":"MC-0-3-1600.png","deleted_at":null,"created_at":null,"updated_at":null,"pivot":{"product_id":2095,"asset_id":3918,"id":3788,"web_id":null,"thumbnail":0,"visible":1,"dim":0,"sort_order":0,"name":null,"desc":null,"alttext":null,"type":null,"deleted_at":null,"created_at":"2018-09-26 00:06:13","updated_at":null}}],"assets_thumbnail":{"id":3916,"asset_type_id":4,"uri_internal":"https:\/\/delasco-assets.s3.amazonaws.com\/c75db27a78db14a12cca9cf2c3274efdd296bfbf8146eb8d4039297649c5e7f4.png","uri_external":"https:\/\/delasco-shared.s3.amazonaws.com\/jasper_export_new\/MC-0-1-1600.png","hash":"c75db27a78db14a12cca9cf2c3274efdd296bfbf8146eb8d4039297649c5e7f4","private":0,"asset_source_date":null,"asset_source":"MC-0-1-1600.png","deleted_at":null,"created_at":null,"updated_at":null,"pivot":{"product_id":2095,"asset_id":3916,"id":3786,"web_id":null,"thumbnail":1,"visible":1,"dim":0,"sort_order":0,"name":null,"desc":null,"alttext":null,"type":null,"deleted_at":null,"created_at":"2018-09-26 00:06:13","updated_at":null}},"assets_non_thumbnail":[{"id":3917,"asset_type_id":4,"uri_internal":"https:\/\/delasco-assets.s3.amazonaws.com\/54dbed12e32b0ca1d2aceab2c8aae2d67f48f0b12ca5ab2d9bc76b926fc32e26.png","uri_external":"https:\/\/delasco-shared.s3.amazonaws.com\/jasper_export_new\/MC-0-2-1600.png","hash":"54dbed12e32b0ca1d2aceab2c8aae2d67f48f0b12ca5ab2d9bc76b926fc32e26","private":0,"asset_source_date":null,"asset_source":"MC-0-2-1600.png","deleted_at":null,"created_at":null,"updated_at":null,"pivot":{"product_id":2095,"asset_id":3917,"id":3787,"web_id":null,"thumbnail":0,"visible":1,"dim":0,"sort_order":0,"name":null,"desc":null,"alttext":null,"type":null,"deleted_at":null,"created_at":"2018-09-26 00:06:13","updated_at":null}},{"id":3918,"asset_type_id":4,"uri_internal":"https:\/\/delasco-assets.s3.amazonaws.com\/d0c76029547ded0480fa467bbc2275e7616330c92a6b25a0688a1e8096dbe131.png","uri_external":"https:\/\/delasco-shared.s3.amazonaws.com\/jasper_export_new\/MC-0-3-1600.png","hash":"d0c76029547ded0480fa467bbc2275e7616330c92a6b25a0688a1e8096dbe131","private":0,"asset_source_date":null,"asset_source":"MC-0-3-1600.png","deleted_at":null,"created_at":null,"updated_at":null,"pivot":{"product_id":2095,"asset_id":3918,"id":3788,"web_id":null,"thumbnail":0,"visible":1,"dim":0,"sort_order":0,"name":null,"desc":null,"alttext":null,"type":null,"deleted_at":null,"created_at":"2018-09-26 00:06:13","updated_at":null}}],"future_exclusions":[]}
