Enterprise Data Provider
Creating an Enterprise Data Provider Script For JSON data
JSON itself is a data interchange format that represents structured data as a collection of key-value pairs. It doesn’t inherently have the concept of records and field sets like you might find in a database. However, you can transform JSON data into a structure that EasyCatalog can import via a simple script. You essentially break […]
Creating Custom JSON Data Providers
The JSON File Sample Data Provider illustrates how to select and parse a typical JSON file and load a set of records and fields into EasyCatalog. The sample file can be downloaded here: JSON Sample File
1 | [{"id":2,"brand_id":"6","created_at":"2021-11-03T18:59:44+00:00","updated_at":"2022-05-17T20:56:36+00:00","sku":"062-000","name":"QUICKFIX 5 Minute Epoxy Adhesive Kit (4.5 oz)","enabled":0,"is_visible":0,"is_bundle":0,"featured":0,"desc_short":"When mixed in equal volumes, the resin and hardener react to produce a tough, rigid, high strength bond, which starts to set in 5 minutes and reaches handling strength in 1 hour.","desc_long":"When mixed in equal volumes, the resin and hardener react to produce a tough, rigid, high strength bond, which starts to set in 5 minutes and reaches handling strength in 1 hour","page_title":"Epoxy Instant Mix 5 Minute is a two-part adhesive 4.5 oz","meta_description":"When mixed in equal volumes, the resin and hardener react to produce a tough, rigid, high strength bond, which starts to set in 5 minutes and reaches handling strength in 1 hour","meta_keywords":"Pegante, Epoxy","shipping_weight":"0.4400","shipping_override":"inherit","special_order":0,"generic_entities":[],"product_attributes":[{"id":3,"name":"Catalog Title","slug":"catalog_title","value":"Epoxy Glue Clear 5 minutes 4.5 oz","webId":null,"sortOrder":0},{"id":30,"name":"Epoxy Adhesive Type","slug":"epoxy_adhesive_type","value":"Structural","webId":null,"sortOrder":0},{"id":5,"name":"Catalog Group Title","slug":"catalog_group_title","value":"Epoxy","webId":null,"sortOrder":1},{"id":29,"name":"Epoxy Container Type","slug":"epoxy_container_type","value":"Bottle","webId":null,"sortOrder":1},{"id":4,"name":"Catalog Product Highlights","slug":"catalog_product_highlights","value":"<ul><li>Drying time: 5 minutes<\/li><li>Color: Clear<\/li><li>Volume: 4.5 oz<\/li><li>Lasting bond in areas subjected to high vibration<\/li><\/ul>","webId":null,"sortOrder":2},{"id":17,"name":"Epoxy Container Size","slug":"epoxy_container_size","value":"4.5 oz","webId":null,"sortOrder":2},{"id":15,"name":"Epoxy Begins to Harden","slug":"epoxy_begins_to_harden","value":"5 min","webId":null,"sortOrder":3},{"id":31,"name":"Epoxy Mixing Required","slug":"epoxy_mixing_required","value":"Yes","webId":null,"sortOrder":4},{"id":32,"name":"Epoxy Mix Ratio","slug":"epoxy_mix_ratio","value":"1:1","webId":null,"sortOrder":5},{"id":33,"name":"Epoxy Reaches Full Strength","slug":"epoxy_reaches_full_strength","value":"60 min","webId":null,"sortOrder":6},{"id":34,"name":"Epoxy For Use On","slug":"epoxy_for_use_on","value":"Fiberglas, Wood, Metals, Plastics, Speaker repair","webId":null,"sortOrder":7},{"id":35,"name":"Epoxy Color","slug":"epoxy_color","value":"Clear","webId":null,"sortOrder":8},{"id":14,"name":"Epoxy Formula","slug":"epoxy_formula","value":"Clear","webId":null,"sortOrder":9}],"related_products":[{"id":2,"name":"Many to Many","values":[{"id":3,"sku":"062-001","name":"QUICKFIX 5 Minute Epoxy Adhesive Kit (10 oz)","attributes":[]}]}],"categories":[{"id":6,"parent_id":153,"name":"Adhesives & Glue","slug":"\/adhesives-glue\/","fqn_cache":"Root > Pro Audio > Speaker Components > Adhesives & Glue"}],"channels":[{"id":1,"name":"HEDEL USA","enabled":1}],"barcodes":[],"active_prices":{"USD":{"base":"USD","cost":null,"map":null,"msrp":null,"sell_price":{"value":"15.00","starts_at":"2021-12-01T13:46:16+00:00","ends_at":null,"attributes":[]}}},"prices":[{"id":2,"batch_id":0,"created_at":"2021-11-03T18:59:44+00:00","updated_at":"2021-12-01T13:46:18+00:00","cost":"0.00","sell_price":"8.21","booktype":"BIGCOMMERCE-IMPORT","price_book_code":"BIGCOMMERCE-IMPORT","starts_at":"2021-11-03T18:59:44+00:00","ends_at":"2021-12-01T13:46:18+00:00","base":"USD","author":"PIM-IMPORT"},{"id":1874,"batch_id":0,"created_at":"2021-12-01T13:46:16+00:00","updated_at":"2021-12-01T13:46:16+00:00","sell_price":"15.00","booktype":"HAND","price_book_code":"PCS-HAND","starts_at":"2021-12-01T13:46:16+00:00","base":"USD","author":"Brian Madro\u00f1ero"}],"inventory":[{"id":1,"created_at":"2021-11-03T18:59:45+00:00","updated_at":"2021-11-03T18:59:45+00:00","location":"MIAMI","count_on_hand":5,"count_on_hold":0}],"children":[],"brand":{"id":6,"name":"QUICKFIX","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":null,"updated_at":"2021-11-05 17:38:19","product_count":6},"parent":null,"tags":[],"assets":[{"id":1,"asset_type_id":4,"uri_internal":"https:\/\/jasper-pimstorage-na-1.s3.amazonaws.com\/e945b788227621d877b8e2be7e34ef34cb89812153f702b4b2b9c6ba6d5b9fbb.png","uri_external":"https:\/\/cdn11.bigcommerce.com\/s-nojk69bs1u\/product_images\/attribute_rule_images\/71_source_1635958709.png","hash":"e945b788227621d877b8e2be7e34ef34cb89812153f702b4b2b9c6ba6d5b9fbb","private":0,"asset_source_date":"2021-11-03 18:59:45","asset_source":"71_source_1635958709.png","deleted_at":null,"created_at":"2021-11-03 18:59:45","updated_at":"2021-11-03 18:59:45","pivot":{"product_id":2,"asset_id":1,"id":1,"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":"2021-11-03 18:59:45","updated_at":"2021-11-03 18:59:45"}}],"assets_thumbnail":{"id":1,"asset_type_id":4,"uri_internal":"https:\/\/jasper-pimstorage-na-1.s3.amazonaws.com\/e945b788227621d877b8e2be7e34ef34cb89812153f702b4b2b9c6ba6d5b9fbb.png","uri_external":"https:\/\/cdn11.bigcommerce.com\/s-nojk69bs1u\/product_images\/attribute_rule_images\/71_source_1635958709.png","hash":"e945b788227621d877b8e2be7e34ef34cb89812153f702b4b2b9c6ba6d5b9fbb","private":0,"asset_source_date":"2021-11-03 18:59:45","asset_source":"71_source_1635958709.png","deleted_at":null,"created_at":"2021-11-03 18:59:45","updated_at":"2021-11-03 18:59:45","pivot":{"product_id":2,"asset_id":1,"id":1,"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":"2021-11-03 18:59:45","updated_at":"2021-11-03 18:59:45"}},"assets_non_thumbnail":[],"future_exclusions":[]},{"id":3,"brand_id":"6","created_at":"2021-11-03T18:59:45+00:00","updated_at":"2022-05-17T20:56:22+00:00","sku":"062-001","name":"QUICKFIX 5 Minute Epoxy Adhesive Kit (10 oz)","enabled":0,"is_visible":0,"is_bundle":0,"featured":0,"desc_short":"When mixed in equal volumes, the resin and hardener react to produce a tough, rigid, high strength bond, which starts to set in 5 minutes and reaches handling strength in 1 hour","desc_long":"When mixed in equal volumes, the resin and hardener react to produce a tough, rigid, high strength bond, which starts to set in 5 minutes and reaches handling strength in 1 hour","page_title":"Epoxy Instant Mix 5 Minute is a two-part adhesive","meta_description":"When mixed in equal volumes, the resin and hardener react to produce a tough, rigid, high strength bond, which starts to set in 5 minutes and reaches handling strength in 1 hour","meta_keywords":"Pegante, Epoxy","shipping_weight":"0.4400","shipping_override":"inherit","special_order":0,"generic_entities":[],"product_attributes":[{"id":30,"name":"Epoxy Adhesive Type","slug":"epoxy_adhesive_type","value":"Structural","webId":null,"sortOrder":0},{"id":3,"name":"Catalog Title","slug":"catalog_title","value":"Epoxy Transparente 5 minutos 10 oz","webId":null,"sortOrder":0},{"id":5,"name":"Catalog Group Title","slug":"catalog_group_title","value":"Epoxy","webId":null,"sortOrder":1},{"id":29,"name":"Epoxy Container Type","slug":"epoxy_container_type","value":"Bottle","webId":null,"sortOrder":1},{"id":17,"name":"Epoxy Container Size","slug":"epoxy_container_size","value":"Botella","webId":null,"sortOrder":2},{"id":4,"name":"Catalog Product Highlights","slug":"catalog_product_highlights","value":"<ul><li>Tiempo de secado: 5 minutos<\/li><li>Color: Transparente<\/li><li>Volumen: 10 oz<\/li><li>Uni","webId":null,"sortOrder":2},{"id":15,"name":"Epoxy Begins to Harden","slug":"epoxy_begins_to_harden","value":"5 Min","webId":null,"sortOrder":3},{"id":31,"name":"Epoxy Mixing Required","slug":"epoxy_mixing_required","value":"Yes","webId":null,"sortOrder":4},{"id":32,"name":"Epoxy Mix Ratio","slug":"epoxy_mix_ratio","value":"1:1","webId":null,"sortOrder":5},{"id":33,"name":"Epoxy Reaches Full Strength","slug":"epoxy_reaches_full_strength","value":"60 min","webId":null,"sortOrder":6},{"id":34,"name":"Epoxy For Use On","slug":"epoxy_for_use_on","value":"Fiberglas, Wood, Metals, Plastics, Speaker repair","webId":null,"sortOrder":7},{"id":35,"name":"Epoxy Color","slug":"epoxy_color","value":"Clear","webId":null,"sortOrder":8},{"id":14,"name":"Epoxy Formula","slug":"epoxy_formula","value":"Transparente","webId":null,"sortOrder":9}],"related_products":[{"id":2,"name":"Many to Many","values":[{"id":2,"sku":"062-000","name":"QUICKFIX 5 Minute Epoxy Adhesive Kit (4.5 oz)","attributes":[]}]}],"categories":[{"id":6,"parent_id":153,"name":"Adhesives & Glue","slug":"\/adhesives-glue\/","fqn_cache":"Root > Pro Audio > Speaker Components > Adhesives & Glue"}],"channels":[{"id":1,"name":"HEDEL USA","enabled":1}],"barcodes":[],"active_prices":{"USD":{"base":"USD","cost":{"value":"0.00","starts_at":"2021-11-03T18:59:45+00:00","ends_at":null,"attributes":[]},"map":null,"msrp":null,"sell_price":{"value":"13.40","starts_at":"2021-11-03T18:59:45+00:00","ends_at":null,"attributes":[]}}},"prices":[{"id":3,"batch_id":0,"created_at":"2021-11-03T18:59:45+00:00","updated_at":"2021-11-03T18:59:45+00:00","cost":"0.00","sell_price":"13.40","booktype":"BIGCOMMERCE-IMPORT","price_book_code":"BIGCOMMERCE-IMPORT","starts_at":"2021-11-03T18:59:45+00:00","base":"USD","author":"PIM-IMPORT"}],"inventory":[{"id":2,"created_at":"2021-11-03T18:59:45+00:00","updated_at":"2021-11-03T18:59:45+00:00","location":"MIAMI","count_on_hand":5,"count_on_hold":0}],"children":[],"brand":{"id":6,"name":"QUICKFIX","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":null,"updated_at":"2021-11-05 17:38:19","product_count":6},"parent":null,"tags":[],"assets":[{"id":2,"asset_type_id":4,"uri_internal":"https:\/\/jasper-pimstorage-na-1.s3.amazonaws.com\/b962714d7ad4c69472f9b4cfd550bce717831b58754b7968fa1643706b59acd7.png","uri_external":"https:\/\/cdn11.bigcommerce.com\/s-nojk69bs1u\/product_images\/attribute_rule_images\/73_source_1635960155.png","hash":"b962714d7ad4c69472f9b4cfd550bce717831b58754b7968fa1643706b59acd7","private":0,"asset_source_date":"2021-11-03 18:59:45","asset_source":"73_source_1635960155.png","deleted_at":null,"created_at":"2021-11-03 18:59:45","updated_at":"2021-11-03 18:59:45","pivot":{"product_id":3,"asset_id":2,"id":2,"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":"2021-11-03 18:59:45","updated_at":"2021-11-03 18:59:45"}}],"assets_thumbnail":{"id":2,"asset_type_id":4,"uri_internal":"https:\/\/jasper-pimstorage-na-1.s3.amazonaws.com\/b962714d7ad4c69472f9b4cfd550bce717831b58754b7968fa1643706b59acd7.png","uri_external":"https:\/\/cdn11.bigcommerce.com\/s-nojk69bs1u\/product_images\/attribute_rule_images\/73_source_1635960155.png","hash":"b962714d7ad4c69472f9b4cfd550bce717831b58754b7968fa1643706b59acd7","private":0,"asset_source_date":"2021-11-03 18:59:45","asset_source":"73_source_1635960155.png","deleted_at":null,"created_at":"2021-11-03 18:59:45","updated_at":"2021-11-03 18:59:45","pivot":{"product_id":3,"asset_id":2,"id":2,"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":"2021-11-03 18:59:45","updated_at":"2021-11-03 18:59:45"}},"assets_non_thumbnail":[],"future_exclusions":[]},{"id":5,"brand_id":"6","created_at":"2021-11-03T18:59:46+00:00","updated_at":"2022-04-21T19:22:09+00:00","sku":"062-100","name":"Epoxy Glue 5 minutes kit of 40gr - (Clear)","enabled":1,"is_visible":1,"is_bundle":0,"featured":0,"desc_short":"5 minute epoxy cures to a slightly flexible consistency, allowing it to form a lasting bond in areas subjected to high vibration. Items bonded with QUICKFIX can be handled after 15 minutes and full strength is reached after just one hour.","desc_long":"<span style=\"color: rgb(65, 65, 65); font-family: "Open Sans", Arial, Helvetica, sans-serif; font-size: 14px;\">5 minute epoxy cures to a slightly flexible consistency, allowing it to form a lasting bond in areas subjected to high vibration. Items bonded with QUICKFIX can be handled after 15 minutes and full strength is reached after just one hour.<\/span>","page_title":"Epoxy Glue 5 minutes kit of 40gr - (Clear)","meta_description":"5 minute epoxy cures to a slightly flexible consistency, allowing it to form a lasting bond in areas subjected to high vibration. Items bonded with QUICKFIX can be handled after 15 minutes and full strength is reached after just one hour.","meta_keywords":"Pegante, adhesivo, goma, epoxy","shipping_weight":"1.0000","shipping_override":"inherit","special_order":0,"generic_entities":[],"product_attributes":[{"id":3,"name":"Catalog Title","slug":"catalog_title","value":"Epoxy Glue Clear 5 minutes kit of 40gr","webId":null,"sortOrder":0},{"id":30,"name":"Epoxy Adhesive Type","slug":"epoxy_adhesive_type","value":"Structural","webId":null,"sortOrder":0},{"id":5,"name":"Catalog Group Title","slug":"catalog_group_title","value":"Epoxy","webId":null,"sortOrder":1},{"id":29,"name":"Epoxy Container Type","slug":"epoxy_container_type","value":"Tube","webId":null,"sortOrder":1},{"id":17,"name":"Epoxy Container Size","slug":"epoxy_container_size","value":"40 gr","webId":null,"sortOrder":2},{"id":4,"name":"Catalog Product Highlights","slug":"catalog_product_highlights","value":"<ul><li>5 minute epoxy cures to a slightly flexible consistency, allowing it to form a lasting bond in areas subjected to high vibration. Items bonded with QUICKFIX can be handled after 15 minutes and full strength is reached after just one hour.<\/li><\/ul>","webId":null,"sortOrder":2},{"id":15,"name":"Epoxy Begins to Harden","slug":"epoxy_begins_to_harden","value":"5 min","webId":null,"sortOrder":3},{"id":31,"name":"Epoxy Mixing Required","slug":"epoxy_mixing_required","value":"Yes","webId":null,"sortOrder":4},{"id":32,"name":"Epoxy Mix Ratio","slug":"epoxy_mix_ratio","value":"1:1","webId":null,"sortOrder":5},{"id":33,"name":"Epoxy Reaches Full Strength","slug":"epoxy_reaches_full_strength","value":"60 min","webId":null,"sortOrder":6},{"id":34,"name":"Epoxy For Use On","slug":"epoxy_for_use_on","value":"Fiberglas, Wood, Metals, Plastics, Speaker repair","webId":null,"sortOrder":7},{"id":35,"name":"Epoxy Color","slug":"epoxy_color","value":"Clear","webId":null,"sortOrder":8},{"id":14,"name":"Epoxy Formula","slug":"epoxy_formula","value":"Resin & Hardener","webId":null,"sortOrder":9}],"related_products":[{"id":2,"name":"Many to Many","values":[{"id":6,"sku":"062-101","name":"Epoxy Glue 5 minutes kit of 40gr - (Black)","attributes":[]}]}],"categories":[{"id":6,"parent_id":153,"name":"Adhesives & Glue","slug":"\/adhesives-glue\/","fqn_cache":"Root > Pro Audio > Speaker Components > Adhesives & Glue"}],"channels":[{"id":1,"name":"HEDEL USA","enabled":1}],"barcodes":[],"active_prices":{"USD":{"base":"USD","cost":{"value":"0.00","starts_at":"2021-11-03T18:59:46+00:00","ends_at":null,"attributes":[]},"map":null,"msrp":null,"sell_price":{"value":"1.00","starts_at":"2021-11-03T18:59:46+00:00","ends_at":null,"attributes":[]}}},"prices":[{"id":5,"batch_id":0,"created_at":"2021-11-03T18:59:46+00:00","updated_at":"2021-11-03T18:59:46+00:00","cost":"0.00","sell_price":"1.00","booktype":"BIGCOMMERCE-IMPORT","price_book_code":"BIGCOMMERCE-IMPORT","starts_at":"2021-11-03T18:59:46+00:00","base":"USD","author":"PIM-IMPORT"}],"inventory":[{"id":3,"created_at":"2021-11-03T18:59:46+00:00","updated_at":"2021-11-03T18:59:46+00:00","location":"MIAMI","count_on_hand":0,"count_on_hold":0}],"children":[],"brand":{"id":6,"name":"QUICKFIX","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":null,"updated_at":"2021-11-05 17:38:19","product_count":6},"parent":null,"tags":[],"assets":[{"id":4,"asset_type_id":4,"uri_internal":"https:\/\/jasper-pimstorage-na-1.s3.amazonaws.com\/aa2a10e29fef25f11dba6a3fdf58585f0937a3ac4e0d2bca65e89150a207d607.png","uri_external":"https:\/\/cdn11.bigcommerce.com\/s-nojk69bs1u\/product_images\/attribute_rule_images\/74_source_1635961646.png","hash":"aa2a10e29fef25f11dba6a3fdf58585f0937a3ac4e0d2bca65e89150a207d607","private":0,"asset_source_date":"2021-11-03 18:59:46","asset_source":"74_source_1635961646.png","deleted_at":null,"created_at":"2021-11-03 18:59:46","updated_at":"2021-11-03 18:59:46","pivot":{"product_id":5,"asset_id":4,"id":4,"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":"2021-11-03 18:59:46","updated_at":"2021-11-03 18:59:46"}}],"assets_thumbnail":{"id":4,"asset_type_id":4,"uri_internal":"https:\/\/jasper-pimstorage-na-1.s3.amazonaws.com\/aa2a10e29fef25f11dba6a3fdf58585f0937a3ac4e0d2bca65e89150a207d607.png","uri_external":"https:\/\/cdn11.bigcommerce.com\/s-nojk69bs1u\/product_images\/attribute_rule_images\/74_source_1635961646.png","hash":"aa2a10e29fef25f11dba6a3fdf58585f0937a3ac4e0d2bca65e89150a207d607","private":0,"asset_source_date":"2021-11-03 18:59:46","asset_source":"74_source_1635961646.png","deleted_at":null,"created_at":"2021-11-03 18:59:46","updated_at":"2021-11-03 18:59:46","pivot":{"product_id":5,"asset_id":4,"id":4,"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":"2021-11-03 18:59:46","updated_at":"2021-11-03 18:59:46"}},"assets_non_thumbnail":[],"future_exclusions":[]},{"id":6,"brand_id":"6","created_at":"2021-11-03T18:59:46+00:00","updated_at":"2022-04-21T19:22:09+00:00","sku":"062-101","name":"Epoxy Glue 5 minutes kit of 40gr - (Black)","enabled":1,"is_visible":1,"is_bundle":0,"featured":0,"desc_short":"5 minute epoxy cures to a slightly flexible consistency, allowing it to form a lasting bond in areas subjected to high vibration. Items bonded with QUICKFIX can be handled after 15 minutes and full strength is reached after just one hour.","desc_long":"<span style=\"color: rgb(65, 65, 65); font-family: "Open Sans", Arial, Helvetica, sans-serif; font-size: 14px;\">5 minute epoxy cures to a slightly flexible consistency, allowing it to form a lasting bond in areas subjected to high vibration. Items bonded with QUICKFIX can be handled after 15 minutes and full strength is reached after just one hour.<\/span>","shipping_weight":"1.0000","shipping_override":"inherit","special_order":0,"generic_entities":[],"product_attributes":[{"id":3,"name":"Catalog Title","slug":"catalog_title","value":"Epoxy Glue Black 5 minutes kit of 40gr","webId":null,"sortOrder":0},{"id":30,"name":"Epoxy Adhesive Type","slug":"epoxy_adhesive_type","value":"Structural","webId":null,"sortOrder":0},{"id":5,"name":"Catalog Group Title","slug":"catalog_group_title","value":"Epoxy","webId":null,"sortOrder":1},{"id":29,"name":"Epoxy Container Type","slug":"epoxy_container_type","value":"Tube","webId":null,"sortOrder":1},{"id":17,"name":"Epoxy Container Size","slug":"epoxy_container_size","value":"40 gr","webId":null,"sortOrder":2},{"id":4,"name":"Catalog Product Highlights","slug":"catalog_product_highlights","value":"<ul><li>5 minute epoxy cures to a slightly flexible consistency, allowing it to form a lasting bond in areas subjected to high vibration. Items bonded with QUICKFIX can be handled after 15 minutes and full strength is reached after just one hour.<\/li><\/ul>","webId":null,"sortOrder":2},{"id":15,"name":"Epoxy Begins to Harden","slug":"epoxy_begins_to_harden","value":"5 min","webId":null,"sortOrder":3},{"id":31,"name":"Epoxy Mixing Required","slug":"epoxy_mixing_required","value":"Yes","webId":null,"sortOrder":4},{"id":32,"name":"Epoxy Mix Ratio","slug":"epoxy_mix_ratio","value":"1:1","webId":null,"sortOrder":5},{"id":33,"name":"Epoxy Reaches Full Strength","slug":"epoxy_reaches_full_strength","value":"60 min","webId":null,"sortOrder":6},{"id":34,"name":"Epoxy For Use On","slug":"epoxy_for_use_on","value":"Fiberglas, Wood, Metals, Plastics, Speaker Repair","webId":null,"sortOrder":7},{"id":35,"name":"Epoxy Color","slug":"epoxy_color","value":"Black","webId":null,"sortOrder":8},{"id":14,"name":"Epoxy Formula","slug":"epoxy_formula","value":"Resin & Hardener","webId":null,"sortOrder":9}],"related_products":[{"id":2,"name":"Many to Many","values":[{"id":5,"sku":"062-100","name":"Epoxy Glue 5 minutes kit of 40gr - (Clear)","attributes":[]}]}],"categories":[{"id":6,"parent_id":153,"name":"Adhesives & Glue","slug":"\/adhesives-glue\/","fqn_cache":"Root > Pro Audio > Speaker Components > Adhesives & Glue"}],"channels":[{"id":1,"name":"HEDEL USA","enabled":1}],"barcodes":[],"active_prices":{"USD":{"base":"USD","cost":{"value":"0.00","starts_at":"2021-11-03T18:59:46+00:00","ends_at":null,"attributes":[]},"map":null,"msrp":null,"sell_price":{"value":"1.00","starts_at":"2021-11-03T18:59:46+00:00","ends_at":null,"attributes":[]}}},"prices":[{"id":6,"batch_id":0,"created_at":"2021-11-03T18:59:46+00:00","updated_at":"2021-11-03T18:59:46+00:00","cost":"0.00","sell_price":"1.00","booktype":"BIGCOMMERCE-IMPORT","price_book_code":"BIGCOMMERCE-IMPORT","starts_at":"2021-11-03T18:59:46+00:00","base":"USD","author":"PIM-IMPORT"}],"inventory":[{"id":4,"created_at":"2021-11-03T18:59:46+00:00","updated_at":"2021-11-03T18:59:46+00:00","location":"MIAMI","count_on_hand":0,"count_on_hold":0}],"children":[],"brand":{"id":6,"name":"QUICKFIX","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":null,"updated_at":"2021-11-05 17:38:19","product_count":6},"parent":null,"tags":[],"assets":[{"id":6,"asset_type_id":4,"uri_internal":"https:\/\/jasper-pimstorage-na-1.s3.amazonaws.com\/af854b8a78fb38d07d446f3043ba228db872916b7630b877e54d7551f5ceb835.png","uri_external":"https:\/\/cdn11.bigcommerce.com\/s-nojk69bs1u\/product_images\/attribute_rule_images\/75_source_1635961710.png","hash":"af854b8a78fb38d07d446f3043ba228db872916b7630b877e54d7551f5ceb835","private":0,"asset_source_date":"2021-11-03 18:59:46","asset_source":"75_source_1635961710.png","deleted_at":null,"created_at":"2021-11-03 18:59:46","updated_at":"2021-11-03 18:59:46","pivot":{"product_id":6,"asset_id":6,"id":6,"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":"2021-11-03 18:59:46","updated_at":"2021-11-03 18:59:46"}}],"assets_thumbnail":{"id":6,"asset_type_id":4,"uri_internal":"https:\/\/jasper-pimstorage-na-1.s3.amazonaws.com\/af854b8a78fb38d07d446f3043ba228db872916b7630b877e54d7551f5ceb835.png","uri_external":"https:\/\/cdn11.bigcommerce.com\/s-nojk69bs1u\/product_images\/attribute_rule_images\/75_source_1635961710.png","hash":"af854b8a78fb38d07d446f3043ba228db872916b7630b877e54d7551f5ceb835","private":0,"asset_source_date":"2021-11-03 18:59:46","asset_source":"75_source_1635961710.png","deleted_at":null,"created_at":"2021-11-03 18:59:46","updated_at":"2021-11-03 18:59:46","pivot":{"product_id":6,"asset_id":6,"id":6,"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":"2021-11-03 18:59:46","updated_at":"2021-11-03 18:59:46"}},"assets_non_thumbnail":[],"future_exclusions":[]},{"id":8,"brand_id":"1","created_at":"2021-11-03T18:59:47+00:00","updated_at":"2022-05-17T20:57:17+00:00","sku":"062-003","name":"Z-poxy 5 Minute Clear Epoxy Set Pack - (4 oz)","enabled":0,"is_visible":0,"is_bundle":0,"featured":0,"shipping_weight":"0.3000","shipping_override":"inherit","special_order":0,"generic_entities":[],"product_attributes":[{"id":3,"name":"Catalog Title","slug":"catalog_title","value":"Epoxy Glue Clear 5 minutes 4 oz Z-Poxy","webId":null,"sortOrder":0},{"id":5,"name":"Catalog Group Title","slug":"catalog_group_title","value":"Epoxy","webId":null,"sortOrder":1},{"id":4,"name":"Catalog Product Highlights","slug":"catalog_product_highlights","value":"<ul><li>Drying time: 5 minutes<\/li><li>Color: Clear<\/li><li>Volume: 4 oz Set<\/li><li>Lasting bond in areas subjected to high vibration<\/li><\/ul>","webId":null,"sortOrder":2}],"related_products":[],"categories":[{"id":6,"parent_id":153,"name":"Adhesives & Glue","slug":"\/adhesives-glue\/","fqn_cache":"Root > Pro Audio > Speaker Components > Adhesives & Glue"}],"channels":[{"id":1,"name":"HEDEL USA","enabled":1}],"barcodes":[],"active_prices":{"USD":{"base":"USD","cost":{"value":"0.00","starts_at":"2021-11-03T18:59:47+00:00","ends_at":null,"attributes":[]},"map":null,"msrp":{"value":"0.00","starts_at":"2021-11-03T18:59:47+00:00","ends_at":null,"attributes":[]},"sell_price":{"value":"0.00","starts_at":"2021-11-03T18:59:47+00:00","ends_at":null,"attributes":[]}}},"prices":[{"id":8,"batch_id":0,"created_at":"2021-11-03T18:59:47+00:00","updated_at":"2021-11-03T18:59:47+00:00","cost":"0.00","msrp":"0.00","sell_price":"0.00","booktype":"BIGCOMMERCE-IMPORT","price_book_code":"BIGCOMMERCE-IMPORT","starts_at":"2021-11-03T18:59:47+00:00","base":"USD","author":"PIM-IMPORT"}],"inventory":[{"id":5,"created_at":"2021-11-03T18:59:47+00:00","updated_at":"2021-11-03T18:59:47+00:00","location":"MIAMI","count_on_hand":0,"count_on_hold":0}],"children":[],"brand":{"id":1,"name":"Z-POXY","desc":null,"excluded":0,"exclusion_start_date":null,"exclusion_end_date":null,"exclusion_reason":null,"seo_search_keywords":"","seo_meta_desc":"","seo_meta_keywords":"","seo_title":"","created_at":"2021-11-03 18:59:43","updated_at":"2021-11-03 20:09:40","product_count":2},"parent":null,"tags":[],"assets":[{"id":7,"asset_type_id":4,"uri_internal":"https:\/\/jasper-pimstorage-na-1.s3.amazonaws.com\/a08abaa8152ecbda28da2a16e0f50ab4d2bafdaf6d585eb4f374196db65d7b95.png","uri_external":"https:\/\/cdn11.bigcommerce.com\/s-nojk69bs1u\/product_images\/attribute_rule_images\/77_source_1635964644.png","hash":"a08abaa8152ecbda28da2a16e0f50ab4d2bafdaf6d585eb4f374196db65d7b95","private":0,"asset_source_date":"2021-11-03 18:59:47","asset_source":"77_source_1635964644.png","deleted_at":null,"created_at":"2021-11-03 18:59:47","updated_at":"2021-11-03 18:59:47","pivot":{"product_id":8,"asset_id":7,"id":7,"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":"2021-11-03 18:59:47","updated_at":"2021-11-03 18:59:47"}}],"assets_thumbnail":{"id":7,"asset_type_id":4,"uri_internal":"https:\/\/jasper-pimstorage-na-1.s3.amazonaws.com\/a08abaa8152ecbda28da2a16e0f50ab4d2bafdaf6d585eb4f374196db65d7b95.png","uri_external":"https:\/\/cdn11.bigcommerce.com\/s-nojk69bs1u\/product_images\/attribute_rule_images\/77_source_1635964644.png","hash":"a08abaa8152ecbda28da2a16e0f50ab4d2bafdaf6d585eb4f374196db65d7b95","private":0,"asset_source_date":"2021-11-03 18:59:47","asset_source":"77_source_1635964644.png","deleted_at":null,"created_at":"2021-11-03 18:59:47","updated_at":"2021-11-03 18:59:47","pivot":{"product_id":8,"asset_id":7,"id":7,"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":"2021-11-03 18:59:47","updated_at":"2021-11-03 18:59:47"}},"assets_non_thumbnail":[],"future_exclusions":[]},{"id":9,"brand_id":"1","created_at":"2021-11-03T18:59:47+00:00","updated_at":"2022-04-29T05:43:08+00:00","sku":"062-002","name":"Z-poxy 5 Minute Clear Epoxy Set Pack - (8 oz)","enabled":1,"is_visible":1,"is_bundle":0,"featured":0,"desc_short":"5 MINUTE Z-POZY SYSTEM is specially formulated to bond fiberglass, wood, metal, plastic, etc. Produces a tough, permanent bond in just 5 minutes. Is resistant to shock and solvents; in non-shrinking and has excellent gap filling characteristics","desc_long":" QUICK SET Z-POXY is a premium two part epoxy adhesive. The 5 minute cure time means fast building and fast repairs. Vibration resistant and fuel proof, this epoxy is perfect for all types of hobbies and crafts. It does not get brittle with age and it's easy to mix: combine equal parts by volume. QUICK SET Z-POXY is handy to have at home for all types of fix-it jobs, woodworking, and furniture repair.","page_title":"Zap Glue - Z-poxy 2 Part 5 Minute Clear Epoxy Set Pack","meta_description":"5 MINUTE Z-POZY SYSTEM is specially formulated to bond fiberglass, wood, metal, plastic, etc. Produces a tough, permanent bond in just 5 minutes. Is resistant to shock and solvents; in non-shrinking and has excellent gap filling characteristics.","meta_keywords":"Epoxy, Pegante","shipping_weight":"0.5000","shipping_override":"inherit","special_order":0,"generic_entities":[],"product_attributes":[{"id":3,"name":"Catalog Title","slug":"catalog_title","value":"Epoxy Glue Clear 5 minutes 8 oz Z-Poxy","webId":null,"sortOrder":0},{"id":5,"name":"Catalog Group Title","slug":"catalog_group_title","value":"Epoxy","webId":null,"sortOrder":1},{"id":29,"name":"Epoxy Container Type","slug":"epoxy_container_type","value":"Bottle","webId":null,"sortOrder":1},{"id":4,"name":"Catalog Product Highlights","slug":"catalog_product_highlights","value":"<ul><li>Drying time: 5 minutes<\/li><li>Color: Clear<\/li><li>Volume: 8 oz Set<\/li><li>Lasting bond in areas subjected to high vibration<\/li><\/ul>","webId":null,"sortOrder":2},{"id":17,"name":"Epoxy Container Size","slug":"epoxy_container_size","value":"8 FL OZ (237ml)","webId":null,"sortOrder":2},{"id":15,"name":"Epoxy Begins to Harden","slug":"epoxy_begins_to_harden","value":"5 Min","webId":null,"sortOrder":3},{"id":34,"name":"Epoxy For Use On","slug":"epoxy_for_use_on","value":"Fiberglas, Wood, Metals, Plastics","webId":null,"sortOrder":7},{"id":35,"name":"Epoxy Color","slug":"epoxy_color","value":"Clear","webId":null,"sortOrder":8}],"related_products":[],"categories":[{"id":6,"parent_id":153,"name":"Adhesives & Glue","slug":"\/adhesives-glue\/","fqn_cache":"Root > Pro Audio > Speaker Components > Adhesives & Glue"}],"channels":[{"id":1,"name":"HEDEL USA","enabled":1}],"barcodes":[],"active_prices":{"USD":{"base":"USD","cost":{"value":"0.00","starts_at":"2021-11-03T18:59:47+00:00","ends_at":null,"attributes":[]},"map":null,"msrp":{"value":"0.00","starts_at":"2021-11-03T18:59:47+00:00","ends_at":null,"attributes":[]},"sell_price":{"value":"11.34","starts_at":"2021-11-03T18:59:47+00:00","ends_at":null,"attributes":[]}}},"prices":[{"id":9,"batch_id":0,"created_at":"2021-11-03T18:59:47+00:00","updated_at":"2021-11-03T18:59:47+00:00","cost":"0.00","msrp":"0.00","sell_price":"11.34","booktype":"BIGCOMMERCE-IMPORT","price_book_code":"BIGCOMMERCE-IMPORT","starts_at":"2021-11-03T18:59:47+00:00","base":"USD","author":"PIM-IMPORT"}],"inventory":[{"id":6,"created_at":"2021-11-03T18:59:47+00:00","updated_at":"2021-11-03T18:59:47+00:00","location":"MIAMI","count_on_hand":0,"count_on_hold":0}],"children":[],"brand":{"id":1,"name":"Z-POXY","desc":null,"excluded":0,"exclusion_start_date":null,"exclusion_end_date":null,"exclusion_reason":null,"seo_search_keywords":"","seo_meta_desc":"","seo_meta_keywords":"","seo_title":"","created_at":"2021-11-03 18:59:43","updated_at":"2021-11-03 20:09:40","product_count":2},"parent":null,"tags":[],"assets":[{"id":8,"asset_type_id":4,"uri_internal":"https:\/\/jasper-pimstorage-na-1.s3.amazonaws.com\/0b8af36fde686f3cae60fadba2a82e03adac8dafe1b240538db71aa55ffc11d8.png","uri_external":"https:\/\/cdn11.bigcommerce.com\/s-nojk69bs1u\/product_images\/attribute_rule_images\/78_source_1635964645.png","hash":"0b8af36fde686f3cae60fadba2a82e03adac8dafe1b240538db71aa55ffc11d8","private":0,"asset_source_date":"2021-11-03 18:59:47","asset_source":"78_source_1635964645.png","deleted_at":null,"created_at":"2021-11-03 18:59:47","updated_at":"2021-11-03 18:59:47","pivot":{"product_id":9,"asset_id":8,"id":8,"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":"2021-11-03 18:59:47","updated_at":"2021-11-03 18:59:47"}}],"assets_thumbnail":{"id":8,"asset_type_id":4,"uri_internal":"https:\/\/jasper-pimstorage-na-1.s3.amazonaws.com\/0b8af36fde686f3cae60fadba2a82e03adac8dafe1b240538db71aa55ffc11d8.png","uri_external":"https:\/\/cdn11.bigcommerce.com\/s-nojk69bs1u\/product_images\/attribute_rule_images\/78_source_1635964645.png","hash":"0b8af36fde686f3cae60fadba2a82e03adac8dafe1b240538db71aa55ffc11d8","private":0,"asset_source_date":"2021-11-03 18:59:47","asset_source":"78_source_1635964645.png","deleted_at":null,"created_at":"2021-11-03 18:59:47","updated_at":"2021-11-03 18:59:47","pivot":{"product_id":9,"asset_id":8,"id":8,"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":"2021-11-03 18:59:47","updated_at":"2021-11-03 18:59:47"}},"assets_non_thumbnail":[],"future_exclusions":[]},{"id":10,"created_at":"2021-11-03T22:12:42+00:00","updated_at":"2022-04-15T01:23:11+00:00","sku":"013-014","name":"HD15 VGA SVGA Male to Male Gender Changer Coupler Adapter","product_url":"\/hd15-vga-svga-male-to-male-gender-changer-coupler-adapter\/","enabled":0,"is_visible":0,"is_bundle":0,"featured":0,"desc_long":"<ul>\n<li>Converts VGA (HD15) male connector into a VGA (HD15) female<\/li>\n<li>Easy to use and install.<\/li>\n<li>Used with Monitors, Projectors, VGA Splitters, KVM and more.<\/li>\n<li>Allow you to couple two VGA cables together that have male connectors<\/li>\n<\/ul><br><br><p>If you have a cable with a VGA (HD15) male connector, this adapter would change that into a VGA (HD15) female. This adapter will also allow you to couple two VGA cables together that have male connectors.<\/p>","shipping_width":"0.00","shipping_height":"0.00","shipping_length":"0.00","shipping_weight":"0.0000","shipping_override":"inherit","shipping_price":"0.00","special_order":0,"max_order_quantity":0,"generic_entities":[],"product_attributes":[{"id":3,"name":"Catalog Title","slug":"catalog_title","value":"HD15 VGA SVGA Male to Male Gender Changer Coupler Adapter","webId":null,"sortOrder":0},{"id":4,"name":"Catalog Product Highlights","slug":"catalog_product_highlights","value":"<ul><li><ul> <li>The VGA male to male coupler extends the length of two short VGA cables<\/li> <li>Convenient VGA inline couplers for use at home and carry on the road for office monitor or projector connections<\/li> <li>Easy to install, Plug and Play<\/li> <\/ul><\/li><\/ul>","webId":null,"sortOrder":2}],"related_products":[],"categories":[],"channels":[{"id":1,"name":"HEDEL USA","enabled":1}],"barcodes":[{"id":1,"type":"UPC-A","barcode":"722713838304"}],"active_prices":{"USD":{"base":"USD","cost":{"value":"0.00","starts_at":"2021-11-03T22:12:43+00:00","ends_at":null,"attributes":[]},"map":null,"msrp":{"value":"0.00","starts_at":"2021-11-03T22:12:43+00:00","ends_at":null,"attributes":[]},"sell_price":{"value":"0.50","starts_at":"2021-11-03T22:12:43+00:00","ends_at":null,"attributes":[]}}},"prices":[{"id":10,"batch_id":0,"created_at":"2021-11-03T22:12:43+00:00","updated_at":"2021-11-03T22:12:43+00:00","cost":"0.00","msrp":"0.00","sell_price":"0.50","booktype":"BIGCOMMERCE-IMPORT","price_book_code":"BIGCOMMERCE-IMPORT","starts_at":"2021-11-03T22:12:43+00:00","base":"USD","author":"PIM-IMPORT"}],"inventory":[{"id":7,"created_at":"2021-11-03T22:12:43+00:00","updated_at":"2021-11-03T22:12:43+00:00","location":"MIAMI","count_on_hand":0,"count_on_hold":0}],"children":[],"brand":null,"parent":null,"tags":[],"assets":[{"id":10,"asset_type_id":4,"uri_internal":"https:\/\/jasper-pimstorage-na-1.s3.amazonaws.com\/4f5c1f942afb142a1f1a94684d225d7ef1d96bc1cfb35c5d1b2ff0e1773313cc.png","uri_external":"https:\/\/cdn11.bigcommerce.com\/s-nojk69bs1u\/products\/148\/images\/430\/013-014__97278.1635975984.386.513.png?c=1","hash":"4f5c1f942afb142a1f1a94684d225d7ef1d96bc1cfb35c5d1b2ff0e1773313cc","private":0,"asset_source_date":"2021-11-03 22:12:44","asset_source":"013-014__97278.1635975984.386.513.png?c=1","deleted_at":null,"created_at":"2021-11-03 22:12:44","updated_at":"2021-11-03 22:12:44","pivot":{"product_id":10,"asset_id":10,"id":10,"web_id":null,"thumbnail":1,"visible":1,"dim":0,"sort_order":0,"name":null,"desc":"","alttext":null,"type":null,"deleted_at":null,"created_at":"2021-11-03 22:12:44","updated_at":"2021-11-03 22:12:44"}}],"assets_thumbnail":{"id":10,"asset_type_id":4,"uri_internal":"https:\/\/jasper-pimstorage-na-1.s3.amazonaws.com\/4f5c1f942afb142a1f1a94684d225d7ef1d96bc1cfb35c5d1b2ff0e1773313cc.png","uri_external":"https:\/\/cdn11.bigcommerce.com\/s-nojk69bs1u\/products\/148\/images\/430\/013-014__97278.1635975984.386.513.png?c=1","hash":"4f5c1f942afb142a1f1a94684d225d7ef1d96bc1cfb35c5d1b2ff0e1773313cc","private":0,"asset_source_date":"2021-11-03 22:12:44","asset_source":"013-014__97278.1635975984.386.513.png?c=1","deleted_at":null,"created_at":"2021-11-03 22:12:44","updated_at":"2021-11-03 22:12:44","pivot":{"product_id":10,"asset_id":10,"id":10,"web_id":null,"thumbnail":1,"visible":1,"dim":0,"sort_order":0,"name":null,"desc":"","alttext":null,"type":null,"deleted_at":null,"created_at":"2021-11-03 22:12:44","updated_at":"2021-11-03 22:12:44"}},"assets_non_thumbnail":[],"future_exclusions":[]},{"id":11,"brand_id":"5","created_at":"2021-11-03T22:12:43+00:00","updated_at":"2022-02-15T21:46:58+00:00","sku":"727-204","name":"Small Plastic Speaker Handles","product_url":"\/small-plastic-speaker-handles\/","enabled":1,"is_visible":1,"is_bundle":0,"featured":0,"desc_short":"Excellent quality plastic handle, ideal for small cabins","desc_long":"Excellent quality plastic handle, ideal for small cabins<br><br>\n<ul><li>Speaker Handle<\/li><li>Dimens: 133x83mm<\/li><\/ul>","page_title":"Small Plastic Speaker Handles","meta_description":"Excellent quality plastic handle, ideal for small cabins","meta_keywords":"Asa, Handle, Agarradera","shipping_width":"0.00","shipping_height":"0.00","shipping_length":"0.00","shipping_weight":"0.0000","shipping_override":"inherit","shipping_price":"0.00","special_order":0,"max_order_quantity":0,"generic_entities":[],"product_attributes":[{"id":3,"name":"Catalog Title","slug":"catalog_title","value":"Speaker Handles 133x83mm","webId":null,"sortOrder":0},{"id":20,"name":"Handle Color","slug":"color","value":"Black","webId":null,"sortOrder":0},{"id":5,"name":"Catalog Group Title","slug":"catalog_group_title","value":"Speaker Handles","webId":null,"sortOrder":1},{"id":19,"name":"Handle Material","slug":"material","value":"ABS Plastic","webId":null,"sortOrder":1},{"id":4,"name":"Catalog Product Highlights","slug":"catalog_product_highlights","value":"<ul><li>Speaker Handle<\/li><li>Dimens: 133x83mm<\/li><\/ul>","webId":null,"sortOrder":2},{"id":36,"name":"Handle Height","slug":"handle_height","value":"136.5 mm - 5 \u00b3\/\u2088 in","webId":null,"sortOrder":2},{"id":37,"name":"Handle Width","slug":"handle_width","value":"86 mm - 3 \u00b3\/\u2088 in","webId":null,"sortOrder":3}],"related_products":[],"categories":[{"id":12,"parent_id":153,"name":"Speaker Handles","slug":"\/speaker-handles\/","fqn_cache":"Root > Pro Audio > Speaker Components > Speaker Handles"}],"channels":[{"id":1,"name":"HEDEL USA","enabled":1}],"barcodes":[{"id":2,"type":"UPC-A","barcode":"731938952030"}],"active_prices":{"USD":{"base":"USD","cost":{"value":"0.00","starts_at":"2021-11-03T22:12:43+00:00","ends_at":null,"attributes":[]},"map":null,"msrp":{"value":"0.00","starts_at":"2021-11-03T22:12:43+00:00","ends_at":null,"attributes":[]},"sell_price":{"value":"0.17","starts_at":"2021-11-03T22:12:43+00:00","ends_at":null,"attributes":[]}}},"prices":[{"id":11,"batch_id":0,"created_at":"2021-11-03T22:12:43+00:00","updated_at":"2021-11-03T22:12:43+00:00","cost":"0.00","msrp":"0.00","sell_price":"0.17","booktype":"BIGCOMMERCE-IMPORT","price_book_code":"BIGCOMMERCE-IMPORT","starts_at":"2021-11-03T22:12:43+00:00","base":"USD","author":"PIM-IMPORT"}],"inventory":[{"id":8,"created_at":"2021-11-03T22:12:43+00:00","updated_at":"2021-11-03T22:12:43+00:00","location":"MIAMI","count_on_hand":0,"count_on_hold":0}],"children":[],"brand":{"id":5,"name":"HEDEL","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":null,"updated_at":"2021-11-04 12:33:12","product_count":100},"parent":null,"tags":[],"assets":[{"id":15,"asset_type_id":4,"uri_internal":"https:\/\/jasper-pimstorage-na-1.s3.amazonaws.com\/ae41a851071359e7516dd2b63bb81c9bf819b170c6773b8930ec84688f28a0b9.png","uri_external":"https:\/\/cdn11.bigcommerce.com\/s-nojk69bs1u\/products\/149\/images\/434\/727-204__34197.1635976958.386.513.png?c=1","hash":"ae41a851071359e7516dd2b63bb81c9bf819b170c6773b8930ec84688f28a0b9","private":0,"asset_source_date":"2021-11-03 22:12:48","asset_source":"727-204__34197.1635976958.386.513.png?c=1","deleted_at":null,"created_at":"2021-11-03 22:12:48","updated_at":"2021-11-03 22:12:48","pivot":{"product_id":11,"asset_id":15,"id":15,"web_id":null,"thumbnail":1,"visible":1,"dim":0,"sort_order":0,"name":null,"desc":"","alttext":null,"type":null,"deleted_at":null,"created_at":"2021-11-03 22:12:48","updated_at":"2021-11-03 22:12:48"}}],"assets_thumbnail":{"id":15,"asset_type_id":4,"uri_internal":"https:\/\/jasper-pimstorage-na-1.s3.amazonaws.com\/ae41a851071359e7516dd2b63bb81c9bf819b170c6773b8930ec84688f28a0b9.png","uri_external":"https:\/\/cdn11.bigcommerce.com\/s-nojk69bs1u\/products\/149\/images\/434\/727-204__34197.1635976958.386.513.png?c=1","hash":"ae41a851071359e7516dd2b63bb81c9bf819b170c6773b8930ec84688f28a0b9","private":0,"asset_source_date":"2021-11-03 22:12:48","asset_source":"727-204__34197.1635976958.386.513.png?c=1","deleted_at":null,"created_at":"2021-11-03 22:12:48","updated_at":"2021-11-03 22:12:48","pivot":{"product_id":11,"asset_id":15,"id":15,"web_id":null,"thumbnail":1,"visible":1,"dim":0,"sort_order":0,"name":null,"desc":"","alttext":null,"type":null,"deleted_at":null,"created_at":"2021-11-03 22:12:48","updated_at":"2021-11-03 22:12:48"}},"assets_non_thumbnail":[],"future_exclusions":[]},{"id":12,"brand_id":"5","created_at":"2021-11-03T22:12:43+00:00","updated_at":"2022-02-15T21:45:48+00:00","sku":"727-203","name":"Round Plastic Speaker Cabinet Handle","product_url":"\/speaker-handles-210x165mm\/","enabled":1,"is_visible":1,"is_bundle":0,"featured":0,"desc_short":"A unique appearance and simple installation make this round handle for speaker cabinets a winner.","desc_long":"A unique appearance and simple installation make this round handle for speaker cabinets a winner.<br><br>\n<ul><li>Speaker Handle<\/li><li>Dimens: 210x165mm<\/li><\/ul>","page_title":"Speaker Cabinet Handles 210x165mm","meta_description":"A unique appearance and simple installation make this round handle for speaker cabinets a winner.","shipping_width":"0.00","shipping_height":"0.00","shipping_length":"0.00","shipping_weight":"0.4274","shipping_override":"inherit","shipping_price":"0.00","special_order":0,"max_order_quantity":0,"generic_entities":[],"product_attributes":[{"id":20,"name":"Handle Color","slug":"color","value":"Black","webId":null,"sortOrder":0},{"id":3,"name":"Catalog Title","slug":"catalog_title","value":"Speaker Handles 210x165mm","webId":null,"sortOrder":0},{"id":19,"name":"Handle Material","slug":"material","value":"ABS Plastic","webId":null,"sortOrder":1},{"id":5,"name":"Catalog Group Title","slug":"catalog_group_title","value":"Speaker Handles","webId":null,"sortOrder":1},{"id":36,"name":"Handle Height","slug":"handle_height","value":"190 mm - 7 \u00b9\/\u2082 in","webId":null,"sortOrder":2},{"id":4,"name":"Catalog Product Highlights","slug":"catalog_product_highlights","value":"<ul><li>Speaker Handle<\/li><li>Dimens: 210x165mm<\/li><\/ul>","webId":null,"sortOrder":2},{"id":37,"name":"Handle Width","slug":"handle_width","value":"190 mm - 7 \u00b9\/\u2082 in","webId":null,"sortOrder":3}],"related_products":[],"categories":[{"id":12,"parent_id":153,"name":"Speaker Handles","slug":"\/speaker-handles\/","fqn_cache":"Root > Pro Audio > Speaker Components > Speaker Handles"}],"channels":[{"id":1,"name":"HEDEL USA","enabled":1}],"barcodes":[{"id":3,"type":"UPC-A","barcode":"731938943069"}],"active_prices":{"USD":{"base":"USD","cost":{"value":"0.00","starts_at":"2021-11-03T22:12:43+00:00","ends_at":null,"attributes":[]},"map":null,"msrp":{"value":"0.00","starts_at":"2021-11-03T22:12:43+00:00","ends_at":null,"attributes":[]},"sell_price":{"value":"0.62","starts_at":"2021-11-03T22:12:43+00:00","ends_at":null,"attributes":[]}}},"prices":[{"id":12,"batch_id":0,"created_at":"2021-11-03T22:12:43+00:00","updated_at":"2021-11-03T22:12:43+00:00","cost":"0.00","msrp":"0.00","sell_price":"0.62","booktype":"BIGCOMMERCE-IMPORT","price_book_code":"BIGCOMMERCE-IMPORT","starts_at":"2021-11-03T22:12:43+00:00","base":"USD","author":"PIM-IMPORT"}],"inventory":[{"id":9,"created_at":"2021-11-03T22:12:43+00:00","updated_at":"2021-11-03T22:12:43+00:00","location":"MIAMI","count_on_hand":0,"count_on_hold":0}],"children":[],"brand":{"id":5,"name":"HEDEL","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":null,"updated_at":"2021-11-04 12:33:12","product_count":100},"parent":null,"tags":[],"assets":[{"id":12,"asset_type_id":4,"uri_internal":"https:\/\/jasper-pimstorage-na-1.s3.amazonaws.com\/1738cfe8e69d81b4a5126e943bf4f16becfe0e3bb0f7087638395e6ca8fabae8.png","uri_external":"https:\/\/cdn11.bigcommerce.com\/s-nojk69bs1u\/products\/150\/images\/432\/727-203__52202.1635976958.386.513.png?c=1","hash":"1738cfe8e69d81b4a5126e943bf4f16becfe0e3bb0f7087638395e6ca8fabae8","private":0,"asset_source_date":"2021-11-03 22:12:46","asset_source":"727-203__52202.1635976958.386.513.png?c=1","deleted_at":null,"created_at":"2021-11-03 22:12:46","updated_at":"2021-11-03 22:12:46","pivot":{"product_id":12,"asset_id":12,"id":12,"web_id":null,"thumbnail":1,"visible":1,"dim":0,"sort_order":0,"name":null,"desc":"","alttext":null,"type":null,"deleted_at":null,"created_at":"2021-11-03 22:12:46","updated_at":"2021-11-03 22:12:46"}}],"assets_thumbnail":{"id":12,"asset_type_id":4,"uri_internal":"https:\/\/jasper-pimstorage-na-1.s3.amazonaws.com\/1738cfe8e69d81b4a5126e943bf4f16becfe0e3bb0f7087638395e6ca8fabae8.png","uri_external":"https:\/\/cdn11.bigcommerce.com\/s-nojk69bs1u\/products\/150\/images\/432\/727-203__52202.1635976958.386.513.png?c=1","hash":"1738cfe8e69d81b4a5126e943bf4f16becfe0e3bb0f7087638395e6ca8fabae8","private":0,"asset_source_date":"2021-11-03 22:12:46","asset_source":"727-203__52202.1635976958.386.513.png?c=1","deleted_at":null,"created_at":"2021-11-03 22:12:46","updated_at":"2021-11-03 22:12:46","pivot":{"product_id":12,"asset_id":12,"id":12,"web_id":null,"thumbnail":1,"visible":1,"dim":0,"sort_order":0,"name":null,"desc":"","alttext":null,"type":null,"deleted_at":null,"created_at":"2021-11-03 22:12:46","updated_at":"2021-11-03 22:12:46"}},"assets_non_thumbnail":[],"future_exclusions":[]},{"id":13,"brand_id":"5","created_at":"2021-11-03T22:12:43+00:00","updated_at":"2022-02-15T21:44:53+00:00","sku":"727-200","name":"Flush Surface Mounted Spring Loaded Holders PA Flip Black Steel Handle","product_url":"\/speaker-handles-Flush-Surface\/","enabled":1,"is_visible":1,"is_bundle":0,"featured":0,"desc_short":"This metal handle does not require any cutting and is constructed of black reinforced steel, a rubberized grip and a spring mechanism that allows it to retract and hold a flat start position.","desc_long":"<p>This metal handle does not require any cutting and is constructed of black reinforced steel, a rubberized grip and a spring mechanism that allows it to retract and hold a flat start position.<br><\/p><p><br><\/p>\n<ul><li>Speaker Handle<\/li><li>Dimens: 14x8.5cm<\/li><\/ul>","page_title":"Flush Surface Mounted Spring Loaded Holders PA Flip Black Metal Handle","meta_description":"Speaker Cabinet Handles - Flush Surface Mounted Spring Loaded Holders PA Flip Black Metal Handle 5 1\/2\" X 1 5\/8 in","meta_keywords":"speaker, handles, parts","shipping_width":"0.00","shipping_height":"0.00","shipping_length":"0.00","shipping_weight":"0.5000","shipping_override":"inherit","shipping_price":"0.00","special_order":0,"max_order_quantity":0,"generic_entities":[],"product_attributes":[{"id":3,"name":"Catalog Title","slug":"catalog_title","value":"Speaker Handles 14x8.5cm","webId":null,"sortOrder":0},{"id":20,"name":"Handle Color","slug":"color","value":"Black","webId":null,"sortOrder":0},{"id":5,"name":"Catalog Group Title","slug":"catalog_group_title","value":"Speaker Handles","webId":null,"sortOrder":1},{"id":19,"name":"Handle Material","slug":"material","value":"Steel","webId":null,"sortOrder":1},{"id":36,"name":"Handle Height","slug":"handle_height","value":"42 mm - 1 \u2075\/\u2088 in","webId":null,"sortOrder":2},{"id":4,"name":"Catalog Product Highlights","slug":"catalog_product_highlights","value":"<ul><li>Speaker Handle<\/li><li>Dimens: 14x8.5cm<\/li><\/ul>","webId":null,"sortOrder":2},{"id":37,"name":"Handle Width","slug":"handle_width","value":"140 mm - 5 \u00b9\/\u2082 in","webId":null,"sortOrder":3}],"related_products":[],"categories":[{"id":12,"parent_id":153,"name":"Speaker Handles","slug":"\/speaker-handles\/","fqn_cache":"Root > Pro Audio > Speaker Components > Speaker Handles"}],"channels":[{"id":1,"name":"HEDEL USA","enabled":1}],"barcodes":[{"id":4,"type":"UPC-A","barcode":"744633420995"}],"active_prices":{"USD":{"base":"USD","cost":{"value":"0.00","starts_at":"2021-11-03T22:12:43+00:00","ends_at":null,"attributes":[]},"map":null,"msrp":{"value":"0.00","starts_at":"2021-11-03T22:12:43+00:00","ends_at":null,"attributes":[]},"sell_price":{"value":"1.24","starts_at":"2021-11-03T22:12:43+00:00","ends_at":null,"attributes":[]}}},"prices":[{"id":13,"batch_id":0,"created_at":"2021-11-03T22:12:43+00:00","updated_at":"2021-11-03T22:12:43+00:00","cost":"0.00","msrp":"0.00","sell_price":"1.24","booktype":"BIGCOMMERCE-IMPORT","price_book_code":"BIGCOMMERCE-IMPORT","starts_at":"2021-11-03T22:12:43+00:00","base":"USD","author":"PIM-IMPORT"}],"inventory":[{"id":10,"created_at":"2021-11-03T22:12:43+00:00","updated_at":"2021-11-03T22:12:43+00:00","location":"MIAMI","count_on_hand":0,"count_on_hold":0}],"children":[],"brand":{"id":5,"name":"HEDEL","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":null,"updated_at":"2021-11-04 12:33:12","product_count":100},"parent":null,"tags":[],"assets":[{"id":13,"asset_type_id":4,"uri_internal":"https:\/\/jasper-pimstorage-na-1.s3.amazonaws.com\/bd312dc21cef10aac4bde1d7c313d84a39ecd1272d7eac1dca88b52cd957ed42.png","uri_external":"https:\/\/cdn11.bigcommerce.com\/s-nojk69bs1u\/products\/151\/images\/433\/727-200__84520.1635976958.386.513.png?c=1","hash":"bd312dc21cef10aac4bde1d7c313d84a39ecd1272d7eac1dca88b52cd957ed42","private":0,"asset_source_date":"2021-11-03 22:12:47","asset_source":"727-200__84520.1635976958.386.513.png?c=1","deleted_at":null,"created_at":"2021-11-03 22:12:47","updated_at":"2021-11-03 22:12:47","pivot":{"product_id":13,"asset_id":13,"id":13,"web_id":null,"thumbnail":1,"visible":1,"dim":0,"sort_order":0,"name":null,"desc":"","alttext":null,"type":null,"deleted_at":null,"created_at":"2021-11-03 22:12:47","updated_at":"2021-11-03 22:12:47"}}],"assets_thumbnail":{"id":13,"asset_type_id":4,"uri_internal":"https:\/\/jasper-pimstorage-na-1.s3.amazonaws.com\/bd312dc21cef10aac4bde1d7c313d84a39ecd1272d7eac1dca88b52cd957ed42.png","uri_external":"https:\/\/cdn11.bigcommerce.com\/s-nojk69bs1u\/products\/151\/images\/433\/727-200__84520.1635976958.386.513.png?c=1","hash":"bd312dc21cef10aac4bde1d7c313d84a39ecd1272d7eac1dca88b52cd957ed42","private":0,"asset_source_date":"2021-11-03 22:12:47","asset_source":"727-200__84520.1635976958.386.513.png?c=1","deleted_at":null,"created_at":"2021-11-03 22:12:47","updated_at":"2021-11-03 22:12:47","pivot":{"product_id":13,"asset_id":13,"id":13,"web_id":null,"thumbnail":1,"visible":1,"dim":0,"sort_order":0,"name":null,"desc":"","alttext":null,"type":null,"deleted_at":null,"created_at":"2021-11-03 22:12:47","updated_at":"2021-11-03 22:12:47"}},"assets_non_thumbnail":[],"future_exclusions":[]}] |
Connecting to Perfion
EasyCatalog provides a direct connection to Perfion without the need to export data files. With the Enterprise Data Provider installed, the script which handles the connection can be installed from the File->New->EasyCatalog Panel->Manage Enterprise Data Providers… menu. After selecting this you should see Perfion API listed as one of the installable scripts. Select it and […]
Managing Enterprise Data Provider
EasyCatalog allows access to third party systems, such as PIM or DAM systems, via Custom Data Providers. The Enterprise Data Provider allows these scripts to installed, updated or removed using the “File->EasyCatalog->Manage Enterprise Data Providers…” menu option. Publicly available scripts are hosted by us in a central location. To download and install a provider, click […]
Support for Custom Salsify Channels
For custom channels, EasyCatalog allows the creation of scripts that take channel data and turn into a record set which EasyCatalog can load. Scripts are written in Lua. They take raw channel JSON and return a RECORDSET object. The name of the file should match the name of the channel, with a.lua extension. Scripts should […]
Custom Data Providers
Overview Through optional modules EasyCatalog provides a number of data providers (ODBC, XML, Excel, CSV, Sqlite). The Enterprise Data Provider also provides additional connections to a number of third party systems. For connections to other systems, such as JSON or REST APIs, the Enterprise Data Provider enables the ability to create custom data providers. Creating […]
EasyCatalog Server and Salsify
The Enterprise Data Provider supports direct connections to a Salsify Data Sources. The normal login procedure uses OAuth based authentication, which uses a browser to login to Salsify. InDesign Server does not allow user interaction, so an alternative method method is supported where a static ‘access token‘ can be used as part of the data source […]
