Jump to content
Sign in to follow this  
rustybolt

HELP SETTING UP SHIPPING!

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.

Share this post


Link to post
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.

Share this post


Link to post
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.

Share this post


Link to post
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?

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
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!

Share this post


Link to post
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)

Share this post


Link to post
Share on other sites

ive done it i think.

 

whats not working tho is the login, create account pages, have a look

 

www.dpsracing.co.uk

 

i appreciate all the help mate, thanks

Share this post


Link to post
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?).

Share this post


Link to post
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.

Share this post


Link to post
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.

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

really confused now, it seems my hosting cant instal ssl certificates on its server??

 

its provided some SSL webspace but im confused.

 

Where in osc do you configure the ssl pages, so that i can use the login etc pages?

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

would any files need to placed in a folder in the secured part?

 

or does oscommerce recognise the SSL and allow access to the login pages??

 

you've been a great help mark.

Share this post


Link to post
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.

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×