Location Product Pricing Service
getLocationProductPricingByPage
Retrieve product pricing for a specific location.
get/locationproductpricing/v1/getLocationProductPricingByPage
Query parameters
locationCodestring
The Code that identifies the Location in Crunchtime.
pageNumberinteger
Retrieve one or more records by pageNumber. Use to retrieve data in smaller chunks. If left blank, the default is 1.
productNumberstring
A unique alphanumeric code used to identify a product.
pageSizeinteger
Number of items to display per page.
includeNullboolean
Specify 'true' to output null data elements.
minutesSinceUpdateinteger
The number of minutes since a location product record was last updated. Use to set how far back to search.
Headers
authenticationtokenstring required
Secure token for API authentication.
passwordstring required
Password for the Crunchtime Application User.
sitenamestring required
Crunchtime site identifier. (test or production)
useridstring required
User ID for the Crunchtime Application User.
X-B3-TraceIdstring
Optional trace identifier for troubleshooting.
Response
Success
Example response
{
"locationProductPricingDetails": [
{
"locationProductPricingAutoTransferDetails": [
{
"autoTransferFlag": "Y",
"locationCode": "000",
"productNumber": "Gallop55concept",
"sourceLocation": "000011",
"lastTouchDate": "02/17/2025 10:00:03"
}
],
"locationProductPricingSeqStorDetails": [
{
"locationCode": "000",
"primaryFlag": "Y",
"productNumber": "Gallop55concept",
"sequenceActiveFlag": "Y",
"sequenceNumber": 41,
"storage": "BAR",
"storageActiveFlag": "Y",
"lastTouchDate": "02/17/2025 10:00:03"
}
],
"locationProductPricingUnitsDetails": [
{
"allowSplitFlag": "N",
"altUnitOneAltUnit": "CAN 13OZ",
"altUnitOneConversion": 2.561538,
"altUnitThreeAltUnit": "QT",
"altUnitThreeConversion": 0.6213,
"altUnitTwoAltUnit": "B-4 4TH PAN",
"altUnitTwoConversion": 0.32813,
"alternatePrimaryFlag": "Y",
"alternatePrimaryOnly": "N",
"custOrderPricPreferred": 1,
"custOrderPricPremium": 1,
"custOrderPricStandard": 1,
"inventory": 2.2444,
"issue": 0.40702816,
"locTransferFlag": "Y",
"locationCode": "000",
"markupMarket": 9999.99,
"maxPar": 1,
"minDaysOnHand": 99.99,
"minPar": 1,
"productNumber": "Gallop55concept",
"reOrderCoFlag": "N",
"reOrderVoFlag": "Y",
"splitOnlyFlag": "Y",
"theoreticalEqualsActualFlag": "N",
"lastTouchDate": "02/17/2025 10:00:03"
}
]
}
]
}