1. drees
  2. RO CSVI
  3. Saturday, 02 November 2019
  4.  Subscribe via email
When importing, the product_tax_id field is not changed in the database.
The field in product_tax_id in the database remains empty. You can change the field manually.
The salesPrice gives a, it seems like a random amount. Price 783.00 sales price 1032.6987
If I change the product_tax_id manually, the price is correct.
Accepted Answer Pending Moderation
Hello,
Can you send us your import debug log to check? To get the debug log check How to get debug information? document.
Kind regards,

Tharuna

=========================
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
Good morning,
By experimenting I discovered that if I prise as
price_with_tax is used, the product_tax_id is being changed.
Pricebeforetax does not appear in the import template. I think that's the problem
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
You are missing needed fields for VirtueMart Price import. The minimum needed fields are product_sku and product_price. You do have product_sku but not product_price in your import. Check the document VirtueMart Price import for these needed field. In the log details page after import, did you not get message about missing field?
Kind regards,

Tharuna

=========================
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
I am reasonably aware of what csvi can do. The problem is that I have to read in a number of xml files. The price is a separate xlm. But the trick is. First I read the article file, it contains the VAT id , but no price. In the import file I have added a field with Price with tax and set this at 10.00. All product cost 10,00 euro whit the wrong price Then I read the xlm file with the sku code and product_price. The tax_id remains unchanged and the price changes to the correct one. Thinking around:D :D :D :D :D
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
Can you send us your import debug log to check? To get the debug log check How to get debug information? document.


hello, here the log file
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello,
You are missing needed fields for VirtueMart Price import. The minimum needed fields are product_sku and product_price. You do have product_sku but not product_price in your import. Check the document VirtueMart Price import for these needed field. In the log details page after import, did you not get message about missing field?


Hello, I have both fields in my import files. I send you a small part of the file I use.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,
I am reasonably aware of what csvi can do. The problem is that I have to read in a number of xml files. The price is a separate xlm. But the trick is. First I read the article file, it contains the VAT id , but no price. In the import file I have added a field with Price with tax and set this at 10.00. All product cost 10,00 euro whit the wrong price

That is correct, you cannot process tax field without price_with_tax field in your import. You need product_tax_id or product_tax field with price_with_tax.

Then I read the xlm file with the sku code and product_price. The tax_id remains unchanged and the price changes to the correct one.

Yes, when there is product_price field, price is directly updated without any change to tax field.
Kind regards,

Tharuna

=========================
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
  • Page :
  • 1


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