Steps to reproduce
Precondition: Data of Inventory status of VariationInventoryPricing is not in "0,1,2" (for example 3,100)
1. Go to commerce manager -> catalog management -> Catalog -> CSV import catalog
2. upload the CSVs and mapping files in the attachment
3. Import step by step as order: Categories -> Variation -> Variation Inventory Pricing
4. View Variant 9,10,11
Observed: Display server error bellow:
Expected: Should validate for Inventory status field when run import CSV or convert to valid data.
Server Error in '/' Application.
Unable to cast object of type 'System.DBNull' to type 'System.String'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. |
Stack Trace:
[InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.]
Mediachase.Commerce.Manager.Apps.Catalog.WarehouseInventoryRow.get_InventoryStatus() +101
[StrongTypingException: The value for column 'InventoryStatus' in table 'WarehouseInventory' is DBNull.]
Mediachase.Commerce.Manager.Apps.Catalog.WarehouseInventoryRow.get_InventoryStatus() +199
Mediachase.Commerce.Manager.Apps.Catalog.Tabs.WarehouseInventoryEditTab.BindForm(CatalogEntryModel model) +904
Mediachase.Commerce.Manager.Core.Controls.EditViewControl.LoadContext(IDictionary context) +280
Mediachase.Commerce.Manager.Catalog.CatalogEntryEdit.Page_Load(Object sender, EventArgs e) +384
System.Web.UI.Control.LoadRecursive() +71
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3178
|
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.33440