Guest Posted October 9, 2005 Share Posted October 9, 2005 Hi there, i have strange thing in OSCommerce. I added a product, with a price. My Tax is 15% and I only have this taxable Goods Tax, nothing more. When I go to preview, all prices are shown correctly, but when you go to the shop the price is to high. What can this be, I am looking since a couple of days to find the solution but I really don't have a clou what this could be. Thanks for all answer MSNetworks Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted October 9, 2005 Share Posted October 9, 2005 Hi there,i have strange thing in OSCommerce. I added a product, with a price. My Tax is 15% and I only have this taxable Goods Tax, nothing more. When I go to preview, all prices are shown correctly, but when you go to the shop the price is to high. What can this be, I am looking since a couple of days to find the solution but I really don't have a clou what this could be. Thanks for all answer MSNetworks maybe set something wrong in the tax section of osc? check if you have double entries, and if not check your database for double entries ... seen that before, not in admin but hidden in the database! :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
kirchenbauer Posted October 9, 2005 Share Posted October 9, 2005 Can you give an example, like what the price should be on your website and what the price is on your website? Do you have your site set up to show prices with tax or with just the price of the product? Link to comment Share on other sites More sharing options...
Guest Posted October 10, 2005 Share Posted October 10, 2005 Can you give an example, like what the price should be onyour website and what the price is on your website? Do you have your site set up to show prices with tax or with just the price of the product? Hello, thanks for the fast answer. The example is, I have a Product for 49,00? with tax (15% in Luxembourg) it should be 56,35? this is all correct in the preview of the admin area, but in the shop it shows 59.35? I setup to show the price with tax. Best regards MSNetworks maybe set something wrong in the tax section of osc? check if you have double entries, and if not check your database for double entries ... seen that before, not in admin but hidden in the database! Hello, thanks for the fast reply, i really appreciate. Where can I find the double entry's in the DB? I will check this. I cannot see any double entries in the OSC. Best regards MSNetworks Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted October 10, 2005 Share Posted October 10, 2005 Hello, thanks for the fast answer. The example is, I have a Product for 49,00? with tax (15% in Luxembourg) it should be 56,35? this is all correct in the preview of the admin area, but in the shop it shows 59.35? I setup to show the price with tax. Best regards MSNetworks Hello, thanks for the fast reply, i really appreciate. Where can I find the double entry's in the DB? I will check this. I cannot see any double entries in the OSC. Best regards MSNetworks in the database, you have the tables tax rates and tax class ... post the export of them here if they look strange. also, check in admin the tax class and tax rates again and post those tables in here too :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
Guest Posted October 10, 2005 Share Posted October 10, 2005 in the database, you have the tables tax rates and tax class ... post the export of them here if they look strange. also, check in admin the tax class and tax rates again and post those tables in here too I cannot find anything unusual, her are the tables: Tax class: Datens?tze, beginnend ab untereinander horizontal (gedrehte Bezeichner) nebeneinander angeordnet und wiederhole die Kopfzeilen nach Datens?tzen. tax_class_id tax_class_title tax_class_description last_modified date_added 1 Taxable Goods The following types of products are included non-f... 2005-10-08 20:39:00 2005-09-09 13:47:56 Alle ausw?hlen / Auswahl entfernen markierte: Tax Rates: tax_rates_id tax_zone_id tax_class_id tax_priority tax_rate tax_description last_modified date_added 1 1 1 1 15.0000 Lux TAX 15.0% 2005-10-09 21:32:47 2005-09-09 13:47:56 Alle ausw?hlen / Auswahl entfernen markierte: I also rechecked the settings in OSC admin, but I cannot see anything wrong in fact in the preview in the admin area evrything is correct. You can check the page at http://www.schammel.com/osCommerce. I am still working on the design. Thank you again for your help Best regards MSNetworks Link to comment Share on other sites More sharing options...
kirchenbauer Posted October 10, 2005 Share Posted October 10, 2005 From what you posted, it seems like your tax class that is set up in "Tax Classes" does not match what you have in the "Tax Rates". But, I might be having trouble because of the two different languages. Here is what my settings look like. I am in Ohio in the USA. Link to comment Share on other sites More sharing options...
Guest Posted October 10, 2005 Share Posted October 10, 2005 From what you posted, it seems like your tax class that isset up in "Tax Classes" does not match what you have in the "Tax Rates". But, I might be having trouble because of the two different languages. Here is what my settings look like. I am in Ohio in the USA. Hello, thank you for your reply, unfortunately those settings are like I configured my OSC, just with luxembourg Taxes. I deleted all other Taxzones to avoid, errors. Best regards MSNetworks Link to comment Share on other sites More sharing options...
241 Posted October 10, 2005 Share Posted October 10, 2005 You are saying preview in admin, this would be in the catalog section of admin where you are adding the product. The difference that you see may be due to shipping weight caused by the package tare weight being set to 3 in admin for shipping and packaging Package Tare weight. 3 Larger packages - percentage increase. 10 No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
kirchenbauer Posted October 10, 2005 Share Posted October 10, 2005 Oh, I think you are exactly right. That makes sense. I didn't think of that. In the USA, we don't have tax on the weight/tare. Link to comment Share on other sites More sharing options...
Guest Posted October 11, 2005 Share Posted October 11, 2005 You are saying preview in admin, this would be in the catalog section of admin where you are adding the product. The difference that you see may be due to shipping weight caused by the package tare weight being set to 3 in admin for shipping and packaging Package Tare weight. 3 Larger packages - percentage increase. 10 Hi, thanls for your help, it helped. After changing those settings, the Price in the catalog section of the admin was also wrong. It indicates now the same price as displayed in the shop section. This showed me that the problem shall be elsewhere. I checked the Currency value in the admin area. And I remembered that I changed the value to the actual US Dollar / ? rate. Which, I think, was an error. Do you know the original OSC currency value? Thanks to all for the fantastic help. Best regards MSNetworks Link to comment Share on other sites More sharing options...
kirchenbauer Posted October 11, 2005 Share Posted October 11, 2005 Link to comment Share on other sites More sharing options...
Guest Posted October 11, 2005 Share Posted October 11, 2005 Thank you very much, that was the problem, now the price is correct, there is only a problem with the tax, but I think I know whats wrong. MSnetworks Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.