fix: obsolete support in update_all_products.pl and export status fix on producers platform

[stephanegigandet]

What

• When exporting obsolete products from the pro platform to the public platform, we were not updating their export status on the obsolete collection of the pro platform (and instead created them on the non obsolete collection).
• This PR fixes the export status, and also add support for selecting the obsolete collection in update_all_products.pl, + an option to remove obsolete / non-obsolete products that are not in the appropriate collection.

16019 products updated (pretend: ) - 0 new versions created
9227 removed from wrong collection (obsolete or current)
off@off1:/srv/off-pro/scripts$ ./update_all_products.pl --query owners_tags=org-auchan-apaw --fix-obsolete 

Part of

• 🗄 Obsolete products (tracker) #8814

[sonarcloud]

Kudos, SonarCloud Quality Gate passed!   

0 Bugs
0 Vulnerabilities
0 Security Hotspots
0 Code Smells

No Coverage information
No Duplication information

[codecov-commenter]

Codecov Report

Merging #8811 (ff36a31) into main (e38efae) will not change coverage.
The diff coverage is 0.00%.

@@           Coverage Diff           @@
##             main    #8811   +/-   ##
=======================================
  Coverage   48.76%   48.76%           
=======================================
  Files         118      118           
  Lines       21998    21998           
  Branches     4889     4889           
=======================================
  Hits        10727    10727           
  Misses       9967     9967           
  Partials     1304     1304           

Files Changed	Coverage Δ
lib/ProductOpener/Import.pm	30.67% <0.00%> (ø)

📣 We’re building smart automated test selection to slash your CI/CD build times. Learn more

[teolemon]

I have created a tracker issue for obsolete product issues, and a call for documentation of our policies/behaviours on the wiki

[alexgarel]

LGTM