Location Product Pricing Service
getAllLocationProductPricing
Retrieve all product pricing by location.
get/locationproductpricing/v1/getAllLocationProductPricing
Query parameters
locationCodestring required
The Code that identifies the Location in Crunchtime.
productNumberstring
A unique alphanumeric code used to identify a product.
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
[
{
"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"
}
]
}
]