Categories
View Replies (4)

Resolved VM3 Prices export/import - VAT/Tax issues

  1. sandstorm871
    sandstorm871
  2. RO CSVI
  3. Thursday, 04 February 2016
  4.  Subscribe via email
I am trying to set up what I thought was going to be an easy/simple CSvi template for exporting/importing new prices.
I want to export Sku,product_price , alter any prices and then reimport to change all the prices in the store.
But the export is pulling prices pre-tax & we have set up all the products manually in Virtuemart to use UK 20% VAT Tax.

In its simplest form (hopefully)
Can I use VM Product Export, to export product sku, product name, product price, where the price exported will include the tax/vat?
So that I can change any prices & re-import, where the prices being imported will already include tax

TIA
Andy
0
Responses (4)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Andy,

Can I use VM Product Export, to export product sku, product name, product price, where the price exported will include the tax/vat?
Yes, you need to use the salesprice field. Be aware of the shopper groups if you use them, you may need to set this as well in the template.

So that I can change any prices & re-import, where the prices being imported will already include tax
To import you will need to use the field price_with_tax and you must also include the product_tax field with a value of 20. This way CSVI can calculated the price excluding tax.

Prices are always stored without any taxes and/or discounts.
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
sandstorm871
sandstorm871
Accepted Answer Pending Moderation
Thanks for fast response, I'll go away & test this. :woohoo:
  1. more than a month ago
  2. RO CSVI
  3. # 2
sandstorm871
sandstorm871
Accepted Answer Pending Moderation
you must also include the product_tax field with a value of 20. This way CSVI can calculated the price excluding tax.


Quick Question - see screenshot
When I tested this I see there is a new tax rule added by CSVi, but we already had one set up.
How can we use the one already set up in the import?

ScreenShot2016-02-05at10.07.34.png

Edit - ALSO, We just noticed that all the products in the store now have VAT/Tax added twice & this seems to be because of the 2 tax rules here. :blink:

Thanks
Andy
Attachments (1)
ScreenShot2016-02-05at10.07.34.png ScreenShot2016-02-05at10.07.34.png
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
Hey Andy,

You need to include the calc_kind field with the value VatTax. As you can see CSVI defaults to Tax instead of VatTax. There are too many tax options in VM :)

As for the prices, you can empty the prices via the maintenance menu and then do a new clean import.
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. # 4
  • Page :
  • 1


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