Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help with prices please - urgent : (


MarkH

Recommended Posts

tried all that... currently got the latest cvs and getting this error:

 

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/markh/www/nonsecure/install/includes/functions/database.php on line 41

 

    return mysql_query($query, $$link);

Link to comment
Share on other sites

fixed the mysql thing.....

 

Problem still remains and I've tried the value at 1.0 as you said with the latest CVS version.

 

seems to be ok for anything without needing rounding off or the chance of it being rounded like 49.95 in my case. It is making it ?50.00.

 

Can anyone from the Uk or who knows whats wrong please please help?.

 

regards,

MarkH

Link to comment
Share on other sites

Fix it, but is there a way to display tax and subtotal seperately?. Due to UK E-Com laws we have to do this : show the product inclusive of vat + the vat at 17.5% but it needs to be at the check out and when the person views it.

 

Any ideas?

 

regards,

MarkH

Link to comment
Share on other sites

That fixed it ? Excellant.

 

Yes it is possible to do what you are asking about the tax.

You need to specify your tax rate first (in your case 17%)

Do this under Location/Taxes.

Tax Zones

Tax Rates

Tax Classes

 

Under Modules , Order Total , setup how you want your total to appear.

Then, for each product you craete, you need to set it to 'Taxable Good' and enter its price MINUS the tax. There is also a mod where you can have all your prices displayed on the site MINUS the tax , it only appears added to the total on the checkout. You need to edit

includes/application_top.php change DISPLAY_PRICE_WITH_TAX to false

to achieve this.

Hope this solves everthing

martin

Link to comment
Share on other sites

yes and it isnt what I wanted :(

 

I want the cost of the item when you click the in cart button to show the subtotal of the product (without any other charges). So say the product is 49.95 GBP and the tax is about 8 GBP say. I want it to do:

 

Subtotal: ?49.95

 

Tax To Add: ?8.00

 

thats basically it, has to be displayed by law.

Link to comment
Share on other sites

Ok, so you want it in the cart before the Final Checkout >

I am in the same situation, but I have my tax displayed on the final checkout. I think if your display on the site, that prices are EX VAT and then show toe price including VAT on teh final checkout page you will be fine

M

Link to comment
Share on other sites

  • 3 years later...
Hi

Another idea, in the same currencies section,

Whats your decimal places set to ? If its set to 1, then it will round off your prices. Change it to 2 if its not already

martin

 

THANK YOU for this one. phew! Os Commerce should really have this set as default - whoever heard of something being priced as ?20.00? when it's always ?19.99, sadly. the 'customer' is not does not like rounding up!

Link to comment
Share on other sites

  • 9 months later...

I have an issue with the price showing correctly with tax (vat) but when you login the prices change to the non tax price? I have got the contribution that allows different prices per group but they are all set to show prices with tax

 

Hope someone can help!

:unsure:

Link to comment
Share on other sites

  • 7 months later...
Hi

Another idea, in the same currencies section,

Whats your decimal places set to ? If its set to 1, then it will round off your prices. Change it to 2 if its not already

martin

 

Hi,

This fixed the prices rounding off but what do i set the decimal point too as there is none showing so a price that is $770.00 is showing as $77000 or $1622.50 is showing as $162250.

All my prices are in a dropbox using product attributes. I'm using Australian dollar and the value is set to 1.0.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...