电子商务系统变更管理
所以，我有一个电子商务网站。该网站有一些项目，这些项目又包含附件、定价和订单表格等。
我正在寻找处理定价、表格等变化的方法。如果定价结构发生变化，新订单的反映没有问题，但是如何我要保持订单历史记录完整吗？
例如，定价选项是预先设置的，如下所示，我将定价 ID 存储在订单上：
100 - $150
200 - $280
如果用户在后端更新定价，订单历史记录将显示不正确的定价
似乎是一种以某种方式保留原始定价的方法在遗留表中？或者只是转储这些东西的硬拷贝值？
任何建议将不胜感激。
So, I have an e-commerce site. This site has items, which in turn have attachments, pricing, and a order form etc.
I'm looking for approaches to handle changes in pricing, forms etc. If a pricing structure changes, it's reflected for new orders no problems, but how do I keep the order history intact?
E.g pricing options are pre-set like following, and I store the pricing ID on the order:
100 - $150
200 - $280
If a user updates the pricing in the back-end, the order history will show incorrect pricing
Seems to be an approach of keep the original pricing somehow in a legacy table? Or just dump hard copy values for these things?
Any advice would be appreciated.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
更新定价时，应将原始值附加到价格历史记录表中，该表显示价格、有效日期范围以及项目的外键。
这是一种标准化的方法；它不涉及复制数据。可能需要预先进行一些额外的设计/编码，但请将其视为将来给您自己（和您的团队）的礼物。您将可以随时查询准确的价格变动历史以及订单数据。
When the pricing is updated, the original values should be appended to a price history table that shows the price, the date range during which it was valid, and a Foreign Key to the item.
This is a normalized approach; it doesn't involve copying data. It may take a little extra design/coding up front, but consider it a gift to yourself (and your team) in the future. You will be able to query for an accurate history of price changes as well as order data at any time.