Skip to main content

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

Keeping Product Prices Distinct At Different Selling Locations

In this document, you'll learn the following:


Updating Product Prices

For Single Product

  1. Search a product whose prices you wish to edit, and click Edit Product.

    QG1

    Figure 1: Drop-down In Products section

  2. Scroll down and click the edit icon (available for each size).

    QG1

    Figure 2: Edit Details

  3. Locate the existing Maximum Retail Price (MRP) and Selling Price.

    QG1

    Figure 3: MRP And ESP Fields

  4. Edit and enter the new prices, and click Save.

    QG1

    Figure 4a: Saving The New Prices

    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.

    QG1

    Figure 4b: Product MRP Lesser Than Inventory MRP

    While saving the changes, you might get an error as shown below.

    QG1

    Figure 4c: Error Encountered While Saving

    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.

    QG1

    Figure 4d: Checking Inventory-level MRP

  5. Save the changes.

    QG1

    Figure 4d: Clicking The Save Button

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 All Products section on Fynd Platform, and click Export.

    QG1

    Figure 5: Export Button

  2. Click Product.

    QG1

    Figure 6: Choosing Product Export

  3. Click the Generate button to get your existing product files in a format used by Fynd Platform.

    QG1

    Figure 7: Downloading All Product Files

  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

    QG1

    Figure 8a: Filters For Generating Catalogue

    The product file(s) will be generated. This might take some time depending on the number of products in the product.

    QG1

    Figure 8b: Product Generation (In Progress)

  5. A zip file will be downloaded, extract it to get all the product files.

    QG1

    Figure 9a: Product Export (Completed)

    QG1

    Figure 9b: Extracting The Zip File

  6. Open the required product file for editing.

    QG1

    Figure 10a: Content Within Zip File

    QG1

    Figure 10b: 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

    Figure 11: 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

    Figure 12: 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 ImportProduct.

    QG1

    Figure 13a: Import Button

    QG1

    Figure 13b: Import Products

  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.

    QG1

    Figure 14: Choosing Template To Upload

  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.

    QG1

    Figure 15: Uploading The File 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.

    QG1

    Figure 16a: Batch Job Initiated

    QG1

    Figure 16b: Batch Job Successful

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.

    QG1

    Figure 17: Edit Inventory Option

  1. 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.

    QG1

    Figure 18: Editing Inventory

  1. Enter your new values in Maximum Retail Price (MRP) and Selling Price. Click on Save.

    QG1

    Figure 19a: Changing MRP And ESP For First Location

    QG1

    Figure 19b: Changing MRP And ESP For Second Location

    QG1

    Figure 19c: Updated MRP And ESP values For Selling Locations

    note

    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.

  2. 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.

    QG1

    Figure 20a: Selecting Size

    QG1

    Figure 20b: Changing Selling Location

    QG1

    Figure 20c: Selecting Selling Location

    QG1

    Figure 20d: New MRP And ESP Values Displayed

For Multiple Products

  1. Go to the Products section in Fynd Platform, and click the Export button.

    QG1

    Figure 21: Products Section

  2. Click Inventory in the pop-up.

    QG1

    Figure 22: Bulk Inventory Export

  3. Click the Generate button on the top-right.

    QG1

    Figure 23: Clicking the Generate Button

  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.

    QG1

    Figure 24a: Selecting Filters

    Inventory export job will begin with RUNNING status as shown in the figure below.

    QG1

    Figure 24b: Running A Batch Job

  5. Click the download icon once the status changes to SUCCESS. A zip file will start downloading to your PC.

    QG1

    Figure 25: Downloading Generated Inventory File

  6. Open the downloaded zip file and extract it.

    QG1

    Figure 26a: Extracting Zip Content

    Find the exported Excel/CSV file within the extracted folder.

    QG1

    Figure 26b: Locating Excel/CSV File

  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

    Figure 27: Locating Products To Update
    note

    (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

    Figure 28: 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.

    QG1

    Figure 29: Download Inventory Screen

  10. Click the Import button.

    QG1

    Figure 30: Products Section

  11. Click Inventory in the pop-up.

    QG1

    Figure 31: Bulk Inventory Import

  12. Use the file uploader to upload your Excel file.

    QG1

    Figure 32: Uploading Excel File

  13. Verify the data once. Click on Upload in the top-right corner.

    QG1

    Figure 33a: Uploading Inventory

    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.

    QG1

    Figure 33b: Batch Processing Started

  14. Visit your website, and you will see the updated Maximum Retail Price and Selling Price for the products modified in the Excel file.

    QG1

    Figure 34: New MRP And ESP Of A Product On PDP