Support » Plugin: WooCommerce » With large amounts of variations only 10 variations are shown in the backend

With large amounts of variations only 10 variations are shown in the backend

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support Mirko P. (woo-hc)

    (@rainfallnixfig)

    2 years, 6 months ago

    Hi @webdegelijk,

    Could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.

    Thanks!

    Thread Starter webdegelijk

    (@webdegelijk)

    2 years, 6 months ago

    Thanks Mirko, Here you go.
    Regards,
    Paul

    
### WordPress Environment ###

WordPress address (URL): its a developement url
Site address (URL): its a developement url
WC Version: 5.3.0
REST API Version: ✔ 5.3.0
WC Blocks Version: ✔ 4.9.1
Action Scheduler Version: ✔ 3.1.6
WC Admin Version: ✔ 2.2.6
Log Directory Writable: ✔
WP Version: 5.7.2
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ✔
Language: nl_NL
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.16
PHP Post Max Size: 32 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.71.0
OpenSSL/1.1.1d

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

### Database ###

WC Database Version: 5.3.0
WC Database Prefix: wp_
Totale databasegrootte: 139.15MB
Database datagrootte: 69.87MB
Database index grootte: 69.28MB
wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 0.13MB + Index: 0.11MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
wp_akeeba_common: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ak_params: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ak_profiles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ak_stats: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ak_storage: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ak_users: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_facetwp_index: Data: 3.03MB + Index: 4.84MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailpoet_mapping_to_external_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_newsletters: Data: 0.03MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wp_mailpoet_scheduled_tasks: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_segments: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_subscribers: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_options: Data: 5.47MB + Index: 0.09MB + Engine InnoDB
wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_hash: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_postmeta: Data: 38.53MB + Index: 33.13MB + Engine InnoDB
wp_posts: Data: 12.52MB + Index: 21.52MB + Engine InnoDB
wp_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Data: 0.30MB + Index: 0.30MB + Engine InnoDB
wp_terms: Data: 0.30MB + Index: 0.28MB + Engine InnoDB
wp_term_relationships: Data: 1.52MB + Index: 1.47MB + Engine InnoDB
wp_term_taxonomy: Data: 0.36MB + Index: 0.33MB + Engine InnoDB
wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 3.52MB + Index: 4.95MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

### Post Type Counts ###

acf-field: 1
acf-field-group: 1
attachment: 29
ct_template: 8
mailpoet_page: 1
nav_menu_item: 7
page: 7
post: 1
product: 50
product_variation: 28609
revision: 18
shop_order: 1

### Security ###

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

### Active Plugins (12) ###

Advanced Custom Fields: door Elliot Condon – 5.9.3
Akeeba Backup for WordPress: door Akeeba Ltd – 7.5.6
Codefragmenten: door Code Snippets Pro – 2.14.1
FacetWP - Flyout menu: door FacetWP
LLC – 0.4

FacetWP: door FacetWP
LLC – 3.6.6

MailPoet 3 Premium (New): door MailPoet – 3.60.0
MailPoet 3 (New): door MailPoet – 3.60.10
OxyExtras: door OxyExtras – 1.3.4
Oxygen Elements for WooCommerce: door Soflyy – 1.4
Oxygen: door Soflyy – 3.7.1
WooCommerce: door Automattic – 5.3.0
WPlit Woo Conditions for Oxygen: door WPlit – 1.0.1

### Inactive Plugins (14) ###

Akismet Anti-Spam: door Automattic – 4.1.3
Animate It!: door eLEOPARD Design Studios – 2.3.6
Estimate delivery date for WooCommerce: door PI WebSolution – 4.6.7
Extra Product Options (Product Addons) for WooCommerce: door ThemeHigh – 3.0.5
Hello Dolly: door Matt Mullenweg – 1.7.2
Markup by Attribute for WooCommerce: door MarkTomlinson – 3.9.6
Redis Object Cache: door Till Krüss – 2.0.18
Variation Swatches for WooCommerce: door Emran Ahmed – 1.1.17
W3 Total Cache: door BoldGrid – 2.1.2
WooCommerce Admin: door WooCommerce – 2.3.0
WooCommerce variations Select2: door Sti3bas – 1.2.1
Woo Variations Table: door Alaa Rihan – 2.2.12
WP All Export: door Soflyy – 1.2.8
WP All Import: door Soflyy – 3.5.7

### Must Use Plugins (1) ###

akeeba-backup-coreupdate.php: door  –

### Settings ###

API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: left
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 ###

Winkelbasis: #9 - /winkel/
Winkelmand: #10 - /winkelmand/
Afrekenen: #11 - /afrekenen/
Mijn account: #12 - /mijn-account/
Algemene voorwaarden: ❌ Pagina niet ingesteld

### Theme ###

Name: Twenty Twenty
Version: 1.1 (update naar versie 1.7 is beschikbaar)
Author URL: https://nl.wordpress.org/
Child Theme: ❌ – Als je wijzigingen aanbrengt in WooCommerce of in een hoofdthema dat je niet zelf gebouwd hebt
raden we het gebruik van een child thema aan. Zie: Hoe maak je een child thema

WooCommerce Support: ✔

### Templates ###

Overrides: –

### Action Scheduler ###

Afgerond: 388
Oldest: 2021-04-30 10:49:33 +0000
Newest: 2021-05-25 04:03:51 +0000

Mislukt: 1
Oldest: 2020-03-25 07:31:41 +0000
Newest: 2020-03-25 07:31:41 +0000

### Status report information ###

Generated at: 2021-05-25 04:08:37 +00:00
    Thread Starter webdegelijk

    (@webdegelijk)

    2 years, 6 months ago

    TYI: Importing the products with the many variations to a blank woo install leads to the same result, I can somehow only see the first 10 variations..
    So if its probably not in my site configuration I would think its in my csv file. But, products with less variants use the same kind of csv file..

    Plugin Support Mirko P. (woo-hc)

    (@rainfallnixfig)

    2 years, 6 months ago

    Hi @webdegelijk,

    Thanks for getting back!

    I wasn’t able to replicate the issue on my WooCommerce test page. I added more than 1500 variations to a variable product and the product data section shows 15 variations at a time for each page. That is also the number of variations per page mentioned in the WooCommerce documentation.

    My Server environment settings though are different from yours. Not sure if those settings may have a role in that issue. Possibly, you’ll want to try and increase the PHP Max Input Vars from the default value. Here’s an article that has more details about it.

    Also, you could change the number of variations per page on admin screen by setting your own number (e.g. return 15;) adding this function to your functions.php file using a plugin like Code Snippets by Code Snippets Pro.

    It’s always recommended to have a full backup in place of your site and database before making any changes. You could consider using a service like Jetpack. If something goes wrong, it’s nice to know that you can restore your site to the previous state.

    Let us know how it goes!

    Thread Starter webdegelijk

    (@webdegelijk)

    2 years, 6 months ago

    I increased the PHP Max Input Vars (to 5000 in the .htaccess file). Problem solved. Thank you very much Mirko for your help!

    Regards,
    Paul

    Plugin Support Mirko P. (woo-hc)

    (@rainfallnixfig)

    2 years, 6 months ago

    Awesome! Thanks so much for letting us know.

    I’m going to mark this thread resolved. If you have further questions, please feel free to open a new topic.

    Cheers.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘With large amounts of variations only 10 variations are shown in the backend’ is closed to new replies.

Topic Tags

Views