Jili999 register link download.REGISTER NOW GET FREE 888 PESOS REWARDS!

Resolved

(@essmeier)

I have a store where I sell one of a kind items. My inventory is binary; it’s either in stock or sold out. AFAIK, I have nothing checked anywhere to enable backorders.

When creating individual product pages, I enable stock management, set quantity to 1 and set backorders to “do not allow.’

Problem: When I sell an item, it still shows an available quantity of 1 to site visitors, giving the impression that it’s available for purchase.

If I go to Woocommerce -> Products, that product is shown as “on backorder,” rather than “out of stock,” with an inventory count of 0. The system is correctly decrementing inventory when a sale is made, but incorrectly marking sold items as “on backorder.”

If I edit the product page, it correctly shows an in-stock quantity of 0. If I click “update” without changing anything, the published page then shows as “out of stock” to site visitors and it updates on the Woocommerce -> Products page from “on backorder” to “out of stock.”

Any idea what’s happening here?


### WordPress Environment ###

Home URL: https://www.rarerecords.net
Site URL: https://www.rarerecords.net
WC Version: 3.5.4
Log Directory Writable: ?
WP Version: 5.0.3
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.2.15
PHP Post Max Size: 8 MB
PHP Time Limit: 0
PHP Max Input Vars: 1000
cURL Version: 7.64.0
OpenSSL/1.0.2q

SUHOSIN Installed: –
MySQL Version: 5.6.41
Max Upload Size: 2 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.5.4
WC Database Prefix: wp_
MaxMind GeoIP Database: ?
Total Database Size: 65.62MB
Database Data Size: 58.91MB
Database Index Size: 6.71MB
wp_woocommerce_sessions: Data: 33.71MB + Index: 1.71MB
wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_order_items: Data: 0.04MB + Index: 0.02MB
wp_woocommerce_order_itemmeta: Data: 0.19MB + Index: 0.15MB
wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB
wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB
wp_blc_filters: Data: 0.00MB + Index: 0.00MB
wp_blc_instances: Data: 0.13MB + Index: 0.03MB
wp_blc_links: Data: 1.11MB + Index: 0.13MB
wp_blc_synch: Data: 0.00MB + Index: 0.00MB
wp_commentmeta: Data: 0.01MB + Index: 0.02MB
wp_comments: Data: 0.05MB + Index: 0.03MB
wp_gdpr_request_records: Data: 0.02MB + Index: 0.00MB
wp_itsec_distributed_storage: Data: 0.00MB + Index: 0.00MB
wp_itsec_fingerprints: Data: 0.00MB + Index: 0.00MB
wp_itsec_geolocation_cache: Data: 0.00MB + Index: 0.00MB
wp_itsec_lockouts: Data: 0.00MB + Index: 0.00MB
wp_itsec_logs: Data: 0.00MB + Index: 0.01MB
wp_itsec_temp: Data: 0.00MB + Index: 0.00MB
wp_links: Data: 0.00MB + Index: 0.00MB
wp_options: Data: 2.38MB + Index: 0.23MB
wp_pmxe_exports: Data: 0.00MB + Index: 0.00MB
wp_pmxe_google_cats: Data: 0.26MB + Index: 0.05MB
wp_pmxe_posts: Data: 0.00MB + Index: 0.00MB
wp_pmxe_templates: Data: 0.00MB + Index: 0.00MB
wp_pmxi_files: Data: 0.00MB + Index: 0.00MB
wp_pmxi_history: Data: 0.00MB + Index: 0.00MB
wp_pmxi_images: Data: 0.01MB + Index: 0.00MB
wp_pmxi_imports: Data: 0.07MB + Index: 0.00MB
wp_pmxi_posts: Data: 0.00MB + Index: 0.00MB
wp_pmxi_templates: Data: 0.00MB + Index: 0.00MB
wp_popularpostsdata: Data: 0.05MB + Index: 0.00MB
wp_popularpostssummary: Data: 0.39MB + Index: 0.50MB
wp_postmeta: Data: 9.39MB + Index: 2.19MB
wp_posts: Data: 8.35MB + Index: 0.46MB
wp_redirection_404: Data: 0.14MB + Index: 0.10MB
wp_redirection_groups: Data: 0.00MB + Index: 0.00MB
wp_redirection_items: Data: 0.01MB + Index: 0.01MB
wp_redirection_logs: Data: 2.26MB + Index: 0.60MB
wp_smush_dir_images: Data: 0.00MB + Index: 0.00MB
wp_termmeta: Data: 0.03MB + Index: 0.02MB
wp_terms: Data: 0.02MB + Index: 0.05MB
wp_term_relationships: Data: 0.15MB + Index: 0.32MB
wp_term_taxonomy: Data: 0.03MB + Index: 0.03MB
wp_usermeta: Data: 0.01MB + Index: 0.01MB
wp_users: Data: 0.00MB + Index: 0.01MB
wp_vtprd_purchase_log: Data: 0.00MB + Index: 0.00MB
wp_vtprd_purchase_log_product: Data: 0.00MB + Index: 0.00MB
wp_vtprd_purchase_log_product_rule: Data: 0.00MB + Index: 0.00MB
wp_wc_download_log: Data: 0.00MB + Index: 0.00MB
wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB
wp_wdp_orders: Data: 0.00MB + Index: 0.00MB
wp_wdp_order_items: Data: 0.00MB + Index: 0.01MB
wp_wdp_rules: Data: 0.02MB + Index: 0.00MB
wp_woocommerce_exported_csv_items: Data: 0.08MB + Index: 0.01MB

### Post Type Counts ###

attachment: 2772
customize_changeset: 68
custom_css: 1
jetpack_migration: 2
jp_img_sitemap: 4
jp_img_sitemap_index: 2
jp_pay_order: 1
jp_sitemap: 2
jp_sitemap_master: 2
nav_menu_item: 13
page: 37
post: 65
product: 679
revision: 214
shop_coupon: 30
shop_order: 322
shop_order_refund: 2
tablepress_table: 1
testimonial: 24
turbo-sidebar-cpt: 13
wpcf7_contact_form: 1

### Security ###

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

### Active Plugins (41) ###

Advanced Dynamic Pricing for WooCommerce: by AlgolPlus – 1.5.2
Anti-spam: by webvitaly – 5.3
Better Search Replace: by Delicious Brains – 1.3.2
iThemes Security: by iThemes – 7.3.0
Broken Link Checker: by Janis Elsts
Vladimir Prelovac – 1.11.5

Classic Editor: by WordPress Contributors – 1.4
Cloudflare: by John Wineman
Furkan Yilmaz
Junade Ali (Cloudflare Team) – 3.3.2

Contact Form 7 Honeypot: by Nocean – 1.14
Contact Form 7: by Takayuki Miyoshi – 5.1.1
Easy Testimonials: by Gold Plugins – 3.3.1
Google XML Sitemaps: by Arne Brachhold – 4.1.0
HTML Widget Text: by <a href="https://jaimyn.com.au">Jaimyn Mayer</a> – 1.1
Jetpack by WordPress.com: by Automattic – 7.0.1
PHP Compatibility Checker: by WP Engine – 1.4.7
Platinum SEO Pack: by Rajesh - Techblissonline Dot Com – 1.3.8
Really Simple SSL pro: by Rogier Lankhorst – 2.0.23
Really Simple SSL: by Rogier Lankhorst
Mark Wolters – 3.1.3

Redirection: by John Godley – 3.7.3
Simple Custom CSS: by John Regan
Danny Van Kooten – 4.0.1

Social Media Feather: by socialmediafeather – 1.8.4
WP woocommerce featured product by category: by WP OnlineSupport – 1.1
Spider Blocker: by Easy Blog Networks – 1.0.19
Storefront Powerpack: by WooCommerce – 1.4.13 – 1.4.14 is available
TablePress: by Tobias B?thge – 1.9.1
TinyMCE Advanced: by Andrew Ozz – 5.0.1
WooCommerce Customer/Order CSV Export: by SkyVerge – 4.6.2
WooCommerce PayPal Checkout Gateway: by WooCommerce – 1.6.9
WooCommerce Print Invoices/Packing Lists: by SkyVerge – 3.6.2
WooCommerce Sequential Order Numbers Pro: by SkyVerge – 1.12.2
WooCommerce Services: by Automattic – 1.18.0
WooCommerce USPS Shipping: by WooCommerce – 4.4.20
WooCommerce Shortcodes: by WooThemes
Claudio Sanches – 1.0.0 – Not tested with the active version of WooCommerce

WooCommerce: by Automattic – 3.5.4
WordPress Popular Posts: by Hector Cabrera – 4.2.2
WP All Export Pro: by Soflyy – 1.5.4
WP All Import Pro: by Soflyy – 4.5.5
Smush: by WPMU DEV – 3.1.1
WP All Import - WooCommerce Add-On Pro: by Soflyy – 3.0.6
WP GDPR Fix Pro: by TEKNIKFORCE – 1.7
WPS Hide Login: by WPServeur
NicolasKulka
tabrisrp – 1.5.2.1

Google XML Sitemap for Videos: by Amit Agarwal – 2.6.1

### 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)

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)

### WC Pages ###

Shop base: #4 - /store/
Cart: #5 - /cart/
Checkout: #6 - /checkout/
My account: #7 - /my-account/
Terms and conditions: #68 - /terms/

### Theme ###

Name: Storefront Child
Version: 1.0
Author URL: https://woocommerce.com
Child Theme: ?
Parent Theme Name: Storefront
Parent Theme Version: 2.4.3
Parent Theme Author URL: https://woocommerce.com/
WooCommerce Support: ?

### Templates ###

Overrides: –

### Customer/Order CSV Export ###

Order Export Format: default
Customer Export Format: default
Automatically Export Orders: disabled
Automatically Export Customers: disabled

This topic was modified 6 years, 1 month ago by James Huff.
This topic was modified 6 years, 1 month ago by essmeier. Reason: deleted extraneous content

The page I need help with: [log in to see the link]

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

Thread Starter essmeier
(@essmeier)

6 years, 1 month ago

Made a sale this morning; sold three items.
Each item was unique; I had a stock of 1 on each item.

After the sale, the following conditions exist:

1. All three items are showing as still available for purchase if you view them on the Website as a site visitor.
2. All three items show “On Backorder” on the Woocommerce -> Products page.
3. If I go to edit each of these three items, all three show stock quantity of 0 and Allow Backorders is set to “Do Not Allow.”

As I had each item open for editing, I clicked the “Update” button without editing anything.

After the refresh, all three items are now showing as “Out of Stock” on the Woocommerce -> Products page.
Plugin Support Grigorij S. a11n
(@grigaswp)

6 years ago
Hi there,

Thank you for reaching out!

I understand that despite backorders being disabled in the settings of your products – out of stock products are on backorder instead.

Are those variable products by any chance?

If it’s a variable product:
A quick fix would be to go to WooCommerce > Settings > Inventory and tick the box next to Hide out of stock items from the catalog, but I have a feeling that this could be caused by a plugin/theme conflict and the best way to determine whether that’s the case is to do a full plugin/theme conflict test.

From your System Status Report I do see that you have quite a few premium WooCommerce.com extensions so you should be eligible for premium support via chats and tickets on WooCommerce.com.

If a plugin/theme conflict test doesn’t show the reason behind this behaviour – please head to Create a Ticket section on WooCommerce.com and submit a new support request with a link to this support thread. My colleagues will be happy to dig deeper into this for you.

I hope this helps!
Thread Starter essmeier
(@essmeier)

6 years ago

Not variable products.

I think the problem may relate to products that I migrated from another shopping cart system.

I just built my Woocommerce site in the past two weeks and migrated 95% of my products from a Shopp system using the paid Cart2Cart service. I’ve since added products to the store directly.

Recently added “test” products decrement properly and show out of stock but the sales causing the problem were sales of products that had been migrated from the old cart.

Perhaps there’s some issue with the migrated products so that they weren’t properly flagged as “do not allow backorders” in the database.

Yesterday, I installed the Woocmmerce Bulk Stock Management plugin. I edited all of my products in bulk to reinforce the “Do not allow backorders” setting.

I also upgraded Woocommerce to the new 3.5.5 version.

I’m hoping that one of those two things will fix the problem, though I’ll need a “real” sale to verify that.

I just added a test product and used my wife’s PayPal account to make a purchase and everything worked correctly, with inventory showing “out of stock” on both the product page and the Woocommerce -> Products page.

I’ll have a “real” sale soon enough and that should tell me if the problem is fixed. I’ll update here with the results of that.

Plugin Support Grigorij S. a11n
(@grigaswp)

6 years ago

Hi there,

Thank you for the additional details and your attempted solutions!

Indeed, an import could definitely be the root cause here. If the solutions you’ve tried so far will not help – you could try exporting all products, making sure this particular set of data is included in the .csv file and re-importing the products.

Please let us know if Bulk Stock Manager or export/re-import won’t solve this, otherwise we’ll mark this thread as resolved next week.
Thread Starter essmeier
(@essmeier)

6 years ago
I just made a sale of one of the products in my store that had been migrated to Woocommerce from the old Shopp cart.

As a result of the sale:

1. Inventory decremented from 1 item to 0.
2. Item correctly shows “Out of Stock” on the product page.
3. Item correctly shows “Out of Stock” on the Woocommerce -> Products page.

Don’t know if it was the bulk edit or the upgrade to Woocommerce 3.5.5 that fixed it, but it seems to be working now.

If I had to wager, I’d guess that it was the bulk edit that solved the problem.

All good now. Thanks for the help.
- This reply was modified 6 years ago by essmeier.
Plugin Support Grigorij S. a11n
(@grigaswp)

6 years ago

Hi there,

I’m glad to hear that product stock level statuses are correct now! You’re right, re-saving the products probably did the trick.

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

The topic ‘Backorders issue’ is closed to new replies.

Tags