I need to divide cost shipping with num. items

[LukasDJ]

HI Everyone.....

I need help with OsCommerce panel....

I need to put 3/4 different cost shipping based on the number of products ordered via OsCommerce site.

Example: a customer order 3 products = the cost of spedition is 5 Euro, order 7 pcs = the cost is 9 euro, order more than 10 pcs= the cost if fix at 14 euro.

 

This, if possible, to different zones too..... (the shop make these prices for Italy, and for europe there are 2 euros difference and rest of world more or less 4.5 euros)

 

It's possible to do this??

Thanks for an answer.....

Lukas

[wheeloftime]

HI Everyone.....

I need help with OsCommerce panel....

I need to put 3/4 different cost shipping based on the number of products ordered via OsCommerce site.

Example: a customer order 3 products = the cost of spedition is 5 Euro, order 7 pcs = the cost is 9 euro, order more than 10 pcs= the cost if fix at 14 euro.

 

This, if possible, to different zones too..... (the shop make these prices for Italy, and for europe there are 2 euros difference and rest of world more or less 4.5 euros)

 

It's possible to do this??

Thanks for an answer.....

Lukas

<{POST_SNAPBACK}>

 

If the weight is of no relevance to your products I could think of something like the following:

- Give your products a weight of 1

- use the zones module and define 3 different zones (or as much as you need)

- for each zone you can create a shipping table like:

3:5.00,7:9.00,10:14.00,100:14.00 and adjust the prices accordingly

The only thing is you might need more 'weight' ranges depending on what you would charge for 1 product or 6 products or 9 products.

The above table says that 1-3 kg. (in your case 1-3 products) cost 5 euro, 4-7 products cost 9 euro, 10-100 products cost 14 euro (change the 100 to something bigger to cover all possibilities but I guess 100 is already a nice figure).

This assumes you can use 1 kg = 1 product

There might be other ways but this seems a simple solution.

[LukasDJ]

thanks ..... but...I have a little problem....my database is more or less 2000 articles now....and to add the weight =1 mean to do a very hardest work and I haven't this time free :(

 

I no understand if, actually, is possible to "program"" the system with the voices "item" becouse I tried to put this but I think isn't the right thing I am searching....

 

I am very down.... :( :( :(

[wheeloftime]

thanks ..... but...I have a little problem....my database is more or less 2000 articles now....and to add the weight =1 mean to do a very hardest work and I haven't this time free  :(

 

I no understand if, actually, is possible to "program"" the system with the voices "item" becouse I tried to put this but I think isn't the right thing I am searching....

 

I am very down.... :(  :(  :(

<{POST_SNAPBACK}>

 

It might help if you tell what you sell, I do not understand what you mean witht 'voices item' and what solution you already tried ?

If putting a standard weight to all items is an option than you don't have to do that by hand for all items, a simple database query would do the trick for you in a few seconds. No need to be down, every 'challenge' has a solution <_<

[LukasDJ]

My shop is a Cd-Vinyl Shop....with cd, vinyls and merchandise and equipment as products to sell... I need to divide the shipping in 4-5 zones (Italy, Europe, USA, Rest Of World and Oceanias ....maybe some other )

I setted to 1 the "weight" of cd's and vinyls products.....I want to set to 4 each merchandise article.....and 10 every equipment article (becouse equipment is very cost to send via mail service)

I need to know this.....

In Italy from 1 to 4 cd's or vinyls articles the cost to send is more or less 6 Euro, from 5 to 8 or 1 equipment article (with weight=8 example) the cost is 13.91, from 12 cd's to 50 or 2 equipment the cost is 20 (these costs are casual at this moment .....they are necessary to explain me and my problem)

If a customer is registered out of Italy......in EUROPE.....maybe that the cost from 1 to 4 is 11 euros, from 5 to 8 or 1 equipment the cost is 20 ecc....

If a customer is registered from Brasil or India maybe the costs are 15 euros, 19 euros.....

I need to set these zones and prices...but....I haven't the big problem that I no understand how to do it well.....can you to help me (if possible for you with little examples to explain me about the control panel).....

I had my shop based on OsCommerce 2.2 vers. ms2 (I read that is incoming new version but...I would like to upgrade so to use a SSL Server too, but I have doubt that I need to rewrite all my site/database to adapt it to new system....what you think???)

 

Thanks A LOT if you can to help me.

Lukas

 

It might help if you tell what you sell, I do not understand what you mean witht 'voices item' and what solution you already tried ?

If putting a standard weight to all items is an option than you don't have to do that by hand for all items, a simple database query would do the trick for you in a few seconds. No need to be down, every 'challenge' has a solution  <_<

<{POST_SNAPBACK}>

[wheeloftime]

My shop is a Cd-Vinyl Shop....with cd, vinyls and merchandise and equipment as products to sell... I need to divide the shipping in 4-5 zones (Italy, Europe, USA, Rest Of World and Oceanias ....maybe some other )

I setted to 1 the "weight" of cd's and vinyls products.....I want to set to 4 each merchandise article.....and 10 every equipment article (becouse equipment is very cost to send via mail service)

I need to know this.....

In Italy from 1 to 4 cd's or vinyls articles the cost to send is more or less 6 Euro, from 5 to 8  or 1 equipment article (with weight=8 example) the cost is 13.91, from 12 cd's to 50 or 2 equipment the cost is 20 (these costs are casual at this moment .....they are necessary to explain me and my problem)

If a customer is registered out of Italy......in EUROPE.....maybe that the cost from 1 to 4 is 11 euros, from 5 to 8 or 1 equipment the cost is 20 ecc....

If a customer is registered from Brasil or India maybe the costs are 15 euros, 19 euros.....

I need to set these zones and prices...but....I haven't the big problem that I no understand how to do it well.....can you to help me (if possible for you with little examples to explain me about the control panel).....

I had my shop based on OsCommerce 2.2 vers. ms2 (I read that is incoming new version but...I would like to upgrade so to use a SSL Server too, but I have doubt that I need to rewrite all my site/database to adapt it to new system....what you think???)

 

Thanks A LOT if you can to help me.

Lukas

<{POST_SNAPBACK}>

 

Hello Lukas,

 

I'll give it a try and will base my answer on using the zones module provided with osC.

First thing you will have to do is to define the amount of zones you are going to need. To do that you will have to edit the catalog/includes/modules/shipping/zones.php

When you open that file you will find:

      // CUSTOMIZE THIS SETTING FOR THE NUMBER OF ZONES NEEDED
     $this->num_zones = 1;

Change the 1 to the amount of zones you are going to need. As you are not sure yet of how many you will need in the end just give it a higher number as you estimated for this moment so you will have some 'spare' zones for later (it doesn't matter if you do not use a couple). So I would say give it a number 7 or 8 to be on the safe side (changing it afterwards is not a good thing as you will loose everything you already defined for the zones).

 

To activate the new zones you have to go to your Admin->Modules->Shipping and select the zones option. If it is not installed already just choose install. If you already have it installed then first choose Remove and immediately after that choose Install. Only that way you can get the newly defined zones active.

 

Next step will be to define the different zones and their according shipping prices.

Assuming you can setup your products with a transparency between weight and quantity ( that is 1 kg = 1 CD, 2 kg = 2 CD, 8 kg = 1 equipment etc.) you set the Zones table method to weight.

 

Then you go defining the zones. Zone 1 will be for Italy (or whatever you want but just let's start with your own country) and for Zone 1 Countries you type IT

For the Zone 1 Shipping Method Name you can type something appropriate or leave it empty.

Now you are going to define the costs with the Zone 1 Shipping Table field.

Here you say (based on your example): 1:6.00, 5:13.91,12:20.00,51:40.00

This just tells that 1-4 CD's will cost 6 euro, 5-11 CD's or 1 equipment will cost 13,91 euro etc. All for shipping in Italy alone.

Of course you should take into account that if 1 equipment = 8 there will be room for three more CD's (= 3) within the same shipping range. 2 Equipments of 8 each gives 16 and will give a shipping cost of 20,00 euro

Keep in mind that you should define the weight with each CD to 1 and for an equipment to 8.

 

Then you go to define the next zone(s) which is more or less the same:

If Zone 2 will be for Europe (ECC countries) you will have to create the list of european countries there for Zone 2 Countries like:

BE,DE,DK,EE,FI,FR,GR,HU,IE,LV,LT,LU,MC,NL,AT,PL,PT,SE,SK,ES,CZ,GB,UK,SE

The zone 2 Shipping Table Field would then read something like:

1:11.00, 5:20.00,12:35.00,51:65.00

 

To the above country list for Europe you can add the non-ECC European countries or have them in a new Zone. If the shipping rates are the same for European ECC countries and European non-ECC countries you can put them together otherwise differentaite by using a new zone.

 

The rest is pretty much the same; decide which countries belong to the same zone, fill in their 2 character ISO code and assign them the shipping table according to the cost of your shipping provider.

 

Create some test accounts with imaginary people from different countries and test your zones. First make sure though you have given your products the correct weight.

 

Before you start make sure you are convinced you can use this weight/quantity conversion otherwise you will need something different.

 

I hope this will get you on the right track !

[LukasDJ]

I have a little problem....once time setted the number of zones in INCLUDES/MODULES/SHPPING/ZONES.PHP to 6 (zones that I need) and SAVED....I gone to activate/install into ADmin panel, choosed MODULES and SHPPING....ZONE RATES (right?) and INSTALL....results is ....

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'True', 'False'), ', now())' at line 1

 

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable Zones Method', 'MODULE_SHIPPING_ZONES_STATUS', 'True', 'Do you want to offer zone rate shipping?', '6', '0', 'tep_cfg_select_option(array('True', 'False'), ', now())

 

[TEP STOP]

 

 

What mean??what I can to do??

[LukasDJ]

Can you to contact me via ICQ? 84332876 (nickname Drago)

Thanks (I am connected now too...)

[wheeloftime]

Can you to contact me via ICQ? 84332876 (nickname Drago)

Thanks (I am connected now too...)

<{POST_SNAPBACK}>

 

I have ditched ICQ a long time ago so that's not an option I'm afraid. You can find me on Skype though with wotantiek.

As for your error I am not sure why that occurs. Somehow it hasn't properly removed itself as it seemes and now gives a problem with reinstalling.

It shouldn't be too hard to cure this through phpMyAdmin but I don't know how familiar you are with directly editing your database ?!

[LukasDJ]

I installated Skype now....I tried to contact you but skype say me that you are no disponible to chat.....