# How to update MRP and ESP of products

The MRP (Actual Price) and ESP (Effective Selling Price) of products are initially set by you at the product level. You can change these prices anytime. However, updating the prices in the product doesn't affect or replace the prices you've set in the inventory. Your website displays the prices mentioned in the inventory.

For changing the MRP or ESP of products at any of your selling locations, you can update the prices in the inventory rather than the product. Moreover, you can maintain different prices at each selling location than the ones you've set in the product.

![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/platform-panel/products/price-update/price-variation.png)

center
em
Keeping Product Prices Distinct At Different Selling Locations
br
In this document, you'll learn the following:

* [Updating Product Prices](#updating-catalogue-prices)
* [Updating Inventory Prices](#updating-inventory-prices)


## Updating Product Prices

### For Single Product

1. Search and open product whose prices you wish to edit.
2. Scroll down and click the edit icon (available for each size).
3. Locate the existing **Maximum Retail Price (MRP)** and **Selling Price**.
4. Edit and enter the new prices, and click **Save**.
Watch Out - Your product MRP in the product cannot be less than the highest MRP you defined in the inventory of your selling locations. Check fig. 4b, 4c, and 4d.
Let's say you have entered a product MRP lower than the MRPs mentioned in the inventory.
While saving the changes, you might get an error as shown below.
In such a case, check the inventory of that product to get the highest of all the MRPs mentioned across your selling locations. Go back and fix the product MRP.
5. Save the changes.


What to do if you still want to reduce the product MRP?

If you are unable to set a lower MRP in the product because the inventory MRPs are higher, reduce the inventory MRPs first. Later, you can bring down the product MRP.

### For Multiple Products

1. Go to the **My Products** section on Fynd Commerce , and click **Bulk Action** and select **Export**.
2. Click **Product**.
3. Click the **Generate** button to get your existing product files in a format used by Fynd Commerce .
4. You can use the filters to download a product of your choice:
  * **Template** - The template you wish to download, e.g. topwear, bottomwear, etc.
  * **Brand** - The brand whose products you wish to download in the product, e.g. Reebok, Nike, etc.
  * **Type** - The file type of the product you wish to download, e.g. Excel or CSV
The product file(s) will be generated. This might take some time depending on the number of products in the product.
5. A zip file will be downloaded, extract it to get all the product files.
6. Open the required product file for editing.
![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/platform-panel/products/price-update/extracted-files.png)
Figure 13: Content Within Zip File

![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/platform-panel/products/price-update/catalogue.png)
Figure 14: Product

7. There are several headers (columns) in the product file. The following headers are mandatory to keep:
  * Item Code
  * Brand
  * Gtin Type
  * Gtin Value
  * Seller Identifier
  * Size
  * Actual Prize
  * Selling Price
  * Currency
  * Length
  * Width
  * Height
  * Weight
Except for the above, you may delete all other columns.
![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/platform-panel/products/price-update/before-update.png)
Figure 15: Keeping Relevant Details

8. Enter the new values in the **Actual Price** and **Selling Price** columns. Add a new column named **Command** and type **Update** in the rows where you have modified the prices.
![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/platform-panel/products/price-update/command-update.png)
Figure 16: Editing The Prices

Watch Out - Actual Price in the product cannot be less than the highest actual price you defined in the product's inventory.
9. Upload the edited file by clicking on **Import** → **Product**.
10. Depending on the product you've edited, choose the applicable *Type*, *Departments* and *Template* from the drop-down. Next, use the file uploader on the right side to upload the edited file.
11. You may re-check the `File Data` which shows all the fields of the uploaded file. If there is no error, you can use the **Upload** button to push your data.
12. A batch job will run for uploading the data. The status will move from **`PENDING`** to **`COMPLETED`** stage once all the data uploads successfully.


Important - For changing the MRP or ESP of products at any of your selling locations, update the prices in the inventory rather than the product.

## Updating Inventory Prices

### For Single Product

1. Search a product whose prices you wish to edit, and click **Edit Inventory**.
2. Click on a particular size, and you will see a list of selling locations with respective Maximum Retail Price and Selling Price. Click on **Edit**.
3. Enter your new values in **Maximum Retail Price (MRP)** and **Selling Price**. Click on **Save**.
As guided in step 3, you can update Maximum Retail Price and Selling Price values for other selling locations too.
Watch Out - MRP in the inventory should be less than or equal to the MRP you defined in the product, but not greater.
4. You can check the updated prices on your website. Simply select the product size, and you'll see the new MRP and SP for each location.


### For Multiple Products

1. Go to the **Products** section in Fynd Commerce , and click the **Export** button.
2. Click **Inventory** in the pop-up.
3. Click the **Generate** button on the top-right.
4. Select **Store**, **Brand**, and **Type** from the drop-down available in each option. Here, we have selected all stores and brands. Now, click on **Export**.
  1. Inventory export job will begin with **RUNNING** status as shown in the figure below.
5. Click the download icon once the status changes to **SUCCESS**. A zip file will start downloading to your PC.
6. Open the downloaded zip file and extract it.
  1. Find the exported Excel/CSV file within the extracted folder.
7. Open the Excel file, and locate the seller identifier of products whose Maximum Retail Price and Selling Price you wish to update. Here, we have selected two products and we will change their prices at each selling location.
![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/platform-panel/products/inventory-price-update/inventory-file.png)
Figure 35: Locating Products To Update
(Optional) You may delete the rows where the prices aren't changed.
8. Enter the new **Actual Price** and **Selling Price**, and save the file.
![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/platform-panel/products/inventory-price-update/new-prices-file.png)
Figure 36: Updating MRP And ESP

Watch Out - Actual Price in the inventory should be less than or equal to the actual price you defined in the product.
9. Go back to the Products section.
10. Click the **Import** button.
11. Click **Inventory** in the pop-up.
12. Use the file uploader to upload your Excel file.
13. Verify the data once. Click on **Upload** in the top-right corner.
  1. The bulk upload will initiate and it can be viewed under 'Upload History' as shown below. The upload status will be shown as **`PENDING`**. Wait till the status turns to **`COMPLETED`**.
14. Visit your website, and you will see the updated Maximum Retail Price and Selling Price for the products modified in the Excel file.