Multiple Inventory item price adjustment.

Question

Good day! Is there a way to change the prices of many inventory items at the same time instead of going to each and every one? We have several hundred items that have had varying prices but we are changing them all to be the same price across the board but doing so one-by-one is just an insane amount of time for something that should be so simple to do.

We are using Sage 50c Pastel Partner Build 19.3.5 if that helps

Mpho Makgoba · Accepted Answer

Hi Harry 
 Ensure you have logged into your company. Should the import/export filled still be greyed out. Log in with a user who has supervisor rights, then they give you the right to use the import filled. 
 Follow the steps in our Knowledge base article: How do I create a new user and set user permission or access? 
 If my answer does help, let me know by clicking on Verify answer. Mpho

Mpho Makgoba · Answer

Hi Harry, 
 
 You can be able to import an excel file with batch of selling prices. Below are steps on how to import the csv file into Pastel: 
 -Open Pastel 
 -Login to the company 
 -Select file>Export/import -Choose the option "import selling prices" - Navigate to where the file is saved -Ensure "include field names" is untick 
 -Select process the file will be imported into Pastel Please refer to the link below with the import & Export File Layout for Selling Prices: https://za-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=200123113352384&page=1&position=0&q=import%20selling%20prices 
 
 Kind regards, Mpho.

Sage 50cloud Pastel

Multiple Inventory item price adjustment.

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING