Improvement: Include MAP in Update Query Logic

The current Update Pricing feature updates active_map and lrp fields in v4_product_data, but it does not include updates to the map column. This omission causes data inconsistencies between displayed MAP values and the actual pricing structure used in the business logic.

Root Cause Analysis (RCA)

  • Existing SQL statement omitted the map column from the SET clause.

  • The original assumption that active_map always mirrors map is outdated.

Please authenticate to join the conversation.

Upvoters
Status

Completed

Board
πŸ’‘

Feature Request

Date

5 months ago

Author

Jon Slyman

Subscribe to post

Get notified by email when there are changes.