24/7 Support: 800.608.6482

Navigation

PriceGroupCustomerList_Load_Query

This function allows you to look up customers assigned to a specific price group. It follows the same structure as other List Load Functions in Miva.

Only one of the three price group identifiers is required.

Request Parameters

count Type:
Number		 Title:
Count		 Count is used to tell Miva how many customers you want returned. 0 will return all customers assigned.
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.
PriceGroup_ID Type:
Number		 Title:
Price Group Id		 Price Group Id
PriceGroup_Name Type:
String		 Title:
Price Group Name		 Price Group Name
Edit_PriceGroup Type:
String		 Title:
Price Group Name		 Price Group Name
Filter Type:
Object		 Title:
Filter		 Array of Object containing search filters. See usage here: List Load Query Overview

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 records 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 records to return. Used in conjunction with the Count parameter for paginating results of large datasets.
id Type:
Number		 Title:
Customer Id		 Customer Id
account_id Type:
Number		 Title:
Business Account Id		 Business Account Id
login Type:
String		 Title:
Customer Login		 Customer Login
pw_email Type:
String		 Title:
Customer Forgot Password Email		 Forgot Password Email
ship_id Type:
Number		 Title:
Shipping Address ID		 Address Book Shipping Address ID
ship_res Type:
Boolean		 Title:
Customer Ship Residential Flag		 Boolean flag used to determine if commercial or resential rates are returned.
ship_fname Type:
String		 Title:
Shipping First Name		 Shipping First Name
ship_lname Type:
String		 Title:
Shipping Last Name		 Customer Last Name
ship_email Type:
String		 Title:
Shipping Email Address		 Shipping Email Address
ship_comp Type:
String		 Title:
Shipping Company		 Shipping Company
ship_phone Type:
String		 Title:
Shipping Phone Number		 Shipping Phone Number
ship_fax Type:
String		 Title:
Shipping Fax Number		 Shipping Fax Number
ship_addr1 Type:
String		 Title:
Shipping Address 1		 Shipping Address 1
ship_addr2 Type:
String		 Title:
Shipping Address 2		 Shipping Address 2
ship_city Type:
String		 Title:
Shipping City		 Shipping City
ship_state Type:
String		 Title:
Shipping State		 Shipping State. 2 digit state code
ship_zip Type:
String		 Title:
Shipping Zip Code		 Shipping Zip Code
ship_cntry Type:
String		 Title:
Shipping Country		 Shipping Country. 2 digit country code
bill_id Type:
Number		 Title:
Billing Address Id		 Billing Address ID
ship_fname Type:
String		 Title:
Customer First Name		 Shipping First Name to assign to a customer
ship_lname Type:
String		 Title:
Customer Last Name		 Customer Last Name
ship_email Type:
String		 Title:
Shipping Email Address		 Shipping Email Address
ship_comp Type:
String		 Title:
Shipping Company		 Shipping Company
ship_phone Type:
String		 Title:
Shipping Phone Number		 Shipping Phone Number
ship_fax Type:
String		 Title:
Shipping Fax Number		 Shipping Fax Number
ship_addr1 Type:
String		 Title:
Shipping Address 1		 Shipping Address 1
ship_addr2 Type:
String		 Title:
Shipping Address 2		 Shipping Address 2
ship_city Type:
String		 Title:
Shipping City		 Shipping City
ship_state Type:
String		 Title:
Shipping State		 Shipping State. 2 digit state code
ship_zip Type:
String		 Title:
Shipping Zip Code		 Shipping Zip Code
ship_cntry Type:
String		 Title:
Shipping Country		 Shipping Country. 2 digit country code
bill_fname Type:
String		 Title:
Bill Address First Name		 Billing First Name
bill_lname Type:
String		 Title:
Bill Address Last Name		 Customer Last Name
bill_email Type:
String		 Title:
Billing Email Address		 Billing Email Address
bill_comp Type:
String		 Title:
Billing Company		 Billing Company
bill_phone Type:
String		 Title:
Billing Phone Number		 Billing Phone Number
bill_fax Type:
String		 Title:
Billing Fax Number		 Billing Fax Number
bill_addr1 Type:
String		 Title:
Billing Address 1		 Billing Address 1
bill_addr2 Type:
String		 Title:
Billing Address 2		 Billing Address 2
bill_city Type:
String		 Title:
Billing City		 Billing City
bill_state Type:
String		 Title:
Billing State		 Billing State. 2 digit state code
bill_zip Type:
String		 Title:
Billing Zip Code		 Billing Zip Code
bill_cntry Type:
String		 Title:
Billing Country		 Billing Country. 2 digit country code
note_count Type:
Number		 Title:
Note Count		 Number of Notes assigned to customer record
dt_created Type:
Unix Timestamp		 Title:
Date Time Created		 Unix timestamp of the date account was created.
dt_login Type:
Unix Timestamp		 Title:
Date Time of Last Login		 Date Time of Last Login
credit Type:
Number		 Title:
Customer Account Credit		 Customer Account Credit
formatted_credit Type:
String		 Title:
Formatted Customer Account Credit		 Currency Formatted Customer Account Credit
business_title Type:
String		 Title:
Business Account		 Name of Business Account customer is assigned to
assigned Type:
Boolean		 Title:
Customer Assigned Flag		 Flag to indicate customer is assigned to the Price Group passed in as a parameter

Example Requests

Example Response

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 – 2022 Miva©, Miva Merchant©, MivaPay©, MivaCon©, Camp Miva ℠, Miva, Inc. All Rights Reserved.