Product feeds import I have a CSV of data which I am importing as Commerce-Products.

The issue is the price data gets rounded up or down when loading the price field data from the CSV into the price field of commerce-product entities.

For example, one CSV field has a price value of £71.89. I configure the price under manage display with the provided options and I get the following results:


Raw Amount: £72
Formatted Amount: £0.72
Formatted Amount with components: £0.72


So, I need help in importing the price data exactly as it is in the CSV, please.
Try Convert Excel Data Types in the corresponding column. 

Excel 2010


Click the File tab, Click Excel Options, Click Advanced.
In the Editing Options, verify that the AllowEditing directly in cells check box is selected. Click OK.
Double-click the cell you want to format, and then press ENTER.
Click the error button next to the cell, and then click Convert to Number on the shortcut menu


How to convert text to numbers in Excel