Customers of this wholesale custom clothing producer had been complaining about the difficulty of placing orders using their Excel/Email based ordering process. Studio28 engineered an online B2B order processing system handling ~5k orders per year worth $10mil sales.
Created a MySql database with a front end application in WordPress that allowed Georgia voters to check if their voting status had been challenged.
The St. Denis building , with 300 commercial tenants in NYC's East Village needed a platform for handling tenant communications. Studio28 built it in WordPress with features such as the ability to manage routine maintenance via sms.

Leads List as lightweight CRM in Google Sheets

Dataset sourced from NYC Department of Finance, Department of Buildings and commercial sources. Leads defined as contact information for owners of rental buildings with more than 4 units in zip code 11238 which have had major renovation permits in the last three years. Includes direct links to mortgage and ownership info using a manually constructed unique identifier.

Identify Rent Stabilized Buildings - MySql

The table shows buildings registered as having one or more rent stabilized units. Data is in a remote MySql database connected to the WordPress site via plugin. Demo by entering an address and/or a zip code to narrow your search.

Top Garments and Suppliers - MySql

Created a MySQL database from multiple CSV files downloaded from suppliers and online sales reports. Database hosted remotely, queried and displayed via WordPress plugin. Click any row to view a popup of garment details. Click a column header to sort by that column.

garment_id style_no brand fit type garment image channel orders sales supplier loc supplier_title piece_price case_price
1 L217 Port Authority Women Jacket L217_Black_Flat_Front_2011.jpg Both 9216 336589 SanMar Onsite Port Authority Ladies Value Fleece Jacket. L217 19 15
2 PC78H Port & Company Adult Unisex Hoodie Both 4622 180253 SanMar Onsite Port & Company - Core Fleece Pullover Hooded Sweatshirt. PC78H 12 10
3 L317 Port Authority Women Jacket L317_deepsmoke_flat_front_072017.jpg Both 2176 134356 SanMar Supplier Port Authority Ladies Core Soft Shell Jacket. L317 23 19
4 F217 Port Authority Men Jacket F217_Black_Flat_Front_2011.jpg Both 1314 56786 SanMar Supplier Port Authority Value Fleece Jacket. F217 19 15
5 CP91L Port & Company Adult Unisex Hat Amazon only 1301 41251 SanMar Onsite Port & Company Fleece-Lined Beanie Cap. CP91L 4 3