bulk updates/ price changes

You can use text functions in Excel to generate a series of queries to do what you want to do.

For example, if your columns are ILC, Supplier, Cost, Price and you want a query to update all items with a new price, you could create a formula like this: =CONCATENATE("UPDATE Item SET Price = '",text(Price,0.00),"' WHERE ItemLookupCode ='"text(ILC,0),"'")

The other way is like this: ="UPDATE etc. "&A2" WHERE ItemLookupCode... '"&B2"'"

Check your Excel help file for help with text-related formulas.

You can copy and paste the resulting query statements into a Store Operations/HQ Administrator query.

Always backup your database first!

HTH, Tom

" snipped-for-privacy@paradiseorganics.net" wrote:

Price changes can be done with RMS using the Inventory Wizards and an Excel sheet with the ILC and the New Price. There is a KB article that explains this on CustomerSource.

For more functionality take a look at EMS SQL Import.

Rob

Hi Amy,

RMSynergy have written a range of bespoke Add-ons that enhance the capabilities of RMS. In particular one of the Add-ons we have written is Data Management. We wrote it with the view that you may want to import data according to a department or by supplier likewise we have written a profile that enables you to manipulate data on mass, again by department or supplier.

If you feel that this add-on would bring benefits to your organisation or would like more information on our complate range please do not hesitate to contact me and I will pass your details on to your local RMSynergy reseller.

Kind Regards

----------------------------------------------------------------- Grant Chaplin

RMSynergy snipped-for-privacy@rmsynergy.com

-----------------------------------------------------------------

Also look at the RR Import [store and hq] that can bring data and catalogue data changes. For a demo contact me.