?>

MySQL + Chargebee Integrations

Appy Pie Connect allows you to automate multiple workflows between MySQL and Chargebee

About MySQL

MySQL is currently the most popular database management system software used for managing the relational database.

About Chargebee

Chargebee is a subscription management and recurring billing solution used by businesses to customize subscription billing workflows

Chargebee Integrations

Best MySQL and Chargebee Integrations

  • MySQL Google Sheets

    MySQL + Google Sheets

    Create rows on a Google Sheets spreadsheet for new MySQL rows Read More...
    When this happens...
    MySQL New Row
     
    Then do this...
    Google Sheets Create Spreadsheet Row

    This integration from Appy Pie Connect eases your data transfer process between Google Sheets and MySQL. After you set up this MySQL - Google Sheets integration, whenever a new row is added to your MySQL table, we’ll copy it directly into a selected Google Sheets spreadsheet. Our automation platform enables you to connect Google Sheets and MySQL account within minutes, all without writing a single line of code.

    Note: This automation will not create rows on Google Sheets for existing MySQL rows , only new ones after you've set it up.

    How It Works
    • A new row is created on MySQL
    • Appy Pie Connect automatically copies it to a selected Google Sheets
    What You Need
    • A MySQL account
    • A Google account
  • MySQL MySQL

    Trello + MySQL

    Create new rows in a MySQL table for new Trello card activity Read More...
    When this happens...
    MySQL New Activity
     
    Then do this...
    MySQL Create Row

    You can automatically archive all of your Trello card activities in a MySQL table using this MySQL - Trello integration. Once set up, whenever an activity happens on a Trello card, a new row will be created in a MySQL table. This integration will help you manage your Trello database without any manual effort at your end.

    Note: This integration only creates MySQL rows for Trello card activities that happen after you've set it up.

    How It Works
    • A new activity happens on a Trello card
    • Appy Pie Connect automatically adds a new row to a MySQL table
    What You Need
    • A Trello account
    • A MySQL account
  • MySQL MySQL

    Gmail + MySQL

    Add rows in MySQL for New Emails in Gmail [REQUIRED : Business Gmail Account] Read More...
    When this happens...
    MySQL New Email
     
    Then do this...
    MySQL Create Row

    Gmail is one of the most used email services across the world and it efficiently uses a variety of signals to predict which messages are important, including the people you email the most and which messages you open and reply to the most. Use our Gmail-MySQL integration and add all Gmail emails (or those with a certain label) to your database. Once this integration is active, it will trigger for every new message received on Gmail, automatically adding a new row to your MySQL database.

    Note: To use this integration you must have a Business Gmail account.

    How it works
    • A new email is received on Gmail
    • Appy Pie Connect automatically creates a new row on a MySQL database.
    What You Need
    • A Gmail account
    • A MySQL account
  • MySQL MySQL

    Cloud Firestore + MySQL

    Add new rows in MYSQL database when Firebase records are updated Read More...
    When this happens...
    MySQL New Document Within a Firestore Collection
     
    Then do this...
    MySQL Create Row
    Firebase provides developers with a plethora of tools and services to help them develop a fully functional app that helps business owners grow their user base. Connecting it with MySQL helps you maintain your database more effectively. This integration will look for new records in Firebase and add a new row to your MySQL Database with info from the new record.
    How This Cisco Cloud Firestore – MySQL Integration Works
    • A new document is added in Cloud Firebase collection
    • Appy Pie Connect will automatically create new row in MySQL
    You Will Require
    • Cloud Firestore account
    • MySQL account
  • MySQL Slack

    Chargebee + Slack

    Send Chargebee subscription notifications to Slack Read More...
    When this happens...
    MySQL New Subscription
     
    Then do this...
    Slack Send Channel Message
    If you’re using Slack to handle customer support, you can notify your team members directly from ChargeBee about new subscriptions. This integration will make things more organized as there will be no need to go to different platforms for the same task. Set up this ChargeBee-Slack integration and automatically send messages to Slack whenever ChargeBee new subscriptions are created on ChargeBee.
    How This Chargebee-Slack Integration Works
    • A new subscription is created on ChargeBee
    • Appy Pie Connect automatically sends a message on Slack
    Apps Involved
    • ChargeBee
    • Slack
  • MySQL Slack

    {{item.triggerAppName}} + {{item.actionAppName}}

    {{item.message}} Read More...
    When this happens...
    MySQL {{item.triggerTitle}}
     
    Then do this...
    {{item.actionAppImage}} {{item.actionTitle}}
Connect MySQL + Chargebee in easier way

It's easy to connect MySQL + Chargebee without coding knowledge. Start creating your own business flow.

    Triggers
  • New Row

    Triggered when you add a new row.

  • New Row (Custom Query)

    Triggered when new rows are returned from a custom query that you provide. Advanced Users Only

  • New Table

    Triggered when you add a new table.

  • Customer Details Updates

    Triggers when customer details such as first name, last name, email, billing address, etc., are updated.

  • New Customer

    Triggers when a customer is created.

  • New Invoice

    Triggers when a new invoice is generated(with line item support).

  • New Payment

    Triggers when a payment is collected successfully.

  • New Subscription

    Triggers when a subscription is created.

  • Payment Failure

    Triggers when a payment fails.

  • Subscription Cancellation

    Triggers when a subscription is cancelled.

  • Subscription Cancellation Scheduled

    Triggers when a subscription is scheduled for cancellation.

  • Subscription Details Updates

    Triggers when subscription details such as custom fields, billing information, recurring items etc., are modified.

  • Subscription Pause

    Triggers when a subscription is paused.

  • Subscription Resumption

    Triggers when a paused subscription is resumed.

    Actions
  • Create Row

    Adds a new row.

  • Delete Row

    Delete a row.

  • Update Row

    Updates an existing row.

  • Change Next Billing Date

    Updates next billing date of a subscription.

  • Create Customer

    Creates a new customer in Chargebee.

  • Create Subscription

    Creates a new subscription along with the customer in Chargebee. This action does not support adding subscription to an existing customer.

  • Pause Subscription

    Pauses a subscription in Chargebee.

  • Record Offline Payment for an Invoice

    Records an offline payment for unpaid invoices.

  • Resume Subscription

    Resumes a paused subscription in Chargebee

  • Update Customer

    Updates customer details in Chargebee.

How MySQL & Chargebee Integrations Work

  1. Step 1: Choose MySQL as a trigger app and Select "Trigger" from the Triggers List.

    (30 seconds)

  2. Step 2: Authenticate MySQL with Appy Pie Connect.

    (10 seconds)

  3. Step 3: Select Chargebee as an action app.

    (30 seconds)

  4. Step 4: Pick desired action for the selected trigger.

    (10 seconds)

  5. Step 5: Authenticate Chargebee with Appy Pie Connect.

    (2 minutes)

  6. Your Connect is ready! It's time to start enjoying the benefits of workflow automation.

Integration of MySQL and Chargebee

MySQL?

MySQL is a database management system (DBMS. that implements object-oriented features such as user-defined types, inheritance and ppymorphism. It is a very fast database server, designed for use with high-traffic websites, using the scripting language PHP. MySQL provides many functions that allow access to the database through the use of a web browser. MySQL also allows applications written in various programming languages to connect to it using API libraries.

Chargebee?

Chargebee is a subscription billing company that specializes in accepting payments from customers across multiple platforms. Integration with Chargebee allows you to create subscriptions for your customers, manage recurring billing, and generate invoices. Chargebee supports credit cards, net banking, wallets, EMI, and debit/credit cards, among other payment methods. The integration of MySQL and Chargebee enables data exchange between these two systems to enable recurring billing services at minimal effort.

Integration of MySQL and Chargebee

This section describes how to integrate MySQL and Chargebee.

Step I. First you need to log into your MySQL account and then you need to create a database called chargebee_db.

Step II. Now go to http://chargebee.com/doc/current/quickstart and fplow the quick start guide.

Note that you will have to take note of your Chargebee credentials while logging into chargebee.com. You can find your Chargebee credentials on the dashboard as shown below:

Step III. Once you have created the database in MySQL, now you need to configure chargebee in /app/Config/database.php.

$config['db']['hostname'] = 'localhost'; $config['db']['username'] = 'root'; $config['db']['password'] = 'yourpassword'; $config['db']['database'] = 'chargebee_db'; $config['db']['prefix'] = ''; $config['db']['charset'] = 'utf8'; $config['db']['table_prefix'] = 'cbb_';

You can set up an SSL certificate for your site if you want to run your site over HTTPS. To do this, fplow the steps below:

  • Step 1. Create the directory structure for the SSL certificate. In my case I am creating the /etc/ssl directory with a subdirectory named after the domain name of my site (lets say mydomain.com. Inside this directory, I have created another directory called certs:
  • Step 2. Next, you need to generate an SSL private key and CSR (Certificate Signing Request. The command used for this is shown below. Make sure you have openssl installed on your machine before executing this command:
  • openssl req -new -nodes -keyout www.mydomain.com.key -out www.mydomain.com.csr -subj "/C=IN/ST=Karnataka/L=Bangalore/O=My Company/OU=IT Department/CN=www.mydomain.com"

  • Step 3. Next, you should submit the CSR generated above for signing by a CA (Certificate Authority. There are several CAs out there who offer this service free of cost but they will make their own checks before issuing the certificate so it would take some time before getting the certificate back from them. If you don't want to wait it out, you can look around on the internet and find services like Let's Encrypt who offer free signing of certificates. The link for Let's Encrypt is https://letsencrypt.org/.
  • Step 4. After receiving your signed SSL certificate from the CA, you should place it into your /etc/ssl directory along with your CSR file that you had generated in step 2 above (this file will be named something like www.mydomain.com.csr. The end result should look something like this:
  • Step 5. Next, you need to configure your Nginx server to redirect all traffic coming through port 443 to port 80 (this is required because browsers block content served over SSL unless its being served on port 80(non-SSL). To do this, edit /etcginx/sites-enabled/default and add a line similar to the one shown below inside the server block in the default file after the location block:
  • fastcgi_param HTTPS on; fastcgi_param HTTP_SCHEME https; rewrite ^ https://$server_name$request_uri? permanent;

  • Step 6. Finally restart Nginx using sudo nginx -s reload or sudo service nginx reload commands depending upon your operating system and you are done!
  • The integration of MySQL and Chargebee provides an easy way to manage subscription based billing for your online business!

    Chapter 11 . How To Setup An Online Store Using PrestaShop 1.7+ And OpenCart 2.3+

    Overview

    PrestaShop is a popular open source e-commerce platform that lets you set up an online store where people can buy from you using a credit card or PayPal account (or even check. It makes it very easy for you to set up an online store but still gives you full contrp over your website and store. PrestaShop has been downloaded more than 26 million times since its inception in 2004 and today powers more than 45000 online stores in over 200 countries worldwide! You can visit its official website at https://prestashop.com/. We will be using PrestaShop version 1.7+ for our project in this chapter but feel free to use any later versions if desired. This chapter demonstrates how we can set up an online store using PrestaShop version 1.7+ and OpenCart 2.3+. We will also learn how we can integrate these two powerful e-commerce platforms using API calls along with the creation of a simple shopping cart using PHP for PrestaShop and Python for OpenCart so that customers can buy from us using their credit cards or PayPal accounts without leaving our site! People familiar with either one or both of these wonderful platforms will be able to create their own e-commerce website using the information provided in this chapter!

    What Is PrestaShop?

    PrestaShop is an open source e-commerce platform that enables individuals or organizations to easily set up their own e-commerce website without having to write any code or spend a lot of money building an online store from scratch! It provides everything that is necessary to run an online store including user management and order management along with powerful features like product management, SEO optimized templates, donation management etc., making it a very attractive option for people who want to run an online store but don’t want to spend a lot of time or money setting it up! It has been downloaded more than 26 million times from its official website since its inception in 2005 and today powers more than 45000 online stores in over 200 countries worldwide! You can visit its official website at https://prestashop.com/en/. We will be using PrestaShop version 1.7+ for our project in this chapter but feel free to use any later versions if desired!

    What Is OpenCart?

    OpenCart is another popular open source e-commerce platform which lets you set up an online store where people can buy from you using a credit card or PayPal account (or even check. It makes it very easy for you to set up an online store but still gives you full contrp over your website and store. Its popularity stems from the fact that its highly customizable and extensible – a feature that is very important for those who want complete contrp over their online store! It has been downloaded more than 50 million times since its inception in 2006 and today powers more than 250000 online stores in over 180 countries worldwide! You can visit its official website at https://opencart.com/. For our project in this chapter, we will be using OpenCart version 2.3+ but feel free to use any later versions if desired!

    Why Choose OpenCart Or PrestaShop Over Other E-Commerce Platforms?

    Both OpenCart and PrestaShop are open source e-commerce platforms which means that you can download them absputely free of cost without having to pay any license fees! They are also highly customizable and extensible – features which make them popular among developers! When compared to other e-commerce platforms available out there today like Magento or Shopify, they are relatively easier to set up with minimum technical knowledge required

    The process to integrate MySQL and Chargebee may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.