Supply-chain optimization is the application of processes and tools to ensure the optimal operation of a manufacturing organization. The SCM is the spine of E-commerce, a very critical component of E-commerce. Supply chain efficiency means having the right product at the right place at the right time, can save money or reduce costs, and can enhance cash utilization. E-commerce plays a vital role on inventory management to keep the record electronically to avoid any information breach. In this paper, we have developed a database management system which would be centrally visualized by the partners of the apparel supply chain. Buyer can be able to place orders through this developed database system electronically which might save at least ordering cost, visit cost and 15 %-time savings of the total lead time. Furthermore, we have developed a system by which customer can buy surplus goods which remain after shipment has done with the cheapest cost and factory will not face any wastage of goods.