1. wirt2web
  2. RO CSVI
  3. Tuesday, 02 November 2021
  4.  Subscribe via email
Hallo!

I have four user groups in my hikashop (Guest, LST, GH1 and GH2). I have an csv file with prices:

product_code;price_with_tax;price_min_quantity;price_access
010002000000;15,58;1;Guest
010002000000;15,58;1;LST
010002000000;12,46;60;Guest
010002000000;12,46;60;LST

my tax is 20%

but the prices after import always 0,00

How can i import prices, i need price with tax for Guest and LST and price without tax for GH1 and GH2?
Attachments (1)
Accepted Answer Pending Moderation
Hello,
As much as i know in HikaShop, a product can have only one tax rate and that does not apply on prices. Can you tell us how you would apply tax on multiple prices in HikaShop manually? Please clarify on this so we can help you with RO CSVI import.

To import multiple prices without tax you should be using HikaShop Price import template. For price_access field you need to add multiple user groups separated by | like Guest|LST instead of having them as each row. You can check the examples in the linked 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
I have a database with prices for B2C (price with tax) and B2B (price without tax). if a caculate the price with tax to price without tax(divide with 1.2, 20% tax) it goes wrong for the last decimal. For example: my price is 9,99%1,2 = 8,325 -> the hikashop set it to 8,33 and show price 10,00 (8,33x1,2=9,996)

So, Can I use price_with_tax to import?
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
I have a database with prices for B2C (price with tax) and B2B (price without tax).

How do you have these price with tax and price without tax in database? I do not see such option in HikaShop core tables. Do you use any 3rd party extension for prices? Can you please share a screenshot on how these prices are saved in database?
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
No, In the database it should be only prices without tax. But I need to import a price_with_tax because if I manually calculate the price without tax it goes wrong (example before).

If I have a price in hikashop I can set the price_with_tax, see screenshot
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
Thank you for the screenshot. Have you tried to save the price_with_tax value manually? Did it work?

HikaShop price table does not have a field to save price_with_tax value. From what i see, Price with tax is calculated by HikaShop automatically. Since there is no field in HikaShop table, it is not possible to import price_with_tax using RO CSVI.
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. # 5
Accepted Answer Pending Moderation
Yes, It works...
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,
That is really strange. When i try to save a value in Price with tax field manually(see screenshot), it does not save the value i put in the field and shows me Price value. Also, i don't see any field in database which save Price with tax field.
Attachments (1)
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
Accepted Answer Pending Moderation
Thank you, i will contact hikashop support. but standard hikashop import doesnt provide to import price_with_tax
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello,
Please let us know on what you find from HikaShop support. We are curious to know on how the Price with tax field works.
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. # 9
Accepted Answer Pending Moderation
HikaShop Support said:

In the CSV file you use for your import, you can either have a column with the title price_value or one with the title price_value_with_tax
So yes, you can import prices with taxes.
Please note however that there are two things to know first:
- HikaShop only stores the price without taxes, unless you have the "floating tax prices" setting activated, in which case it will store the price with tax and calculate the price without taxes dynamically by using your tax rules in the other way.
- to be able to import prices with taxes, you also need to have the product_tax_id column in your CSV in order to specify the tax category id you want for each product.
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello,

Thank you for your update. The field price_value_with_tax is not something RO CSVI uses but we use price_with_tax, perhaps they mean that. In case you are importing prices with tax you need to use the field product_tax with the actual tax rate that is included in the price and RO CSVI will calculate the price without tax for you.

The option floating tax prices is something I never noticed. Are you using this option?

Now to get back to your original question, to import prices with and without taxes in the same file is currently not possible. You are going to need 2 files, one with and one without taxes.

product_code;price_with_tax;price_min_quantity;price_access;product_tax
010002000000;15.58;1;Guest;20
010002000000;15.58;1;LST;20

product_code;product_price;price_min_quantity;price_access
010002000000;12.46;60;GH1
010002000000;12.46;60;GH2
Notice also I changed the comma to a dot in the price, that is why you are getting a 0 price as the computer can only calculate prices with a dot as decimal sign.

There is one issue I did find and I need to look at, if you import the same price multiple times, it will show up multiple times in HikaShop. That is because we check with 12 decimals but only 5 decimals are stored, so the result we get back is that no price exists, so we add it again.

Let me know if that helps. I will get back to you for updating the prices.
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. # 11
Accepted Answer Pending Moderation
Hello,

So I said I would get back to you on the price update. Attached is a patch file, you can load the patch file as explained in the How to load a patch file document.

This also makes it possible to import your data in 1 file like this:

product_code;price_with_tax;product_price;price_min_quantity;price_access;product_tax
010002000000;15.58;;1;Guest;20
010002000000;15.58;;1;LST;20
010002000000;;12.46;60;GH1;
010002000000;;12.46;60;GH2;
Let me know how it goes.
Attachments (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. # 12
  • Page :
  • 1


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