Import a price with a decimal point | WordPress.org

Resolved Helpful Guy Uk
(@helpful-guy-uk)

10 years, 4 months ago

Hi,

Im trying to import a csv file but the csv price has no decimal points, when I upload it instead of it being £75.00 (seventy five) its £7500 (seven thousand five hundred)

The CSV price section looks like <price>7500</price>

I have no control over the CSV file so I will need to if there is an option on “wp import all” or what the PHP code would be to fix this problem as i see it has the ability to execute php while importing. i.e [str_replace(",", "", {your_price_element[1]})]

Thanks

http://wordpress.org/plugins/wp-all-import/

Viewing 1 replies (of 1 total)

Thread Starter Helpful Guy Uk
(@helpful-guy-uk)

10 years, 4 months ago
I contacted “support@soflyy.com” which was very helpful and this is the answer they gave.

The code below should be added to your functions.php file:
```
function correct_prices($price){
$price_result = number_format($price/100,2);
echo $price_result;
}
```
And put this InsideWP All Import:
[correct_prices({path with your price})]

More Info:
http://www.wpallimport.com/documentation/advanced/execute-php/

Viewing 1 replies (of 1 total)

The topic ‘Import a price with a decimal point’ is closed to new replies.

In: Plugins
1 reply
1 participant
Last reply from: Helpful Guy Uk
Last activity: 10 years, 4 months ago
Status: resolved