Hi there
I receive pricelists often from suppliers etc and I need to update our prices on Evolution. To amend each item individually will take me years to do. I know there is a Data Import and Data Export function. When I go Import, it first gives me some path issue but that's easy to figure out. What I need is the process to create a import template that links item's description1 with the price. I then simply put in all the prices in this excel file and import it to update all the inventory's prices.
A guy that worked at the company previously was apparently able to do it but he is gone and nobody else knows...not even our Sage consultants by the looks of it. I could do an export template but I do not know which table or column to select to have it output at least the prices as they stand...I'm sure I can then use that same file as an import template?
HELP! Thanks in advance.
