List Price List Records

GET

https://api.bigcommerce.com/stores/store_hash/v3/pricelists/:price_list_id/records

GET

/stores/store_hash/v3/pricelists/:price_list_id/records

1 curl https://api.bigcommerce.com/stores/store_hash/v3/pricelists/1/records \
2      -H "X-Auth-Token: <apiKey>"

1 {
2   "data": [
3     {
4       "calculated_price": 25.48,
5       "date_created": "2022-09-17T20:33:14Z",
6       "date_modified": "2022-09-17T20:33:14Z",
7       "product_id": 187,
8       "price_list_id": 3,
9       "variant_id": 358,
10       "currency": "usd",
11       "price": 25.48,
12       "sale_price": 18.57,
13       "retail_price": 25.48,
14       "map_price": 18.57,
15       "bulk_pricing_tiers": []
16     },
17     {
18       "calculated_price": 31.31,
19       "date_created": "2022-09-17T20:33:14Z",
20       "date_modified": "2022-09-17T20:33:14Z",
21       "product_id": 188,
22       "price_list_id": 3,
23       "variant_id": 359,
24       "currency": "usd",
25       "price": 31.31,
26       "sale_price": 31.31,
27       "retail_price": 31.31,
28       "map_price": 31.31,
29       "bulk_pricing_tiers": []
30     },
31     {
32       "calculated_price": 18.57,
33       "date_created": "2022-09-17T20:33:14Z",
34       "date_modified": "2022-09-17T20:33:14Z",
35       "product_id": 189,
36       "price_list_id": 3,
37       "variant_id": 360,
38       "currency": "usd",
39       "price": 18.57,
40       "sale_price": 18.57,
41       "retail_price": 18.57,
42       "map_price": 18.57,
43       "bulk_pricing_tiers": []
44     },
45     {
46       "calculated_price": 22.54,
47       "date_created": "2022-09-17T20:33:14Z",
48       "date_modified": "2022-09-17T20:33:14Z",
49       "product_id": 190,
50       "price_list_id": 3,
51       "variant_id": 361,
52       "currency": "usd",
53       "price": 22.54,
54       "sale_price": 22.54,
55       "retail_price": 22.54,
56       "map_price": 22.54,
57       "bulk_pricing_tiers": []
58     },
59     {
60       "calculated_price": 27.39,
61       "date_created": "2022-09-17T20:33:14Z",
62       "date_modified": "2022-09-17T20:51:26Z",
63       "product_id": 191,
64       "price_list_id": 3,
65       "variant_id": 362,
66       "currency": "usd",
67       "price": 27.39,
68       "sale_price": 27.39,
69       "retail_price": 27.39,
70       "map_price": 27.39,
71       "bulk_pricing_tiers": [
72         {
73           "quantity_min": 10,
74           "quantity_max": 19,
75           "type": "percent",
76           "amount": 1
77         },
78         {
79           "quantity_min": 20,
80           "quantity_max": 29,
81           "type": "percent",
82           "amount": 3
83         },
84         {
85           "quantity_min": 30,
86           "quantity_max": 2147483647,
87           "type": "percent",
88           "amount": 5
89         }
90       ]
91     },
92     {
93       "calculated_price": 9.8,
94       "date_created": "2022-09-17T20:33:14Z",
95       "date_modified": "2022-09-17T20:33:14Z",
96       "product_id": 192,
97       "price_list_id": 3,
98       "variant_id": 382,
99       "currency": "usd",
100       "price": 9.8,
101       "sale_price": 9.8,
102       "retail_price": 9.8,
103       "map_price": 9.8,
104       "bulk_pricing_tiers": []
105     },
106     {
107       "calculated_price": 24.5,
108       "date_created": "2022-09-17T20:33:14Z",
109       "date_modified": "2022-09-17T20:33:14Z",
110       "product_id": 192,
111       "price_list_id": 3,
112       "variant_id": 383,
113       "currency": "usd",
114       "price": 24.5,
115       "sale_price": 24.5,
116       "retail_price": 24.5,
117       "map_price": 24.5,
118       "bulk_pricing_tiers": []
119     },
120     {
121       "calculated_price": 24.5,
122       "date_created": "2022-09-17T20:33:14Z",
123       "date_modified": "2022-09-17T20:33:14Z",
124       "product_id": 192,
125       "price_list_id": 3,
126       "variant_id": 384,
127       "currency": "usd",
128       "price": 24.5,
129       "sale_price": 24.5,
130       "retail_price": 24.5,
131       "map_price": 24.5,
132       "bulk_pricing_tiers": []
133     },
134     {
135       "calculated_price": 9.8,
136       "date_created": "2022-09-17T20:33:14Z",
137       "date_modified": "2022-09-17T20:33:14Z",
138       "product_id": 193,
139       "price_list_id": 3,
140       "variant_id": 385,
141       "currency": "usd",
142       "price": 9.8,
143       "sale_price": 9.8,
144       "retail_price": 9.8,
145       "map_price": 9.8,
146       "bulk_pricing_tiers": []
147     },
148     {
149       "calculated_price": 10.78,
150       "date_created": "2022-09-17T20:33:14Z",
151       "date_modified": "2022-09-17T20:33:14Z",
152       "product_id": 194,
153       "price_list_id": 3,
154       "variant_id": 386,
155       "currency": "usd",
156       "price": 10.78,
157       "sale_price": 10.78,
158       "retail_price": 10.78,
159       "map_price": 10.78,
160       "bulk_pricing_tiers": []
161     },
162     {
163       "calculated_price": 10.78,
164       "date_created": "2022-09-17T20:33:14Z",
165       "date_modified": "2022-09-17T20:35:42Z",
166       "product_id": 195,
167       "price_list_id": 3,
168       "variant_id": 388,
169       "currency": "usd",
170       "price": 10.78,
171       "sale_price": 10.78,
172       "retail_price": 10.78,
173       "map_price": 10.78,
174       "bulk_pricing_tiers": [
175         {
176           "quantity_min": 2,
177           "quantity_max": 9,
178           "type": "percent",
179           "amount": 1
180         },
181         {
182           "quantity_min": 10,
183           "quantity_max": 19,
184           "type": "percent",
185           "amount": 2
186         },
187         {
188           "quantity_min": 20,
189           "quantity_max": 2147483647,
190           "type": "percent",
191           "amount": 3
192         }
193       ]
194     },
195     {
196       "calculated_price": 18.62,
197       "date_created": "2022-09-17T20:33:14Z",
198       "date_modified": "2022-09-17T20:35:42Z",
199       "product_id": 195,
200       "price_list_id": 3,
201       "variant_id": 389,
202       "currency": "usd",
203       "price": 18.62,
204       "sale_price": 18.62,
205       "retail_price": 18.62,
206       "map_price": 18.62,
207       "bulk_pricing_tiers": [
208         {
209           "quantity_min": 2,
210           "quantity_max": 9,
211           "type": "percent",
212           "amount": 1
213         },
214         {
215           "quantity_min": 10,
216           "quantity_max": 19,
217           "type": "percent",
218           "amount": 2
219         },
220         {
221           "quantity_min": 20,
222           "quantity_max": 2147483647,
223           "type": "percent",
224           "amount": 3
225         }
226       ]
227     },
228     {
229       "calculated_price": 10.78,
230       "date_created": "2022-09-17T20:33:14Z",
231       "date_modified": "2022-09-17T20:35:42Z",
232       "product_id": 195,
233       "price_list_id": 3,
234       "variant_id": 390,
235       "currency": "usd",
236       "price": 10.78,
237       "sale_price": 10.78,
238       "retail_price": 10.78,
239       "map_price": 10.78,
240       "bulk_pricing_tiers": [
241         {
242           "quantity_min": 2,
243           "quantity_max": 9,
244           "type": "percent",
245           "amount": 1
246         },
247         {
248           "quantity_min": 10,
249           "quantity_max": 19,
250           "type": "percent",
251           "amount": 2
252         },
253         {
254           "quantity_min": 20,
255           "quantity_max": 2147483647,
256           "type": "percent",
257           "amount": 3
258         }
259       ]
260     },
261     {
262       "calculated_price": 10.78,
263       "date_created": "2022-09-17T20:33:14Z",
264       "date_modified": "2022-09-17T20:35:42Z",
265       "product_id": 195,
266       "price_list_id": 3,
267       "variant_id": 391,
268       "currency": "usd",
269       "price": 10.78,
270       "sale_price": 10.78,
271       "retail_price": 10.78,
272       "map_price": 10.78,
273       "bulk_pricing_tiers": [
274         {
275           "quantity_min": 2,
276           "quantity_max": 9,
277           "type": "percent",
278           "amount": 1
279         },
280         {
281           "quantity_min": 10,
282           "quantity_max": 19,
283           "type": "percent",
284           "amount": 2
285         },
286         {
287           "quantity_min": 20,
288           "quantity_max": 2147483647,
289           "type": "percent",
290           "amount": 3
291         }
292       ]
293     }
294   ],
295   "meta": {
296     "pagination": {
297       "total": 14,
298       "count": 14,
299       "per_page": 50,
300       "current_page": 1,
301       "total_pages": 1
302     },
303     "cursor_pagination": {
304       "count": 1,
305       "per_page": 50,
306       "start_cursor": "MTUsMjEx",
307       "end_cursor": "MTUsMjEx",
308       "links": {}
309     }
310   }
311 }

Returns a list of Price List Records associated with a Price List.

Notes

Supports up to 10 simultaneous GET requests. Running more than the allowed number of requests concurrently on the same store will result in a 429 status error and your additional requests will fail.
Store Pricelist Records data to reduce the number of calls and maximize performance.

Returns a list of *Price List Records* associated with a *Price List*. **Notes** * Supports up to 10 simultaneous GET requests. Running more than the allowed number of requests concurrently on the same store will result in a `429` status error and your additional requests will fail. * Store Pricelist Records data to reduce the number of calls and maximize performance.

Authentication

X-Auth-Tokenstring

OAuth scopes

UI Name	Permission	Parameter
Products	modify	`store_v2_products`
Products	read-only	`store_v2_products_read_only`

Authentication header

Header	Argument	Description
`X-Auth-Token`	`access_token`	For more about API accounts that generate `access_token`s, see our Guide to API Accounts.

Path parameters

price_list_idintegerRequired

The ID of the Price List requested.

Query parameters

variant_id:inlist of integersOptional

A comma-separated list of IDs for one or more variants for which prices were requested.

product_id:inlist of integersOptional

A comma-separated list of IDs for one or more products for which prices were requested.

currencystringOptionalformat: "ISO-4217"

Filter items by currency.

pageintegerOptional

Specifies the page number in a limited (paginated) list of products.

limitintegerOptional

Controls the number of items per page in a limited (paginated) list of products. If you provide only a limit, the API returns both paginations while applying that limit.

beforestringOptional

A cursor that can be used for backwards pagination. Will fetch results before the position corresponding to the cursor. Cannot be used with the 'page' query parameter. Cannot be used with the 'after' query parameter.

afterstringOptional

A cursor that can be used for forwards pagination. Will fetch results after the position corresponding to the cursor. Cannot be used with the 'page' query parameter. Cannot be used with the 'before' query parameter.

includelist of enumsOptional

Sub-resources to include on a price record, in a comma-separated list. Valid expansions currently include bulk_pricing_tiers and sku. Other values will be ignored.

Allowed values:

pricedoubleOptional

Filter items by price.

sale_pricedoubleOptional

Filter items by sale_price.

retail_pricedoubleOptional

Filter items by retail_price.

map_pricedoubleOptional

Filter items by map_price.

calculated_pricedoubleOptional

Filter items by calculated_price.

date_createddatetimeOptional

Filter items by date_created.

date_modifieddatetimeOptional

Filter items by date_modified. For example v3/catalog/products?date_last_imported:min=2022-06-15

skustringOptional

Filter items by SKU.

sku:inlist of stringsOptional

currency:inlist of stringsOptional

price:maxdoubleOptional

price:mindoubleOptional

sale_price:maxdoubleOptional

sale_price:mindoubleOptional

retail_price:maxdoubleOptional

retail_price:mindoubleOptional

map_price:maxdoubleOptional

map_price:mindoubleOptional

calculated_price:maxdoubleOptional

calculated_price:mindoubleOptional

date_created:maxstringOptional

date_created:minstringOptional

date_modified:maxstringOptional

date_modified:minstringOptional

Response

datalist of objects

metaobject

‘Contains data about paginating the response via cursors. If no pagination details are specified or if you only provide a limit, then both properties will be present. When a ‘before’ or ‘after’ cursor is provided, only the ‘cursor_pagination’ property will be present. When a ‘page’ parameter is provided, only the offset based ‘pagination’ property will be present.’

Errors

429

Too Many Requests Error

List Price List Records

Authentication

OAuth scopes

Authentication header

Further reading

Path parameters

Query parameters

Response

Errors

OAuth scopes

Authentication header

Further reading