Database of products

General schema

JSON example

{
   "id": "0130350591",
   "title": "Le Creuset Butter Dish Stoneware",
   "description": "Each piece of Le Creuset dinnerware is ...",
   "price": 14.05,
   "imgUrl": "http://ecx.images-amazon.com/images/I/21zcx6RCDoL.jpg",
   "brand": "Le Creuset",
   "categories": [
      "Home & Kitchen",
      "Kitchen & Dining",
      "Dining & Entertaining",
      "Serveware",
      "Butter Dishes"
   ]
},

SQL example

INSERT INTO `product` (`id`, `title`, `description`, `price`, `imgUrl`, `brand`) VALUES
(2, 'Le Creuset Butter Dish Stoneware', 'Each piece of Le Creuset dinnerware is...', 14.05, 'http://ecx.images-amazon.com/images/I/21zcx6RCDoL.jpg', 'Le Creuset');

Reference

J. McAuley, C. Targett, J. Shi, A. van den Hengel: Image-based recommendations on styles and substitutes. SIGIR, 2015.