petjorgensen

Hello,

We manually fixed the breadcrumb issue by following these steps:

• Ran the SEO Data Optimization tool from Yoast SEO > Tools.
• Manually corrected the incorrect breadcrumb text in the backend for the default language.

However, after a few days, when we needed to update some Yoast settings and made changes, the breadcrumb language became mismatched again. It seems that this issue occurs whenever we modify any settings in the Yoast backend.

FYI: When we manually correct the breadcrumb text in the backend for the default language, the changes are not consistently reflected on the frontend. The breadcrumb text may update randomly, and only after multiple saves or updates does the correct text appear.

Hello,

I hope you’re doing well.

I’m writing to follow up on our recent support request. We’ve noticed that after raising tickets with Yoast, we receive separate emails from an individual named “Juwel,” who references our issues.

For your reference, I’ve attached a screenshot of the latest communication(See screenshot for reference).

Could you please clarify whether this individual is officially associated with Yoast or has been authorized by your team to assist with our requests? As this has occurred multiple times, We want to ensure that all communications are conducted strictly through verified and authorized Yoast representatives only.

We would appreciate your confirmation on this before proceeding further.

Thank you for your support.

Hello,

We followed the steps you suggested. The last step I ran was “Start SEO Data Optimization” on the staging server. After running the SEO data optimization for a long time, we received a Cloudflare 524 error on the staging server.

Please see the screenshot below for reference.

Could you help us resolve this issue?

Hello,

Thank you for your detailed response. I’ve reviewed your suggestions and taken the following steps:

1. Index on zone_id:
   I confirmed that an index on zone_id should exist, as mentioned in your response. However, after running the EXPLAIN query, it seems that the query is not using any index for the zone_id field, which may be contributing to the performance issue.
2. SHOW INDEXES Output:
   To check the indexes on the woocommerce_shipping_zone_methods table, I ran the following SHOW INDEXES command: Command Output:
   • Table Name: www0_woocommerce_shipping_zone_methods
   • Index Type: PRIMARY
   • Column Name: instance_id
   • Collation: A (Ascending)
   • Cardinality: 57 (indicates the number of unique values for this index)
   • Index Type: BTREE
   • Null Values: Not allowed
   • Sub-part / Packed: N/A (not applicable for this index)
   As you can see, there is no index on zone_id. The primary index exists on instance_id, but not on zone_id, which is why the query is performing a full table scan.
3. EXPLAIN Query Output:
   Below is the result of running EXPLAIN on the slow query: EXPLAIN SELECT method_id, method_order, instance_id, is_enabled
   FROM www0_woocommerce_shipping_zone_methods
   WHERE zone_id = 5; EXPLAIN Output:
   • id: 1
   • select_type: SIMPLE
   • table: www0_woocommerce_shipping_zone_methods
   • type: ALL (full table scan)
   • possible_keys: NULL (no possible index used)
   • key: NULL (no index used)
   • key_len: NULL (no index length used)
   • ref: NULL (no reference to indexed data)
   • rows: 57 (MySQL expects to examine 57 rows)
   • Extra: Using where (MySQL is using the WHERE clause to filter rows)
   This output shows that MySQL is performing a full table scan (ALL) and not using any index, even though zone_id should be the primary lookup key.
4. Next Steps:
   Based on your guidance, I have taken the following actions:
   • Analyzed the table: I have confirmed that the table statistics are up-to-date.
   • Shipping Method and Zone Cleanup: We are using the WCFM Shipping Method and have ensured that only necessary zones are configured for each vendor’s shipping methods. All redundant zones and shipping methods have been removed, so the dataset being queried should be minimal.
5. Shipping Zones and Methods Configuration:
   • We currently have 57 shipping zones configured.
   • The number of shipping methods per zone varies, and we are using only necessary shipping methods for each vendor.

Could you kindly advise:

1. Why the index on zone_id is not being used for this query?
2. What steps can be taken to resolve this issue, such as ensuring the index is applied or troubleshooting potential problems with the index itself?

Looking forward to your assistance in resolving this performance issue.

Hello,

Point 1: Custom Product Identifiers
I meant that I would like to include the following custom product identifiers using hooks/filters, without modifying the plugin code. Just to clarify, WooCommerce doesn’t include product identifiers by default. We need to register, save, and add our custom product identifier via a hook/filter in the product edit page, under the ‘WCFM Custom Attributes’ option. Here’s an example : https://prnt.sc/UoJAXh8tgjtx

• Unit pricing measure
• Unit pricing base measure
• Multipack
• Is bundle (a yes/no field, with “null” also indicating no)
• Custom field 0 (this field is mapped to the Google attribute “excluded_destination”)

Point 2: Submitting Product Data to Google Merchant Center
Could you let me know when I can expect a solution for the API interface with support for different target countries and additional languages?

Hello @mdrazunmia,

Point 1: Custom Product Identifiers

This is the complete documentation for product identifiers: Google Merchant Center Product Identifiers.

Point 2: Sending Product Data to Google Merchant Center

We have country-wise multiple product feeds ( see the screenshot ) and are sending products via the Google Content API. However, we are only able to send one country’s product feed data at a time via the Content API ( see the screenshot ). I also noticed that we are receiving the following error in our Google Merchant account ( see the screenshot ) : “You can only have one Content API data source. To add more products via API, add them to your current Content API data source.“

Why am I only able to send product feed data for one country via the Google Content API?

Can you help me with how to send multiple product feeds data (see the screenshot) via the Google Content API?

Hello,
I’m waiting your reply any updates?

Hi Jose,

Sorry! I didn’t get a chance to review it, let me check and come back to you.

Thanks!