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?
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?
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.
...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
Webopius.com: ASPDotNetStorefront web development and ecommerce project management
Webopius is now a Sage Pay Approved Partner