Music Lounge

Sold CD still in database ????

1  Joachim Glaser yotown Germany 55 posts 8.8 years 2674 items Hi, this is also a question for Dave, but maybe somebody else had this problem in the past: CD was ordered right now......I have checked that it was sold 5 years ago on another database. Standard procedure: After payment I will delete the item from the MS database and all other databases. That's normal and quite easy! But why it was still in the MS database? I did a complete physical inventory check last november/december and everything was fine (I found some problems with database <> physical inventory <> inventory list, but this was fixed from my side!) So there is a 0.5% chance that I was still wrong and have missed a Cd, but I don't think so ;-) Maybe old DB problem with bug fixes or updates??? Jo Posted 1 year 1 months ago       Quote     Like     Dislike         Back to Top 2  Joachim Glaser yotown Germany 55 posts 8.8 years 2674 items ...a question for all sellers on Musicstack ;-) Posted 1 year 1 months ago       Quote     Like     Dislike         Back to Top 3  Abstracks Abstracks United Kingdom 91 posts 1.3 years 0 items I have encountered this issue and emailed Dave recently about this, though may need a follow-up as not heard yet. I am currently at the stage of doing another physical stock check before re-uploading the database (the 4th time). I used Access and converted to Excel and manually deleted the sold items. From what you say, sounds like we have the same methodology of uploading stock databases Posted 1 year 1 months ago       Quote     Like     Dislike         Back to Top 4  Joachim Glaser yotown Germany 55 posts 8.8 years 2674 items Well, I use Excel direct. This is very easy :-) I will not do a re-upload of my old inventory, I have done a lot of changes manually in the database.....but not in my list ;-) This was an old Cd from my list (uploaded years ago) As I work with databases from time to time, I know some weird things can happen with the data inside.....sometimes it#s not possible to track these things. Hopefully this is the only problem within my & your list :-) I don#t want to do a new stock check in the next 2 years ;-) No problem to tell a customer that I don't have the CD anymore.....because of "strange things happen..." hehe Posted 1 year 1 months ago       Quote     Like     Dislike         Back to Top 5  Matt Johnson Funkenskankenland United Kingdom 50 posts 1.9 years 2792 items There is a glitch whereby if an item is reserved for a customer order it sits in limbo where it is not available for sale and is temporarily removed from your online (Musicstack) database. If you upload your entire inventory while items are in limbo, the entries corresponding to these items are assessed as new items, since we presumably don't delete items from our offline databases until the order completes. Currently the only way round this is to manually delete items on the online (Musicstack) database corresponding to any reserved items immediately after an upload. I have exchanged mails with Dave about this but it's a tricky one to deal with. It can affect your fill rate though, since it may unwittingly reintroduce items that have been sold and passed through the system using all the proper processes. Matt Posted 1 year 1 months ago       Quote     Like     Dislike         Back to Top Add Reply