Help for Aimeos

Laravel: 5.6
Aimeos: 2018.04
PHP: 7.1.18

Hi,

So, I need to modify each order in administration panel. I want to give administrator the flexibility to add additional notes with each order and I was going through Aimeos database to understand, which table would be best for this type of thing and I came across "mshop_order_base_product_attr" table. So, I was wondering what is the purpose of this table?

Can you please, explain what data will be stored inside "mshop_order_base_product_attr?" Because currently, it is empty on my side.

Do you guys have proper documentation for all database tables? So, I can understand purpose of each table.

Thanks!

What kind of notes do you want to add? There's a comment field in the mshop_order_base table but that's usually for customer comments. In the mshop_order_base_product_attr and mshop_order_base_service_attr tables you can store arbitrary information (code, type, value) and for products it's used to store information about the selected attributes while in the service_attr table information about the delivery/payment services is stored.

There's no full documentation of all tables because Aimeos tables are pretty generic but there's an ERM diagram for the table relations: https://aimeos.org/docs/Developers#Database

aimeos wrote:What kind of notes do you want to add? There's a comment field in the mshop_order_base table but that's usually for customer comments. In the mshop_order_base_product_attr and mshop_order_base_service_attr tables you can store arbitrary information (code, type, value) and for products it's used to store information about the selected attributes while in the service_attr table information about the delivery/payment services is stored.

There's no full documentation of all tables because Aimeos tables are pretty generic but there's an ERM diagram for the table relations: https://aimeos.org/docs/Developers#Database

Hi,

Thanks for the reply. Actually, my client want to add note to each purchased item in an order. So, I guess I need to install multiple entries for single order. I shall see which tables suits this scenario. Otherwise, I shall create a new table.

Thanks!

You should then use the mshop_order_base_product_attr table where you can store arbitrary information for each product

aimeos wrote:You should then use the mshop_order_base_product_attr table where you can store arbitrary information for each product

OK thanks!