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 catalogue-level. You can change these prices anytime using the Partial Update feature. However, updating the prices in the catalogue doesn't affect the prices you've set in the inventory.

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

QG1

Keeping Product Prices Distinct at Different Selling Locations

In this document, you'll learn the following:


Updating Prices Through UI#

  1. Go to the Products section in Fynd Platform, find your product, and click the drop-down present besides the Edit Product button.

    QG1

    Figure 1: Drop-down in Products section

  2. Select Edit Inventory for the desired product whose Maximum Retail Price and Selling Price you wish to update.

    QG1

    Figure 2: Edit Inventory Option

  3. 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 3: Editing Inventory

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

    QG1

    Figure 4a: Changing MRP and ESP for first location

    QG1

    Figure 4b: Changing MRP and ESP for second location

    QG1

    Figure 4c: 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 multiple selling locations.

  5. 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 5a: Selecting Size

    QG1

    Figure 5b: Selecting a Selling Location

    QG1

    Figure 5c: New MRP and ESP values displayed


Updating Prices Through Excel#

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

    QG1

    Figure 1: Products Section

  2. Click Inventory in the pop-up.

    QG1

    Figure 2: Bulk Inventory Export

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

    QG1

    Figure 3: 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 4a: Selecting Filters

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

    QG1

    Figure 4b: 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 5: Downloading Generated Inventory File

  6. Open the downloaded zip file, and extract it as shown in the figure below.

    QG1

    Figure 6a: Extracting Zip Content

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

    QG1

    Figure 6b: 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 7: Selecting Products
    note

    (Optional) You may delete the rows where the prices aren't changed.

  8. Enter new Actual Price and Selling Price and save the file.

    QG1

    Figure 8: Updating MRP and ESP

  9. On Fynd Platform, go back to the Products section.

    QG1

    Figure 9: Download Inventory Screen

  10. Click the Import button.

    QG1

    Figure 10: Products Section

  11. Click Inventory in the pop-up.

    QG1

    Figure 11: Bulk Inventory Import

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

    QG1

    Figure 12a: Uploading Excel File

    Verify the data before proceeding with inventory upload.

    QG1

    Figure 12b: Upload Bulk Inventory Window

  13. If the file is valid, you can upload your inventory. Click on Upload in the top-right corner.

    QG1

    Figure 13a: 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 13b: Batch Processing Started

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

    QG1

    Figure 14: New MRP and ESP values of a product on PDP