pbaddock Posted March 8, 2003 Share Posted March 8, 2003 Hi All, I'm a newbie (standard disclaimer), I was updating the currencies and tax zones etc. I removed the USD currency and added a new one (Australian Dollars / AUD). It was working when I had simply edited the USD entry earlier (I should have left well-enough alone!!). Anyway, after removing USD, all my prices on the catalog changed to $0 for the initial sample data in the catalog (I'm going to add new products shortly but want to understand whats gone wrong first). The price shows up OK in the admin area. I figured that the dB had lost a foreign key to that currency - so started sniifing around but I can't find where the currency is picked up by the products. I searched the forum for similar issues but can't see any. Can anyone help? (its prob something obvious I've missed). Phil http://www.platter-pus.com Link to comment Share on other sites More sharing options...
Guest Posted March 8, 2003 Share Posted March 8, 2003 In admin.currencies click "edit" on your aussie dollars and scroll down and check the checbox that says "set as default" Link to comment Share on other sites More sharing options...
pbaddock Posted March 8, 2003 Author Share Posted March 8, 2003 Thanks for such a quick reply...yeah - tried that...its currently the default but still no prices (see http://www.platter-pus.com) Link to comment Share on other sites More sharing options...
Guest Posted March 8, 2003 Share Posted March 8, 2003 In Admin>my store set "use default language currency" to true Link to comment Share on other sites More sharing options...
Guest Posted March 8, 2003 Share Posted March 8, 2003 in your admin/currencies click edit on your aussie dollar and make sure that in the value you put 1.0000000 and after you click on "update curencie" HTH The_Bear Link to comment Share on other sites More sharing options...
pbaddock Posted March 8, 2003 Author Share Posted March 8, 2003 OK - tried both those suggestions. The "use default language currency" was false...set to true. Double checked the value in aussie dollar - was 1.00000000....changed to 1.0000000 (to be sure...to be sure...). Still no luck... Link to comment Share on other sites More sharing options...
pbaddock Posted March 8, 2003 Author Share Posted March 8, 2003 I notice the country has a couple of "ISO" codes - do they need to match the code of the currency? (country codes are AU and AUS...currency is AUD). Link to comment Share on other sites More sharing options...
pbaddock Posted March 8, 2003 Author Share Posted March 8, 2003 I don't want to waste anyones time on the forum - can anyone tell me if a simple re-execution of the install oscommerce.sql will be OK for an already setup store ie if I just wipe the dB out and start again from scratch?). Link to comment Share on other sites More sharing options...
pbaddock Posted March 8, 2003 Author Share Posted March 8, 2003 yippee!! I fixed it. I re-executed the followin from the install script: INSERT INTO tax_rates VALUES (1, 1, 1, 1, 7.0, 'FL TAX 7.0%', now(), now()); INSERT INTO geo_zones (geo_zone_id,geo_zone_name,geo_zone_description,date_added) VALUES (1,"Florida","Florida local sales tax zone",now()); INSERT INTO zones_to_geo_zones (association_id,zone_country_id,zone_id,geo_zone_id,date_added) VALUES (1,223,18,1,now()); ...after removing the records from these tables and all is well again. me thinks I need a dB schema diagram! This time round I think I wont go deleting records - I'll just edit whats there....thanks all for the help!! Link to comment Share on other sites More sharing options...
pbaddock Posted March 8, 2003 Author Share Posted March 8, 2003 actually - found the real cause - I also restored the currencies table...it was the "code" field which had "USD". I had changed this to AUD for australian dollars and this obviously broke a relationship somewhere....now to find out what uses this so I can rename my currency code... Link to comment Share on other sites More sharing options...
jrobbio Posted March 10, 2003 Share Posted March 10, 2003 pbaddock could you just clarify what the problem was and how you fixed it as I have the same problem since i want to use British Pounds. Top Fun Websites .com - The place to find YOUR entertainment on the net Link to comment Share on other sites More sharing options...
jrobbio Posted March 11, 2003 Share Posted March 11, 2003 I managed to get it to finally work. I'm not overly certain what I did but I think it was making sure I pressed the update button and flicking to false in configuration under switch to default language currency as I think it breaks it when you change from the original languages and currencies. Top Fun Websites .com - The place to find YOUR entertainment on the net Link to comment Share on other sites More sharing options...
pbaddock Posted March 11, 2003 Author Share Posted March 11, 2003 I feel a little unsure as to how much you should rely on this reply as I never quite got to the bottom of all the dB relationships (ran out of time the other day to fully analyse) - but I did observer particular sensitivity to the "Code" field in the Currencies area. I ended up leaving my "Code" as USD and altered all the rest to get it working. If I changed the Code to AUD, it broke the relationships and prices disappeared. So my final values were : Currencies: Aussie Dollars, USD, 1.000 Languages (english :en as default) Zones: Australia / Victroria / VIC (ie zone of victoria in country australia) Tax Zone --> AllAustralia ------> Australia / All Zones Tax Classes GST Inclusive Tax Rates Priority=1, TaxClass=GST Inclusive, Zone=AllAustralia,TaxRate=10% That allowed me to have a pure single country focus and all to function OK and prices and orders show OK and calculate tax correctly. Its likely that there is a better config to achieve this outcome - but that worked OK for me. If you find a more appropriate way to structure - I'd love to hear it. Hope that helps Phil B Link to comment Share on other sites More sharing options...
RhettCan Posted March 19, 2003 Share Posted March 19, 2003 actually - found the real cause - I also restored the currencies table...it was the "code" field which had "USD". I had changed this to AUD for australian dollars and this obviously broke a relationship somewhere....now to find out what uses this so I can rename my currency code... We're having the same problem over here, too. What is going on with all of this? Trying everything doesn't seem to work. Anyone please help! I am chaning it for CAD Canadian Dollars. Thanks Rhett Nye Island Ink-Jet Systems Inc. www.islandinkjet.com "1000 Locations Forecast by 2005" Link to comment Share on other sites More sharing options...
Guest Posted March 19, 2003 Share Posted March 19, 2003 check this Hi Have a look in MODULE : Includeslanguagesenglish.php Quote: Line 36: Note Currency should always be GBP // if USE_DEFAULT_LANGUAGE_CURRENCY is true, use the following currency, instead of the applications default currency (used when changing language) define('LANGUAGE_CURRENCY', 'GBP'); hope this points you in the right direction cheers barry Link to comment Share on other sites More sharing options...
RhettCan Posted March 19, 2003 Share Posted March 19, 2003 I was aware of this file, and a combination of changing it, making the currency USD as well as the currency CAD and setting the defaults, reapplying oscommerce.sql, it somehow started working. Thanks for your help! Rhett Nye Island Ink-Jet Systems Inc. www.islandinkjet.com "1000 Locations Forecast by 2005" Link to comment Share on other sites More sharing options...
pbaddock Posted March 20, 2003 Author Share Posted March 20, 2003 Ahhh excellent - tks, I'll try that approach. and post the results in a day or so. Link to comment Share on other sites More sharing options...
pbaddock Posted March 20, 2003 Author Share Posted March 20, 2003 just tested it - all works fine...tks heaps barry!! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.