List products (per location)
...
POST /apps/any/queries/read__qpt__list_products {'qp_loc_entity_id': 'LOCATION_ID'}
POST /apps/any/queries/read__qpt__list_products
...
{'product_id': 'PRODUCT_ID', 'qp_loc_entity_id
...
': 'LOCATION_ID'}
Parameters
qp_loc_entity_id - location_id
qp_product_id - if only 1 product is needed
POST /apps/any/queries/read__qpt__list_products
POST /apps/any/queries/read__qpt__list_products {'limit': '2
...
', 'qp_loc_entity_id': '4'}
Response
...
| Code Block | ||
|---|---|---|
| ||
{
"objects": [
{
"category": "Reptile Supplies",
"cheapest_supplier": "Animal Supply Co",
"dinv_on_hand": 0.0,
"ent_name": "Zoo Med Laboratories",
"fifo_cost": null,
"first_barcode": "097612391107",
"invtry_qty": 0.0,
"last_inventory": "2023-11-09 15:43:52.503033-05:00",
"last_movement": null,
"last_purchase": null,
"last_sale": null,
"loc_entity_id": 4,
"loc_report_code": "PS",
"location_last_inventory": "2023-11-09 15:43:52.503033-05:00",
"location_last_movement": null,
"location_last_purchase": null,
"location_last_sale": null,
"mfg_brand_id": 248,
"mfgbr_brand_name": "Zoo Med",
"mfgbr_ent_name": "Zoo Med Laboratories",
"mfgbr_entity_id": 1342,
"on_order_qty": 0.0,
"plnk_name": null,
"prdmed_file_ids": [],
"prdpr_actual_margin": 0.5011119347664937,
"prdpr_actual_markup": 2.0044576523031203,
"prdpr_cost": 6.73,
"prdpr_margin": 0.5011119347664937,
"prdpr_markup": 2.0,
"prdpr_price": 13.49,
"prdpr_uses_markup": true,
"prdvar_base_name": null,
"prdvar_slug": null,
"prdvar_suggested_name": null,
"price_link_id": null,
"prlocs_bin_location": null,
"prlocs_excluded_delivery_types": [],
"prlocs_is_saleable_as_modifier_only": false,
"prlocs_last_change": null,
"prlocs_last_inventory": "2023-11-09 15:43:52.503033-05:00",
"prlocs_last_movement": null,
"prlocs_last_purchase": null,
"prlocs_last_sale": null,
"prlocs_replaced_by_product_id": null,
"prlocs_stocking_rule": "Stock",
"prlstat_last_purchase": null,
"prlstat_recent_quantity_used": null,
"prod_barcode": "097612391107",
"prod_barcodes": [
"097612391107"
],
"prod_category": "Reptile Supplies",
"prod_cheapest_auto_order_supplier": "Animal Supply Co",
"prod_cheapest_supplier": "Animal Supply Co",
"prod_has_image": true,
"prod_image_count": 1,
"prod_image_file_ids": [
14634
],
"prod_ingredients": [],
"prod_is_available_on_web": true,
"prod_is_marked_for_deletion": false,
"prod_is_mfd": false,
"prod_last_change": null,
"prod_last_inventory": "2023-11-09 15:43:52.503033-05:00",
"prod_last_movement": null,
"prod_last_purchase": null,
"prod_last_sale": null,
"prod_long_description": "Zoo Med Moonlite Heat Bulb 100 Watt",
"prod_marketing_message": null,
"prod_media_count": 1,
"prod_media_file_ids": [
14634
],
"prod_minimal_selling_price": null,
"prod_minimum_advertised_price": null,
"prod_msrp": null,
"prod_name": "Zoo Med Moonlite Heat Bulb 100 Watt",
"prod_nutritional": {},
"prod_product_category_id": 156,
"prod_product_sub_category_id": 514,
"prod_product_variation_id": null,
"prod_slug": "zoo-med-moonlite-heat-bulb-100w",
"prod_subcategory": "Bulbs",
"prod_tags": [],
"prod_timestamp": "2023-11-09 20:44:06.019179",
"prod_type": "Regular",
"prod_var_field1": null,
"prod_var_field10": null,
"prod_var_field11": null,
"prod_var_field12": null,
"prod_var_field13": null,
"prod_var_field14": null,
"prod_var_field15": null,
"prod_var_field16": null,
"prod_var_field17": null,
"prod_var_field18": null,
"prod_var_field19": null,
"prod_var_field2": null,
"prod_var_field20": null,
"prod_var_field3": null,
"prod_var_field4": null,
"prod_var_field5": null,
"prod_var_field6": null,
"prod_var_field7": null,
"prod_var_field8": null,
"prod_var_field9": null,
"prod_var_fields": null,
"prod_video_count": 0,
"prod_video_file_ids": null,
"prod_web_description": "Zoo Med Moonlite Heat Bulb 100 Watt",
"prod_web_info": null,
"prodss_website_order": null,
"product_id": 19725,
"product_location_settings_id": 16581,
"product_media_count": 0,
"product_price_id": 9155,
"product_pricing_group_id": 1,
"sub_category": "Bulbs",
"warnings": {}
},
{
"category": "Cat Supplies",
"cheapest_supplier": "Frontier Distributing Inc",
"dinv_on_hand": 0.0,
"ent_name": null,
"fifo_cost": null,
"first_barcode": "850010391823",
"invtry_qty": 0.0,
"last_inventory": "2023-11-07 17:52:25.763190-05:00",
"last_movement": null,
"last_purchase": null,
"last_sale": "2023-11-01 14:53:34.975099-04:00",
"loc_entity_id": 4,
"loc_report_code": "PS",
"location_last_inventory": "2023-11-07 17:52:25.763190-05:00",
"location_last_movement": null,
"location_last_purchase": null,
"location_last_sale": "2023-11-01 14:53:34.975099-04:00",
"mfg_brand_id": null,
"mfgbr_brand_name": null,
"mfgbr_ent_name": null,
"mfgbr_entity_id": null,
"on_order_qty": 0.0,
"plnk_name": null,
"prdmed_file_ids": [],
"prdpr_actual_margin": 0.5023832221163013,
"prdpr_actual_markup": 2.0095785440613025,
"prdpr_cost": 5.22,
"prdpr_margin": 0.5023832221163013,
"prdpr_markup": 2.0,
"prdpr_price": 10.49,
"prdpr_uses_markup": true,
"prdvar_base_name": null,
"prdvar_slug": null,
"prdvar_suggested_name": null,
"price_link_id": null,
"prlocs_bin_location": null,
"prlocs_excluded_delivery_types": [],
"prlocs_is_saleable_as_modifier_only": false,
"prlocs_last_change": "2023-11-07 17:46:47.209294-05:00",
"prlocs_last_inventory": "2023-11-07 17:52:25.763190-05:00",
"prlocs_last_movement": null,
"prlocs_last_purchase": null,
"prlocs_last_sale": "2023-11-01 14:53:34.975099-04:00",
"prlocs_replaced_by_product_id": null,
"prlocs_stocking_rule": "Stock",
"prlstat_last_purchase": null,
"prlstat_recent_quantity_used": 1.0,
"prod_barcode": "850010391823",
"prod_barcodes": [
"850010391823",
"00850010391823"
],
"prod_category": "Cat Supplies",
"prod_cheapest_auto_order_supplier": "Frontier Distributing Inc",
"prod_cheapest_supplier": "Frontier Distributing Inc",
"prod_has_image": true,
"prod_image_count": 1,
"prod_image_file_ids": [
14591
],
"prod_ingredients": [],
"prod_is_available_on_web": true,
"prod_is_marked_for_deletion": false,
"prod_is_mfd": false,
"prod_last_change": "2023-11-07 17:46:47.209294-05:00",
"prod_last_inventory": "2023-11-07 17:52:25.763190-05:00",
"prod_last_movement": null,
"prod_last_purchase": null,
"prod_last_sale": "2023-11-01 14:53:34.975099-04:00",
"prod_long_description": "Frozen Complete Raw Chicken Entrees - 8oz Deli Cup",
"prod_marketing_message": "Boss Cat Raw Frozen Chicken Entrees 8 Oz Deli Cup",
"prod_media_count": 1,
"prod_media_file_ids": [
14591
],
"prod_minimal_selling_price": null,
"prod_minimum_advertised_price": null,
"prod_msrp": 8.99,
"prod_name": "Frozen Complete Raw Chicken Entrees - 8oz Deli Cup",
"prod_nutritional": {},
"prod_product_category_id": 158,
"prod_product_sub_category_id": null,
"prod_product_variation_id": null,
"prod_slug": "frozen-complete-raw-chicken-entrees-8oz-deli-cup",
"prod_subcategory": null,
"prod_tags": [],
"prod_timestamp": "2023-11-01 18:44:42.692964",
"prod_type": "Regular",
"prod_var_field1": null,
"prod_var_field10": null,
"prod_var_field11": null,
"prod_var_field12": null,
"prod_var_field13": null,
"prod_var_field14": null,
"prod_var_field15": null,
"prod_var_field16": null,
"prod_var_field17": null,
"prod_var_field18": null,
"prod_var_field19": null,
"prod_var_field2": null,
"prod_var_field20": null,
"prod_var_field3": null,
"prod_var_field4": null,
"prod_var_field5": null,
"prod_var_field6": null,
"prod_var_field7": null,
"prod_var_field8": null,
"prod_var_field9": null,
"prod_var_fields": null,
"prod_video_count": 0,
"prod_video_file_ids": null,
"prod_web_description": "Frozen Complete Raw Chicken Entrees - 8oz Deli Cup",
"prod_web_info": null,
"prodss_website_order": 1.9995088408644401,
"product_id": 19722,
"product_location_settings_id": 16572,
"product_media_count": 0,
"product_price_id": 9149,
"product_pricing_group_id": 1,
"sub_category": null,
"warnings": {}
}
],
"total": 3698
} |
POST /apps/any/queries/read__qpt__list_products {
...
'
...
product_id': '19725', 'qp_loc_entity_id': '4'}
Response
...
| Code Block | ||
|---|---|---|
| ||
{
"objects": [
{
"category": "Pet Services",
"cheapest_supplier": null,
"dinv_on_hand": 2.0,
"ent_name": null,
"fifo_cost": null,
"first_barcode": "CP_REG",
"invtry_qty": 2.0,
"last_inventory": "2023-11-07 17:52:25.763190-05:00",
"last_movement": null,
"last_purchase": null,
"last_sale": "2023-07-11 16:18:41.023045-04:00",
"loc_entity_id": 4,
"loc_report_code": "PS",
"location_last_inventory": "2023-11-07 17:52:25.763190-05:00",
"location_last_movement": null,
"location_last_purchase": null,
"location_last_sale": "2023-07-11 16:18:41.023045-04:00",
"mfg_brand_id": null,
"mfgbr_brand_name": null,
"mfgbr_ent_name": null,
"mfgbr_entity_id": null,
"on_order_qty": 0.0,
"plnk_name": "AKC Regs",
"prdmed_file_ids": [],
"prdpr_actual_margin": 0.5834583458345834,
"prdpr_actual_markup": 2.400720288115246,
"prdpr_cost": 41.65,
"prdpr_margin": 0.5834583458345834,
"prdpr_markup": null,
"prdpr_price": 99.99,
"prdpr_uses_markup": false,
"prdvar_base_name": null,
"prdvar_slug": null,
"prdvar_suggested_name": null,
"price_link_id": 1,
"prlocs_bin_location": null,
"prlocs_excluded_delivery_types": null,
"prlocs_is_saleable_as_modifier_only": false,
"prlocs_last_change": "2023-11-07 17:52:25.763190-05:00",
"prlocs_last_inventory": "2023-11-07 17:52:25.763190-05:00",
"prlocs_last_movement": null,
"prlocs_last_purchase": null,
"prlocs_last_sale": "2023-07-11 16:18:41.023045-04:00",
"prlocs_replaced_by_product_id": null,
"prlocs_stocking_rule": "Stock",
"prlstat_last_purchase": null,
"prlstat_recent_quantity_used": 0.0,
"prod_barcode": "CP_REG",
"prod_barcodes": [
"CP_REG"
],
"prod_category": "Pet Services",
"prod_cheapest_auto_order_supplier": null,
"prod_cheapest_supplier": null,
"prod_has_image": false,
"prod_image_count": 0,
"prod_image_file_ids": null,
"prod_ingredients": [],
"prod_is_available_on_web": true,
"prod_is_marked_for_deletion": false,
"prod_is_mfd": false,
"prod_last_change": "2023-11-07 17:52:25.763190-05:00",
"prod_last_inventory": "2023-11-07 17:52:25.763190-05:00",
"prod_last_movement": null,
"prod_last_purchase": null,
"prod_last_sale": "2023-07-11 16:18:41.023045-04:00",
"prod_long_description": "AKC Canine Partners Registration Add On",
"prod_marketing_message": "",
"prod_media_count": 0,
"prod_media_file_ids": [],
"prod_minimal_selling_price": null,
"prod_minimum_advertised_price": null,
"prod_msrp": null,
"prod_name": "AKC Canine Partners Registration Add On",
"prod_nutritional": {},
"prod_product_category_id": 182,
"prod_product_sub_category_id": 348,
"prod_product_variation_id": null,
"prod_slug": "akc-canine-partners-registration",
"prod_subcategory": "Uncategorized",
"prod_tags": [],
"prod_timestamp": "2022-11-22 20:29:38.127075",
"prod_type": "Regular",
"prod_var_field1": null,
"prod_var_field10": null,
"prod_var_field11": null,
"prod_var_field12": null,
"prod_var_field13": null,
"prod_var_field14": null,
"prod_var_field15": null,
"prod_var_field16": null,
"prod_var_field17": null,
"prod_var_field18": null,
"prod_var_field19": null,
"prod_var_field2": null,
"prod_var_field20": null,
"prod_var_field3": null,
"prod_var_field4": null,
"prod_var_field5": null,
"prod_var_field6": null,
"prod_var_field7": null,
"prod_var_field8": null,
"prod_var_field9": null,
"prod_var_fields": null,
"prod_video_count": 0,
"prod_video_file_ids": null,
"prod_web_description": "AKC Canine Partners Registration Add On",
"prod_web_info": "",
"prodss_website_order": 2.0,
"product_id": 10040,
"product_location_settings_id": 24,
"product_media_count": 0,
"product_price_id": 25,
"product_pricing_group_id": 1,
"sub_category": "Uncategorized",
"warnings": {}
},
{
"category": "Pet Services",
"cheapest_supplier": null,
"dinv_on_hand": 0.0,
"ent_name": null,
"fifo_cost": null,
"first_barcode": "AKC_REG",
"invtry_qty": 0.0,
"last_inventory": "2023-11-07 17:52:25.763190-05:00",
"last_movement": null,
"last_purchase": null,
"last_sale": "2022-02-28 04:08:48.933596-05:00",
"loc_entity_id": 4,
"loc_report_code": "PS",
"location_last_inventory": "2023-11-07 17:52:25.763190-05:00",
"location_last_movement": null,
"location_last_purchase": null,
"location_last_sale": "2022-02-28 04:08:48.933596-05:00",
"mfg_brand_id": null,
"mfgbr_brand_name": null,
"mfgbr_ent_name": null,
"mfgbr_entity_id": null,
"on_order_qty": 0.0,
"plnk_name": "AKC Regs",
"prdmed_file_ids": [],
"prdpr_actual_margin": 0.5834583458345834,
"prdpr_actual_markup": 2.400720288115246,
"prdpr_cost": 41.65,
"prdpr_margin": 0.5834583458345834,
"prdpr_markup": null,
"prdpr_price": 99.99,
"prdpr_uses_markup": false,
"prdvar_base_name": null,
"prdvar_slug": null,
"prdvar_suggested_name": null,
"price_link_id": 1,
"prlocs_bin_location": null,
"prlocs_excluded_delivery_types": [
"Pickup",
"Ship to Home"
],
"prlocs_is_saleable_as_modifier_only": false,
"prlocs_last_change": "2023-04-06 15:14:35.754372-04:00",
"prlocs_last_inventory": "2023-11-07 17:52:25.763190-05:00",
"prlocs_last_movement": null,
"prlocs_last_purchase": null,
"prlocs_last_sale": "2022-02-28 04:08:48.933596-05:00",
"prlocs_replaced_by_product_id": null,
"prlocs_stocking_rule": "Stock",
"prlstat_last_purchase": null,
"prlstat_recent_quantity_used": 0.0,
"prod_barcode": "AKC_REG",
"prod_barcodes": [
"AKC_REG"
],
"prod_category": "Pet Services",
"prod_cheapest_auto_order_supplier": null,
"prod_cheapest_supplier": null,
"prod_has_image": false,
"prod_image_count": 0,
"prod_image_file_ids": null,
"prod_ingredients": [],
"prod_is_available_on_web": true,
"prod_is_marked_for_deletion": false,
"prod_is_mfd": false,
"prod_last_change": "2023-04-06 15:14:35.754372-04:00",
"prod_last_inventory": "2023-11-07 17:52:25.763190-05:00",
"prod_last_movement": null,
"prod_last_purchase": null,
"prod_last_sale": "2022-02-28 04:08:48.933596-05:00",
"prod_long_description": "AKC Pedigree Registration Add On",
"prod_marketing_message": "",
"prod_media_count": 0,
"prod_media_file_ids": [],
"prod_minimal_selling_price": null,
"prod_minimum_advertised_price": null,
"prod_msrp": null,
"prod_name": "AKC Pedigree Registration Add On",
"prod_nutritional": {},
"prod_product_category_id": 182,
"prod_product_sub_category_id": 348,
"prod_product_variation_id": null,
"prod_slug": "akc-pedigree-registration",
"prod_subcategory": "Uncategorized",
"prod_tags": [],
"prod_timestamp": "2022-11-22 20:29:38.075651",
"prod_type": "Regular",
"prod_var_field1": null,
"prod_var_field10": null,
"prod_var_field11": null,
"prod_var_field12": null,
"prod_var_field13": null,
"prod_var_field14": null,
"prod_var_field15": null,
"prod_var_field16": null,
"prod_var_field17": null,
"prod_var_field18": null,
"prod_var_field19": null,
"prod_var_field2": null,
"prod_var_field20": null,
"prod_var_field3": null,
"prod_var_field4": null,
"prod_var_field5": null,
"prod_var_field6": null,
"prod_var_field7": null,
"prod_var_field8": null,
"prod_var_field9": null,
"prod_var_fields": null,
"prod_video_count": 0,
"prod_video_file_ids": null,
"prod_web_description": "AKC Pedigree Registration Add On",
"prod_web_info": "",
"prodss_website_order": 3.0,
"product_id": 10041,
"product_location_settings_id": 25,
"product_media_count": 0,
"product_price_id": 26,
"product_pricing_group_id": 1,
"sub_category": "Uncategorized",
"warnings": {}
}
],
"total": 3698
} |