ClicShopping

March 29

For over two years, ClicShopping AI has been integrating generative AI using OpenAI, Anthropic, and Ollama.

While the V3.x release incorporated AI without requiring fundamental changes to the core application or underlying technologies, the upcoming V4 takes a major leap forward with deeper AI integration and enhanced functionalities.

MariaDB with RAG: A Game Changer for AI-Driven E-Commerce for PHP aplication

MariaDB has recently introduced a version with built-in Retrieval-Augmented Generation (RAG), leveraging OpenAI for intelligent search and contextual understanding.
This upgrade enables databases to create vector embeddings, allowing for advanced semantic search capabilities that link structured and unstructured data.

ClicShopping AI V4 seamlessly integrates MariaDB’s RAG with its PHP-based framework, empowering merchants with AI-powered data retrieval. The system can process vast datasets, enabling real-time insights and intelligent automation through a chatbot-driven interface.

Advanced AI-Powered Features for Merchants

ClicShopping AI V4 enhances the merchant experience with context-aware search and AI-driven analytics.

Key capabilities will be includes (most of them):

✔ Intelligent Stock Monitoring – Instantly check which products are running low.
✔ Advanced Product Lookup – Retrieve products by reference, attributes, or even vague descriptions.
✔ Automated Customer Insights – AI-driven analysis of purchasing patterns and customer preferences.
✔ Smart Recommendations – Suggests relevant products based on user behavior and search history.

and more.

If no exact match is found, the chatbot dynamically returns the closest relevant result, ensuring an intuitive and efficient user experience.

Currently, very few PHP e-commerce solutions natively integrate generative AI and RAG technology.

ClicShopping AI is the first PHP solution to pioneer this innovation, redefining how merchants interact with their data.

Enhanced Security with AES-256 Encryption

Security remains a top priority. The next release will introduce dynamic AES-256 encryption for sensitive data stored within the platform.
This ensures:

🔐 End-to-End Encryption – Protects customer and transaction data.
🔐 Adaptive Key Management – Rotates encryption keys dynamically for enhanced security.
🔐 Compliance-Ready Protection – Meets industry standards for data privacy and security.

Try the Development Version Today

ClicShopping AI V4 is at the forefront of AI-driven e-commerce solutions. Be among the first to explore its capabilities!

⚡ System Requirements (recommended):

MariaDB 11.7 (with RAG support)

PHP 8.4

Stay ahead of the curve—embrace the future of AI-powered e-commerce with ClicShopping AI V4!

August 16, 2023

Good morning,

Some of you have certainly noticed a change on the logo. Since the 2 last versions, we have set out to put generative artificial intelligence in the application with GPT and OPENAI. The module will certainly evolve in time to integrate other approach like Google Bard for example. We go there in stages.

For the next version 3.431 a Charbot will be integrated into the application on the front office.

It will use generative AI to give additional information to the user allowing him to have more information on the product.

We wanted to go more far including generation conditions for example. But the expected result was not there. We have tried to use text segmentation to reduce the processing time but the limitation obtained is not good.

This is due to the fact that Mariadb does not have a feature to include a vector inside a table.

This approach improves treatment time but drastically reducing the number of Token sent to GPT and the cost linked to treatment.

In addition, proposing a solution whose reaction time and a cost of treatment too much did not seem to us to be careful as an approach.

Furthermore, like the administration where we use Davinci-003 model, in the front office, we use GPT 3.5 Turbo is a model largely cheaper than Davinci.

We have included a parameter allowing to manage the chatbot display in the offering front so that you can better manage your budget.

To complete the next evolution will have updates concerning the GPT including new statistics, a preditive security stock -analyse and an update on customer recommendations.

Our objective is to be able to offer a new generation of e-commerce platform allowing merchants (small company, medium company) to be able to use artificial intelligence with a budget control, to be able to carry out more impactful communication campaign, marketing and finally to optimize production time, creation of product sheets and increase the sell.

The work continues and will continue in this orientation in the future.

January 8, 2023

We have started the next version of ClicShopping and some minor release has been pushed.

What do we find inside this new version essentially ?

Php8.2 compatibility and optimized

Studio editor to edit the template and the css

Cronjob manager with some tasks included

API allowing to connect ClicShopping with some other tools as crm, erp across json approach ....

A new marketplace

Librairies will updated

Double authentification

The new boostrap version

and some other surprises

August 23, 2022

Email is part of communication, below different examples how to set email inside ClicShopping

Example 1 : o2switch.net

User name : myemail@domain.com

- Password : email password
- Server : mail.test.domain.com
- remove mail. and write only test.domain.com
- SMTP Port: 26
- SMTP authentication : true
- SMTP secured protocol : ssl
- Emails activation : true

Example 2 : gmail.com

- User name : myemail@gmail.com
- Password : Utilisez le mot de passe du compte de messagerie.
- Server smtp : smtp.gmail.com
- remove smtp. and write only gmail.com
- SMTP Port: 25 ou 465
- SMTP authentication : true
- SMTP secured protocol : ssl or Tls
- Emails activation : true

August 16, 2022

When Google or other search engines come to your site to read and store the content in its search index, it will look for a special file called robots.txt. This file is a set of instructions to tell search engines where they can look to crawl content and where they are not allowed to crawl content. We can use these rules to ensure that search engines don't waste their time looking at links that do not have valuable content and avoid links that produce faceted content.

Why is this important?

Search engines need to look at and store as many pages that exist on the internet as possible. There are currently an estimated more 4.5 billion web pages active today. That's a lot of work for Google.

It cannot look and store every single page, so it needs to decide what to keep and how long it will spend on your site indexing pages. This is called a crawl budget.

How many pages a day Google will index depends on many factors, including how fresh the site is, how much content you have and how popular your site is. Some websites will have Google index as few as 30 links a day. We want every link to count and not waste Google's time.

What does the suggested Robots.txt file do?

ClicShopping optimised rules exclude site areas with no unique content but instead redirect links to existing topics. Also excluded are areas such as the privacy policy, cookie policy, log in and register pages and so on. Submit buttons and filters are also excluded to prevent faceted pages. Finally, user profiles are excluded as these offer little valuable content for Google but contain around 150 redirect links. Given that Google has more seconds on your site, these links that exist elsewhere eat up your crawl budget quickly.

What is the suggested Robots.txt file?

Here is the content of the suggested Robots.txt file. If your ClicSHoppingis inside a directory, you will need to apply it to the root of your site manually. So, for example, if your community was at /home/site/public_html/myDirectory/ - you would need to create this robots.txt file and add it to /home/site/public_html. It's simple just edit robot.txt and change inside the information

example of robot.txt

Note : domain.ltd must be changed by your domain.

# Rules for ClicSopping (https://www.clicshopping.org)

User-Agent: *

# Block pages with no unique content

Disallow: /Account/LogIn/

Disallow: /Account/CreatePro

Disallow: /Account/Create

Disallow: /Account/PasswordForgotten

Disallow: /Search/AdvancedSearch/

Disallow: /Search/Q/

# Block faceted pages and 301 redirect pages

Disallow: /*?page=

Disallow: /*?sort=

# Sitemap URL

Sitemap: https://domain.tld/index.php?Sitemap&GoogleSitemapIndex

August 13, 2022

The version 3.323 allows to use htaccess to rewrite the url.

To use this function you must activate in Shop/SEO urls this 2 options

1 - Use Search-Engine Safe Native URLs

this option rewrites the url like this :

 https://demo.clicshopping.org/index.php/Products/Description/logitech-trackman-marble-mouse/Id-12

and

2- Use Search-Engine Safe URLs Pro (with htaccess)

This option rewrites the url like this :

https://demo.clicshopping.org/Products/Description/logitech-trackman-marble-mouse/Id-12

To use the last option, you must include inside your root an htaccess with this syntax. Of course, it can updated in function of your server.

note : This option works only on the catalog without customer, if your are logged you will see the url above. It's optimized only for the search engine.

For apache 2.4

##################################
# url rewiting
#improve url rewriting
#work fine without directory https://mydomain.com/test/index.php
#the rewriting must be activated inside the application
# uncomment
##################################

<IfModule mod_rewrite.c>
RewriteEngine On
DirectorySlash Off

#
# Remove WWW
#
RewriteCond %{HTTP_HOST} ^www\.(.+)$ [NC]
RewriteRule ^ https://%1%{REQUEST_URI} [R=302,L]

#
# Remove Trailing Slashes
#
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{THE_REQUEST} \s(.+?)//+[?\s]
RewriteRule ^ %1 [R=302,L]

#
# Reroute to index.php
#
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php/$1 [L]

</IfModule>

March 7, 2021

Hello,

Thank you for you comment, it's always welcome.

@Juliana,

Yes you can always use the last image gallery but you must follow this process
- Do not remove the jquery hooks because the module use jquery - For this version, we do not touch on the module - No pb

- You must change inside the image gallery these elements :

edit : pi_products_info_gallery.php

Inside sql configuration : 'configuration_title' => 'Where do want to display the gallery position ?',

update by this

'set_function' => 'clic_cfg_set_boolean_value(array(\'float-end\', \'float-start\', \'float-none\'))',

Of course, remove and reinstall it.
I will push when I have a little time a specific module in the marketplace and github community.

November 26, 2020

Hello @Rantanplan,

little late but there an example. You can find this code the apps category

You can create another if you add information inside the json or you can add inside the includes/Modules directories. Goofd luck

<?php
  /**
   *
   * @copyright 2008 - https://www.clicshopping.org
   * @Brand : ClicShopping(Tm) at Inpi all right Reserved
   * @Licence GPL 2 & MIT
   * @licence MIT - Portion of osCommerce 2.4
   * @Info : https://www.clicshopping.org/forum/trademark/
   *
   */

  namespace ClicShopping\Apps\Catalog\Categories\Module\Hooks\ClicShoppingAdmin\DashboardShortCut;

  use ClicShopping\OM\Registry;
  use ClicShopping\OM\HTML;
  use ClicShopping\OM\CLICSHOPPING;

  use ClicShopping\Apps\Catalog\Categories\Categories as categoriesApp;

  class DashboardShortCutCategories implements \ClicShopping\OM\Modules\HooksInterface
  {
    protected $app;

    public function __construct()
    {
      if (!Registry::exists('Categories')) {
        Registry::set('Categories', new categoriesApp());
      }

      $this->app = Registry::get('Categories');

      $this->app->loadDefinitions('Module/Hooks/ClicShoppingAdmin/DashboardShortCut/dashboard_shortcut_categories');
    }

    public function display(): string
    {
      if (!defined('CLICSHOPPING_APP_CATEGORIES_CT_STATUS') || CLICSHOPPING_APP_CATEGORIES_CT_STATUS == 'False') {
        return false;
      }

      $output = HTML::link(CLICSHOPPING::link(null, 'A&Catalog\Categories&Categories'), null, 'class="btn btn-primary btn-sm" role="button"><span class="fas fa-list" title="' . $this->app->getDef('heading_short_categories') . '"') . ' ';

      return $output;
    }
  }

October 31, 2020

Hello @AlwaysSkint,

Some people here have not your knowledge, your experience can help but with respect. It's a credo on this forum,

Thank you

January 13, 2020

Hello,

Just a note , I just published the Release 3.2131 see announcement for more explanations.

December 10, 2019

With PHP 7.4, support for preloading was added, a feature that could improve the performance of your code significantly.

In a nutshell, this is how it works:

- In order to preload files, you need to write a custom PHP script

- This script is executed once on server startup

- All preloaded files are available in memory for all requests

- Changes made to preloaded files won't have any effect, until the server is restarted

If you want more information, some article are available on this new feature.

library used (under MIT licence):
https://github.com/DarkGhostHunter/Preloader

1 / Mandatory Requirement
- Php 7.4 minimum version
- opCache installed
- An access to your php.ini
- Work in 777 chmod

2 / How to implement :

Step 1 : Know your path
You must know your root on preloader.php inside your application. below an example

www/var/..../shop/includes/ClicShopping/Work/Log/preloader.php

Step 2 : Php.init implementation
Edit your php.init and search this line :

;opcache.preload=

replace by your root path : below an example

opcache.preload=/home/www/..../shop/includes/ClicShopping/Work/Log/preloader.php

Step4 : Restart apache2

Make this command inside your terminal

sudo service apache2 restart

Step5 : Configure ClicShopping

* Go to ClicShopping Administration
- Menu Configuration / Session & Cache / Compression & optimization
- Activate the preload functionnalities

* Go to your catalog and actualise a page
- The sytem will create a preloader.php file inside your Work/Log directory
- You can check if everything is correct in editing your preload.php files. You must see some information inside.

December 1, 2019

Hello,

@Drack, thank you for this report, updated.
The ClicShopping Core seems to work fine with php 7.4, just the external libraries must be updated eventually, for that we must wait the developer to make the work.
If I see something, I will update the core.

There, the elements can put eventually a problem after a quick search (I do not say, you will have an error, more test must be again done) :
base on this information : https://www.php.net/manual/fr/migration74.deprecated.php

Using array_key_exists() on objects (some external libraries) ¶

Magic quotes functions (ckeditor) ==> no impact

November 13, 2019

Hello,

To react at this topic, I pushed a new minor version with all the composer libraries updated.
This version has some update like ckeditor, Elfinder and some fix.

If you have not included new composer library, you can easily update your solution else you must make the command composer unpdate inside the Shop directory or where you can find the composer.json in the ClicShopping root directory.

November 5, 2019

Hello,

@Patricks describe well what you must make and also take time to learn and test.

About the demo and master, the demo show you how to use different themes but the default is the same than you have on Github, after you can change some setting inside modules ou default configuration or apps.

For the demo, I just created a specific theme and put just the file need to be change but you also can create your own module and call your own template.

Note, the default template is the "referent" for the files, if you create a new template with new module and change after in other template without this module, errors can appear. You can resolve that if you bring you new module inside the default template.

The new template override just the files in the default template. Limit all the css must copied in the new template

November 2, 2019

Just a little note.

PHP 7.4 is out soon (end of this month) and bring lot of new features or deprecated features.

I will start to stest ClicShopping under php 7.4 soon

If you see something report on Github (ClicShopping, Official and community) the error or the bug.
If you have time.

November 2, 2019

The menu can have different function

For example if you want to create a marketplace you have 2 choices

Create the menu in manual mode

Create the menu via the apps automatically

Manual is not recommended on this case when you create an apps because the administrator must do a manual action on the menu and after install the apps with the instructions.

Like all menu has a specific code. It s possible to re-organise the menu if you do not appreciate.

Access to this menu allow you to know the good code and id for a programmer when he creates a new apps inside the menu of his choice.

The best is to look inside the Configure directory the different files (Install and Delete) the approach.

About the modules inside the catalog (template), you have nothing to do.

October 28, 2019

Included in 3.2111 new release who fix some bug indentified in 3.2110.

October 27, 2019

hello @SuperThin,

Could you test (on several specific world) this please and tell me if it work ?

in includes/Shop/RewriteUrl.php - change the function by this.

In it's work it will be added on next update.

I take different work on your website, and seems now ok inside the the url

Thank you for your comment @SuperThin

/**
     * Remove url accent
     * @param $str
     * @param string $charset
     * @return null|string|string[]
     */
    protected function getSkipAccents(string $str, string $charset = 'utf-8'): string
    {

      if (!extension_loaded('intl')) {
        throw new Exception('intl module not loaded');
      } else {
        $transliterator = \Transliterator::create('Any-Latin; Latin-ASCII');
        $str = $transliterator->transliterate(mb_convert_encoding(htmlspecialchars_decode($str),$charset, 'auto'));
      }

      $str = htmlentities($str, ENT_NOQUOTES, $charset);

      $str = preg_replace('#&([A-za-z])(?:acute|cedil|caron|circ|grave|orn|ring|slash|th|tilde|uml);#', '\1', $str);
      $str = preg_replace('#&([A-za-z]{2})(?:lig);#', '\1', $str);
      $str = preg_replace('#&[^;]+;#', '', $str);
      $str = preg_replace('/[^A-Za-z0-9\-]/', '', $str); // Removes special chars

      return $str;
    }

October 19, 2019

Fixed. Just is it possible to report a bug on this page. It's better to manage than this bug that the forum :
https://github.com/ClicShopping/ClicShopping_V3/issues

October 18, 2019

@SuperThin

Just a question when you will are finish to translate ClicShopping in Vietnamese, Are you agree to share your work ?
If yes, just contact me by mail, i will explain you the process.

October 15, 2019

Hello

I make an update about the composer who can create automatically an htaccess in shop directory and when you install application and the site is not accessible.

I change the json configuration to resolve that.

About chmod if your hoster do not allow to include new file or create new directory. You must do that manually.

For you the most important directory and sub directory are :

Includes/clicshopping/work in 777 and sub

Sources/images in 777 and image

The chmod can be changed with your ftp

Check also is your hoster accept composer (commande). Now, if you want install a payment for example, composer is required in your server.

If the automatic install do not work you have no choice to download the apps you make an install manually in your case

You have some tutorials on the website to do that how to install in manual an apps

The best is to have a local website, to install local and after to export in your server.

I hope it can help you to resolve your problem.

October 11, 2019

Hello,

Just for information, An update has been made, now, it's possible to :

update all the library

update one library

clear the cache

compare the version installed with the latest version.

Just a warning, you must be careful when you make an update because it can create an error inside your apps.

Make for the expert.

October 8, 2019

hello,

@SuperThinI:

fixed the problem, you can find the files modified there : https://github.com/ClicShopping/ClicShopping_V3/commit/8d21913e9fb17242b57fe202a2a94c62e10d89f4

Thank you for this report.

August 28, 2019

@Drack, Thank you for this great help

This fix will be included for 3.2107 version

August 15, 2019

If you hoster use MyISAM for their SGBD

You can not install ClicShopping because it Use Innodb

If you see a message like this when you try to install ClicShopping :

SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown storage engine 'innodb'

You can try to resolve the problem with this process :

1 - Install manually the Database called : clicshopping_en_MyIsam.sql located inside install directory via your phpMyAdmin import Db (no data included inside)

3 - Continue the installation process without to install the Db.

Sign In

Profiles

Forums

Blogs

Store

Downloads

Gallery

Posts posted by ClicShopping

Important Information