Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Zone Based Shipping Rate - Change Field size


hennanra

Recommended Posts

Hello,

 

I remember in an old installation I had to modify the field sizes in the database (I think) for the Zone based shipping table. However, I do not remember the table or field that was changed for this. Basically, I am entering a very long list of shipping weight and prices for some zones - the field in the admin panel (Modules > Shipping > Zone Based Shipping Rates) is too small to accomodate all of these.

 

Also, the Zone Countries fields in this section is too small. Please can someone advise where I need to change both of these fields. I remember something like the database field size being set to a given number of characters and therefore it restricts the number of text characters that can be entered - although I managed to change this in an old installation - but don't remember how.

 

Kind Regards,

Raheel

Link to comment
Share on other sites

all these go in configuration table.

 

Should configuration value table.

 

Satish

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Link to comment
Share on other sites

Hello,

 

Thanks for guidance. For reference as to what I did (in case anyone else benefits from this post) - I checked in the configuration table and changed the field type for the "Configuration Value" field from VarChar(255) to Text. Whilst this field is applied across all data including those not related to shipping - the shipping records require a far longer string (at least in my case).

 

I therefore changed the field type to Text - with no field size specified. I was finding it a bit awkward to enter records in using control panel (could be that I didn't close and restart session) - so I used PHP my admin to enter data and it worked fine.

 

Thanks again.

 

Kind Regards.

Raheel

 

 

all these go in configuration table.

 

Should configuration value table.

 

Satish

Link to comment
Share on other sites

  • 1 year later...

I have tried to follow at zones.php instruction. but i still cant add any zone.

only the default zone appeared which is

Zone 1 Countries

US,CA

 

Zone 1 Shipping Table

3:8.50,7:10.50,99:20.00

 

can anyone explain to me more details ..

Link to comment
Share on other sites

I have tried to follow at zones.php instruction. but i still cant add any zone.

only the default zone appeared which is

Zone 1 Countries

US,CA

 

Zone 1 Shipping Table

3:8.50,7:10.50,99:20.00

 

can anyone explain to me more details ..

Hi

 

You have to go into the zones.php file in catalog/includes/modules/shipping - there's a line in there that says something like 'number of zones =1', change that to how ever many you want. The extra zone fields will then appear in admin>shipping>zones

 

Graeme

Link to comment
Share on other sites

Hi

 

You have to go into the zones.php file in catalog/includes/modules/shipping - there's a line in there that says something like 'number of zones =1', change that to how ever many you want. The extra zone fields will then appear in admin>shipping>zones

 

Graeme

 

thanks for your reply, the extra zone field is supposed to appear in admin>modules>shipping>zone rates ..is it true? ..

i have change the number of zones to 7 and when i go to admin>modules>shipping>zone rates, the part that change is under zone 1 handling fee .. by default it has only one textfield ..after i change to 7 it has 18 textfield under the zone one handling fee ..

can you explain why it is so and how i can actually add more zone?

Thanks in advance .. :D

Link to comment
Share on other sites

  • 1 month later...
i have figure out the solution ..

to change the zone rate, i follow the instruction at zones.php ..

after i edit it ..

i have to reinstall the zone rates part ..then only it can apply ..

 

Then did you get the zones? I would be most grateful if you explain what you mean because I have the same problem - when I changed the number of zones from 1 to 7 they all appeared under Zone 1 handling fee. What does reinstall mean? Please help. Thanks in advance. Muzaffar

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...