Updating product prices in mass

An opportunity to continue a discussion from Sage Summit...

How do you update your product prices when you have a change across lots of products? 

Who uses the price update function in Sage ERP X3?

  • We use Usage>Import. The user provides us a list of prices in Excel and we have a VB macro that creates the import file in the correct format. Then we run the Usage>Import utility and update the price lists.

  • We create the master price list in Excel and use the Import function to bring the file into X3.  We have multiple price lists (domestic, export, and customer specific)  After import to a custom table we use a process that we wrote to create the multiple price lists.

  • web service
    you can publish SPL and SPC objects and use the web services to update 1 or many items/price lists with a loop
    I also think there is a function for this in X3 but i'm not sure