Update the Prices in Excel Sheet

  1. Refer to the following article to download the Product List
  2. Open the downloaded file. Following columns can be updated and imported (attached a sample file for reference)


    Header
    Description
    Required
    cost_price
    Enter the cost price of the product
    Optional
    tax_name
    Enter the Tax Name of the product
    Optional
    tax_percentage
    Enter the Tax Percentage of the product
    Optional
    tax_inclusive
    yes: if entered cost price is inclusive of taxes
    no: if cost price is exclusive of taxes
    Disabled by default
    Required
    charge_name
    Enter the Charge Name is applicable
    Optional
    enabled
    yes: if the product to be enabled
    no: if the product to be disabled
    Disabled by default
    Required
    inventory_tracking
    yes: if inventory tracking should be enabled
    no: if inventory tracking should be disabled
    Disabled by default
    Required
    sale channel_display_selling_price
    Enter the MRP of the product
    Optional
    sale channel_selling_price
    Enter the Selling Price of the product
    Required
    sale channel_tax_name
    Enter the Tax Name of the product
    Required
    sale channel_tax_percentage
    Enter the Tax Percentage of the product
    Required
    sale channel_tax_inclusive
    yes: if entered selling_price is inclusive of taxes
    no: if entered selling_price is exclusive of taxes
    Disabled by default

    sale channel_charge_name
    Enter the Charge Name is applicable
    Optional
    sale channel_enabled
    yes: if the product to be enabled for the sale channel
    no: if the product to be disabled for the sale channel
    Disabled by default
    Required
    sale channel_sellable
    yes: if the product is sellable for the sale channel
    no: if the product is sellable for the sale channel
    Enabled by default
    Required

       3. Save the file after making the changes for all the required products


Import the sheet

  1. Click on Products and select Product Prices
  2. Select the Location for which the Price list has to be updated and click on Import
  3. Select the price list file which is ready to import by clicking on Browse. Click on Import 
  4. You will receive notifications on the status of the import