#opencart customization

You can pull data from an Opencart shop to Google doc spreadsheet auto with just click of a button.

This is of great use for retrieving data in spreadsheet format.

Here is a step by step Guide:

The demo below explains how to retrieve product data from Opencart on to Google spreadsheet

Step-1   Create a spreadsheet within your Google Drive

Step -2 Create a new spreadsheet and insert the script provided in below link.

https://docs.google.com/document/d/1iA3284ZrSEAGdwJQeb5dJXLRTkECMb52z4KwBqxUBZQ/edit?usp=sharing

How to insert script

To insert the script in Google spreadsheet go to Tools> script Editor

On opening script editor you will find a Google Apps Script pop-up Close it.

  On closing pop-up you will also find some pre-written function tags. Remove them completely

Paste the script provided in script Editor.

Step -3: (Important step) Adding your MySQL database credentials and correct table names

Jdbc.getConnection('jdbc:mysql://demo.transpacific.me/opencart_db', 'admin', 'pass123')

Replace the place holder credentials (host, user, pass) for mysql

Also change place holder table names in script oc_product and oc_product_description as per your MySQL database (correct table names you can check through your cpanel phpmyadmin)

Step-4 Run the Script

You are all set to run the script!!

Run the script from top menu <Run> and it will pull the product data from your Opencart shop.

(it will ask for  script authorization on first run  accept.)

Script will take anywhere between 20 seconds to 1 minute to pull data depending on connection speed and data size.

Step -5 (important step) connection error & White listing Google ip’s

To Pull data; Script from Google Docs connects to your Opencart MySQL database. In some cases your MySQL database will not allow this unless you white list the visiting servers ip.

Google has provided a list of ip’s you need to white list. (this can be done through your servers  cpanel )

Below is the list of Google ip’s you need to whitelist. More details on:

https://developers.google.com/apps-script/guides/jdbc#authorization

216.239.32.0 - 216.239.63.255

64.233.160.0 - 64.233.191.255

66.249.80.0 - 66.249.95.255

72.14.192.0 - 72.14.255.255

209.85.128.0 - 209.85.255.255

66.102.0.0 - 66.102.15.255

74.125.0.0 - 74.125.255.255

64.18.0.0 - 64.18.15.255

207.126.144.0 - 207.126.159.255

173.194.0.0 - 173.194.255.255

Scope for customization:

The script is written for a default Opencart but can be customized to any extend. It can also pull data from order table, from abandon cart table and  any additional tables as required.

Its of great help to quickly backup the OC data on your Google spreadsheet environment.

Please post your comments/queries here.

For the starters, OpenCart is an e-commerce platform used by many companies to create their online portals for business. It has many features and applications to help the customers purchase goods and pay through internet. There are many OpenCart development companies that help to customize the platform for various businesses.

SEO With OpenCart

Can a platform help in SEO? Beyond all the features and applications, OpenCart has to create a perfect website, make add-ons which can be linked to the platform to bring a unique look to the site. There are many OpenCart developers who would develop add-ons for their clients and some are available on internet.

SEO Add-on Feature For OpenCart:

This SEO add-on helps to have control over the content in e-commerce site. This feature helps in creating categories on the website. Category creating has following advantages:

a)      It makes the content easily readable and understandable by the customers, thereby helping to increase the sales.

b)      The usage of categories also helps the search engine to index the site easily, thereby, increasing the rank of the site. The rank of the site in turn helps to increase the return on investment or simply, the revenue.

c)      Instead of filling up the page with text, the category usage helps in differentiating the products, features and other attributes making it go easy on the eyes of the customers.

SEO OpenCart also helps to manage multiple sites with different themes, products and other features. Earlier, separate OpenCart customization has to be handled to manage different sites. This option helps the companies that have various businesses on a global scale. Thus, managing different tax details, currency and its value and other geographically varying information becomes easier with OpenCart.

There are many people who seek the help of an OpenCart development company, to build a platform to increase the business. The main factor that increases the business is the rank of the site. More than 90% of the viewers do not move to the second page of Google. OpenCart development service can help you with providing SEO-friendly links. These links helps the search engine to index the page thereby moving the site up in the rankings.