Is there any software out there, compatible with RMS, that would allow us to do bulk updating of our items using an excel spreadsheet? We are looking for something fairly advanced that would enable us to do mass price changes based on supplier and item lookup codes. Also need to be flagged on new items and discontinued items. Know of anything that sounds similar? Thanks
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.
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.