Timestamp when product was last available

Created on 11 December 2024, about 1 month ago

Problem/Motivation

On one site we would like to send notifications to users when there were products that are not available for X days.

Currently the 'renewal' time in the amazon_product_widget_key_value table is used to store when the product was last updated (via API request to Amazon). This is fine.

Would be a neat addition if a column would be added to signify when was the last time the product was available. Suggestion would be 'last_available'. Meaning, this would be the timestamp when the 'available' column switched from true to false. If the product becomes available again the column could either be set to the same value as renewal or set to NULL.

Steps to reproduce

None.

Proposed resolution

Introduce a column in amazon_product_widget_key_value 'last_available' that would store the timestamp at which the product was still available.

Remaining tasks

User interface changes

API changes

Data model changes

Feature request
Status

Active

Version

1.5

Component

Code

Created by

🇸🇮Slovenia miha.wagner

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Merge Requests

Comments & Activities

Production build 0.71.5 2024