Bulk management of domain name extensions / pricing

[nitro]

I'm in the process of setting up close to 200 options for domain name registration for my business. I had started using the admin interface to manage these but am finding that this is going to get hairy pretty quickly.

 

I have noticed that domain name periods and pricing are held in tbldomainpricing in the database. Am I going to cause issues for myself if I insert the rows there directly myself rather than dealing in the admin interface?

[Iceman]

Nope. Thats exactly what we did. Saves a heck of a lot of clicking :-D

(Also handy to import other Custom Field's data etc.)

 

Make sure though that if you have any existing clients accessing any data that you don't change the id of entries already in the database. Otherwise it will change what is tied to that client.

 

So, you can simply do this using phpMyAdmin to upload all your domain info.

INSERT INTO `tbldomainpricing` (`id`, `extension`, `registrationperiod`, `price`, `autoreg`, `order`) VALUES 
(1, '.com', 1, 20.00, '', 1),
(2, '.net', 1, 20.00, '', 3),
(3, '.org', 1, 20.00, '', 5),
(4, '.com.au', 2, 60.00, '', 2),
(5, '.net.au', 2, 60.00, '', 4),
(6, '.org.au', 2, 60.00, '', 6);

 

Cheers,

Paul

[nitro]

Thanks! I was hoping it would be that easy, but was expecting things to be a lot harder. I had tested some already and they seemed to work OK.

 

So you've had no problems crop up elsewhere since doing that?

[othellotech]

We faced the same issue with over 150 extensions supported - added some of each year combination manually and then inserted the rest startigh into the DB - absolutely no problmes with WHMCS caused by the data import method at all