Resolved Problem with importing products - hikashop

Hello,
That high price is because of margin rule applied on price. I had explained that in my previous reply. For price of 244 margin is calculated as below. Remove the margin rule and you will have price imported as in import file.

15% of 244.77 is 36.7155

Since margin is set to Multiplication 244.77X36.7155 = 8986.8529

Hello,

Ok, now everything works, everything is fine. Thank you very much. Last question, how to round prices after a decimal point? Example, if there is a product with a price of

25.68, it should be rounded to 26.00

if there is a product with a price of

20.31, it should be rounded to 20.50

can you do something like that?

Hello,
We do not have the option of rounding prices in RO CSVI with current version. But I have added three new operations round, floor and ceil to RO CSVI Multireplace rule to process on price values. You can install the attached modified rule plugin from Joomla extension manager to get this new added operations. You can then create RO CSVI Multireplace rule with these multiple operations based on how you want price to round and apply the rule on price field. Try and let me know on how that goes.

FYI - Ceil() takes the number and rounds it to the nearest integer above its current value, whereas floor() rounds it to the nearest integer below its current value. 

The function round() takes two parameters - the number to round, and the number of decimal places to round to. If a number is exactly half way between two integers, round() will always round up.

I installed the add-on. I added a rounding rule, but after installing the add-on, they keep throwing an error after a while (screenshot). A few products were caught, but the rounding wasn't exactly what I was looking for.

Product

Lizak konopny - ENERGY 12g - EUPHORIA

Before the change, the price was 2.56 PLN

and after the change, the price is: 3.69 PLN

I wanted the product to have a price of 3.00 PLN.

Similarly, the second product
Herbatka konopno owocowa "WIŚNIOWY SAD" 45 g

Before import, the price was 23.17 PLN

and after import, it is 23.37 PLN

and I would like it to have a price of 23.50 PLN.

So, if we have a price of up to PLN 0.49, we should round it to PLN 0.50, and if we have an enum of PLN 0.50 to PLN 0.99, we should round it to PLN 1.00.

I'm attaching screenshots and logs.

Hello,

but after installing the add-on, they keep throwing an error after a while (screenshot)

Are you sure 500 error is after installing modified Multireplace rule? If there is issue in rule it will not import any product and you should see error immediately after import starts. Can you also post your import file? I will check the rounding of prices and also see if I can reproduce 500 internal server error.

Hello,

I think so. So far, there have been no errors during import. Since yesterday, I've been getting an error after importing about 150-170 products.

This is a error from today (screenshot)

Import file:
https://cloud.appstore.mamezi.pl/feeds/shop96d6bee72f63481c300948e9db8305b7b5be9048/sklepSativaPrivateApp01-pl_PL.xml

Hello,
We have made a few changes to RO CSVI Multi replace plugin and RO CSVI Margin plugin and they are attached here.

1. Install the attached plugin using Joomla extension manager
2. Edit margin rule Marża 15% and set Decimal separator and Thousand operator as in the attached screenshot(margin.png) and save the rule.
3. Edit RO Multireplace rule Zaokrąglanie and set round operation as in attached screenshot (multireplace.png) and save the rule.
4. Run import and check.

If you have any problem with import post the administrator login details and I will take a look. You can post the details on Site Details tab under your reply.