Stock Not Reducing on Some Pre-Orders
-
Good Day Everyone,
I want to start by saying that this Plugin was a great solution for us since the WooCommerce Pre-Order Plugin only allowed you to pre-order one product at a time.
I have not had any problems until recently with this plugin. I run a Nerdy eCommerce website for Trading Card Games. We had a BIG release last weekend and we ran into a problem of product going negative after shipping.
After researching I found that about a 1/4th of my orders did not reduce the stock of the items pre-ordered until after the item was shipped. Meaning if I had 40 items in stock before the order, I still had 40 in stock after the order was paid for.
I did some more digging and found that this was only for pre-ordered items, it did not affect orders with items available the day of the order. It also affected multiple items meaning that was not a problem with only one product.
Looking for some help since I am unable to figure it out on my own.
-Tommy`
The page I need help with: [log in to see the link]
-
I have done as requested. I went back further to see when this started happening and it happened with the very first order that was placed with your plug-in on 7/28/21. Below is the text from the Notifications from that order
Order status changed from Pre Ordered to Completed.
August 20, 2021 at 2:46 pm Delete noteStock levels reduced: Pokemon TCG: Evolving Skies – Booster Box [Pre-Order] (#13911) 9→7
August 20, 2021 at 2:46 pm Delete notePokemon TCG: Evolving Skies – Booster Box [Pre-Order] x 2 shipped via USPS on August 21, 2021 with tracking number 94055##… (Removed for privacy)
August 20, 2021 at 2:46 pm Delete note
Order has been exported to Shipstation
July 28, 2021 at 9:35 pm Delete noteIPN payment completed
July 28, 2021 at 9:30 pm Delete noteIPN payment completed
July 28, 2021 at 9:30 pm Delete noteOrder status changed from Pending payment to Pre Ordered.
July 28, 2021 at 9:30 pm Delete note`The Stock level should have been reduced at the beginning, not the end when it was shipped.
After doing Further Research, I have found that the root of the problem is that while the order is in “Pre-Ordered” Status, the stock can not be updated. Below I changed one of the orders to On Hold and the Stock Level Reduced.
Order status changed from On hold to Pre Ordered.
February 14, 2022 at 12:33 pm by Tommy Delete noteOrder status changed from Pre Ordered to On hold.
February 14, 2022 at 12:32 pm by Tommy Delete noteStock levels reduced: Pokémon TCG: Brilliant Stars – Booster Box (16231-1) 0→-3
February 14, 2022 at 12:32 pm Delete noteOrder has been exported to Shipstation
February 9, 2022 at 8:32 pm Delete noteOrder status changed from Pending payment to Pre Ordered.
February 9, 2022 at 7:36 pm Delete noteIPN payment completed
February 9, 2022 at 7:36 pm Delete noteIPN payment completed
February 9, 2022 at 7:36 pm Delete noteIs there a way to allow the stock to change while in Pre-Order Status or how would you like to proceed from here? Below is an example of how a properly working Pre Order records notes.
Order status changed from Pre Ordered to Completed.
February 10, 2022 at 12:27 pm Delete noteMagic the Gathering – Kamigawa: Neon Dynasty – Set Booster Box With Buy-A-Box Promo (195166104980) x 1 shipped via USPS on February 11, 2022 with tracking number 94055###….
February 10, 2022 at 12:27 pm Delete noteOrder has been exported to Shipstation
February 10, 2022 at 10:30 am Delete noteIPN payment completed
February 10, 2022 at 9:44 am Delete noteStock levels reduced: Magic the Gathering – Kamigawa: Neon Dynasty – Set Booster Box With Buy-A-Box Promo (195166104980) 12→11
February 10, 2022 at 9:44 am Delete note
Order status changed from Pending payment to Pre Ordered.February 10, 2022 at 9:43 am Delete note
IPN payment completedI have not heard anything for you guys but here is my WooCommerce Status report if it helps
### WordPress Environment ### WordPress address (URL): https://vgmx.com Site address (URL): https://vgmx.com WC Version: 6.2.0 REST API Version: ✔ 6.2.0 WC Blocks Version: ✔ 6.7.3 Action Scheduler Version: ✔ 3.4.0 WC Admin Version: ✔ 3.1.0 Log Directory Writable: ✔ WP Version: 5.9 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ✔ Language: en_US External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 7.3.30 PHP Post Max Size: 100 MB PHP Time Limit: 300 PHP Max Input Vars: 1000 cURL Version: 7.79.1 OpenSSL/1.1.1l SUHOSIN Installed: – MySQL Version: 5.7.26-29-log Max Upload Size: 100 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 6.2.0 WC Database Prefix: wp_tx11v2d096_ Total Database Size: 192.61MB Database Data Size: 164.17MB Database Index Size: 28.44MB wp_tx11v2d096_woocommerce_sessions: Data: 29.85MB + Index: 0.90MB + Engine MyISAM wp_tx11v2d096_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_tx11v2d096_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_tx11v2d096_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_tx11v2d096_woocommerce_order_items: Data: 0.41MB + Index: 0.17MB + Engine MyISAM wp_tx11v2d096_woocommerce_order_itemmeta: Data: 2.14MB + Index: 1.51MB + Engine MyISAM wp_tx11v2d096_woocommerce_tax_rates: Data: 0.02MB + Index: 0.01MB + Engine MyISAM wp_tx11v2d096_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine MyISAM wp_tx11v2d096_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_tx11v2d096_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_tx11v2d096_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_tx11v2d096_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_tx11v2d096_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_tx11v2d096_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_tx11v2d096_actionscheduler_actions: Data: 0.28MB + Index: 0.44MB + Engine InnoDB wp_tx11v2d096_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_tx11v2d096_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_tx11v2d096_actionscheduler_logs: Data: 0.17MB + Index: 0.13MB + Engine InnoDB wp_tx11v2d096_cff_facebook_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_tx11v2d096_cff_feeds: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_tx11v2d096_cff_feed_caches: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_tx11v2d096_cff_sources: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_tx11v2d096_commentmeta: Data: 0.11MB + Index: 0.16MB + Engine InnoDB wp_tx11v2d096_comments: Data: 2.52MB + Index: 1.59MB + Engine InnoDB wp_tx11v2d096_em_bookings: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_tx11v2d096_em_events: Data: 0.02MB + Index: 0.14MB + Engine InnoDB wp_tx11v2d096_em_locations: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_tx11v2d096_em_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_tx11v2d096_em_tickets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_tx11v2d096_em_tickets_bookings: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_tx11v2d096_ewwwio_images: Data: 0.05MB + Index: 0.03MB + Engine InnoDB wp_tx11v2d096_ewwwio_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_tx11v2d096_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB wp_tx11v2d096_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB wp_tx11v2d096_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_tx11v2d096_gmp_htmltype: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_tx11v2d096_grp_google_place: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_tx11v2d096_grp_google_review: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_tx11v2d096_grp_google_stats: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_tx11v2d096_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_tx11v2d096_mec_attendees: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_mec_dates: Data: 0.08MB + Index: 0.05MB + Engine InnoDB wp_tx11v2d096_mec_events: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_tx11v2d096_mec_occurrences: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_tx11v2d096_mec_users: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_tx11v2d096_options: Data: 6.42MB + Index: 0.33MB + Engine InnoDB wp_tx11v2d096_postmeta: Data: 20.55MB + Index: 13.03MB + Engine InnoDB wp_tx11v2d096_posts: Data: 4.52MB + Index: 0.91MB + Engine InnoDB wp_tx11v2d096_shortpixel_queue: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_tx11v2d096_sib_model_contact: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_sib_model_country: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_signups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_tx11v2d096_stock_log: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_termmeta: Data: 0.04MB + Index: 0.04MB + Engine MyISAM wp_tx11v2d096_terms: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wp_tx11v2d096_term_relationships: Data: 0.17MB + Index: 0.16MB + Engine InnoDB wp_tx11v2d096_term_taxonomy: Data: 0.08MB + Index: 0.06MB + Engine InnoDB wp_tx11v2d096_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_tx11v2d096_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_tx11v2d096_UPCP_Catalogues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_UPCP_Catalogue_Items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_UPCP_Categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_UPCP_Custom_Fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_UPCP_Fields_Meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_UPCP_Items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_UPCP_Item_Images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_UPCP_SubCategories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_UPCP_Tagged_Items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_UPCP_Tags: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_UPCP_Tag_Groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_UPCP_Videos: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_usermeta: Data: 2.52MB + Index: 4.03MB + Engine InnoDB wp_tx11v2d096_users: Data: 0.14MB + Index: 0.14MB + Engine InnoDB wp_tx11v2d096_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_wcsc_error_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_tx11v2d096_wcsc_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_tx11v2d096_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_tx11v2d096_wc_category_lookup: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_wc_customer_lookup: Data: 0.16MB + Index: 0.13MB + Engine InnoDB wp_tx11v2d096_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_tx11v2d096_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_tx11v2d096_wc_order_product_lookup: Data: 0.23MB + Index: 0.31MB + Engine InnoDB wp_tx11v2d096_wc_order_stats: Data: 0.19MB + Index: 0.22MB + Engine InnoDB wp_tx11v2d096_wc_order_tax_lookup: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wp_tx11v2d096_wc_product_meta_lookup: Data: 0.11MB + Index: 0.19MB + Engine InnoDB wp_tx11v2d096_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_tx11v2d096_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_tx11v2d096_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_tx11v2d096_wpml_mails: Data: 86.52MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_wpr_rucss_resources: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_tx11v2d096_wpr_rucss_used_css: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_tx11v2d096_wt_iew_action_history: Data: 0.08MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_wt_iew_cron: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_wt_iew_ftp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_yoast_indexable: Data: 4.48MB + Index: 1.36MB + Engine InnoDB wp_tx11v2d096_yoast_indexable_hierarchy: Data: 0.23MB + Index: 0.36MB + Engine InnoDB wp_tx11v2d096_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_tx11v2d096_yoast_primary_term: Data: 0.05MB + Index: 0.03MB + Engine InnoDB wp_tx11v2d096_yoast_prominent_words: Data: 0.20MB + Index: 0.25MB + Engine InnoDB wp_tx11v2d096_yoast_seo_links: Data: 0.39MB + Index: 0.27MB + Engine InnoDB wp_tx11v2d096_yoast_seo_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tx11v2d096_zp_locations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ### Post Type Counts ### attachment: 2569 bp-email: 15 cybrchmpsthmoption: 16 elementor_library: 19 event: 1 grw_feed: 3 jetpack_migration: 2 jp_img_sitemap: 6 jp_img_sitemap_index: 3 jp_sitemap: 3 jp_sitemap_master: 3 jp_vid_sitemap: 3 location: 1 mec_calendars: 6 mec-events: 2 mep_events: 20 ml-slide: 3 ml-slider: 1 nav_menu_item: 30 oembed_cache: 6 option-tree: 1 page: 10 post: 3 product: 674 product_variation: 224 revision: 318 shop_coupon: 1 shop_order: 1901 shop_order_refund: 54 wafs: 1 wcpcsu-custom-post: 1 x-portfolio: 17 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (40) ### Advanced Cron Manager: by BracketSpace – 2.4.2 FiboSearch - AJAX Search for WooCommerce: by FiboSearch Team – 1.16.0 Smash Balloon Custom Facebook Feed: by Smash Balloon – 4.1.1 Elementor Pro: by Elementor.com – 3.6.2 Elementor: by Elementor.com – 3.5.5 Facebook for WooCommerce: by Facebook – 2.6.9 Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.3.4 Insert Headers and Footers: by WPBeginner – 1.6.0 Jetpack: by Automattic – 10.6 Google Ads & Marketing by Kliken: by Kliken – 1.0.8 Login or Logout Menu Item: by cartpauj – 1.2.1 Event Manager and Tickets Selling Plugin for WooCommerce: by MagePeople Team – 3.5.7 Order / Coupon / Subscription Export Import Plugin for WooCommerce (BASIC): by WebToffee – 2.1.9 Preorders for WooCommerce: by Bright Plugins – 1.2.5 BizPrint Print Manager for WooCommerce: by BizSwoop a CPF Concepts LLC Brand – 4.1.20 Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5 Search Engine Visibility: by GoDaddy – 0.5 SiteOrigin Widgets Bundle: by SiteOrigin – 1.30.0 Sucuri Security - Auditing, Malware Scanner and Hardening: by Sucuri Inc. – 1.8.30 Ultimate Product Catalog: by Etoile Web Design – 5.1.0 CTX Feed: by WebAppick – 4.4.49 WebP Converter for Media: by Mateusz Gbiorczyk – 4.2.0 Widget for Google Reviews: by RichPlugins – 2.1.2 Prevent Customers To Cancel WooCommerce Orders: by Tyche Softwares – 1.2 WooCommerce Product Carousel, Slider and Grid Ultimate: by wpWax – 1.8.6 WooCommerce Advanced Free Shipping: by Jeroen Sormani – 1.1.4 WooCommerce Cart Stock Reducer: by James Golovich – 3.85 WooCommerce Max Quantity: by Isabel Castillo – 1.5.2 WooCommerce PayPal Payments: by WooCommerce – 1.6.5 Sendinblue - WooCommerce Email Marketing: by Sendinblue – 2.0.34 WooCommerce Shipping & Tax: by WooCommerce – 1.25.23 WooCommerce - ShipStation Integration: by WooCommerce – 4.1.48 Stock Manager for WooCommerce: by StoreApps – 2.8.3 WooCommerce: by Automattic – 6.2.0 Yoast SEO: by Team Yoast – 18.1 WP-Cron Status Checker: by Webhead LLC – 1.2.2 WP Crontrol: by John Blackbourn & crontributors – 1.12.0 WP Mail Logging: by Wysija – 1.10.4 WP Rocket: by WP Media – 3.10.7 Smart Image Resize PRO: by Nabil Lemsieh – 1.7.5.4 ### Inactive Plugins (7) ### Advance Ecommerce Tracking: by theDotstore – 3.6.2 Modern Events Calendar Lite: by Webnus – 6.3.0 Query Monitor: by John Blackbourn – 3.8.2 Regenerate Thumbnails Advanced: by ShortPixel – 2.4.0 Smart Image Resize for WooCommerce: by Nabil Lemsieh – 1.7.5.3 WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.1.3 WP-Optimize - Clean, Compress, Cache: by David Anderson Ruhani Rabin Team Updraft – 3.2.2 ### Dropin Plugins (2) ### advanced-cache.php: advanced-cache.php object-cache.php: APCu Object Cache ### Must Use Plugins (1) ### System Plugin: by – 4.21.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) Connected to WooCommerce.com: ✔ ### WC Pages ### Shop base: #6997 - /shop/ Cart: #6998 - /cart/ Checkout: #6999 - /checkout/ My account: #7000 - /my-account/ Terms and conditions: #11846 - /return-and-pre-order-policy/ ### Theme ### Name: Astra Child Version: 1.0.0 Author URL: https://vgmx.com Child Theme: ✔ Parent Theme Name: Astra Parent Theme Version: 3.7.7 Parent Theme Author URL: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_theme WooCommerce Support: ✔ ### Templates ### Overrides: – ### WooCommerce PayPal Payments ### Onboarded: ✔ Shop country code: US WooCommerce currency supported: ✔ PayPal card processing available in country: ✔ Pay Later messaging available in country: ✔ Webhook status: ✔ Vault enabled: ✔ Logging enabled: – Reference Transactions: – Used PayPal Checkout plugin: ✔ ### Action Scheduler ### Complete: 968 Oldest: 2022-01-17 10:23:51 -0500 Newest: 2022-02-15 09:21:12 -0500 Failed: 1 Oldest: 2021-05-27 15:27:09 -0400 Newest: 2021-05-27 15:27:09 -0400 Pending: 1 Oldest: 2022-02-16 09:20:52 -0500 Newest: 2022-02-16 09:20:52 -0500 ### Status report information ### Generated at: 2022-02-15 09:21:16 -05:00
- This reply was modified 2 years, 9 months ago by Jan Dembowski.
Hi Tommy,
I hope you are wellI have replied to you by email
- The topic ‘Stock Not Reducing on Some Pre-Orders’ is closed to new replies.