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