You are here:  » import error

Support Forum



import error

Submitted by Langdon on Tue, 2009-07-28 00:43 in

Hi David,

I'm importing a Commission Junction feed from Buy.com with the format of "csv|124|1|0" All appears to go well with no actual error generated. The problem I have discovered is prices over $999.00 import improperly. It seems to think the comma is a decimal place. For example if the price in the feed is 1,484.99 it imports as 1.48 and displays as $1.48.

I have no troubles with Google's Affiliate Network. Their feeds are the format of "csv|9|1|0" and don't contain commas.

I have made some mods to my site but don't think it is caused by something I did.

Thanks for your help!

Lang

Submitted by support on Tue, 2009-07-28 08:51

Hello Lang,

It's like that to handle certain methods of representing currency where a comma is used in place of a decimal point.

Easily fixed - in includes/tapestry.php look for the following code on line 42:

    $price = str_replace(",",".",$price);

...and REPLACE that with:

    $price = str_replace(",","",$price);

Cheers,
David.