Tag Archives: settings

cre loaded – how to use shipping zones for free shipping

If you want to restrict the conditions of a shipping module to a specific state or county then you can do this by creating a Shipping Zone and attaching this to the shipping module.

Step 1: create a Zone

Go to the Admin panel >> Locations/Taxes >> Zones … New Zone button (bottom)
This example shows the entry for the state of Victoria in Australia.

Cre Loaded has Zones set up for several countries already, including the US, Canada, Austria, Switzerland, Germany and Spain.

If your region doesn’t use 2 or 3-letter codes, just retype the Zone name again.

Click Insert when completed.

The sql statements for automatically setting up Zones for Australia are available here

Step 2: create a Tax Zone

Go to the Admin panel >> Locations/Taxes >> Tax Zones … Insert button (on right)
This is where the label for the Shipping Zone is created. You don’t have to use a geographic location as the Tax Zone title – for instance you could create a Tax Zone called ‘Free Shipping Regions.’ All of the applicable regions could be added to this label.

Complete and click Insert.

Step 3: add the Country & Region to the Tax Zone

With the Tax Zone selected (yellow) click the Details button on right.
Next, click insert and choose the Country, then from the dropdown below it, choose the region (in this case, Victoria.)

Click Insert again.

(Repeat Step 3 for each region you want to add to ‘Free Shipping Regions.’ When done continue to Step 4.)

Step 4: attach Shipping Zone to the shipping module

Go to the Admin panel >> Modules >> Shipping >> and the shipping module you want to add the Shipping Zone to.

In the example I’ve used the Free Shipper shipping module and chosen ‘Free Shipping Regions’ from the Shipping Zone dropdown.

Click Update to finish.

Result – when a customer with a Delivery Address State/County of ‘Victoria’ makes a purchase, the shipping module settings (in this case free shipping over $50) will be applied.

add currency dropdown to menu bar

If you run an e-commerce website that accepts multiple currencies, then customers will appreciate being able to change currencies quickly.

currency dropdown added to cre63_ats template

This modification adds a currency dropdown to a menu bar (part of the cre63_ats template for Cre Loaded), however it will work for all osCommerce-based carts with minor tweaks.

            
    currencies);
                   $currencies_array = array();
                   while (list($key, $value) = each($currencies->currencies)) {
                  $currencies_array[] = array('id' => $key, 'text' => $value['title']);
                }
                  $hidden_get_variables = '';
                  reset($_GET);
                  while (list($key, $value) = each($_GET)) {
                  if ( ($key != 'currency') && ($key != tep_session_name()) && ($key != 'x') && ($key != 'y') ) {
                  $hidden_get_variables .= tep_draw_hidden_field($key, $value);
                }
              }
            }
                  echo tep_draw_form('currencies', tep_href_link(basename($PHP_SELF), '', $request_type, false), 'get');
                  echo tep_draw_pull_down_menu('currency', $currencies_array, $currency, 'onChange="this.form.submit();"') . $hidden_get_variables . tep_hide_session_id();
                  echo '';
    ?>

Disable any ‘Switch to Default Language Currency’ setting you may have enabled in your Configuration panel.

Australian zone and tax settings

You can plug all the default zone and tax settings through the Admin but there’s an easier way. The sql snippets below can be run through phpMyAdmin which you can usually access through cPanel. Once in phpmyadmin, select the database you want to update and click on the Sql tab at the top of the page. Copy n paste the code below then Go. Once done, your Australian store will have all the tax and zone information needed for using various shipping and payment modules.

Note – the sqls below are for a store that is missing the data. Check your admin for these settings already (eg under Localizations >> Currencies for AUD; under Locations/Taxes >> Zones for Australian states. There’s no point readding them if they already exist.)

Australian Zones (States)

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',13,'NSW','New South Wales');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',13,'VIC','Victoria');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',13,'QLD','Queensland');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',13,'NT','Northern Territory');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',13,'WA','Western Australia');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',13,'SA','South Australia');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',13,'TAS','Tasmania');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',13,'ACT','Australian Capital Territory');

Australia GST Setup

update tax_class set tax_class_title="GST" where tax_class_title = "Taxable Goods";
update tax_class set tax_class_description="The following types of products attract GST in Australia" where tax_class_title = "GST";
update tax_rates set tax_description = "GST" where tax_description = "FL TAX 7.0%";
update tax_rates set tax_rate = "10" where tax_description = "GST";

Australia Currency Setup

update currencies set code = "AUD" where code = "USD";
update currencies set title = "Australian Dollar" where code = "AUD";
update configuration set configuration_value = "AUD" where configuration_key = "DEFAULT_CURRENCY";
update configuration set configuration_value = "true" where configuration_key = "DISPLAY_PRICE_WITH_TAX";

Australia Tax Geo Zone Setup

insert into `geo_zones` (`geo_zone_id`,`geo_zone_name`,`geo_zone_description`) values (1,'Australia','');
insert into zones_to_geo_zones (zone_country_id, zone_id, geo_zone_id)
select countries_id as zone_country_id, 0 as zone_id, geo_zone_id
   from countries, geo_zones
   where countries_name = "Australia"
   and geo_zone_name = "Australia";