How to bulk update item sales price

Method 1

Step 1 :  Login to your AltheaSuite account.

Step 2 :  From main menu options navigate to Products > Items.

Step 3: By default All Items will be selected, but if you want to update price of any specific Category, go ahead and select that Category.

Step 4: You can also go to the second filter and select any sub category or item fields to change the item price.

Step 5: Click Export Item List To Excel. This will export all the items of selected category to excel.

Step 6: Look for SALESPRICE column in the downloaded excel. Update the price, save and close the excel.

Step 7: Go back to AltheaSuite and click Upload Items.

Step 8: Click OK on Select Business Location window.

Step 9: Click Browse, select the excel and click Item Upload.

Step 10: You will get a message once the excel is uploaded successfully. Close the message and close the Item Upload window.

Step 11: Refresh the window and you will see the updated Sales Price of items.

Method 2

Step 1: To adjust item prices by a fixed percentage (%), click on the Bulk Update option.

Step 2: Filter the items on how you want to apply the bulk update.

Here, we are updating the sales price of all items under a specific category.

Select the desired category from the dropdown list.

System will also show the total number of items that will be updated in the selected category.

Step 3: Choose either % Increased By or % Decreased By based on your requirement. Enter the desired percentage value, then enable the “Apply” box to proceed.

Step 4: Click on the “Bulk Update” to apply the changes.

A confirmation popup will appear and also a message at the bottom of the screen will display: “Bulk edits on items are applied successfully”.

Step 5: You will now see that the sales prices of all items in the selected category have been decreased by 2% (as per the percentage entered).