osCommerceCoders.com

It specializes in designer brand name men’s, women’s and unisex designer sunglasses, handbags and apparel. All items here are 100% Authentic and come with a Money Back Guarantee.

Custom design
Custom banner management module
Contributions install
Affiliate module
Faster checkout system

Marine.com is one of the leading ecommerce sites for marine and navigation products and accessories since 1997.

Customization of admin panel.
Contributions install
Faster checkout system
Affiliates module

===================
Step-by-Step SETUP:
===================

STEP (1): Set the location for your store:

Configuration –> My Store

- Country: Canada
- Zone: Ontario

========================================================

STEP (2): Create the “Tax Zones”. The are geographical regions where a particular set of tax laws applies

Locations/Taxes –> Tax Zones

Create the Zone for all of Canada
- Zone Name: Canada GST Zone
- Description: GST (most of Canada except NS, NB, NL)

Now click on the newly created “Canada GST Zone” row to drill down one level to “Sub Zones”
Click INSERT to create 10 new sub-zones, one at a time:

- Country: Canada; Zone: Alberta
- Country: Canada; Zone: British Columbia
- Country: Canada; Zone: Manitoba
- Country: Canada; Zone: Northwest Territories
- Country: Canada; Zone: Nunavut
- Country: Canada; Zone: Ontario
- Country: Canada; Zone: Prince Edward Island
- Country: Canada; Zone: Quebec
- Country: Canada; Zone: Saskatchewan
- Country: Canada; Zone: Yukon Territory

==============

Click on “BACK” to go up one level.
Now create the Ontario Provincial Tax Zone:
Click Insert

- Zone Name: Ontario PST Zone
- Description: PST (only when shipping to Ontario)

Now click on the newly created “Ontario PST Zone” row to drill down one level to “Sub Zones”
Click INSERT to create new sub-zone:

- Country: Canada
- Zone: Ontario

==============

Click on “BACK” to go up one level.
Now create the HST Tax Zone:
Click Insert

- Zone Name: HST Zone
- Description: NS, NB, NL

Now click on the newly created “HST Zone” row to drill down one level to “Sub Zones”
Click INSERT to create new sub-zone:

- Country: Canada; Zone: Nova Scotia
- Country: Canada; Zone: New Brunswick
- Country: Canada; Zone: Newfoundland

==============

Do NOT create a seperate Tax zone for Shipping. You will simply use the “Canada” tax zone for the GST Shipping tax class (below).

*** Important: this means that SHIPPING GST will only be charged to destinations within Canada,
*** but NOT charged on exports.
*** According to Canada Customs & Revenue Agency (1-800-959-5525), you do *NOT* charge GST
*** on the shipping fee for EXPORTS.

========================================================

STEP (3): Create the “Tax Classes”

Note: You can only assign ONE
Tax Class to a product. But since we want shipping gst to
show up seperately, we will make a seperate Tax Class just for it.

Locations/Taxes –> Tax Classes

create TWO (2) tax classes:

- Tax Class Title: GST/HST/PST Class
- Description: All taxable goods

- Tax Class Title: GST Shipping class
- Description: GST on shipping within Canada

========================================================

STEP (4): TAX RATES

Here is where it all comes together: Tax Rates.
Tax Rates associate Tax Zones & Tax Class to determine
the correct Tax Rate.

HINT: The “DESCRIPTION” is what shows up on the invoice
so use it judiciously!!!!!!!!!!!!!

Locations/Taxes –> Tax Rates

create SIX (6) Tax Rates:

- Tax Class Title: GST/PST/HST Class
- Zone: Canada GST Zone
- Tax Rate (%): 7.0000
- Description: 7.0% GST#99999 99999 RT0001
- Priority: 1

/*HINT: Insert your GST# as part of DESCRIPTION and it will show up on invoice !!!
/*HINT: Leave PRIORITY at “1″ for a non-cumulative tax (i.e. Ontario)

- Tax Class Title: GST/PST/HST Class /* HINT: Yes, this is the same one you just used
- Zone: Ontario PST Zone
- Tax Rate (%): 8.0000
- Description: 8.0% PST (Ontario)
- Priority: 1

/*HINT: Leave PRIORITY at “1″ for a non-cumulative tax (i.e. Ontario)
but change to “2″ for cumulative tax (i.e. You are a Quebec store)

- Tax Class Title: GST/PST/HST Class /* HINT: Yes, this is the same one you just used
- Zone: HST Zone
- Tax Rate (%): 15.0000
- Description: 15% HST#R99999 9999 RT0001
- Priority: 1

That takes care of taxes on products. And now, the Shipping taxes:

- Tax Class Title: GST Shipping Class
- Zone: Canada GST Zone
- Tax Rate (%): 7.0000
- Description: 7.0% GST on shipping
- Priority: 1

- Tax Class Title: GST Shipping Class
- Zone: Ontario PST Zone
- Tax Rate (%): 8.0000
- Description: 8.0% PST (shipping)
- Priority: 1

- Tax Class Title: GST Shipping Class
- Zone: HST Zone
- Tax Rate (%): 15.0000
- Description: 15% shipping HST#99999 9999 RT0001
- Priority: 1

/* HINT: The above will calculate PST on shipping. Although there might
/* be a tendenancy to think of shipping as a PST exempt service, in fact
/* the Ontario Ministry of Finance says that for cacluating the PST,
/* “The total selling price includes delivery, mailing, transportation, or
/* handling charges, but does not include the GST”. With the above set-up,
/* the PST for the shipping gets calculated (albeit seperately). If you wanted them
/* calculated together, you could assign “GST/PST/HST Class” as the
/* Tax Class when setting up the shipping method. Personally, I prefer
/* to break it out seperately.

========================================================

STEP (5): Specify the appropriate Tax Class for SHIPPING MODULES

MODULES –> SHIPPING

Edit whichever shipping module(s) you are using.

Tax Class: GST Shipping Class

/* SEE PREVIOUS HINT

========================================================

STEP (6): Specify the appropriate Tax for PRODUCTS

This may take some time….

CATALOG –> Categories/Products

Drill down to each product. Click EDIT

TAX CLASS: “GST/PST/HST CLASS”

========================================================

===============
Example Output:
===============

Shipping to Ontario:

Sub-Total: $69.00
Per Item (Best Way): $10.00
8.0% PST (Ontario) + 7.0% GST #99999 9999 RT0001: $10.35
7.0% GST (shipping) + 8.0% PST (shipping): $ 1.50
Total: $90.85

Shipping into the HST zone (NB, NS, or NL):

Sub-Total: $69.00
Per Item (Best Way): $10.00
15% HST#R86179 1655 RT0001: $10.35
15% shipping HST#99999 9999 RT0001: $ 1.50
Total: $90.85

Shipping to Canada, but non-HST, and non-Ontario:
Sub-Total: $69.00
Per Item (Best Way): $10.00
7.0% GST # 99999 9999 RT0001: $ 4.83
7.0% GST (shipping): $ 0.70
Total: $84.53

Shipping to non-Canada zone:
Sub-Total: $69.00
Per Item (Best Way): $10.00
Total: $79.00

If you need help in setting it up we charge a nominal fee of 50 USD for setting up the Canadian Tax for the store.

You can order the package and get it started.

50 USD

osCommerce has a problem when editing an existing manufacturer’s information. If a new manufacturer image is not loaded at the same time then the image that was there previously disappears. osCommerce also fails to delete a manufacturer’s image from the server when the manufacturer is deleted.

The solution to the problems is simple. Open the file admin/manufacturers.php

Find the following lines around line 41:

if ($manufacturers_image = new upload(‘manufacturers_image’, DIR_FS_CATALOG_IMAGES)) {
tep_db_query(“update ” . TABLE_MANUFACTURERS . ” set manufacturers_image = ‘” . $manufacturers_image->filename . “‘ where manufacturers_id = ‘” . (int)$manufacturers_id . “‘”);
}

Replace them with the following lines:

$manufacturers_image = new upload(‘manufacturers_image’);
$webimgtypes = array (‘bmp’, ‘jpg’, ‘jpeg’, ‘gif’, ‘png’);
$manufacturers_image->set_extensions($webimgtypes);
$manufacturers_image->set_destination(DIR_FS_CATALOG_IMAGES);
if ($manufacturers_image->parse() && $manufacturers_image->save()) {
tep_db_query(“update ” . TABLE_MANUFACTURERS . ” set manufacturers_image = ‘” . tep_db_input($manufacturers_image->filename) . “‘ where manufacturers_id = ‘” . (int)$manufacturers_id . “‘”);
}

Find the following around line 77 (line 81 if you’ve made the previous change already)

$image_location = DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG_IMAGES . $manufacturer['manufacturers_image'];

and replace it with the following:

$image_location = DIR_FS_CATALOG_IMAGES . $manufacturer['manufacturers_image'];

Save your work and you are done.
Cheers

This is because of the free gifts addon of oscommerce store. this is a mysql 5 fix.

Need to change 2 files

Fix 3 files:
shopping_cart.php
Edit the line to:
$gift_query = tep_db_query(“SELECT fg.*, p.products_id, p.products_model, p.products_price, p.products_image, p.products_status, pd.products_name FROM (” . TABLE_CARROT . ” fg, ” . TABLE_PRODUCTS . ” p)
LEFT JOIN ” . TABLE_PRODUCTS_DESCRIPTION . ” pd ON (pd.products_id=fg.products_id)
WHERE pd.language_id = ‘”.$languages_id.”‘ AND p.products_id = fg.products_id AND p.products_status = ’1′ ORDER BY fg.threshold ASC”);

admin/gift_add.php
Edit the line to:
$gift_query = tep_db_query(“SELECT fg.*, p.products_id, pd.products_name FROM (” . TABLE_CARROT . ” fg, products p)
LEFT JOIN products_description pd ON (pd.products_id=fg.products_id)
WHERE pd.language_id = ‘”.$languages_id.”‘
AND p.products_id = fg.products_id
ORDER BY fg.threshold ASC”);

If you need commercial support in fixing it you can use the contact us form in the site.

Steps to configure oscommerce for VAT in UK based stores

Login to the Admin section of your osCommerce store

SETUP OF TAX ZONES

Follow the Location / Taxes link, and then Tax Zones

1. Click the insert button and add the first Zone as below:

Zone Name: ROW
Description: Rest of World

2. Then click the insert button again, to save.
3. Click the insert button again to add the second Zone as below:

Zone Name: EC
Description: European Community

4. Then click the insert button again, to save.
5. Now assign countries to ROW Zone
6. Click to highlight the ROW Zone (created in no.1 above) then click the details button.
7. Then click the insert button to add the countries.
8. By default All Countries and All Zones should be selected, if not select these.
9. Then click the insert button again, to save.
10. Now assign countries to EC Zone
11. Click to highlight the EC Zone (created in no.3 above) then click the details button.
12. Then click the insert button to add a country.
13. Select United Kingdom.
14. Then click the insert button again, to save.
15. To complete the EC Zone you should insert all the following countries:

VAT Territory of the EC:

1. United Kingdom and the Isle of Man
2. Austria
3. Belgium
4. Denmark, except the Faroe Islands and Greenland
5. Finland
6. France, including Monaco
7. Germany, except Busingen and the Isle of Heligoland
8. Greece
9. The Republic of Ireland
10. Italy, except the communes of Livigno and Campione d’Italia and the Italian waters of Lake Lugano
11. Luxembourg
12. The Netherlands
13. Portugal, including the Azores and Madeira
14. Spain, including the Balearic Islands but excluding Cueta and Melilla
15. Sweden

For an up-to-date list you should check the Government VAT web site (www.hmce.gov.uk) by searching for “VAT Territory of the EC”

SETUP OF TAX RATES

1. Click the Tax Rates link, then click the new tax rate button.
2. For the Tax Class select Taxable Goods
3. For the Zone select EC, and then complete as follows:

Tax Rate (%): 17.5 (assuming the current rate is 17.5%)
Description: VAT 17.5% (assuming the current rate is 17.5%)
Priority:
4. Then click the insert button, to save.
5. Click the new tax rate button again.
6. Then for the Zone select RoW, and then complete as follows:

Tax Rate (%): 0 (assuming the current rate is 17.5%)
Description: VAT Exempt(assuming the current rate is 17.5%)
Priority:
7. Then click the insert button, to save.
8. Finally, ensure you add a relevant statement to the catalog\includes\footer.php file

eg: “All prices are in UK Pounds sterling & include VAT at 17.5%”

if you need assistance in setting up VAT in your store , you can contact us.

Social media marketing describes use of social networks, online communities, blogs, wikis or any other online collaborative media for marketing, sales, public relations and customer service. It is about using social media platforms and online communities to promote your business. Common social media marketing tools include Twitter, LinkedIn, Facebook, Flickr, Wikipedia, Orkut, YouTube etc

Our team has extensive experience offering a full suite of social media marketing services to clients around the globe.

The campaign will be designed around your specific needs and objectives.

We use the following services to help you build a strong online presence and leverage social media to your advantage.

Blogging
We will setup a blog where you can post blog post with information related to your business.

We can also assign you a writer who will capture your personal voice and branding message in each blog post. Our social media marketing consultant will make your blog social media-friendly by making it easier for people to link, tag, and bookmark your blog posts. We will integrate your blog into your overall marketing campaign and promote your posts to spread awareness of your brand.

Viral Marketing
It encourages people to pass a marketing message on to others

Facebook Communities
It creates a platform where local customers can come together and also helps in sharing news, receiving feedback and providing customer service.

Twitter Accounts
It enables to network and attract new clients and promote the business

You Tube videos
Videos about products information and other social messages is used to market the businesss

Video Optimization
Viral Videos gets quick exposure to business and attract visitors to website

You can order the package and get it started.

250 USD

You can add your logo the following way:
1) go to your paypal account
2) select Profile
3) Custom Payment Pages
4) add Custom Page Style
5) add header image URL with your logo
6) save your style page
7) make your new style page as primary style page

Make sure you have ssl in your store and the image link of logo is in SSL, or else it will give warnings of unsecure contents when a customer is in paypal site for payment from the oscommerce store.

http://www.oscommerce.com/community/contributions,1129

this is a great contribution for adding products to the shopping cart for customers.

along with onepagecheckout – this can be used for a better customer experience in a oscommerce store.

for demo pls email us

This is a known bug in the latest osCommerce 060817 release and has to do with the modules not refreshing with udated changes in the admin.

This fix has worked for several users:
1. Open the catalog/admin/includes/functions/compatibility.php.
2. At the end of the “do_magic_quotes_gpc” routine, add the following code

reset($ar);

It will end up looking like this:

function do_magic_quotes_gpc(&$ar) {
if (!is_array($ar)) return false;
while (list($key, $value) = each($ar)) {
if (is_array($ar[$key])) {
do_magic_quotes_gpc($ar[$key]);
} else {
$ar[$key] = addslashes($value);
}
}
reset($ar);
}

3. Do the same for the compatibility.php file located in catalog/includes/functions/compatibility.php.