List products (per location)
------------------------------------------------------------------------
res = po_client.request("post", "/apps/any/queries/read__qpt__list_products", qp_loc_entity_id=4, limit=2, offset=0)
...
qp_product_id - if only 1 product is needed
Response:
{'objects': [{'category': None,
'cheapest_supplier': None,
'dinv_on_hand': 0.0,
'ent_name': None,
'fifo_cost': None,
'first_barcode': None,
'invtry_qty': 0.0,
'last_inventory': None,
'last_movement': None,
'last_purchase': None,
'last_sale': None,
'loc_entity_id': 4,
'loc_report_code': 'RHCP',
'location_last_inventory': None,
'location_last_movement': None,
'location_last_purchase': None,
'location_last_sale': None,
'mfg_brand_id': None,
'mfgbr_brand_name': None,
'mfgbr_ent_name': None,
'mfgbr_entity_id': None,
'on_order_qty': 0.0,
'plnk_name': None,
'prdmed_file_ids': [],
'prdpr_actual_margin': None,
'prdpr_actual_markup': None,
'prdpr_cost': 0.0,
'prdpr_margin': None,
'prdpr_markup': None,
'prdpr_price': 0.0,
'prdpr_uses_markup': False,
'prdvar_base_name': None,
'prdvar_slug': None,
'prdvar_suggested_name': None,
'price_link_id': None,
'prlocs_bin_location': None,
'prlocs_excluded_delivery_types': [],
...
POST /apps/any/queries/read__qpt__list_products {'limit': '2', 'offset': '0', '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 {'limit': '2', 'offset': '0', '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': None,
'prod_barcodes': None,
'prod_category': None,
...
"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 |
...
'prod_nutritional': {},
...
": "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 |
...
'prod_subcategory': None,
'prod_tags': [],
'prod_timestamp': '2022-04-20 08:23:57.016287',
'prod_type': 'Regular',
'prod_var_field1': None,
'prod_var_field10': None,
'prod_var_field11': None,
'prod_var_field12': None,
'prod_var_field13': None,
'prod_var_field14': None,
'prod_var_field15': None,
'prod_var_field16': None,
'prod_var_field17': None,
'prod_var_field18': None,
'prod_var_field19': None,
'prod_var_field2': None,
'prod_var_field20': None,
'prod_var_field3': None,
'prod_var_field4': None,
'prod_var_field5': None,
'prod_var_field6': None,
'prod_var_field7': None,
'prod_var_field8': None,
'prod_var_field9': None,
'prod_var_fields': {},
'prod_video_count': 0,
'prod_video_file_ids': None,
'prod_web_description': 'Qr Tag 222',
'prod_web_info': None,
'prodss_website_order': None,
'product_id': 10007,
'product_location_settings_id': 1025749,
'product_media_count': 0,
'product_price_id': 241020,
'product_pricing_group_id': 1,
'sub_category': None,
'warnings': {'No Cost': {'date': '05/17/2022',
'message': 'No Cost detected on Price '
'Group PrcGrp #1'},
'No supplier available': {'date': '05/16/2022',
'message': 'No supplier '
'available '
'detected'}}},
{'category': None,
'cheapest_supplier': None,
'dinv_on_hand': 0.0,
'ent_name': None,
'fifo_cost': None,
'first_barcode': None,
'invtry_qty': 0.0,
'last_inventory': None,
'last_movement': None,
'last_purchase': None,
'last_sale': None,
'loc_entity_id': 4,
'loc_report_code': 'RHCP',
'location_last_inventory': None,
'location_last_movement': None,
'location_last_purchase': None,
'location_last_sale': None,
'mfg_brand_id': None,
'mfgbr_brand_name': None,
'mfgbr_ent_name': None,
'mfgbr_entity_id': None,
'on_order_qty': 0.0,
'plnk_name': None,
'prdmed_file_ids': [],
'prdpr_actual_margin': None,
'prdpr_actual_markup': None,
'prdpr_cost': None,
'prdpr_margin': None,
'prdpr_markup': None,
'prdpr_price': None,
'prdpr_uses_markup': None,
'prdvar_base_name': None,
'prdvar_slug': None,
'prdvar_suggested_name': None,
'price_link_id': None,
'prlocs_bin_location': None,
'prlocs_excluded_delivery_types': [],
...
": "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_ |
...
'prlocs_last_sale': None,
...
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 |
...
'prod_barcodes': None,
'prod_category': None,
...
": "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 |
...
": |
...
'prod_last_change': None,
...
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 |
...
": |
...
'prod_nutritional': {},
...
"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 |
...
": |
...
'sub_category': None,
'warnings': {'No supplier available': {'date': '03/08/2022',
'message': 'No supplier '
'available '
'detected'}}}],
...
1, "sub_category": "Uncategorized", "warnings": {} } ], "total": 3698 } |