Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: Import Error

  1. 03-09-2010, 02:37 PM #1
    Geoff66 is offline Junior Member
    Join Date
    Feb 2010
    Posts
    10

    Default Import Error

    Using excel import and getting this error.
    Cannot insert the value NULL into column 'TaxClassID', table 'marinemanifold_com.dbo.Product'; column does not allow nulls. INSERT fails
    I have a 1 as the value in the istaxable column on import spreadsheet. I assume that is the column it is referring to.
    Any Hints?
  2. 03-09-2010, 04:13 PM #2
    Mike The Last Boyscout is offline User
    Join Date
    Nov 2008
    Posts
    254

    Default

    The TaxClassID is what defines what type of tax class each product belongs to (goods, alcohol, tobacco, etc.) This field is not included as part of the Excel Import process and should default to a value other than NULL. I'd recommend you submit a support ticket so our team can look into this a bit more.