Hi Bryan,
To confirm, did you mean that an applied_tax has a tax_uid field directly related to the uid field on order’s taxes (relation shown using the green arrow)?
If yes, what about the tax from the catalogue? Its id is exactly the same as uid of the tax from the taxes (red arrow relation). I think it can’t be a coincidence. And it wouldn’t be weird if this relation was created by the catalog_object_id on the taxes field as usual - especially when the sale source is Square Online.
Isn’t this a thing directly managed by you? Or by saying, “This is due to the way the order was created with the Square Online Store” you mean that one day you were doing this in such a peculiar way? So, instead of storing an id of catalogue tax on the catalog_object_id field, you were just sharing the identifier when those objects were related?
Please confirm. I will be so much thankful.
Thanks.