Hi,
There is no item table. The custom item fields are added as columns in both the hikashop_cart_product and the hikashop_order_product tables since the custom item fields data needs to be stored together with the product in the cart and in the order.
So you'll find the data there.
The problem can come from several things:
- You don't have all the patches that we added in June for the custom item fields. So check the build number next to the version number in the HikaShop configuration. The first numbers of the build number correspond to the date. For example, a build number like 1707241513 indicates that you have all the patches we published for HikaShop 3.1.1 until the 24th of July 2017. So in the case of @a2zcs, it should not be a problem. If unsure, just download the install package on our website and install it on yours and you'll get all the latest patchs.
- You have a custom override of the email. Go in the menu System>Emails and check that the customization columns there are empty for the emails for which you have the problem.
- The settings of the custom field in the database do not reflect what you see when you edit the custom field. Save the custom field settings once to avoid that.
- The data of the custom field is missing in the database. If you have the custom item field displayed on the products listing of the order details page in the backend, then it is not that problem.
On my end, I tested a custom item field with a restriction on a product with variants:
monosnap.com/file/V3bwKxGbWq1g4p6JMyss63EfmUsvJO
monosnap.com/file/VLoI92fVynymt0awEXNyiPwH3aP4y7
And as you can see, the custom item field is displayed on the notification email.
So I don't see how it could be a bug in HikaShop.
1. com_hikashop_business_v3.1.1_2017-08-01_03-19-54.tar / HikaShop Business 3.1.1 [1707282317]
2. Yes I did on a single email. I believe it's not the admin email any AND I also removed the override, then tested, and still not fixed.
3. Resaved custom field, tested, not fixed
4. I can not see the custom field in the backend order view. How do I test this further?
Thanks again for the help.