Smartstore Releases Versions 5.0.2 to 5.0.4 with .NET 7 Update, Expanded Database Support, and Performance Enhancements

About Smartstore

Smartstore is an open-source e-commerce solution built on ASP.NET Core, designed to cater to businesses of varying sizes. It supports multiple database systems including SQL Server, MySQL, and now PostgreSQL and SQLite, enabling flexible deployment options across Windows, Linux, and macOS platforms. The platform offers a comprehensive set of tools for managing online stores, including CRM and marketplace features, and is appreciated for its extensibility through plugins.

Release 5.0.2 Highlights

Released in early January 2023, version 5.0.2 marked a foundational update for Smartstore with the following key changes:

• Upgrade to .NET 7: This update brought the platform up to date with the latest Microsoft .NET framework, promising better performance and modern development features.
• New Plugins: Introduction of the Web API plugin for enhanced API capabilities, Stripe Elements for payment processing, and several commercial plugins such as BeezUp, ElmarShopInfo, Shopwahl, and CartApproval.
• Performance Improvements: Approximately 10% faster application startup and time to first byte (TTFB), along with reduced memory usage.
• Developer Changes: Renaming of Product.ProductPictures to ProductMediaFiles and addition of a new action filter attribute DisallowRobotAttribute.
• Bug Fixes: Addressed various issues including duplicate locale string resources, export profile problems, media display errors, and payment fee display inconsistencies.

Release 5.0.3 Highlights

The February 2023 release focused on enhancements around payment integrations and API stability:

• Webhook Enhancements: Added WebhookEndpointAttribute metadata to suppress guest account creation during webhook calls, improving API interaction control.
• PayPal Improvements: Added a support window for PayPal account information, an upper limit setting for Pay Upon Invoice, and the ability to disable PayPal buttons on the shopping cart page.
• Customer Role Management: Enabled deletion and filtering of customer role assignments automatically created by rules.
• Bug Fixes: Resolved issues related to database connection changes, AJAX grid saving, API metadata configurations, theming inconsistencies, export file counts, and various payment and checkout workflow problems.

Release 5.0.4 Highlights

The most recent update, published in March 2023, brought significant enhancements particularly in database support and memory management:

• Expanded Database Support: Added official support for PostgreSQL and SQLite, broadening the database options beyond SQL Server and MySQL and facilitating more flexible deployment environments.
• New Commercial Plugins: Released easyCredit and DependingPrices plugins, the latter enabling price configurations based on customer groups, language, store, or customer number.
• Embedded Image Offloading: Introduced a Base64 image offloader that extracts embedded images from lengthy HTML descriptions and saves them to media storage, optimizing content management.
• Mail and System Settings: Added options for SMTP connection encryption and new app system settings to control database context pooling and caching.
• Memory Management Improvements: Fixed multiple memory leaks, disabled DbContext pooling to prevent leaks, introduced a new sequential data reader for large HTML content, and optimized garbage collection, leading to significantly reduced memory usage under heavy load.
• Performance and Usability: Enhanced MegaSearch with faster search and indexing, configurable word stemming, and improved product list loading times.
• Bug Fixes: Addressed a wide range of issues including address state selection, SQL deadlocks, discount application errors, memory leaks in search indexing, validation fixes, and UI inconsistencies.

Impact and Community Reception

Smartstore’s continuous updates demonstrate a commitment to improving performance, expanding compatibility, and enhancing user experience. The addition of PostgreSQL and SQLite support is particularly notable, as community discussions had previously identified the lack of PostgreSQL support as a limitation. The memory optimizations and search improvements respond to demands for better scalability and responsiveness in larger stores or those with complex product data.

The introduction of commercial plugins alongside open-source features indicates a hybrid approach to monetization and extensibility, catering to both community users and professional deployments. Bug fixes across all releases show active maintenance and responsiveness to user-reported issues.

Overall, these releases position Smartstore as a versatile and evolving e-commerce platform suitable for a wide range of business needs, with modern technology stacks and growing ecosystem support.