bulk updates/ price changes

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

0
amy1517 (1)
5/11/2006 6:49:33 PM
pos 14173 articles. 0 followers. Follow

4 Replies
328 Views

Similar Articles

[PageSpeed] 24

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


"amy@paradiseorganics.net" wrote:

> 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
> 
> 
0
tomg1 (230)
5/11/2006 7:48:02 PM
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. www.sqlmanager.net

Rob

<amy@paradiseorganics.net> wrote in message 
news:1147373373.867746.152420@i40g2000cwc.googlegroups.com...
> 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
> 


0
Rob
5/11/2006 8:56:18 PM
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
info@rmsynergy.com

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

<amy@paradiseorganics.net> wrote in message 
news:1147373373.867746.152420@i40g2000cwc.googlegroups.com...
> 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
> 


0
RMSynergy
5/11/2006 10:38:11 PM
Also look at the RR Import [store and hq] that can bring data and catalogue 
data changes.  For a demo contact me.

Afshin Alikhani - [afshin@retailrealm.co.uk]
CEO - Retail Realm
= = = = = = = = =
<amy@paradiseorganics.net> wrote in message 
news:1147373373.867746.152420@i40g2000cwc.googlegroups.com...
> 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
> 


0
afshin (783)
5/14/2006 9:19:59 AM
Reply:

Similar Artilces:

my column headers has changed to numeric from alphabetcal order #2
I have come across strange problem ..my column names has chnaged to numeric from alphabet and now none of my formulaes work as all the cell names show up as R1C1 , R1C2 and so on... Anyone knows what have i messed up ??? Hi Annie, Try: Tools | Options | General Tab | Uncheck R1C1 reference style. --- Regards, Norman "Annie" <Annie@discussions.microsoft.com> wrote in message news:1FE6319D-59BD-4BEE-9C77-B8B97AC78CEF@microsoft.com... >I have come across strange problem ..my column names has chnaged to numeric > from alphabet and now none of my formulaes work ...

Update Fails to Load
I have tried several times to install KB979683 and keep getting failure message. All other updates load fine. Also, have Stopzilla and McAfee Virus Scan but can't seem to get rid of a malicious file that won't let me go to sites when I look up things on google, bing....always get sent to advertisement websites. Any ideas or helpful suggestions!! Thanks Always state your full Windows version (e.g., WinXP SP3; WinXP 64-bit SP2; Vista SP1; Vista 64-bit SP2; Win7; Win7 64-bit) when posting in a forum or newsgroup. Please do so in your next reply. When does your McAfee su...

Try on this important update
--ibbinwkirijnhr Content-Type: multipart/related; boundary="jpcfngnkwxzrztrma"; type="multipart/alternative" --jpcfngnkwxzrztrma Content-Type: multipart/alternative; boundary="ksfkpxttkrplpf" --ksfkpxttkrplpf Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Consumer this is the latest version of security update, the "October 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to continue keeping your computer secure ...

Field within Form Not Updating
I have a form that runs off a query (the query runs off of 3 tables). One of the fields within the form is "Item". In Access 2003, when the user entered their Item number, the next field, item description, would automatically populate. Now, in Access 2007 the user must close the form and re-open it in order for the item description to populate. Any suggestions woule be appreciated. Do you have any code that runs in 2007? Code does not run in 2007 unless your database resides in a folder that has been declared a “trusted” location. To trust your folder, click: ...

Warum nach Update HBCI-PIN?
Hallo Uli, natürlich auch an alle anderen Moneyisten ein freundliches Hallo. Kennt mich überhaupt noch jemand hier? Daß ich lange Zeit (mögen vielleicht 2-3 Jahre sein) nicht mehr hier war ist die positive Bestätigung der Paarung Money/HBCI. Wir arbeiten klaglos mit dem System. Vieles ist neu bei Euch. Selbst die Update-Adressen waren nicht mehr aktuell. Auch das Forum ist wo anders auffindbar. Sieht aber alles sehr ordentlich aus. Gratulation an die unermüdlichen Idealisten. Ich habe eben die aktuellen Updates für DDBAC und HBCIFM99 Version 3.4.19 in...

User married-name change
I've read the posts from others but have not seen the complete answer. I have Exchange 2003 in Windows2003 AD environment. Is there a best practice for changing everything over when a user gets married. I changed everything in AD, added the the new email address to her profile setting it as primary. In Exchange System Manager, her mailbox still shows as her old name and emails she sends still show as old name. Any way to change this? Regards, -Karl One of the things that has come up before is that the rename should occur via right click on the user account in ADUC and then choose...

Update CRM Data using vb.net
Hi, I am new to CRM. I am trying to retrive and update information into CRM using my VB.Net application. I am able to retrieve information from CRM. But i am not able to update. Can any one tell me how to update contact information using VB.Net. If any sample program it will help me to create some applications. Thanks in advance. Phani Check out the Microsoft CRM examples on msdn.microsoft.com - a number of these show updfating data "Phani" <phanimadhavsv@hotmail.com> wrote in message news:Ow5xjhnWDHA.2064@TK2MSFTNGP11.phx.gbl... > Hi, > > I am new to CRM. I am...

How do I publish an Excel graph on the web such that it updates?
I need to place an excel line graph on a webpage that updates as data is updated from another excel file? Thanks, Mike In article <3E32A358-C1AE-497C-9BFF-2D156EDB57F1@microsoft.com>, MikeBSDLP@discussions.microsoft.com says... > I need to place an excel line graph on a webpage that updates as data is > updated from another excel file? Thanks, Mike > If the XL file is on your desktop there is no practical way for a chart on a web server to update itself, is there? If the XL file is on the server itself, you may want to look into a Office Web Components chart. Use of O...

Windows live Messenger Privacy Contact List View Wont Update
On Windows Live Messenger version 2009 (build 14.0.8089.76) vista 32 bit I can not see who has added me to their contact list or not. Even after some one has removed me i still can not delete them in tools/options/privacy. Does messenger just not do that function or some thing? Or could this be that a certain service should be turned on from services.msc? "snakejr" wrote: > On Windows Live Messenger version 2009 (build 14.0.8089.76) vista 32 bit I > can not see who has added me to their contact list or not. Even after some > one has removed me i still can n...

Direct statements for retirement account don't seem to update properly
Hi, When I manually update my retirement account from Fidelity by downloading a QIF statement and importing it, it works fine. However, if I do a direct update, the individual transactions do not appear. I just see lump sum adjustments in the cash account. I see a KB article here that sounds like this... http://support.microsoft.com/default.aspx?scid=kb;en-us;822766. Does anyone know if this will solve my problem and if there are any downsides to marking the account something other than 401K (which it is)? --John Hi John, First save your .mny file and then follow the procedure you fo...

Repetitive Assignment Update email Notification to all resources instead of the updated ones.
We are facing this issue on the project server, The software config of the same is Microsoft Project Server 2007 Version 12.0.0.4518, Project Professional 2007 & SQL 2005 sp3 9.00.4035 When we create a new project and assign task to resources (from project professional 2007) and later save and publish, the assigned resources get an email notification of their task and even they can view the same on the PWA site. Also the project is successfully saved and published on the Project Server. However when we open that project again in Project professional 2007 and add or edit any...

USB mass storage device asynchronous file change notification
Hello, A challenge: I have a (RAM) disk, which is exposed as a USB mass storage device. Therefore, the desktop computer accesses my disk as a SCSI block device. Also, I mounted the same disk using the FATFS and I can see files under WinCE, which have been just copied over USB from the desktop. So far, so good. Now: if I create a file under WinCE, the desktop computer does not notice and I can wait forever. When I unplug and plug-in the USB again, I can see the file created before under WinCE. Is there a sort of SCSI asynchronous file change notification? If so, is there any exam...

Change Folder Colors
How do I change the Organized folder colors from the standard Manilia The folder icons can't be changed. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook 2007: http://www.slipstick.com/outlook/ol2007/ Outlook Tips by email: dailytips-subscribe-request@lists.outlooktips.net Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Subscribe to Exchange Messaging Outlook newsletter: EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LS...

Excel updating from XML file
I'm having a littl edifficulty getting Excel to dynamically update from an XML file. The XML file is generated from a program and I would like the Excel file to dynamically update. Problem is that the location of the XML and Excel file can change, that is they can be anywhere on a hard drive but both are in the same directory. The mapping of the XML file in Excel appears to be a complete file path C:/data/report/.... but the location could change. They could be in C:/data/report/run1 or run2, I don't want to have to re-map each time a report is generated. Ideally I would like t...

Looking to change pivot table orientation
I'm using Excel 2007 and have a pivot table with many values and no row labels. This is making the pivot table very wide - like 15 columns and I'm wondering if there's a way to switch the orientation so that it would be 2 columns and 15 rows instead of 2 rows and 15 columns. Just move the fields around in the field list "eggman2001" <sodani@gmail.com> wrote in message news:4e21a055-eace-433c-b38f-73a93eb2566e@d34g2000vbl.googlegroups.com... > I'm using Excel 2007 and have a pivot table with many values and no > row labels. This is making the ...

mass change of numbers to alphabetic
I have a large spreadhseet with three groupings of numbers 1. less then 0 (this can be anything from -1 and below) 2. greater then 0 (this can be anything from 1 and above) 3. zero I need to change items that are: 1.less then 0 to a Y, 2. greater then 0 to an N; and 3. 0 to NA. I would really appreciate if someone could let me know how this can be done. Regards, Jeff try this Sub changenums() For Each c In Selection If c < 0 Then c.Value = "Y" ElseIf c > 0 Then c.Value = "N" Else c.Value = "NA" End If Next End Sub -- Don Guillett SalesAid Softwa...

How can you change an Access datasheet column header height or wra
If you have a column in an Access datasheet where the name is larger than the data, it would be nice to be able to make the column header wrap or be able to resize the datasheet header row to display more than one line. "Bitsmith" <Bitsmith@discussions.microsoft.com> wrote > If you have a column in an Access datasheet where the name is larger than > the > data, it would be nice to be able to make the column header wrap or be > able > to resize the datasheet header row to display more than one line. You don't have nearly the formatting capabilities in d...

CBM should let me change account code for AP & AR when recording.
On recording payments/ receipts using Cashbook Management batches, it is impossible to change the distribution accounts of the Creditor/ Vendor. Our clients have Five (5) divisions and it is company policy to keep Creditor/ Vendor details seperately for each of the divisions. We have Three (3) segments in our account format with the first segment representing Divisions. We want to be able to change divisions for the related payments to Creditors/ Vendors. We would like you to include this in the feature. Thank you. ---------------- This post is a suggestion for Microsoft, and Micro...

Numbers are changed in Excel?
I created a spread sheet of some stuff. I entered some serial and account numbers. For some reason that everyone but me probably knows the numbers are changed by Excel by inserting a ., a + sign, etc. hat are not as I typed. What's going on here? Thanks. I would say it's some formatting (either default or pre-existing) in those cells. Try giving all those cells the "Text" format. Then Excel won't add decimal places or signs. I -think- Excel won't let you do math with those values (unless you convert them first), but you probably don't need to add or subtra...

Data update problem
Hello, We work with Dynamic CRM 3.0 (w2k3 server platform). Our corporate users (outlook 2003 and web mode) complain that performing changes in CRM and on the next day they see data before changes. How I can check that SQL transaction was successful or not? Is there detailed LOG? Thanks. Do you have any integration or data migration in place overnight? Darren Liu, Microsoft CRM MVP Crowe http://www.crowecrm.com On Feb 14, 7:26=C2=A0am, =D7=9C=D7=90=D7=95=D7=9F <@discussions.microsoft.co= m> wrote: > Hello, > We work with Dynamic CRM 3.0 (w2k3 server platform). Our corporate ...

Borders and page numbering changes in 2007
Hi Everyone, Quick question. In previous versions of excel i use to be able to select multiple rows and then click the bottom border button and all the selected rows would then have bottom borders. However when i now do this in 2007 only the last row i have higlighted gets the boarder. Have they taken this funtionality away or is there another way to do it? Second quick question. I have an excel document with multiple pages that i want to have the page number displayed at the top of. However when i click header and footer and click the page number button and then go back to normal...

Accept all changes by one editor?
I have a word document with changes from different users. I would like to accept all of the changes from one person, and review the rest individually. Any ideas on how to accomplish this in Word 2007? Thanks! Run a macro containing the following code: Dim i As Long With ActiveDocument For i = .Revisions.Count To 1 Step -1 If .Revisions(i).Author = "Joe Blogs" Then .Revisions(i).Accept End If Next i End With -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consul...

How do I change Excel format to pdf format?
How do I change Excel format to pdf format? See this post in Google from a couple of days ago for some ideas http://tinyurl.com/4xhtn -- HTH RP (remove nothere from the email address if mailing direct) "William Haskovec" <William Haskovec@discussions.microsoft.com> wrote in message news:C33520CB-289A-4B7E-90E3-C4C9741B62E7@microsoft.com... > How do I change Excel format to pdf format? ...

auto update form
I have two fields on my form - RevisonDate and ReviewDate. The default value for RevisionDate is set to =Date(). This works fine. I then set the default vaule for the ReviewDate to =[RevisionDate]+60. This ONLY works if I manually type in the RevisionDate. I know I need a requery somewhere and I have tried it on the form and different fields, but it is not working. Where should I add the requery????? Or do I need to remove the default for ReviewDate and just have code to populate the field on close? Not sure. You can't use a default value that is based on a calcula...

Exchange 2003 sp2 on automatic update
Is service pack 2 for Exchange 2003 available (automatically) on Microsoft Update? I just installed a copy of SBS 2003, and did a full update: Exchange sp2 was not offered. Does anyone know what gives? (david) You Have to download the Service Pack Manually. "david" <david@nospam.nospam> wrote in message news:u1WaX8ypKHA.4836@TK2MSFTNGP05.phx.gbl... > Is service pack 2 for Exchange 2003 available (automatically) on Microsoft > Update? > > I just installed a copy of SBS 2003, and did a full update: Exchange sp2 > was not offered. &g...