Goal
A Los Angeles wholesale distributor took store orders on Drupal Commerce but synced prices, stock and orders with QuickBooks by hand.
What I did
A custom QuickBooks Desktop integration (Web Connector, SOAP/qbXML): hourly sync of ~7,500 items, prices and stock, and automatic export of web orders
Per-customer price caching for the signed-in B2B ordering flow
WebP images and lazy loading for 1,700 product photos
Technical SEO: clean URLs with ~3,900 redirects, XML sitemap, schema.org JSON-LD
An AI module on the Google Gemini API that rewrote raw item names into clean product titles, with review and revert
A DigitalOcean LAMP server that I set up and tuned, moved from PHP 7.4 to 8.5 with 12 seconds of maintenance mode
Results
Checkout server response: 7–13 s → 0.5 s
Catalog of 1,700 products on 4G: 16.8 s → 2.1 s
Google Search Console: impressions +98%, clicks +62%
Live site: araks.org
0 likes · 0 views · Nov 5, 2026
Wholesale ordering site with a QuickBooks sync for ~7,500 items. Checkout 7–13 s → 0.5 s; Google impressions +98%, clicks +62%.
