Description
Warranty
{"id":2423,"brand_id":"138","created_at":"2018-09-13T02:29:07+00:00","updated_at":"2021-10-24T02:54:16+00:00","sku":"SH-28S","name":"Osada Handpiece, Standard Lever Chucking Handpiece with Nose Guard","enabled":1,"is_visible":1,"is_bundle":0,"featured":0,"weight":"1.10","shipping_weight":"1.1000","shipping_override":"inherit","special_order":0,"generic_entities":[],"product_attributes":[{"id":32,"name":"GP Description","slug":"GP Description","value":"OSADA HANDPIECE,STANDARD 1:1 WITH S NOSE GUARD(NS)","webId":null,"sortOrder":0},{"id":29,"name":"Freezable","slug":"ta-Freezable","value":"Not Freezable","webId":null,"sortOrder":0},{"id":106,"name":"Heat Sensitive","slug":"ta-heat-sensitive","value":"No","webId":null,"sortOrder":1},{"id":17,"name":"CE Marked","slug":"ta-CE Marked","value":"No","webId":null,"sortOrder":1},{"id":35,"name":"GP Item Type","slug":"GP Item Type","value":"Sales Inventory","webId":null,"sortOrder":1},{"id":39,"name":"HazMat","slug":"ta-Hazardous Shipping Restrictions","value":"Not Hazardous","webId":null,"sortOrder":2},{"id":31,"name":"GP Category","slug":"GP Category","value":"SURG","webId":null,"sortOrder":2},{"id":21,"name":"Country of Origin","slug":"ta-Country of Origin","value":"Japan","webId":null,"sortOrder":2},{"id":38,"name":"GP Use Type","slug":"GP Use Type","value":"REUSABLE","webId":null,"sortOrder":3},{"id":70,"name":"Medical License Required","slug":"ta-Medical License Required","value":"No","webId":null,"sortOrder":3},{"id":68,"name":"Perishable","slug":"ta-Perishable","value":"No","webId":null,"sortOrder":3},{"id":69,"name":"Refrigeration Required","slug":"ta-Refrigeration Required","value":"No","webId":null,"sortOrder":4},{"id":33,"name":"GP Distribution Type","slug":"GP Distribution Type","value":"NONSTOCK","webId":null,"sortOrder":4},{"id":116,"name":"License Requirements","slug":"license-requirements","value":"10 - No Medical License Required","webId":null,"sortOrder":4},{"id":52,"name":"Latex Free","slug":"Latex Free","value":"No","webId":null,"sortOrder":5},{"id":30,"name":"GP Buyer ID","slug":"GP Buyer ID","value":"DarcyR","webId":null,"sortOrder":6},{"id":24,"name":"UOM","slug":"ta-UOM","value":"EACH","webId":null,"sortOrder":7},{"id":36,"name":"GP Primary Vendor","slug":"GP Primary Vendor","value":"OSADA","webId":null,"sortOrder":9}],"related_products":[{"id":2,"name":"Related products","values":[{"id":2415,"sku":"XL-30W","name":"Osada Standard Electric Hand Engine System, 110 Volt"},{"id":2417,"sku":"LVS","name":"Micromotor With Fixed Casing"},{"id":2420,"sku":"MCC6","name":"Osada Motor Cord, Coiled 6 Foot"},{"id":2421,"sku":"OIL\/S","name":"Osada Spray Oil"},{"id":2422,"sku":"SH-27","name":"Osada Handpiece, 20 Degree Twist Ring Handpiece with Nose Guard"},{"id":2424,"sku":"SH-29S","name":"Osada Handpiece, Reduction Speed with Lever Chucking Handpiece and Nose Guard, 2.7:1"},{"id":3367,"sku":"AMC","name":"Autoclavable micromotor housing"}]}],"categories":[{"id":296,"parent_id":21,"name":"Dermabrasion","slug":null,"fqn_cache":"Root Category > Shop All > Surgery > Dermabrasion"}],"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":"751.00","starts_at":"2021-01-01T11:38:37+00:00","ends_at":null,"attributes":[]}}},"prices":[{"id":1970,"batch_id":0,"created_at":"2018-09-12T23:45:29+00:00","sell_price":"600.00","booktype":"MASTER","price_book_code":"DGP","starts_at":"2018-09-12T23:45:29+00:00","base":"BASE","author":"DGP"},{"id":6537,"batch_id":0,"created_at":"2019-01-02T12:12:14+00:00","sell_price":"618.00","booktype":"MASTER","price_book_code":"DGP","starts_at":"2019-01-02T12:12:14+00:00","base":"BASE","author":"DGP"},{"id":10792,"batch_id":0,"created_at":"2020-01-05T14:38:11+00:00","sell_price":"729.00","booktype":"MASTER","price_book_code":"DGP","starts_at":"2020-01-05T14:38:11+00:00","base":"BASE","author":"DGP"},{"id":13713,"batch_id":0,"created_at":"2021-01-01T11:38:37+00:00","sell_price":"751.00","booktype":"MASTER","price_book_code":"DGP","starts_at":"2021-01-01T11:38:37+00:00","base":"BASE","author":"DGP"}],"inventory":[{"id":2452,"updated_at":"2021-09-10T15:45:11+00:00","location":"default","type":100,"count_on_hand":0,"count_on_hold":0},{"id":11228,"created_at":"2021-10-08T22:03:20+00:00","updated_at":"2021-10-08T22:03:20+00:00","location":"CENTRAL","count_on_hand":0,"count_on_hold":0}],"children":[],"brand":{"id":138,"name":"Osada","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:29:06","updated_at":null,"product_count":0},"parent":null,"tags":[{"id":13279,"product_id":"2423","tag_value_en":"CLOSEOUT2020","created_at":null,"updated_at":null,"version_id":0}],"assets":[{"id":4764,"asset_type_id":4,"uri_internal":"https:\/\/delasco-assets.s3.amazonaws.com\/4a415f5c42044ca852b1fdeb4f70d110fe5687fd0f4e26e89d942b5dfc31c146.png","uri_external":"https:\/\/delasco-shared.s3.amazonaws.com\/jasper_export_new\/SH-28S-1-1600.png","hash":"4a415f5c42044ca852b1fdeb4f70d110fe5687fd0f4e26e89d942b5dfc31c146","private":0,"asset_source_date":null,"asset_source":"SH-28S-1-1600.png","deleted_at":null,"created_at":null,"updated_at":null,"pivot":{"product_id":2423,"asset_id":4764,"id":4634,"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:12:34","updated_at":null}},{"id":4765,"asset_type_id":4,"uri_internal":"https:\/\/delasco-assets.s3.amazonaws.com\/f382504e40a010c5ee6e3adf496f833d241b79632978d656234d784350398e14.png","uri_external":"https:\/\/delasco-shared.s3.amazonaws.com\/jasper_export_new\/SH-28S-2-1600.png","hash":"f382504e40a010c5ee6e3adf496f833d241b79632978d656234d784350398e14","private":0,"asset_source_date":null,"asset_source":"SH-28S-2-1600.png","deleted_at":null,"created_at":null,"updated_at":null,"pivot":{"product_id":2423,"asset_id":4765,"id":4635,"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:12:34","updated_at":null}}],"assets_thumbnail":{"id":4764,"asset_type_id":4,"uri_internal":"https:\/\/delasco-assets.s3.amazonaws.com\/4a415f5c42044ca852b1fdeb4f70d110fe5687fd0f4e26e89d942b5dfc31c146.png","uri_external":"https:\/\/delasco-shared.s3.amazonaws.com\/jasper_export_new\/SH-28S-1-1600.png","hash":"4a415f5c42044ca852b1fdeb4f70d110fe5687fd0f4e26e89d942b5dfc31c146","private":0,"asset_source_date":null,"asset_source":"SH-28S-1-1600.png","deleted_at":null,"created_at":null,"updated_at":null,"pivot":{"product_id":2423,"asset_id":4764,"id":4634,"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:12:34","updated_at":null}},"assets_non_thumbnail":[{"id":4765,"asset_type_id":4,"uri_internal":"https:\/\/delasco-assets.s3.amazonaws.com\/f382504e40a010c5ee6e3adf496f833d241b79632978d656234d784350398e14.png","uri_external":"https:\/\/delasco-shared.s3.amazonaws.com\/jasper_export_new\/SH-28S-2-1600.png","hash":"f382504e40a010c5ee6e3adf496f833d241b79632978d656234d784350398e14","private":0,"asset_source_date":null,"asset_source":"SH-28S-2-1600.png","deleted_at":null,"created_at":null,"updated_at":null,"pivot":{"product_id":2423,"asset_id":4765,"id":4635,"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:12:34","updated_at":null}}],"future_exclusions":[]}
