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 3 of 3

Thread: Product.IsImport

  1. #1
    bcaroli is offline Junior Member
    Join Date
    Jun 2012
    Posts
    1

    Post Product.IsImport

    Can I use the column IsImport from table Product to identify the products that I inputed by command insert in sqlserver, or this column is used for other things in the system? And what is the purpose of the column IsSystem?

  2. #2
    AspDotNetStorefront Staff - Scott's Avatar
    AspDotNetStorefront Staff - Scott is offline Administrator
    Join Date
    Mar 2007
    Location
    Ashland, OR
    Posts
    2,390

    Default

    IsImport is only used by WSI as far as I remember, to identify new rows to roll back if you do imports inside a <transaction> tag. If you're not using WSI it should be safe enough to use that field.

    IsSystem is used for special products - Micropay, Gift Cards, etc.

  3. #3
    webopius is offline Senior Member
    Join Date
    Nov 2008
    Location
    London, UK
    Posts
    440

    Default

    ...and it's also used by the Excel product importer isn't it? (within import.cs) which sets IsImport to 1 on import, then either...

    - Set IsImport to 0 for all products if the user clicks 'accept import'
    - Or, uses the IsImport flag to find which products to roll back if the user cancels the import

    Adam