This error could show when uploading spreadsheets for Products, Orders, Courier Prices, etc. If you are receiving this error (Invalid Spreadsheet Format: The conversion cannot be performed) when uploading a CSV file to Mintsoft this is caused by either a Non-Numeric Value in a Numeric Field (A space/ gap could also count as a non-numeric value) or a value missing from a field that is mandatory.
Additionally, if you are experiencing delays in file uploads where data does not display immediately, it could be due to background processing. In such cases, allow the system up to 10–15 minutes to complete the upload.
Common File Upload Issues and Examples
SKU: (Blank) instead of SKU-123.
Quantity: One instead of 1.
Height: 10cm instead of 10.
Active: 'Y' instead of TRUE (for active products) or FALSE (for inactive products).
Error Details and Fixes
Error in Active column
Error: "The conversion cannot be performed. Text: 'Y' MemberName: Active MemberType: System.Nullable`1[[System.Boolean..." Cause: Misuse of 'Y' or 'N' instead of boolean values (TRUE/FALSE).
Fix: Replace 'Y'/'N' with TRUE/FALSE.
Error in Quantity column
Error: "The conversion cannot be performed... MemberName: Quantity." Cause: Non-numeric or missing values in the Quantity field.
Fix: Correct numerical formats and remove invalid rows.
Additionally, ensure to review CSV formatting guidelines, check for hidden formatting issues such as extra spaces or irrelevant characters, and use Mintsoft’s official templates to ensure compliance.
If you have checked this and still seem to be getting the same error, please speak with the Mintsoft support team or raise a support ticket along with the CSV that is causing the issue and where it is being uploaded to.