A database was constructed for customers to find and choose and apparel product. The product information was collected from words on several kinds of advertisement, which purchasers meet in their ordinary life. The information was sorted and categorized in 8 basic mother categories (Target group, Color, Apparel type, Fabric, Size, Price, Manufacturer) to build a suitable database structure. Each mother category was arranged into subcategories. Also this study showed a demonstration version of the retrieval system. the research resulted can be used for more intensive retrieval system.