SimpleBiz EasyUse

OpenCart Canada Taxes Setting

2012-09-12T15:05:00.001-07:00

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

2012-09-12T10:51:00.001-07:00

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?

2012-03-08T10:16:00.001-08:00

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?

2012-02-10T14:36:00.000-08:00

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

2012-01-27T15:03:00.000-08:00

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?

2011-12-26T16:14:00.000-08:00

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?

2011-12-15T17:30:00.001-08:00

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].

How to add a network printer on Windows XP?

2011-12-01T17:00:00.001-08:00

1. Share a printer
1.1 [Start] --> [Printers and Faxes].

1.2 Right-click printer, select [Sharing...].

1.3 Select [Share this printer], click [OK].

2. Check host computer name
2.1 [Start] --> Right-click [My Computer] --> [Properties].

2.2 Check "Full computer name".

3. Add a network printer
3.1 [Start] --> [Printers and Faxes].

3.2 Click [Add a printer].

3.3 Click [Next >].

3.4 Select [A network printer, or a printer attached to another computer], click [Next >].

3.5 Select [Connect to this printer (or to browse for a printer, select this option and click Next)]. Type "\\host computer name\shared printer name" at Name tag. Click [Next >].

3.6 Click [Yes].

3.7 Select [Yes], click [Next >].

3.8 Click [Finish].

3.9 Printer added.

Outlook too slow? Run AutoArchive

2011-12-01T11:50:00.001-08:00

1. On menu bars, [Tools] --> [Options...]

2. Click [AutoArchive...]

3. Set the AutoArchive Properties

References:
1. Description of the AutoArchive feature in Outlook 2007 and in Outlook 2003

Webmail for Bellhosting

2011-12-01T11:18:00.001-08:00

1. Accessing your email via Outlook Express
Use these settings to configure Microsoft Outlook Express to check your email.
http://www.bellhosting.ca/en/topics/email/outlook_xpress.htm

2. Using Webmail
http://webmail.bellhosting.ca/

Get Started with MVA - Microsoft Virtual Academy

2011-12-01T09:53:00.000-08:00

Get Started with MVA - Microsoft Virtual Academy

Outlook 2003 Mail Backup / Restore

2011-11-30T17:55:00.001-08:00

Sometime you may need to backup your Outlook data or if you re-install your Windows, you can follow steps to backup and restore it.
1. Backup Outlook
1.1 On menu bars, [Tools] --> [Options...]

1.2 On Options tabs, [Mail Setup] --> [Data Files...]

1.3 Select which file you'd like to backup, click [Open Folder...]. (If you don't know which files you need to backup, you can backup all.)

1.4 Copy .pst file to your backup folder. You can rename .pst file for easy to understand. Such like add the date you backup.

For Windows 7/8: C:\Users\username\AppData\Roaming\Microsoft\Outlook

For Windows XP: C:\Documents and Settings\username\Application Data\Microsoft\Outlook

2. Restore Outlook

2.1 On menu bars, [File] --> [Open] --> [Outlook Data File...]

2.2 Select .pst file which you want to restore.