Gateway Timeout when creating feed..

Hi

I was having some trouble creating feeds. We have a store with a lot of products and it just never worked, running out of memory.

I also searched this support forum for “Gateway Timeout” and I couldn’t find the solution in the other tickets. So I’m just adding this ticket for reference. It might also be good to add a timeout note in the plugin FAQs.

For me this toggle in the settings fixed the issue:

Show only basis attributes in field mapping and filter/rule drop-downs

—–

The cause of this issue is probably the function woosea_get_meta_keys_for_post_type() which loads every single product post from the database, and then it loads every meta key from the product. This is a bit crazy (and times out after 100s on my site). It should really be replaced with something like this (which is a query that runs in a few ms):

SELECT DISTINCT postmeta.meta_key
FROM {$wpdb->postmeta} postmeta
INNER JOIN {$wpdb->posts} posts
  ON posts.ID = postmeta.post_id
  AND posts.post_type = 'post';

• This topic was modified 1 year, 6 months ago by michaelcartersa.
• This topic was modified 1 year, 6 months ago by michaelcartersa.
• This topic was modified 1 year, 6 months ago by michaelcartersa.