Product XML Export Create not working

[brucezly]

Hello,

ID filter works perfect.

But since 2.0.396, not work the export. Not even ajax.

[admin]

hello, the latest OPC expects CLI to be used. let me know how you export the products, how many of them you got. most of our customers have access to CLI which is not limited by RAM. normally web accesses are limited to 128 to 256mb and some of the OPC exports per 100 000 products may require up to 10gb of ram.

let me know which export are you using and i'll check it locally. you may lower the "batch" some a minimum number of products to see if it helps.

best regards, stan

[edwin@.....tk]

Oke i'm trying the Google Merchant Export, but it doesn't work.

I have installed all the latest versions:
- Joomla 3.9.25
- Virtuemart 3.8.8 10472
- OPC 2.0.404.011220

I have also added the plg_vmaddtabs.

Then i have configured the whole XML settings and associated all the categories.

When i start creating a XML the step indicator shows and with the final step i apairs to run in a loop. Nothing is saved in the xml file
So i tried the test product id to only generate one product in the xml. Same result
The I tried running the command that is used by the crom job in a SSH session, also not the result i hoped for (lots of DEBIG messages, but no XML file)

What am i doing wrong?

[admin]

hello, i suggest to use CLI from CRON this way:

(assuming cpanel or similar setup)
1. ideally create
/home/{your user}/cron.sh
file and mark it as executable (chmod +x cron.sh )

2. content should be:
#!/bin/bash
/usr/local/bin/php /home/{your user}/public_html/administrator/components/com_onepage/cli.php --task=xmlexport --myurl=https://{your domain}/ --debug=1

3. in cpanel create a cron job:
/home/{your user}/cron.sh

to be run once a day

OR
directly within the cpanel setup enter cron job as:
/usr/local/bin/php /home/{your user}/public_html/administrator/components/com_onepage/cli.php --task=xmlexport --myurl=https://{your domain}/ --debug=1 --override_jroot=/home/{your user}/public_html

if the shop is too large CLI is much more reliable way of running the exports and slow tasks. CLI is not limited by timeout and can have much larger memory support.

if this doesn't help you, pls write me an email to info @ rupostel.com and i can invetigate the issues on your site directly - usually problems are caused by "gzip" compression + timeouts in apache or php + too few memory for direct access, etc...

best regards, stan

[admin]

hello,
the resulting XML file is stored in your
{site root}/export
directory as configured at OPC Product XML Export section (usually it's 'export/' )

it uses multiple temporary XMLs within the directory which it then merges into one.

best regards, stan

[joomla@.....de]

I'm trying to load the German version (https://www.google.com/basepages/produc ... .de-DE.txt) instead of the default taxonomy file (https://www.google.com/basepages/produc ... .en-GB.txt). But unfortunately this has no effect. The English version is still displayed in the selection lists of the category assignments.

[joomla@.....de]

Unfortunately, when I try to go to the "Download XLS for manual category pairing" link on the category pairing page, I only get an error:

0 Argument 1 passed to PhpOffice\PhpSpreadsheet\Shared\StringHelper::strToLower() must be of the type string, null given,
called in /***/cmsJ/libraries/vendor/php-office/PhpSpreadsheet-master/src/PhpSpreadsheet/Calculation/LookupRef/VLookup.php on line 87