You need to be logged in to view a user's profile.
  1. rosaliesimple
  2. RO CSVI
  3. Thursday, 14 March 2019
  4.  Subscribe via email
hi

i have update csvi and add-on
i try to update taxes products

i made a test files

and it change nothing...to my product.
without error...i think i need help
Accepted Answer Pending Moderation
Hello,

You are missing the price_with_tax field in your import file. CSVI has no clue now which price it needs to update with the new tax ID. So if you add that field and the prices including tax, the import should update the price and set the correct tax.
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
Accepted Answer Pending Moderation
so i neeed to calculate the price with taxes of my 500 products to set it in the file...
?
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,

You don't have to calculate it yourself, you can run an export first with the product_sku, price_tax_id and price_with_tax field and update the export file with the new data and then import the file. It should run fine then.
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
Accepted Answer Pending Moderation
ok

why when i go modify templates fields...in export i dont have price_with_tax field
i have basepricewithtax field

and, in my import fields...dont have basepricewithtax
but i have price_with_tax ???

also, how i export. or work in excel to have "," between each tab...becose the better i can do is a colomn of "," between each colomn of my excel file and i'm shure there's a better way!
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,

My mistake, on export the field is called salesprice.

and, in my import fields...dont have basepricewithtax
That is becaue VirtueMart has a number of fields available on export that do not exist in the database.

becose the better i can do is a colomn of ","
You can set the delimiters you like to use in your template. On the File tab you can set the field delimiter and text enclosure. So if you set the field delimiter to , (comma) and " (double quote) for text enclosure.

Depending on your country Excel prefers a comma or a semi-colon ( ; ). A rough rule is that in Europe Excel wants a ; and outside of Europe a ,
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
  • Page :
  • 1


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