Web & Database Optimization for Solablok.com

Client Overview
Solablok is a custom roller shades retailer based in the United States, offering made-to-order window covering solutions. The company operates an eCommerce platform that handles product configuration, online payments, and logistics integrations with shipping providers like FedEx.

Project Objective
Solablok needed a complete revamp and stabilization of their ASP.NET-based eCommerce system, including:
  1. a) Bug fixing for dynamic price calculations and shipping APIs.
  2. b) Stripe integration for delayed payment capture.
  3. c) Streamlined checkout and order status automation.
  4. d) Discount logic implementation.
  5. e) Security improvement with SSL.
  6. f) Website maintenance and deployment controls.

Challenges
  1. a) Inconsistent shipping costs and faulty FedEx rate returns.
  2. b) Stripe API integration was incomplete and charged immediately instead of upon order completion.
  3. c) Discount logic was conflicting and lacked dynamic control.
  4. d) High communication overhead due to continuous change tracking and remote debugging.
  5. e) Lack of SSL for secure card handling.
  6. f) Frequent client-side changes created version control issues.

Solution Delivered
  1. a) Developed efficient SQL queries to handle item-based shipping costs.
  2. b) Refactored Stripe integration to store tokens and delay payment until order completion.
  3. c) Designed a Stripe-compliant charge handler using customer IDs and secure tokens.
  4. d) Created logic for discount scheduling and validation.
  5. e) Integrated maintenance mode toggle via Plesk for smooth production deployments.
  6. f) Added audit-ready database tracking for transactions, order status, and discount updates.
  7. g) Maintained continuous communication with the client, providing video guides, screenshots, and flexible custom offers.
  Key Technologies
  1. a) ASP.NET MVC
  2. b) SQL Server
  3. c) FedEx API
  4. d) Stripe API (Tokenization + Deferred Charge)
  5. e) Google Drive for collaboration
  6. f) Plesk for hosting control

Results
  1. a) 100% of identified bugs resolved.
  2. b) Stripe successfully handled both test and live transactions.
  3. c) FedEx rates now dynamically adjust to weight, dimension, and ZIP.
  4. d) Checkout flow optimized; client saw fewer abandoned carts.
  5. e) Discount automation and cart logic improved.
  6. f) Site moved to production with robust backup handling.
  7. g) Client satisfaction and repeat business inquiries confirmed long-term trust.
Testimonial
“The developer stayed with me through months of revisions, testing, debugging, and integration work. He never gave up on the solution, even when things got complex.”  — Huy Pham, USA