Amazon is notorious for restating sales data within a 14-day window from when it is posted. This causes issues with the validity of reporting for the most recent days of extraction.

To ensure we can extract valid data that is up to date, we require some process to either re-sync data at the table level for Amazon connectors or set a window for each scheduled sync to repull the most recent record of historical data within a rolling 14-day window to ensure we capture Amazon restatements as they are posted.

impacted tables:

vendor_inventory_manufacturing_fresh_asin_report_daily

vendor_inventory_manufacturing_retail_asin_report_daily

vendor_inventory_sourcing_fresh_asin_report_daily

vendor_inventory_sourcing_retail_asin_report_daily

vendor_sales_manufacturing_business_asin_report_daily

vendor_sales_manufacturing_fresh_asin_report_daily

vendor_sales_manufacturing_retail_asin_report_daily

vendor_sales_sourcing_business_asin_report_daily

vendor_sales_sourcing_fresh_asin_report_daily

vendor_sales_sourcing_retail_asin_report_daily

sales_and_traffic_business_child_asin_report_daily

sales_and_traffic_business_parent_asin_report_daily

sales_and_traffic_business_sku_report_daily