Skip to content

1.11.14

⚙️ Patch 1.11.14 — Sellerlogic FBA/FBM export safety, SKU heal, Autocalculate

🚀 Summary

Fixes Sellerlogic FBA/FBM cross-channel overwrites, stale FBA seller_sku vs product_url, token refresh on UUID credentials, richer reprice notes, FBA seller SKU search, and Autocalculate Rules staying on for penner/renner articles.

✨ Details

Area Behavior
Token refresh sellerlogic_credentials.id mapped as Postgres uuid (+ naive datetimes) so token UPDATE no longer fails with uuid = varchar and blocks FBM/FBA export
Reprice notes Sellerlogic comments include fulfillment, article_sku, and seller_sku for FBA and FBM
Cross-channel guard Reprice no longer updates the other stock type when FBA and FBM share a merchant SKU (removes dangerous skip_stock_type_filter write fallback)
FBA seller_sku sync Sync always takes the live Sellerlogic merchant SKU; heals stale seller_sku from product_url at sync start; single-ASIN sync fetches by ASIN, not a stale SKU
FBA UI search FBA articles filter bar: Search Seller SKU… (same as FBM)
Autocalculate Rules Enabling use_min_max_rules on penner/renner no longer gets forced back to false by post-save recalc; wave profit-only only while rules are off

📌 Notes

  • Redeploy service-multi-repricer and frontend.
  • Run an FBA sync (or open/sync affected ASINs) so remaining stale seller_sku rows heal from product_url / Sellerlogic.
  • Shared SKU example that motivated the guard: FBM KL-T0F1-ML3Q vs FBA ASIN B01EXQ582Q (correct FBA SKU TR-288O-07CW).

✅ Verify

  1. FBM/FBA export authenticates (no uuid = character varying on sellerlogic_credentials).
  2. After a reprice, Sellerlogic notes show fulfillment=… article_sku=… seller_sku=….
  3. FBA sync on B01EXQ582Q → seller_sku matches product_url (TR-288O-07CW); FBA export no longer writes FBM bounds onto the FBM listing.
  4. FBA tab → Search Seller SKU finds the merchant SKU.
  5. Edit FBA details on a penner article → enable Autocalculate Rules → save → flag stays Yes and full SP-API recalc runs.

📁 Files

  • backend/service_multi-repricer/app/schemas/sellerlogic.py — UUID id, NAIVE_DATETIME
  • backend/service_multi-repricer/app/services/sellerlogic/sellerlogic_credentials.py — naive Berlin token timestamps
  • backend/service_multi-repricer/app/crud/sellerlogic.py — UUID id helpers
  • backend/service_multi-repricer/app/services/sellerlogic/sellerlogic_manager.py — notes + no cross-fulfillment reprice
  • backend/service_multi-repricer/app/api/v1/endpoints/fba_articles.py — seller_sku heal/sync, rules-vs-wave recalc
  • backend/service_multi-repricer/app/api/v1/endpoints/fbm_articles.py — rules-vs-wave recalc
  • backend/service_multi-repricer/app/tests/test_sellerlogic_reprice_verify.py, test_fba_seller_sku_heal.py
  • frontend/src/pages/MultiRepricer/Tabs/FBA/FBAArticles.jsx — seller SKU search + penner/renner hint
  • docs/docs/patchnotes/1.11/1.11.14.md — this file