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_loc_entity_id - location_id
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': [],
'prlocs_is_saleable_as_modifier_only': False,
'prlocs_last_change': None,
'prlocs_last_inventory': None,
'prlocs_last_movement': None,
'prlocs_last_purchase': None,
'prlocs_last_sale': None,
'prlocs_replaced_by_product_id': None,
'prlocs_stocking_rule': 'Stock',
'prlstat_last_purchase': None,
'prlstat_recent_quantity_used': 0.0,
'prod_barcode': None,
'prod_barcodes': None,
'prod_category': None,
'prod_cheapest_auto_order_supplier': None,
'prod_cheapest_supplier': None,
'prod_has_image': False,
'prod_image_count': 0,
'prod_image_file_ids': None,
'prod_ingredients': [],
'prod_is_available_on_web': False,
'prod_is_marked_for_deletion': False,
'prod_is_mfd': False,
'prod_last_change': None,
'prod_last_inventory': None,
'prod_last_movement': None,
'prod_last_purchase': None,
'prod_last_sale': None,
'prod_long_description': 'Qr Tag 222',
'prod_marketing_message': None,
'prod_media_count': 0,
'prod_media_file_ids': [],
'prod_minimal_selling_price': None,
'prod_minimum_advertised_price': None,
'prod_msrp': None,
'prod_name': 'Qr Tag 222',
'prod_nutritional': {},
'prod_product_category_id': None,
'prod_product_sub_category_id': None,
'prod_product_variation_id': None,
'prod_slug': 'qr-tag-222',
'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': [],
'prlocs_is_saleable_as_modifier_only': False,
'prlocs_last_change': None,
'prlocs_last_inventory': None,
'prlocs_last_movement': None,
'prlocs_last_purchase': None,
'prlocs_last_sale': None,
'prlocs_replaced_by_product_id': None,
'prlocs_stocking_rule': 'Stock',
'prlstat_last_purchase': None,
'prlstat_recent_quantity_used': 0.0,
'prod_barcode': None,
'prod_barcodes': None,
'prod_category': None,
'prod_cheapest_auto_order_supplier': None,
'prod_cheapest_supplier': None,
'prod_has_image': False,
'prod_image_count': 0,
'prod_image_file_ids': None,
'prod_ingredients': [],
'prod_is_available_on_web': False,
'prod_is_marked_for_deletion': False,
'prod_is_mfd': False,
'prod_last_change': None,
'prod_last_inventory': None,
'prod_last_movement': None,
'prod_last_purchase': None,
'prod_last_sale': None,
'prod_long_description': 'AKC Reunite expanded network',
'prod_marketing_message': None,
'prod_media_count': 0,
'prod_media_file_ids': [],
'prod_minimal_selling_price': None,
'prod_minimum_advertised_price': None,
'prod_msrp': None,
'prod_name': 'AKC Reunite expanded network',
'prod_nutritional': {},
'prod_product_category_id': None,
'prod_product_sub_category_id': None,
'prod_product_variation_id': None,
'prod_slug': 'akc-reunite-expanded-network',
'prod_subcategory': None,
'prod_tags': [],
'prod_timestamp': '2022-03-08 20:03:05.008711',
'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': None,
'prod_video_count': 0,
'prod_video_file_ids': None,
'prod_web_description': 'AKC Reunite expanded network',
'prod_web_info': None,
'prodss_website_order': None,
'product_id': 10017,
'product_location_settings_id': 997157,
'product_media_count': 0,
'product_price_id': None,
'product_pricing_group_id': None,
'sub_category': None,
'warnings': {'No supplier available': {'date': '03/08/2022',
'message': 'No supplier '
'available '
'detected'}}}],
'total': 45350}