How can I vary the prices of my products as per the location and/or channel?

OR

How can I differ the prices of my products among the user groups?

OR

How can I change the prices as per the order quantity?

OR

How can I apply the specific prices only for a limited period of time?

OR

How can I create price lists?


To vary the prices of your products as per location and/or channel, user group or order quantity or to create a price list, do the following:

  • Log in to the 'Anywhere Commerce Control Panel' by using your User Name (Email Address) and Password.


 Manage Price List

  • You will be navigated to the Dashboard page.


 Manage Price List

  • Click the  Manage Price List icon. The Products section will be displayed as shown in the figure.


 Manage Price List

  • Click Manage Price List. The Manage Price Lists page will be displayed.


 Manage Price List

  • To create a price list, click Create Price List. You will be displayed the Create Price List page.


 Manage Price List

  • Enter the name of the price list in the Price list name text box.
  • Enter a unique reference code for this price list (just for your reference only) in the Reference Code text box.
  • Location: This defines for which location the price list is applicable.
    • If you want to vary the product prices as per location, click the  Manage Price List icon of the Location text box. You will be displayed a Store Location dialog box.
    • Note: If no location is selected, the price list will be applicable to all the locations.


  Manage Price List

  • Note:
    • All the locations of your store for which the Enable location wise shipments for this location checkbox is selected, are displayed in this dialog box.
      Please refer: Adding A Stock Location

    • If you apply a price list to a 'Parent Location', the price list will be applied to all its child locations if there are no exclusive price lists configured to those 'child locations'.

    • That means, if any price list is configured to a child location, that price list will be applied to that child location and for the rest of the child locations (which are under a parent location), the price list of their parent location will be applied.
  • There are two methods for finding out required Locations:
    • i) Start entering the 'location name' in the Search Location text box slowly. You will be displayed auto-completed list according to the entered criteria. Select the required location from this list.
      or
    • ii) Expand the location hierarchy and select the required location.
    • Click Submit. The Select Location dialog box will be closed and the name of the selected location will be displayed in the Location text box.
  • If you want to vary the product prices as per user group, select the respective user group from the User group drop-down.
    • Note: If you want to vary the product prices based on both location and user group, select both respective the location and user group.
  • To apply the price list only for a limited period of time, select the 'from date & time' from the From Date 'date & time picker' and 'to date & time' from the To Date 'date & time picker'.
  • Select the channel to which you want to apply the price list from the Channel drop-down.
    • Note: The Channel drop-down will be displayed if you are connected to some channels through the 'SellerWorx'.
  • To save the price list and define the applicable SKUs & prices for this price list, click Save And Continue. You will be navigated to the Price List Details page. Now you can create some more price lists as per your requirement.
    • Note: If you click the Save And Exit button, the price list will be saved under the Price List section of the Create Price List page.


 Manage Price List

  • To associate SKUs and prices to this price list, you need to download the excel format. To download the same, click Download excel format. The ProductPriceList.xlsx file will be downloaded. To open the Excel, double-click on it. The respective Excel sheet will be opened as shown in the figure.


 Manage Price List

  • Enter SKU, Variant SKU (if it is a Product Variant), Quantity, MRP, Web Price, Token Price in the respective columns of Excel sheet.
  • Group Ref Code: The 'Group Ref Code' helps to maintain the location-specific prices for the required items of the bundle groups. There may be some 'normal products' as well as some 'Add-ons' in a bundle group. Enter the reference code of the respective bundle group in the Group Ref Code column against both the 'Add-on' as well as the 'normal' products as per your requirement.
    • Note: You also define the location-specific prices for the required items of bundle groups against all the required locations in one go through the Location Wise Stock and Price Download module.
    • Let's see how it works for Add-on Products and Normal Products:
      • Add-on Product - Both 'Ref Code' and 'Web Price' specified scenario: The Web Price specified in the ProductPriceList.xlsx will be considered (i.e. overrides) for that Add-on at the Price list's location for only that bundle group having the specified ref. code in respective 'Bundle products/Deals'.
      • Add-on Product - 'Ref Code' not specified but 'Web Price' specified scenario: The Web Price specified in ProductPriceList.xlsx will be applicable for that Add-on at the Price list's location for any bundle group in respective 'Bundle products/Deals'
    • i) Normal Product - Both 'Ref Code' and 'Web Price' specified scenario: The Web Price specified in the ProductPriceList.xlsx will be considered (i.e. overrides) for that normal product at the Price list's location for only that bundle group having the specified ref. code in respective 'Bundle products/Deals'.
    • ii) Normal Product'- Ref Code' not specified but 'Web Price' specified scenario: The Web Price specified in the ProductPriceList.xlsx will be applicable for that normal product at the Price list's location for any bundle group in respective 'Bundle products/Deals'. As this is a normal product, the Web Price specified in this Excel will also be applicable for this normal product in that Price list's location.
  • Note: If you want to define the location-specific prices for the required bundle group items against the required locations in one stretch, you can do it through the LocationWiseStockOrPriceXXXXXXXXXXXXXX.xlsx.
    Please refer: Location Wise Stock and Price Download
    • Note: 'Quantity (enter lower limit of the quantity range)' column facilitates to specify the quantity range for varying the prices as per the quantity.

  • Enter the lower limit of quantity range in the Quantity (enter lower limit of the quantity range) column.
    • For Example, If you want to vary product prices such as: for purchases up to 5 products - the price is the normal price as defined to the product; for 6-50 products - the Price is Rs. X; and above 50 products - the price is Rs. Y.
      Enter 6 in the first 'Quantity (enter lower limit of the quantity range)' column & enter X in the corresponding 'Web Price' column, and enter 51 in the next 'Quantity (enter lower limit of the quantity range)' column & enter Y in the corresponding 'Web Price' column.
    • For varying the prices as per quantity range, you need to specify 'same SKU' at all respective rows with the 'different quantity and price values'.

    • If there are no quantity range based prices, still you need to mention 1 in the 'Quantity (enter lower limit of the quantity range)' column.

    • If you mention the prices based on the quantity range, you need to specify the same SKU/Variant SKU against all the corresponding rows.

Tier Pricing:

  • You can display a table (i.e. Tier pricing widget) on 'Product Details' page for showing the variation of prices as per quantity, by defining the prices based on quantity as explained above and adding respective MJTL tag in the Productdetails.xslt.
    • Please refer: Productdetails_xsl for more details.
    • An example of tier pricing after successful configuration is displayed in the following figure:


 Manage Price List

  • Save the ProductPriceList.xlsx in a suitable location.
  • Note: There is a limit for upload. At a time you can upload a maximum of 10,000 rows only. So, if the maximum number of rows are greater than 10,000, prepare multiple ProductPriceList.xlsx files and upload one by one.
  • Now you can upload this Excel.
  • To upload the updated ProductPriceList.xlsx, click Proceed to upload in the Price List Details page. You will be navigated to the Upload Price List Excel page.


 Manage Price List

  • Navigate to the Upload Excel section and click Browse. You will be displayed a Open dialog box.


 Manage Price List

  • Select the updated ProductPriceList.xlsx from the stored location and click Open. The Open dialog box will be closed and the name of the uploaded file will be displayed in the Upload a file text box.


 Manage Price List

  • To upload the file, click Upload. You can find the upload status in the Task History section.


 Manage Price List

  • You can find the 'status of upload', 'total number of rows in the excel', 'number of rows updated (i.e. uploaded)', 'number of rows failed to upload due to validations or exceptions' in the respective columns.
  • If any rows failed to update (i.e. upload, you can find the ' Manage Price List' icon in the Actions column.
  • To know the upload failures, click the ' Manage Price List' icon (if existing). You will be navigated to the Bulk Tools > Error Log Summary page.


 Manage Price List

  • Verify the error messages and update the data accordingly.
  • Again follow the above-mentioned uploading procedure and upload the file. If all rows are uploaded, you can find the Total Rows and Updated Rows are same in the Task History section.


 Manage Price List

  • You can click and view the uploaded excel by clicking ' Manage Price List' icon of the respective row.
  • You can also delete a row from the Task History section by clicking ' Manage Price List' icon of the respective row.

Learn More:


learnmore2.jpg
1. To enable the 'price lists' (i.e. if 'Price List' want to applied), you need to select either the Minimum Price or Maximum Price radio button in the Enable Price List section of the Application Settings > Store Settings page and click Save.

By default, one of the radio buttons is selected (Note: You can change the selection if required), but unless you click Save, the price list will not work.

Note: Sometimes a user may qualify for different price lists.
For example, the user may qualify for both 'location' and 'user group' based price lists; or the user may be existing in different user groups, etc…
However, in this scenario still, you can control the product prices by defining the Minimum Price or Maximum Price. If the Minimum Price is defined, the minimum product price of all qualified price lists will be applied to the user and vice versa.

Please Refer: Enable Price List

2. The location wise price list will be applied only when you have installed the 'Enable storefront for location awareness' App and when the user has selected the respective location in the storefront.

Please Refer: the 'Enable Storefront for Location Awareness' topic in App Store.

Note: When the user selects the respective location in the storefront, the prices will be automatically changed in the showcase. A user can also select the location in the product details page or cart page and the respective product prices will be visible accordingly in the product details page or cart page respectively.

3. If the price list is purely location wise, and you have enabled the Price Lists, the respective prices that you have mentioned in the ProductPriceList.xlsx will be directly displayed for that location (i.e. after the user selects that location) to those products which are mapped to that location. That means the new prices will be applied to those products which specified in the ProductPriceList.xlsx against respective store location.

4. If the price list is created exclusively for a 'user group' or for the combination of both 'location & User Group', the prices of that price list will be applied if the user logs in through the Up-front Login or logs in before entering the 'single page checkout' page. If the user crosses 'cart page' and enters to the 'single page checkout page', the user group wise price list will not be applied to that user. That means only normal prices will be applicable to the user now.