🔍 Publish Date Debug (Mass Upload Support)

Current Date: 2026-06-17

Current DateTime: 2026-06-17 09:34:52.807776

Total Products (no filter): 50

Auto-filtered Products (model layer): 50

⚠️ No products being filtered (all have valid dates or no dates set)

✅ Field found: x_studio_to_publish_on (Type: date)

All Products (including future-dated):

IDNamePublish DateCreatedShould Show?In Filtered List?
451086MOKOKIMO Campus Series2026-06-162026-06-16 07:58✅ YES✅ YES
451085(SA) Don! Liazrd2026-06-162026-06-16 07:55✅ YES✅ YES
451013Warhammer Colour Paints: Base - Averland SunsetNot set2026-06-14 09:06✅ YES (no date set)✅ YES
451012Warhammer Colour Paints: Base - Jokaero OrangeNot set2026-06-14 09:06✅ YES (no date set)✅ YES
451011Warhammer Colour Paints: Base - Mephiston RedNot set2026-06-14 09:06✅ YES (no date set)✅ YES
451010Warhammer Colour Paints: Base - Khorne RedNot set2026-06-14 09:06✅ YES (no date set)✅ YES
451009Warhammer Colour Paints: Base - Naggaroth NightNot set2026-06-14 09:06✅ YES (no date set)✅ YES
451008Warhammer Colour Paints: Base - Daemonette HideNot set2026-06-14 09:06✅ YES (no date set)✅ YES
451007Warhammer Colour Paints: Base - Kantor BlueNot set2026-06-14 09:06✅ YES (no date set)✅ YES
451006Warhammer Colour Paints: Base - Macragge BlueNot set2026-06-14 09:06✅ YES (no date set)✅ YES
451005Warhammer Colour Paints: Base - Caledor SkyNot set2026-06-14 09:06✅ YES (no date set)✅ YES
451004Warhammer Colour Paints: Base - Stegadon Scale GreNot set2026-06-14 09:06✅ YES (no date set)✅ YES
451003Warhammer Colour Paints: Base - Incubi DarknessNot set2026-06-14 09:06✅ YES (no date set)✅ YES
451002Warhammer Colour Paints: Base - Caliban GreenNot set2026-06-14 09:06✅ YES (no date set)✅ YES
451001Warhammer Colour Paints: Base - Waaagh! FleshNot set2026-06-14 09:06✅ YES (no date set)✅ YES
451000Warhammer Colour Paints: Base - Castellan GreenNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450999Warhammer Colour Paints: Base - Death World ForestNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450998Warhammer Colour Paints: Base - Zandri DustNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450997Warhammer Colour Paints: Base - Steel Legion DrabNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450996Warhammer Colour Paints: Base - Bugman'S GlowNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450995Warhammer Colour Paints: Base - Ratskin FleshNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450994Warhammer Colour Paints: Base - Mournfang BrownNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450993Warhammer Colour Paints: Base - Xv88Not set2026-06-14 09:06✅ YES (no date set)✅ YES
450992Warhammer Colour Paints: Base - Rhinox HideNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450991Warhammer Colour Paints: Base - Dryad BarkNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450990Warhammer Colour Paints: Base - Mechanicus StandarNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450989Warhammer Colour Paints: Base - Abaddon BlackNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450988Warhammer Colour Paints: Base - Celestra GreyNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450987Warhammer Colour Paints: Base - Rakarth FleshNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450986Warhammer Colour Paints: Base - LeadbelcherNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450985Warhammer Colour Paints: Base - Screaming BellNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450984Warhammer Colour Paints: Base - Warplock BronzeNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450983Warhammer Colour Paints: Base - The FangNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450982Warhammer Colour Paints: Base - Screamer PinkNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450981Warhammer Colour Paints: Base - Retributor ArmourNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450980Warhammer Colour Paints: Base - Thousand Sons BlueNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450979Warhammer Colour Paints: Base - Death Guard GreenNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450978Warhammer Colour Paints: Base - Ionrach SkinNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450977Warhammer Colour Paints: Base - Phoenician PurpleNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450976Warhammer Colour Paints: Base - Death Korps DrabNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450975Warhammer Colour Paints: Base - Gal Vorbak RedNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450974Warhammer Colour Paints: Base - Night Lords BlueNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450973Warhammer Colour Paints: Base - Nocturne GreenNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450972Warhammer Colour Paints: Base - Corvus BlackNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450971Warhammer Colour Paints: Base - Lupercal GreenNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450970Warhammer Colour Paints: Base - Iron Hands SteelNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450969Warhammer Colour Paints: Base - Grey Knights SteelNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450968Warhammer Colour Paints: Base - Balthasar GoldNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450967Warhammer Colour Paints: Base - Iron WarriorsNot set2026-06-14 09:06✅ YES (no date set)✅ YES
450966Warhammer Colour Paints: Base - Baraknar BurgundyNot set2026-06-14 09:06✅ YES (no date set)✅ YES

Summary: 50 should be visible, 0 should be hidden

Testing Instructions for Mass Upload:

  1. CSV Import: Include column 'x_studio_to_publish_on' with dates in format: YYYY-MM-DD or YYYY-MM-DD HH:MM:SS
  2. Future dates: Set dates AFTER 2026-06-17 to hide products
  3. Past dates: Set dates BEFORE or equal to 2026-06-17 to show products immediately
  4. Empty dates: Leave blank to show products immediately
  5. Verification: Refresh this page after import to see filtering in action