# Live Price Grids ## Assign Customers - [POST /customermanager.assign](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/customers/post-customermanager.assign.md): Assigns multiple customers to the specified entity (e.g., Price List, Live Price Grid, etc.). ## List Customer Assignments - [POST /customermanager.fetchassignments/{typedId}](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/customers/post-customermanager.fetchassignments-typedid.md): Retrieves a list of customers assigned to the specified entity. A filter can be applied (see the request sample). ## Assign Customers - [POST /customermanager.assign](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/price-lists/post-customermanager.assign.md): Assigns multiple customers to the specified entity (e.g., Price List, Live Price Grid, etc.). ## List Customer Assignments - [POST /customermanager.fetchassignments/{typedId}](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/price-lists/post-customermanager.fetchassignments-typedid.md): Retrieves a list of customers assigned to the specified entity. A filter can be applied (see the request sample). ## Assign Customers - [POST /customermanager.assign](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/manual-price-lists/post-customermanager.assign.md): Assigns multiple customers to the specified entity (e.g., Price List, Live Price Grid, etc.). ## List Customer Assignments - [POST /customermanager.fetchassignments/{typedId}](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/manual-price-lists/post-customermanager.fetchassignments-typedid.md): Retrieves a list of customers assigned to the specified entity. A filter can be applied (see the request sample). ## Submit Products - [POST /pricegridmanager.accept/{id}](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-pricegridmanager.accept.md): Submits or approves Live Price Grid (LPG) items. The same endpoint covers both actions: when called on unsubmitted items it performs a submit, and when called with the same payload on items that are already submitted it performs an approval. The Pricefx UI uses this single endpoint for both the Submit and Approve actions, which means repeated or concurrent calls (for example, two users submitting the same change at nearly the same time, or a double-click on Submit) can cause an item to move directly from Unsubmitted to Approved from the first caller's perspective. In workflows with more than one approval step, each call to accept on a SUBMITTED item advances the item by exactly one step (the workflow's current step) by default. The system can be configured so that one approval automatically triggers the next when the calling user has permission to approve the next step; in that case, a single call in a multi-step workflow can result in the item being fully approved. Otherwise, repeated calls — by the same or different approvers, depending on workflow configuration — progress the item through each step until the final approval completes the workflow. The endpoint does not distinguish between "step approval" and "final approval" in its API surface; both are the same call, and the workflow engine determines the effect based on the step the item is currently on. --- Required Permission| Roles with the Required Permission | ---------|----------| PRICEGRID_SUBMIT | Edit LPG & Add Products (PB_PRICEGRIDEDITOR_ADD_SKU), Edit LPG (PB_PRICEGRIDEDITOR), Administer LPG (PB_PRICEGRIDS) ## List Live Price Grids - [POST /fetch/PG](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-fetch-pg.md): Retrieves all Price Grids based on filter settings. --- Filter example: Returns only Price Grids where status = CANCELLED. json { "data":{ "_constructor":"AdvancedCriteria", "operator":"and", "criteria":[ { "fieldName":"status", "operator":"equals", "value":"CANCELLED" } ] } } --- ## Get a Live Price Grid - [POST /fetch/PG/{id}](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-fetch-pg-id.md): Retrieves details of the specified Live Price Grid. ## List Live Price Grid Items - [POST /pricegridmanager.fetch/{id}](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-pricegridmanager.fetch-id.md): Retrieves Live Price Grid Items. A filter can be applied. Filter example: Returns the item where id = 644. > #### Please note: > Filtering by typedId is not accepted by this enpoint. json { "endRow":300, "oldValues":null, "operationType":"fetch", "startRow":0, "textMatchStyle":"exact", "data":{ "_constructor":"AdvancedCriteria", "operator":"and", "criteria":[ { "fieldName":"id", "operator":"equals", "value":644 } ] } } Required Permission| Roles with the Required Permission | ---------|----------| PRICEGRID_FETCH | Edit LPG & Add Products (PB_PRICEGRIDEDITOR_ADD_SKU), Edit LPG (PB_PRICEGRIDEDITOR), Administer LPG (PB_PRICEGRIDS), Investigate for Support (SUPPORT), Administer Plasma (PLASMA), Manage Workflow Logics (WF_BUILDER) ## Copy a Price Grid - [POST /pricegridmanager.copy/{id}](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-pricegridmanager.copy-id.md): Creates a copy of the specified Live Price Grid (including metadata and Price Grid Items). --- Required Permission| Roles with the Required Permission | ---------|----------| PRICEGRID_ADD | Edit LPG & Add Products (PB_PRICEGRIDEDITOR_ADD_SKU), Administer LPG (PB_PRICEGRIDS) ## Mass Edit Price Grid Items - [POST /pricegridmanager.massedit/{id}](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-pricegridmanager.massedit-id.md): Updates fields of specified Live Price Grid Items.Specify the items in the request body by the id field. > Information: > The id is the typedId without the PGI suffix. For example, the id attribute of the item with typedId = 649.PGI is 649. --- Required Permission| Roles with the Required Permission | ---------|----------| PRICEGRID_UPDATE | Edit LPG & Add Products (PB_PRICEGRIDEDITOR_ADD_SKU), Edit LPG (PB_PRICEGRIDEDITOR), Administer LPG (PB_PRICEGRIDS) ## Update a Live Price Grid Item - [POST /pricegridmanager.update/{id}](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-pricegridmanager.update-id.md): Updates a Price Grid Item. >To update items without a recalculation, use the /pricegridmanager.update/{id}/norecalc endpoint. --- Required Permission| Roles with the Required Permission | ---------|----------| PRICEGRID_UPDATE | Edit LPG & Add Products (PB_PRICEGRIDEDITOR_ADD_SKU), Edit LPG (PB_PRICEGRIDEDITOR), Administer LPG (PB_PRICEGRIDS) ## Update a Live Price Grid Item (No Recalculation) - [POST /pricegridmanager.update/{id}/norecalc](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-pricegridmanager.update-id-norecalc.md): Updates a Price Grid Item without recalculation. Use this endpoint to skip recalculation of comments and manualResultPrice (Manual Override). --- Required Permission| Roles with the Required Permission | ---------|----------| PRICEGRID_UPDATE | Edit LPG & Add Products (PB_PRICEGRIDEDITOR_ADD_SKU), Edit LPG (PB_PRICEGRIDEDITOR), Administer LPG (PB_PRICEGRIDS) ## Delete a Price Grid Item - [POST /pricegridmanager.delete/{id}](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-pricegridmanager.delete-id.md): Deletes a Live Price Grid Item object from the specified Live Price Grid. --- Required Permission| Roles with the Required Permission | ---------|----------| PRICEGRID_REMOVE | Edit LPG & Add Products (PB_PRICEGRIDEDITOR_ADD_SKU), Administer LPG (PB_PRICEGRIDS) ## Deny a Live Price Grid Item - [POST /pricegridmanager.reject/{id}](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-pricegridmanager.reject-id.md): Sets the approvalState field to Denied. --- Required Permission| Roles with the Required Permission | ---------|----------| PRICEGRID_SUBMIT | Edit LPG & Add Products (PB_PRICEGRIDEDITOR_ADD_SKU), Edit LPG (PB_PRICEGRIDEDITOR), Administer LPG (PB_PRICEGRIDS) ## Delete a Price Grid Item (Filter) - [POST /pricegridmanager.delete/{id}/batch](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-pricegridmanager.delete-id-batch.md): Deletes a Live Price Grid Item based on filter settings. --- Filter example: Deletes only Price Grid Items where comments = "del". json { "data": { "filterCriteria": { "operator": "and", "criteria": [ { "fieldName": "comments", "operator": "iEquals", "value": "del" } ] } } } --- Required Permission| Roles with the Required Permission | ---------|----------| PRICEGRID_REMOVE | Edit LPG & Add Products (PB_PRICEGRIDEDITOR_ADD_SKU), Administer LPG (PB_PRICEGRIDS) ## Add Price Grid Items to a Price Grid - [POST /pricegridmanager.add/{id}](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-pricegridmanager.add-id.md): Adds products to the Live Price Grid. > Information: > Only products that are not already in the Price Grid will be added. You can specify products by skus (see the example 1 below) or by filter settings (see example 2). --- Example 1: Adds only products with specified SKUs. json { "data":{ "skus":[ "p0001", "p0002" ] } } Example 2: Adds only products where formulaName = "CompetitionPricing". json { "data":{ "filterCriteria":{ "operator":"and", "criteria":[ { "fieldName":"formulaName", "operator":"iEquals", "value":"CompetitionPricing" } ] } } } --- >To add items without a recalculation, use the /pricegridmanager.add/{id}/norecalc endpoint. Required Permission| Roles with the Required Permission | ---------|----------| PRICEGRID_ADD | Edit LPG & Add Products (PB_PRICEGRIDEDITOR_ADD_SKU), Administer LPG (PB_PRICEGRIDS) ## Calculate a Price Grid - [POST /pricegridmanager.calculate/{id}](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-pricegridmanager.calculate-id.md): Starts a calculation of the entire Live Price Grid. --- Required Permission| Roles with the Required Permission | ---------|----------| PRICEGRID_CALCULATE | Edit LPG & Add Products (PB_PRICEGRIDEDITOR_ADD_SKU), Edit LPG (PB_PRICEGRIDEDITOR), Administer LPG (PB_PRICEGRIDS) ## Cancel a Calculation - [POST /pricegridmanager.cancel/{id}](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-pricegridmanager.cancel-id.md): Cancels a Price Grid calculation background job. --- Required Permission| Roles with the Required Permission | ---------|----------| PRICEGRID_CALCULATE | Edit LPG & Add Products (PB_PRICEGRIDEDITOR_ADD_SKU), Edit LPG (PB_PRICEGRIDEDITOR), Administer LPG (PB_PRICEGRIDS) ## Perform a Mass Action - [POST /pricegridmanager.massaction/{id}](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-pricegridmanager.massaction-id.md): Performs a mass workflow action on specified Price Grid Items based on filter settings. --- Example: Approves only products where activePrice = 250. json { "data":{ "_constructor":"AdvancedCriteria", "operator":"and", "criteria":[ { "fieldName":"activePrice", "operator":"equals", "value":250 } ], "workflowAction":"APPROVED", "comment":"Approved." } } --- Required Permission| Roles with the Required Permission | ---------|----------| PRICEGRID_UPDATE | Edit LPG & Add Products (PB_PRICEGRIDEDITOR_ADD_SKU), Edit LPG (PB_PRICEGRIDEDITOR), Administer LPG (PB_PRICEGRIDS) ## Count Mass Action Items - [POST /pricegridmanager.massactioncount/{id}](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-pricegridmanager.massactioncount-id.md): Returns a number of Price Grid Items that would be affected by the mass action operation. totalRows value = number of affected items. --- Required Permission| Roles with the Required Permission | ---------|----------| PRICEGRID_UPDATE | Edit LPG & Add Products (PB_PRICEGRIDEDITOR_ADD_SKU), Edit LPG (PB_PRICEGRIDEDITOR), Administer LPG (PB_PRICEGRIDS) ## Convert to Price List - [POST /pricegridmanager.convert2pl/{id}](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-pricegridmanager.convert2pl-id.md): Converts a Live Price Grid (including items) to a Price List. Returns the pricelistId. --- Required Permission| Roles with the Required Permission | ---------|----------| PRICEGRID_ADD | Manage Price Lists (PB_PRICELISTSEDITOR), Administer Price Lists (PB_PRICELISTS) ## Delete a Live Price Grid - [POST /pricegridmanager.delete](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-pricegridmanager.delete.md): Deletes the Price Grid specified by typedId. --- Required Permission| Roles with the Required Permission | ---------|----------| PRICEGRID_REMOVE | Edit LPG & Add Products (PB_PRICEGRIDEDITOR_ADD_SKU), Administer LPG (PB_PRICEGRIDS) ## Assign Customers - [POST /customermanager.assign](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-customermanager.assign.md): Assigns multiple customers to the specified entity (e.g., Price List, Live Price Grid, etc.). ## List Customer Assignments - [POST /customermanager.fetchassignments/{typedId}](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-customermanager.fetchassignments-typedid.md): Retrieves a list of customers assigned to the specified entity. A filter can be applied (see the request sample). ## List Live Price Grid Types - [POST /fetch/PGTT](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-fetch-pgtt.md): Retrieves a list of Live Price Grid Types. ## Delete a Live Price Grid Type - [POST /delete/PGTT](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-delete-pgtt.md): Deletes the specified Live Price Grid Type. ## Add a Live Price Grid Type - [POST /add/PGTT](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-add-pgtt.md): Creates a Live Price Grid Type. ## Update a Live Price Grid Type - [POST /update/PGTT](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/post-update-pgtt.md): Updates the Live Price Grid Type. ## Download a Live Price Grid Excel File - [GET /pricegridmanager.fetchxls/{id1}/{id2}/{id3}/{id4}/{id5}/{id6}/{id7}/{id8}/{id9}/{id10}/{id11}/{id12}/{id13}](https://api.pricefx.com/openapi/reference/pricefx-server_openapi/live-price-grids/get-pricegridmanager.fetchxls.md): Downloads the specified Price Grid in the XLSX format.