[NSFW] SKU duplicate Big Problem Polish sign

Hi @ptrpartnerbhp

How are you getting the products from your supplier?

If you’re getting CSV files from them you can try to convert it to UTF8 prior to importing on your site, by using a tool such as the following:

1. https://www.browserling.com/tools/utf8-encode
2. https://subtitletools.com/convert-text-files-to-utf8-online/0eae2708de4d0b41

I hope that helps.

the file from the supplier is not important, the product manually has the same problem with a duplicate SKU, i.e. if I manually create a DDR-_z_xl product, then woocomerc will not allow me to create DDR-_?_xl, the problem is in a different place – somewhere in the woordpres and woocomerc. regards Krzysztof

Hello,

Thanks for writing back!

What is your WordPress dashboard language set to? So we can have a better understanding of your setup, can you please share your System status report? You can find it in WooCommerce > Status > Get system report > Copy for support and then paste it here.

sure I can give you a report, I also contacted WooCommerc – they gave me an official answer

“You might notice that aeiou and áê?òù as SKUs will cause the same duplicate error message. I recommend using a different character in addition to DDR-_z_xl (DDR-_zi_xl and DDR-_zo_xl, for example) instead of attempting to use an accented character.
Best,
Darcie – Happiness Engineer @ WooCommerce | Automatti”

so it is not a problem of Polish characters, but generally wooCommerc cannot use any diacritics

raport:

### WordPress Environment ###

WordPress address (URL): https://base.ptr-bhp.pl
Site address (URL): https://base.ptr-bhp.pl
WC Version: 6.3.1
REST API Version: ? 6.3.1
WC Blocks Version: ? 6.9.0
Action Scheduler Version: ? 3.4.0
WC Admin Version: ? 3.2.1
Log Directory Writable: ?
WP Version: 5.9.2
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ?
Language: pl_PL
External object cache: –

### Server Environment ###

Server Info: nginx/1.21.6
PHP Version: 7.4.27
PHP Post Max Size: 640 MB
PHP Time Limit: 6000000
PHP Max Input Vars: 10000
cURL Version: 7.29.0
NSS/3.53.1

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

### Database ###

WC Database Version: 6.3.1
WC Database Prefix: 22651_
Ca?kowity rozmiar bazy danych: 76.15MB
Rozmiar bazy danych: 39.73MB
Rozmiar indeksu bazy danych: 36.42MB
22651_woocommerce_sessions: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB
22651_woocommerce_api_keys: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB
22651_woocommerce_attribute_taxonomies: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB
22651_woocommerce_downloadable_product_permissions: Dane: 0.02MB + Indeks: 0.06MB + Silnik InnoDB
22651_woocommerce_order_items: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB
22651_woocommerce_order_itemmeta: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB
22651_woocommerce_tax_rates: Dane: 0.02MB + Indeks: 0.06MB + Silnik InnoDB
22651_woocommerce_tax_rate_locations: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB
22651_woocommerce_shipping_zones: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB
22651_woocommerce_shipping_zone_locations: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB
22651_woocommerce_shipping_zone_methods: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB
22651_woocommerce_payment_tokens: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB
22651_woocommerce_payment_tokenmeta: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB
22651_woocommerce_log: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB
22651_actionscheduler_actions: Dane: 6.52MB + Indeks: 7.39MB + Silnik InnoDB
22651_actionscheduler_claims: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB
22651_actionscheduler_groups: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB
22651_actionscheduler_logs: Dane: 5.52MB + Indeks: 4.03MB + Silnik InnoDB
22651_ariadminer_connections: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB
22651_commentmeta: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB
22651_comments: Dane: 0.02MB + Indeks: 0.09MB + Silnik InnoDB
22651_links: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB
22651_options: Dane: 2.19MB + Indeks: 0.23MB + Silnik InnoDB
22651_pmlca_links: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB
22651_pmxe_exports: Dane: 0.08MB + Indeks: 0.00MB + Silnik InnoDB
22651_pmxe_google_cats: Dane: 0.38MB + Indeks: 0.00MB + Silnik InnoDB
22651_pmxe_posts: Dane: 1.52MB + Indeks: 0.00MB + Silnik InnoDB
22651_pmxe_templates: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB
22651_pmxi_files: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB
22651_pmxi_hash: Dane: 1.52MB + Indeks: 0.00MB + Silnik InnoDB
22651_pmxi_history: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB
22651_pmxi_images: Dane: 0.13MB + Indeks: 0.00MB + Silnik InnoDB
22651_pmxi_imports: Dane: 0.16MB + Indeks: 0.00MB + Silnik InnoDB
22651_pmxi_posts: Dane: 1.52MB + Indeks: 0.00MB + Silnik InnoDB
22651_pmxi_templates: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB
22651_postmeta: Dane: 14.55MB + Indeks: 20.06MB + Silnik InnoDB
22651_posts: Dane: 2.52MB + Indeks: 2.17MB + Silnik InnoDB
22651_termmeta: Dane: 0.08MB + Indeks: 0.13MB + Silnik InnoDB
22651_terms: Dane: 0.05MB + Indeks: 0.03MB + Silnik InnoDB
22651_term_relationships: Dane: 0.45MB + Indeks: 0.23MB + Silnik InnoDB
22651_term_taxonomy: Dane: 0.05MB + Indeks: 0.03MB + Silnik InnoDB
22651_toolset_associations: Dane: 0.02MB + Indeks: 0.06MB + Silnik InnoDB
22651_toolset_connected_elements: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB
22651_toolset_post_guid_id: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB
22651_toolset_relationships: Dane: 0.02MB + Indeks: 0.08MB + Silnik InnoDB
22651_toolset_type_sets: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB
22651_usermeta: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB
22651_users: Dane: 0.02MB + Indeks: 0.05MB + Silnik InnoDB
22651_wc_admin_notes: Dane: 0.05MB + Indeks: 0.00MB + Silnik InnoDB
22651_wc_admin_note_actions: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB
22651_wc_category_lookup: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB
22651_wc_customer_lookup: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB
22651_wc_download_log: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB
22651_wc_order_coupon_lookup: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB
22651_wc_order_product_lookup: Dane: 0.02MB + Indeks: 0.06MB + Silnik InnoDB
22651_wc_order_stats: Dane: 0.02MB + Indeks: 0.05MB + Silnik InnoDB
22651_wc_order_tax_lookup: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB
22651_wc_product_attributes_lookup: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB
22651_wc_product_meta_lookup: Dane: 1.52MB + Indeks: 0.92MB + Silnik InnoDB
22651_wc_rate_limits: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB
22651_wc_reserved_stock: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB
22651_wc_tax_rate_classes: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB
22651_wc_webhooks: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB
22651_wpmelon_advbedit_temp: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB

### Post Type Counts ###

attachment: 510
page: 7
post: 2
product: 480
product_variation: 4929
revision: 3
wp-types-group: 1

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (35) ###

Advanced Custom Fields PRO: przez Delicious Brains – 5.12
Akismet antyspam: przez Automattic – 4.2.2
ARI Adminer: przez ARI Soft – 1.2.3
Autoptimize: przez Frank Goossens (futtta) – 2.9.5.1
Block Specific Plugin Updates: przez Dinesh Karki – 3.2
Cache Enabler: przez KeyCDN – 1.8.7
CDN Enabler: przez KeyCDN – 2.0.4
Klasyczny edytor: przez Kontrybutorzy WordPressa – 1.6.2
Coming Soon Page, Maintenance Mode, Landing Pages & WordPress Website Builder by SeedProd: przez SeedProd – 6.10.0
Disable XML-RPC: przez Philip Erb – 1.0.1
Extendons: WooCommerce CSV import Export: przez Extendons – 2.0.1
Stop Generating Unnecessary Thumbnails: przez Codexpert – 3.4.4
Jetpack: przez Automattic – 10.7
Loco Translate: przez Tim Whitlock – 2.6.1
Sandbox: przez Liquid Web – 1.1.10
Sucuri Security - Auditing, Malware Scanner and Hardening: przez Sucuri Inc. – 1.8.30
ThemeGrill Demo Importer: przez ThemeGrill – 1.8.0
TM WooCommerce Product API Link: przez Manish – 1.1
Toolset Types: przez OnTheGoSystems – 3.4.15
WooCommerce UPC, EAN, and ISBN: przez Scott Bolinger – 0.5.1
WooCommerce Advanced Bulk Edit: przez George Iron – 5.0.1
WooCommerce API Product Sync with Multiple Stores: przez Obtain Infotech – 2.5.0
WooCommerce Product CSV Import Suite: przez WooCommerce – 1.10.46
WooCommerce: przez Automattic – 6.3.1
WP All Export Pro: przez Soflyy – 1.7.4
WP All Import Pro: przez Soflyy – 4.7.2
WP All Export - ACF Export Add-On Pro: przez Soflyy – 1.0.3
WP All Export - User Export Add-On Pro: przez Soflyy – 1.0.7
WP All Export - WooCommerce Export Add-On Pro: przez Soflyy – 1.0.4
WP All Import - ACF Add-On: przez Soflyy – 3.3.6
WP All Import - Link Cloaking Add-on: przez Soflyy – 1.1.5
WP All Import - Toolset Types Add-On Pro: przez Soflyy – 1.0.4
WP All Import - User Import Add-On Pro: przez Soflyy – 1.1.6
WP All Import - WooCommerce Import Add-On Pro: przez Soflyy – 3.3.0
WPTerm: przez Jerome Bruandet – 1.1.9

### Inactive Plugins (0) ###

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Settings ###

API Enabled: –
Force SSL: –
Currency: PLN (z?)
Currency Position: right_space
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: –

### WC Pages ###

Strona sklepu: #6 - /sklep/
Koszyk: #7 - /koszyk/
Zamówienie: #8 - /zamowienie/
Moje konto: #9 - /moje-konto/
Regulamin: ? Strona nie ustawiona

### Theme ###

Name: Twenty Twenty-One
Version: 1.5
Author URL: https://pl.www.ads-software.com/
Child Theme: ? – Je?li modyfikujesz WooCommerce lub motyw nadrz?dny
którego nie jeste? autorem
polecamy u?ywanie motywu potomnego. Zobacz: Jak tworzy? motywy potomne

WooCommerce Support: ?

### Templates ###

Overrides: –

### Action Scheduler ###

Zakończ: 21?162
Oldest: 2022-03-24 10:34:31 +0100
Newest: 2022-04-05 13:19:36 +0200

Niepowodzenie: 22
Oldest: 2022-03-24 10:21:23 +0100
Newest: 2022-03-24 10:33:19 +0100

### Status report information ###

Generated at: 2022-04-05 13:34:39 +02:00

Hi @ptrpartnerbhp

Thanks for sharing the System Status Report.

I recommend using a different character in addition to DDR-_z_xl (DDR-_zi_xl and DDR-_zo_xl, for example) instead of attempting to use an accented character.

The solution provided by Darcie is what actually needs done, because WooCommerce does not differentiate between accented characters and is therefore considering those as duplicates.

I can’t change them because the supplier provides them to me and they are used in external systems

One way could be to programmatically transform the SKUs internally. We are unable to say for sure whether that may be possible, but you could check with developers in this regard.

I can recommend the following places where you can get help:

• WooCommerce Developer Resources Portal: https://developer.woocommerce.com/
• WooCommerce Slack Community: https://woocommerce.com/community-slack/
• WooCommerce Community on Facebook: https://www.facebook.com/groups/advanced.woocommerce/

You may also be able to find someone willing to volunteer their time and knowledge in the free PHP support forum at PHP Builder.

For direct assistance with customization or development with your site, you could reach out to someone on our customizations page.

I’m going to leave this thread open for a bit to see if a developer is able to chime in to help you out here.

Cheers

Seems we’ve not had additional inputs on this thread. Thus, we encourage you to make use of the above resources.

I’ll go ahead and mark the thread as resolved but please feel free to create a new thread if you have further questions.