Landed cost is a join against a dated rule table, not a column
Most fulfillment systems store the duty assumption where it cannot survive contact with reality. A field on the product row. Sometimes a percentage in a shipping settings screen, entered the day the account was set up and never revisited. It looks like a reasonable denormalization until the first time a rule changes underneath it and forty thousand historical orders quietly become wrong. The reason that shape fails is that duty is not an attribute of a product.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)
Log in to join the discussion and vote.
Log in