3.0 Issues: pagination, terms & conditions

I also found, when duplicating products, it doesn’t change the time of publish now. So new items end up down in the list. Not sure if it is related.

Just tried to do the 3.0.1 update and it failed.

Do it manually then. Upload via FTP. It fixes the publish date on dupe issue.

Update done. I also tried disabling all plugins to see if the page error went away. No go, still there.

Screenshot?

Here is a link to my site. This is page 40, which is one of the MANY blank pages. You can see how it is showing xxxx of xxxx many products. Page after page of blank, just some random (in stock) ones that happen to be in stock floating around, depending when they were added.
https://www.pintailwaterfowl.com/shop/page/40/

The update DID fix the error and I believe the timestamp while duplicating.

Also, my system status:

### WordPress Environment ###

Home URL: https://www.pintailwaterfowl.com
Site URL: https://www.pintailwaterfowl.com
WC Version: 3.0.1
Log Directory Writable: ?
WP Version: 4.7.3
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US

### Server Environment ###

Server Info: Apache/2.2.32 (Unix) mod_ssl/2.2.32 OpenSSL/1.0.1e-fips mod_bwlimited/1.4
PHP Version: 5.6.30
PHP Post Max Size: 500 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.38.0
OpenSSL/1.0.1e

SUHOSIN Installed: –
MySQL Version: ? 5.5.54 - We recommend a minimum MySQL version of 5.6. See: WordPress requirements
Max Upload Size: 500 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.0.1
WC Database Prefix: wp_
woocommerce_sessions: ?
woocommerce_api_keys: ?
woocommerce_attribute_taxonomies: ?
woocommerce_downloadable_product_permissions: ?
woocommerce_order_items: ?
woocommerce_order_itemmeta: ?
woocommerce_tax_rates: ?
woocommerce_tax_rate_locations: ?
woocommerce_shipping_zones: ?
woocommerce_shipping_zone_locations: ?
woocommerce_shipping_zone_methods: ?
woocommerce_payment_tokens: ?
woocommerce_payment_tokenmeta: ?

### Security ###

Secure connection (HTTPS): ?Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates.
Hide errors from visitors: ?

### Active Plugins (32) ###

WooCommerce ShippingEasy Integration: by WooThemes – 3.4.1
Social Media Widget by Acurax: by Acurax – 3.2.4
Advanced Database Cleaner: by Younes JFR. – 2.0.0
Akismet Anti-Spam: by Automattic – 3.3
All In One SEO Pack: by Michael Torbert – 2.3.12.2.1
iThemes Security: by iThemes – 6.2.1
Better WordPress Google XML Sitemaps: by Khang Minh – 1.4.1
Cleverness To-Do List: by C.M. Kendrick – 3.4.2
Custom Post Type UI: by WebDevStudios – 1.5.3
Email Users: by Mike Walsh & MarvinLabs – 4.8.4
Google Analyticator: by SumoMe – 6.5.2
Image Rotation Repair: by Shane & Peter
Inc. – 1.1

Image Watermark: by dFactory – 1.6.1
jQuery Colorbox: by Arne Franken – 4.6.2
jQuery Updater: by Ramoonus – 3.2.1
More Fields: by Henrik Melin
Kal Str?m – 2.1

P3 (Plugin Performance Profiler): by GoDaddy.com – 1.5.3.9
VarkTech Pricing Deals for WooCommerce: by Vark – 1.1.7
Fast Secure Contact Form: by Mike Challis
Ken Carlson – 4.0.50

SSL Insecure Content Fixer: by WebAware – 2.2.3
Use Google Libraries: by Jason Penney – 1.6.2.1
WooCommerce Bulk Discount: by Rene Puchinger – 2.4.4
WooCommerce Cart Image - Widget and Shortcode - WordPress Sidebar and Posts Plugin: by WooCommerce and WordPress Plugins – 1.0
WooCommerce Cost of Goods: by WooThemes / SkyVerge – 1.8.0 – 2.3.0 is available
WooCommerce Custom Status: by Garman Technical Services – 1.0
WooCommerce Print Invoice & Delivery Note: by Triggvy Gunderson – 4.1.5
WooCommerce Product Add-ons: by WooThemes – 2.7.9 – 2.8.1 is available
WooCommerce Store Credit: by WooThemes – 2.1.5
WooCommerce: by Automattic – 3.0.1
WordPress Gzip Compression: by James Socol – 1.0
WP Super Cache: by Automattic – 1.4.9
YITH WooCommerce Affiliates: by YITHEMES – 1.1.0

### Settings ###

API Enabled: ?
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

### WC Pages ###

Shop base: #363 - /shop/
Cart: #364 - /cart/
Checkout: #365 - /checkout/
My account: #367 - /my-account/

### Theme ###

Name: Pintail Waterfowl Theme
Version: 1.0.0
Author URL: https://www.barbedhook.com
Child Theme: ?
Parent Theme Name: Storefront
Parent Theme Version: 2.1.8
Parent Theme Author URL: https://woocommerce.com/
WooCommerce Support: ?

### Templates ###

Overrides: –

Hi,

I had a similar problem with pagination. It was caused by a snippet in my functions.php based on this: https://docs.woocommerce.com/document/exclude-a-category-from-the-shop-page/.

After removing the snippet the pagination was ok again. So please check if one of your plugins has similar filtering functionality and might cause this issue. Good luck!

• This reply was modified 7 years, 11 months ago by Soft79.

Looks like the initial data upgrade may have failed or timed out. How many products in total?

Assuming this isn’t due to a bad plugin or customisation, this could be ran again manually https://github.com/woocommerce/woocommerce/blob/master/includes/wc-update-functions.php#L1040

If you were able to export (tools > Export) the products I could (or you could) check if the product_visibility term outofstock was applied to your products correctly before running that updater again.

But yeah, ensure it’s not custom code first.

Have 5058 products in the store. Most are out of stock. We leave then in case we ever add that color again (which wwe do regularly).

I tried removing all info from my child themes functions.php file. No change.

Tried exporting products DB. Froze site. Had to kill processes.

Looked in php myAdmin. Didn’t see any table related to product_visability but I did find this: _stock_status outofstock.

I added this to my functions.php
if ( ! empty( $_GET[‘wc_update_300_product_visibility’] ) ) {
wc_update_300_product_visibility();
}

then went to mysite.com?wc_update_300_product_visibility=true but just got an error.

product_visability is not a table, is a taxonomy. Look at the wp_terms table and see if the terms are linked to products.

What was the error? Ensure there are no curly quotes in the code you added as that would be invalid syntax.

I put the code is exactly as I wrote it. Error was: Fatal error: Call to undefined function wc_update_300_product_visibility() in /home/typecxxk/public_html/pintailwaterfowl/wp-content/themes/storefront-child/functions.php on line 109

Here is a screen shot of the table wp_term_taxonomy

I’m guessing id 115 is “in stock” and is 116 is “out of stock”

There is not in stock filter.

if ( ! empty( $_GET[‘wc_update_300_product_visibility’] ) ) {
global $wpdb;

if ( $outofstock_term = get_term_by( 'name', 'outofstock', 'product_visibility' ) ) {
		$wpdb->query( $wpdb->prepare( "INSERT IGNORE INTO {$wpdb->term_relationships} SELECT post_id, %d, 0 FROM {$wpdb->postmeta} WHERE meta_key = '_stock_status' AND meta_value = 'outofstock';", $outofstock_term->term_taxonomy_id ) );
	}
}

I added the above code to functions.php

Went to https://www.pintailwaterfowl.com/?wc_update_300_product_visibility=true

Nothing happened or changed.

Sorry, im not a programmer at all, just a front end guy.

Ok let’s try something else. Note the pagination results count.

Make one of your instock products out of stock. Does the count reduce?

If yes, it’s term data related.

If no, as suggested by someone above its code. I don’t know if you tried another theme but do a quick test with a default theme.