24/7 Support: 800.608.6482

Navigation


CategoryProductList_Load_Query

This function allows you to load a list of products assigned to a specific category.

Assigned defaults to true and Unassigned defaults to false if omitted. See the List Load Query Overview guide to get started.

Request Parameters

count Type:
Number
Title:
Count
Count is used to tell Miva how many products you returned. If for example you are querying thousands of products you'll want to set the count to limit how many you get back in a single request.
offset Type:
Offset
Title:
Number
Used in conjunction with the Count parameter for paginating results of large datasets. Default is 0 whcih is no offset.
sort Type:
String
Title:
Sort
Field to sort results by. Avaiilable sorting fields listed below. Use - prefix for a decending sort.
Filter Type:
Object
Title:
Filter
Array of Object containing search filters. See usage here: List Load Query Overview
Category_ID Type:
String
Title:
Category ID
Category ID
Category_Code Type:
String
Title:
Category Code
Category Code
Edit_Category Type:
String
Title:
Edit Category
Edit Category - Same as Category Code
Assigned Type:
Boolean
Title:
Assigned
Assigned. Defaults to true if omitted
Unassigned Type:
Boolean
Title:
Unassigned
Unassigned. Defaults to false if omitted.

On Demand Columns

descrip Full HTML product description
catcount Number of categories the product is assigned to
productinventorysettings Product specific inventory settings
attributes Includes attribute object in response
productimagedata Product Image including Image Types and non image types
categories Product Category Assignments
productshippingrules Includes product dimensions and restricted shipping methods (if any)
relatedproduct Related product assignments
uris Includes URI's object in response. Canonical URI is the default URL for the product.
CustomField_Values:* See custom field usage here: https://docs.miva.com/json-api/list-load-query-overview

Other custom Filters

Product_Show "All", "Uncategorized" or "Active" (All is default)

Supported Search Filter Columns

code sku cancat_code
page_code name thumbnail
image price cost
weight taxable active
page_title dt_created dt_updated
category Supports only IN and NOT_IN operators. Accepts a comma separated list of category IDs. Limits results to products in the specified categories. product_inventory Searches the product's inventory level (not accounting for baskets)

Supported Sort Columns

One of these values would be passed in the sort request parameter to have the results sorted by that column. Value may be preceded by "-" for a descending sort.

code sku cancat_code
page_code name thumbnail
image price cost
descrip weight taxable
active page_title dt_created
dt_updated    

Response Parameters

total_count Type:
Number
Title:
Total Product Count
total_count is the total number of records that match your search criteria. Note: this is not always the total products returned. Based on the Count and Offset parameters passed, the number of records returned could be different than the total_count.
start_offset Type:
Number
Title:
Start Offset
Number number of the starting offset number of products to return. Used in conjunction with the Count parameter for paginating results of large datasets.
id Type:
Number
Title:
id
Product Id
code Type:
String
Title:
Product Code
Miva Product Code (unique)
Sku Type:
String
Title:
Product SKU
Product SKU
thumbnail Type:
String
Title:
Product Thumbnail
[Depreciated] This field is depreciated and is supported for legacy purposes. Relative Path to the product thumbnail image.
image Type:
String
Title:
Product Fullsize Image
[Depreciated] This field is depreciated and is supported for legacy purposes. Relative Path to the product fullsize image.
price Type:
Number
Title:
Price
Product Price
formatted_price Type:
String
Title:
Formatted_Price
Currency Formatted Product Price
cost Type:
Number
Title:
Cost
Product Cost
formatted_cost Type:
String
Title:
Formatted_Cost
Currency Formatted Product Cost
weight Type:
Number
Title:
Weight
Product Weight
taxable Type:
Boolean
Title:
Taxable
true/false flag if the product is taxable
active Type:
Boolean
Title:
Active
true/false flag if the product is active
page_title Type:
String
Title:
Product Page Title
Product Page Title - used in HTML title tag within head
dt_created Type:
Unix Timestamp
Title:
Date/Time Product was created
Unix timestamp product was created
dt_updated Type:
Unix Timestamp
Title:
Date/Time Product Updated
Unix timestamp product was last updated
productinventorysettings
+ Show Properties
Type:
Object
Title:
Product Inventory Settings
productinventorysettings (if requested as an On Demand Column)
active Type:
Boolean
Title:
Active
Active Flag if inventory is being tracked on this product
in_short Type:
String
Title:
Inventory Short Message
Inventory Short Message
in_long Type:
String
Title:
Inventory Long Message
Inventory Long Message
low_track Type:
String
Title:
Track Low Stock Level
Values include: d = default (inherits from global), y = yes, n = no
low_level Type:
Number
Title:
Low Stock Level
Inventory level at which the low stock level is triggered
low_lvl_d Type:
Boolean
Title:
Low Stock Level Default
Flag to determine if low stock level inherits from global settings. Will be set to false if low_level has a value.
low_short Type:
String
Title:
Low Stock Short Message
Low Stock Short Message
low_long Type:
String
Title:
Low Stock Long Message
Low Stock Long Message
out_track Type:
String
Title:
Track Out of Stock Level
Values include: d = default (inherits from global), y = yes, n = no
out_hide Type:
String
Title:
Hide Out Of Stock Products
Values include: d = default (inherits from global), y = yes, n = no
out_level Type:
Number
Title:
Out of Stock Level
Inventory level at which the out stock level is triggered
out_lvl_d Type:
Boolean
Title:
Out of Stock Level Default
Flag to determine if out of stock level inherits from global settings. Will Set to false if out_level has a value.
out_short Type:
String
Title:
Out of Stock Short Message
Out of Stock Short Message
out_long Type:
String
Title:
Out of Stock Long Message
Out of Stock Long Message
ltd_long Type:
String
Title:
Limited Stock Message
Shows when only part of the number requested can be added to the basket. ie. there are only 3 instock but customer tries to add 5.
attributes
+ Show Properties
Type:
Object
Title:
Attributes
Attributes
id Type:
Number
Title:
Attribute Id
Attribute Id
product_id Type:
Number
Title:
Product ID
Id of product attribute is assigned to
attr_id Type:
Number
Title:
Attribute Id
Same as Id field.
default_id Type:
Number
Title:
Default ID
id of default attribute option
disp_order Type:
Number
Title:
Display Order
Display Order. Used in sorting attributes.
attemp_id Type:
Number
Title:
Attribute Template Id
Will contain the id of the attribute id reference, otherwise 0
code Type:
String
Title:
Attribute Code
Attribute Code
type Type:
String
Title:
Attribute Type
One of the following types: radio, checkbox, text, memo, swatch, swatch-select
prompt Type:
String
Title:
Attribute Prompt
Attribute Text displayed to customer during runtime
price Type:
Number
Title:
Price
Attribute Price
cost Type:
Number
Title:
Cost
Attribute Cost
weight Type:
Number
Title:
Weight
Attribute Weight
required Type:
Boolean
Title:
Required
Flag if the Attribute is Required
inventory Type:
Boolean
Title:
Inventory Flag
Flag if Inventory is being tracked on this attribute. Required when using Inventory Variants.
image Type:
String
Title:
Attribute Image
Attribute Image - Relative path to image file.
options
+ Show Properties
Type:
Object
Title:
Options
Options
id Type:
Number
Title:
Option Id
Option Id
product_id Type:
Number
Title:
Product ID
Id of product attribute is assigned to
attr_id Type:
Number
Title:
Attribute Id
Id of attribute option is assigned to
disp_order Type:
Number
Title:
Display Order
Display Order. Used in sorting options.
code Type:
String
Title:
Option Code
Option Code
prompt Type:
String
Title:
Option Prompt
Option Text displayed to customer during runtime
price Type:
Number
Title:
Price
Option Price
cost Type:
Number
Title:
Cost
Option Cost
weight Type:
Number
Title:
Weight
Option Weight
image Type:
String
Title:
Option Image
Option Image - Relative path to image file.
productimagedata
+ Show Properties
Type:
Object
Title:
Product Image Data
Product Images
id Type:
Number
Title:
Image Id
Image Id
product_id Type:
Number
Title:
Product ID
Id of product image is assigned to
image_id Type:
Number
Title:
Image Id
Same as Id field.
type_id Type:
Number
Title:
Type Id
Image Type Id
code Type:
String
Title:
Code
Image Type Code
type_desc Type:
String
Title:
Image Type Description
Image Type Description
image Type:
String
Title:
Image Path
Relative (to mm5 folder) path to product image
width Type:
Number
Title:
width
Width (in Pixels) of image
height Type:
Number
Title:
Height
Height (in pixels) of image
disp_order Type:
Number
Title:
Display Order
Image Display Order
categories
+ Show Properties
Type:
Object
Title:
Categories
Assigned Categories
id Type:
Number
Title:
Category Id
Category Id
parent_id Type:
Number
Title:
Parent ID
Id of parent category. 0 if category does not have a parent
agrpcount Type:
Number
Title:
Availability Group Count
Availability Group Count
depth Type:
Number
Title:
Depth
Category Depth
disp_order Type:
Number
Title:
Display Order
Category Display Order
page_id Type:
Number
Title:
Page Id
Alternate Display Page Id. O if none.
code Type:
String
Title:
Code
Category Code
name Type:
String
Title:
Category Name
Category Name
page_title Type:
String
Title:
Page Title
Page Title Tag (used in head tag)
active Type:
Boolean
Title:
Active
Active
dt_created Type:
Unix Timestamp
Title:
Date/Time Created
Date/Time Created
dt_updated Type:
Unix Timestamp
Title:
Date/Time Updated
Date/Time Updated
uris
+ Show Properties
Type:
Object
Title:
URIs
URIs
id Type:
Number
Title:
URI Id
URI Id
uri Type:
String
Title:
Uri
relative URI path to product
store_id Type:
Number
Title:
Store ID
Id of Store product URI is assigned to
screen Type:
String
Title:
Screen
Only used for page uris. Will always be empty for product URIs
page_id Type:
Number
Title:
Page Id
Only used for page uris. Will always be 0 for product URIs
cat_id Type:
Number
Title:
Category Id
Category Id URI is associated with
product_id Type:
Number
Title:
Product Id
Product Id URI is associated with
feed_id Type:
Number
Title:
feed_id
Feed id URI is associated with
canonical Type:
Boolean
Title:
Canonical
Flag to signifiy if URI is the canonical (default) URI
status Type:
Number
Title:
Status
http Status to return. Values include: 200, 301, 302, 303, 307
concact_code Type:
String
Title:
Canonocal Category Code
Canonical Category Code for the product
page_code Type:
String
Title:
Alternate Display Page Code
Will contain the page code if the product is linked to an alternate display page (other than PROD)
product_inventory_active Type:
Boolean
Title:
Product Inventory Active
Flag if inventory is being tracked on this product
product_inventory Type:
Number
Title:
Product Inventory Count
Current Inventory Count
CustomField_Values
+ Show Properties
Type:
Object
Title:
Custom Field Values
Object of Custom Fields
cmp-cssui-pchdft
+ Show Properties
Type:
Object
Title:
Product/Category Header & Footer
Product/Category Header & Footer
header Type:
String
Title:
Product Header
Full HTML of Product Header
footer Type:
String
Title:
Product Footer
Full HTML of Product Footer

Example Request

Example Response

Error Responses

error code
MER-JSN-CAT-00033
error message
Unable to load category: One of Category_ID, Edit_Category or Category_Code must be specified
  Missing required category identifier

This website uses cookies to identify visitors, track visitors to our website, store login session information and to remember your user preferences. By continuing to use this site you agree to our use of cookies. Learn More.

This website uses cookies. By continuing to use this site you agree to our use of cookies. Learn More.

Accept

Copyright © 1997 – 2023 Miva©, Miva Merchant©, MivaPay©, MivaCon©, Camp Miva ℠, Miva, Inc. All Rights Reserved.