Forum

what is see is almost 5000 ordered but a great deal cancelled. I also see a listing in the notes field for what looks like everyone who has received a doublecharge credit. I just dont have total numbers on everything. I am getting very very very burned out with all of Ross's mess. Not the dvds but e...

I have decided to post my new updates to the Ross Rojek arrested thread, since that was seeing alot more posts in regards to this situation.

Thanks.

Justin

Thank You Kenny. Well it was much easier than i expected, just dropped the files in access and ran a query. I now have a list of everyone who ordered the set and who has received their bonus disks, and if they cancelled, and if they refused shipment of the bonus disk and lunch box, which did happen ...

I am just getting it in two files that can be crossreferenced. The problem is that the customer file with the email addresses is every customer au had. Other news. The Bookkeeper called me back. She didnt have any sort of list just a file of people who emailed her asking for there lunchbox and bonus...

Let me strip credit card information if it is in there first. The customer info file is in the worst shape. I have a full list of orders with customer numbers, just the table with the names attached to order numbers is in disarray. Also, I dont know if it is very wise of me to give out this informat...

The files are huge .csv files just dumped out of sql. I will be going through them tonight and tomorrow to clean then up and then import them into an easy to use excel file.

Justin

Hey everyone, Wow, what a day. See there has been lots of activity on here. As for the question of what I get out of all this, nothing but good Karma like Jason said. I am just trying to helpout before the doors close. Now for my news. I found a list of every order in all the SQL mess. It only gives...

Update - I found some sort of record on the main server in sql. I have never gotten around to learning how to work and mine an sql database but i have been able to pull up an order here and there and found that they noted the files in someway with notes on if they got sent the bonus disk or lunch bo...

sorry forgot to respond to Jason;s suggestion and offer of help on the vertical response front. The account was closed from what I can tell awhile back, so that is not really an option. I can still get an email out to everyone if i find the darn shipping list and email list. It just wouldnt get out ...

Just an update- I brought the dead computer back from the grave, but no dice it had nothing useful on it. The good news is I talked with the bookeepers husband and he said he will relay my message to his wife that I need the shipping list files if she has them. I have to assume she does after what o...

Very understandable Jason. Thank you though for your advise and suggestions up to this point.

I will know more tomorrow. Once I do I will post an update. The list is the key, but as others have stated the record keeping at au was horrible. There is some hope. I did find a partial checklist the other day. Just 200 order number with numbers crossed off that had already been shipped the bonus d...

The landlord gave us until the 10th he wanted us out last friday. He has people looking at the property and doesnt have the room to store this stuff till we figure it out. I am working on tracking down a list. The bookkeeper i am told had a list but she has been hard to track down. However the FBI m...

After speaking with his attorney Jason has decided he can;t take the product or the responisbilty. The compnay has until May 10th to move product out of the warehouse or forfiet it to the landlord. Jason did provide me witha fufillment compnay but without a master list which only one person seems to...

Wow this is all a shock from my talks with you earlier Jason. My wife was refereing to a few box sets that were still at the warehouse that we were told were okay to sell. Not the Bonus disks or Lunch Boxes. My wife doesnt always have the whole picture of what i am doing at work. Two days ago I rece...