Jump to content
  • 0

How To Use Blesta ?

kikloo

Asked by kikloo,

 Share

Question

kikloo Newbie

kikloo

Posted
Posted

Hi,

 

I am right now using WHMCS and I want to move to Blesta becuase it has open source and I need some modifcations doing which I cannot do in WHMCS. I had also installed the trial version which is going to expire very soon. I just want to know how do I setup Blesta so my clients can register, order domains / hostings by themselves ? Right now all I see is a login page and no reg. link, no order nothing. In WHMCS its all very easy. How do I setup blesta ? I am using Resellerclub for domains, cPanel for hosting and Paypal and 2Checkout for payments.

 

Thanks.

25 answers to this question

Recommended Posts

  • 0
kikloo Newbie

kikloo

Posted
  • Author
Posted

Hi,

 

Okay now i understand that I had to add 3 different order forms for this to work. So I added Domain, Hosting and Client Reg. order forms respectively.

Now the other issue I am facing is regarding currencies.

 

I have 2 currencies setup i.e INR (default) and USD secondary.

Client's default currency is INR.

When I added a domain name I set its pricing in USD (as I am billed in USD) 

But when as a client (who's currency is INR) I tried to order the domain it still showed me pricing in USD instead of INR. Why its not converting the price into INR from USD for that client ?

 

Thanks.

  • 0
kikloo Newbie

kikloo

Posted
  • Author
Posted

Hi,

 

Okay so after trying it out, I deleted the installation as a fresh installation was required for WHMCS migration but now when I try to setup blesta it says: 

 

--
The license key is invalid.
---
 
What to do ?
 
Thanks.
  • 0
Michael Apprentice

Michael

Posted
Posted

You was using a trial and re-installed it so the key was removed and as it was already installed it won't install again, can you please email sales[a.t]blesta.com for a new trial key issued. Otherwise you can purchase a license which will fix the issue.

 

As for how to use Blesta I recommend the videos I watch them now, they was made when 3.0 was in development: http://videos.blesta.com/ 

 

If you have any questions you can post here I can help you with them.

  • 0
kikloo Newbie

kikloo

Posted
  • Author
Posted

You was using a trial and re-installed it so the key was removed and as it was already installed it won't install again, can you please email sales[a.t]blesta.com for a new trial key issued. Otherwise you can purchase a license which will fix the issue.

 

As for how to use Blesta I recommend the videos I watch them now, they was made when 3.0 was in development: http://videos.blesta.com/ 

 

If you have any questions you can post here I can help you with them.

 

Hi,

 

I have sent email to sales for key. Please issue fast as I have disabled whmcs for migration.

 

Thanks.

  • 0
Paul Rising Star

Paul

Posted
Posted

Hi,

 

I have sent email to sales for key. Please issue fast as I have disabled whmcs for migration.

 

Thanks.

 

I replied to your email with a trial key you can use. Caught me just in time -- heading to the airport soon. :)

  • 0
kikloo Newbie

kikloo

Posted
  • Author
Posted

Hi,

 

Blesta has successfully imported all data from WHMCS but when i try to change / fix the prices of domains etc. then it won't let me delete the prices that are not correct etc. What do I do ?

 

Thanks.

  • 0
Michael Apprentice

Michael

Posted
Posted

Hi,

 

Blesta has successfully imported all data from WHMCS but when i try to change / fix the prices of domains etc. then it won't let me delete the prices that are not correct etc. What do I do ?

 

Thanks.

 

oh your best bet is to restore Blesta and wait for 3.3.x as you'll need the price over-ride option as WHM** has promotions as their own price tier so you end up with billions.

  • 0
kikloo Newbie

kikloo

Posted
  • Author
Posted

Hi,

 

I have imported from WHMCS. Can i delete imported data everything in Blesta except the clients ? I want to delete invoices, orders, packages, transactions everything else just keep the clients. How do I do that ? Can I do that through phpmyAdmin ? Can you give me some sql code which would Truncate all the data and keep clients only ? You should put option in importer script on what to import. So we can check the boxes etc. and import only that data which is required.

 

Thanks.

  • 0
kikloo Newbie

kikloo

Posted
  • Author
Posted

Hi,

 

I ran this query:

TRUNCATE calendar_events;
TRUNCATE invoices;
TRUNCATE invoice_lines;
TRUNCATE packages;
TRUNCATE package_emails;
TRUNCATE package_group;
TRUNCATE package_groups;
TRUNCATE package_meta;
TRUNCATE package_pricing;
TRUNCATE pricings;
TRUNCATE services;
TRUNCATE service_fields;
TRUNCATE support_replies;
TRUNCATE transactions;
TRUNCATE transaction_applied;
TRUNCATE transaction_types;

Do i need to do anything else to make sure that client's accounts that have been left are clean and fine and won't cause any issue when I add orders to them ?

 

Thanks.

  • 0
Michael Apprentice

Michael

Posted
Posted

Hi,

 

I ran this query:

TRUNCATE calendar_events;
TRUNCATE invoices;
TRUNCATE invoice_lines;
TRUNCATE packages;
TRUNCATE package_emails;
TRUNCATE package_group;
TRUNCATE package_groups;
TRUNCATE package_meta;
TRUNCATE package_pricing;
TRUNCATE pricings;
TRUNCATE services;
TRUNCATE service_fields;
TRUNCATE support_replies;
TRUNCATE transactions;
TRUNCATE transaction_applied;
TRUNCATE transaction_types;

Do i need to do anything else to make sure that client's accounts that have been left are clean and fine and won't cause any issue when I add orders to them ?

 

Thanks.

 

If you can't wait for 3.3, you can clean the db, then import again, go to the packages turn all the packages restricted, this means they are active for the customer but not for anyone else (No one can order a cheaper price) and then re-make the packages but these will be new and active.

  • 0
kikloo Newbie

kikloo

Posted
  • Author
Posted

Hi,

 

Thanks for the tip, but I went my way and it seems to be working. I am now adding orders 1 by 1 to the clients from WHMCS to Blesta.

The only issue I am facing now is that I have to manaully set expiration date of domains. You do not have something like WHMCS domain sync ??

It updates all the domain's expiry dates. Does Blesta have anything like that ? It would save me a lot of time. I will then just add the domain and run the script to sync the expiry dates.

 

Thanks.

  • 0
Michael Apprentice

Michael

Posted
Posted

Hi,

 

Thanks for the tip, but I went my way and it seems to be working. I am now adding orders 1 by 1 to the clients from WHMCS to Blesta.

The only issue I am facing now is that I have to manaully set expiration date of domains. You do not have something like WHMCS domain sync ??

It updates all the domain's expiry dates. Does Blesta have anything like that ? It would save me a lot of time. I will then just add the domain and run the script to sync the expiry dates.

 

Thanks.

 

There isn't yet you can open a feature request for that :). 

  • 0
kikloo Newbie

kikloo

Posted
  • Author
Posted

Hi,

 

I just made this quick domain sync (which updates reg. date and expiry date into the blesta database directly) php script which seems to be working fine for me, i am posting it here for anyone else's use:

 

ITS FOR RESELLERCLUB ONLY

 

BEFORE YOU USE: BACKUP DATABASE , BACKUP DATABASE

<?php
$db_host = "localhost";
$db_name = "loremipsum"; // your blesta database name
$db_username = "loremipsum"; // your blesta database username
$db_password = "loremipsum"; // your blesta database password
 
$uid = "123456"; // your logic boxes or reseller club user id
$key = "loremipsumloremipsumloremipsum"; // your logic boxes or reseller club api key
 
// ============================================
// No change is required after this point
//=============================================
$conn = mysql_connect($db_host, $db_username, $db_password) or die("Unable to Connect");
$db = mysql_select_db($db_name, $conn) or die("Unable to Select");
 
 
$q0 = "SELECT * FROM `service_fields` WHERE `key` = 'domain-name'";
$r0 = mysql_query($q0) or die("Query Failed: Get Domains");
 
while ($a0 = mysql_fetch_array($r0))
{
$q1 = "SELECT * FROM services WHERE id_value = " . $a0["service_id"] . " LIMIT 1";
$r1 = mysql_query($q1) or die("Query Failed: Get Record");
$a1 = mysql_fetch_array($r1);
 
$domain = $a0["value"];
$url = "https://httpapi.com/api/domains/details-by-name.json?auth-userid=" . $uid . "&api-key=" . $key . "&domain-name=" . $domain . "&options=OrderDetails";
 
$handle = fopen($url, "rb");
$content = stream_get_contents($handle);
$content = json_decode($content);  
fclose($handle);
 
$regdate = date("Y-m-d H:i:s", $content->creationtime);
$expdate = date("Y-m-d H:i:s", $content->endtime);
 
$q2 = "UPDATE services SET 
date_added = '" . $regdate . "',
date_renews = '" . $expdate . "' WHERE 
id = " . $a1["id"] . " LIMIT 1";
$r2 = mysql_query($q2) or die("Query Failed: Update Exp. Date for " . $domain);
}
 
echo "Done";
?>

Its a quickly done script which has nothing to do with blesta, just put in the required details, upload an run once. It will update all your domain's reg / expiry date.

 

Thanks.

  • 0
kikloo Newbie

kikloo

Posted
  • Author
Posted

Hi,

 

How is blesta converting currency ?

Earlier 9.89 USD to INR was 578 by Blesta

But today 1 USD to INR is 60.38

But Blesta is still showing 578 for 9.89 USD when I am trying to order.

 

It does'nt apply the new price to services / products ?

 

Thanks.

  • 0
Paul Rising Star

Paul

Posted
Posted

Hi,

 

How is blesta converting currency ?

Earlier 9.89 USD to INR was 578 by Blesta

But today 1 USD to INR is 60.38

But Blesta is still showing 578 for 9.89 USD when I am trying to order.

 

It does'nt apply the new price to services / products ?

 

Thanks.

 

If a price is defined in the currency for the package, it will use that price. If the price is defined in the companies default currency, but not the currency it was ordered in, then the exchange rate will be used. You can set the exchange rate to be updated automatically under Settings > Company > Currencies > Currency Setup. Click Active Currencies to see the current exchange rate for each currency.

  • 0
kikloo Newbie

kikloo

Posted
  • Author
Posted

Hi,

 

The default currency is INR but price specified for that product was USD as I want Blesta to convert to INR everytime someone orders and show the new price but that is not happening.

 

Thanks.

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
 Share
Go to question listing
×
×
  • Create New...