1. Home
  2. Point-Of-Sale Software
  3. Spring cleaning

Spring cleaning

When I make a new item I go by my distributers description for item description. The first part of the description is an abbreviated name for manufacturer. Over the years these abbreviations have changed slightly from time to time, so what I am left with now is multiple abbreviations for the same manufacturer. This can cause some confusion with my staff, so I have decided it is time to do a little spring cleaning, and get these abbreviations standardized for all my items. right now the only way I can see to do this is by going into each items properties and changing it manually. With 6000 items total, and about 1000 that need cleaned up, this is going to be quite a chore. What I need is to be able to change the first word(abbreviation) of the description in a group of items determined by an ILC grouping(ex: 1001 - 1100) to the same abbreviation. Does somebody have a faster way to do this, by SQL maybe? Thanks for any help. Craig

Reply to
Craig
Loading thread data ...

Craig,

Please give me an example

Reply to
Ahmed Nashat

Ahmed, Thanks for the reply. I will be in the office tomorrow and will give a detailed example when I get in. I really appreciate your (and others) willingness to share your knowledge. Craig

Reply to
Craig

Ahmed, As an example: The description on Items with ILC's 09761266104 through

09761280032 (the first 6 numbers are unique to each manufacturer) belong to the manufacturer Zoo Med and might start with ZOO MED, ZMED, or ZML, I want to make all items start with ZML. I have many different products from different manufacturers that I need to do this with. I hope this makes sense. Craig
Reply to
Craig

Craig,

use the 2 following updates for the example u mentioned, please BACKUP FIRST

update item

set description = 'ZML' + substring(description,5,len(description)-4)

where itemlookupcode between '09761266104' and '09761280032'

and description like 'ZMED%'

update item

set description = 'ZML' + substring(description,8,len(description)-7)

where itemlookupcode between '09761266104' and '09761280032'

and description like 'ZOO MED%'

Reply to
Ahmed Nashat

Thank you so much Ahmed, this is going to save me gobs of time. I'll let you know how things go. I am waiting until I close to do this. Craig BTW, maybe you forgot to send me a demo of your forecasting utility, in case you did, here's my email snipped-for-privacy@netzero.net

Reply to
Craig

Ahmed, The queries worked perfectly. Thanks again for your help, I just can't express enough how much time you have saved me. Craig

Reply to
Craig

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.