Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

HELP SETTING UP SHIPPING!


rustybolt

Recommended Posts

Im based in the UK and would like some help setting up shipping tariffs.

 

Is there an easy contribution that will enable our customers to first select the country they are in and then if based in the UK select their county ie: Devon, Yorkshire, Derbyshire etc etc.

 

Im really stuck setting this up so any help or advise is really apprieciated.

Link to comment
Share on other sites

Use the UK zones contribution for this

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

 

When a customer creates an account and selects the country the counties (or states) will come up as options (or when he changes address). You could also select what countries to support and populate only the country's specific states:

 

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

 

Finally create the tax zones that will also be used for shipping to cover the UK and other countries of preference. Don't forget to setup the tax zones details for each tax-zone. That's the part a lot of people miss when they setup their store for shipping.

Link to comment
Share on other sites

osc admin->modules->Locations/Taxes->Tax Zones

 

Create first the folder then select it click details and then create the actual zone details. The UK zones should appear with all other zones in the drop-down list.

Link to comment
Share on other sites

osc admin->modules->Locations/Taxes->Tax Zones

 

Create first the folder then select it click details and then create the actual zone details. The UK zones should appear with all other zones in the drop-down list.

 

 

found it thanks, but i think ive installed it twice cos theres 2 of every county!!

 

how do i remove one set from the database?

Link to comment
Share on other sites

First backup the database, then make sure there're duplicates. Use something like phpmyadmin, examine the contents of the zones and zones_to_geo_zones tables. Newer entries have higher IDs. If there're duplicate you could delete them with the phpmyadmin. The default osc UK countries_id code is 222

 

So you execute 2 queries in the phpmyadmin

delete from zones where zone_country_id='222';
delete from zones_to_geo_zones where zone_country_id='222';

 

Then you re-install it. But first make sure there is a duplicate

Link to comment
Share on other sites

well ive messed something up cos i get the following error

 

1146 - Table 'dpsracing.geo_zones' doesn't exist

 

select count(*) as total from tax_class tc, tax_rates r left join geo_zones z on r.tax_zone_id = z.geo_zone_id where r.tax_class_id = tc.tax_class_id

 

[TEP STOP]

 

 

what have i done. and idont know how to back up the database cos i dont know where its stored

Link to comment
Share on other sites

hi again, right it seems i need to install this properly so have follwed it to the letter, secured the admin, created the database, set write permissions etc. here is our site address

 

www.dpsracing.co.uk

 

I had a really good looking site locally but it seems a task to transfer it all, so am starting from scratch, that way any probs can be seen by you kind people helping me..!

 

ive tried to install php MyAdmin but i get an error, it seems i need to create a config file for this, how can i execute sql files into the database.

 

please help mark!

Link to comment
Share on other sites

Before getting into trouble installing phpmyadmin check if your host's cpanel already has it. Usually they do.

 

Now to go live all you have to do is to use ftp (or your host's file manager) to copy the osc files to the site and import the dbase using the phpmyadmin (create database name and then click the import tab of phpmyadmin and select the sql file-previously saved in your local server with your osc admin backup manager).

 

Finally you setup the configure.php files to point to the correct server and the oscadmin store configuration (like email, cookies)

Link to comment
Share on other sites

The login, create account, checkout pages go through secure connections with your configuration. Make sure you have those setup correctly (right now its setup for a dedicated SSL certificate - is that correct?).

Link to comment
Share on other sites

I see, I remember some threads talking about the fasthosts, they maintain separate folders for secure non-secure pages. Yes, the secure pages should go in the secure folder. But you need the support files (includes, languages etc) so pretty much you duplicate the whole store.

Link to comment
Share on other sites

The root folders are specific with your host. You could ask them if they have different directories for secure non-secure pages and what are they. The non-secure pages display correctly so either a secure folder is needed or a different configuration for the secure paths.

Link to comment
Share on other sites

im going to give them a call in a minute, i take it ill need an ssl certificate.

 

can you recommend a free trail so that i can get used to setting this up before purchasing?

 

seen this which seems reasonable -

 

http://www.instantssl.com/ssl-certificate-...ertificate.html

 

is this wise, id like to run through the process 1st.

Edited by rustybolt
Link to comment
Share on other sites

Ok so here is how the server setting should be in the configure.php files

 

  define('HTTP_SERVER', 'http://www.dpsracing.co.uk'); // eg, http://localhost - should not be empty for productive servers
 define('HTTPS_SERVER', 'https://vault2.secured-url.com'); // eg, https://localhost - should not be empty for productive servers

Link to comment
Share on other sites

osc will recognize it as long as the scripts are there. But if the host switches directories on SSL it will not find the files. Just try setting up the one directory that you currently have. If the SSL works it means there is no 2nd folder to worry about.

Link to comment
Share on other sites

you are speaking to someone thats a bit new to this!!

 

I have created a folder in the root of the SSL webspace (this is seperate FTP details to the normal site)

 

the only file in their is cgi-bin

 

I have created a file next to it and named it dps, should the file be inside the CGI-BIN or next to it>??

 

i have sent the files from the normal site into this (all the php files from the root catalog, and the entire includes folder. Am i to send the entire shop over??

 

its not working anyway what ive done, have a look and try get in the create account part

 

http://www.dpsracing.co.uk

 

any ideas what mess ive created??

 

ive changed both config files to point to this folder.

Edited by rustybolt
Link to comment
Share on other sites

don't copy any files yet. Goto your catalog\includes\configure.php file and view it. See if the server settings I posted earlier match those in your configure.php file

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...