Extend order table for data import/export

Help for integrating the Laravel package
Forum rules
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
MikaelNazarenko
Expert
Posts: 274
Joined: 27 Jun 2019, 16:19

Extend order table for data import/export

Post by MikaelNazarenko » 27 Sep 2019, 07:11

I need to export and import orders between aimeos and external software. For this I need filed in order table, it is something like id from external software. Please, don't ask me why I do it so - it is task feature. I didn't see the filed for this purpose in order like 'code' in product. So I am only asking in in which table can I add new field, mshop_order or mshop_order_base ? Or I may use some existing field for this ?

Thank you very much !

User avatar
aimeos
Administrator
Posts: 7873
Joined: 01 Jan 1970, 00:00

Re: Extend order table for data import/export

Post by aimeos » 27 Sep 2019, 09:26

In mshop_order_base there's a field named "customerref" you can use for that purpose:
https://github.com/aimeos/aimeos-core/b ... er.php#L34
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply