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.
- You will be navigated to the Dashboard page.
- Click the
icon. The Products section will be displayed as shown in the figure.
- Click Manage Price List. The Manage Price Lists page will be displayed.
- To create a price list, click Create Price List. You will be displayed the Create Price List page.
- 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
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.
- 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.
- 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.
- 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.
- 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.
- Navigate to the Upload Excel section and click Browse. You will be displayed a Open dialog box.
- 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.
- To upload the file, click Upload. You can find the upload status in the Task History section.
- 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 '
' icon in the Actions column.
- To know the upload failures, click the '
' icon (if existing). You will be navigated to the Bulk Tools > Error Log Summary page.
- 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.
- You can click and view the uploaded excel by clicking '
' icon of the respective row.
- You can also delete a row from the Task History section by clicking '
' icon of the respective row.