bsmither Posted February 1, 2020 Share Posted February 1, 2020 It won't be the CubeCart_order_inventory insertions of the items for the order -- this definitely happens after the CubeCart_order_summary insertion happens. We are looking for an insertion before the order summary gets databased. Link to comment Share on other sites More sharing options...
bsmither Posted February 1, 2020 Share Posted February 1, 2020 Finished my experiments and have concluded that the trigger's LAST_INSERT_ID catching the value from having made an insertion into the CubeCart_order_tax table -- for those stores that could make a sale that includes tax. Should a store be set up so that taxes might not be applied, then the LAST_INSERT_ID may be catching the value from some other table's insertion -- if the integer part of the custom order_id does not match what is expected (see earlier discussion). Link to comment Share on other sites More sharing options...
Dirty Butter Posted February 1, 2020 Share Posted February 1, 2020 I hope I helped a litte, but I don't think I understand some of your comments on my information enough to be any more help. It sounds like you have pin pointed the issue, though. Fingers crossed Link to comment Share on other sites More sharing options...
bsmither Posted February 1, 2020 Share Posted February 1, 2020 In addition to the possible insertion of a database record of tax details on the sale, there could also be the possible insertion of a database record of coupon/giftcert usage on the sale in the CubeCart_order_notes table. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.