Categories
You need to be logged in to view a user's profile.
View Replies (4)

Resolved VM3 price with tax

  1. peterva
    peterva
  2. RO CSVI
  3. Saturday, 21 February 2015
  4.  Subscribe via email
Joomla 3.3.6
VM 3.0.6
CSVI 5.20

Hi, I want to export VM prices with 21% tax included. I tried 2 methods but cannot get them to work:

1. selecting the basepricewithtax field gives an SQL error
2. cannot find a working replacement expression (e.g. str_ireplace(',', '.', '\1')*1.21 gives a wrong output)

Any ideas of what to try next?
0
Responses (4)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

The price including tax is the salesprice field. As for the SQL error it is because VirtueMart made a change that affected the retrieval of prices. You can find the same question here with the patch as well. Apply the patch and you should be good to go.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
peterva
peterva
Accepted Answer Pending Moderation
Wonderful! It worked.

Except I am not getting the right decimals.

My settings are: decimals 2, thousands separator . and decimals separator ,

The output is 35 for a rounded number and 42,5 for a number with decimals.
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

I don't think this is a CSVI problem but a spreadsheet problem. Spreadsheets remove the trailing zeroes. If you look at your file with a plain text editor you will see the zeroes. Can you check that?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
peterva
peterva
Accepted Answer Pending Moderation
You're absolutely right. I was checking the output in Excel (which has its own default number format), but in a text editor I can see two decimals. So ... problem solved, thanks!
  1. more than a month ago
  2. RO CSVI
  3. # 4
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!