j2 commerce assigning the same SKU to all products. Joomla 5.4

Hi There,

I'm using j2 commerce on Joomla 5.4, and for every new product I create from scartch, all existing products get assigned the same SKU, meaning only 1 item is visble in the store. I'm using MySQLi, is there a fix for this bug?

Thanks

Hi Olivier,

I'm creating a downloadable product. So what's happening is that, if I change the SKU in one of them, it changes everything to the same SKU, same thing with the price.. If I create a new product, and change the sku in that one.. Then the sku of all products, and the price reverts to the SKU of the last one created.. 

I've cleared out the database after uninstalling the plugin, I tried to use chatGPT to create a unique SKU fiels in the database.. but this didn't work.

Really stumped.

I'll attach a video just to sow you what happens..

https://drive.google.com/file/d/1O6mKEFyIbGUtdGg-Ve5ksyB235GovfuX/view?usp=sharing

Any help would be greatly appreciated.

Thanks

Gio

Hi Olivier,

I'm developing the site on wampserver. I'll attach system info with this message. The easiest way might be for me to send you the site and database, and you can have a playaround on your end.

Ehat version of PHP and mysql are you using?

Thanks

Gio

Hi Olivier,

So uninstalled what I had originally installed by doing a pull from the github page, and installed the 4.09 com version. From your site, and it seems to be working well. Deleted all entries from the sql database before installing.

Thanks
Gio