osCommerceCoders.com

This is for stores using currencies which is not USD. then follow the steps below

modify the catalog/ext/modules/payment/paypal/express.php file.

Find:

$params = array();
$params['AMT'] = $paypal_express->format_raw($order->info['total'], ”, 1);

Replace with:

$params = array(‘CURRENCYCODE’ => $order->info['currency']); $params['AMT'] = $paypal_express->format_raw($order->info['total']);

Then discount code works perfect for currencies like GBP, AUD etc which is not the default USD

in usps.php

Locate

list($type, $cost) = each($uspsQuote[$i]);

Add these lines after it

$type = str_replace(‘<sup>®</sup>’, ”, $type);
$type = str_replace(‘<sup>™</sup>’, ”, $type);
$type = str_replace(‘**’, ”, $type);

This removes the everything that was added by USPS that was causing errors on the site. It also fixes the international issue (response had added a ** to the end of the title).

thanks

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

If you need paid support you can use the contact us in the site

osCommerce V&TS is designed to run on your web server and scan your public web files for malicious code. It is small, portable and efficient, uses minimal server resources, and provides a full report on what has been discovered.

It is a great contribution to protect your store.

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.

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.

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.

Here’s how to do it. (remember to backup before any modification)

Also change the country code to match yours (this example uses GB for UK)

********************************************************************
* Open catalog/includes/languages/english.php (this is for your catalog section)
* The changes are highlighted.
********************************************************************
@setlocale(LC_TIME, ‘en_GB.ISO_8859-1′);

define(‘DATE_FORMAT_SHORT’, ‘%d/%m/%Y’); // this is used for strftime()
define(‘DATE_FORMAT_LONG’, ‘%A %d %B, %Y’); // this is used for strftime()
define(‘DATE_FORMAT’, ‘d/m/Y’); // this is used for date()
define(‘DATE_TIME_FORMAT’, DATE_FORMAT_SHORT . ‘ %H:%M:%S’);

////
// Return date in raw format
// $date should be in format mm/dd/yyyy
// raw date is in format YYYYMMDD, or DDMMYYYY
function tep_date_raw($date, $reverse = false) {
if ($reverse) {
return substr($date, 0, 2) . substr($date, 3, 2) . substr($date, 6, 4);
} else {
return substr($date, 6, 4) . substr($date, 3, 2) . substr($date, 0, 2);
}
}

*********************
Also change the following
*********************

CODE
define(‘ENTRY_DATE_OF_BIRTH_ERROR’, ‘Your Date of Birth must be in this format: MM/DD/YYYY (eg 05/21/1970)’);
to
CODE
define(‘ENTRY_DATE_OF_BIRTH_ERROR’, ‘Your Date of Birth must be in this format: DD/MM/YYYY (eg 21/05/1970)’);

CODE
define(‘ENTRY_DATE_OF_BIRTH_TEXT’, ‘* (eg. 05/21/1970)’);
to
CODE
define(‘ENTRY_DATE_OF_BIRTH_TEXT’, ‘* (eg. 21/05/1970)’);

CODE
define(‘DOB_FORMAT_STRING’, ‘mm/dd/yyyy’);
to
CODE
define(‘DOB_FORMAT_STRING’, ‘dd/mm/yyyy’);

How to Change Product Model Length
The default 12 character limit for product model strings may be too short for certain needs, and can be easily increased with phpMyAdmin or directly with MySQL.

Two database tables need to be modified when changing the length of the product model
field: products, and orders_products.

Using phpMyAdmin

Select the products table on the left side of phpMyAdmin
Select the product_model check box
Click on the Change button
Set the new size value under the Length/Values field, and click on the Save button. The same steps need to be reproduced for the orders_products table.

Using MySQL
alter table products change products_model products_model varchar(255);
alter table orders_products change products_model products_model varchar(255);