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.

  • Have you tried resetting the property of CSV column.
    – niksmac
    May 16, 2013 at 2:59
  • @NikhilM: I don't know what you mean. Please explain
    – sisko
    May 16, 2013 at 11:46
  • CSV column property or type like text, number etc ?
    – niksmac
    May 16, 2013 at 12:12
  • 1
    @NikhilM: hi, you are right. Removing the decimal place from the price data in the spreadsheet allows the import to take place correctly. PROVIDE AN ACTUAL ANSWER SO I CAN MARK IT CORRECT TO YOUR CREDIT
    – sisko
    May 17, 2013 at 9:27
  • Okay answer added.. :) Good luck
    – niksmac
    May 17, 2013 at 10:32

1 Answer 1


Try Convert Excel Data Types in the corresponding column.

Excel 2010

  1. Click the File tab, Click Excel Options, Click Advanced.
  2. In the Editing Options, verify that the AllowEditing directly in cells check box is selected. Click OK.
  3. Double-click the cell you want to format, and then press ENTER.
  4. 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.