Hi. Im planning to wipe out my database without clearing out its parameters and settings. I have an existing Store running on HQ and SO. I plan to change the barcodes for all items as they are inconsistent. Therefore i need to wipe out everything without the parameters and configuration settings. Can This be done? If so i need a detailed steps in doing this.
How to wipe out HQ and SO data without the setting and paramters
Mar 22, 2006
5 Replies
This sounds very dangerous. What if you changed all your items so they start with a 'Z-' and then make all those items InActive, that way will not lose any Sales History? Then delete everything from the Alias table if you are using it and start adding your newly created items.
Rob
The answer is no, that's why I sugges you add a Z- to the beginning of all your old items. To do this run this SQL statement: UPDATE Item SET ItemLookupCode = 'Z-' + ItemLookupCode. The Results: Old ItemLookupCode = ABC123 New ItemLookupCode = Z-ABC123
And if you have any Aliases defined run this: DELETE Alias
ALWAYS DO A BACKUP BEFORE MODIFYING THE DATABASE.
Rob
You will definitely want to do this at HQ then push down those changes to your store and then using the Item Wizards make all your items that start with 'Z-' InActive.
Rob
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required