Need help: problems with accounts imported from autopilot

[dharmainternet]

I admit that I may have done things out of order, however there is not much documentation or forum activity on importing billing accounts from autopilot...

 

What I did after doing all the general system config:

 

1. Set up my servers

2. Set up my packages

3. Imported shared hosting accounts from two servers (no modifications made)

4. Imported user accounts from autopilot using the script

 

I ended up with duplicate accounts for each user/domain with duplicate packages and duplicate servers

 

So then I

 

5. merged duplicates - keeping the profile info for the autopilot account

6. now each account owner has two product/services, and since there are duplicate packages and servers, I cleaned that up by making sure the products all point to the same package and server

7. delete duplicate packages, delete duplicate servers (almost * problem 1)

8. finally delete second product/service for each client

 

Keep in mind at this point there are no orders in the system.

 

Last night the cron ran and generated two invoices:

 

Invoice 1: generated for a parked domain, which does not show up anywhere that I can *see* in whmcs, can't find the domain anywhere I look however is it related to problem 1?

 

Amount Due: $0.00 USD

Due Date: 04/01/1970

 

Invoice Items

 

- aparkeddomain.com (04/01/1970 - 06/30/1970) $0.00 USD

------------------------------------------------------

Sub Total: $0.00 USD

Credit: $0.00 USD

Total: $0.00 USD

------------------------------------------------------

 

Problem 1: One of the servers has a ghost account connected to it. All the accounts that show up in the list are pointed correctly however this server still shows 1 account attached to it and when I look at servers specifically the list comes up empty

 

Invoice 2: Uggghhhh, to a long-term client of mine. This product/service is also nowhere to be found in his whmcs account. The current product service is configured correctly.

 

Your payment method is: PayPal

 

Invoice #19585

Amount Due: $0.00 USD

Due Date: 02/01/1970

 

Invoice Items

 

- awesomeclient.com (02/01/1970 - 02/28/1970) $0.00 USD

------------------------------------------------------

Sub Total: $0.00 USD

Credit: $0.00 USD

Total: $0.00 USD

 

 

Questions

 

1. Any way to find where the parked domain info is so I can delete it?

2. How do I get rid of the ghost account hooked to the server2 duplicate?

3. How do I find the product service connected to this client in invoice 2?

4. Where does creating orders fit into this? Do they need to be created for each of these imported accounts?

5. Should I delete all products/services for each account and start over?

6. Should I wipe all the data and start from scratch and if so what would be the best way?

7. Default payment setting - I'll ask this another time....

 

 

Problem: After importing autopilot data, all the unpaid invoices were marked paid. So I marked them unpaid but the system did not adjust the unpaid invoice total.

 

 

 

Just in case some wants to ask why I need to import from autopilot, having the historical data for the accounts is important to me. Besides it's nice to not have to recreate all of the account profiles. The script worked great and I am grateful for that.

 

I know this is a long post, so thank for you reading and responding even if it's just to post a link to something I missed.

 

Yvette