multiple of the same product

Hi @parisaaxp ,

Thanks for reaching out!

We understand that you are having issues with products being duplicated that have the same product id.

Please provide us with a copy of your?System Status which you can find via?WooCommerce > Status. Select ‘Get system report’ and then ‘Copy for support’.

Once you do this, you can paste your response here.

Thanks!

Hi @parisaaxp

I have 81 published products.
but in pagination part it shows 161 products

Please go to WooCommerce > Status > Tools, and see if clearing transients helps.

Just to confirm – did you import products recently, after which this triplication issue surfaced?

So that we can get a better idea of what may be causing the issue, please share the System Status report as requested above.

We’ll look forward to your response.

no I didn’t import anything.
I cleared out all transient. no change.

is this it? is it alright sharing it here?

### WordPress Environment ###

WordPress address (URL): https://itookmarket.com
Site address (URL): https://itookmarket.com
WC Version: 6.5.1
REST API Version: ? 6.5.1
WC Blocks Version: ? 7.4.3
Action Scheduler Version: ? 3.4.0
Log Directory Writable: ?
WP Version: 5.9.3
WP Multisite: –
WP Memory Limit: 256 ???????
WP Debug Mode: –
WP Cron: ?
Language: fa_IR
External object cache: –

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 7.4.29
PHP Post Max Size: 100 ???????
PHP Time Limit: 60
PHP Max Input Vars: 1000
cURL Version: 7.83.0
OpenSSL/1.1.1o

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.5.15-MariaDB
Max Upload Size: 100 ???????
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_
?????? ?? ?????? ????: 57.60MB
?????? ???????? ?????? ????: 51.64MB
?????? ????? ?????? ????: 5.96MB
wp_woocommerce_sessions: ????: 0.14??????? + ??????: 0.00??????? + ????? MyISAM
wp_woocommerce_api_keys: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_woocommerce_attribute_taxonomies: ????: 0.02??????? + ??????: 0.01??????? + ????? MyISAM
wp_woocommerce_downloadable_product_permissions: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_woocommerce_order_items: ????: 0.01??????? + ??????: 0.00??????? + ????? MyISAM
wp_woocommerce_order_itemmeta: ????: 0.03??????? + ??????: 0.03??????? + ????? MyISAM
wp_woocommerce_tax_rates: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_woocommerce_tax_rate_locations: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_woocommerce_shipping_zones: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_woocommerce_shipping_zone_locations: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_woocommerce_shipping_zone_methods: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_woocommerce_payment_tokens: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_woocommerce_payment_tokenmeta: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_woocommerce_log: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_actionscheduler_actions: ????: 0.04??????? + ??????: 0.03??????? + ????? MyISAM
wp_actionscheduler_claims: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_actionscheduler_groups: ????: 0.00??????? + ??????: 0.01??????? + ????? MyISAM
wp_actionscheduler_logs: ????: 0.03??????? + ??????: 0.02??????? + ????? MyISAM
wp_commentmeta: ????: 0.02??????? + ??????: 0.02??????? + ????? MyISAM
wp_comments: ????: 0.02??????? + ??????: 0.02??????? + ????? MyISAM
wp_digits_blocked_ip: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_digits_mobile_otp: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_digits_requests_log: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_e_events: ????: 0.02??????? + ??????: 0.02??????? + ????? InnoDB
wp_e_submissions: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_e_submissions_actions_log: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_e_submissions_values: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_gla_budget_recommendations: ????: 0.22??????? + ??????: 0.14??????? + ????? InnoDB
wp_gla_merchant_issues: ????: 0.02??????? + ??????: 0.00??????? + ????? InnoDB
wp_gla_shipping_rates: ????: 0.02??????? + ??????: 0.05??????? + ????? InnoDB
wp_gla_shipping_times: ????: 0.02??????? + ??????: 0.02??????? + ????? InnoDB
wp_itsec_bans: ????: 0.00??????? + ??????: 0.01??????? + ????? MyISAM
wp_itsec_dashboard_events: ????: 0.01??????? + ??????: 0.01??????? + ????? MyISAM
wp_itsec_distributed_storage: ????: 6.22??????? + ??????: 0.00??????? + ????? MyISAM
wp_itsec_fingerprints: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_itsec_geolocation_cache: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_itsec_lockouts: ????: 0.00??????? + ??????: 0.01??????? + ????? MyISAM
wp_itsec_logs: ????: 9.66??????? + ??????: 0.22??????? + ????? MyISAM
wp_itsec_mutexes: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_itsec_opaque_tokens: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_itsec_temp: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_itsec_user_groups: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_links: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_litespeed_avatar: ????: 0.05??????? + ??????: 0.04??????? + ????? MyISAM
wp_litespeed_crawler: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_litespeed_crawler_blacklist: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_litespeed_img_optm: ????: 0.26??????? + ??????: 0.12??????? + ????? MyISAM
wp_litespeed_img_optming: ????: 0.01??????? + ??????: 0.03??????? + ????? MyISAM
wp_litespeed_url: ????: 0.09??????? + ??????: 0.13??????? + ????? MyISAM
wp_litespeed_url_file: ????: 0.11??????? + ??????: 0.13??????? + ????? MyISAM
wp_mailpoet_custom_fields: ????: 0.02??????? + ??????: 0.02??????? + ????? InnoDB
wp_mailpoet_dynamic_segment_filters: ????: 0.02??????? + ??????: 0.02??????? + ????? InnoDB
wp_mailpoet_feature_flags: ????: 0.02??????? + ??????: 0.02??????? + ????? InnoDB
wp_mailpoet_forms: ????: 0.02??????? + ??????: 0.00??????? + ????? InnoDB
wp_mailpoet_log: ????: 0.02??????? + ??????: 0.00??????? + ????? InnoDB
wp_mailpoet_mapping_to_external_entities: ????: 0.02??????? + ??????: 0.02??????? + ????? InnoDB
wp_mailpoet_newsletters: ????: 0.02??????? + ??????: 0.03??????? + ????? InnoDB
wp_mailpoet_newsletter_links: ????: 0.02??????? + ??????: 0.05??????? + ????? InnoDB
wp_mailpoet_newsletter_option: ????: 0.02??????? + ??????: 0.02??????? + ????? InnoDB
wp_mailpoet_newsletter_option_fields: ????: 0.02??????? + ??????: 0.02??????? + ????? InnoDB
wp_mailpoet_newsletter_posts: ????: 0.02??????? + ??????: 0.02??????? + ????? InnoDB
wp_mailpoet_newsletter_segment: ????: 0.02??????? + ??????: 0.02??????? + ????? InnoDB
wp_mailpoet_newsletter_templates: ????: 2.52??????? + ??????: 0.00??????? + ????? InnoDB
wp_mailpoet_scheduled_tasks: ????: 0.02??????? + ??????: 0.03??????? + ????? InnoDB
wp_mailpoet_scheduled_task_subscribers: ????: 0.02??????? + ??????: 0.02??????? + ????? InnoDB
wp_mailpoet_segments: ????: 0.02??????? + ??????: 0.03??????? + ????? InnoDB
wp_mailpoet_sending_queues: ????: 0.02??????? + ??????: 0.03??????? + ????? InnoDB
wp_mailpoet_settings: ????: 0.02??????? + ??????: 0.02??????? + ????? InnoDB
wp_mailpoet_statistics_bounces: ????: 0.02??????? + ??????: 0.00??????? + ????? InnoDB
wp_mailpoet_statistics_clicks: ????: 0.02??????? + ??????: 0.05??????? + ????? InnoDB
wp_mailpoet_statistics_forms: ????: 0.02??????? + ??????: 0.02??????? + ????? InnoDB
wp_mailpoet_statistics_newsletters: ????: 0.02??????? + ??????: 0.03??????? + ????? InnoDB
wp_mailpoet_statistics_opens: ????: 0.02??????? + ??????: 0.08??????? + ????? InnoDB
wp_mailpoet_statistics_unsubscribes: ????: 0.02??????? + ??????: 0.05??????? + ????? InnoDB
wp_mailpoet_statistics_woocommerce_purchases: ????: 0.02??????? + ??????: 0.06??????? + ????? InnoDB
wp_mailpoet_stats_notifications: ????: 0.02??????? + ??????: 0.03??????? + ????? InnoDB
wp_mailpoet_subscribers: ????: 0.02??????? + ??????: 0.13??????? + ????? InnoDB
wp_mailpoet_subscriber_custom_field: ????: 0.02??????? + ??????: 0.02??????? + ????? InnoDB
wp_mailpoet_subscriber_ips: ????: 0.02??????? + ??????: 0.02??????? + ????? InnoDB
wp_mailpoet_subscriber_segment: ????: 0.02??????? + ??????: 0.03??????? + ????? InnoDB
wp_mailpoet_user_agents: ????: 0.02??????? + ??????: 0.02??????? + ????? InnoDB
wp_mailpoet_user_flags: ????: 0.02??????? + ??????: 0.02??????? + ????? InnoDB
wp_melipayamak_GFVerification: ????: 0.02??????? + ??????: 0.02??????? + ????? InnoDB
wp_options: ????: 5.63??????? + ??????: 0.10??????? + ????? MyISAM
wp_postmeta: ????: 17.36??????? + ??????: 1.72??????? + ????? MyISAM
wp_posts: ????: 6.00??????? + ??????: 0.26??????? + ????? MyISAM
wp_revslider_css: ????: 0.09??????? + ??????: 0.01??????? + ????? MyISAM
wp_revslider_css_bkp: ????: 0.01??????? + ??????: 0.00??????? + ????? MyISAM
wp_revslider_layer_animations: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_revslider_layer_animations_bkp: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_revslider_navigations: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_revslider_navigations_bkp: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_revslider_sliders: ????: 0.01??????? + ??????: 0.00??????? + ????? MyISAM
wp_revslider_sliders_bkp: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_revslider_slides: ????: 0.01??????? + ??????: 0.00??????? + ????? MyISAM
wp_revslider_slides_bkp: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_revslider_static_slides: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_revslider_static_slides_bkp: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_termmeta: ????: 0.11??????? + ??????: 0.07??????? + ????? MyISAM
wp_terms: ????: 0.15??????? + ??????: 0.27??????? + ????? MyISAM
wp_term_relationships: ????: 0.16??????? + ??????: 0.29??????? + ????? MyISAM
wp_term_taxonomy: ????: 0.08??????? + ??????: 0.10??????? + ????? MyISAM
wp_tm_taskmeta: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_tm_tasks: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_usermeta: ????: 0.06??????? + ??????: 0.04??????? + ????? MyISAM
wp_users: ????: 0.00??????? + ??????: 0.01??????? + ????? MyISAM
wp_wc_admin_notes: ????: 0.02??????? + ??????: 0.00??????? + ????? MyISAM
wp_wc_admin_note_actions: ????: 0.01??????? + ??????: 0.00??????? + ????? MyISAM
wp_wc_category_lookup: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_wc_customer_lookup: ????: 0.00??????? + ??????: 0.01??????? + ????? MyISAM
wp_wc_download_log: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_wc_order_coupon_lookup: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_wc_order_product_lookup: ????: 0.00??????? + ??????: 0.01??????? + ????? MyISAM
wp_wc_order_stats: ????: 0.00??????? + ??????: 0.01??????? + ????? MyISAM
wp_wc_order_tax_lookup: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_wc_product_attributes_lookup: ????: 0.34??????? + ??????: 0.39??????? + ????? InnoDB
wp_wc_product_download_directories: ????: 0.02??????? + ??????: 0.02??????? + ????? InnoDB
wp_wc_product_meta_lookup: ????: 0.02??????? + ??????: 0.04??????? + ????? MyISAM
wp_wc_rate_limits: ????: 0.02??????? + ??????: 0.02??????? + ????? InnoDB
wp_wc_reserved_stock: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_wc_tax_rate_classes: ????: 0.00??????? + ??????: 0.01??????? + ????? MyISAM
wp_wc_webhooks: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_woocommerce_ir_sms_archive: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_woocommerce_ir_sms_contacts: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_woodmart_wishlists: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_woodmart_wishlist_products: ????: 0.00??????? + ??????: 0.01??????? + ????? MyISAM
wp_wpyar_alert_onsale: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_wpyar_alert_stocked: ????: 0.00??????? + ??????: 0.00??????? + ????? MyISAM
wp_yoast_indexable: ????: 1.19??????? + ??????: 0.24??????? + ????? MyISAM
wp_yoast_indexable_hierarchy: ????: 0.03??????? + ??????: 0.09??????? + ????? MyISAM
wp_yoast_migrations: ????: 0.00??????? + ??????: 0.01??????? + ????? MyISAM
wp_yoast_primary_term: ????: 0.01??????? + ??????: 0.02??????? + ????? MyISAM
wp_yoast_prominent_words: ????: 0.08??????? + ??????: 0.17??????? + ????? MyISAM
wp_yoast_seo_links: ????: 0.05??????? + ??????: 0.02??????? + ????? MyISAM

### Post Type Counts ###

acf-field: 1
acf-field-group: 1
attachment: 717
attribute_group: 18
cms_block: 29
customize_changeset: 5
elementor_library: 1
itsec-dash-card: 6
itsec-dashboard: 1
mailpoet_page: 1
mc4wp-form: 2
nav_menu_item: 103
page: 13
portfolio: 9
post: 17
product: 179
product_variation: 118
revision: 988
shop_order: 32
wafs: 1
woodmart_sidebar: 1
woodmart_slide: 5
wp_block: 1
wp_global_styles: 1

### Security ###

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

### Active Plugins (28) ###

Query Monitor: ???? John Blackbourn – 3.9.0
weLaunch Framework: ???? weLaunch.io – 1.0.12
????????? ?????? ???????: ???? Delicious Brains – 5.12.2
????? ?? ?????? ??? ???? ???????: ???? ????? ?????? – 1.2.0
????? ?? ???: ???? ??????? ?????? ?? ??? – 8.1.2
?????????? ??????: ???? ??????? ?????? – 0.3
DIGITS: ??? ??? ? ???? ?? ?????? – ???? ??: ???? ?????? – 7.9.2.5
??????? ???: ???? https://www.zhaket.com/web/elementor-pro-plugin – 3.4.1
???????: ???? Elementor.com – 3.6.5
?? LiteSpeed: ???? LiteSpeed Technologies – 4.6
????? ???? ?? ???????: ???? ??????? ????? – 4.4.2
??????? ??????? ??????? ???? ??? – ????: ???? Torob – 1.2.2
Slider Revolution: ???? ThemePunch – 6.5.8
UberMenu – Flat Skins Pack Extension: ???? Chris Mavricos
SevenSpark – 3.0

UberMenu 3 – The Ultimate WordPress Mega Menu: ???? Ehsan12 – 3.7.6
???????? ??? ?????: ???? ???????? ????????? | ???????? ?? ???? – 4.62.1
WooCommerce Advanced Free Shipping: ???? Jeroen Sormani – 1.1.4
?????????? ????????? ???????: ???? Beasttheme – 1.7.4
?????? ???? ?? ???????: ???? ??? ??? ????? – 10.10.2
???????: ???? ???????? – 6.5.1
Woodmart Core: ???? – 1.0.29
Yoast SEO Premium ????????: ???? ??? Yoast – 18.1
?????? Yoast SEO: ???? ??? Yoast – 18.8
???? ?????? ?????: ???? ??? ?????? ????? – 4.0.1
WPS Hide Login: ???? WPServeur
NicolasKulka
wpformation – 1.9.4

????? ????? ??? ??: ???? ??? ????? ??? ?? – 1.3.6
?????? ?????? ??? ???????? ???? ???????: ???? Masoud Amini
alireza yousefi – 4.8.1

zibal payment gateway for woocommerce: ???? Mohammad Zamanzadeh – 1.6

### Inactive Plugins (3) ###

Pasargad electronic payment Woocommerce gateway: ???? Mojtaba Darvishi – 1.0.1
WP Crontrol: ???? John Blackbourn & crontributors – 1.12.1
????? ?????? ???????? ???? ???????: ???? ???? ?????? ????????? ???????? – 1.0

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Settings ###

API Enabled: –
Force SSL: –
Currency: IRT (?????)
Currency Position: left
Thousand Separator: .
Decimal Separator: ,
Number of Decimals: 0
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 ###

?????? ???????: #6 – /shop/
??? ????: #7 – /cart/
??????: #8 – /checkout/
???? ?????? ??: #9 – /my-account/
????? ? ?????: #12679 – /%d8%b4%d8%b1%d8%a7%db%8c%d8%b7-%d9%88-%d8%b6%d9%88%d8%a7%d8%a8%d8%b7/

### Theme ###

Name: Woodmart Child
Version: 1.0.0
Author URL: https://xtemos.com
Child Theme: ?
Parent Theme Name: Woodmart
Parent Theme Version: 6.2.4
Parent Theme Author URL: https://zhaket.com/product/woodmart-woocommerce-theme/
WooCommerce Support: ?

### Templates ###

Overrides: woodmart/woocommerce/archive-product.php
woodmart/woocommerce/cart/cart-item-data.php
woodmart/woocommerce/cart/cart.php
woodmart/woocommerce/cart/cross-sells.php
woodmart/woocommerce/cart/mini-cart.php
woodmart/woocommerce/checkout/form-checkout.php
woodmart/woocommerce/checkout/thankyou.php
woodmart/woocommerce/content-product-cat.php
woodmart/woocommerce/content-product.php
woodmart/woocommerce/content-single-product.php
woodmart/woocommerce/content-widget-product.php
woodmart/woocommerce/global/breadcrumb.php
woodmart/woocommerce/global/form-login.php
woodmart/woocommerce/global/quantity-input.php
woodmart/woocommerce/loop/add-to-cart.php
woodmart/woocommerce/loop/loop-end.php
woodmart/woocommerce/loop/loop-start.php
woodmart/woocommerce/loop/no-products-found.php
woodmart/woocommerce/loop/orderby.php
woodmart/woocommerce/loop/pagination.php
woodmart/woocommerce/loop/sale-flash.php
woodmart/woocommerce/myaccount/form-login.php
woodmart/woocommerce/product-searchform.php
woodmart/woocommerce/single-product/add-to-cart/grouped.php
woodmart/woocommerce/single-product/add-to-cart/variable.php ???? 3.5.5 ????? ????? ???. ???? ???? ??? 6.1.0
woodmart/woocommerce/single-product/meta.php
/home/itookmar/public_html/wp-content/plugins/woocommerce-group-attributes/public/partials/woocommerce-group-attributes-output-layout-1.php
woodmart/woocommerce/single-product/product-image.php
woodmart/woocommerce/single-product/product-thumbnails.php
woodmart/woocommerce/single-product/rating.php
woodmart/woocommerce/single-product/related.php
woodmart/woocommerce/single-product/sale-flash.php
woodmart/woocommerce/single-product/tabs/tabs.php
woodmart/woocommerce/single-product/title.php
woodmart/woocommerce/single-product/up-sells.php
woodmart/woocommerce/single-product.php

Outdated Templates: ?

?????? ?? ??? ????? ?? ????????

### Action Scheduler ###

????? ???: 160
Oldest: 2022-04-16 08:31:15 +0430
Newest: 2022-05-16 18:10:23 +0430

??????: 1
Oldest: 2022-03-09 10:14:04 +0330
Newest: 2022-03-09 10:14:04 +0330

### Status report information ###

Generated at: 2022-05-16 18:11:44 +04:30
`

Hi @parisaaxp

Did you make any changes prior to this? E.g. did you create a new product and that caused duplicate products? Or duplicate products showed up after plugin update etc..?

Looking at your system status, I see that there are some outdated templates. Can you follow the steps described here to fix this first?

If the issue persists, I’d recommend checking for a theme/plugin conflict. You can find a detailed explanation on how to do a conflict test here: https://docs.woocommerce.com/document/how-to-test-for-conflicts/

found the problem :

to customize the products order I used this snippet and put it in my theme’s functions.php

add_filter('posts_clauses', 'order_by_stock_status');
function order_by_stock_status($posts_clauses) {
    global $wpdb;
    // only change query on WooCommerce loops
    if (is_woocommerce() && (is_shop() || is_product_category() || is_product_tag() || is_product_taxonomy())) {
        $posts_clauses['join'] .= " INNER JOIN $wpdb->postmeta istockstatus ON ($wpdb->posts.ID = istockstatus.post_id) ";
        $posts_clauses['orderby'] = " istockstatus.meta_value ASC, " . $posts_clauses['orderby'];
        $posts_clauses['where'] = " AND istockstatus.meta_key = '_stock_status' AND istockstatus.meta_value <> '' " . $posts_clauses['where'];
    }
    return $posts_clauses;
}

I dunno which part of it caused my problem.
Thank you for your time.

Hi @parisaaxp ,

Glad to hear that you were able to resolve the issue.

Please feel free to create a new thread if you need any further help ??

Best,

found the problem

Great! Thanks for letting us know. I’m marking this topic as resolved.