To many products? 12.000

Hi,

I’m trying to make a product feed for google merchant center, to have for Google ads.
The generation process keeps getting stucked at some point.

I have tried to set the product batch to 10, to 1000.. but that aint worked either.

Status:

`
WooCommerce Version: 7.0.0 – You are using the latest version of WooCommerce.

Product Types: ? Simpel Product [simple]

? Gegroepeerd Product [grouped]

? Extern/Affiliate Product [external]

? Variabel Product [variable]

Total Products: WP Query: 12007
WC Product Query: 12007
Both Query: 12007

Product Total by Types.

? External Product: 1

? Simple Product: 24

? Variable Product: 11982

? Product Variations: 239971

Product Per Batch: 500

Product Query Type: Both

Default Customer Location: Default Customer Location
Geolocate

Store Address

NL

Multi Language Site: GTranslate is not compatible for multi-language feed. You can not make feed for each language. Supported multi-language plugins are WPML & Polylang.

Multi Currency Site: Below Multi Currency Plugins are compatible with Woo Feed Pro.

? Currency Switcher WooCommerce by Aelia
? WooCommerce Currency Switcher by Realmag777
? WooCommerce Multilingual
? Polylang

WP DEBUG Status: WP_DEBUG is false. If you having any issue with the plugin then set WP_DEBUG to true so that you can find the issue from logs. You can learn more about debugging in WordPress from here.

WP CRON: Ok

Upload Directory: Ok – Writable.

Cache Plugin Installed: No.

WordPress Multi Site: No

Home Url: https://www.kunstinkaart.nl

Site Url: https://www.kunstinkaart.nl

Version: 7.0.0

Log Directory: /var/www/nlkuns-fenoarivo/wordpress/current/wp-content/uploads/wc-logs/

Log Directory Writable: Yes

WP Version: 6.0.2

WP Multisite: No

WP Memory Limit: 1 GB

WP Debug Mode: No

WP Cron: Yes

Language: nl_NL

Server Info: nginx/1.21.4

Php Version: 7.4.29

Php Post Max Size: 64 MB

Php Max Execution Time: 600

Php Max Input Vars: 2.93 KB

Curl Version: 7.85.0, NSS/3.67

Suhosin Installed: No

Max Upload Size: 64 MB

Mysql Version: 5.6.51

Mysql Version String: 5.6.51

Default Timezone: UTC

Fsockopen Or Curl Enabled: Yes

Soapclient Enabled: Yes

Domdocument Enabled: Yes

Gzip Enabled: Yes

Mbstring Enabled: Yes

Remote Post Successful: Yes

Remote Post Response: 200

Remote Get Successful: Yes

Remote Get Response: 200

Savoy: 2.7.3 (Latest:0)

Query Monitor (John Blackbourn): 3.10.1

FiboSearch – AJAX Search for WooCommerce (Pro) (FiboSearch Team): 1.20.2.13

Akismet Anti-Spam (Automattic): 5.0.1

All 404 Redirect to Homepage (wp-buy): 3.7

Autoptimize (Frank Goossens (futtta)): 3.1.2

Clerk (Clerk.io): 3.8.1 (Latest:3.8.2)

Contact Form 7 – Success Page Redirects (Ryan Nevius): 1.2.0

Contact Form 7 (Takayuki Miyoshi): 5.6.3

Cookie Notice & Compliance for GDPR / CCPA (Hu-manity.co): 2.4.1

WooCommerce Waardebon Generator (Jeroen Sormani): 1.2.0

Disable Right Click For WP (Aftab Muni): 1.1.6

Yoast Duplicate Post (Enrico Battocchi & Team Yoast): 4.5

GTM4WP (Thomas Geiger): 1.16.1

Drukwerkdeal order sync (Jeroen Kodde): 1.0

Easy WP SMTP (wpecommerce, alexanderfoxc): 1.5.1

Envato Market (Envato): 2.0.7

Facebook for WooCommerce (Facebook): 2.6.25 (Latest:2.6.27)

GTranslate (Translate AI Multilingual Solutions): 2.9.13

Header and Footer Scripts (Digital Liberation): 2.2.1

Smash Balloon Instagram Feed (Smash Balloon): 6.0.8

Jetpack (Automattic): 11.4

WPBakery Page Builder (Michael M – WPBakery.com): 6.9.0 (Latest:6.10.0)

Loco Translate (Tim Whitlock): 2.6.2

Mailchimp for WooCommerce (Mailchimp): 2.7.5

MC4WP: Mailchimp for WordPress (ibericode): 4.8.10

Media Library Assistant (David Lingren): 3.04

Savoy Theme – Content Elements (NordicMade): 1.4.9

Savoy Theme – Instagram Gallery (NordicMade): 1.3.5

Savoy Theme – Portfolio (NordicMade): 1.2.8

Savoy Theme – Team Members (NordicMade): 1.0.8

Savoy Theme – Settings Panel (NordicMade): 1.2

Verlanglijstje (NordicMade): 2.4.2

Print order sync (Jeroen Kodde): 1.0

Redirection (John Godley): 5.3.4

Regenerate Thumbnails (Alex Mills (Viper007Bond)): 3.1.5

Tawk.to Live Chat (Tawkto): 0.7.2

WooCommerce Thank You Page – NextMove (XLPlugins): 1.16.0

Warpdrive (Savvii ): 2.10.7

CTX Feed (WebAppick): 4.5.4

WebwinkelKeur (Albert Peschar): 3.18

Widget Options (Widget Options Team): 3.8.9.1

WooCommerce Bulk Edit Product Variations (matterico_themes): 2.7

Woo Discount Rules PRO 2.0 (Flycart): 2.4.5

Woo Discount Rules (Flycart): 2.4.5

NextMove Lite – Thank You Page for WooCommerce (XLPlugins): 2.15.1

WooCommerce Advanced Bulk Edit (George Iron): 5.0.1

WooCommerce Checkout Add-Ons (SkyVerge): 2.5.7

WooCommerce Mailchimp (Saint Systems): 2.4.9

MyParcel (MyParcel): 4.14.0

PAY. Payment Methods for WooCommerce (PAY.): 3.11.0

PDF Invoices & Packing Slips for WooCommerce (WP Overnight): 3.2.1

WooCommerce Product Add-ons (WooCommerce): 5.0.0

WooCommerce (Automattic): 7.0.0

Wordfence Security (Wordfence): 7.7.1

WordPress Importer (wordpressdotorg): 0.8

Yoast SEO (Team Yoast): 19.8

WPS Hide Login (WPServeur, NicolasKulka, wpformation): 1.9.6

YayMail – WooCommerce Email Customizer (YayCommerce): 3.0.8

YITH WooCommerce Wishlist (YITH): 3.14.0

Feed Files
Array

___

The fatal error we get:

Fatal Errors
2022-10-15T13:49:00+00:00 CRITICAL Allowed memory size of 1073741824 bytes exhausted (tried to allocate 2097160 bytes) in /var/www/nlkuns-fenoarivo/wordpress/current/wp-includes/wp-db.php on line 2867

___

PHP post max size: 64 MB
PHP time limit: 600
PHP max input vars: 3000

_____

What is the best way to get the feed?

The page I need help with: [log in to see the link]