API UpdateProductGroup
Z Podpora.nextis.cz
Description
Method allows You to update product group in system.
Exact name
API_UpdateProductGroup
Type
Standard executable stored procedure.
Specification
Parameter | Data type | Value range | Description | Relation |
---|---|---|---|---|
@ID | int | Internal system id | API_GetProductGroups.ID | |
@ProductCode | nvarchar(40) | Product code | ||
@TecDocCode | nvarchar(35) | TecDoc code | ||
@TecDocBrandName | nvarchar(80) | TecDoc brand name | ||
@TecDocBrandID | int | TecDoc brand ID | ||
@GroupName | nvarchar(100) | Group name | ||
@SubGoupName | nvarchar(100) | Sub goup name | ||
@AssortmentName | nvarchar(100) | AssortmentName | ||
@Name | nvarchar(100) | Name | ||
@Name2 | nvarchar(150) | Name2 | ||
@IsNew | bit | Is new:
0 = Off, 1 = On |
||
@PurchasePrice | decimal(19,6) | Purchase price | ||
@RetailPrice | decimal(19,6) | Retail price | ||
@IsArchiving | int | Is archiving | ||
@SupplierID | int | Supplier ID | API_GetCustomers.ID | |
@Prefix | nvarchar(3) | @Prefix | ||
@SupplierProductCode | nvarchar(40) | Supplier product code | ||
@ManufacturerSupplier | nvarchar(50) | Manufacturer supplier | ||
@SupplierItemName | nvarchar(300) | Supplier item name | ||
@BasicPrice | decimal(19,6) | Basic price | ||
@SupplierRetailPrice | decimal(19,6) | Supplier retail price | ||
@SupplierIsArchiving | int | Supplier is archiving | ||
@Description | nvarchar(250) | Description | ||
@EshopDescription | nvarchar(500) | Eshop description | ||
@VATRate | int | ID of VAT rates from VAT rates list (see relation) | API_GetVATRates.ID | |
@MinimumOrderablePieces | decimal(18,2) | Minimum orderable pieces | ||
@UnitID | int | ID of unit from units list (see relation) | API_GetUnits.ID | |
@IsSale | bit | Is sale:
0 = Off, 1 = On |
||
@IsHiddenOnEshop | bit | Is hidden on eshop:
0 = Off, 1 = On |
||
@InfoReturnOfGoods | nvarchar(50) | Info return of goods |
Return
0 : OK 100 : Item could not be updated
Example
DECLARE @return_value int
DECLARE @ID int
DECLARE @ProductCode nvarchar(40)
DECLARE @TecDocCode nvarchar(35)
DECLARE @TecDocBrandName nvarchar(80)
DECLARE @TecDocBrandID int
DECLARE @GroupName nvarchar(100)
DECLARE @SubGoupName nvarchar(100)
DECLARE @AssortmentName nvarchar(100)
DECLARE @Name nvarchar(100)
DECLARE @Name2 nvarchar(150)
DECLARE @IsNew bit
DECLARE @PurchasePrice decimal(19,6)
DECLARE @RetailPrice decimal(19,6)
DECLARE @IsArchiving int
DECLARE @SupplierID int
DECLARE @Prefix nvarchar(3)
DECLARE @SupplierProductCode nvarchar(40)
DECLARE @ManufacturerSupplier nvarchar(50)
DECLARE @SupplierItemName nvarchar(300)
DECLARE @BasicPrice decimal(19,6)
DECLARE @SupplierRetailPrice decimal(19,6)
DECLARE @SupplierIsArchiving int
DECLARE @Description nvarchar(250)
DECLARE @EshopDescription nvarchar(500)
DECLARE @VATRate int
DECLARE @MinimumOrderablePieces decimal(18,2)
DECLARE @UnitID int
DECLARE @IsSale bit
DECLARE @IsHiddenOnEshop bit
DECLARE @InfoReturnOfGoods nvarchar(50)
SELECT @ID = [ID],
@ProductCode = [ProductCode],
@TecDocCode = [TecDocCode],
@TecDocBrandName = [TecDocBrandName],
@TecDocBrandID = [TecDocBrandID],
@GroupName = [GroupName],
@SubGoupName = [SubGoupName],
@AssortmentName = [AssortmentName],
@Name = 'Name 2',
@Name2 = [Name2],
@IsNew = [IsNew],
@PurchasePrice = [PurchasePrice],
@RetailPrice = [RetailPrice],
@Description = [Description],
@EshopDescription = [EshopDescription],
@VATRate = [VATRate],
@MinimumOrderablePieces = [MinimumOrderablePieces],
@UnitID = [UnitID],
@IsArchiving = [IsArchiving],
@IsSale = [IsSale],
@IsHiddenOnEshop = [IsHiddenOnEshop]
FROM [API_GetProductGroups]
WHERE id = 3
SELECT @SupplierID = [SupplierID],
@Prefix = [Prefix],
@SupplierProductCode = [SupplierProductCode],
@ManufacturerSupplier = [ManufacturerSupplier],
@SupplierItemName = [SupplierItemName],
@BasicPrice = [BasicPrice],
@SupplierRetailPrice = [RetailPrice],
@SupplierIsArchiving = [IsArchiving],
@InfoReturnOfGoods = [InfoReturnOfGoods]
FROM [API_GetProducts]
WHERE GroupID = @ID and SupplierID = @SupplierID
EXECUTE @return_value = [API_UpdateProductGroup]
@ID,
@ProductCode,
@TecDocCode,
@TecDocBrandName,
@TecDocBrandID,
@GroupName,
@SubGoupName,
@AssortmentName,
@Name,
@Name2,
@IsNew,
@PurchasePrice,
@RetailPrice,
@IsArchiving,
@SupplierID,
@Prefix,
@SupplierProductCode,
@ManufacturerSupplier,
@SupplierItemName,
@BasicPrice,
@SupplierRetailPrice,
@SupplierIsArchiving,
@Description,
@EshopDescription,
@VATRate,
@MinimumOrderablePieces,
@UnitID,
@IsSale,
@IsHiddenOnEshop,
@InfoReturnOfGoods
Notices
None.