OpenCart Canada Taxes Setting

Taxes reference from Sales taxes in Canada.
Note : 
1. OpenCart won't calculate cumulative tax (such for Quebec and PEI). I use the effective tax rate.
2. This article for OpenCart Tax setting SAMPLE only. 

0. Backup website and database.

1. Create [Geo Zones]
    Canada GST Zone --> Canada / Alberta, Manitoba, Northwest Territories, Nunavut, Prince Edward Island, Quebec, Saskatchewan, Yukon Territory
    BC HST Zone --> Canada / British Columbia
    MB PST Zone --> Canada / Manitoba
    NB HST Zone --> Canada / New Brunswick
    NL HST Zone --> Canada / Newfoundland and Labrador
    NS HST Zone --> Canada / Nova Scotia
    ON HST Zone --> Canada / Ontario
    PEI PST Zone  --> Canada / Prince Edward Island
    QC QST Zone --> Canada / Quebec
    SK PST Zone --> Canada / Saskatchewan

2. Create [Tax Rates]
    GST (5%) --> Tax Rate: 5, Type: Percentage, Customer Group: check all, Geo Zone: Canada GST Zone
    HST (12%) --> Tax Rate: 12, Type: Percentage, Customer Group: check all, Geo Zone: BC HST Zone
    PST (7%) --> Tax Rate: 7, Type: Percentage, Customer Group: check all, Geo Zone: MB PST Zone
    HST (13%) --> Tax Rate: 13, Type: Percentage, Customer Group: check all, Geo Zone: NB HST Zone
    HST (13%) --> Tax Rate: 13, Type: Percentage, Customer Group: check all, Geo Zone: NL HST Zone
    HST (15%) --> Tax Rate: 15, Type: Percentage, Customer Group: check all, Geo Zone: NS HST Zone
    HST (13%) --> Tax Rate: 13, Type: Percentage, Customer Group: check all, Geo Zone: ON HST Zone
    PST (10%) --> Tax Rate: 10.5, Type: Percentage, Customer Group: check all, Geo Zone: PEI PST Zone
    QST (9.5%) --> Tax Rate: 9.975, Type: Percentage, Customer Group: check all, Geo Zone: QC QST Zone
    PST (5%) --> Tax Rate: 5, Type: Percentage, Customer Group: check all, Geo Zone: SK PST Zone

3. Create [Tax Class]
    Canadian Tax Class --> Add all 10 Tax Rates. Based On select [Shipping Address].

4. Select [Canadian Tax Class] on products' [Tax Class].

5. Make an order and check the [Total].

Use SSL in OpenCart

Before use SSL, you have to make sure you already have SSL for your domain.

1. Open [config.php] and modify following:
define('HTTPS_SERVER', 'http://www.yourdomain.com/');
==> define('HTTPS_SERVER', 'https:// www.yourdomain.com /');
define('HTTPS_IMAGE', 'http://www.yourdomain.com/image/');
==> define('HTTPS_IMAGE', 'https://www.yourdomain.com/image/');

2. Open [config.php] under admin folder and modify following:
define('HTTPS_SERVER', 'http://www.yourdomain.com/admin/');
==> define('HTTPS_SERVER', 'https://www.yourdomain.com/admin/');
define('HTTPS_CATALOG', 'http://www.yourdomain.com/');
==> define('HTTPS_CATALOG', 'https://www.yourdomain.com/');

define('HTTPS_IMAGE', 'http://www.yourdomain.com/image/');
==> define('HTTPS_IMAGE', 'https://www.yourdomain.com/image/');


3. Select Use SSL at Administration
Login admin --> [System] --> [Settings] --> [Edit] --> [Server] --> [Use SSL] select [Yes] --> [Save] 

Can not open .xlsx file?

Can not open Office 2007 or Office 2010 files?


Install this:
Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint File Formats


Or install Excel Viewer.

Can not open .docx file?

Can not open Office 2007 or Office 2010 files?

Install this:
Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint File Formats

Fail to install SQL Server Compact 4.0

When try to install SQL Server Compact 4.0 , and it shows:
Error 25541.Failed to open XML file C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe.config, system error: -2147024786


Solution:
1. Run "Regedit".
2. Find “HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\VisualStudio\10.0\Setup\VS".
3. Export "VS".
4. Delete "VS".
5. Install SQL Server Compact 4.0 .
6. Register "VS".

How to use FileZilla?

1. Download FileZilla.
2. Follow instruction to install FileZilla.
3. Add a ftp site.
    3.1 Click [Site Manager...].

    3.2 Click 1. [New Site].  2. Name ftp site. 3. Type [Host] (you can type ftp url or ip). 4. Select "Normal" for [Logon Type]. 5. Type your username and password. 6. Click [OK].

4. Select your ftp site.

5. Drag your folder or files from 1 to 2.

How to setting VPN on Windows 7?

1. [Start] --> [Control Panel] --> [Network and Internet]

2. Click [Set up a new connection or network]

3. Select [Connect to a workplace] --> [Next]

4. Select [No, create a new connection] --> [Next]

5. Select [Use my Internet connection (VPN)]

6. Type [Internet address] and [Destination name] --> [Next]

7. Key in [User name] and [Password]. Check [Remember this password]. Key in [Domain (optional)] if VPN server needed. Click [Connect].