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.
- drees
- RO CSVI
- Saturday, 02 November 2019
- Subscribe via email
0
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?
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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





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)
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)
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.
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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)
Accepted Answer
Pending Moderation
Hello,
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.
Yes, when there is product_price field, price is directly updated without any change to tax field.
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »