hello, i now tried this:
1. changed the URL within the google taxonomy in Product XML Export -> Google RSS Feeds to:
https://www.google.com/basepages/produc ... .de-DE.txtthen i clicked save
2. then i visited the category pairing (and google categories were in DE)
3. and clicked download categories XLS and i don't see any problem there
you might want to check OPC utilities and see if you are missing any translations within your categories (or other related content) as this is possibly the only place where it could cause a NULL VLOOKUP error in XLS.
if you'd like to reinstall php-office you can remove/rename the directory within your /libraries folder and opc will reinstall it - please note that phpoffice requires the PHP version on which it is installed (so if you install it on php8.1 it cannot be then used on php7.4 for example - it has to be removed or reinstalled then)
in OPC 432 there is a useful section to detect issues on your site with translations:
/administrator/index.php?option=com_onepage&task=showreportlang&view=utils
available as a link from OPC Utilities page (report issues... ) -> this will report any missing translations on VM core stuff (categories+products+shipment+payment+manuf+vendor) as well as any menu associations against published languages.
best regards,stan