List Products
List Products in Erply, with optional filters.
Query
Get all items that have been ADDED AND/OR CHANGED since a specific point in time. Use this field for synchronizing product database. Must be a UNIX timestamp (integer)
Filter by product type. You can specify multiple product types. Note that matrix variations (specific colors and sizes of a matrix product) are regular products; there is no separate type for those. To include or exclude matrix variations, please see the next filter: `includeMatrixVariations`
Product status, possible statuses are 'ACTIVE', 'NO_LONGER_ORDERED', 'NOT_FOR_SALE' and 'ARCHIVED'.
Specify warehouse ID to: 1) retrieve inventory quantities of selected products only in one specific warehouse. If not set, API will return inventory quantities for every warehouse. For performance reasons, it is recommended to always set this parameter if you do not need information about all warehouses simultaneously. 2) retrieve price list prices in one specific location. 3) retrieve POS quick select buttons for one specific location (quickPosProducts = 1)
Search for a product by name, exact matches only.
Search for a product by code, exact matches only. For more sophisticated product search options, use the input parameters 'findBestMatch' or 'searchNameIncrementally'
Retrieve one specific product by it's ID.
Retrieve specific products. Here you may enter multiple product IDs.
Search from product name, product code, EAN / UPC, code3, supplier code, code5, code6, code7, or code8.
This filter is for retrieving or excluding matrix variations (specific colors or sizes of a matrix product). By default, variations are included.
Toggle on to retrieve inventory quantities for selected products.
Toggle on to retrieve price list prices.
Toggle on to retrieve only the products that are in stock at specific location.
The default value is 'changed'. Other accepted values are: 'name', 'code', 'productID', 'price', 'parentProductID', 'changed' or 'added'.
By default, items are sorted in descending order. Set the sort direction of the returned results: 'asc' (ascending order) or 'desc' (descending order).
Maximum number of rows to return.
Number of rows to skip.
Comma-separated response fields to include.