Products Importer Error Messages

Owned by Apostolos Karakaxas
Last updated: Nov 15, 2018
3 min read

Below you can find a list of the data validation or data execution error messages.

FieldError Message
Pricing TypeExcelRow1 with product Name 'ProductName'- Pricing Type has not acceptable value ''
Pricing TypeExcelRow1 with product Name 'ProductName'- Pricing Type has not acceptable value 'WrongValue'
Charge RuleExcelRow1 with product Name 'ProductName'- Charge Rule has not acceptable value 'WrongValue'
Billing DateExcelRow1 with product Name 'ProductName'- Billing Date has not acceptable value '40'
Billing DateExcelRow1 with product Name 'ProductName'- Billing Date has not acceptable value '-5'
Billing DateExcelRow1 with product Name 'ProductName'- Billing Date has not acceptable value 'WrongValue'
Is TaxableExcelRow1 with product Name 'ProductName'- You can't cast value 'WrongValue' to a boolean for property 'IsTaxable'!"
Is ActivatedExcelRow1 with product Name 'ProductName'- You can't cast value 'WrongValue' to a boolean for property 'IsActivated'!"
Is AddonExcelRow1 with product Name 'ProductName'- You can't cast value 'WrongValue' to a boolean for property 'IsAddon'!"
Avalara Tax Code From ProductExcelRow1 with product Name 'ProductName'- You can't cast value 'WrongValue' to a boolean for property 'AvalaraTaxCodeFromProduct'!"
Upfront BillingExcelRow1 with product Name 'ProductName'- You can't cast value 'WrongValue' to a boolean for property 'UpfrontBilling'!"
Free periodExcelRow1 with product Name 'ProductName'- You can't cast value 'WrongValue' to a boolean for property 'FreePeriod'!"
TermExcelRow1 with product Name 'ProductName'- You can't cast value 'WrongValue' to an int for property 'Term'!"
Purchase PriceExcelRow1 with product Name 'ProductName'- You can't cast value 'WrongValue' to a decimal for property 'PurchasePrice'!"
Sales PriceExcelRow1 with product Name 'ProductName'- You can't cast value 'WrongValue' to a decimal for property 'SalesPrice'!"
Purchase PriceExcelRow1 with product Name 'ProductName'- Purchase Price 'NegativeValue' cannot be less than 0"
Sales PriceExcelRow1 with product Name 'ProductName'- Sales Price 'NegativeValue' cannot be less than 0"
Unit (used in prices)ExcelRow1 with product Name 'ProductName'- Unit NOT found for price with Unit Name WrongUnitName, isDefault : false , isSetup false
Unit (used in prices)ExcelRow1 with product Name 'ProductName'- No unique unit found for price with Unit Name WrongUnitName, isDefault : false , isSetup false
Product AttributeExcelRow1 with product Name 'ProductName'- Product attributes mismatch with value: WrongGuid"
Product AttributeExcelRow1 with product Name 'ProductName'- Value 'WrongValue' is not a acceptable value for product characteristic field: MultiValueFromList"
Product AttributeExcelRow1 with product Name 'ProductName'- Value 'WrongValue' is not a acceptable value for product characteristic field: SingleValueFromList"
Product AttributeExcelRow1 with product Name 'ProductName'- Value '' is not a acceptable value for product characteristic field: CompulsoryField"
Custom FieldExcelRow1 with product Name 'ProductName'- Custom field with Id: 'WrongGuid' has not been found""
Custom FieldExcelRow1 with product Name 'ProductName'- Value 'WrongValue' is not a acceptable value for custom field: MultiValueFromList"
Custom FieldExcelRow1 with product Name 'ProductName'- Value 'WrongValue' is not a acceptable value for custom field: SingleValueFromList"
Custom FieldExcelRow1 with product Name 'ProductName'- Value '' is not a acceptable value for custom field: SingleValueFromList"
Product TypeproductType NOT found for productTypeId WrongGuid
Product TypeExcelRow1 with product Name 'ProductName'- Product type NOT found for WrongName
Product TypeExcelRow1 with product Name 'ProductName'- No unique product type found for WrongName
UnitTypeExcelRow1 with product Name 'ProductName'- Unit type NOT found for WrongName
UnitTypeExcelRow1 with product Name 'ProductName'- No unique unit type found for WrongName
Price GroupExcelRow1 with product Name 'ProductName'- Price group NOT found for WrongName
Price GroupExcelRow1 with product Name 'ProductName'- No unique price group found for WrongName
ProductCategoryExcelRow1 with product Name 'ProductName'- Product category NOT found for WrongName
ProductCategoryExcelRow1 with product Name 'ProductName'- No unique product category found for WrongName
Volume DiscountExcelRow1 with product Name 'ProductName'- Discount NOT found for WrongName
Volume DiscountExcelRow1 with product Name 'ProductName'- No unique volume discount found for WrongName
IndustryExcelRow1 with product Name 'ProductName'- Industry NOT found for WrongName
IndustryExcelRow1 with product Name 'ProductName'- No unique industry found for WrongName
Unit GroupExcelRow1 with product Name 'ProductName'- Unit group NOT found for group name: WrongName  for pricing type OT