The client being a trading firm dealing in millions of dollars of recycled diamonds and jewelry, required a lot of paperwork. They initially had the legacy system of storing and tracking data but it was a costly affair with a difficult user interface which was was not fruitful to the company. They had segregated their entire workflow in three phases i.e buying, processing and selling. It was the need of the hour to automate these phases.

We suggested a complete Salesforce based solution to the client and helped them move their entire data from their legacy database system to Salesforce. We performed exhaustive requirement gathering. And thereby designed and implemented complete workflows as per extensive research of client needs. We had also anticipated their future needs and created flexible workflows.We had automated each phase of buying, processing and selling using Salesforce and also provided role based authentication at each of these phases. Each step in every phase was thus automated and trackable. We had provided a complete solution along with hardware, financialforce and third party web-services integration to meet all their needs.

They had a process which involved buying of diamonds and jewelry, segregating the components and then reselling it again. They segregated the different components of the jewelry so there was a list of data to be maintained for each type of component extracted. So it was a pretty difficult task to update the stock of each and every component with all the minute details at real time.

We provided a complete cloud based solution which not only helped to maintain the data but also helped to keep a calculated track of all the components- their quantity, weight,etc and thereby helping in inventory management.At the buying phase they needed to keep a record of what was being bought, their quantity, and a lot more. Similarly at the processing phase they had to keep a proper record of what are the components extracted, their quantity,size,cut and other important aspects. And at the selling phase they needed to update their inventory accordingly to keep a check on the number of items sold and the ones remaining along with their relevant details.

Being one of the top diamond and jewelry recycling companies it had a very vital requirement of displaying its products on the desired jewelry based e-commerce websites. As new components were processed and segregated, they needed a system which would automatically update their display items in these third party websites along with their details at real time. For this they needed to push data from Salesforce to these third party web-services directly.

We suggested Salesforce integration with the third party web-services. There was Rapnet, Blue Nile, Idex and Polygone which catered to their need of displaying their available components for sale. A few of them had Restful API and the data can be directly pushed from Salesforce to these third party web-services and can be displayed accordingly. But a few of them did not support direct pushing of data from Salesforce as they had the old FTP system.Hence we created a custom java adapter for them which can pull data from the Salesforce system and push it to FTP and then it could push the same data to these web-service portals via FTP protocol and display their product with their relevant details automatically when the inventory is updated in the system.