rustybolt Posted February 16, 2006 Share Posted February 16, 2006 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. Quote Link to comment Share on other sites More sharing options...
Guest Posted February 16, 2006 Share Posted February 16, 2006 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. Quote Link to comment Share on other sites More sharing options...
rustybolt Posted February 16, 2006 Author Share Posted February 16, 2006 thanks enigma, however ive added this via MySQL and it says successfully added. Where are these options in the admin section?? Quote Link to comment Share on other sites More sharing options...
Guest Posted February 16, 2006 Share Posted February 16, 2006 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. Quote Link to comment Share on other sites More sharing options...
rustybolt Posted February 18, 2006 Author Share Posted February 18, 2006 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? Quote Link to comment Share on other sites More sharing options...
Guest Posted February 18, 2006 Share Posted February 18, 2006 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 Quote Link to comment Share on other sites More sharing options...
rustybolt Posted February 18, 2006 Author Share Posted February 18, 2006 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted February 18, 2006 Share Posted February 18, 2006 you backup the database either using the osc backup manager or using the phpmyadmin. Quote Link to comment Share on other sites More sharing options...
rustybolt Posted February 18, 2006 Author Share Posted February 18, 2006 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! Quote Link to comment Share on other sites More sharing options...
Guest Posted February 19, 2006 Share Posted February 19, 2006 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) Quote Link to comment Share on other sites More sharing options...
rustybolt Posted February 19, 2006 Author Share Posted February 19, 2006 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted February 19, 2006 Share Posted February 19, 2006 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?). Quote Link to comment Share on other sites More sharing options...
rustybolt Posted February 19, 2006 Author Share Posted February 19, 2006 not too sure, ive created an ssl secure folder within my hosts admin, do i place these files in their? Quote Link to comment Share on other sites More sharing options...
Guest Posted February 19, 2006 Share Posted February 19, 2006 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. Quote Link to comment Share on other sites More sharing options...
rustybolt Posted February 19, 2006 Author Share Posted February 19, 2006 i dont have a folder in my htdocs file, ive just been given a URL of some secured webspace. What do i have to do? Quote Link to comment Share on other sites More sharing options...
Guest Posted February 19, 2006 Share Posted February 19, 2006 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. Quote Link to comment Share on other sites More sharing options...
rustybolt Posted February 19, 2006 Author Share Posted February 19, 2006 (edited) 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 February 19, 2006 by rustybolt Quote Link to comment Share on other sites More sharing options...
rustybolt Posted February 19, 2006 Author Share Posted February 19, 2006 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? Quote Link to comment Share on other sites More sharing options...
Guest Posted February 19, 2006 Share Posted February 19, 2006 its in the catalog\includes\configure.php catalog\admin\includes\configure.php Quote Link to comment Share on other sites More sharing options...
rustybolt Posted February 20, 2006 Author Share Posted February 20, 2006 right my host has an SSL folder that i can access its a different address to the actual site tho. https://vault2.secured-url.com is the address of the SSL http://www.dpsracing.co.uk is our site what do i have to do now then? which files go where and what has to changed in the configure .php?? thanks Quote Link to comment Share on other sites More sharing options...
Guest Posted February 20, 2006 Share Posted February 20, 2006 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 Quote Link to comment Share on other sites More sharing options...
rustybolt Posted February 20, 2006 Author Share Posted February 20, 2006 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. Quote Link to comment Share on other sites More sharing options...
Guest Posted February 20, 2006 Share Posted February 20, 2006 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. Quote Link to comment Share on other sites More sharing options...
rustybolt Posted February 20, 2006 Author Share Posted February 20, 2006 (edited) 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 February 20, 2006 by rustybolt Quote Link to comment Share on other sites More sharing options...
Guest Posted February 20, 2006 Share Posted February 20, 2006 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.