Extra characters appear in product links.

Resolved ibrahimpak
(@ibrahimpak)

1 year, 8 months ago
The output of links pointing to my product pages has recently contained extra characters.

// Example 1
Product Title: Ews Akri̇li̇k Yeşi̇l Jolly Süzgeç

Product Link Output: https://sitename.com/urun/ews-akri%cc%87li%cc%87k-yesi%cc%87l-jolly-suzgec/

//Example 2
Product Title: Beyaz Raf İçi̇ Kaşıklık

Product Link Output: https://sitename.com/urun/beyaz-raf-ici%cc%87-kasiklik/

//Example 3
Product Title: Akri̇li̇k 2’Li̇ Şeffaf Çatal Kaşık Seti̇

Product Link Output: https://sitename.com/urun/akri%cc%87li%cc%87k-2li%cc%87-seffaf-catal-kasik-seti%cc%87/

Note: These characters do not appear in post and page links.
- This topic was modified 1 year, 8 months ago by ibrahimpak.
- This topic was modified 1 year, 8 months ago by ibrahimpak.

Viewing 7 replies - 1 through 7 (of 7 total)

Plugin Support Rafy a11n
(@nawaz0705)

1 year, 8 months ago

Hi @ibrahimpak

Thank you for reaching out!

I have tried to reproduce the issue on my test website, but was unable to. Here is a screenshot as a reference: https://d.pr/i/H7BoY4

In order for us to get a better understanding of your site setup, could you please share a copy of your website’s System Status Report?

You can get it by navigating to the WooCommerce / Status section of your site. Once there, click on the Get system report button and then copy it by clicking on the Copy for support button. Then paste it here in a comment.

Thread Starter ibrahimpak
(@ibrahimpak)

1 year, 8 months ago

Hi @nawaz0705

My status report and some more info, only titles with non-English characters have this problem.

I also re-added a product with non-English characters and it comes up a clean link.

Do I need to refresh all connections? What do you recommend?

Note: This is a migration site and there are too many items to delete. So I want to clean the links for fresh start.

### WordPress Environment ###

WordPress address (URL): https://sitename.com
Site address (URL): https://sitename.com
WC Version: 6.8.0
REST API Version: ✔ 6.8.0
WC Blocks Version: ✔ 8.0.0
Action Scheduler Version: ✔ 3.4.0
Log Directory Writable: ✔
WP Version: 6.0.1
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: ✔
WP Cron: ✔
Language: tr_TR
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.30
PHP Post Max Size: 256 MB
PHP Time Limit: 1200
PHP Max Input Vars: 1000
cURL Version: 7.84.0
OpenSSL/1.1.1q

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.3.36-MariaDB
Max Upload Size: 256 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### Database ###

WC Database Version: 6.5.1
WC Database Prefix: wp_
Toplam veritabanı boyutu: 1273.77MB
Veritabanı veri boyutu: 892.89MB
Veritabanı indis boyutu: 380.88MB
wp_woocommerce_sessions: Veriler: 0.05 MB + Dizin: 0.02 MB + Motor InnoDB
wp_woocommerce_api_keys: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_woocommerce_attribute_taxonomies: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_woocommerce_downloadable_product_permissions: Veriler: 0.02 MB + Dizin: 0.06 MB + Motor InnoDB
wp_woocommerce_order_items: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_woocommerce_order_itemmeta: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_woocommerce_tax_rates: Veriler: 0.02 MB + Dizin: 0.06 MB + Motor InnoDB
wp_woocommerce_tax_rate_locations: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_woocommerce_shipping_zones: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_woocommerce_shipping_zone_locations: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_woocommerce_shipping_zone_methods: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_woocommerce_payment_tokens: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_woocommerce_payment_tokenmeta: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_woocommerce_log: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_actionscheduler_actions: Veriler: 99.64 MB + Dizin: 79.81 MB + Motor InnoDB
wp_actionscheduler_claims: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_actionscheduler_groups: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_actionscheduler_logs: Veriler: 78.63 MB + Dizin: 56.14 MB + Motor InnoDB
wp_commentmeta: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_comments: Veriler: 0.02 MB + Dizin: 0.09 MB + Motor InnoDB
wp_e_events: Veriler: 0.00 MB + Dizin: 0.00 MB + Motor MyISAM
wp_e_submissions: Veriler: 0.00 MB + Dizin: 0.00 MB + Motor MyISAM
wp_e_submissions_actions_log: Veriler: 0.00 MB + Dizin: 0.00 MB + Motor MyISAM
wp_e_submissions_values: Veriler: 0.00 MB + Dizin: 0.00 MB + Motor MyISAM
wp_import_detail_log: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_import_log_detail: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_import_postID: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_links: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_noptin_automation_rules: Veriler: 0.00 MB + Dizin: 0.00 MB + Motor MyISAM
wp_noptin_subscribers: Veriler: 0.00 MB + Dizin: 0.00 MB + Motor MyISAM
wp_noptin_subscriber_meta: Veriler: 0.00 MB + Dizin: 0.01 MB + Motor MyISAM
wp_options: Veriler: 22.48 MB + Dizin: 5.92 MB + Motor InnoDB
wp_pmxi_files: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_pmxi_hash: Veriler: 3.52 MB + Dizin: 0.00 MB + Motor InnoDB
wp_pmxi_history: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_pmxi_images: Veriler: 17.55 MB + Dizin: 0.00 MB + Motor InnoDB
wp_pmxi_imports: Veriler: 0.42 MB + Dizin: 0.00 MB + Motor MyISAM
wp_pmxi_posts: Veriler: 7.52 MB + Dizin: 0.00 MB + Motor InnoDB
wp_pmxi_templates: Veriler: 1.52 MB + Dizin: 0.00 MB + Motor InnoDB
wp_postmeta: Veriler: 305.86 MB + Dizin: 159.38 MB + Motor InnoDB
wp_posts: Veriler: 320.78 MB + Dizin: 49.22 MB + Motor InnoDB
wp_social_users: Veriler: 0.00 MB + Dizin: 0.00 MB + Motor MyISAM
wp_termmeta: Veriler: 1.52 MB + Dizin: 0.86 MB + Motor InnoDB
wp_terms: Veriler: 0.20 MB + Dizin: 0.28 MB + Motor InnoDB
wp_term_relationships: Veriler: 14.55 MB + Dizin: 7.52 MB + Motor InnoDB
wp_term_taxonomy: Veriler: 0.19 MB + Dizin: 0.22 MB + Motor InnoDB
wp_usermeta: Veriler: 0.06 MB + Dizin: 0.03 MB + Motor InnoDB
wp_users: Veriler: 0.02 MB + Dizin: 0.05 MB + Motor InnoDB
wp_wc_admin_notes: Veriler: 0.05 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wc_admin_note_actions: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_wc_category_lookup: Veriler: 0.45 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wc_customer_lookup: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_wc_download_log: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_wc_order_coupon_lookup: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_wc_order_product_lookup: Veriler: 0.02 MB + Dizin: 0.06 MB + Motor InnoDB
wp_wc_order_stats: Veriler: 0.02 MB + Dizin: 0.05 MB + Motor InnoDB
wp_wc_order_tax_lookup: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_wc_product_attributes_lookup: Veriler: 6.64 MB + Dizin: 7.45 MB + Motor MyISAM
wp_wc_product_download_directories: Veriler: 0.00 MB + Dizin: 0.01 MB + Motor MyISAM
wp_wc_product_meta_lookup: Veriler: 10.52 MB + Dizin: 13.09 MB + Motor InnoDB
wp_wc_rate_limits: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_wc_reserved_stock: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wc_tax_rate_classes: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_wc_webhooks: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_woodmart_wishlists: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_woodmart_wishlist_products: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_yith_wcwl: Veriler: 0.00 MB + Dizin: 0.00 MB + Motor MyISAM
wp_yith_wcwl_lists: Veriler: 0.00 MB + Dizin: 0.01 MB + Motor MyISAM

### Post Type Counts ###

attachment: 83245
blocks: 8
cms_block: 31
custom_css: 1
customize_changeset: 70
elementor_library: 12
featured_item: 8
mc4wp-form: 1
nav_menu_item: 1060
noptin-form: 1
page: 93
post: 10
product: 47817
product_variation: 29397
revision: 83393
shop_order: 4
woodmart_sidebar: 1
woodmart_size_guide: 1
wp_global_styles: 1
wpcf7_contact_form: 5

### Security ###

Secure connection (HTTPS): ✔
Hide errors from visitors: ❌Hata mesajları ziyaretçilere gösterilmemelidir.

### Active Plugins (11) ###

Contact Form 7: (Takayuki Miyoshi) – 5.6.2
Easy WP SMTP: (wpecommerce
alexanderfoxc) – 1.4.7

Loco Translate: (Tim Whitlock) – 2.6.2
Noptin – WordPress Newsletter Plugin: (Newsletter) – 1.7.7
Nextend Social Login: (Nextendweb) – 3.1.5
Term Management Tools: (theMikeD
scribu) – 2.0.1

WooCommerce Adres Defteri: (Hall Internet Marketing) – 2.1.3
WooCommerce: (Automattic) – 6.8.1
WP All Import Pro: (Soflyy) – 4.7.3
WP All Import – WooCommerce Import Add-On Pro: (Soflyy) – 3.3.1
YITH WooCommerce Wishlist: (YITH) – 3.12.0

### Inactive Plugins (3) ###

Elementor: (Elementor.com) – 3.6.8
Elementor Pro: (Elementor.com) – 3.6.4
Woodmart Core: () – 1.0.34

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Settings ###

API Enabled: –
Force SSL: –
Currency: TRY (TL)
Currency Position: right
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: –
Enforce Approved Product Download Directories: –

### WC Pages ###

Mağaza giriş sayfası: #872769 – /shop/
Sepet sayfası: #872768 – /cart/
Ödeme sayfası: #872767 – /checkout/
Hesabım sayfası: #872766 – /my-account/
Şartlar ve koşullar: ❌ Sayfa ayarlanmamış

### Theme ###

Name: Flatsome Child
Version: 3.0
Author URL:
Child Theme: ✔
Parent Theme Name: Flatsome
Parent Theme Version: 3.15.7
Parent Theme Author URL: http://www.uxthemes.com/
WooCommerce Support: ✔

### Templates ###

Overrides: flatsome/woocommerce/archive-product.php
flatsome/woocommerce/cart/cart-empty.php
flatsome/woocommerce/cart/cart-shipping.php
flatsome/woocommerce/cart/cart.php
flatsome/woocommerce/checkout/form-checkout.php
flatsome/woocommerce/checkout/form-coupon.php
flatsome/woocommerce/checkout/terms.php
flatsome/woocommerce/checkout/thankyou.php
flatsome/woocommerce/content-product-cat.php
flatsome/woocommerce/content-product.php
flatsome/woocommerce/content-single-product.php
flatsome/woocommerce/content-widget-product.php
flatsome/woocommerce/global/breadcrumb.php
flatsome/woocommerce/global/quantity-input.php
flatsome/woocommerce/global/wrapper-end.php
flatsome/woocommerce/global/wrapper-start.php
flatsome/woocommerce/loop/loop-end.php
flatsome/woocommerce/loop/loop-start.php
flatsome/woocommerce/loop/pagination.php
flatsome/woocommerce/loop/result-count.php
flatsome/woocommerce/loop/sale-flash.php
flatsome-child/woocommerce/myaccount/form-login.php
flatsome-child/woocommerce/myaccount/navigation.php
flatsome/woocommerce/notices/error.php
flatsome/woocommerce/notices/notice.php
flatsome/woocommerce/notices/success.php
flatsome/woocommerce/product-searchform.php
flatsome/woocommerce/single-product/photoswipe.php
flatsome/woocommerce/single-product/price.php
flatsome-child/woocommerce/single-product/product-image.php
flatsome/woocommerce/single-product/product-thumbnails.php
flatsome-child/woocommerce/single-product/rating.php
flatsome/woocommerce/single-product/related.php
flatsome/woocommerce/single-product/review.php
flatsome/woocommerce/single-product/sale-flash.php
flatsome/woocommerce/single-product/share.php
flatsome/woocommerce/single-product/short-description.php
flatsome/woocommerce/single-product/tabs/tabs.php
flatsome/woocommerce/single-product/title.php
flatsome/woocommerce/single-product/up-sells.php
flatsome-child/woocommerce/single-product-reviews.php
flatsome/woocommerce/single-product.php
flatsome/woocommerce/content-product_cat.php

### Admin ###

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
experimental-product-tour
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
wc-pay-promotion
wc-pay-welcome-page
wc-pay-subscriptions-page

Disabled Features: minified-js
settings

Daily Cron: ✔ Next scheduled: 2022-08-21 17:47:01 +03:00
Options: ✔
Notes: 46
Onboarding: completed

### Action Scheduler ###

Tamamla: 307.773
Oldest: 2022-07-18 09:27:35 +0000
Newest: 2022-08-21 14:06:29 +0000

Başarısız: 17
Oldest: –
Newest: –

Bekleyen: 1
Oldest: 2022-08-21 18:11:20 +0000
Newest: 2022-08-21 18:11:20 +0000

### Status report information ###

Generated at: 2022-08-21 17:08:57 +03:00
xue28 (woo-hc)
(@xue28)

1 year, 8 months ago
Hi @ibrahimpak

Thanks for sharing the system status report.

I also replicated this on my test site and produced the same result as Rafy.

WC Database Version: 6.5.1

Can you please try to update your database to the latest version by following our guide here?

Then, please follow the below steps to perform a full conflict test and see if that works.
- Temporarily switch your theme to Storefront
- Disable all plugins except for WooCommerce
- Repeat the action that is causing the problem
If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To figure out which plugin is causing the problem, reactivate your other plugins one by one, testing after each, until you find the one causing conflict. You can find a more detailed explanation on how to do a conflict test here.

Before you start
- First, please make sure you have a good backup in place of your full site and database. Most hosting companies have this included in the subscription, but you could also consider using a service like Jetpack. If something goes wrong, it’s nice to know that you can restore your site.
- Second, I would suggest installing a plugin called Health Check & Troubleshooting. This is a plugin developed by the WordPress community and it allows you to disable plugins without affecting your current site visitors.
You can make use of a staging/test site to proceed with the conflict test recommended above.

If your host doesn’t offer that option, we recommend WP Staging for quickly spinning up a new test site.

Let us know the result of the test.
- This reply was modified 1 year, 8 months ago by xue28 (woo-hc).
Thread Starter ibrahimpak
(@ibrahimpak)

1 year, 8 months ago

This issue can be seen in the product names in my database. Not available on some products and not on newly added products. I need to rewrite all the product names into the database. Do you have a recommendation?

Product names on db: https://prnt.sc/CdvItEKePl3N

Igor H
(@ihereira)

1 year, 8 months ago

Hello,

I need to rewrite all the product names into the database. Do you have a recommendation?

You can export all your product using the default importer/exporter feature under WP Dashboard > Products > Export. Please create a copy of this file as a backup of your products.

Then you can download the file generated, and edit the product names. Once you are done, you can impórt the file back under WP Dashboard > Products > Import and you will be able to override the products.

Let us know if that worked for you 🙂

Thread Starter ibrahimpak
(@ibrahimpak)

1 year, 8 months ago

Thank you for your helpful suggestions.

First I will delete the product names containing % from the database, UPDATEwp_postsSETpost_name= '' WHEREwp_posts.post_nameREGEXP '%' then I will update the products and the products will be renamed and probably the names will be clean.

Plugin Support Kaushik S. a11n
(@kaushiksomaiya)

1 year, 8 months ago

Hi there @ibrahimpak!

You do not need to replace the characters in the database. This is expected behavior when special characters are used in the URL.

When special characters are used, the browser automatically converts the URL into URL-encoded form. So for example:

https://sitename.com/urun/ews-akri%cc%87li%cc%87k-yesi%cc%87l-jolly-suzgec/

is the URL encoded version for:

https://sitename.com/urun/ews-akri̇li̇k-yesi̇l-jolly-suzgec/

You can try using a tool like https://www.urldecoder.org to check that.

If you want your product permalinks to be cleaner, you could instead try modifying the permalinks to remove any special characters like i̇.

I hope this helps! 🙂

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Extra characters appear in product links.’ is closed to new replies.

Tags