Update Insert nopCommerce Manufacturer Stored Procedure

Since installing nopCommerce on Azure is now a viable option updating and inserting Manufacturer data can be pushed directly via SQL (easy to maintain and fast).  I hope this saves you some typing.  Below is sql procedure...

-- ==========================================================
-- Create Stored Procedure Template for SQL Azure Database
-- ==========================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE updateManufacturer
(
@Name nvarchar(400)
, @Description nvarchar(max)
, @ManufacturerTemplateId int
, @MetaKeywords nvarchar(400)
, @MetaDescription nvarchar(max)
, @MetaTitle nvarchar(400)
, @PictureId int
, @PageSize int
, @AllowCustomersToSelectPageSize bit
, @PageSizeOptions nvarchar(200)
, @PriceRanges nvarchar(400)
, @SubjectToAcl bit
, @LimitedToStores bit
, @Published bit
, @Deleted bit
, @DisplayOrder int
)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

IF EXISTS (SELECT * FROM Manufacturer WHERE LTrim(Rtrim(Name))=Ltrim(Rtrim(@Name)))
    UPDATE Manufacturer
SET
Name = @Name
, [Description] = @Description
, ManufacturerTemplateId = @ManufacturerTemplateId
, MetaKeywords = @MetaKeywords
, MetaDescription = @MetaDescription
, MetaTitle = @MetaTitle
, PictureId = @PictureId
, PageSize = @PageSize
, AllowCustomersToSelectPageSize = @AllowCustomersToSelectPageSize
, PageSizeOptions = @PageSizeOptions
, PriceRanges = @PriceRanges
, SubjectToAcl = @SubjectToAcl
, LimitedToStores = @LimitedToStores
, Published = @Published
, Deleted = @Deleted
, DisplayOrder = @DisplayOrder
, UpdatedOnUtc = getdate()
WHERE Ltrim(Rtrim(Name)) = Ltrim(Rtrim(@Name))
ELSE
    INSERT INTO Manufacturer
(Name
, [Description]
, ManufacturerTemplateId
, MetaKeywords
, MetaDescription
, MetaTitle
, PictureId
, PageSize
, AllowCustomersToSelectPageSize
, PageSizeOptions
, PriceRanges
, SubjectToAcl
, LimitedToStores
, Published
, Deleted
, DisplayOrder
, CreatedOnUtc
, UpdatedOnUtc)
VALUES
(Ltrim(Rtrim(@Name))
, Ltrim(Rtrim(@Description))
, @ManufacturerTemplateId
, Ltrim(Rtrim(@MetaKeywords))
, Ltrim(Rtrim(@MetaDescription))
, Ltrim(Rtrim(@MetaTitle))
, @PictureId
, @PageSize
, @AllowCustomersToSelectPageSize
, @PageSizeOptions
, @PriceRanges
, @SubjectToAcl
, @LimitedToStores
, @Published
, @Deleted
, @DisplayOrder
, getdate()
, getdate())
END
GO