Help for Aimeos

I have additional column in mshop_order => order_no
How can I generate unique an order number just before it is saved to the database?

How to upgrade from low version 2021.10 to high version 2024.10 ? Can you describe step by step how to do it so that I don't carry out unnecessary commands etc. ?

aimeos-extensions/new-ext dev-master Aimeos new-ext extension aimeos/ai-admin-jqadm 2021.10.19 Aimeos Vue.js+Bootstrap admin interface aimeos/ai-admin-jsonadm 2021.10.5 Aimeos ai-admin-jsonadm extension aimeos/ai-client-html 2021.10.20 Aimeos ai-client-html extension aimeos/ai-client-jsonapi 2021.1...

I have aimeos/aimeos-laravel ver. 2021.10.7. After composer update appeared to me "Found 6 security vulnerability advisories affecting 3 packages". After doing composer audit i have something like this:


How to fix it ?

Is it possible to do this if someone orders product A in the amount of 3 pieces, so that in the mshop_order_base_product table there will be 3 entries of 1 piece each instead of 1 entry with 3 pieces ?

So when will the release of the new version 2021.10 with these fixes be?

It's working but now I use:
and Maybe I should update aimeos/aimeos-laravel to version 2021.10.x-dev as well ?

After composer update to 2021.10 version when I execute below command: php artisan aimeos:setup I receive error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'statuspayment' in 'where clause': UPDATE "mshop_order_base_product" SET "statuspayment" = -1 WHERE "status...

What exact steps do I need to follow outside of composer to upgrade from 2021.07 to 2021.10?
How big are the differences between 2021.07 and 2021.10 ?

How to do database transaction in Aimeos 2021.07 ? I have a code: $orderCntl = \Aimeos\Controller\Frontend::create($this->context, 'order' ); $basketCntl = \Aimeos\Controller\Frontend::create($this->context, 'basket' ); $this->setAddress($req); $basket = $basketCntl->store(); //begin transaction $or...