Skip to content

1.4.3

🚀 New Features

  • Add latest shopping-table data to Google Sheets updates: fetch latest preis_pro_einheit_b, ek_ort, and datum for each SKU and include them in sheet rows for Penner/Renner/OOS.

🔧 Improvements

  • Backend: shopping_price_column, shopping_location_column, and shopping_date_column added to sheet_settings schema and models; multi_bulk_update_rows now supports writing these columns when configured.
  • Backend: plenty_article sheets update now builds a lookup of latest ShoppingTable entries (by asin_sku) and enriches bulk update payloads with shopping price, location and date.
  • Frontend: Settings UI (PennerRennerSheetSettings.jsx) updated to expose the three new sheet column settings for both Amazon and Plenty, including load/save/clear logic.
  • DB: Added migration SQL to add shopping_price_column, shopping_location_column, and shopping_date_column to the sheet_settings table (docker/postgres/updates/sheet_settings_shopping_table.sql).

🐛 Bug Fixes

  • Fix ordering in get_active_sheets_manager: apply override_spreadsheet_id/override_sheet_id before calling ensure_authenticated() to avoid authenticating against the wrong spreadsheet ID.

SQL

ALTER TABLE sheet_settings ADD COLUMN shopping_price_column VARCHAR(255);
ALTER TABLE sheet_settings ADD COLUMN shopping_location_column VARCHAR(255);
ALTER TABLE sheet_settings ADD COLUMN shopping_date_column VARCHAR(255);

Migration file: docker/postgres/updates/sheet_settings_shopping_table.sql