call func.sp_savetreezproduct('{"schema":"cmp2","operate":"crud","flag":"","payload":""}','[{"processid":"e72ac8167ff19d6e7c0f00f7","product_id":"8c1df2c1-d0fa-11e9-97d6-02759c1e999e","product_status":"ACTIVE","category_type":"PILL","amount":0,"brand":"ABSOLUTE EXTRACTS","classification":"","name":"100MG SOFT GELS (20)","size":0,"subtype":"","total_mg_cbd":0,"total_mg_thc":2000,"uom":null,"price_sell":161,"tier_price":null,"attr_general":[],"attr_flavors":[],"attr_effects":[],"attr_ingredients":[],"attr_internal_tags":[],"product_barcodes":[],"images":[],"menu_title":null,"product_description":null,"dispensaryid":"76d1f202-ab85-11ea-8372-02c22777d7b7","published":"false","hidefromscreen":"true","sellableqty":0,"img2":null,"img3":null,"primary_image":null,"sku":""},{"processid":"e72ac8167ff19d6e7c0f00f7","product_id":"370ea6dd-f9c3-11e8-b2ef-02759c1e999e","product_status":"ACTIVE","category_type":"CARTRIDGE","amount":0.5,"brand":"ROVE","classification":"NONE","name":"10:1 REMEDY .5G","size":0,"subtype":"510 THREAD","total_mg_cbd":0,"total_mg_thc":0,"uom":"GRAMS","price_sell":31.2,"tier_price":null,"attr_general":["RETAIL"],"attr_flavors":[],"attr_effects":[],"attr_ingredients":[],"attr_internal_tags":["RETAIL"],"product_barcodes":[],"images":["https:\/\/treezfromtheearthx2.s3.us-west-2.amazonaws.com\/product\/1e43a152-f84f-4022-a2c6-0c66c86e9e70_370ea6dd-f9c3-11e8-b2ef-02759c1e999e_null_29-01-20-13-17-58"],"menu_title":null,"product_description":"These full spectrum oils are derived directly from high CBD cannabis flower. With absolutely no fillers, Remedies offers all the therapeutic effects of CBD with all the natural benefits of full spectrum cannabinoids.\n\nRemedies 10:1\n\nSpot of tea? Yes please! Exotic and extravagant, but certainly not fanciful, this oil is for those who want the best for themselves. Be well and enjoy this sophisticated brew.","dispensaryid":"76d1f202-ab85-11ea-8372-02c22777d7b7","published":"true","hidefromscreen":"false","sellableqty":0,"img2":null,"img3":null,"primary_image":"https:\/\/treezfromtheearthx2.s3.us-west-2.amazonaws.com\/product\/1e43a152-f84f-4022-a2c6-0c66c86e9e70_370ea6dd-f9c3-11e8-b2ef-02759c1e999e_null_29-01-20-13-17-58","sku":""},{"processid":"e72ac8167ff19d6e7c0f00f7","product_id":"5d49ba51-4887-481c-97c6-b480f3e77286","product_status":"ACTIVE","category_type":"CARTRIDGE","amount":0.4,"brand":"ROVE","classification":"","name":"10:1 REMEDY DISPOSABLE","size":0,"subtype":"READY TO USE","total_mg_cbd":0,"total_mg_thc":0,"uom":"GRAMS","price_sell":33.6,"tier_price":null,"attr_general":["RETAIL"],"attr_flavors":[],"attr_effects":[],"attr_ingredients":[],"attr_internal_tags":[],"product_barcodes":[],"images":["https:\/\/treezfromtheearthx2.s3.us-west-2.amazonaws.com\/product\/1e43a152-f84f-4022-a2c6-0c66c86e9e70_5d49ba51-4887-481c-97c6-b480f3e77286_null_29-01-20-13-13-42"],"menu_title":"","product_description":null,"dispensaryid":"76d1f202-ab85-11ea-8372-02c22777d7b7","published":"true","hidefromscreen":"false","sellableqty":0,"img2":null,"img3":null,"primary_image":"https:\/\/treezfromtheearthx2.s3.us-west-2.amazonaws.com\/product\/1e43a152-f84f-4022-a2c6-0c66c86e9e70_5d49ba51-4887-481c-97c6-b480f3e77286_null_29-01-20-13-13-42","sku":""},{"processid":"e72ac8167ff19d6e7c0f00f7","product_id":"1768a9d8-7c05-494b-be10-ef0395ceef6a","product_status":"ACTIVE","category_type":"TINCTURE","amount":0,"brand":"VET CBD","classification":"","name":"10:1 TINCTURE 30ML","size":0,"subtype":"DROPPER","total_mg_cbd":0,"total_mg_thc":12.5,"uom":null,"price_sell":43.2,"tier_price":null,"attr_general":[],"attr_flavors":[],"attr_effects":[],"attr_ingredients":[],"attr_internal_tags":["90-119"],"product_barcodes":[],"images":[],"menu_title":"","product_description":null,"dispensaryid":"76d1f202-ab85-11ea-8372-02c22777d7b7","published":"true","hidefromscreen":"false","sellableqty":0,"img2":null,"img3":null,"primary_image":null,"sku":""},{"processid":"e72ac8167ff19d6e7c0f00f7","product_id":"1d79449f-df11-434b-8681-061b16d97adf","product_status":"ACTIVE","category_type":"PILL","amount":0,"brand":"ABSOLUTE EXTRACTS","classification":"","name":"10MG SOFTGELS 10CT","size":0,"subtype":"","total_mg_cbd":0,"total_mg_thc":100,"uom":null,"price_sell":14.4,"tier_price":null,"attr_general":["RETAIL"],"attr_flavors":[],"attr_effects":[],"attr_ingredients":[],"attr_internal_tags":["RETAIL"],"product_barcodes":[],"images":["https:\/\/treezfteporthueneme.s3.amazonaws.com\/product\/1e43a152-f84f-4022-a2c6-0c66c86e9e70_1d79449f-df11-434b-8681-061b16d97adf_null_18-05-20-11-39-15"],"menu_title":null,"product_description":"Cannabis oil in an easy to consume, precisely dosed gel cap. Ideal for long-lasting relief. We add high-quality organic coconut oil (MCT) to aid absorption of the cannabis oil for optimal benefits. (Use Caution: As with any edible, the intoxicating effects of this product may be delayed by up to 2 hours).\n\nIngredients: Cannabis Oil, Coconut Oil, Gelatin.\n\n10mg Soft Gels - 10 capsules","dispensaryid":"76d1f202-ab85-11ea-8372-02c22777d7b7","published":"true","hidefromscreen":"false","sellableqty":9,"img2":null,"img3":null,"primary_image":"https:\/\/treezfteporthueneme.s3.amazonaws.com\/product\/1e43a152-f84f-4022-a2c6-0c66c86e9e70_1d79449f-df11-434b-8681-061b16d97adf_null_18-05-20-11-39-15","sku":""},{"processid":"e72ac8167ff19d6e7c0f00f7","product_id":"385197aa-c73d-11e8-a549-02759c1e999e","product_status":"ACTIVE","category_type":"PILL","amount":0,"brand":"ABSOLUTE EXTRACTS","classification":"","name":"10MG SOFT GELS 30CT","size":0,"subtype":"","total_mg_cbd":0,"total_mg_thc":300,"uom":null,"price_sell":40.8,"tier_price":null,"attr_general":["RETAIL"],"attr_flavors":[],"attr_effects":[],"attr_ingredients":[],"attr_internal_tags":["RETAIL"],"product_barcodes":[],"images":["https:\/\/treezfromtheearthx2.s3.us-west-2.amazonaws.com\/product\/1e43a152-f84f-4022-a2c6-0c66c86e9e70_385197aa-c73d-11e8-a549-02759c1e999e_product_1587495325448.jpeg_21-04-20-11-55-25"],"menu_title":null,"product_description":"Potent THC cannabis oil in an easy-to-consume, precisely-dosed soft gel capsule. Batch-to-batch consistency of active THC in a price-effective solution for everyday use. (Use Caution: As with any edible, the intoxicating effects of this product may be delayed by up to 2 hours).\n\nKey Benefits: Precisely dosed amount of THC. Long-lasting, easy to consume, odorless and flavor-free gel capsule.\nIngredients: MCT Oil, Gelatin, Water, Glycerin, Cannabis Oil\nAvailable in: 10mg, 25mg, 50mg & 100mg THC capsules","dispensaryid":"76d1f202-ab85-11ea-8372-02c22777d7b7","published":"true","hidefromscreen":"false","sellableqty":9,"img2":null,"img3":null,"primary_image":"https:\/\/treezfromtheearthx2.s3.us-west-2.amazonaws.com\/product\/1e43a152-f84f-4022-a2c6-0c66c86e9e70_385197aa-c73d-11e8-a549-02759c1e999e_product_1587495325448.jpeg_21-04-20-11-55-25","sku":""},{"processid":"e72ac8167ff19d6e7c0f00f7","product_id":"734e231f-c6a4-11e8-891b-02a1750f1c6a","product_status":"ACTIVE","category_type":"MERCH","amount":0,"brand":"RAW","classification":"","name":"1-1\/4 CLASSIC CONES","size":0,"subtype":"","total_mg_cbd":0,"total_mg_thc":0,"uom":null,"price_sell":3.5,"tier_price":null,"attr_general":[],"attr_flavors":[],"attr_effects":[],"attr_ingredients":[],"attr_internal_tags":[],"product_barcodes":[],"images":["https:\/\/treezfteporthueneme.s3.us-west-2.amazonaws.com\/category\/1_73482eb4-c6a4-11e8-891b-02a1750f1c6a_1-1\/4_CONES_335_10_PHOTO_1538587254190_03-10-18-10-21-10"],"menu_title":null,"product_description":null,"dispensaryid":"76d1f202-ab85-11ea-8372-02c22777d7b7","published":"false","hidefromscreen":"true","sellableqty":0,"img2":null,"img3":null,"primary_image":"https:\/\/treezfteporthueneme.s3.us-west-2.amazonaws.com\/category\/1_73482eb4-c6a4-11e8-891b-02a1750f1c6a_1-1\/4_CONES_335_10_PHOTO_1538587254190_03-10-18-10-21-10","sku":""},{"processid":"e72ac8167ff19d6e7c0f00f7","product_id":"b8da4782-9767-11e8-a9a0-02759c1e999e","product_status":"ACTIVE","category_type":"MERCH","amount":0,"brand":"RAW","classification":"","name":"1-1\/4 CLASSIC PAPERS","size":0,"subtype":"","total_mg_cbd":0,"total_mg_thc":0,"uom":null,"price_sell":2,"tier_price":null,"attr_general":[],"attr_flavors":[],"attr_effects":[],"attr_ingredients":[],"attr_internal_tags":[],"product_barcodes":[],"images":["https:\/\/treezfromtheearthx2.s3.us-west-2.amazonaws.com\/product\/1e43a152-f84f-4022-a2c6-0c66c86e9e70_b8da4782-9767-11e8-a9a0-02759c1e999e_null_12-04-20-17-24-27"],"menu_title":null,"product_description":null,"dispensaryid":"76d1f202-ab85-11ea-8372-02c22777d7b7","published":"true","hidefromscreen":"false","sellableqty":0,"img2":null,"img3":null,"primary_image":"https:\/\/treezfromtheearthx2.s3.us-west-2.amazonaws.com\/product\/1e43a152-f84f-4022-a2c6-0c66c86e9e70_b8da4782-9767-11e8-a9a0-02759c1e999e_null_12-04-20-17-24-27","sku":""},{"processid":"e72ac8167ff19d6e7c0f00f7","product_id":"db32d520-8abc-11e8-891b-02a1750f1c6a","product_status":"ACTIVE","category_type":"CARTRIDGE","amount":0.5,"brand":"CARE BY DESIGN","classification":"","name":"1:1 .5G","size":0,"subtype":"510 THREAD","total_mg_cbd":0,"total_mg_thc":0,"uom":"GRAMS","price_sell":29.21,"tier_price":null,"attr_general":["RETAIL"],"attr_flavors":[],"attr_effects":["CARTRIDGE","RELAXING","LOW THC","ANTI-ANXIETY","CBD","ANIT-INFLAMMATORY","BALANCED","RECOVER","PAIN","SLEEP"],"attr_ingredients":[],"attr_internal_tags":["90-119"],"product_barcodes":[],"images":["https:\/\/treezfteporthueneme.s3.us-west-2.amazonaws.com\/category\/1_db2d81cd-8abc-11e8-891b-02a1750f1c6a_1:1_.5G_101_13_PHOTO_1532124064063_20-07-18-15-01-15"],"menu_title":null,"product_description":"Good for nighttime use. The 1:1 is typically psychoactive and may cause sleepiness.\n\nCARE BY DESIGN CBD VAPE CARTRIDGES\nBreath in fast-acting CBD relief. Care By Design vape cartridges work with a standard vape pen and battery. Ideal for quick relief. Available in CBD-to-THCratios of 18:1, 8:1, 4:1, 2:1, 1:1.\n\nWhat Is CBD?\nCannabidiol or CBD is a component of the cannabis plant that may have enormous therapeutic potential. Although it doesn''t make people feel high like THC, CBD is causing quite a buzz among scientists, health professionals, and medical marijuana patients. Academic research centers around the world are currently studying the effects of CBD. Scientists refer to CBD as a \u201cpromiscuous\u201d compound because it may confer therapeutic benefits in many different ways while tapping into how we function physiologically and biologically on a deep level\n","dispensaryid":"76d1f202-ab85-11ea-8372-02c22777d7b7","published":"true","hidefromscreen":"false","sellableqty":0,"img2":null,"img3":null,"primary_image":"https:\/\/treezfteporthueneme.s3.us-west-2.amazonaws.com\/category\/1_db2d81cd-8abc-11e8-891b-02a1750f1c6a_1:1_.5G_101_13_PHOTO_1532124064063_20-07-18-15-01-15","sku":""},{"processid":"e72ac8167ff19d6e7c0f00f7","product_id":"d581cd21-1a77-11e9-a8f9-54b203084267","product_status":"ACTIVE","category_type":"BEVERAGE","amount":0,"brand":"LAGUNITAS","classification":"","name":"1:1 CBD HI-FI HOPS","size":0,"subtype":"BEER","total_mg_cbd":0,"total_mg_thc":5,"uom":null,"price_sell":6,"tier_price":null,"attr_general":["RETAIL"],"attr_flavors":[],"attr_effects":[],"attr_ingredients":[],"attr_internal_tags":["RETAIL"],"product_barcodes":[],"images":["https:\/\/treezfromtheearthx2.s3.us-west-2.amazonaws.com\/product\/1e43a152-f84f-4022-a2c6-0c66c86e9e70_d581cd21-1a77-11e9-a8f9-54b203084267_null_12-04-20-11-47-37"],"menu_title":null,"product_description":"This IPA-inspired sparkling beverage is made using everything Lagunitas knows about hops \u2013 but with zero alcohol, zero calories, and zero carbs. Infused with THC from the finest, sun-grown cannabis at AbsoluteXtracts. \n","dispensaryid":"76d1f202-ab85-11ea-8372-02c22777d7b7","published":"true","hidefromscreen":"false","sellableqty":24,"img2":null,"img3":null,"primary_image":"https:\/\/treezfromtheearthx2.s3.us-west-2.amazonaws.com\/product\/1e43a152-f84f-4022-a2c6-0c66c86e9e70_d581cd21-1a77-11e9-a8f9-54b203084267_null_12-04-20-11-47-37","sku":""}]')