Sunbelt Sports Sales is now Bedlam Sports.
However, when I was employed there from May 2004 through April 2006 it was still Sunbelt Sports Sales.
While employed at Sunbelt Sports Sales I was assigned to transition the website from a static HTML site to a dynamic database driven site.
The static Sunbelt Sports site
I made a copy of the website and with that copy I determined which HTML tags contained the product information needed for a database.
Using find and replace in Notepad and then later Dreamweaver I transitioned the website copy into a large table with rows, columns, and table headings.
By running the website copy on a local machince I was able to copy and paste the values into an Excel spreadsheet.
Some minor corrections were made to the spreadsheet and then it was imported into an Access Database.
Once in a database the ASP code was written to retrieve and display the product information.
The dynamic Sunbelt Sports site
I designed and developed a Sunbelt BackOffice System that was used for inventory control.
As products were sold online the quanity of that product would be decremented from inventory.
As products arrived in the warehouse the staff could add the new amount into the system.
Anytime a product reached a quantity of zero it automatically stopped displaying on the website.
I also worked with the warehouse personnel to organize and mark shelf locations for staff to easily locate products still in the warehouse.
This system helped the company identify which products sold often and which did not, so that the purchasing department could adjust orders.
