If you get the following error "The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Nop_ProductVariant_Nop_LowStockActivity"..." while inserting new product, then execute the following statement over your database:


ALTER PROCEDURE [dbo].[Nop_ProductVariantInsert]
(
    @ProductVariantID int = NULL output,
    @ProductId int,
    @Name nvarchar(400),
    @SKU nvarchar (400),
    @Description nvarchar(4000),
    @AdminComment nvarchar(4000),
    @ManufacturerPartNumber nvarchar(100),
    @IsDownload bit,
    @DownloadID int,
    @IsShipEnabled bit,
    @IsFreeShipping bit,
    @IsTaxExempt bit,
    @TaxCategoryID int,
    @StockQuantity int,
    @MinStockQuantity int,
    @LowStockActivityID int,
    @WarehouseId int,
    @DisableBuyButton int,
    @RequiresTextOption bit,
    @TextOptionPrompt nvarchar(400),
    @Price money,
    @OldPrice money,
    @Weight float,
    @Length decimal(18, 4),
    @Width decimal(18, 4),
    @Height decimal(18, 4),
    @PictureID int,
    @Published bit,
    @Deleted bit,
    @DisplayOrder int,
    @CreatedOn datetime,
    @UpdatedOn datetime
)
AS
BEGIN
    INSERT
    INTO [Nop_ProductVariant]
    (
        ProductId,
        [Name],
        SKU,
        [Description],
        AdminComment,
        ManufacturerPartNumber,
        IsDownload,
        DownloadID,
        IsShipEnabled,
        IsFreeShipping,
        IsTaxExempt,
        TaxCategoryID,
        StockQuantity,
        MinStockQuantity,
        LowStockActivityID,
        WarehouseId,
        DisableBuyButton,
        RequiresTextOption,
        TextOptionPrompt,
        Price,
        OldPrice,
        Weight,
        [Length],
        Width,
        Height,
        PictureID,
        Published,
        Deleted,
        DisplayOrder,
        CreatedOn,
        UpdatedOn
    )
    VALUES
    (
        @ProductId,
        @Name,
        @SKU,
        @Description,
        @AdminComment,
        @ManufacturerPartNumber,
        @IsDownload,
        @DownloadID,
        @IsShipEnabled,
        @IsFreeShipping,
        @IsTaxExempt,
        @TaxCategoryID,
        @StockQuantity,
        @MinStockQuantity,
        @LowStockActivityID,
        @WarehouseId,
        @DisableBuyButton,
        @RequiresTextOption,
        @TextOptionPrompt,
        @Price,
        @OldPrice,
        @Weight,
        @Length,
        @Width,
        @Height,
        @PictureID,
        @Published,
        @Deleted,
        @DisplayOrder,
        @CreatedOn,
        @UpdatedOn
    )

    set @ProductVariantID=@@identity
END