|
Posted by Anthony Laidler on September 2, 2008, 10:24 pm
Please log in for more thread options
The only thing I can caution you on with some of the SQL statements is that
you end up leaving orphaned records in other areas such as your suppliers. I
was just going through the new store I created and I had more items for some
of the suppliers than I had in my entire database. They show up as Unknown.
The only thing I could think they came from is when I deleted items via SQL
statements in the past. However, I could be wrong.
"EricJRW" wrote:
> I have not done this, yet... But there is a "last sold" date field for each
> item (on the inventory tab). My plan would be to not worry about it yet...
> 12K is not that much... I have 40,000 items. At some point I will write a
> little SQL to look for items that have not sold, then mark those items
> inactive (options tab). I'm hoping SO can be configured so that inactive
> items won't ring up (but this way can easily be made active). Then I will do
> more SQL to delete items that have not sold in the past X. At least that's
> the plan I'm working on.
>
> "Anthony Laidler" wrote:
>
> > Thanks for your response. I would like to reduce the size of my database
> > since I would be going from 12000 items to about 5000 items. That is why I
> > didn't want to keep all the old data that I would never sale again.
> >
> > Any other ideas or suggestions?
> >
> > "Afshin" wrote:
> >
> > > If you have HQ create a store in HQ. Go to item tab andchangeth re-order
> > > point and restock level for those items you do not want in this store to
> > > ZERO. But at least this way if an item gets transferred accidently to a
> > > store you get no errors. As for purging old data just make them hidden
and
> > > do not worry about them as SQL can handle larger database.
> > >
> > > Afshin Alikhani - afshin@retailrealm.co.uk
> > > Retail Realm
> > > = = = = = = =
> > > > We are starting a new contract, and I will be adding new stores.
However,
> > > > we
> > > > will not be selling all the merchandise that we had in the previous
> > > > stores.
> > > > What is the BEST way to rebuild my database without starting over from
> > > > scratch?
> > > >
> > > > My thought is to do the following:
> > > > -Choose one of my exisiting stores with the most data
> > > > -Break the HQ connection (USing instructions from Customersource)
> > > > -Ddelete all sales data, and old cashers, etc.
> > > > I would LIKE to purge all items that have not sold in the past year and
is
> > > > not in a warehouse.
> > > >
> > > > Once I have everything setup how I need it, we will use this template to
> > > > populate the new HQ and thus the new stores.
> > > >
> > > > Question I have is...What is the best way to purge all the unwanted items
> > > > and keep all my databases and tables intact?
> > > >
> > > > If there is a better way please advise. As always thanks for all help and
> > > > assistance.
> > > >
> > > > Ace Laidler
> > >
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap