Products

The following routes are available for products:

GET /api/v1/product/:itemNr

Url with params /api/v1/product/35651?branchNr=5&user=user&password=password

Get product including events, translations

• body: none
• tables: api_items, api_itemvariants, api_eventitems
• query:
  • user: string
  • password: string
  • itemNr: string
  • branchNr (optional): string
  • recipeTypeNr (optional): string
• response:

Response product:

[
    {
        "ItemNr": "35651",
        "BranchNr": "5",
        "BranchItem_Status": "-1",
        "ItemNumber": "303103",
        "ProductGroupNr": "12",
        "PackageTypeNr": "0",
        "Quantity": "100",
        "UnitNr": "150",
        "AssortmentNr": "1",
        "WebLayoutNr": null,
        "PosLayoutNr": null,
        "Item_PurchaseAmount": "0",
        "Item_SalesAmount": "0",
        "Item_PurchaseQty": "0",
        "Item_SalesQty": "0",
        "Item_Status": "-1",
        "ItemTypeNr": "310",
        "strFDB_Link1": null,
        "strFDB_Link2": null,
        "strFDB_Link3": null,
        "lngFDB_Link4": "0",
        "lngFDB_Link5": "0",
        "Item_Time_stamp": "2023-12-15 16:53:12",
        "GrossWeight": "0",
        "CSFactor": "0",
        "SaleOnPermission": "0",
        "FullStockQty": "0",
        "FullStoreQty": "1000",
        "ActualStockQty": "0",
        "ActualStoreQty": "0",
        "MinStockQty": "0",
        "MinimalStockQty": "-1",
        "BasicPrice": "0",
        "ActualPrice": "0",
        "ItemActive": "-1",
        "ShelfLocation": null,
        "StockLocation": null,
        "SalesAmount": "0",
        "SalesQty": "0",
        "PurchaseAmount": "0",
        "PurchaseQty": "0",
        "Time_Stamp": "2023-12-15 16:53:12",
        "ItemURL": null,
        "ItemSpecsURL": null,
        "ItemPictureURL": null,
        "ItemPictureSmallURL": null,
        "ItemPicturePrintURL": "../userfiles/printpic/f7_a35650_car.jpg",
        "SellingDaysAmount": "0",
        "NOSFlag": "0",
        "ItemOffStockDays": "0",
        "DataLanguageNr": "1",
        "ItemName": "Coupon 30% Rabatt für PKW am Lötschberg und 20% für den Skipass Lauener Alp",
        "ItemAddition1": "5",
        "ItemAddition2": null,
        "ItemAddition3": null,
        "ItemAddition4": null,
        "ItemAddition5": null,
        "TillName": "Coupon 30% Rabatt f",
        "LabelName": "Coupon 30% Rabatt für PKW am Lötschberg und 20% fü",
        "ItemShortDesc": "Fahren Sie mit der XXX auf die PIste und geniessen Sie die Vorteile und sparen erst noch Geld. Das gibt gute Laune.",
        "ItemDesc": null,
        "Matchcode": "Coupon 30% Rabatt f   ",
        "ItemLanguage_LastUpdate": "2023-11-07 18:09:42",
        "VATRateNr": "2",
        "VATRateNr1": "2",
        "Pricelevel_1": "0",
        "Pricelevel_2": "0",
        "Pricelevel_3": "0",
        "isGrossPrice1evel_1": "0",
        "isGrossPrice1evel_2": "0",
        "isGrossPrice1evel_3": "0",
        "Qty_Price1evel_1": null,
        "Qty_Price1evel_2": null,
        "Qty_Price1evel_3": null,
        "GroupCostAmount": "0",
        "GroupCostFactor0": "1",
        "GroupCostFactor1": "1",
        "GroupCostFactor2": "1",
        "GroupCostFactor3": "1",
        "SupplyCostAmount": "0",
        "SupplyCostFactor0": "1",
        "SupplyCostFactor1": "1",
        "SupplyCostFactor2": "1",
        "SupplyCostFactor3": "1",
        "ProductionQuantity": "0",
        "AssignQty": "0",
        "DeliveryQty": "0",
        "StockQty": "0",
        "RequiredQty": "0",
        "StartQty": "0",
        "Reserve": "0",
        "DiscountNr": "3",
        "DiscountValue": "0.3",
        "isStockItem": "-1",
        "MinFillUpQty": "1",
        "MinSalesPrice": "0",
        "isMandatoryPriceInput": "0",
        "isMandatoryPriceControl": "0",
        "isNoQtyPreselection": "0",
        "isNoDoublePosition": "0",
        "isNoReturn": "0",
        "MinSalesQty": "0",
        "MaxSalesQty": "0",
        "isMandatoryWeightInput": "0",
        "isDiscountable": "-1",
        "ShippingTypeNr": "1",
        "DaysOutOfStock": "0",
        "Department": null,
        "AvgPurchasePrice": "0",
        "AvgSalesPrice": "0",
        "LastUpdate": "2024-02-01 10:41:25",
        "events":
        [],
        "eventsDescriptions":
        [],
        "languages":
        [
            {
                "DataLanguageNr": "1",
                "ItemName": "Coupon 30% Rabatt für PKW am Lötschberg und 20% für den Skipass Lauener Alp",
                "ItemAddition1": "5",
                "ItemAddition2": null,
                "ItemAddition3": null,
                "ItemAddition4": null,
                "ItemAddition5": null,
                "TillName": "Coupon 30% Rabatt f",
                "LabelName": "Coupon 30% Rabatt für PKW am Lötschberg und 20% fü",
                "ItemShortDesc": "Fahren Sie mit der XXX auf die PIste und geniessen Sie die Vorteile und sparen erst noch Geld. Das gibt gute Laune.",
                "ItemDesc": null,
                "Matchcode": "Coupon 30% Rabatt f   ",
                "ItemLanguage_LastUpdate": "2023-11-07 18:09:42"
            },
            {
                "DataLanguageNr": "2",
                "ItemName": "Coupon 30% Rabatt für PKW am Lötschberg und 20% für den Skipass Lauener Alp",
                "ItemAddition1": null,
                "ItemAddition2": null,
                "ItemAddition3": null,
                "ItemAddition4": null,
                "ItemAddition5": null,
                "TillName": "Coupon 30% Rabatt f",
                "LabelName": "Coupon 30% Rabatt für PKW am Lötschberg und 20% fü",
                "ItemShortDesc": null,
                "ItemDesc": null,
                "Matchcode": "Coupon 30% Rabatt f   ",
                "ItemLanguage_LastUpdate": "2023-10-18 21:02:18"
            },
            {
                "DataLanguageNr": "3",
                "ItemName": "Coupon 30% Rabatt für PKW am Lötschberg und 20% für den Skipass Lauener Alp",
                "ItemAddition1": null,
                "ItemAddition2": null,
                "ItemAddition3": null,
                "ItemAddition4": null,
                "ItemAddition5": null,
                "TillName": "Coupon 30% Rabatt f",
                "LabelName": "Coupon 30% Rabatt für PKW am Lötschberg und 20% fü",
                "ItemShortDesc": null,
                "ItemDesc": null,
                "Matchcode": "Coupon 30% Rabatt f   ",
                "ItemLanguage_LastUpdate": "2023-10-18 21:02:18"
            },
            {
                "DataLanguageNr": "5",
                "ItemName": "Coupon 30% Rabatt für PKW am Lötschberg und 20% für den Skipass Lauener Alp",
                "ItemAddition1": null,
                "ItemAddition2": null,
                "ItemAddition3": null,
                "ItemAddition4": null,
                "ItemAddition5": null,
                "TillName": "Coupon 30% Rabatt f",
                "LabelName": "Coupon 30% Rabatt für PKW am Lötschberg und 20% fü",
                "ItemShortDesc": null,
                "ItemDesc": null,
                "Matchcode": "Coupon 30% Rabatt f   ",
                "ItemLanguage_LastUpdate": "2023-10-18 21:02:18"
            }
        ],
        "codes":
        []
    }
]

GET /api/v1/products-category

Url with params /api/v1/products-category?user=user&password=password&navigationstypNr=4&recipeTypeNr=2&branchNr=5&limit=LIMIT%201000%20%20OFFSET%200

Get list of all products including events, translations, categories

• body: none
• tables: api_items, api_categoryitems, api_itemvariants, api_eventitems
• query:
  • user: string
  • password: string
  • navigationstypNr (optional): string
  • branchNr (optional): string
  • timestamp (optional): string
  • recipeTypeNr (optional): string
  • limit (optional): string
  • offset (optional): string
• response: list of all products including events, translations, categories

Product:

[
  {
    "ItemNr": "35508",
    "BranchNr": "5",
    "BranchItem_Status": "-1",
    "ItemNumber": "1003",
    "ProductGroupNr": "1",
    "PackageTypeNr": "24",
    "Quantity": "3",
    "UnitNr": "152",
    "AssortmentNr": "2",
    "WebLayoutNr": "0",
    "PosLayoutNr": "0",
    "Item_PurchaseAmount": "0",
    "Item_SalesAmount": "2965.3999996185",
    "Item_PurchaseQty": "0",
    "Item_SalesQty": "108",
    "Item_Status": "-1",
    "ItemTypeNr": "160",
    "strFDB_Link1": null,
    "strFDB_Link2": null,
    "strFDB_Link3": null,
    "lngFDB_Link4": "0",
    "lngFDB_Link5": "0",
    "Item_Time_stamp": "2024-02-14 15:22:41",
    "GrossWeight": "0",
    "CSFactor": "0",
    "SaleOnPermission": "0",
    "FullStockQty": "0",
    "FullStoreQty": "0",
    "ActualStockQty": "0",
    "ActualStoreQty": "-445",
    "MinStockQty": "0",
    "MinimalStockQty": "-1",
    "BasicPrice": "27",
    "ActualPrice": "27",
    "ItemActive": "-1",
    "ShelfLocation": null,
    "StockLocation": null,
    "SalesAmount": "10808.715000000006",
    "SalesQty": "440",
    "PurchaseAmount": "0",
    "PurchaseQty": "0",
    "Time_Stamp": "2024-02-21 14:30:20",
    "ItemURL": null,
    "ItemSpecsURL": null,
    "ItemPictureURL": null,
    "ItemPictureSmallURL": null,
    "ItemPicturePrintURL": null,
    "SellingDaysAmount": "0",
    "NOSFlag": "0",
    "ItemOffStockDays": "0",
    "DataLanguageNr": "1",
    "ItemName": "PW-3.5t KA-GO MO-DO",
    "ItemAddition1": "1:Lötschberg",
    "ItemAddition2": "1:Kandersteg",
    "ItemAddition3": "2:Goppenstein",
    "ItemAddition4": "1:PW-3.5t",
    "ItemAddition5": "2:Niedertarif",
    "TillName": "PW-3.5t",
    "LabelName": "Auto-3.5t MBU",
    "ItemShortDesc": "Kurzbeschreibung MBU",
    "ItemDesc": "Beschreibung MBU",
    "Matchcode": "PW-3.5t",
    "ItemLanguage_LastUpdate": "2024-02-14 15:21:10",
    "VATRateNr": "2",
    "VATRateNr1": "2",
    "Pricelevel_1": "0",
    "Pricelevel_2": "0",
    "Pricelevel_3": "0",
    "isGrossPrice1evel_1": "0",
    "isGrossPrice1evel_2": "0",
    "isGrossPrice1evel_3": "0",
    "Qty_Price1evel_1": null,
    "Qty_Price1evel_2": null,
    "Qty_Price1evel_3": null,
    "GroupCostAmount": "0",
    "GroupCostFactor0": "1",
    "GroupCostFactor1": "1",
    "GroupCostFactor2": "1",
    "GroupCostFactor3": "1",
    "SupplyCostAmount": "0",
    "SupplyCostFactor0": "1",
    "SupplyCostFactor1": "1",
    "SupplyCostFactor2": "1",
    "SupplyCostFactor3": "1",
    "ProductionQuantity": "0",
    "AssignQty": "0",
    "DeliveryQty": "0",
    "StockQty": "0",
    "RequiredQty": "0",
    "StartQty": "0",
    "Reserve": "0",
    "DiscountNr": "0",
    "DiscountValue": "0",
    "isStockItem": "0",
    "MinFillUpQty": "1",
    "MinSalesPrice": "0",
    "isMandatoryPriceInput": "0",
    "isMandatoryPriceControl": "0",
    "isNoQtyPreselection": "0",
    "isNoDoublePosition": "0",
    "isNoReturn": "0",
    "MinSalesQty": "0",
    "MaxSalesQty": "0",
    "isMandatoryWeightInput": "0",
    "isDiscountable": "-1",
    "ShippingTypeNr": "9",
    "DaysOutOfStock": "0",
    "Department": "1",
    "AvgPurchasePrice": "0",
    "AvgSalesPrice": "26.200151991614238",
    "LastUpdate": "2023-10-10 08:51:13",
    "CatNr": "50",
    "NavigationtypeNr": "4",
    "CategoryItem_Status": "1",
    "Displaymode": "1",
    "LastChange": "2023-06-29 13:24:37",
    "SortOrder": "001",
    "CatNumber": null,
    "ItemControlData": null,
    "Style": null,
    "FromDate": null,
    "ToDate": null,
    "IsDeleted": "0",
    "events": [
      {
        "EventItemNr": "5359",
        "EventNr": "51",
        "ItemNr": "35508",
        "EventName": "Vorlage: Sparticket KA-GO",
        "BranchNr": "5",
        "FullStock": "55",
        "CurrentStock": "55",
        "MinStock": "0",
        "Actualprice": "27",
        "FromDate": "2023-10-04 09:00:00",
        "ToDate": "2023-10-04 11:00:00",
        "addressnr": "0",
        "Preptime": "0",
        "Followuptime": "0",
        "Status": "-1",
        "Supplierlist": null,
        "PositionID": "2",
        "eventtype": "7",
        "conditions": "{\"presale_period\":{\"4\":\"1\",\"10\":\"0.95\",\"40\":\"0.8\",\"81\":\"0.75\"},\"presale_rate\":{\"0\":\"0.75\",\"30\":\"0.8\",\"60\":\"0.9\",\"61\":\"0.95\"}}",
        "LastUpdate": "2024-01-16 10:28:28"
      }
    ],
    "eventsDescriptions": [
      {
        "ItemNr": "35643",
        "BranchNr": "5",
        "BranchItem_Status": "-1",
        "ItemNumber": "303098",
        "ProductGroupNr": "11",
        "PackageTypeNr": "0",
        "Quantity": "1",
        "UnitNr": "150",
        "AssortmentNr": "1",
        "WebLayoutNr": "0",
        "PosLayoutNr": "0",
        "Item_PurchaseAmount": "0",
        "Item_SalesAmount": "0",
        "Item_PurchaseQty": "0",
        "Item_SalesQty": "0",
        "Item_Status": "-1",
        "ItemTypeNr": "50",
        "strFDB_Link1": null,
        "strFDB_Link2": null,
        "strFDB_Link3": null,
        "lngFDB_Link4": "0",
        "lngFDB_Link5": "0",
        "Item_Time_stamp": "2024-02-14 09:15:14",
        "GrossWeight": "0",
        "CSFactor": "0",
        "SaleOnPermission": "0",
        "FullStockQty": "0",
        "FullStoreQty": "0",
        "ActualStockQty": "0",
        "ActualStoreQty": "0",
        "MinStockQty": "0",
        "MinimalStockQty": "-1",
        "BasicPrice": "0",
        "ActualPrice": "0",
        "ItemActive": "-1",
        "ShelfLocation": null,
        "StockLocation": null,
        "SalesAmount": "0",
        "SalesQty": "0",
        "PurchaseAmount": "0",
        "PurchaseQty": "0",
        "Time_Stamp": "2024-02-19 16:04:18",
        "ItemURL": null,
        "ItemSpecsURL": null,
        "ItemPictureURL": null,
        "ItemPictureSmallURL": null,
        "ItemPicturePrintURL": null,
        "SellingDaysAmount": "0",
        "NOSFlag": "0",
        "ItemOffStockDays": "0",
        "DataLanguageNr": "1",
        "ItemName": "Sparticket Beschreibung",
        "ItemAddition1": null,
        "ItemAddition2": null,
        "ItemAddition3": null,
        "ItemAddition4": null,
        "ItemAddition5": null,
        "TillName": "Sparticket Beschreibung",
        "LabelName": "Sparticket Beschreibung",
        "ItemShortDesc": "Sparticket Kurzbeschreibung",
        "ItemDesc": "Sparticket Langbeschreibung",
        "Matchcode": "Sparticket Beschreibung",
        "ItemLanguage_LastUpdate": "2024-02-14 09:15:14",
        "VATRateNr": "2",
        "VATRateNr1": "2",
        "Pricelevel_1": "0",
        "Pricelevel_2": "0",
        "Pricelevel_3": "0",
        "isGrossPrice1evel_1": "0",
        "isGrossPrice1evel_2": "0",
        "isGrossPrice1evel_3": "0",
        "Qty_Price1evel_1": null,
        "Qty_Price1evel_2": null,
        "Qty_Price1evel_3": null,
        "GroupCostAmount": "0",
        "GroupCostFactor0": "1",
        "GroupCostFactor1": "1",
        "GroupCostFactor2": "1",
        "GroupCostFactor3": "1",
        "SupplyCostAmount": "0",
        "SupplyCostFactor0": "1",
        "SupplyCostFactor1": "1",
        "SupplyCostFactor2": "1",
        "SupplyCostFactor3": "1",
        "ProductionQuantity": "0",
        "AssignQty": "0",
        "DeliveryQty": "0",
        "StockQty": "0",
        "RequiredQty": "0",
        "StartQty": "0",
        "Reserve": "0",
        "DiscountNr": "0",
        "DiscountValue": "0",
        "isStockItem": "0",
        "MinFillUpQty": "1",
        "MinSalesPrice": "0",
        "isMandatoryPriceInput": "0",
        "isMandatoryPriceControl": "0",
        "isNoQtyPreselection": "0",
        "isNoDoublePosition": "0",
        "isNoReturn": "0",
        "MinSalesQty": "0",
        "MaxSalesQty": "0",
        "isMandatoryWeightInput": "0",
        "isDiscountable": "-1",
        "ShippingTypeNr": "9",
        "DaysOutOfStock": "0",
        "Department": null,
        "AvgPurchasePrice": "0",
        "AvgSalesPrice": "0",
        "LastUpdate": "2024-02-19 16:04:18"
      }
    ],
    "languages": [
      {
        "DataLanguageNr": "1",
        "ItemName": "PW-3.5t KA-GO MO-DO",
        "ItemAddition1": "1:Lötschberg",
        "ItemAddition2": "1:Kandersteg",
        "ItemAddition3": "2:Goppenstein",
        "ItemAddition4": "1:PW-3.5t",
        "ItemAddition5": "2:Niedertarif",
        "TillName": "PW-3.5t",
        "LabelName": "Auto-3.5t MBU",
        "ItemShortDesc": "Kurzbeschreibung MBU",
        "ItemDesc": "Beschreibung MBU",
        "Matchcode": "PW-3.5t",
        "ItemLanguage_LastUpdate": "2024-02-14 15:21:10"
      }
    ],
    "categories": [
      {
        "CatNr": "50",
        "NavigationtypeNr": "4",
        "ItemNr": "35508",
        "BranchNr": "5",
        "CategoryItem_Status": "1",
        "Displaymode": "1",
        "LastChange": "2023-06-29 13:24:37",
        "SortOrder": "001",
        "CatNumber": null,
        "ItemControlData": null,
        "Style": null,
        "FromDate": null,
        "ToDate": null,
        "IsDeleted": "0",
        "LastUpdate": "2023-10-10 08:51:13"
      }
    ],
    "codes": []
  }
]