Categories

RMS - 03.2 How to use Excel file to Delete Item Selling Price of Multiple Product items

Downloading a DeleteProductPrice Excel Template

1. Go to Product > Product Item. Click on the cloud with up arrow icon on the upper right corner.

pasted_image_file683931da79aa4-image_VNwLV.png


2. Click on "Delete Product Price" to download the excel file.

pasted_image_file68393233a5525-image_HXVvQ.png


3. 
Open the Excel file and fill in the following:


  • ItemCode = Item Code of the Product Item
  • SPTCode = "MYR" if currency code is Malaysian Ringgit
  • EffDate = the effective date of the price of the item you want to delete.
  • SPTTag = Price Tag code. Leave blank if no use.

4. After done edit, save the excel file and then upload it by clicking on the cloud with up arrow icon beside the cloud with down arrow icon at step 1. Choose "Import Files" and select the saved excel file.

pasted_image_file683937ccc8b65-image_miZwu.png


5. If the entries are correct and valid, the file will be successfully uploaded. If not, the system will give an error and the file cannot be uploaded.


pasted_image_file683938b4888d7-image_wYIto.png


6. Now the pricing on the effective date of the product items have been deleted.