Categories
View Replies (15)

Resolved [SOLVED] pricing and vat

  1. levelcom
    levelcom
  2. RO CSVI
  3. Wednesday, 18 March 2015
  4.  Subscribe via email
Hi my installation is:
Joomla 3.3.6
VirtueMart 3.0.4
PHP 5.6.3
MySQL 5.6.21
Magic Quotes Off.

I recently find out that some (not few) of my products were missing the rule that calculates VAT rate and it is applied at every product.
I thought that I can make a csv import with only product_sku and product_tax_id to 0 therefore I'll force every product to get the default VAT rate. Unfortunately that didn't work even after Maintenance > Virtuemart > Remove product prices.
In every case product_tax_id remains empty.
I ended with no price and no VAT setting in all of my products.
Any ideas?

Dennis
0
Responses (15)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Dennis,

You are using the product import for a price update, this will require you to add more fields than just product_tax_id. You should at minimum include the product_price field.

I ended with no price and no VAT setting in all of my products.
That is because you chose to remove the product prices from the maintenance menu.

Since you have no prices, you would need to import product_sku, product_price, product_tax to get your prices. This should also set the correct taxation rule as it is based on the product_tax field.
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
levelcom
levelcom
Accepted Answer Pending Moderation
Hi ronaldd
And this brings us (as always) to a different problem, product_tax does not exist in the field list of my installation nether for import or export. Furthermore Maintenance > Update fields didn't help ether.

Any clues?
-*Dennis
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Dennis,

If you don't see the product_tax field and it won't appear after the Update available fields, there is indeed another problem. Do you have for example the field price_with_tax? In case you don't have that file either, there is a problem reading the custom available fields.
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
levelcom
levelcom
Accepted Answer Pending Moderation
Ok this is the list of TAX related fields I can see.
basepricewithtax
discauntedprisewithouttax
pricebeforetax
pricewithouttax
product_tax_id

-*Dennis
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hey Dennis,

Ok that is not near enough fields. When you run the Update available fields, what is listed on the results page?
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. # 5
levelcom
levelcom
Accepted Answer Pending Moderation
Please find attached the output.
-*Dennis
Attachments (1)
Update_Output.txt
  1. more than a month ago
  2. RO CSVI
  3. # 6
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Dennis,

This is what I was looking for: Custom available fields for VirtueMart have been added

So the available fields should have been loaded. Are you using CSVI 5.21.1?
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. # 7
levelcom
levelcom
Accepted Answer Pending Moderation
At about I have:
Name: CSVI Pro
Version: 5.20
and the "You have the latest version" is green.
-*Dennis
  1. more than a month ago
  2. RO CSVI
  3. # 8
levelcom
levelcom
Accepted Answer Pending Moderation
Hi RonalD
I have just updated to ver 5.21.1 and update available fields.
The product_tax field is again no were to find.
Further more I have loaded a csv with product_sku,product_price,product_tax_id.
No luck yet, product_tax_id remains un-updated.
Regards , Dennis
  1. more than a month ago
  2. RO CSVI
  3. # 9
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Dennis,

In the folder administrator\components\com_csvi\install\availablefields\ you have the file com_virtuemart.sql. Can you copy the content of this file into the SQL tab of PhpMyadmin in your database, replace all the #_ with your own prefix and then execute the query. Does this complete? If so, you should see the price_with_tax fields etc. in your available fields list.
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. # 10
levelcom
levelcom
Accepted Answer Pending Moderation
Done without errors.
Now the tax related fields I see are:
basepricewithtax
discauntedprisewithouttax
pricebeforetax
pricewithouttax
product_tax_id
taxamount
The only difference I can see is "taxamount" that didn't exist before the above action.
Is this the correct state?
-*Dennis
  1. more than a month ago
  2. RO CSVI
  3. # 11
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Dennis,

This is not the correct state, you should see the price_with tax field for example. Something is off in your system. Can you private message me the URL and login details?
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. # 12
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Dennis,

Actually, the fields are there but we are talking about two different things. You were looking at the Prices import list and I was looking at the Product import list :)

That is because the debug log you posted in your first post is from a product import. Are you going to import the prices with the product import or the price import? If it is the latter, you will need to use product_sku, product_price (price excluding tax), product_tax_id (The existing ID of a taxation rule).
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. # 13
levelcom
levelcom
Accepted Answer Pending Moderation
Hi RonaldD
Sorry for wasting your time.
It was a moment of panic, realizing that I have a priceless site in the middle of a campaign...
Anyway I have included product_price_id as 0 in my update procedure and this results to have default tax rule applied to every product, updated or not.
I guess this resolves my issues.
Thank you again for your support.
  1. more than a month ago
  2. RO CSVI
  3. # 14
rolandd
rolandd
Accepted Answer Pending Moderation
Glad to hear all is resolved :)
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. # 15
  • Page :
  • 1


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