Socket
Socket
Sign inDemoInstall

@progress/kendo-schematics

Package Overview
Dependencies
Maintainers
1
Versions
43
Alerts
File Explorer

Advanced tools

Socket logo

Install Socket

Detect and block malicious and high-risk dependencies

Install

@progress/kendo-schematics - npm Package Compare versions

Comparing version 3.1.0 to 3.2.0-dev.202209131446

src/collection/charts/categorical/files/data.d.ts

2

package.json

@@ -6,3 +6,3 @@ {

"license": "SEE LICENSE in LICENSE.md",
"version": "3.1.0",
"version": "3.2.0-dev.202209131446",
"scripts": {

@@ -9,0 +9,0 @@ "build-package": "npm run build",

@@ -17,7 +17,38 @@ {

"grid": {
"description": "Generates a component containing Kendo Angular Grid component.",
"factory": "./collection/grid/index#grid",
"schema": "./collection/grid/schema.json"
}
"progress:scaffold-category": "page",
"description": "Generates a component containing Kendo Angular Grid component.",
"factory": "./collection/grid/index#grid",
"schema": "./collection/grid/schema.json"
},
"scheduler": {
"progress:scaffold-category": "page",
"description": "Generates a component containing Kendo Angular Scheduler component.",
"factory": "./collection/scheduler/index#scheduler",
"schema": "./collection/scheduler/schema.json"
},
"categorical-chart": {
"progress:scaffold-category": "page",
"description": "Generates a component containing Kendo Angular Chart component.",
"factory": "./collection/charts/categorical/index#chart",
"schema": "./collection/charts/categorical/schema.json"
},
"circular-chart": {
"progress:scaffold-category": "page",
"description": "Generates a component containing Kendo Angular Pie or Donut Chart component.",
"factory": "./collection/charts/circular/index#chart",
"schema": "./collection/charts/circular/schema.json"
},
"scatter-chart": {
"progress:scaffold-category": "page",
"description": "Generates a component containing Kendo Angular Scatter Chart component.",
"factory": "./collection/charts/scatter/index#chart",
"schema": "./collection/charts/scatter/schema.json"
},
"stock-chart": {
"progress:scaffold-category": "page",
"description": "Generates a component containing Kendo Angular Stock Chart component.",
"factory": "./collection/charts/stock/index#chart",
"schema": "./collection/charts/stock/schema.json"
}
}
}
}

@@ -1,1 +0,1 @@

export declare const products = "[{\n \"ProductID\": 1,\n \"ProductName\": \"Chai\",\n \"SupplierID\": 1,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"10 boxes x 20 bags\",\n \"UnitPrice\": 18.0000,\n \"UnitsInStock\": 39,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 10,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 2,\n \"ProductName\": \"Chang\",\n \"SupplierID\": 1,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"24 - 12 oz bottles\",\n \"UnitPrice\": 19.0000,\n \"UnitsInStock\": 17,\n \"UnitsOnOrder\": 40,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 3,\n \"ProductName\": \"Aniseed Syrup\",\n \"SupplierID\": 1,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"12 - 550 ml bottles\",\n \"UnitPrice\": 10.0000,\n \"UnitsInStock\": 13,\n \"UnitsOnOrder\": 70,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}, {\n \"ProductID\": 4,\n \"ProductName\": \"Chef Anton's Cajun Seasoning\",\n \"SupplierID\": 2,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"48 - 6 oz jars\",\n \"UnitPrice\": 22.0000,\n \"UnitsInStock\": 53,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}, {\n \"ProductID\": 5,\n \"ProductName\": \"Chef Anton's Gumbo Mix\",\n \"SupplierID\": 2,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"36 boxes\",\n \"UnitPrice\": 21.3500,\n \"UnitsInStock\": 0,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": true,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}, {\n \"ProductID\": 6,\n \"ProductName\": \"Grandma's Boysenberry Spread\",\n \"SupplierID\": 3,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"12 - 8 oz jars\",\n \"UnitPrice\": 25.0000,\n \"UnitsInStock\": 120,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}, {\n \"ProductID\": 7,\n \"ProductName\": \"Uncle Bob's Organic Dried Pears\",\n \"SupplierID\": 3,\n \"CategoryID\": 7,\n \"QuantityPerUnit\": \"12 - 1 lb pkgs.\",\n \"UnitPrice\": 30.0000,\n \"UnitsInStock\": 15,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 10,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 7,\n \"CategoryName\": \"Produce\",\n \"Description\": \"Dried fruit and bean curd\"\n }\n}, {\n \"ProductID\": 8,\n \"ProductName\": \"Northwoods Cranberry Sauce\",\n \"SupplierID\": 3,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"12 - 12 oz jars\",\n \"UnitPrice\": 40.0000,\n \"UnitsInStock\": 6,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}, {\n \"ProductID\": 9,\n \"ProductName\": \"Mishi Kobe Niku\",\n \"SupplierID\": 4,\n \"CategoryID\": 6,\n \"QuantityPerUnit\": \"18 - 500 g pkgs.\",\n \"UnitPrice\": 97.0000,\n \"UnitsInStock\": 29,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": true,\n \"Category\": {\n \"CategoryID\": 6,\n \"CategoryName\": \"Meat/Poultry\",\n \"Description\": \"Prepared meats\"\n }\n}, {\n \"ProductID\": 10,\n \"ProductName\": \"Ikura\",\n \"SupplierID\": 4,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"12 - 200 ml jars\",\n \"UnitPrice\": 31.0000,\n \"UnitsInStock\": 31,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 11,\n \"ProductName\": \"Queso Cabrales\",\n \"SupplierID\": 5,\n \"CategoryID\": 4,\n \"QuantityPerUnit\": \"1 kg pkg.\",\n \"UnitPrice\": 21.0000,\n \"UnitsInStock\": 22,\n \"UnitsOnOrder\": 30,\n \"ReorderLevel\": 30,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 4,\n \"CategoryName\": \"Dairy Products\",\n \"Description\": \"Cheeses\"\n }\n}, {\n \"ProductID\": 12,\n \"ProductName\": \"Queso Manchego La Pastora\",\n \"SupplierID\": 5,\n \"CategoryID\": 4,\n \"QuantityPerUnit\": \"10 - 500 g pkgs.\",\n \"UnitPrice\": 38.0000,\n \"UnitsInStock\": 86,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 4,\n \"CategoryName\": \"Dairy Products\",\n \"Description\": \"Cheeses\"\n }\n}, {\n \"ProductID\": 13,\n \"ProductName\": \"Konbu\",\n \"SupplierID\": 6,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"2 kg box\",\n \"UnitPrice\": 6.0000,\n \"UnitsInStock\": 24,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 5,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 14,\n \"ProductName\": \"Tofu\",\n \"SupplierID\": 6,\n \"CategoryID\": 7,\n \"QuantityPerUnit\": \"40 - 100 g pkgs.\",\n \"UnitPrice\": 23.2500,\n \"UnitsInStock\": 35,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 7,\n \"CategoryName\": \"Produce\",\n \"Description\": \"Dried fruit and bean curd\"\n }\n}, {\n \"ProductID\": 15,\n \"ProductName\": \"Genen Shouyu\",\n \"SupplierID\": 6,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"24 - 250 ml bottles\",\n \"UnitPrice\": 15.5000,\n \"UnitsInStock\": 39,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 5,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}, {\n \"ProductID\": 16,\n \"ProductName\": \"Pavlova\",\n \"SupplierID\": 7,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"32 - 500 g boxes\",\n \"UnitPrice\": 17.4500,\n \"UnitsInStock\": 29,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 10,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 17,\n \"ProductName\": \"Alice Mutton\",\n \"SupplierID\": 7,\n \"CategoryID\": 6,\n \"QuantityPerUnit\": \"20 - 1 kg tins\",\n \"UnitPrice\": 39.0000,\n \"UnitsInStock\": 0,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": true,\n \"Category\": {\n \"CategoryID\": 6,\n \"CategoryName\": \"Meat/Poultry\",\n \"Description\": \"Prepared meats\"\n }\n}, {\n \"ProductID\": 18,\n \"ProductName\": \"Carnarvon Tigers\",\n \"SupplierID\": 7,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"16 kg pkg.\",\n \"UnitPrice\": 62.5000,\n \"UnitsInStock\": 42,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 19,\n \"ProductName\": \"Teatime Chocolate Biscuits\",\n \"SupplierID\": 8,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"10 boxes x 12 pieces\",\n \"UnitPrice\": 9.2000,\n \"UnitsInStock\": 25,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 5,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 20,\n \"ProductName\": \"Sir Rodney's Marmalade\",\n \"SupplierID\": 8,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"30 gift boxes\",\n \"UnitPrice\": 81.0000,\n \"UnitsInStock\": 40,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 21,\n \"ProductName\": \"Sir Rodney's Scones\",\n \"SupplierID\": 8,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"24 pkgs. x 4 pieces\",\n \"UnitPrice\": 10.0000,\n \"UnitsInStock\": 3,\n \"UnitsOnOrder\": 40,\n \"ReorderLevel\": 5,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 22,\n \"ProductName\": \"Gustaf's Kn\u00E4ckebr\u00F6d\",\n \"SupplierID\": 9,\n \"CategoryID\": 5,\n \"QuantityPerUnit\": \"24 - 500 g pkgs.\",\n \"UnitPrice\": 21.0000,\n \"UnitsInStock\": 104,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 5,\n \"CategoryName\": \"Grains/Cereals\",\n \"Description\": \"Breads, crackers, pasta, and cereal\"\n }\n}, {\n \"ProductID\": 23,\n \"ProductName\": \"Tunnbr\u00F6d\",\n \"SupplierID\": 9,\n \"CategoryID\": 5,\n \"QuantityPerUnit\": \"12 - 250 g pkgs.\",\n \"UnitPrice\": 9.0000,\n \"UnitsInStock\": 61,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 5,\n \"CategoryName\": \"Grains/Cereals\",\n \"Description\": \"Breads, crackers, pasta, and cereal\"\n }\n}, {\n \"ProductID\": 24,\n \"ProductName\": \"Guaran\u00E1 Fant\u00E1stica\",\n \"SupplierID\": 10,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"12 - 355 ml cans\",\n \"UnitPrice\": 4.5000,\n \"UnitsInStock\": 20,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": true,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 25,\n \"ProductName\": \"NuNuCa Nu\u00DF-Nougat-Creme\",\n \"SupplierID\": 11,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"20 - 450 g glasses\",\n \"UnitPrice\": 14.0000,\n \"UnitsInStock\": 76,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 30,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 26,\n \"ProductName\": \"Gumb\u00E4r Gummib\u00E4rchen\",\n \"SupplierID\": 11,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"100 - 250 g bags\",\n \"UnitPrice\": 31.2300,\n \"UnitsInStock\": 15,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 27,\n \"ProductName\": \"Schoggi Schokolade\",\n \"SupplierID\": 11,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"100 - 100 g pieces\",\n \"UnitPrice\": 43.9000,\n \"UnitsInStock\": 49,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 30,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 28,\n \"ProductName\": \"R\u00F6ssle Sauerkraut\",\n \"SupplierID\": 12,\n \"CategoryID\": 7,\n \"QuantityPerUnit\": \"25 - 825 g cans\",\n \"UnitPrice\": 45.6000,\n \"UnitsInStock\": 26,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": true,\n \"Category\": {\n \"CategoryID\": 7,\n \"CategoryName\": \"Produce\",\n \"Description\": \"Dried fruit and bean curd\"\n }\n}, {\n \"ProductID\": 29,\n \"ProductName\": \"Th\u00FCringer Rostbratwurst\",\n \"SupplierID\": 12,\n \"CategoryID\": 6,\n \"QuantityPerUnit\": \"50 bags x 30 sausgs.\",\n \"UnitPrice\": 123.7900,\n \"UnitsInStock\": 0,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": true,\n \"Category\": {\n \"CategoryID\": 6,\n \"CategoryName\": \"Meat/Poultry\",\n \"Description\": \"Prepared meats\"\n }\n}, {\n \"ProductID\": 30,\n \"ProductName\": \"Nord-Ost Matjeshering\",\n \"SupplierID\": 13,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"10 - 200 g glasses\",\n \"UnitPrice\": 25.8900,\n \"UnitsInStock\": 10,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 15,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 31,\n \"ProductName\": \"Gorgonzola Telino\",\n \"SupplierID\": 14,\n \"CategoryID\": 4,\n \"QuantityPerUnit\": \"12 - 100 g pkgs\",\n \"UnitPrice\": 12.5000,\n \"UnitsInStock\": 0,\n \"UnitsOnOrder\": 70,\n \"ReorderLevel\": 20,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 4,\n \"CategoryName\": \"Dairy Products\",\n \"Description\": \"Cheeses\"\n }\n}, {\n \"ProductID\": 32,\n \"ProductName\": \"Mascarpone Fabioli\",\n \"SupplierID\": 14,\n \"CategoryID\": 4,\n \"QuantityPerUnit\": \"24 - 200 g pkgs.\",\n \"UnitPrice\": 32.0000,\n \"UnitsInStock\": 9,\n \"UnitsOnOrder\": 40,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 4,\n \"CategoryName\": \"Dairy Products\",\n \"Description\": \"Cheeses\"\n }\n}, {\n \"ProductID\": 33,\n \"ProductName\": \"Geitost\",\n \"SupplierID\": 15,\n \"CategoryID\": 4,\n \"QuantityPerUnit\": \"500 g\",\n \"UnitPrice\": 2.5000,\n \"UnitsInStock\": 112,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 20,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 4,\n \"CategoryName\": \"Dairy Products\",\n \"Description\": \"Cheeses\"\n }\n}, {\n \"ProductID\": 34,\n \"ProductName\": \"Sasquatch Ale\",\n \"SupplierID\": 16,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"24 - 12 oz bottles\",\n \"UnitPrice\": 14.0000,\n \"UnitsInStock\": 111,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 15,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 35,\n \"ProductName\": \"Steeleye Stout\",\n \"SupplierID\": 16,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"24 - 12 oz bottles\",\n \"UnitPrice\": 18.0000,\n \"UnitsInStock\": 20,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 15,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 36,\n \"ProductName\": \"Inlagd Sill\",\n \"SupplierID\": 17,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"24 - 250 g jars\",\n \"UnitPrice\": 19.0000,\n \"UnitsInStock\": 112,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 20,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 37,\n \"ProductName\": \"Gravad lax\",\n \"SupplierID\": 17,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"12 - 500 g pkgs.\",\n \"UnitPrice\": 26.0000,\n \"UnitsInStock\": 11,\n \"UnitsOnOrder\": 50,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 38,\n \"ProductName\": \"C\u00F4te de Blaye\",\n \"SupplierID\": 18,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"12 - 75 cl bottles\",\n \"UnitPrice\": 263.5000,\n \"UnitsInStock\": 17,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 15,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 39,\n \"ProductName\": \"Chartreuse verte\",\n \"SupplierID\": 18,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"750 cc per bottle\",\n \"UnitPrice\": 18.0000,\n \"UnitsInStock\": 69,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 5,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 40,\n \"ProductName\": \"Boston Crab Meat\",\n \"SupplierID\": 19,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"24 - 4 oz tins\",\n \"UnitPrice\": 18.4000,\n \"UnitsInStock\": 123,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 30,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 41,\n \"ProductName\": \"Jack's New England Clam Chowder\",\n \"SupplierID\": 19,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"12 - 12 oz cans\",\n \"UnitPrice\": 9.6500,\n \"UnitsInStock\": 85,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 10,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 42,\n \"ProductName\": \"Singaporean Hokkien Fried Mee\",\n \"SupplierID\": 20,\n \"CategoryID\": 5,\n \"QuantityPerUnit\": \"32 - 1 kg pkgs.\",\n \"UnitPrice\": 14.0000,\n \"UnitsInStock\": 26,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": true,\n \"Category\": {\n \"CategoryID\": 5,\n \"CategoryName\": \"Grains/Cereals\",\n \"Description\": \"Breads, crackers, pasta, and cereal\"\n }\n}, {\n \"ProductID\": 43,\n \"ProductName\": \"Ipoh Coffee\",\n \"SupplierID\": 20,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"16 - 500 g tins\",\n \"UnitPrice\": 46.0000,\n \"UnitsInStock\": 17,\n \"UnitsOnOrder\": 10,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 44,\n \"ProductName\": \"Gula Malacca\",\n \"SupplierID\": 20,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"20 - 2 kg bags\",\n \"UnitPrice\": 19.4500,\n \"UnitsInStock\": 27,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 15,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}, {\n \"ProductID\": 45,\n \"ProductName\": \"Rogede sild\",\n \"SupplierID\": 21,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"1k pkg.\",\n \"UnitPrice\": 9.5000,\n \"UnitsInStock\": 5,\n \"UnitsOnOrder\": 70,\n \"ReorderLevel\": 15,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 46,\n \"ProductName\": \"Spegesild\",\n \"SupplierID\": 21,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"4 - 450 g glasses\",\n \"UnitPrice\": 12.0000,\n \"UnitsInStock\": 95,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 47,\n \"ProductName\": \"Zaanse koeken\",\n \"SupplierID\": 22,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"10 - 4 oz boxes\",\n \"UnitPrice\": 9.5000,\n \"UnitsInStock\": 36,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 48,\n \"ProductName\": \"Chocolade\",\n \"SupplierID\": 22,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"10 pkgs.\",\n \"UnitPrice\": 12.7500,\n \"UnitsInStock\": 15,\n \"UnitsOnOrder\": 70,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 49,\n \"ProductName\": \"Maxilaku\",\n \"SupplierID\": 23,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"24 - 50 g pkgs.\",\n \"UnitPrice\": 20.0000,\n \"UnitsInStock\": 10,\n \"UnitsOnOrder\": 60,\n \"ReorderLevel\": 15,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 50,\n \"ProductName\": \"Valkoinen suklaa\",\n \"SupplierID\": 23,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"12 - 100 g bars\",\n \"UnitPrice\": 16.2500,\n \"UnitsInStock\": 65,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 30,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 51,\n \"ProductName\": \"Manjimup Dried Apples\",\n \"SupplierID\": 24,\n \"CategoryID\": 7,\n \"QuantityPerUnit\": \"50 - 300 g pkgs.\",\n \"UnitPrice\": 53.0000,\n \"UnitsInStock\": 20,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 10,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 7,\n \"CategoryName\": \"Produce\",\n \"Description\": \"Dried fruit and bean curd\"\n }\n}, {\n \"ProductID\": 52,\n \"ProductName\": \"Filo Mix\",\n \"SupplierID\": 24,\n \"CategoryID\": 5,\n \"QuantityPerUnit\": \"16 - 2 kg boxes\",\n \"UnitPrice\": 7.0000,\n \"UnitsInStock\": 38,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 5,\n \"CategoryName\": \"Grains/Cereals\",\n \"Description\": \"Breads, crackers, pasta, and cereal\"\n }\n}, {\n \"ProductID\": 53,\n \"ProductName\": \"Perth Pasties\",\n \"SupplierID\": 24,\n \"CategoryID\": 6,\n \"QuantityPerUnit\": \"48 pieces\",\n \"UnitPrice\": 32.8000,\n \"UnitsInStock\": 0,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": true,\n \"Category\": {\n \"CategoryID\": 6,\n \"CategoryName\": \"Meat/Poultry\",\n \"Description\": \"Prepared meats\"\n }\n}, {\n \"ProductID\": 54,\n \"ProductName\": \"Tourti\u00E8re\",\n \"SupplierID\": 25,\n \"CategoryID\": 6,\n \"QuantityPerUnit\": \"16 pies\",\n \"UnitPrice\": 7.4500,\n \"UnitsInStock\": 21,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 10,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 6,\n \"CategoryName\": \"Meat/Poultry\",\n \"Description\": \"Prepared meats\"\n }\n}, {\n \"ProductID\": 55,\n \"ProductName\": \"P\u00E2t\u00E9 chinois\",\n \"SupplierID\": 25,\n \"CategoryID\": 6,\n \"QuantityPerUnit\": \"24 boxes x 2 pies\",\n \"UnitPrice\": 24.0000,\n \"UnitsInStock\": 115,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 20,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 6,\n \"CategoryName\": \"Meat/Poultry\",\n \"Description\": \"Prepared meats\"\n }\n}, {\n \"ProductID\": 56,\n \"ProductName\": \"Gnocchi di nonna Alice\",\n \"SupplierID\": 26,\n \"CategoryID\": 5,\n \"QuantityPerUnit\": \"24 - 250 g pkgs.\",\n \"UnitPrice\": 38.0000,\n \"UnitsInStock\": 21,\n \"UnitsOnOrder\": 10,\n \"ReorderLevel\": 30,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 5,\n \"CategoryName\": \"Grains/Cereals\",\n \"Description\": \"Breads, crackers, pasta, and cereal\"\n }\n}, {\n \"ProductID\": 57,\n \"ProductName\": \"Ravioli Angelo\",\n \"SupplierID\": 26,\n \"CategoryID\": 5,\n \"QuantityPerUnit\": \"24 - 250 g pkgs.\",\n \"UnitPrice\": 19.5000,\n \"UnitsInStock\": 36,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 20,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 5,\n \"CategoryName\": \"Grains/Cereals\",\n \"Description\": \"Breads, crackers, pasta, and cereal\"\n }\n}, {\n \"ProductID\": 58,\n \"ProductName\": \"Escargots de Bourgogne\",\n \"SupplierID\": 27,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"24 pieces\",\n \"UnitPrice\": 13.2500,\n \"UnitsInStock\": 62,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 20,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 59,\n \"ProductName\": \"Raclette Courdavault\",\n \"SupplierID\": 28,\n \"CategoryID\": 4,\n \"QuantityPerUnit\": \"5 kg pkg.\",\n \"UnitPrice\": 55.0000,\n \"UnitsInStock\": 79,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 4,\n \"CategoryName\": \"Dairy Products\",\n \"Description\": \"Cheeses\"\n }\n}, {\n \"ProductID\": 60,\n \"ProductName\": \"Camembert Pierrot\",\n \"SupplierID\": 28,\n \"CategoryID\": 4,\n \"QuantityPerUnit\": \"15 - 300 g rounds\",\n \"UnitPrice\": 34.0000,\n \"UnitsInStock\": 19,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 4,\n \"CategoryName\": \"Dairy Products\",\n \"Description\": \"Cheeses\"\n }\n}, {\n \"ProductID\": 61,\n \"ProductName\": \"Sirop d'\u00E9rable\",\n \"SupplierID\": 29,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"24 - 500 ml bottles\",\n \"UnitPrice\": 28.5000,\n \"UnitsInStock\": 113,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}, {\n \"ProductID\": 62,\n \"ProductName\": \"Tarte au sucre\",\n \"SupplierID\": 29,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"48 pies\",\n \"UnitPrice\": 49.3000,\n \"UnitsInStock\": 17,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 63,\n \"ProductName\": \"Vegie-spread\",\n \"SupplierID\": 7,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"15 - 625 g jars\",\n \"UnitPrice\": 43.9000,\n \"UnitsInStock\": 24,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 5,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}, {\n \"ProductID\": 64,\n \"ProductName\": \"Wimmers gute Semmelkn\u00F6del\",\n \"SupplierID\": 12,\n \"CategoryID\": 5,\n \"QuantityPerUnit\": \"20 bags x 4 pieces\",\n \"UnitPrice\": 33.2500,\n \"UnitsInStock\": 22,\n \"UnitsOnOrder\": 80,\n \"ReorderLevel\": 30,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 5,\n \"CategoryName\": \"Grains/Cereals\",\n \"Description\": \"Breads, crackers, pasta, and cereal\"\n }\n}, {\n \"ProductID\": 65,\n \"ProductName\": \"Louisiana Fiery Hot Pepper Sauce\",\n \"SupplierID\": 2,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"32 - 8 oz bottles\",\n \"UnitPrice\": 21.0500,\n \"UnitsInStock\": 76,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}, {\n \"ProductID\": 66,\n \"ProductName\": \"Louisiana Hot Spiced Okra\",\n \"SupplierID\": 2,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"24 - 8 oz jars\",\n \"UnitPrice\": 17.0000,\n \"UnitsInStock\": 4,\n \"UnitsOnOrder\": 100,\n \"ReorderLevel\": 20,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}, {\n \"ProductID\": 67,\n \"ProductName\": \"Laughing Lumberjack Lager\",\n \"SupplierID\": 16,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"24 - 12 oz bottles\",\n \"UnitPrice\": 14.0000,\n \"UnitsInStock\": 52,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 10,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 68,\n \"ProductName\": \"Scottish Longbreads\",\n \"SupplierID\": 8,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"10 boxes x 8 pieces\",\n \"UnitPrice\": 12.5000,\n \"UnitsInStock\": 6,\n \"UnitsOnOrder\": 10,\n \"ReorderLevel\": 15,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 69,\n \"ProductName\": \"Gudbrandsdalsost\",\n \"SupplierID\": 15,\n \"CategoryID\": 4,\n \"QuantityPerUnit\": \"10 kg pkg.\",\n \"UnitPrice\": 36.0000,\n \"UnitsInStock\": 26,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 15,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 4,\n \"CategoryName\": \"Dairy Products\",\n \"Description\": \"Cheeses\"\n }\n}, {\n \"ProductID\": 70,\n \"ProductName\": \"Outback Lager\",\n \"SupplierID\": 7,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"24 - 355 ml bottles\",\n \"UnitPrice\": 15.0000,\n \"UnitsInStock\": 15,\n \"UnitsOnOrder\": 10,\n \"ReorderLevel\": 30,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 71,\n \"ProductName\": \"Flotemysost\",\n \"SupplierID\": 15,\n \"CategoryID\": 4,\n \"QuantityPerUnit\": \"10 - 500 g pkgs.\",\n \"UnitPrice\": 21.5000,\n \"UnitsInStock\": 26,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 4,\n \"CategoryName\": \"Dairy Products\",\n \"Description\": \"Cheeses\"\n }\n}, {\n \"ProductID\": 72,\n \"ProductName\": \"Mozzarella di Giovanni\",\n \"SupplierID\": 14,\n \"CategoryID\": 4,\n \"QuantityPerUnit\": \"24 - 200 g pkgs.\",\n \"UnitPrice\": 34.8000,\n \"UnitsInStock\": 14,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 4,\n \"CategoryName\": \"Dairy Products\",\n \"Description\": \"Cheeses\"\n }\n}, {\n \"ProductID\": 73,\n \"ProductName\": \"R\u00F6d Kaviar\",\n \"SupplierID\": 17,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"24 - 150 g jars\",\n \"UnitPrice\": 15.0000,\n \"UnitsInStock\": 101,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 5,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 74,\n \"ProductName\": \"Longlife Tofu\",\n \"SupplierID\": 4,\n \"CategoryID\": 7,\n \"QuantityPerUnit\": \"5 kg pkg.\",\n \"UnitPrice\": 10.0000,\n \"UnitsInStock\": 4,\n \"UnitsOnOrder\": 20,\n \"ReorderLevel\": 5,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 7,\n \"CategoryName\": \"Produce\",\n \"Description\": \"Dried fruit and bean curd\"\n }\n}, {\n \"ProductID\": 75,\n \"ProductName\": \"Rh\u00F6nbr\u00E4u Klosterbier\",\n \"SupplierID\": 12,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"24 - 0.5 l bottles\",\n \"UnitPrice\": 7.7500,\n \"UnitsInStock\": 125,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 76,\n \"ProductName\": \"Lakkalik\u00F6\u00F6ri\",\n \"SupplierID\": 23,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"500 ml\",\n \"UnitPrice\": 18.0000,\n \"UnitsInStock\": 57,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 20,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 77,\n \"ProductName\": \"Original Frankfurter gr\u00FCne So\u00DFe\",\n \"SupplierID\": 12,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"12 boxes\",\n \"UnitPrice\": 13.0000,\n \"UnitsInStock\": 32,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 15,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}];";
export declare const productsSourceCode = "export const products = [{\n ProductID: 1,\n ProductName: 'Chai',\n SupplierID: 1,\n CategoryID: 1,\n QuantityPerUnit: '10 boxes x 20 bags',\n UnitPrice: 18.0000,\n UnitsInStock: 39,\n UnitsOnOrder: 0,\n ReorderLevel: 10,\n Discontinued: false,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 2,\n ProductName: 'Chang',\n SupplierID: 1,\n CategoryID: 1,\n QuantityPerUnit: '24 - 12 oz bottles',\n UnitPrice: 19.0000,\n UnitsInStock: 17,\n UnitsOnOrder: 40,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 3,\n ProductName: 'Aniseed Syrup',\n SupplierID: 1,\n CategoryID: 2,\n QuantityPerUnit: '12 - 550 ml bottles',\n UnitPrice: 10.0000,\n UnitsInStock: 13,\n UnitsOnOrder: 70,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}, {\n ProductID: 4,\n ProductName: 'Chef Antons Cajun Seasoning',\n SupplierID: 2,\n CategoryID: 2,\n QuantityPerUnit: '48 - 6 oz jars',\n UnitPrice: 22.0000,\n UnitsInStock: 53,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}, {\n ProductID: 5,\n ProductName: 'Chef Antons Gumbo Mix',\n SupplierID: 2,\n CategoryID: 2,\n QuantityPerUnit: '36 boxes',\n UnitPrice: 21.3500,\n UnitsInStock: 0,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: true,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}, {\n ProductID: 6,\n ProductName: 'Grandmas Boysenberry Spread',\n SupplierID: 3,\n CategoryID: 2,\n QuantityPerUnit: '12 - 8 oz jars',\n UnitPrice: 25.0000,\n UnitsInStock: 120,\n UnitsOnOrder: 0,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}, {\n ProductID: 7,\n ProductName: 'Uncle Bobs Organic Dried Pears',\n SupplierID: 3,\n CategoryID: 7,\n QuantityPerUnit: '12 - 1 lb pkgs.',\n UnitPrice: 30.0000,\n UnitsInStock: 15,\n UnitsOnOrder: 0,\n ReorderLevel: 10,\n Discontinued: false,\n Category: {\n CategoryID: 7,\n CategoryName: 'Produce',\n Description: 'Dried fruit and bean curd'\n }\n}, {\n ProductID: 8,\n ProductName: 'Northwoods Cranberry Sauce',\n SupplierID: 3,\n CategoryID: 2,\n QuantityPerUnit: '12 - 12 oz jars',\n UnitPrice: 40.0000,\n UnitsInStock: 6,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}, {\n ProductID: 9,\n ProductName: 'Mishi Kobe Niku',\n SupplierID: 4,\n CategoryID: 6,\n QuantityPerUnit: '18 - 500 g pkgs.',\n UnitPrice: 97.0000,\n UnitsInStock: 29,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: true,\n Category: {\n CategoryID: 6,\n CategoryName: 'Meat/Poultry',\n Description: 'Prepared meats'\n }\n}, {\n ProductID: 10,\n ProductName: 'Ikura',\n SupplierID: 4,\n CategoryID: 8,\n QuantityPerUnit: '12 - 200 ml jars',\n UnitPrice: 31.0000,\n UnitsInStock: 31,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 11,\n ProductName: 'Queso Cabrales',\n SupplierID: 5,\n CategoryID: 4,\n QuantityPerUnit: '1 kg pkg.',\n UnitPrice: 21.0000,\n UnitsInStock: 22,\n UnitsOnOrder: 30,\n ReorderLevel: 30,\n Discontinued: false,\n Category: {\n CategoryID: 4,\n CategoryName: 'Dairy Products',\n Description: 'Cheeses'\n }\n}, {\n ProductID: 12,\n ProductName: 'Queso Manchego La Pastora',\n SupplierID: 5,\n CategoryID: 4,\n QuantityPerUnit: '10 - 500 g pkgs.',\n UnitPrice: 38.0000,\n UnitsInStock: 86,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 4,\n CategoryName: 'Dairy Products',\n Description: 'Cheeses'\n }\n}, {\n ProductID: 13,\n ProductName: 'Konbu',\n SupplierID: 6,\n CategoryID: 8,\n QuantityPerUnit: '2 kg box',\n UnitPrice: 6.0000,\n UnitsInStock: 24,\n UnitsOnOrder: 0,\n ReorderLevel: 5,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 14,\n ProductName: 'Tofu',\n SupplierID: 6,\n CategoryID: 7,\n QuantityPerUnit: '40 - 100 g pkgs.',\n UnitPrice: 23.2500,\n UnitsInStock: 35,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 7,\n CategoryName: 'Produce',\n Description: 'Dried fruit and bean curd'\n }\n}, {\n ProductID: 15,\n ProductName: 'Genen Shouyu',\n SupplierID: 6,\n CategoryID: 2,\n QuantityPerUnit: '24 - 250 ml bottles',\n UnitPrice: 15.5000,\n UnitsInStock: 39,\n UnitsOnOrder: 0,\n ReorderLevel: 5,\n Discontinued: false,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}, {\n ProductID: 16,\n ProductName: 'Pavlova',\n SupplierID: 7,\n CategoryID: 3,\n QuantityPerUnit: '32 - 500 g boxes',\n UnitPrice: 17.4500,\n UnitsInStock: 29,\n UnitsOnOrder: 0,\n ReorderLevel: 10,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 17,\n ProductName: 'Alice Mutton',\n SupplierID: 7,\n CategoryID: 6,\n QuantityPerUnit: '20 - 1 kg tins',\n UnitPrice: 39.0000,\n UnitsInStock: 0,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: true,\n Category: {\n CategoryID: 6,\n CategoryName: 'Meat/Poultry',\n Description: 'Prepared meats'\n }\n}, {\n ProductID: 18,\n ProductName: 'Carnarvon Tigers',\n SupplierID: 7,\n CategoryID: 8,\n QuantityPerUnit: '16 kg pkg.',\n UnitPrice: 62.5000,\n UnitsInStock: 42,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 19,\n ProductName: 'Teatime Chocolate Biscuits',\n SupplierID: 8,\n CategoryID: 3,\n QuantityPerUnit: '10 boxes x 12 pieces',\n UnitPrice: 9.2000,\n UnitsInStock: 25,\n UnitsOnOrder: 0,\n ReorderLevel: 5,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 20,\n ProductName: 'Sir Rodneys Marmalade',\n SupplierID: 8,\n CategoryID: 3,\n QuantityPerUnit: '30 gift boxes',\n UnitPrice: 81.0000,\n UnitsInStock: 40,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 21,\n ProductName: 'Sir Rodneys Scones',\n SupplierID: 8,\n CategoryID: 3,\n QuantityPerUnit: '24 pkgs. x 4 pieces',\n UnitPrice: 10.0000,\n UnitsInStock: 3,\n UnitsOnOrder: 40,\n ReorderLevel: 5,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 22,\n ProductName: 'Gustafs Kn\u00E4ckebr\u00F6d',\n SupplierID: 9,\n CategoryID: 5,\n QuantityPerUnit: '24 - 500 g pkgs.',\n UnitPrice: 21.0000,\n UnitsInStock: 104,\n UnitsOnOrder: 0,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 5,\n CategoryName: 'Grains/Cereals',\n Description: 'Breads, crackers, pasta, and cereal'\n }\n}, {\n ProductID: 23,\n ProductName: 'Tunnbr\u00F6d',\n SupplierID: 9,\n CategoryID: 5,\n QuantityPerUnit: '12 - 250 g pkgs.',\n UnitPrice: 9.0000,\n UnitsInStock: 61,\n UnitsOnOrder: 0,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 5,\n CategoryName: 'Grains/Cereals',\n Description: 'Breads, crackers, pasta, and cereal'\n }\n}, {\n ProductID: 24,\n ProductName: 'Guaran\u00E1 Fant\u00E1stica',\n SupplierID: 10,\n CategoryID: 1,\n QuantityPerUnit: '12 - 355 ml cans',\n UnitPrice: 4.5000,\n UnitsInStock: 20,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: true,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 25,\n ProductName: 'NuNuCa Nu\u00DF-Nougat-Creme',\n SupplierID: 11,\n CategoryID: 3,\n QuantityPerUnit: '20 - 450 g glasses',\n UnitPrice: 14.0000,\n UnitsInStock: 76,\n UnitsOnOrder: 0,\n ReorderLevel: 30,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 26,\n ProductName: 'Gumb\u00E4r Gummib\u00E4rchen',\n SupplierID: 11,\n CategoryID: 3,\n QuantityPerUnit: '100 - 250 g bags',\n UnitPrice: 31.2300,\n UnitsInStock: 15,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 27,\n ProductName: 'Schoggi Schokolade',\n SupplierID: 11,\n CategoryID: 3,\n QuantityPerUnit: '100 - 100 g pieces',\n UnitPrice: 43.9000,\n UnitsInStock: 49,\n UnitsOnOrder: 0,\n ReorderLevel: 30,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 28,\n ProductName: 'R\u00F6ssle Sauerkraut',\n SupplierID: 12,\n CategoryID: 7,\n QuantityPerUnit: '25 - 825 g cans',\n UnitPrice: 45.6000,\n UnitsInStock: 26,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: true,\n Category: {\n CategoryID: 7,\n CategoryName: 'Produce',\n Description: 'Dried fruit and bean curd'\n }\n}, {\n ProductID: 29,\n ProductName: 'Th\u00FCringer Rostbratwurst',\n SupplierID: 12,\n CategoryID: 6,\n QuantityPerUnit: '50 bags x 30 sausgs.',\n UnitPrice: 123.7900,\n UnitsInStock: 0,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: true,\n Category: {\n CategoryID: 6,\n CategoryName: 'Meat/Poultry',\n Description: 'Prepared meats'\n }\n}, {\n ProductID: 30,\n ProductName: 'Nord-Ost Matjeshering',\n SupplierID: 13,\n CategoryID: 8,\n QuantityPerUnit: '10 - 200 g glasses',\n UnitPrice: 25.8900,\n UnitsInStock: 10,\n UnitsOnOrder: 0,\n ReorderLevel: 15,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 31,\n ProductName: 'Gorgonzola Telino',\n SupplierID: 14,\n CategoryID: 4,\n QuantityPerUnit: '12 - 100 g pkgs',\n UnitPrice: 12.5000,\n UnitsInStock: 0,\n UnitsOnOrder: 70,\n ReorderLevel: 20,\n Discontinued: false,\n Category: {\n CategoryID: 4,\n CategoryName: 'Dairy Products',\n Description: 'Cheeses'\n }\n}, {\n ProductID: 32,\n ProductName: 'Mascarpone Fabioli',\n SupplierID: 14,\n CategoryID: 4,\n QuantityPerUnit: '24 - 200 g pkgs.',\n UnitPrice: 32.0000,\n UnitsInStock: 9,\n UnitsOnOrder: 40,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 4,\n CategoryName: 'Dairy Products',\n Description: 'Cheeses'\n }\n}, {\n ProductID: 33,\n ProductName: 'Geitost',\n SupplierID: 15,\n CategoryID: 4,\n QuantityPerUnit: '500 g',\n UnitPrice: 2.5000,\n UnitsInStock: 112,\n UnitsOnOrder: 0,\n ReorderLevel: 20,\n Discontinued: false,\n Category: {\n CategoryID: 4,\n CategoryName: 'Dairy Products',\n Description: 'Cheeses'\n }\n}, {\n ProductID: 34,\n ProductName: 'Sasquatch Ale',\n SupplierID: 16,\n CategoryID: 1,\n QuantityPerUnit: '24 - 12 oz bottles',\n UnitPrice: 14.0000,\n UnitsInStock: 111,\n UnitsOnOrder: 0,\n ReorderLevel: 15,\n Discontinued: false,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 35,\n ProductName: 'Steeleye Stout',\n SupplierID: 16,\n CategoryID: 1,\n QuantityPerUnit: '24 - 12 oz bottles',\n UnitPrice: 18.0000,\n UnitsInStock: 20,\n UnitsOnOrder: 0,\n ReorderLevel: 15,\n Discontinued: false,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 36,\n ProductName: 'Inlagd Sill',\n SupplierID: 17,\n CategoryID: 8,\n QuantityPerUnit: '24 - 250 g jars',\n UnitPrice: 19.0000,\n UnitsInStock: 112,\n UnitsOnOrder: 0,\n ReorderLevel: 20,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 37,\n ProductName: 'Gravad lax',\n SupplierID: 17,\n CategoryID: 8,\n QuantityPerUnit: '12 - 500 g pkgs.',\n UnitPrice: 26.0000,\n UnitsInStock: 11,\n UnitsOnOrder: 50,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 38,\n ProductName: 'C\u00F4te de Blaye',\n SupplierID: 18,\n CategoryID: 1,\n QuantityPerUnit: '12 - 75 cl bottles',\n UnitPrice: 263.5000,\n UnitsInStock: 17,\n UnitsOnOrder: 0,\n ReorderLevel: 15,\n Discontinued: false,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 39,\n ProductName: 'Chartreuse verte',\n SupplierID: 18,\n CategoryID: 1,\n QuantityPerUnit: '750 cc per bottle',\n UnitPrice: 18.0000,\n UnitsInStock: 69,\n UnitsOnOrder: 0,\n ReorderLevel: 5,\n Discontinued: false,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 40,\n ProductName: 'Boston Crab Meat',\n SupplierID: 19,\n CategoryID: 8,\n QuantityPerUnit: '24 - 4 oz tins',\n UnitPrice: 18.4000,\n UnitsInStock: 123,\n UnitsOnOrder: 0,\n ReorderLevel: 30,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 41,\n ProductName: 'Jacks New England Clam Chowder',\n SupplierID: 19,\n CategoryID: 8,\n QuantityPerUnit: '12 - 12 oz cans',\n UnitPrice: 9.6500,\n UnitsInStock: 85,\n UnitsOnOrder: 0,\n ReorderLevel: 10,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 42,\n ProductName: 'Singaporean Hokkien Fried Mee',\n SupplierID: 20,\n CategoryID: 5,\n QuantityPerUnit: '32 - 1 kg pkgs.',\n UnitPrice: 14.0000,\n UnitsInStock: 26,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: true,\n Category: {\n CategoryID: 5,\n CategoryName: 'Grains/Cereals',\n Description: 'Breads, crackers, pasta, and cereal'\n }\n}, {\n ProductID: 43,\n ProductName: 'Ipoh Coffee',\n SupplierID: 20,\n CategoryID: 1,\n QuantityPerUnit: '16 - 500 g tins',\n UnitPrice: 46.0000,\n UnitsInStock: 17,\n UnitsOnOrder: 10,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 44,\n ProductName: 'Gula Malacca',\n SupplierID: 20,\n CategoryID: 2,\n QuantityPerUnit: '20 - 2 kg bags',\n UnitPrice: 19.4500,\n UnitsInStock: 27,\n UnitsOnOrder: 0,\n ReorderLevel: 15,\n Discontinued: false,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}, {\n ProductID: 45,\n ProductName: 'Rogede sild',\n SupplierID: 21,\n CategoryID: 8,\n QuantityPerUnit: '1k pkg.',\n UnitPrice: 9.5000,\n UnitsInStock: 5,\n UnitsOnOrder: 70,\n ReorderLevel: 15,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 46,\n ProductName: 'Spegesild',\n SupplierID: 21,\n CategoryID: 8,\n QuantityPerUnit: '4 - 450 g glasses',\n UnitPrice: 12.0000,\n UnitsInStock: 95,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 47,\n ProductName: 'Zaanse koeken',\n SupplierID: 22,\n CategoryID: 3,\n QuantityPerUnit: '10 - 4 oz boxes',\n UnitPrice: 9.5000,\n UnitsInStock: 36,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 48,\n ProductName: 'Chocolade',\n SupplierID: 22,\n CategoryID: 3,\n QuantityPerUnit: '10 pkgs.',\n UnitPrice: 12.7500,\n UnitsInStock: 15,\n UnitsOnOrder: 70,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 49,\n ProductName: 'Maxilaku',\n SupplierID: 23,\n CategoryID: 3,\n QuantityPerUnit: '24 - 50 g pkgs.',\n UnitPrice: 20.0000,\n UnitsInStock: 10,\n UnitsOnOrder: 60,\n ReorderLevel: 15,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 50,\n ProductName: 'Valkoinen suklaa',\n SupplierID: 23,\n CategoryID: 3,\n QuantityPerUnit: '12 - 100 g bars',\n UnitPrice: 16.2500,\n UnitsInStock: 65,\n UnitsOnOrder: 0,\n ReorderLevel: 30,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 51,\n ProductName: 'Manjimup Dried Apples',\n SupplierID: 24,\n CategoryID: 7,\n QuantityPerUnit: '50 - 300 g pkgs.',\n UnitPrice: 53.0000,\n UnitsInStock: 20,\n UnitsOnOrder: 0,\n ReorderLevel: 10,\n Discontinued: false,\n Category: {\n CategoryID: 7,\n CategoryName: 'Produce',\n Description: 'Dried fruit and bean curd'\n }\n}, {\n ProductID: 52,\n ProductName: 'Filo Mix',\n SupplierID: 24,\n CategoryID: 5,\n QuantityPerUnit: '16 - 2 kg boxes',\n UnitPrice: 7.0000,\n UnitsInStock: 38,\n UnitsOnOrder: 0,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 5,\n CategoryName: 'Grains/Cereals',\n Description: 'Breads, crackers, pasta, and cereal'\n }\n}, {\n ProductID: 53,\n ProductName: 'Perth Pasties',\n SupplierID: 24,\n CategoryID: 6,\n QuantityPerUnit: '48 pieces',\n UnitPrice: 32.8000,\n UnitsInStock: 0,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: true,\n Category: {\n CategoryID: 6,\n CategoryName: 'Meat/Poultry',\n Description: 'Prepared meats'\n }\n}, {\n ProductID: 54,\n ProductName: 'Tourti\u00E8re',\n SupplierID: 25,\n CategoryID: 6,\n QuantityPerUnit: '16 pies',\n UnitPrice: 7.4500,\n UnitsInStock: 21,\n UnitsOnOrder: 0,\n ReorderLevel: 10,\n Discontinued: false,\n Category: {\n CategoryID: 6,\n CategoryName: 'Meat/Poultry',\n Description: 'Prepared meats'\n }\n}, {\n ProductID: 55,\n ProductName: 'P\u00E2t\u00E9 chinois',\n SupplierID: 25,\n CategoryID: 6,\n QuantityPerUnit: '24 boxes x 2 pies',\n UnitPrice: 24.0000,\n UnitsInStock: 115,\n UnitsOnOrder: 0,\n ReorderLevel: 20,\n Discontinued: false,\n Category: {\n CategoryID: 6,\n CategoryName: 'Meat/Poultry',\n Description: 'Prepared meats'\n }\n}, {\n ProductID: 56,\n ProductName: 'Gnocchi di nonna Alice',\n SupplierID: 26,\n CategoryID: 5,\n QuantityPerUnit: '24 - 250 g pkgs.',\n UnitPrice: 38.0000,\n UnitsInStock: 21,\n UnitsOnOrder: 10,\n ReorderLevel: 30,\n Discontinued: false,\n Category: {\n CategoryID: 5,\n CategoryName: 'Grains/Cereals',\n Description: 'Breads, crackers, pasta, and cereal'\n }\n}, {\n ProductID: 57,\n ProductName: 'Ravioli Angelo',\n SupplierID: 26,\n CategoryID: 5,\n QuantityPerUnit: '24 - 250 g pkgs.',\n UnitPrice: 19.5000,\n UnitsInStock: 36,\n UnitsOnOrder: 0,\n ReorderLevel: 20,\n Discontinued: false,\n Category: {\n CategoryID: 5,\n CategoryName: 'Grains/Cereals',\n Description: 'Breads, crackers, pasta, and cereal'\n }\n}, {\n ProductID: 58,\n ProductName: 'Escargots de Bourgogne',\n SupplierID: 27,\n CategoryID: 8,\n QuantityPerUnit: '24 pieces',\n UnitPrice: 13.2500,\n UnitsInStock: 62,\n UnitsOnOrder: 0,\n ReorderLevel: 20,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 59,\n ProductName: 'Raclette Courdavault',\n SupplierID: 28,\n CategoryID: 4,\n QuantityPerUnit: '5 kg pkg.',\n UnitPrice: 55.0000,\n UnitsInStock: 79,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 4,\n CategoryName: 'Dairy Products',\n Description: 'Cheeses'\n }\n}, {\n ProductID: 60,\n ProductName: 'Camembert Pierrot',\n SupplierID: 28,\n CategoryID: 4,\n QuantityPerUnit: '15 - 300 g rounds',\n UnitPrice: 34.0000,\n UnitsInStock: 19,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 4,\n CategoryName: 'Dairy Products',\n Description: 'Cheeses'\n }\n}, {\n ProductID: 61,\n ProductName: 'Sirop d\u00E9rable',\n SupplierID: 29,\n CategoryID: 2,\n QuantityPerUnit: '24 - 500 ml bottles',\n UnitPrice: 28.5000,\n UnitsInStock: 113,\n UnitsOnOrder: 0,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}, {\n ProductID: 62,\n ProductName: 'Tarte au sucre',\n SupplierID: 29,\n CategoryID: 3,\n QuantityPerUnit: '48 pies',\n UnitPrice: 49.3000,\n UnitsInStock: 17,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 63,\n ProductName: 'Vegie-spread',\n SupplierID: 7,\n CategoryID: 2,\n QuantityPerUnit: '15 - 625 g jars',\n UnitPrice: 43.9000,\n UnitsInStock: 24,\n UnitsOnOrder: 0,\n ReorderLevel: 5,\n Discontinued: false,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}, {\n ProductID: 64,\n ProductName: 'Wimmers gute Semmelkn\u00F6del',\n SupplierID: 12,\n CategoryID: 5,\n QuantityPerUnit: '20 bags x 4 pieces',\n UnitPrice: 33.2500,\n UnitsInStock: 22,\n UnitsOnOrder: 80,\n ReorderLevel: 30,\n Discontinued: false,\n Category: {\n CategoryID: 5,\n CategoryName: 'Grains/Cereals',\n Description: 'Breads, crackers, pasta, and cereal'\n }\n}, {\n ProductID: 65,\n ProductName: 'Louisiana Fiery Hot Pepper Sauce',\n SupplierID: 2,\n CategoryID: 2,\n QuantityPerUnit: '32 - 8 oz bottles',\n UnitPrice: 21.0500,\n UnitsInStock: 76,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}, {\n ProductID: 66,\n ProductName: 'Louisiana Hot Spiced Okra',\n SupplierID: 2,\n CategoryID: 2,\n QuantityPerUnit: '24 - 8 oz jars',\n UnitPrice: 17.0000,\n UnitsInStock: 4,\n UnitsOnOrder: 100,\n ReorderLevel: 20,\n Discontinued: false,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}, {\n ProductID: 67,\n ProductName: 'Laughing Lumberjack Lager',\n SupplierID: 16,\n CategoryID: 1,\n QuantityPerUnit: '24 - 12 oz bottles',\n UnitPrice: 14.0000,\n UnitsInStock: 52,\n UnitsOnOrder: 0,\n ReorderLevel: 10,\n Discontinued: false,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 68,\n ProductName: 'Scottish Longbreads',\n SupplierID: 8,\n CategoryID: 3,\n QuantityPerUnit: '10 boxes x 8 pieces',\n UnitPrice: 12.5000,\n UnitsInStock: 6,\n UnitsOnOrder: 10,\n ReorderLevel: 15,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 69,\n ProductName: 'Gudbrandsdalsost',\n SupplierID: 15,\n CategoryID: 4,\n QuantityPerUnit: '10 kg pkg.',\n UnitPrice: 36.0000,\n UnitsInStock: 26,\n UnitsOnOrder: 0,\n ReorderLevel: 15,\n Discontinued: false,\n Category: {\n CategoryID: 4,\n CategoryName: 'Dairy Products',\n Description: 'Cheeses'\n }\n}, {\n ProductID: 70,\n ProductName: 'Outback Lager',\n SupplierID: 7,\n CategoryID: 1,\n QuantityPerUnit: '24 - 355 ml bottles',\n UnitPrice: 15.0000,\n UnitsInStock: 15,\n UnitsOnOrder: 10,\n ReorderLevel: 30,\n Discontinued: false,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 71,\n ProductName: 'Flotemysost',\n SupplierID: 15,\n CategoryID: 4,\n QuantityPerUnit: '10 - 500 g pkgs.',\n UnitPrice: 21.5000,\n UnitsInStock: 26,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 4,\n CategoryName: 'Dairy Products',\n Description: 'Cheeses'\n }\n}, {\n ProductID: 72,\n ProductName: 'Mozzarella di Giovanni',\n SupplierID: 14,\n CategoryID: 4,\n QuantityPerUnit: '24 - 200 g pkgs.',\n UnitPrice: 34.8000,\n UnitsInStock: 14,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 4,\n CategoryName: 'Dairy Products',\n Description: 'Cheeses'\n }\n}, {\n ProductID: 73,\n ProductName: 'R\u00F6d Kaviar',\n SupplierID: 17,\n CategoryID: 8,\n QuantityPerUnit: '24 - 150 g jars',\n UnitPrice: 15.0000,\n UnitsInStock: 101,\n UnitsOnOrder: 0,\n ReorderLevel: 5,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 74,\n ProductName: 'Longlife Tofu',\n SupplierID: 4,\n CategoryID: 7,\n QuantityPerUnit: '5 kg pkg.',\n UnitPrice: 10.0000,\n UnitsInStock: 4,\n UnitsOnOrder: 20,\n ReorderLevel: 5,\n Discontinued: false,\n Category: {\n CategoryID: 7,\n CategoryName: 'Produce',\n Description: 'Dried fruit and bean curd'\n }\n}, {\n ProductID: 75,\n ProductName: 'Rh\u00F6nbr\u00E4u Klosterbier',\n SupplierID: 12,\n CategoryID: 1,\n QuantityPerUnit: '24 - 0.5 l bottles',\n UnitPrice: 7.7500,\n UnitsInStock: 125,\n UnitsOnOrder: 0,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 76,\n ProductName: 'Lakkalik\u00F6\u00F6ri',\n SupplierID: 23,\n CategoryID: 1,\n QuantityPerUnit: '500 ml',\n UnitPrice: 18.0000,\n UnitsInStock: 57,\n UnitsOnOrder: 0,\n ReorderLevel: 20,\n Discontinued: false,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 77,\n ProductName: 'Original Frankfurter gr\u00FCne So\u00DFe',\n SupplierID: 12,\n CategoryID: 2,\n QuantityPerUnit: '12 boxes',\n UnitPrice: 13.0000,\n UnitsInStock: 32,\n UnitsOnOrder: 0,\n ReorderLevel: 15,\n Discontinued: false,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}];";
"use strict";
Object.defineProperty(exports, "__esModule", { value: true });
exports.products = void 0;
exports.products = `[{
"ProductID": 1,
"ProductName": "Chai",
"SupplierID": 1,
"CategoryID": 1,
"QuantityPerUnit": "10 boxes x 20 bags",
"UnitPrice": 18.0000,
"UnitsInStock": 39,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
exports.productsSourceCode = void 0;
exports.productsSourceCode = `export const products = [{
ProductID: 1,
ProductName: 'Chai',
SupplierID: 1,
CategoryID: 1,
QuantityPerUnit: '10 boxes x 20 bags',
UnitPrice: 18.0000,
UnitsInStock: 39,
UnitsOnOrder: 0,
ReorderLevel: 10,
Discontinued: false,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 2,
"ProductName": "Chang",
"SupplierID": 1,
"CategoryID": 1,
"QuantityPerUnit": "24 - 12 oz bottles",
"UnitPrice": 19.0000,
"UnitsInStock": 17,
"UnitsOnOrder": 40,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
ProductID: 2,
ProductName: 'Chang',
SupplierID: 1,
CategoryID: 1,
QuantityPerUnit: '24 - 12 oz bottles',
UnitPrice: 19.0000,
UnitsInStock: 17,
UnitsOnOrder: 40,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 3,
"ProductName": "Aniseed Syrup",
"SupplierID": 1,
"CategoryID": 2,
"QuantityPerUnit": "12 - 550 ml bottles",
"UnitPrice": 10.0000,
"UnitsInStock": 13,
"UnitsOnOrder": 70,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 3,
ProductName: 'Aniseed Syrup',
SupplierID: 1,
CategoryID: 2,
QuantityPerUnit: '12 - 550 ml bottles',
UnitPrice: 10.0000,
UnitsInStock: 13,
UnitsOnOrder: 70,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}, {
"ProductID": 4,
"ProductName": "Chef Anton's Cajun Seasoning",
"SupplierID": 2,
"CategoryID": 2,
"QuantityPerUnit": "48 - 6 oz jars",
"UnitPrice": 22.0000,
"UnitsInStock": 53,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 4,
ProductName: 'Chef Antons Cajun Seasoning',
SupplierID: 2,
CategoryID: 2,
QuantityPerUnit: '48 - 6 oz jars',
UnitPrice: 22.0000,
UnitsInStock: 53,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}, {
"ProductID": 5,
"ProductName": "Chef Anton's Gumbo Mix",
"SupplierID": 2,
"CategoryID": 2,
"QuantityPerUnit": "36 boxes",
"UnitPrice": 21.3500,
"UnitsInStock": 0,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 5,
ProductName: 'Chef Antons Gumbo Mix',
SupplierID: 2,
CategoryID: 2,
QuantityPerUnit: '36 boxes',
UnitPrice: 21.3500,
UnitsInStock: 0,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: true,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}, {
"ProductID": 6,
"ProductName": "Grandma's Boysenberry Spread",
"SupplierID": 3,
"CategoryID": 2,
"QuantityPerUnit": "12 - 8 oz jars",
"UnitPrice": 25.0000,
"UnitsInStock": 120,
"UnitsOnOrder": 0,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 6,
ProductName: 'Grandmas Boysenberry Spread',
SupplierID: 3,
CategoryID: 2,
QuantityPerUnit: '12 - 8 oz jars',
UnitPrice: 25.0000,
UnitsInStock: 120,
UnitsOnOrder: 0,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}, {
"ProductID": 7,
"ProductName": "Uncle Bob's Organic Dried Pears",
"SupplierID": 3,
"CategoryID": 7,
"QuantityPerUnit": "12 - 1 lb pkgs.",
"UnitPrice": 30.0000,
"UnitsInStock": 15,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 7,
"CategoryName": "Produce",
"Description": "Dried fruit and bean curd"
ProductID: 7,
ProductName: 'Uncle Bobs Organic Dried Pears',
SupplierID: 3,
CategoryID: 7,
QuantityPerUnit: '12 - 1 lb pkgs.',
UnitPrice: 30.0000,
UnitsInStock: 15,
UnitsOnOrder: 0,
ReorderLevel: 10,
Discontinued: false,
Category: {
CategoryID: 7,
CategoryName: 'Produce',
Description: 'Dried fruit and bean curd'
}
}, {
"ProductID": 8,
"ProductName": "Northwoods Cranberry Sauce",
"SupplierID": 3,
"CategoryID": 2,
"QuantityPerUnit": "12 - 12 oz jars",
"UnitPrice": 40.0000,
"UnitsInStock": 6,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 8,
ProductName: 'Northwoods Cranberry Sauce',
SupplierID: 3,
CategoryID: 2,
QuantityPerUnit: '12 - 12 oz jars',
UnitPrice: 40.0000,
UnitsInStock: 6,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}, {
"ProductID": 9,
"ProductName": "Mishi Kobe Niku",
"SupplierID": 4,
"CategoryID": 6,
"QuantityPerUnit": "18 - 500 g pkgs.",
"UnitPrice": 97.0000,
"UnitsInStock": 29,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 6,
"CategoryName": "Meat/Poultry",
"Description": "Prepared meats"
ProductID: 9,
ProductName: 'Mishi Kobe Niku',
SupplierID: 4,
CategoryID: 6,
QuantityPerUnit: '18 - 500 g pkgs.',
UnitPrice: 97.0000,
UnitsInStock: 29,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: true,
Category: {
CategoryID: 6,
CategoryName: 'Meat/Poultry',
Description: 'Prepared meats'
}
}, {
"ProductID": 10,
"ProductName": "Ikura",
"SupplierID": 4,
"CategoryID": 8,
"QuantityPerUnit": "12 - 200 ml jars",
"UnitPrice": 31.0000,
"UnitsInStock": 31,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 10,
ProductName: 'Ikura',
SupplierID: 4,
CategoryID: 8,
QuantityPerUnit: '12 - 200 ml jars',
UnitPrice: 31.0000,
UnitsInStock: 31,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 11,
"ProductName": "Queso Cabrales",
"SupplierID": 5,
"CategoryID": 4,
"QuantityPerUnit": "1 kg pkg.",
"UnitPrice": 21.0000,
"UnitsInStock": 22,
"UnitsOnOrder": 30,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
ProductID: 11,
ProductName: 'Queso Cabrales',
SupplierID: 5,
CategoryID: 4,
QuantityPerUnit: '1 kg pkg.',
UnitPrice: 21.0000,
UnitsInStock: 22,
UnitsOnOrder: 30,
ReorderLevel: 30,
Discontinued: false,
Category: {
CategoryID: 4,
CategoryName: 'Dairy Products',
Description: 'Cheeses'
}
}, {
"ProductID": 12,
"ProductName": "Queso Manchego La Pastora",
"SupplierID": 5,
"CategoryID": 4,
"QuantityPerUnit": "10 - 500 g pkgs.",
"UnitPrice": 38.0000,
"UnitsInStock": 86,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
ProductID: 12,
ProductName: 'Queso Manchego La Pastora',
SupplierID: 5,
CategoryID: 4,
QuantityPerUnit: '10 - 500 g pkgs.',
UnitPrice: 38.0000,
UnitsInStock: 86,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 4,
CategoryName: 'Dairy Products',
Description: 'Cheeses'
}
}, {
"ProductID": 13,
"ProductName": "Konbu",
"SupplierID": 6,
"CategoryID": 8,
"QuantityPerUnit": "2 kg box",
"UnitPrice": 6.0000,
"UnitsInStock": 24,
"UnitsOnOrder": 0,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 13,
ProductName: 'Konbu',
SupplierID: 6,
CategoryID: 8,
QuantityPerUnit: '2 kg box',
UnitPrice: 6.0000,
UnitsInStock: 24,
UnitsOnOrder: 0,
ReorderLevel: 5,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 14,
"ProductName": "Tofu",
"SupplierID": 6,
"CategoryID": 7,
"QuantityPerUnit": "40 - 100 g pkgs.",
"UnitPrice": 23.2500,
"UnitsInStock": 35,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 7,
"CategoryName": "Produce",
"Description": "Dried fruit and bean curd"
ProductID: 14,
ProductName: 'Tofu',
SupplierID: 6,
CategoryID: 7,
QuantityPerUnit: '40 - 100 g pkgs.',
UnitPrice: 23.2500,
UnitsInStock: 35,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 7,
CategoryName: 'Produce',
Description: 'Dried fruit and bean curd'
}
}, {
"ProductID": 15,
"ProductName": "Genen Shouyu",
"SupplierID": 6,
"CategoryID": 2,
"QuantityPerUnit": "24 - 250 ml bottles",
"UnitPrice": 15.5000,
"UnitsInStock": 39,
"UnitsOnOrder": 0,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 15,
ProductName: 'Genen Shouyu',
SupplierID: 6,
CategoryID: 2,
QuantityPerUnit: '24 - 250 ml bottles',
UnitPrice: 15.5000,
UnitsInStock: 39,
UnitsOnOrder: 0,
ReorderLevel: 5,
Discontinued: false,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}, {
"ProductID": 16,
"ProductName": "Pavlova",
"SupplierID": 7,
"CategoryID": 3,
"QuantityPerUnit": "32 - 500 g boxes",
"UnitPrice": 17.4500,
"UnitsInStock": 29,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 16,
ProductName: 'Pavlova',
SupplierID: 7,
CategoryID: 3,
QuantityPerUnit: '32 - 500 g boxes',
UnitPrice: 17.4500,
UnitsInStock: 29,
UnitsOnOrder: 0,
ReorderLevel: 10,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 17,
"ProductName": "Alice Mutton",
"SupplierID": 7,
"CategoryID": 6,
"QuantityPerUnit": "20 - 1 kg tins",
"UnitPrice": 39.0000,
"UnitsInStock": 0,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 6,
"CategoryName": "Meat/Poultry",
"Description": "Prepared meats"
ProductID: 17,
ProductName: 'Alice Mutton',
SupplierID: 7,
CategoryID: 6,
QuantityPerUnit: '20 - 1 kg tins',
UnitPrice: 39.0000,
UnitsInStock: 0,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: true,
Category: {
CategoryID: 6,
CategoryName: 'Meat/Poultry',
Description: 'Prepared meats'
}
}, {
"ProductID": 18,
"ProductName": "Carnarvon Tigers",
"SupplierID": 7,
"CategoryID": 8,
"QuantityPerUnit": "16 kg pkg.",
"UnitPrice": 62.5000,
"UnitsInStock": 42,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 18,
ProductName: 'Carnarvon Tigers',
SupplierID: 7,
CategoryID: 8,
QuantityPerUnit: '16 kg pkg.',
UnitPrice: 62.5000,
UnitsInStock: 42,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 19,
"ProductName": "Teatime Chocolate Biscuits",
"SupplierID": 8,
"CategoryID": 3,
"QuantityPerUnit": "10 boxes x 12 pieces",
"UnitPrice": 9.2000,
"UnitsInStock": 25,
"UnitsOnOrder": 0,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 19,
ProductName: 'Teatime Chocolate Biscuits',
SupplierID: 8,
CategoryID: 3,
QuantityPerUnit: '10 boxes x 12 pieces',
UnitPrice: 9.2000,
UnitsInStock: 25,
UnitsOnOrder: 0,
ReorderLevel: 5,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 20,
"ProductName": "Sir Rodney's Marmalade",
"SupplierID": 8,
"CategoryID": 3,
"QuantityPerUnit": "30 gift boxes",
"UnitPrice": 81.0000,
"UnitsInStock": 40,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 20,
ProductName: 'Sir Rodneys Marmalade',
SupplierID: 8,
CategoryID: 3,
QuantityPerUnit: '30 gift boxes',
UnitPrice: 81.0000,
UnitsInStock: 40,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 21,
"ProductName": "Sir Rodney's Scones",
"SupplierID": 8,
"CategoryID": 3,
"QuantityPerUnit": "24 pkgs. x 4 pieces",
"UnitPrice": 10.0000,
"UnitsInStock": 3,
"UnitsOnOrder": 40,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 21,
ProductName: 'Sir Rodneys Scones',
SupplierID: 8,
CategoryID: 3,
QuantityPerUnit: '24 pkgs. x 4 pieces',
UnitPrice: 10.0000,
UnitsInStock: 3,
UnitsOnOrder: 40,
ReorderLevel: 5,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 22,
"ProductName": "Gustaf's Knäckebröd",
"SupplierID": 9,
"CategoryID": 5,
"QuantityPerUnit": "24 - 500 g pkgs.",
"UnitPrice": 21.0000,
"UnitsInStock": 104,
"UnitsOnOrder": 0,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 5,
"CategoryName": "Grains/Cereals",
"Description": "Breads, crackers, pasta, and cereal"
ProductID: 22,
ProductName: 'Gustafs Knäckebröd',
SupplierID: 9,
CategoryID: 5,
QuantityPerUnit: '24 - 500 g pkgs.',
UnitPrice: 21.0000,
UnitsInStock: 104,
UnitsOnOrder: 0,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 5,
CategoryName: 'Grains/Cereals',
Description: 'Breads, crackers, pasta, and cereal'
}
}, {
"ProductID": 23,
"ProductName": "Tunnbröd",
"SupplierID": 9,
"CategoryID": 5,
"QuantityPerUnit": "12 - 250 g pkgs.",
"UnitPrice": 9.0000,
"UnitsInStock": 61,
"UnitsOnOrder": 0,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 5,
"CategoryName": "Grains/Cereals",
"Description": "Breads, crackers, pasta, and cereal"
ProductID: 23,
ProductName: 'Tunnbröd',
SupplierID: 9,
CategoryID: 5,
QuantityPerUnit: '12 - 250 g pkgs.',
UnitPrice: 9.0000,
UnitsInStock: 61,
UnitsOnOrder: 0,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 5,
CategoryName: 'Grains/Cereals',
Description: 'Breads, crackers, pasta, and cereal'
}
}, {
"ProductID": 24,
"ProductName": "Guaraná Fantástica",
"SupplierID": 10,
"CategoryID": 1,
"QuantityPerUnit": "12 - 355 ml cans",
"UnitPrice": 4.5000,
"UnitsInStock": 20,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
ProductID: 24,
ProductName: 'Guaraná Fantástica',
SupplierID: 10,
CategoryID: 1,
QuantityPerUnit: '12 - 355 ml cans',
UnitPrice: 4.5000,
UnitsInStock: 20,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: true,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 25,
"ProductName": "NuNuCa Nuß-Nougat-Creme",
"SupplierID": 11,
"CategoryID": 3,
"QuantityPerUnit": "20 - 450 g glasses",
"UnitPrice": 14.0000,
"UnitsInStock": 76,
"UnitsOnOrder": 0,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 25,
ProductName: 'NuNuCa Nuß-Nougat-Creme',
SupplierID: 11,
CategoryID: 3,
QuantityPerUnit: '20 - 450 g glasses',
UnitPrice: 14.0000,
UnitsInStock: 76,
UnitsOnOrder: 0,
ReorderLevel: 30,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 26,
"ProductName": "Gumbär Gummibärchen",
"SupplierID": 11,
"CategoryID": 3,
"QuantityPerUnit": "100 - 250 g bags",
"UnitPrice": 31.2300,
"UnitsInStock": 15,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 26,
ProductName: 'Gumbär Gummibärchen',
SupplierID: 11,
CategoryID: 3,
QuantityPerUnit: '100 - 250 g bags',
UnitPrice: 31.2300,
UnitsInStock: 15,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 27,
"ProductName": "Schoggi Schokolade",
"SupplierID": 11,
"CategoryID": 3,
"QuantityPerUnit": "100 - 100 g pieces",
"UnitPrice": 43.9000,
"UnitsInStock": 49,
"UnitsOnOrder": 0,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 27,
ProductName: 'Schoggi Schokolade',
SupplierID: 11,
CategoryID: 3,
QuantityPerUnit: '100 - 100 g pieces',
UnitPrice: 43.9000,
UnitsInStock: 49,
UnitsOnOrder: 0,
ReorderLevel: 30,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 28,
"ProductName": "Rössle Sauerkraut",
"SupplierID": 12,
"CategoryID": 7,
"QuantityPerUnit": "25 - 825 g cans",
"UnitPrice": 45.6000,
"UnitsInStock": 26,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 7,
"CategoryName": "Produce",
"Description": "Dried fruit and bean curd"
ProductID: 28,
ProductName: 'Rössle Sauerkraut',
SupplierID: 12,
CategoryID: 7,
QuantityPerUnit: '25 - 825 g cans',
UnitPrice: 45.6000,
UnitsInStock: 26,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: true,
Category: {
CategoryID: 7,
CategoryName: 'Produce',
Description: 'Dried fruit and bean curd'
}
}, {
"ProductID": 29,
"ProductName": "Thüringer Rostbratwurst",
"SupplierID": 12,
"CategoryID": 6,
"QuantityPerUnit": "50 bags x 30 sausgs.",
"UnitPrice": 123.7900,
"UnitsInStock": 0,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 6,
"CategoryName": "Meat/Poultry",
"Description": "Prepared meats"
ProductID: 29,
ProductName: 'Thüringer Rostbratwurst',
SupplierID: 12,
CategoryID: 6,
QuantityPerUnit: '50 bags x 30 sausgs.',
UnitPrice: 123.7900,
UnitsInStock: 0,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: true,
Category: {
CategoryID: 6,
CategoryName: 'Meat/Poultry',
Description: 'Prepared meats'
}
}, {
"ProductID": 30,
"ProductName": "Nord-Ost Matjeshering",
"SupplierID": 13,
"CategoryID": 8,
"QuantityPerUnit": "10 - 200 g glasses",
"UnitPrice": 25.8900,
"UnitsInStock": 10,
"UnitsOnOrder": 0,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 30,
ProductName: 'Nord-Ost Matjeshering',
SupplierID: 13,
CategoryID: 8,
QuantityPerUnit: '10 - 200 g glasses',
UnitPrice: 25.8900,
UnitsInStock: 10,
UnitsOnOrder: 0,
ReorderLevel: 15,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 31,
"ProductName": "Gorgonzola Telino",
"SupplierID": 14,
"CategoryID": 4,
"QuantityPerUnit": "12 - 100 g pkgs",
"UnitPrice": 12.5000,
"UnitsInStock": 0,
"UnitsOnOrder": 70,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
ProductID: 31,
ProductName: 'Gorgonzola Telino',
SupplierID: 14,
CategoryID: 4,
QuantityPerUnit: '12 - 100 g pkgs',
UnitPrice: 12.5000,
UnitsInStock: 0,
UnitsOnOrder: 70,
ReorderLevel: 20,
Discontinued: false,
Category: {
CategoryID: 4,
CategoryName: 'Dairy Products',
Description: 'Cheeses'
}
}, {
"ProductID": 32,
"ProductName": "Mascarpone Fabioli",
"SupplierID": 14,
"CategoryID": 4,
"QuantityPerUnit": "24 - 200 g pkgs.",
"UnitPrice": 32.0000,
"UnitsInStock": 9,
"UnitsOnOrder": 40,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
ProductID: 32,
ProductName: 'Mascarpone Fabioli',
SupplierID: 14,
CategoryID: 4,
QuantityPerUnit: '24 - 200 g pkgs.',
UnitPrice: 32.0000,
UnitsInStock: 9,
UnitsOnOrder: 40,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 4,
CategoryName: 'Dairy Products',
Description: 'Cheeses'
}
}, {
"ProductID": 33,
"ProductName": "Geitost",
"SupplierID": 15,
"CategoryID": 4,
"QuantityPerUnit": "500 g",
"UnitPrice": 2.5000,
"UnitsInStock": 112,
"UnitsOnOrder": 0,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
ProductID: 33,
ProductName: 'Geitost',
SupplierID: 15,
CategoryID: 4,
QuantityPerUnit: '500 g',
UnitPrice: 2.5000,
UnitsInStock: 112,
UnitsOnOrder: 0,
ReorderLevel: 20,
Discontinued: false,
Category: {
CategoryID: 4,
CategoryName: 'Dairy Products',
Description: 'Cheeses'
}
}, {
"ProductID": 34,
"ProductName": "Sasquatch Ale",
"SupplierID": 16,
"CategoryID": 1,
"QuantityPerUnit": "24 - 12 oz bottles",
"UnitPrice": 14.0000,
"UnitsInStock": 111,
"UnitsOnOrder": 0,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
ProductID: 34,
ProductName: 'Sasquatch Ale',
SupplierID: 16,
CategoryID: 1,
QuantityPerUnit: '24 - 12 oz bottles',
UnitPrice: 14.0000,
UnitsInStock: 111,
UnitsOnOrder: 0,
ReorderLevel: 15,
Discontinued: false,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 35,
"ProductName": "Steeleye Stout",
"SupplierID": 16,
"CategoryID": 1,
"QuantityPerUnit": "24 - 12 oz bottles",
"UnitPrice": 18.0000,
"UnitsInStock": 20,
"UnitsOnOrder": 0,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
ProductID: 35,
ProductName: 'Steeleye Stout',
SupplierID: 16,
CategoryID: 1,
QuantityPerUnit: '24 - 12 oz bottles',
UnitPrice: 18.0000,
UnitsInStock: 20,
UnitsOnOrder: 0,
ReorderLevel: 15,
Discontinued: false,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 36,
"ProductName": "Inlagd Sill",
"SupplierID": 17,
"CategoryID": 8,
"QuantityPerUnit": "24 - 250 g jars",
"UnitPrice": 19.0000,
"UnitsInStock": 112,
"UnitsOnOrder": 0,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 36,
ProductName: 'Inlagd Sill',
SupplierID: 17,
CategoryID: 8,
QuantityPerUnit: '24 - 250 g jars',
UnitPrice: 19.0000,
UnitsInStock: 112,
UnitsOnOrder: 0,
ReorderLevel: 20,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 37,
"ProductName": "Gravad lax",
"SupplierID": 17,
"CategoryID": 8,
"QuantityPerUnit": "12 - 500 g pkgs.",
"UnitPrice": 26.0000,
"UnitsInStock": 11,
"UnitsOnOrder": 50,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 37,
ProductName: 'Gravad lax',
SupplierID: 17,
CategoryID: 8,
QuantityPerUnit: '12 - 500 g pkgs.',
UnitPrice: 26.0000,
UnitsInStock: 11,
UnitsOnOrder: 50,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 38,
"ProductName": "Côte de Blaye",
"SupplierID": 18,
"CategoryID": 1,
"QuantityPerUnit": "12 - 75 cl bottles",
"UnitPrice": 263.5000,
"UnitsInStock": 17,
"UnitsOnOrder": 0,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
ProductID: 38,
ProductName: 'Côte de Blaye',
SupplierID: 18,
CategoryID: 1,
QuantityPerUnit: '12 - 75 cl bottles',
UnitPrice: 263.5000,
UnitsInStock: 17,
UnitsOnOrder: 0,
ReorderLevel: 15,
Discontinued: false,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 39,
"ProductName": "Chartreuse verte",
"SupplierID": 18,
"CategoryID": 1,
"QuantityPerUnit": "750 cc per bottle",
"UnitPrice": 18.0000,
"UnitsInStock": 69,
"UnitsOnOrder": 0,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
ProductID: 39,
ProductName: 'Chartreuse verte',
SupplierID: 18,
CategoryID: 1,
QuantityPerUnit: '750 cc per bottle',
UnitPrice: 18.0000,
UnitsInStock: 69,
UnitsOnOrder: 0,
ReorderLevel: 5,
Discontinued: false,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 40,
"ProductName": "Boston Crab Meat",
"SupplierID": 19,
"CategoryID": 8,
"QuantityPerUnit": "24 - 4 oz tins",
"UnitPrice": 18.4000,
"UnitsInStock": 123,
"UnitsOnOrder": 0,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 40,
ProductName: 'Boston Crab Meat',
SupplierID: 19,
CategoryID: 8,
QuantityPerUnit: '24 - 4 oz tins',
UnitPrice: 18.4000,
UnitsInStock: 123,
UnitsOnOrder: 0,
ReorderLevel: 30,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 41,
"ProductName": "Jack's New England Clam Chowder",
"SupplierID": 19,
"CategoryID": 8,
"QuantityPerUnit": "12 - 12 oz cans",
"UnitPrice": 9.6500,
"UnitsInStock": 85,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 41,
ProductName: 'Jacks New England Clam Chowder',
SupplierID: 19,
CategoryID: 8,
QuantityPerUnit: '12 - 12 oz cans',
UnitPrice: 9.6500,
UnitsInStock: 85,
UnitsOnOrder: 0,
ReorderLevel: 10,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 42,
"ProductName": "Singaporean Hokkien Fried Mee",
"SupplierID": 20,
"CategoryID": 5,
"QuantityPerUnit": "32 - 1 kg pkgs.",
"UnitPrice": 14.0000,
"UnitsInStock": 26,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 5,
"CategoryName": "Grains/Cereals",
"Description": "Breads, crackers, pasta, and cereal"
ProductID: 42,
ProductName: 'Singaporean Hokkien Fried Mee',
SupplierID: 20,
CategoryID: 5,
QuantityPerUnit: '32 - 1 kg pkgs.',
UnitPrice: 14.0000,
UnitsInStock: 26,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: true,
Category: {
CategoryID: 5,
CategoryName: 'Grains/Cereals',
Description: 'Breads, crackers, pasta, and cereal'
}
}, {
"ProductID": 43,
"ProductName": "Ipoh Coffee",
"SupplierID": 20,
"CategoryID": 1,
"QuantityPerUnit": "16 - 500 g tins",
"UnitPrice": 46.0000,
"UnitsInStock": 17,
"UnitsOnOrder": 10,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
ProductID: 43,
ProductName: 'Ipoh Coffee',
SupplierID: 20,
CategoryID: 1,
QuantityPerUnit: '16 - 500 g tins',
UnitPrice: 46.0000,
UnitsInStock: 17,
UnitsOnOrder: 10,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 44,
"ProductName": "Gula Malacca",
"SupplierID": 20,
"CategoryID": 2,
"QuantityPerUnit": "20 - 2 kg bags",
"UnitPrice": 19.4500,
"UnitsInStock": 27,
"UnitsOnOrder": 0,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 44,
ProductName: 'Gula Malacca',
SupplierID: 20,
CategoryID: 2,
QuantityPerUnit: '20 - 2 kg bags',
UnitPrice: 19.4500,
UnitsInStock: 27,
UnitsOnOrder: 0,
ReorderLevel: 15,
Discontinued: false,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}, {
"ProductID": 45,
"ProductName": "Rogede sild",
"SupplierID": 21,
"CategoryID": 8,
"QuantityPerUnit": "1k pkg.",
"UnitPrice": 9.5000,
"UnitsInStock": 5,
"UnitsOnOrder": 70,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 45,
ProductName: 'Rogede sild',
SupplierID: 21,
CategoryID: 8,
QuantityPerUnit: '1k pkg.',
UnitPrice: 9.5000,
UnitsInStock: 5,
UnitsOnOrder: 70,
ReorderLevel: 15,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 46,
"ProductName": "Spegesild",
"SupplierID": 21,
"CategoryID": 8,
"QuantityPerUnit": "4 - 450 g glasses",
"UnitPrice": 12.0000,
"UnitsInStock": 95,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 46,
ProductName: 'Spegesild',
SupplierID: 21,
CategoryID: 8,
QuantityPerUnit: '4 - 450 g glasses',
UnitPrice: 12.0000,
UnitsInStock: 95,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 47,
"ProductName": "Zaanse koeken",
"SupplierID": 22,
"CategoryID": 3,
"QuantityPerUnit": "10 - 4 oz boxes",
"UnitPrice": 9.5000,
"UnitsInStock": 36,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 47,
ProductName: 'Zaanse koeken',
SupplierID: 22,
CategoryID: 3,
QuantityPerUnit: '10 - 4 oz boxes',
UnitPrice: 9.5000,
UnitsInStock: 36,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 48,
"ProductName": "Chocolade",
"SupplierID": 22,
"CategoryID": 3,
"QuantityPerUnit": "10 pkgs.",
"UnitPrice": 12.7500,
"UnitsInStock": 15,
"UnitsOnOrder": 70,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 48,
ProductName: 'Chocolade',
SupplierID: 22,
CategoryID: 3,
QuantityPerUnit: '10 pkgs.',
UnitPrice: 12.7500,
UnitsInStock: 15,
UnitsOnOrder: 70,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 49,
"ProductName": "Maxilaku",
"SupplierID": 23,
"CategoryID": 3,
"QuantityPerUnit": "24 - 50 g pkgs.",
"UnitPrice": 20.0000,
"UnitsInStock": 10,
"UnitsOnOrder": 60,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 49,
ProductName: 'Maxilaku',
SupplierID: 23,
CategoryID: 3,
QuantityPerUnit: '24 - 50 g pkgs.',
UnitPrice: 20.0000,
UnitsInStock: 10,
UnitsOnOrder: 60,
ReorderLevel: 15,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 50,
"ProductName": "Valkoinen suklaa",
"SupplierID": 23,
"CategoryID": 3,
"QuantityPerUnit": "12 - 100 g bars",
"UnitPrice": 16.2500,
"UnitsInStock": 65,
"UnitsOnOrder": 0,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 50,
ProductName: 'Valkoinen suklaa',
SupplierID: 23,
CategoryID: 3,
QuantityPerUnit: '12 - 100 g bars',
UnitPrice: 16.2500,
UnitsInStock: 65,
UnitsOnOrder: 0,
ReorderLevel: 30,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 51,
"ProductName": "Manjimup Dried Apples",
"SupplierID": 24,
"CategoryID": 7,
"QuantityPerUnit": "50 - 300 g pkgs.",
"UnitPrice": 53.0000,
"UnitsInStock": 20,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 7,
"CategoryName": "Produce",
"Description": "Dried fruit and bean curd"
ProductID: 51,
ProductName: 'Manjimup Dried Apples',
SupplierID: 24,
CategoryID: 7,
QuantityPerUnit: '50 - 300 g pkgs.',
UnitPrice: 53.0000,
UnitsInStock: 20,
UnitsOnOrder: 0,
ReorderLevel: 10,
Discontinued: false,
Category: {
CategoryID: 7,
CategoryName: 'Produce',
Description: 'Dried fruit and bean curd'
}
}, {
"ProductID": 52,
"ProductName": "Filo Mix",
"SupplierID": 24,
"CategoryID": 5,
"QuantityPerUnit": "16 - 2 kg boxes",
"UnitPrice": 7.0000,
"UnitsInStock": 38,
"UnitsOnOrder": 0,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 5,
"CategoryName": "Grains/Cereals",
"Description": "Breads, crackers, pasta, and cereal"
ProductID: 52,
ProductName: 'Filo Mix',
SupplierID: 24,
CategoryID: 5,
QuantityPerUnit: '16 - 2 kg boxes',
UnitPrice: 7.0000,
UnitsInStock: 38,
UnitsOnOrder: 0,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 5,
CategoryName: 'Grains/Cereals',
Description: 'Breads, crackers, pasta, and cereal'
}
}, {
"ProductID": 53,
"ProductName": "Perth Pasties",
"SupplierID": 24,
"CategoryID": 6,
"QuantityPerUnit": "48 pieces",
"UnitPrice": 32.8000,
"UnitsInStock": 0,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 6,
"CategoryName": "Meat/Poultry",
"Description": "Prepared meats"
ProductID: 53,
ProductName: 'Perth Pasties',
SupplierID: 24,
CategoryID: 6,
QuantityPerUnit: '48 pieces',
UnitPrice: 32.8000,
UnitsInStock: 0,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: true,
Category: {
CategoryID: 6,
CategoryName: 'Meat/Poultry',
Description: 'Prepared meats'
}
}, {
"ProductID": 54,
"ProductName": "Tourtière",
"SupplierID": 25,
"CategoryID": 6,
"QuantityPerUnit": "16 pies",
"UnitPrice": 7.4500,
"UnitsInStock": 21,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 6,
"CategoryName": "Meat/Poultry",
"Description": "Prepared meats"
ProductID: 54,
ProductName: 'Tourtière',
SupplierID: 25,
CategoryID: 6,
QuantityPerUnit: '16 pies',
UnitPrice: 7.4500,
UnitsInStock: 21,
UnitsOnOrder: 0,
ReorderLevel: 10,
Discontinued: false,
Category: {
CategoryID: 6,
CategoryName: 'Meat/Poultry',
Description: 'Prepared meats'
}
}, {
"ProductID": 55,
"ProductName": "Pâté chinois",
"SupplierID": 25,
"CategoryID": 6,
"QuantityPerUnit": "24 boxes x 2 pies",
"UnitPrice": 24.0000,
"UnitsInStock": 115,
"UnitsOnOrder": 0,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 6,
"CategoryName": "Meat/Poultry",
"Description": "Prepared meats"
ProductID: 55,
ProductName: 'Pâté chinois',
SupplierID: 25,
CategoryID: 6,
QuantityPerUnit: '24 boxes x 2 pies',
UnitPrice: 24.0000,
UnitsInStock: 115,
UnitsOnOrder: 0,
ReorderLevel: 20,
Discontinued: false,
Category: {
CategoryID: 6,
CategoryName: 'Meat/Poultry',
Description: 'Prepared meats'
}
}, {
"ProductID": 56,
"ProductName": "Gnocchi di nonna Alice",
"SupplierID": 26,
"CategoryID": 5,
"QuantityPerUnit": "24 - 250 g pkgs.",
"UnitPrice": 38.0000,
"UnitsInStock": 21,
"UnitsOnOrder": 10,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 5,
"CategoryName": "Grains/Cereals",
"Description": "Breads, crackers, pasta, and cereal"
ProductID: 56,
ProductName: 'Gnocchi di nonna Alice',
SupplierID: 26,
CategoryID: 5,
QuantityPerUnit: '24 - 250 g pkgs.',
UnitPrice: 38.0000,
UnitsInStock: 21,
UnitsOnOrder: 10,
ReorderLevel: 30,
Discontinued: false,
Category: {
CategoryID: 5,
CategoryName: 'Grains/Cereals',
Description: 'Breads, crackers, pasta, and cereal'
}
}, {
"ProductID": 57,
"ProductName": "Ravioli Angelo",
"SupplierID": 26,
"CategoryID": 5,
"QuantityPerUnit": "24 - 250 g pkgs.",
"UnitPrice": 19.5000,
"UnitsInStock": 36,
"UnitsOnOrder": 0,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 5,
"CategoryName": "Grains/Cereals",
"Description": "Breads, crackers, pasta, and cereal"
ProductID: 57,
ProductName: 'Ravioli Angelo',
SupplierID: 26,
CategoryID: 5,
QuantityPerUnit: '24 - 250 g pkgs.',
UnitPrice: 19.5000,
UnitsInStock: 36,
UnitsOnOrder: 0,
ReorderLevel: 20,
Discontinued: false,
Category: {
CategoryID: 5,
CategoryName: 'Grains/Cereals',
Description: 'Breads, crackers, pasta, and cereal'
}
}, {
"ProductID": 58,
"ProductName": "Escargots de Bourgogne",
"SupplierID": 27,
"CategoryID": 8,
"QuantityPerUnit": "24 pieces",
"UnitPrice": 13.2500,
"UnitsInStock": 62,
"UnitsOnOrder": 0,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 58,
ProductName: 'Escargots de Bourgogne',
SupplierID: 27,
CategoryID: 8,
QuantityPerUnit: '24 pieces',
UnitPrice: 13.2500,
UnitsInStock: 62,
UnitsOnOrder: 0,
ReorderLevel: 20,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 59,
"ProductName": "Raclette Courdavault",
"SupplierID": 28,
"CategoryID": 4,
"QuantityPerUnit": "5 kg pkg.",
"UnitPrice": 55.0000,
"UnitsInStock": 79,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
ProductID: 59,
ProductName: 'Raclette Courdavault',
SupplierID: 28,
CategoryID: 4,
QuantityPerUnit: '5 kg pkg.',
UnitPrice: 55.0000,
UnitsInStock: 79,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 4,
CategoryName: 'Dairy Products',
Description: 'Cheeses'
}
}, {
"ProductID": 60,
"ProductName": "Camembert Pierrot",
"SupplierID": 28,
"CategoryID": 4,
"QuantityPerUnit": "15 - 300 g rounds",
"UnitPrice": 34.0000,
"UnitsInStock": 19,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
ProductID: 60,
ProductName: 'Camembert Pierrot',
SupplierID: 28,
CategoryID: 4,
QuantityPerUnit: '15 - 300 g rounds',
UnitPrice: 34.0000,
UnitsInStock: 19,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 4,
CategoryName: 'Dairy Products',
Description: 'Cheeses'
}
}, {
"ProductID": 61,
"ProductName": "Sirop d'érable",
"SupplierID": 29,
"CategoryID": 2,
"QuantityPerUnit": "24 - 500 ml bottles",
"UnitPrice": 28.5000,
"UnitsInStock": 113,
"UnitsOnOrder": 0,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 61,
ProductName: 'Sirop dérable',
SupplierID: 29,
CategoryID: 2,
QuantityPerUnit: '24 - 500 ml bottles',
UnitPrice: 28.5000,
UnitsInStock: 113,
UnitsOnOrder: 0,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}, {
"ProductID": 62,
"ProductName": "Tarte au sucre",
"SupplierID": 29,
"CategoryID": 3,
"QuantityPerUnit": "48 pies",
"UnitPrice": 49.3000,
"UnitsInStock": 17,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 62,
ProductName: 'Tarte au sucre',
SupplierID: 29,
CategoryID: 3,
QuantityPerUnit: '48 pies',
UnitPrice: 49.3000,
UnitsInStock: 17,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 63,
"ProductName": "Vegie-spread",
"SupplierID": 7,
"CategoryID": 2,
"QuantityPerUnit": "15 - 625 g jars",
"UnitPrice": 43.9000,
"UnitsInStock": 24,
"UnitsOnOrder": 0,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 63,
ProductName: 'Vegie-spread',
SupplierID: 7,
CategoryID: 2,
QuantityPerUnit: '15 - 625 g jars',
UnitPrice: 43.9000,
UnitsInStock: 24,
UnitsOnOrder: 0,
ReorderLevel: 5,
Discontinued: false,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}, {
"ProductID": 64,
"ProductName": "Wimmers gute Semmelknödel",
"SupplierID": 12,
"CategoryID": 5,
"QuantityPerUnit": "20 bags x 4 pieces",
"UnitPrice": 33.2500,
"UnitsInStock": 22,
"UnitsOnOrder": 80,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 5,
"CategoryName": "Grains/Cereals",
"Description": "Breads, crackers, pasta, and cereal"
ProductID: 64,
ProductName: 'Wimmers gute Semmelknödel',
SupplierID: 12,
CategoryID: 5,
QuantityPerUnit: '20 bags x 4 pieces',
UnitPrice: 33.2500,
UnitsInStock: 22,
UnitsOnOrder: 80,
ReorderLevel: 30,
Discontinued: false,
Category: {
CategoryID: 5,
CategoryName: 'Grains/Cereals',
Description: 'Breads, crackers, pasta, and cereal'
}
}, {
"ProductID": 65,
"ProductName": "Louisiana Fiery Hot Pepper Sauce",
"SupplierID": 2,
"CategoryID": 2,
"QuantityPerUnit": "32 - 8 oz bottles",
"UnitPrice": 21.0500,
"UnitsInStock": 76,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 65,
ProductName: 'Louisiana Fiery Hot Pepper Sauce',
SupplierID: 2,
CategoryID: 2,
QuantityPerUnit: '32 - 8 oz bottles',
UnitPrice: 21.0500,
UnitsInStock: 76,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}, {
"ProductID": 66,
"ProductName": "Louisiana Hot Spiced Okra",
"SupplierID": 2,
"CategoryID": 2,
"QuantityPerUnit": "24 - 8 oz jars",
"UnitPrice": 17.0000,
"UnitsInStock": 4,
"UnitsOnOrder": 100,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 66,
ProductName: 'Louisiana Hot Spiced Okra',
SupplierID: 2,
CategoryID: 2,
QuantityPerUnit: '24 - 8 oz jars',
UnitPrice: 17.0000,
UnitsInStock: 4,
UnitsOnOrder: 100,
ReorderLevel: 20,
Discontinued: false,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}, {
"ProductID": 67,
"ProductName": "Laughing Lumberjack Lager",
"SupplierID": 16,
"CategoryID": 1,
"QuantityPerUnit": "24 - 12 oz bottles",
"UnitPrice": 14.0000,
"UnitsInStock": 52,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
ProductID: 67,
ProductName: 'Laughing Lumberjack Lager',
SupplierID: 16,
CategoryID: 1,
QuantityPerUnit: '24 - 12 oz bottles',
UnitPrice: 14.0000,
UnitsInStock: 52,
UnitsOnOrder: 0,
ReorderLevel: 10,
Discontinued: false,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 68,
"ProductName": "Scottish Longbreads",
"SupplierID": 8,
"CategoryID": 3,
"QuantityPerUnit": "10 boxes x 8 pieces",
"UnitPrice": 12.5000,
"UnitsInStock": 6,
"UnitsOnOrder": 10,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 68,
ProductName: 'Scottish Longbreads',
SupplierID: 8,
CategoryID: 3,
QuantityPerUnit: '10 boxes x 8 pieces',
UnitPrice: 12.5000,
UnitsInStock: 6,
UnitsOnOrder: 10,
ReorderLevel: 15,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 69,
"ProductName": "Gudbrandsdalsost",
"SupplierID": 15,
"CategoryID": 4,
"QuantityPerUnit": "10 kg pkg.",
"UnitPrice": 36.0000,
"UnitsInStock": 26,
"UnitsOnOrder": 0,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
ProductID: 69,
ProductName: 'Gudbrandsdalsost',
SupplierID: 15,
CategoryID: 4,
QuantityPerUnit: '10 kg pkg.',
UnitPrice: 36.0000,
UnitsInStock: 26,
UnitsOnOrder: 0,
ReorderLevel: 15,
Discontinued: false,
Category: {
CategoryID: 4,
CategoryName: 'Dairy Products',
Description: 'Cheeses'
}
}, {
"ProductID": 70,
"ProductName": "Outback Lager",
"SupplierID": 7,
"CategoryID": 1,
"QuantityPerUnit": "24 - 355 ml bottles",
"UnitPrice": 15.0000,
"UnitsInStock": 15,
"UnitsOnOrder": 10,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
ProductID: 70,
ProductName: 'Outback Lager',
SupplierID: 7,
CategoryID: 1,
QuantityPerUnit: '24 - 355 ml bottles',
UnitPrice: 15.0000,
UnitsInStock: 15,
UnitsOnOrder: 10,
ReorderLevel: 30,
Discontinued: false,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 71,
"ProductName": "Flotemysost",
"SupplierID": 15,
"CategoryID": 4,
"QuantityPerUnit": "10 - 500 g pkgs.",
"UnitPrice": 21.5000,
"UnitsInStock": 26,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
ProductID: 71,
ProductName: 'Flotemysost',
SupplierID: 15,
CategoryID: 4,
QuantityPerUnit: '10 - 500 g pkgs.',
UnitPrice: 21.5000,
UnitsInStock: 26,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 4,
CategoryName: 'Dairy Products',
Description: 'Cheeses'
}
}, {
"ProductID": 72,
"ProductName": "Mozzarella di Giovanni",
"SupplierID": 14,
"CategoryID": 4,
"QuantityPerUnit": "24 - 200 g pkgs.",
"UnitPrice": 34.8000,
"UnitsInStock": 14,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
ProductID: 72,
ProductName: 'Mozzarella di Giovanni',
SupplierID: 14,
CategoryID: 4,
QuantityPerUnit: '24 - 200 g pkgs.',
UnitPrice: 34.8000,
UnitsInStock: 14,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 4,
CategoryName: 'Dairy Products',
Description: 'Cheeses'
}
}, {
"ProductID": 73,
"ProductName": "Röd Kaviar",
"SupplierID": 17,
"CategoryID": 8,
"QuantityPerUnit": "24 - 150 g jars",
"UnitPrice": 15.0000,
"UnitsInStock": 101,
"UnitsOnOrder": 0,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 73,
ProductName: 'Röd Kaviar',
SupplierID: 17,
CategoryID: 8,
QuantityPerUnit: '24 - 150 g jars',
UnitPrice: 15.0000,
UnitsInStock: 101,
UnitsOnOrder: 0,
ReorderLevel: 5,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 74,
"ProductName": "Longlife Tofu",
"SupplierID": 4,
"CategoryID": 7,
"QuantityPerUnit": "5 kg pkg.",
"UnitPrice": 10.0000,
"UnitsInStock": 4,
"UnitsOnOrder": 20,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 7,
"CategoryName": "Produce",
"Description": "Dried fruit and bean curd"
ProductID: 74,
ProductName: 'Longlife Tofu',
SupplierID: 4,
CategoryID: 7,
QuantityPerUnit: '5 kg pkg.',
UnitPrice: 10.0000,
UnitsInStock: 4,
UnitsOnOrder: 20,
ReorderLevel: 5,
Discontinued: false,
Category: {
CategoryID: 7,
CategoryName: 'Produce',
Description: 'Dried fruit and bean curd'
}
}, {
"ProductID": 75,
"ProductName": "Rhönbräu Klosterbier",
"SupplierID": 12,
"CategoryID": 1,
"QuantityPerUnit": "24 - 0.5 l bottles",
"UnitPrice": 7.7500,
"UnitsInStock": 125,
"UnitsOnOrder": 0,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
ProductID: 75,
ProductName: 'Rhönbräu Klosterbier',
SupplierID: 12,
CategoryID: 1,
QuantityPerUnit: '24 - 0.5 l bottles',
UnitPrice: 7.7500,
UnitsInStock: 125,
UnitsOnOrder: 0,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 76,
"ProductName": "Lakkalikööri",
"SupplierID": 23,
"CategoryID": 1,
"QuantityPerUnit": "500 ml",
"UnitPrice": 18.0000,
"UnitsInStock": 57,
"UnitsOnOrder": 0,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
ProductID: 76,
ProductName: 'Lakkalikööri',
SupplierID: 23,
CategoryID: 1,
QuantityPerUnit: '500 ml',
UnitPrice: 18.0000,
UnitsInStock: 57,
UnitsOnOrder: 0,
ReorderLevel: 20,
Discontinued: false,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 77,
"ProductName": "Original Frankfurter grüne Soße",
"SupplierID": 12,
"CategoryID": 2,
"QuantityPerUnit": "12 boxes",
"UnitPrice": 13.0000,
"UnitsInStock": 32,
"UnitsOnOrder": 0,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 77,
ProductName: 'Original Frankfurter grüne Soße',
SupplierID: 12,
CategoryID: 2,
QuantityPerUnit: '12 boxes',
UnitPrice: 13.0000,
UnitsInStock: 32,
UnitsOnOrder: 0,
ReorderLevel: 15,
Discontinued: false,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}];`;

@@ -1,1233 +0,1233 @@

export const products = `[{
"ProductID": 1,
"ProductName": "Chai",
"SupplierID": 1,
"CategoryID": 1,
"QuantityPerUnit": "10 boxes x 20 bags",
"UnitPrice": 18.0000,
"UnitsInStock": 39,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
export const productsSourceCode = `export const products = [{
ProductID: 1,
ProductName: 'Chai',
SupplierID: 1,
CategoryID: 1,
QuantityPerUnit: '10 boxes x 20 bags',
UnitPrice: 18.0000,
UnitsInStock: 39,
UnitsOnOrder: 0,
ReorderLevel: 10,
Discontinued: false,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 2,
"ProductName": "Chang",
"SupplierID": 1,
"CategoryID": 1,
"QuantityPerUnit": "24 - 12 oz bottles",
"UnitPrice": 19.0000,
"UnitsInStock": 17,
"UnitsOnOrder": 40,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
ProductID: 2,
ProductName: 'Chang',
SupplierID: 1,
CategoryID: 1,
QuantityPerUnit: '24 - 12 oz bottles',
UnitPrice: 19.0000,
UnitsInStock: 17,
UnitsOnOrder: 40,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 3,
"ProductName": "Aniseed Syrup",
"SupplierID": 1,
"CategoryID": 2,
"QuantityPerUnit": "12 - 550 ml bottles",
"UnitPrice": 10.0000,
"UnitsInStock": 13,
"UnitsOnOrder": 70,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 3,
ProductName: 'Aniseed Syrup',
SupplierID: 1,
CategoryID: 2,
QuantityPerUnit: '12 - 550 ml bottles',
UnitPrice: 10.0000,
UnitsInStock: 13,
UnitsOnOrder: 70,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}, {
"ProductID": 4,
"ProductName": "Chef Anton's Cajun Seasoning",
"SupplierID": 2,
"CategoryID": 2,
"QuantityPerUnit": "48 - 6 oz jars",
"UnitPrice": 22.0000,
"UnitsInStock": 53,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 4,
ProductName: 'Chef Antons Cajun Seasoning',
SupplierID: 2,
CategoryID: 2,
QuantityPerUnit: '48 - 6 oz jars',
UnitPrice: 22.0000,
UnitsInStock: 53,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}, {
"ProductID": 5,
"ProductName": "Chef Anton's Gumbo Mix",
"SupplierID": 2,
"CategoryID": 2,
"QuantityPerUnit": "36 boxes",
"UnitPrice": 21.3500,
"UnitsInStock": 0,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 5,
ProductName: 'Chef Antons Gumbo Mix',
SupplierID: 2,
CategoryID: 2,
QuantityPerUnit: '36 boxes',
UnitPrice: 21.3500,
UnitsInStock: 0,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: true,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}, {
"ProductID": 6,
"ProductName": "Grandma's Boysenberry Spread",
"SupplierID": 3,
"CategoryID": 2,
"QuantityPerUnit": "12 - 8 oz jars",
"UnitPrice": 25.0000,
"UnitsInStock": 120,
"UnitsOnOrder": 0,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 6,
ProductName: 'Grandmas Boysenberry Spread',
SupplierID: 3,
CategoryID: 2,
QuantityPerUnit: '12 - 8 oz jars',
UnitPrice: 25.0000,
UnitsInStock: 120,
UnitsOnOrder: 0,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}, {
"ProductID": 7,
"ProductName": "Uncle Bob's Organic Dried Pears",
"SupplierID": 3,
"CategoryID": 7,
"QuantityPerUnit": "12 - 1 lb pkgs.",
"UnitPrice": 30.0000,
"UnitsInStock": 15,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 7,
"CategoryName": "Produce",
"Description": "Dried fruit and bean curd"
ProductID: 7,
ProductName: 'Uncle Bobs Organic Dried Pears',
SupplierID: 3,
CategoryID: 7,
QuantityPerUnit: '12 - 1 lb pkgs.',
UnitPrice: 30.0000,
UnitsInStock: 15,
UnitsOnOrder: 0,
ReorderLevel: 10,
Discontinued: false,
Category: {
CategoryID: 7,
CategoryName: 'Produce',
Description: 'Dried fruit and bean curd'
}
}, {
"ProductID": 8,
"ProductName": "Northwoods Cranberry Sauce",
"SupplierID": 3,
"CategoryID": 2,
"QuantityPerUnit": "12 - 12 oz jars",
"UnitPrice": 40.0000,
"UnitsInStock": 6,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 8,
ProductName: 'Northwoods Cranberry Sauce',
SupplierID: 3,
CategoryID: 2,
QuantityPerUnit: '12 - 12 oz jars',
UnitPrice: 40.0000,
UnitsInStock: 6,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}, {
"ProductID": 9,
"ProductName": "Mishi Kobe Niku",
"SupplierID": 4,
"CategoryID": 6,
"QuantityPerUnit": "18 - 500 g pkgs.",
"UnitPrice": 97.0000,
"UnitsInStock": 29,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 6,
"CategoryName": "Meat/Poultry",
"Description": "Prepared meats"
ProductID: 9,
ProductName: 'Mishi Kobe Niku',
SupplierID: 4,
CategoryID: 6,
QuantityPerUnit: '18 - 500 g pkgs.',
UnitPrice: 97.0000,
UnitsInStock: 29,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: true,
Category: {
CategoryID: 6,
CategoryName: 'Meat/Poultry',
Description: 'Prepared meats'
}
}, {
"ProductID": 10,
"ProductName": "Ikura",
"SupplierID": 4,
"CategoryID": 8,
"QuantityPerUnit": "12 - 200 ml jars",
"UnitPrice": 31.0000,
"UnitsInStock": 31,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 10,
ProductName: 'Ikura',
SupplierID: 4,
CategoryID: 8,
QuantityPerUnit: '12 - 200 ml jars',
UnitPrice: 31.0000,
UnitsInStock: 31,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 11,
"ProductName": "Queso Cabrales",
"SupplierID": 5,
"CategoryID": 4,
"QuantityPerUnit": "1 kg pkg.",
"UnitPrice": 21.0000,
"UnitsInStock": 22,
"UnitsOnOrder": 30,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
ProductID: 11,
ProductName: 'Queso Cabrales',
SupplierID: 5,
CategoryID: 4,
QuantityPerUnit: '1 kg pkg.',
UnitPrice: 21.0000,
UnitsInStock: 22,
UnitsOnOrder: 30,
ReorderLevel: 30,
Discontinued: false,
Category: {
CategoryID: 4,
CategoryName: 'Dairy Products',
Description: 'Cheeses'
}
}, {
"ProductID": 12,
"ProductName": "Queso Manchego La Pastora",
"SupplierID": 5,
"CategoryID": 4,
"QuantityPerUnit": "10 - 500 g pkgs.",
"UnitPrice": 38.0000,
"UnitsInStock": 86,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
ProductID: 12,
ProductName: 'Queso Manchego La Pastora',
SupplierID: 5,
CategoryID: 4,
QuantityPerUnit: '10 - 500 g pkgs.',
UnitPrice: 38.0000,
UnitsInStock: 86,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 4,
CategoryName: 'Dairy Products',
Description: 'Cheeses'
}
}, {
"ProductID": 13,
"ProductName": "Konbu",
"SupplierID": 6,
"CategoryID": 8,
"QuantityPerUnit": "2 kg box",
"UnitPrice": 6.0000,
"UnitsInStock": 24,
"UnitsOnOrder": 0,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 13,
ProductName: 'Konbu',
SupplierID: 6,
CategoryID: 8,
QuantityPerUnit: '2 kg box',
UnitPrice: 6.0000,
UnitsInStock: 24,
UnitsOnOrder: 0,
ReorderLevel: 5,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 14,
"ProductName": "Tofu",
"SupplierID": 6,
"CategoryID": 7,
"QuantityPerUnit": "40 - 100 g pkgs.",
"UnitPrice": 23.2500,
"UnitsInStock": 35,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 7,
"CategoryName": "Produce",
"Description": "Dried fruit and bean curd"
ProductID: 14,
ProductName: 'Tofu',
SupplierID: 6,
CategoryID: 7,
QuantityPerUnit: '40 - 100 g pkgs.',
UnitPrice: 23.2500,
UnitsInStock: 35,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 7,
CategoryName: 'Produce',
Description: 'Dried fruit and bean curd'
}
}, {
"ProductID": 15,
"ProductName": "Genen Shouyu",
"SupplierID": 6,
"CategoryID": 2,
"QuantityPerUnit": "24 - 250 ml bottles",
"UnitPrice": 15.5000,
"UnitsInStock": 39,
"UnitsOnOrder": 0,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 15,
ProductName: 'Genen Shouyu',
SupplierID: 6,
CategoryID: 2,
QuantityPerUnit: '24 - 250 ml bottles',
UnitPrice: 15.5000,
UnitsInStock: 39,
UnitsOnOrder: 0,
ReorderLevel: 5,
Discontinued: false,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}, {
"ProductID": 16,
"ProductName": "Pavlova",
"SupplierID": 7,
"CategoryID": 3,
"QuantityPerUnit": "32 - 500 g boxes",
"UnitPrice": 17.4500,
"UnitsInStock": 29,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 16,
ProductName: 'Pavlova',
SupplierID: 7,
CategoryID: 3,
QuantityPerUnit: '32 - 500 g boxes',
UnitPrice: 17.4500,
UnitsInStock: 29,
UnitsOnOrder: 0,
ReorderLevel: 10,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 17,
"ProductName": "Alice Mutton",
"SupplierID": 7,
"CategoryID": 6,
"QuantityPerUnit": "20 - 1 kg tins",
"UnitPrice": 39.0000,
"UnitsInStock": 0,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 6,
"CategoryName": "Meat/Poultry",
"Description": "Prepared meats"
ProductID: 17,
ProductName: 'Alice Mutton',
SupplierID: 7,
CategoryID: 6,
QuantityPerUnit: '20 - 1 kg tins',
UnitPrice: 39.0000,
UnitsInStock: 0,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: true,
Category: {
CategoryID: 6,
CategoryName: 'Meat/Poultry',
Description: 'Prepared meats'
}
}, {
"ProductID": 18,
"ProductName": "Carnarvon Tigers",
"SupplierID": 7,
"CategoryID": 8,
"QuantityPerUnit": "16 kg pkg.",
"UnitPrice": 62.5000,
"UnitsInStock": 42,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 18,
ProductName: 'Carnarvon Tigers',
SupplierID: 7,
CategoryID: 8,
QuantityPerUnit: '16 kg pkg.',
UnitPrice: 62.5000,
UnitsInStock: 42,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 19,
"ProductName": "Teatime Chocolate Biscuits",
"SupplierID": 8,
"CategoryID": 3,
"QuantityPerUnit": "10 boxes x 12 pieces",
"UnitPrice": 9.2000,
"UnitsInStock": 25,
"UnitsOnOrder": 0,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 19,
ProductName: 'Teatime Chocolate Biscuits',
SupplierID: 8,
CategoryID: 3,
QuantityPerUnit: '10 boxes x 12 pieces',
UnitPrice: 9.2000,
UnitsInStock: 25,
UnitsOnOrder: 0,
ReorderLevel: 5,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 20,
"ProductName": "Sir Rodney's Marmalade",
"SupplierID": 8,
"CategoryID": 3,
"QuantityPerUnit": "30 gift boxes",
"UnitPrice": 81.0000,
"UnitsInStock": 40,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 20,
ProductName: 'Sir Rodneys Marmalade',
SupplierID: 8,
CategoryID: 3,
QuantityPerUnit: '30 gift boxes',
UnitPrice: 81.0000,
UnitsInStock: 40,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 21,
"ProductName": "Sir Rodney's Scones",
"SupplierID": 8,
"CategoryID": 3,
"QuantityPerUnit": "24 pkgs. x 4 pieces",
"UnitPrice": 10.0000,
"UnitsInStock": 3,
"UnitsOnOrder": 40,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 21,
ProductName: 'Sir Rodneys Scones',
SupplierID: 8,
CategoryID: 3,
QuantityPerUnit: '24 pkgs. x 4 pieces',
UnitPrice: 10.0000,
UnitsInStock: 3,
UnitsOnOrder: 40,
ReorderLevel: 5,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 22,
"ProductName": "Gustaf's Knäckebröd",
"SupplierID": 9,
"CategoryID": 5,
"QuantityPerUnit": "24 - 500 g pkgs.",
"UnitPrice": 21.0000,
"UnitsInStock": 104,
"UnitsOnOrder": 0,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 5,
"CategoryName": "Grains/Cereals",
"Description": "Breads, crackers, pasta, and cereal"
ProductID: 22,
ProductName: 'Gustafs Knäckebröd',
SupplierID: 9,
CategoryID: 5,
QuantityPerUnit: '24 - 500 g pkgs.',
UnitPrice: 21.0000,
UnitsInStock: 104,
UnitsOnOrder: 0,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 5,
CategoryName: 'Grains/Cereals',
Description: 'Breads, crackers, pasta, and cereal'
}
}, {
"ProductID": 23,
"ProductName": "Tunnbröd",
"SupplierID": 9,
"CategoryID": 5,
"QuantityPerUnit": "12 - 250 g pkgs.",
"UnitPrice": 9.0000,
"UnitsInStock": 61,
"UnitsOnOrder": 0,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 5,
"CategoryName": "Grains/Cereals",
"Description": "Breads, crackers, pasta, and cereal"
ProductID: 23,
ProductName: 'Tunnbröd',
SupplierID: 9,
CategoryID: 5,
QuantityPerUnit: '12 - 250 g pkgs.',
UnitPrice: 9.0000,
UnitsInStock: 61,
UnitsOnOrder: 0,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 5,
CategoryName: 'Grains/Cereals',
Description: 'Breads, crackers, pasta, and cereal'
}
}, {
"ProductID": 24,
"ProductName": "Guaraná Fantástica",
"SupplierID": 10,
"CategoryID": 1,
"QuantityPerUnit": "12 - 355 ml cans",
"UnitPrice": 4.5000,
"UnitsInStock": 20,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
ProductID: 24,
ProductName: 'Guaraná Fantástica',
SupplierID: 10,
CategoryID: 1,
QuantityPerUnit: '12 - 355 ml cans',
UnitPrice: 4.5000,
UnitsInStock: 20,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: true,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 25,
"ProductName": "NuNuCa Nuß-Nougat-Creme",
"SupplierID": 11,
"CategoryID": 3,
"QuantityPerUnit": "20 - 450 g glasses",
"UnitPrice": 14.0000,
"UnitsInStock": 76,
"UnitsOnOrder": 0,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 25,
ProductName: 'NuNuCa Nuß-Nougat-Creme',
SupplierID: 11,
CategoryID: 3,
QuantityPerUnit: '20 - 450 g glasses',
UnitPrice: 14.0000,
UnitsInStock: 76,
UnitsOnOrder: 0,
ReorderLevel: 30,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 26,
"ProductName": "Gumbär Gummibärchen",
"SupplierID": 11,
"CategoryID": 3,
"QuantityPerUnit": "100 - 250 g bags",
"UnitPrice": 31.2300,
"UnitsInStock": 15,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 26,
ProductName: 'Gumbär Gummibärchen',
SupplierID: 11,
CategoryID: 3,
QuantityPerUnit: '100 - 250 g bags',
UnitPrice: 31.2300,
UnitsInStock: 15,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 27,
"ProductName": "Schoggi Schokolade",
"SupplierID": 11,
"CategoryID": 3,
"QuantityPerUnit": "100 - 100 g pieces",
"UnitPrice": 43.9000,
"UnitsInStock": 49,
"UnitsOnOrder": 0,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 27,
ProductName: 'Schoggi Schokolade',
SupplierID: 11,
CategoryID: 3,
QuantityPerUnit: '100 - 100 g pieces',
UnitPrice: 43.9000,
UnitsInStock: 49,
UnitsOnOrder: 0,
ReorderLevel: 30,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 28,
"ProductName": "Rössle Sauerkraut",
"SupplierID": 12,
"CategoryID": 7,
"QuantityPerUnit": "25 - 825 g cans",
"UnitPrice": 45.6000,
"UnitsInStock": 26,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 7,
"CategoryName": "Produce",
"Description": "Dried fruit and bean curd"
ProductID: 28,
ProductName: 'Rössle Sauerkraut',
SupplierID: 12,
CategoryID: 7,
QuantityPerUnit: '25 - 825 g cans',
UnitPrice: 45.6000,
UnitsInStock: 26,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: true,
Category: {
CategoryID: 7,
CategoryName: 'Produce',
Description: 'Dried fruit and bean curd'
}
}, {
"ProductID": 29,
"ProductName": "Thüringer Rostbratwurst",
"SupplierID": 12,
"CategoryID": 6,
"QuantityPerUnit": "50 bags x 30 sausgs.",
"UnitPrice": 123.7900,
"UnitsInStock": 0,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 6,
"CategoryName": "Meat/Poultry",
"Description": "Prepared meats"
ProductID: 29,
ProductName: 'Thüringer Rostbratwurst',
SupplierID: 12,
CategoryID: 6,
QuantityPerUnit: '50 bags x 30 sausgs.',
UnitPrice: 123.7900,
UnitsInStock: 0,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: true,
Category: {
CategoryID: 6,
CategoryName: 'Meat/Poultry',
Description: 'Prepared meats'
}
}, {
"ProductID": 30,
"ProductName": "Nord-Ost Matjeshering",
"SupplierID": 13,
"CategoryID": 8,
"QuantityPerUnit": "10 - 200 g glasses",
"UnitPrice": 25.8900,
"UnitsInStock": 10,
"UnitsOnOrder": 0,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 30,
ProductName: 'Nord-Ost Matjeshering',
SupplierID: 13,
CategoryID: 8,
QuantityPerUnit: '10 - 200 g glasses',
UnitPrice: 25.8900,
UnitsInStock: 10,
UnitsOnOrder: 0,
ReorderLevel: 15,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 31,
"ProductName": "Gorgonzola Telino",
"SupplierID": 14,
"CategoryID": 4,
"QuantityPerUnit": "12 - 100 g pkgs",
"UnitPrice": 12.5000,
"UnitsInStock": 0,
"UnitsOnOrder": 70,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
ProductID: 31,
ProductName: 'Gorgonzola Telino',
SupplierID: 14,
CategoryID: 4,
QuantityPerUnit: '12 - 100 g pkgs',
UnitPrice: 12.5000,
UnitsInStock: 0,
UnitsOnOrder: 70,
ReorderLevel: 20,
Discontinued: false,
Category: {
CategoryID: 4,
CategoryName: 'Dairy Products',
Description: 'Cheeses'
}
}, {
"ProductID": 32,
"ProductName": "Mascarpone Fabioli",
"SupplierID": 14,
"CategoryID": 4,
"QuantityPerUnit": "24 - 200 g pkgs.",
"UnitPrice": 32.0000,
"UnitsInStock": 9,
"UnitsOnOrder": 40,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
ProductID: 32,
ProductName: 'Mascarpone Fabioli',
SupplierID: 14,
CategoryID: 4,
QuantityPerUnit: '24 - 200 g pkgs.',
UnitPrice: 32.0000,
UnitsInStock: 9,
UnitsOnOrder: 40,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 4,
CategoryName: 'Dairy Products',
Description: 'Cheeses'
}
}, {
"ProductID": 33,
"ProductName": "Geitost",
"SupplierID": 15,
"CategoryID": 4,
"QuantityPerUnit": "500 g",
"UnitPrice": 2.5000,
"UnitsInStock": 112,
"UnitsOnOrder": 0,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
ProductID: 33,
ProductName: 'Geitost',
SupplierID: 15,
CategoryID: 4,
QuantityPerUnit: '500 g',
UnitPrice: 2.5000,
UnitsInStock: 112,
UnitsOnOrder: 0,
ReorderLevel: 20,
Discontinued: false,
Category: {
CategoryID: 4,
CategoryName: 'Dairy Products',
Description: 'Cheeses'
}
}, {
"ProductID": 34,
"ProductName": "Sasquatch Ale",
"SupplierID": 16,
"CategoryID": 1,
"QuantityPerUnit": "24 - 12 oz bottles",
"UnitPrice": 14.0000,
"UnitsInStock": 111,
"UnitsOnOrder": 0,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
ProductID: 34,
ProductName: 'Sasquatch Ale',
SupplierID: 16,
CategoryID: 1,
QuantityPerUnit: '24 - 12 oz bottles',
UnitPrice: 14.0000,
UnitsInStock: 111,
UnitsOnOrder: 0,
ReorderLevel: 15,
Discontinued: false,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 35,
"ProductName": "Steeleye Stout",
"SupplierID": 16,
"CategoryID": 1,
"QuantityPerUnit": "24 - 12 oz bottles",
"UnitPrice": 18.0000,
"UnitsInStock": 20,
"UnitsOnOrder": 0,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
ProductID: 35,
ProductName: 'Steeleye Stout',
SupplierID: 16,
CategoryID: 1,
QuantityPerUnit: '24 - 12 oz bottles',
UnitPrice: 18.0000,
UnitsInStock: 20,
UnitsOnOrder: 0,
ReorderLevel: 15,
Discontinued: false,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 36,
"ProductName": "Inlagd Sill",
"SupplierID": 17,
"CategoryID": 8,
"QuantityPerUnit": "24 - 250 g jars",
"UnitPrice": 19.0000,
"UnitsInStock": 112,
"UnitsOnOrder": 0,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 36,
ProductName: 'Inlagd Sill',
SupplierID: 17,
CategoryID: 8,
QuantityPerUnit: '24 - 250 g jars',
UnitPrice: 19.0000,
UnitsInStock: 112,
UnitsOnOrder: 0,
ReorderLevel: 20,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 37,
"ProductName": "Gravad lax",
"SupplierID": 17,
"CategoryID": 8,
"QuantityPerUnit": "12 - 500 g pkgs.",
"UnitPrice": 26.0000,
"UnitsInStock": 11,
"UnitsOnOrder": 50,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 37,
ProductName: 'Gravad lax',
SupplierID: 17,
CategoryID: 8,
QuantityPerUnit: '12 - 500 g pkgs.',
UnitPrice: 26.0000,
UnitsInStock: 11,
UnitsOnOrder: 50,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 38,
"ProductName": "Côte de Blaye",
"SupplierID": 18,
"CategoryID": 1,
"QuantityPerUnit": "12 - 75 cl bottles",
"UnitPrice": 263.5000,
"UnitsInStock": 17,
"UnitsOnOrder": 0,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
ProductID: 38,
ProductName: 'Côte de Blaye',
SupplierID: 18,
CategoryID: 1,
QuantityPerUnit: '12 - 75 cl bottles',
UnitPrice: 263.5000,
UnitsInStock: 17,
UnitsOnOrder: 0,
ReorderLevel: 15,
Discontinued: false,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 39,
"ProductName": "Chartreuse verte",
"SupplierID": 18,
"CategoryID": 1,
"QuantityPerUnit": "750 cc per bottle",
"UnitPrice": 18.0000,
"UnitsInStock": 69,
"UnitsOnOrder": 0,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
ProductID: 39,
ProductName: 'Chartreuse verte',
SupplierID: 18,
CategoryID: 1,
QuantityPerUnit: '750 cc per bottle',
UnitPrice: 18.0000,
UnitsInStock: 69,
UnitsOnOrder: 0,
ReorderLevel: 5,
Discontinued: false,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 40,
"ProductName": "Boston Crab Meat",
"SupplierID": 19,
"CategoryID": 8,
"QuantityPerUnit": "24 - 4 oz tins",
"UnitPrice": 18.4000,
"UnitsInStock": 123,
"UnitsOnOrder": 0,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 40,
ProductName: 'Boston Crab Meat',
SupplierID: 19,
CategoryID: 8,
QuantityPerUnit: '24 - 4 oz tins',
UnitPrice: 18.4000,
UnitsInStock: 123,
UnitsOnOrder: 0,
ReorderLevel: 30,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 41,
"ProductName": "Jack's New England Clam Chowder",
"SupplierID": 19,
"CategoryID": 8,
"QuantityPerUnit": "12 - 12 oz cans",
"UnitPrice": 9.6500,
"UnitsInStock": 85,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 41,
ProductName: 'Jacks New England Clam Chowder',
SupplierID: 19,
CategoryID: 8,
QuantityPerUnit: '12 - 12 oz cans',
UnitPrice: 9.6500,
UnitsInStock: 85,
UnitsOnOrder: 0,
ReorderLevel: 10,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 42,
"ProductName": "Singaporean Hokkien Fried Mee",
"SupplierID": 20,
"CategoryID": 5,
"QuantityPerUnit": "32 - 1 kg pkgs.",
"UnitPrice": 14.0000,
"UnitsInStock": 26,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 5,
"CategoryName": "Grains/Cereals",
"Description": "Breads, crackers, pasta, and cereal"
ProductID: 42,
ProductName: 'Singaporean Hokkien Fried Mee',
SupplierID: 20,
CategoryID: 5,
QuantityPerUnit: '32 - 1 kg pkgs.',
UnitPrice: 14.0000,
UnitsInStock: 26,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: true,
Category: {
CategoryID: 5,
CategoryName: 'Grains/Cereals',
Description: 'Breads, crackers, pasta, and cereal'
}
}, {
"ProductID": 43,
"ProductName": "Ipoh Coffee",
"SupplierID": 20,
"CategoryID": 1,
"QuantityPerUnit": "16 - 500 g tins",
"UnitPrice": 46.0000,
"UnitsInStock": 17,
"UnitsOnOrder": 10,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
ProductID: 43,
ProductName: 'Ipoh Coffee',
SupplierID: 20,
CategoryID: 1,
QuantityPerUnit: '16 - 500 g tins',
UnitPrice: 46.0000,
UnitsInStock: 17,
UnitsOnOrder: 10,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 44,
"ProductName": "Gula Malacca",
"SupplierID": 20,
"CategoryID": 2,
"QuantityPerUnit": "20 - 2 kg bags",
"UnitPrice": 19.4500,
"UnitsInStock": 27,
"UnitsOnOrder": 0,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 44,
ProductName: 'Gula Malacca',
SupplierID: 20,
CategoryID: 2,
QuantityPerUnit: '20 - 2 kg bags',
UnitPrice: 19.4500,
UnitsInStock: 27,
UnitsOnOrder: 0,
ReorderLevel: 15,
Discontinued: false,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}, {
"ProductID": 45,
"ProductName": "Rogede sild",
"SupplierID": 21,
"CategoryID": 8,
"QuantityPerUnit": "1k pkg.",
"UnitPrice": 9.5000,
"UnitsInStock": 5,
"UnitsOnOrder": 70,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 45,
ProductName: 'Rogede sild',
SupplierID: 21,
CategoryID: 8,
QuantityPerUnit: '1k pkg.',
UnitPrice: 9.5000,
UnitsInStock: 5,
UnitsOnOrder: 70,
ReorderLevel: 15,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 46,
"ProductName": "Spegesild",
"SupplierID": 21,
"CategoryID": 8,
"QuantityPerUnit": "4 - 450 g glasses",
"UnitPrice": 12.0000,
"UnitsInStock": 95,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 46,
ProductName: 'Spegesild',
SupplierID: 21,
CategoryID: 8,
QuantityPerUnit: '4 - 450 g glasses',
UnitPrice: 12.0000,
UnitsInStock: 95,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 47,
"ProductName": "Zaanse koeken",
"SupplierID": 22,
"CategoryID": 3,
"QuantityPerUnit": "10 - 4 oz boxes",
"UnitPrice": 9.5000,
"UnitsInStock": 36,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 47,
ProductName: 'Zaanse koeken',
SupplierID: 22,
CategoryID: 3,
QuantityPerUnit: '10 - 4 oz boxes',
UnitPrice: 9.5000,
UnitsInStock: 36,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 48,
"ProductName": "Chocolade",
"SupplierID": 22,
"CategoryID": 3,
"QuantityPerUnit": "10 pkgs.",
"UnitPrice": 12.7500,
"UnitsInStock": 15,
"UnitsOnOrder": 70,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 48,
ProductName: 'Chocolade',
SupplierID: 22,
CategoryID: 3,
QuantityPerUnit: '10 pkgs.',
UnitPrice: 12.7500,
UnitsInStock: 15,
UnitsOnOrder: 70,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 49,
"ProductName": "Maxilaku",
"SupplierID": 23,
"CategoryID": 3,
"QuantityPerUnit": "24 - 50 g pkgs.",
"UnitPrice": 20.0000,
"UnitsInStock": 10,
"UnitsOnOrder": 60,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 49,
ProductName: 'Maxilaku',
SupplierID: 23,
CategoryID: 3,
QuantityPerUnit: '24 - 50 g pkgs.',
UnitPrice: 20.0000,
UnitsInStock: 10,
UnitsOnOrder: 60,
ReorderLevel: 15,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 50,
"ProductName": "Valkoinen suklaa",
"SupplierID": 23,
"CategoryID": 3,
"QuantityPerUnit": "12 - 100 g bars",
"UnitPrice": 16.2500,
"UnitsInStock": 65,
"UnitsOnOrder": 0,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 50,
ProductName: 'Valkoinen suklaa',
SupplierID: 23,
CategoryID: 3,
QuantityPerUnit: '12 - 100 g bars',
UnitPrice: 16.2500,
UnitsInStock: 65,
UnitsOnOrder: 0,
ReorderLevel: 30,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 51,
"ProductName": "Manjimup Dried Apples",
"SupplierID": 24,
"CategoryID": 7,
"QuantityPerUnit": "50 - 300 g pkgs.",
"UnitPrice": 53.0000,
"UnitsInStock": 20,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 7,
"CategoryName": "Produce",
"Description": "Dried fruit and bean curd"
ProductID: 51,
ProductName: 'Manjimup Dried Apples',
SupplierID: 24,
CategoryID: 7,
QuantityPerUnit: '50 - 300 g pkgs.',
UnitPrice: 53.0000,
UnitsInStock: 20,
UnitsOnOrder: 0,
ReorderLevel: 10,
Discontinued: false,
Category: {
CategoryID: 7,
CategoryName: 'Produce',
Description: 'Dried fruit and bean curd'
}
}, {
"ProductID": 52,
"ProductName": "Filo Mix",
"SupplierID": 24,
"CategoryID": 5,
"QuantityPerUnit": "16 - 2 kg boxes",
"UnitPrice": 7.0000,
"UnitsInStock": 38,
"UnitsOnOrder": 0,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 5,
"CategoryName": "Grains/Cereals",
"Description": "Breads, crackers, pasta, and cereal"
ProductID: 52,
ProductName: 'Filo Mix',
SupplierID: 24,
CategoryID: 5,
QuantityPerUnit: '16 - 2 kg boxes',
UnitPrice: 7.0000,
UnitsInStock: 38,
UnitsOnOrder: 0,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 5,
CategoryName: 'Grains/Cereals',
Description: 'Breads, crackers, pasta, and cereal'
}
}, {
"ProductID": 53,
"ProductName": "Perth Pasties",
"SupplierID": 24,
"CategoryID": 6,
"QuantityPerUnit": "48 pieces",
"UnitPrice": 32.8000,
"UnitsInStock": 0,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 6,
"CategoryName": "Meat/Poultry",
"Description": "Prepared meats"
ProductID: 53,
ProductName: 'Perth Pasties',
SupplierID: 24,
CategoryID: 6,
QuantityPerUnit: '48 pieces',
UnitPrice: 32.8000,
UnitsInStock: 0,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: true,
Category: {
CategoryID: 6,
CategoryName: 'Meat/Poultry',
Description: 'Prepared meats'
}
}, {
"ProductID": 54,
"ProductName": "Tourtière",
"SupplierID": 25,
"CategoryID": 6,
"QuantityPerUnit": "16 pies",
"UnitPrice": 7.4500,
"UnitsInStock": 21,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 6,
"CategoryName": "Meat/Poultry",
"Description": "Prepared meats"
ProductID: 54,
ProductName: 'Tourtière',
SupplierID: 25,
CategoryID: 6,
QuantityPerUnit: '16 pies',
UnitPrice: 7.4500,
UnitsInStock: 21,
UnitsOnOrder: 0,
ReorderLevel: 10,
Discontinued: false,
Category: {
CategoryID: 6,
CategoryName: 'Meat/Poultry',
Description: 'Prepared meats'
}
}, {
"ProductID": 55,
"ProductName": "Pâté chinois",
"SupplierID": 25,
"CategoryID": 6,
"QuantityPerUnit": "24 boxes x 2 pies",
"UnitPrice": 24.0000,
"UnitsInStock": 115,
"UnitsOnOrder": 0,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 6,
"CategoryName": "Meat/Poultry",
"Description": "Prepared meats"
ProductID: 55,
ProductName: 'Pâté chinois',
SupplierID: 25,
CategoryID: 6,
QuantityPerUnit: '24 boxes x 2 pies',
UnitPrice: 24.0000,
UnitsInStock: 115,
UnitsOnOrder: 0,
ReorderLevel: 20,
Discontinued: false,
Category: {
CategoryID: 6,
CategoryName: 'Meat/Poultry',
Description: 'Prepared meats'
}
}, {
"ProductID": 56,
"ProductName": "Gnocchi di nonna Alice",
"SupplierID": 26,
"CategoryID": 5,
"QuantityPerUnit": "24 - 250 g pkgs.",
"UnitPrice": 38.0000,
"UnitsInStock": 21,
"UnitsOnOrder": 10,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 5,
"CategoryName": "Grains/Cereals",
"Description": "Breads, crackers, pasta, and cereal"
ProductID: 56,
ProductName: 'Gnocchi di nonna Alice',
SupplierID: 26,
CategoryID: 5,
QuantityPerUnit: '24 - 250 g pkgs.',
UnitPrice: 38.0000,
UnitsInStock: 21,
UnitsOnOrder: 10,
ReorderLevel: 30,
Discontinued: false,
Category: {
CategoryID: 5,
CategoryName: 'Grains/Cereals',
Description: 'Breads, crackers, pasta, and cereal'
}
}, {
"ProductID": 57,
"ProductName": "Ravioli Angelo",
"SupplierID": 26,
"CategoryID": 5,
"QuantityPerUnit": "24 - 250 g pkgs.",
"UnitPrice": 19.5000,
"UnitsInStock": 36,
"UnitsOnOrder": 0,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 5,
"CategoryName": "Grains/Cereals",
"Description": "Breads, crackers, pasta, and cereal"
ProductID: 57,
ProductName: 'Ravioli Angelo',
SupplierID: 26,
CategoryID: 5,
QuantityPerUnit: '24 - 250 g pkgs.',
UnitPrice: 19.5000,
UnitsInStock: 36,
UnitsOnOrder: 0,
ReorderLevel: 20,
Discontinued: false,
Category: {
CategoryID: 5,
CategoryName: 'Grains/Cereals',
Description: 'Breads, crackers, pasta, and cereal'
}
}, {
"ProductID": 58,
"ProductName": "Escargots de Bourgogne",
"SupplierID": 27,
"CategoryID": 8,
"QuantityPerUnit": "24 pieces",
"UnitPrice": 13.2500,
"UnitsInStock": 62,
"UnitsOnOrder": 0,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 58,
ProductName: 'Escargots de Bourgogne',
SupplierID: 27,
CategoryID: 8,
QuantityPerUnit: '24 pieces',
UnitPrice: 13.2500,
UnitsInStock: 62,
UnitsOnOrder: 0,
ReorderLevel: 20,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 59,
"ProductName": "Raclette Courdavault",
"SupplierID": 28,
"CategoryID": 4,
"QuantityPerUnit": "5 kg pkg.",
"UnitPrice": 55.0000,
"UnitsInStock": 79,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
ProductID: 59,
ProductName: 'Raclette Courdavault',
SupplierID: 28,
CategoryID: 4,
QuantityPerUnit: '5 kg pkg.',
UnitPrice: 55.0000,
UnitsInStock: 79,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 4,
CategoryName: 'Dairy Products',
Description: 'Cheeses'
}
}, {
"ProductID": 60,
"ProductName": "Camembert Pierrot",
"SupplierID": 28,
"CategoryID": 4,
"QuantityPerUnit": "15 - 300 g rounds",
"UnitPrice": 34.0000,
"UnitsInStock": 19,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
ProductID: 60,
ProductName: 'Camembert Pierrot',
SupplierID: 28,
CategoryID: 4,
QuantityPerUnit: '15 - 300 g rounds',
UnitPrice: 34.0000,
UnitsInStock: 19,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 4,
CategoryName: 'Dairy Products',
Description: 'Cheeses'
}
}, {
"ProductID": 61,
"ProductName": "Sirop d'érable",
"SupplierID": 29,
"CategoryID": 2,
"QuantityPerUnit": "24 - 500 ml bottles",
"UnitPrice": 28.5000,
"UnitsInStock": 113,
"UnitsOnOrder": 0,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 61,
ProductName: 'Sirop dérable',
SupplierID: 29,
CategoryID: 2,
QuantityPerUnit: '24 - 500 ml bottles',
UnitPrice: 28.5000,
UnitsInStock: 113,
UnitsOnOrder: 0,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}, {
"ProductID": 62,
"ProductName": "Tarte au sucre",
"SupplierID": 29,
"CategoryID": 3,
"QuantityPerUnit": "48 pies",
"UnitPrice": 49.3000,
"UnitsInStock": 17,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 62,
ProductName: 'Tarte au sucre',
SupplierID: 29,
CategoryID: 3,
QuantityPerUnit: '48 pies',
UnitPrice: 49.3000,
UnitsInStock: 17,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 63,
"ProductName": "Vegie-spread",
"SupplierID": 7,
"CategoryID": 2,
"QuantityPerUnit": "15 - 625 g jars",
"UnitPrice": 43.9000,
"UnitsInStock": 24,
"UnitsOnOrder": 0,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 63,
ProductName: 'Vegie-spread',
SupplierID: 7,
CategoryID: 2,
QuantityPerUnit: '15 - 625 g jars',
UnitPrice: 43.9000,
UnitsInStock: 24,
UnitsOnOrder: 0,
ReorderLevel: 5,
Discontinued: false,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}, {
"ProductID": 64,
"ProductName": "Wimmers gute Semmelknödel",
"SupplierID": 12,
"CategoryID": 5,
"QuantityPerUnit": "20 bags x 4 pieces",
"UnitPrice": 33.2500,
"UnitsInStock": 22,
"UnitsOnOrder": 80,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 5,
"CategoryName": "Grains/Cereals",
"Description": "Breads, crackers, pasta, and cereal"
ProductID: 64,
ProductName: 'Wimmers gute Semmelknödel',
SupplierID: 12,
CategoryID: 5,
QuantityPerUnit: '20 bags x 4 pieces',
UnitPrice: 33.2500,
UnitsInStock: 22,
UnitsOnOrder: 80,
ReorderLevel: 30,
Discontinued: false,
Category: {
CategoryID: 5,
CategoryName: 'Grains/Cereals',
Description: 'Breads, crackers, pasta, and cereal'
}
}, {
"ProductID": 65,
"ProductName": "Louisiana Fiery Hot Pepper Sauce",
"SupplierID": 2,
"CategoryID": 2,
"QuantityPerUnit": "32 - 8 oz bottles",
"UnitPrice": 21.0500,
"UnitsInStock": 76,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 65,
ProductName: 'Louisiana Fiery Hot Pepper Sauce',
SupplierID: 2,
CategoryID: 2,
QuantityPerUnit: '32 - 8 oz bottles',
UnitPrice: 21.0500,
UnitsInStock: 76,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}, {
"ProductID": 66,
"ProductName": "Louisiana Hot Spiced Okra",
"SupplierID": 2,
"CategoryID": 2,
"QuantityPerUnit": "24 - 8 oz jars",
"UnitPrice": 17.0000,
"UnitsInStock": 4,
"UnitsOnOrder": 100,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 66,
ProductName: 'Louisiana Hot Spiced Okra',
SupplierID: 2,
CategoryID: 2,
QuantityPerUnit: '24 - 8 oz jars',
UnitPrice: 17.0000,
UnitsInStock: 4,
UnitsOnOrder: 100,
ReorderLevel: 20,
Discontinued: false,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}, {
"ProductID": 67,
"ProductName": "Laughing Lumberjack Lager",
"SupplierID": 16,
"CategoryID": 1,
"QuantityPerUnit": "24 - 12 oz bottles",
"UnitPrice": 14.0000,
"UnitsInStock": 52,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
ProductID: 67,
ProductName: 'Laughing Lumberjack Lager',
SupplierID: 16,
CategoryID: 1,
QuantityPerUnit: '24 - 12 oz bottles',
UnitPrice: 14.0000,
UnitsInStock: 52,
UnitsOnOrder: 0,
ReorderLevel: 10,
Discontinued: false,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 68,
"ProductName": "Scottish Longbreads",
"SupplierID": 8,
"CategoryID": 3,
"QuantityPerUnit": "10 boxes x 8 pieces",
"UnitPrice": 12.5000,
"UnitsInStock": 6,
"UnitsOnOrder": 10,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
ProductID: 68,
ProductName: 'Scottish Longbreads',
SupplierID: 8,
CategoryID: 3,
QuantityPerUnit: '10 boxes x 8 pieces',
UnitPrice: 12.5000,
UnitsInStock: 6,
UnitsOnOrder: 10,
ReorderLevel: 15,
Discontinued: false,
Category: {
CategoryID: 3,
CategoryName: 'Confections',
Description: 'Desserts, candies, and sweet breads'
}
}, {
"ProductID": 69,
"ProductName": "Gudbrandsdalsost",
"SupplierID": 15,
"CategoryID": 4,
"QuantityPerUnit": "10 kg pkg.",
"UnitPrice": 36.0000,
"UnitsInStock": 26,
"UnitsOnOrder": 0,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
ProductID: 69,
ProductName: 'Gudbrandsdalsost',
SupplierID: 15,
CategoryID: 4,
QuantityPerUnit: '10 kg pkg.',
UnitPrice: 36.0000,
UnitsInStock: 26,
UnitsOnOrder: 0,
ReorderLevel: 15,
Discontinued: false,
Category: {
CategoryID: 4,
CategoryName: 'Dairy Products',
Description: 'Cheeses'
}
}, {
"ProductID": 70,
"ProductName": "Outback Lager",
"SupplierID": 7,
"CategoryID": 1,
"QuantityPerUnit": "24 - 355 ml bottles",
"UnitPrice": 15.0000,
"UnitsInStock": 15,
"UnitsOnOrder": 10,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
ProductID: 70,
ProductName: 'Outback Lager',
SupplierID: 7,
CategoryID: 1,
QuantityPerUnit: '24 - 355 ml bottles',
UnitPrice: 15.0000,
UnitsInStock: 15,
UnitsOnOrder: 10,
ReorderLevel: 30,
Discontinued: false,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 71,
"ProductName": "Flotemysost",
"SupplierID": 15,
"CategoryID": 4,
"QuantityPerUnit": "10 - 500 g pkgs.",
"UnitPrice": 21.5000,
"UnitsInStock": 26,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
ProductID: 71,
ProductName: 'Flotemysost',
SupplierID: 15,
CategoryID: 4,
QuantityPerUnit: '10 - 500 g pkgs.',
UnitPrice: 21.5000,
UnitsInStock: 26,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 4,
CategoryName: 'Dairy Products',
Description: 'Cheeses'
}
}, {
"ProductID": 72,
"ProductName": "Mozzarella di Giovanni",
"SupplierID": 14,
"CategoryID": 4,
"QuantityPerUnit": "24 - 200 g pkgs.",
"UnitPrice": 34.8000,
"UnitsInStock": 14,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
ProductID: 72,
ProductName: 'Mozzarella di Giovanni',
SupplierID: 14,
CategoryID: 4,
QuantityPerUnit: '24 - 200 g pkgs.',
UnitPrice: 34.8000,
UnitsInStock: 14,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false,
Category: {
CategoryID: 4,
CategoryName: 'Dairy Products',
Description: 'Cheeses'
}
}, {
"ProductID": 73,
"ProductName": "Röd Kaviar",
"SupplierID": 17,
"CategoryID": 8,
"QuantityPerUnit": "24 - 150 g jars",
"UnitPrice": 15.0000,
"UnitsInStock": 101,
"UnitsOnOrder": 0,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
ProductID: 73,
ProductName: 'Röd Kaviar',
SupplierID: 17,
CategoryID: 8,
QuantityPerUnit: '24 - 150 g jars',
UnitPrice: 15.0000,
UnitsInStock: 101,
UnitsOnOrder: 0,
ReorderLevel: 5,
Discontinued: false,
Category: {
CategoryID: 8,
CategoryName: 'Seafood',
Description: 'Seaweed and fish'
}
}, {
"ProductID": 74,
"ProductName": "Longlife Tofu",
"SupplierID": 4,
"CategoryID": 7,
"QuantityPerUnit": "5 kg pkg.",
"UnitPrice": 10.0000,
"UnitsInStock": 4,
"UnitsOnOrder": 20,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 7,
"CategoryName": "Produce",
"Description": "Dried fruit and bean curd"
ProductID: 74,
ProductName: 'Longlife Tofu',
SupplierID: 4,
CategoryID: 7,
QuantityPerUnit: '5 kg pkg.',
UnitPrice: 10.0000,
UnitsInStock: 4,
UnitsOnOrder: 20,
ReorderLevel: 5,
Discontinued: false,
Category: {
CategoryID: 7,
CategoryName: 'Produce',
Description: 'Dried fruit and bean curd'
}
}, {
"ProductID": 75,
"ProductName": "Rhönbräu Klosterbier",
"SupplierID": 12,
"CategoryID": 1,
"QuantityPerUnit": "24 - 0.5 l bottles",
"UnitPrice": 7.7500,
"UnitsInStock": 125,
"UnitsOnOrder": 0,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
ProductID: 75,
ProductName: 'Rhönbräu Klosterbier',
SupplierID: 12,
CategoryID: 1,
QuantityPerUnit: '24 - 0.5 l bottles',
UnitPrice: 7.7500,
UnitsInStock: 125,
UnitsOnOrder: 0,
ReorderLevel: 25,
Discontinued: false,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 76,
"ProductName": "Lakkalikööri",
"SupplierID": 23,
"CategoryID": 1,
"QuantityPerUnit": "500 ml",
"UnitPrice": 18.0000,
"UnitsInStock": 57,
"UnitsOnOrder": 0,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
ProductID: 76,
ProductName: 'Lakkalikööri',
SupplierID: 23,
CategoryID: 1,
QuantityPerUnit: '500 ml',
UnitPrice: 18.0000,
UnitsInStock: 57,
UnitsOnOrder: 0,
ReorderLevel: 20,
Discontinued: false,
Category: {
CategoryID: 1,
CategoryName: 'Beverages',
Description: 'Soft drinks, coffees, teas, beers, and ales'
}
}, {
"ProductID": 77,
"ProductName": "Original Frankfurter grüne Soße",
"SupplierID": 12,
"CategoryID": 2,
"QuantityPerUnit": "12 boxes",
"UnitPrice": 13.0000,
"UnitsInStock": 32,
"UnitsOnOrder": 0,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
ProductID: 77,
ProductName: 'Original Frankfurter grüne Soße',
SupplierID: 12,
CategoryID: 2,
QuantityPerUnit: '12 boxes',
UnitPrice: 13.0000,
UnitsInStock: 32,
UnitsOnOrder: 0,
ReorderLevel: 15,
Discontinued: false,
Category: {
CategoryID: 2,
CategoryName: 'Condiments',
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'
}
}];`
import { Component } from '@angular/core';<% if (dataPath) {%>
import { <%= dataName %> } from '<%= dataPath %>'; <% } %><% if (mockedData) {%>
import { products } from './data'; <% } %>
import { <%= dataName %> } from '<%= dataPath %>'; <% } %><% if (dataSource === "Example") {%>
import { products } from './data'; <% } %><% if (dataSource === "Mock Data") {%>
import data from './data';<% } %><% if (editing) {%>
import { FormBuilder, FormGroup } from '@angular/forms';
import { CreateFormGroupArgs } from '@progress/kendo-angular-grid';<% } %>

@@ -11,5 +14,13 @@ @Component({

export class <%= classify(name) %>Component {
public gridData: any[] = <% if (dataName) {%><%=dataName%><% } else {%>products<% }%>;<% if (columns.length > 0) {%>
public fields = [<%=arrayify(columns)%>];<% }%>
public pageSize: number = <%=pageSize%>;
public gridData: any[] = <% if (dataSource === "Example") { %>products<% } else if (dataSource === "Mock Data") { %>data<% } else if (dataName) { %><%=dataName%><% } else { %>products<%} %>;<% if (paging) { %>
public pageSize: number = <%=pageSize%>;<% } %><% if (editing) {%>
constructor(private formBuilder: FormBuilder) { }
public createFormGroup = (args: CreateFormGroupArgs): FormGroup => {
// TODO: Implement default item factory.
const item = args.isNew ? Object.keys(this.gridData[0]).reduce((acc, curr) => (acc as any)[curr] = null || acc, {}) : args.dataItem;
return this.formBuilder.group(item);
};<% } %>
}
import { Component } from '@angular/core';<% if (dataPath) {%>
import { <%= dataName %> } from '<%= dataPath %>'; <% } %><% if (mockedData) {%>
import { products } from './data'; <% } %>
import { <%= dataName %> } from '<%= dataPath %>'; <% } %><% if (dataSource === "Example") {%>
import { products } from './data'; <% } %><% if (dataSource === "Mock Data") {%>
import data from './data';<% } %><% if (editing === 'inline' || editing === 'incell') {%>
import { FormBuilder, FormGroup } from '@angular/forms';
import { CreateFormGroupArgs } from '@progress/kendo-angular-grid';<% } %>

@@ -8,15 +11,50 @@ @Component({

template: `
<kendo-grid
<% if (paging || sorting || filtering || grouping) {%>[kendoGridBinding]="gridData"<% } else {%>[data]="gridData"<% } %>
[filterable]="<% if (filtering) {%> true<% } else {%>false<% } %>"
[groupable]="<% if (grouping) {%>true<% } else {%>false<% } %>"
[pageable]="<% if (paging) {%>true<% } else {%>false<% } %>"
[pageSize]="pageSize"
[sortable]="<% if (sorting) {%>true<% } else {%>false<% } %>"
<% if (height) {%>[height]="<%=height%>"<% } %>><% if (columns.length > 0) {%>
<kendo-grid-column
*ngFor="let field of fields"
[field]="field">
</kendo-grid-column> <% } %>
</kendo-grid>
<kendo-grid <% if (paging || sorting || filtering || grouping) {%>
[kendoGridBinding]="gridData"<% } else {%>[data]="gridData"<% } %><% if (editing === 'inline') {%>
[kendoGridReactiveEditing]="createFormGroup"<% }%><% if (editing === 'incell') {%>
[kendoGridInCellEditing]="createFormGroup"<% }%><% if (filtering){%>
[filterable]="true"<% }%><% if (grouping) {%>
[groupable]="true"<% } %><% if (paging) {%>
[pageable]="true"<% } %><% if (sorting) {%>
[sortable]="true"<% } %><% if (resizing) {%>
[resizable]="true"<% } %><% if (reordering) {%>
[reorderable]="true"<% } %><% if (columnMenu) {%>
[columnMenu]="true"<% } %><% if (navigable) {%>
[navigable]="true"<% } %><% if (height) {%>
[height]="<%=height%>"<% } %><% if (paging) {%>
[pageSize]="pageSize"><% } %>><% if (columns.length) {%><% for (let column of columns) {%>
<kendo-grid-column<% if (column.field) {%>
field="<%=column.field%>"<% } %><% if (column.title) {%>
title="<%=column.title%>"<% } %><% if (column.hidden) {%>
[hidden]="<%=column.hidden%>"<% } %><% if (column.locked) {%>
[locked]="<%=column.locked%>"<% } %><% if (column.sticky) {%>
[sticky]="<%=column.sticky%>"<% } %><% if (column.width) {%>
[width]="<%=column.width%>"<% } %><% if (column.columnMenu) {%>
[columnMenu]="<%=column.columnMenu%>"<% } %><% if (column.editable) {%>
[editable]="<%=column.editable%>"><% } %>></kendo-grid-column><% } %><% } %><% if (editing === 'inline') {%>
<kendo-grid-command-column title="Command" [width]="220">
<ng-template kendoGridCellTemplate let-formGroup="formGroup" let-isNew="isNew">
<button kendoGridEditCommand [primary]="true">Edit</button>
<button kendoGridRemoveCommand>Remove</button>
<button kendoGridSaveCommand [disabled]="formGroup?.invalid">
{{ isNew ? "Add" : "Update" }}
</button>
<button kendoGridCancelCommand>
{{ isNew ? "Discard changes" : "Cancel" }}
</button>
</ng-template>
</kendo-grid-command-column><% } %><% if (editing === 'incell') {%>
<kendo-grid-command-column title="command" [width]="220">
<ng-template kendoGridCellTemplate let-formGroup="formGroup" let-isNew="isNew">
<button kendoGridRemoveCommand>Remove</button>
<button kendoGridSaveCommand [disabled]="formGroup?.invalid">
Add
</button>
<button kendoGridCancelCommand>Discard</button>
</ng-template>
</kendo-grid-command-column><% } %><% if (editing === 'incell' || editing === 'inline') {%>
<ng-template kendoGridToolbarTemplate>
<button kendoGridAddCommand>Add new</button>
</ng-template><% } %>
</kendo-grid>
`,<% if (inlineStyle) {%>

@@ -27,5 +65,13 @@ styles: [``]<% } else {%>

export class <%= classify(name) %>Component {
public gridData: any[] = <% if (dataName) {%><%=dataName%><% } else {%>products<% }%>;<% if (columns.length > 0) {%>
public fields = [<%=arrayify(columns)%>];<% }%>
public pageSize: number = <%=pageSize%>;
public gridData: any[] = <% if (dataSource === "Example") { %>products<% } else if (dataSource === "Mock Data") { %>data<% } else if (dataName) { %><%=dataName%><% } else { %>products<%} %>;<% if (paging) { %>
public pageSize: number = <%=pageSize%>;<% if (editing === 'inline' || editing === 'incell') {%>
constructor(private formBuilder: FormBuilder) { }
public createFormGroup = (args: CreateFormGroupArgs): FormGroup => {
// TODO: Implement default item factory.
const item = args.isNew ? Object.keys(this.gridData[0]).reduce((acc, curr) => (acc as any)[curr] = null || acc, {}) : args.dataItem;
return this.formBuilder.group(item);
};<% } %>
}

@@ -5,8 +5,17 @@ "use strict";

const core_1 = require("@angular-devkit/core");
const strings_1 = require("@angular-devkit/core/src/utils/strings");
const schematics_1 = require("@angular-devkit/schematics");
const path_1 = require("path");
const schema_1 = require("./schema");
const data_1 = require("./files/data");
const utils_1 = require("../utils");
const classify = core_1.strings.classify;
const arrayify = (args) => args.map(s => `'${s}'`).join(", ");
function grid(_options) {
return (_tree, _context) => {
var _a;
_options.name = path_1.basename(_options.name);
let defaults = {
style: "css"
};
let path = path_1.normalize('/' + path_1.dirname((_options.path + '/' + _options.name)));

@@ -16,7 +25,18 @@ if (process.platform == "win32") {

}
const parsedComplexOptions = utils_1.parseComplexOptions(['columns'], _options);
const overrides = {};
if (_options.dataSource == schema_1.DataSource.Example) {
// If the data source is "Example", use a predefined template for data and columns
overrides.columns = [
{ field: "ProductID", title: "ID" },
{ field: "ProductName", title: "Product Name" },
{ field: "UnitPrice", title: "Unit Price" }
];
}
const templateOptions = Object.assign(Object.assign(Object.assign(Object.assign(Object.assign({}, defaults), _options), parsedComplexOptions), overrides), { classify,
dasherize: strings_1.dasherize,
arrayify });
const templateSource = schematics_1.apply(schematics_1.url(_options.inlineTemplate ? './files/inline' : './files/html'), [
schematics_1.template(Object.assign(Object.assign({}, _options), { classify: core_1.strings.classify, dasherize: core_1.strings.dasherize, arrayify(args) {
return args.map(s => `'${s}'`).join(", ");
} })),
schematics_1.move(_options.path),
schematics_1.template(templateOptions),
schematics_1.move(_options.path)
]);

@@ -28,7 +48,24 @@ const angularComponentOptions = {

inlineStyle: _options.inlineStyle,
skipTests: _options.skipTests
skipTests: _options.skipTests,
style: templateOptions.style
};
if (_options.mockedData) {
_tree.create(`${_options.path}/${_options.name}/data.ts`, `export const products = ${data_1.products}`);
if (_options.dataSource == schema_1.DataSource.Example) {
// Import the example datasource
_tree.create(`${_options.path}/${strings_1.dasherize(_options.name)}/data.ts`, data_1.productsSourceCode);
}
else if (_options.dataSource == schema_1.DataSource['Mock Data']) {
// Generate mocked data out of the column defitions
let dataSourceCode = `export const data = [{\n`;
for (let i = 0; i <= 15; i++) {
for (const column of parsedComplexOptions.columns) {
dataSourceCode += ` "${column.field}": "${(_a = column.title) !== null && _a !== void 0 ? _a : column.field} ${i}",\n`;
}
if (i < 15) {
dataSourceCode += ` }, {\n`;
}
}
dataSourceCode += ` }];\n`;
dataSourceCode += `export default data;`;
_tree.create(`${_options.path}/${strings_1.dasherize(_options.name)}/data.ts`, dataSourceCode);
}
return schematics_1.chain([

@@ -35,0 +72,0 @@ schematics_1.externalSchematic('@schematics/angular', 'component', angularComponentOptions),

import { strings } from '@angular-devkit/core';
import { dasherize } from '@angular-devkit/core/src/utils/strings';
import {

@@ -17,5 +18,11 @@ apply,

import { basename, normalize, dirname, win32 } from 'path';
import { Schema } from './schema';
import { products } from './files/data';
import { DataSource, Schema } from './schema';
import { productsSourceCode } from './files/data';
import { parseComplexOptions } from '../utils';
const classify = strings.classify;
const arrayify = (args: string[]) =>
args.map(s => `'${s}'`).join(", ");
export function grid(_options: Schema): Rule {

@@ -25,2 +32,6 @@ return (_tree: Tree, _context: SchematicContext) => {

let defaults = {
style: "css"
};
let path = normalize('/' + dirname((_options.path + '/' + _options.name)));

@@ -31,13 +42,29 @@ if (process.platform == "win32") {

const parsedComplexOptions = parseComplexOptions(['columns'], _options);
const overrides: any = {};
if (_options.dataSource == DataSource.Example) {
// If the data source is "Example", use a predefined template for data and columns
overrides.columns = [
{ field: "ProductID", title: "ID" },
{ field: "ProductName", title: "Product Name" },
{ field: "UnitPrice", title: "Unit Price"}
]
}
const templateOptions = {
...defaults,
..._options,
...parsedComplexOptions,
...overrides,
classify,
dasherize,
arrayify
};
const templateSource = apply(
url(_options.inlineTemplate ? './files/inline' : './files/html'), [
template({
..._options,
classify: strings.classify,
dasherize: strings.dasherize,
arrayify(args: string[]) {
return args.map(s => `'${s}'`).join(", ");
}
}),
move(_options.path),
template(templateOptions),
move(_options.path)
],

@@ -51,8 +78,26 @@ );

inlineStyle: _options.inlineStyle,
skipTests: _options.skipTests
skipTests: _options.skipTests,
style: templateOptions.style
};
if(_options.mockedData) {
_tree.create(`${_options.path}/${_options.name}/data.ts`, `export const products = ${products}`);
if(_options.dataSource == DataSource.Example) {
// Import the example datasource
_tree.create(`${_options.path}/${dasherize(_options.name)}/data.ts`, productsSourceCode);
}
else if (_options.dataSource == DataSource['Mock Data'])
{
// Generate mocked data out of the column defitions
let dataSourceCode = `export const data = [{\n`;
for (let i = 0; i <= 15; i++) {
for (const column of parsedComplexOptions.columns) {
dataSourceCode += ` "${column.field}": "${column.title ?? column.field} ${i}",\n`;
}
if (i < 15) {
dataSourceCode += ` }, {\n`;
}
}
dataSourceCode += ` }];\n`;
dataSourceCode += `export default data;`;
_tree.create(`${_options.path}/${dasherize(_options.name)}/data.ts`, dataSourceCode);
}

@@ -59,0 +104,0 @@ return chain([

@@ -0,1 +1,20 @@

export declare enum DataSource {
/**
* An example data source will be added to the project with predefined column definitions.
* The data and column definitions can not be modified.
*
* This is the default.
*/
"Example" = "Example",
/**
* The user is expected to provide column definitions.
* A mock data will be generated out of the column definitions.
*/
"Mock Data" = "Mock Data",
/**
* The user can specify a basic module to bind to and provide column definitions,
* but in general the user will have to author some code to connect the data.
*/
"Existing App Data" = "Existing App Data"
}
export interface Schema {

@@ -11,8 +30,12 @@ path?: string;

sorting?: boolean;
resizing?: boolean;
reordering?: boolean;
columnMenu?: boolean;
navigable?: boolean;
pageSize?: number;
height?: number;
columns?: Array<string>;
columns?: string;
dataSource: DataSource;
dataPath?: string;
dataName: string;
mockedData?: boolean;
}
"use strict";
Object.defineProperty(exports, "__esModule", { value: true });
exports.DataSource = void 0;
var DataSource;
(function (DataSource) {
/**
* An example data source will be added to the project with predefined column definitions.
* The data and column definitions can not be modified.
*
* This is the default.
*/
DataSource["Example"] = "Example";
/**
* The user is expected to provide column definitions.
* A mock data will be generated out of the column definitions.
*/
DataSource["Mock Data"] = "Mock Data";
/**
* The user can specify a basic module to bind to and provide column definitions,
* but in general the user will have to author some code to connect the data.
*/
DataSource["Existing App Data"] = "Existing App Data";
})(DataSource = exports.DataSource || (exports.DataSource = {}));

@@ -21,3 +21,5 @@ {

},
"inlineTemplate": {
"progress:category": "Code Generation",
"progress:display-name": "Inline template",

@@ -30,2 +32,3 @@ "description": "Include template inline in the component.ts file. By default, an external template file is created and referenced in the component.ts file.",

"inlineStyle": {
"progress:category": "Code Generation",
"description": "Include styles inline in the component.ts file. Only CSS styles can be included inline. By default, an external styles file is created and referenced in the component.ts file.",

@@ -37,2 +40,3 @@ "type": "boolean",

"skipTests": {
"progress:category": "Code Generation",
"type": "boolean",

@@ -42,2 +46,10 @@ "description": "Do not create \"spec.ts\" test files for the new component.",

},
"editing": {
"progress:category": "Grid Features",
"description": "Configures the Grid for inline or incell editing.",
"type": "string",
"enum": ["none", "inline", "incell"],
"default": "none"
},
"filtering": {

@@ -50,2 +62,3 @@ "progress:category": "Grid Features",

"grouping": {
"progress:category": "Grid Features",
"description": "Enables Grid grouping",

@@ -56,2 +69,3 @@ "type": "boolean",

"paging": {
"progress:category": "Grid Features",
"description": "Enables Grid paging",

@@ -62,2 +76,3 @@ "type": "boolean",

"sorting": {
"progress:category": "Grid Features",
"description": "Enables Grid sorting",

@@ -67,3 +82,28 @@ "type": "boolean",

},
"resizing": {
"progress:category": "Grid Features",
"description": "Enables Grid resizing",
"type": "boolean",
"default": false
},
"reordering": {
"progress:category": "Grid Features",
"description": "Enables Grid reordering",
"type": "boolean",
"default": false
},
"columnMenu": {
"progress:category": "Grid Features",
"description": "Enables Grid column menu",
"type": "boolean",
"default": false
},
"navigable": {
"progress:category": "Grid Features",
"description": "Makes the Grid navigable",
"type": "boolean",
"default": false
},
"pageSize": {
"progress:category": "Grid Features",
"description": "Sets the pageSize of a pageable Grid",

@@ -74,2 +114,3 @@ "type": "number",

"height": {
"progress:category": "Grid Features",
"description": "Sets the height of the Grid",

@@ -79,29 +120,53 @@ "type": "number",

},
"columns": {
"progress:category": "Data Binding",
"description": "Specifies the fields that will be rendered as columns in the Grid",
"type": "array",
"items": {
"type": "string"
},
"uniqueItems": true
"dataSource": {
"progress:category": "Data Source",
"description": "Select grid data source generation strategy",
"type": "string",
"default": "Example",
"enum": [ "Example", "Mock Data", "Existing App Data" ],
"progress:enum": [{
"name": "Example", "description": "An example data source will be added to the project, with predefined column definitions."
}, {
"name": "Mock Data", "description": "Specify column definitions, from which mock data will be generated and added to the project."
}, {
"name": "Existing App Data", "description": "Provide import path. If the data module does not exist in your project, you will have to generate it by hand."
}]
},
"mockedData": {
"description": "Enables the generation of a local data file",
"type": "boolean"
},
"dataPath": {
"progress:category": "Data Source",
"description": "Sets a path to the local data file",
"type": "string",
"progress:hideOnPropertyValue": {
"property": "mockedData",
"value": true
}
"progress:attributes": [
{ "type": "hideOnPropertyValue", "property": "dataSource", "values": [ "Example", "Mock Data" ] }
]
},
"dataName": {
"progress:category": "Data Source",
"description": "Sets a name to the local data property",
"type": "string",
"progress:hideOnPropertyValue": {
"property": "mockedData",
"value": true
"progress:attributes": [
{ "type": "hideOnPropertyValue", "property": "dataSource", "values": [ "Example", "Mock Data" ] }
]
},
"columns": {
"progress:category": "Data Source",
"progress:type": "array",
"hidden": true,
"description": "Specifies the columns in the Grid",
"type": "string",
"progress:attributes": [
{ "type": "hideOnPropertyValue", "property": "dataSource", "values": [ "Example" ] }
],
"items": {
"type": "object",
"properties": {
"field": {"type": "string"},
"title": {"type": "string"},
"hidden": {"type": "boolean"},
"locked": {"type": "boolean"},
"sticky": {"type": "boolean"},
"columnMenu": {"type": "boolean"},
"editable": {"type": "boolean"},
"width": {"type": "number"}
}
}

@@ -108,0 +173,0 @@ }

@@ -0,1 +1,24 @@

export enum DataSource {
/**
* An example data source will be added to the project with predefined column definitions.
* The data and column definitions can not be modified.
*
* This is the default.
*/
"Example" = "Example",
/**
* The user is expected to provide column definitions.
* A mock data will be generated out of the column definitions.
*/
"Mock Data" = "Mock Data",
/**
* The user can specify a basic module to bind to and provide column definitions,
* but in general the user will have to author some code to connect the data.
*/
"Existing App Data" = "Existing App Data"
}
export interface Schema {

@@ -11,8 +34,12 @@ path?: string;

sorting?: boolean;
resizing?: boolean;
reordering?: boolean;
columnMenu?: boolean;
navigable?: boolean;
pageSize?: number;
height?: number;
columns?: Array<string>;
columns?: string;
dataSource: DataSource;
dataPath?: string;
dataName: string;
mockedData?: boolean;
}
}

@@ -12,1 +12,2 @@ import { Tree } from '@angular-devkit/schematics';

export declare function fileContent(tree: Tree, path: string): string;
export declare const parseComplexOptions: (props: string[], options: any) => any;

@@ -13,3 +13,3 @@ "use strict";

Object.defineProperty(exports, "__esModule", { value: true });
exports.fileContent = exports.asObservable = exports.stringify = exports.buildSelector = exports.folderName = exports.getAppModulePath = exports.findModule = exports.addImportToModule = exports.addExportToModule = exports.addDeclarationToModule = exports.addSymbolToMetadata = void 0;
exports.parseComplexOptions = exports.fileContent = exports.asObservable = exports.stringify = exports.buildSelector = exports.folderName = exports.getAppModulePath = exports.findModule = exports.addImportToModule = exports.addExportToModule = exports.addDeclarationToModule = exports.addSymbolToMetadata = void 0;
const core_1 = require("@angular-devkit/core");

@@ -64,1 +64,17 @@ const schematics_1 = require("@angular-devkit/schematics");

exports.fileContent = fileContent;
const parseComplexOptions = (props, options) => props.reduce((acc, option) => {
if (options[option]) {
try {
let rawValue = options[option];
let parsed = JSON.parse(rawValue);
acc[option] = parsed;
// console.log(`Parsing ${option}, raw: '${rawValue}', json: '${JSON.stringify(parsed, null, " ")}'`);
}
catch (e) {
e.message = `Failed parsing '${option}' input. ${e.message}.`;
throw e;
}
}
return acc;
}, {});
exports.parseComplexOptions = parseComplexOptions;

@@ -70,1 +70,18 @@ import { strings } from '@angular-devkit/core';

}
export const parseComplexOptions =
(props: string[], options: any): any => props.reduce((acc, option) => {
if (options[option]) {
try {
let rawValue = options[option];
let parsed = JSON.parse(rawValue);
acc[option] = parsed;
// console.log(`Parsing ${option}, raw: '${rawValue}', json: '${JSON.stringify(parsed, null, " ")}'`);
} catch(e) {
e.message = `Failed parsing '${option}' input. ${e.message}.`;
throw e;
}
}
return acc;
}, {});

Sorry, the diff of this file is not supported yet

SocketSocket SOC 2 Logo

Product

  • Package Alerts
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap
  • Changelog

Packages

npm

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc