Issue with Purchase Rate Showing as “0” After Importing Items List

Issue with Purchase Rate Showing as “0” After Importing Items List

Dear Zoho Books Support Team,

Good day.

I’m reaching out regarding an issue I’m facing while importing my items list into Zoho Books. Despite mapping all fields correctly and including the purchase price for each product in my Excel file, the Purchase Rate is showing as 0 for all items after import.

  • Import Type: Items list (via .CSV file)

  • Column Headers in My File:

  • Item Name

  • SKU

  • Rate

  • Purchase Rate

  • Description

  • Item Type (value: “Goods” for all products)

  • File Format: CSV (Comma delimited)

  • Character Encoding: UTF-8

  • File Delimiter: Comma

  • Mapping: All fields were correctly mapped to Zoho Books suggested fields

  • Action Taken: I deleted all items from Zoho Books and re-imported the file from scratch, ensuring no duplicate entries and selecting the “Skip duplicates” option.

  • Outcome: The Rate (selling price) imports correctly, but the Purchase Rate shows as 0 for all items.

I’ve verified that the values are numeric, formatted correctly, and that there are no extra spaces or symbols. Despite several attempts, the issue persists.

I would appreciate your help in resolving this issue. 

Looking forward to your support.