You are here:  » Decimal at .00


Decimal at .00

Submitted by DVDAFFAIRES on Wed, 2018-12-05 18:48 in

Hi David: o)

I am encountering a problem.
I have reinstalled the latest version (18 / 6A).
When I import all product feeds (or only one), all decimal prices are at xx.00!
Apparently, the decimals do not register, I looked in DB.
Would you have an idea?

Cheers,
Raoul

Submitted by support on Thu, 2018-12-06 07:43

Hello Raoul,

The import process will handle either "." or "," as the decimal separator however what I have come across occasionally is the price in cent units and therefore needs to be divided by 100 before import. There is a Div100 filter in this comment that will do that. After adding the code add a new Div100 filter to the Price field for this feed, re-import and that should do the trick.

If that's not the case, if you could post a couple of example of the price field from this feed by copying from the Sample Data displayed below the form on Feed Registration Step 2 i'll check it out further with you...

Cheers,
David.
--
PriceTapestry.com

Submitted by DVDAFFAIRES on Thu, 2018-12-06 09:32

Hi David,
Thank you for your reply.
I did a test and applied the filter on one of the streams and reimported.
Now all prices are at 00.00 €

A stream line:

{code saved}

Cheers,
Raoul

Submitted by support on Thu, 2018-12-06 10:31

Hello Raoul,

That's strange - all looks fine in the raw data. Could you make a temporary change just to make sure that the reg exp processing is working as normal on your server, if you edit includes/tapestry.php and look for the following code at line 33:

    if (strpos($price,","))

...and REPLACE with:

    return $price;
    if (strpos($price,","))

Then re-import...

Thanks,
David.
--
PriceTapestry.com