Add Product Data Source Flagging in Database

We need the system to clearly track where each product value comes from (e.g., prices, specs, images, etc.). Right now, the database does not store this information, which makes it difficult for our team to debug issues such as incorrect prices or missing specs. When something looks wrong, it’s hard to identify which system last updated the value.

In addition to improving debugging, we also need this for future access-control logic for example, showing authorized data only to specific clients and hiding restricted data from others.

To solve this, we are requesting the backend to add proper source flagging for all key product fields.

The requirements include:

• Define a controlled list of source types (official_api, official_website, almo, eastern_marketing, spreadsheet, manual_edit, etc.).

• Update the database schema so each important product value includes a source.

• Ensure all update flows automatically write the correct source.

• Provide documentation so our team can quickly check the source of any value.