jedfirestone

Ran into this same error this morning. Contacted support and quickly solved the issue. Figured it would be helpful to give an update here just in case anyone else runs into it.

Check your add-ons you are using with Tickera (i.e. bridge, forms, check in notifications etc). one of them is likely the culprit here. Bridge was my issue. I had 1.5.7 installed, but 1.5.9 was current.

Apparently the main Tickera add-on autoupdates to the newest version. NONE of the add-ons do this. You have to manually download them from your Tickera account and upload them to update. 4 of mine were old versions and I had no idea until this error.

I’ll make it a habit to check them regularly. You should too. ??

We couldn’t find that pattern. Some browsers would pass the zip code from the Woocommerce billing address to the hidden postal code field, some wouldn’t. Everyone we asked seemed to have a different system and browser. lol

Unhiding the postal code and forcing people to manually enter it fixed it.

Did you change both CSS files? And is it the zip code field you’re missing?

Try a second browser in the event you didn’t clear your cache. If you want to send me a link to your site I can see if it’s the same problem I had. It could be different.

I don’t know if you can private message but you can do that if you’d like.

Glad it helped!

It’s NOT Square that’s to blame. This is WooCommerce’s plugin. They need to implement the fix.

You may have to make it when you update again next time.

I fixed this yesterday. i am using version 2.0.4

https://www.ads-software.com/support/topic/invalid-zip-code-2/#post-11952907

• This reply was modified 5 years, 2 months ago by jedfirestone.

Same issue with us! It’s one of the last few updates, but this fix I mention fixed it. It appeared to be certain zip codes, but in the end it was that certain system display the Zip input and certain don’t!

Make this change and force the reload and you’ll be a good to go.

sdrake – I have no issue typing in your credit card box, but the Postal code field is hidden on your form and you will not be able to process transactions. I just wrote a post explaining how to fix it.

Thanks for all the suggestions!

I guess we will have to test this slowly and see what happens. Sadly (not really but sort of) it doesn’t happen with every order, just appears to be totally random, I’d have to somehow be able to process 30-100 orders and even then I may never see the problem.

We need Square for charges, and there is no way to check that without money exchange – but since we don’t use it for inventory, I’ll make sure that there is no inventory exchange with Square – like you said, maybe that’s where it’s getting goofed up.

I’ll look into that Autocomplete orders thing first. I guess it means more work for me, but then maybe it will let me see exactly when the stock count goes wacky.

Thanks again!

Thanks again for your help! Here is that report.

————–

### WordPress Environment ###

Home URL: https://gograpevinetickets.com
Site URL: https://gograpevinetickets.com
WC Version: 3.5.3
Log Directory Writable: ?
WP Version: ? 4.9.9 - There is a newer version of WordPress available (5.0.3)
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.1.25 - We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version
PHP Post Max Size: 128 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.62.0
OpenSSL/1.0.2q

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.2.21-MariaDB
Max Upload Size: 128 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.5.3
WC Database Prefix: wp_
Total Database Size: 74.78MB
Database Data Size: 44.24MB
Database Index Size: 30.54MB
wp_woocommerce_sessions: Data: 0.23MB + Index: 0.02MB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.05MB
wp_woocommerce_order_items: Data: 0.34MB + Index: 0.13MB
wp_woocommerce_order_itemmeta: Data: 11.52MB + Index: 3.03MB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB
wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB
simpletix_button: Data: 0.01MB + Index: 0.00MB
simpletix_event: Data: 0.00MB + Index: 0.00MB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB
wp_comments: Data: 2.52MB + Index: 1.23MB
wp_events_answer: Data: 0.00MB + Index: 0.00MB
wp_events_attendee: Data: 0.00MB + Index: 0.00MB
wp_events_attendee_meta: Data: 0.00MB + Index: 0.00MB
wp_events_category_detail: Data: 0.00MB + Index: 0.00MB
wp_events_category_rel: Data: 0.00MB + Index: 0.00MB
wp_events_detail: Data: 0.00MB + Index: 0.02MB
wp_events_discount_codes: Data: 0.00MB + Index: 0.00MB
wp_events_discount_rel: Data: 0.00MB + Index: 0.00MB
wp_events_email: Data: 0.00MB + Index: 0.00MB
wp_events_locale: Data: 0.00MB + Index: 0.00MB
wp_events_locale_rel: Data: 0.00MB + Index: 0.00MB
wp_events_meta: Data: 0.00MB + Index: 0.00MB
wp_events_multi_event_registration_id_group: Data: 0.00MB + Index: 0.00MB
wp_events_personnel: Data: 0.00MB + Index: 0.00MB
wp_events_personnel_rel: Data: 0.00MB + Index: 0.00MB
wp_events_prices: Data: 0.00MB + Index: 0.00MB
wp_events_qst_group: Data: 0.00MB + Index: 0.00MB
wp_events_qst_group_rel: Data: 0.00MB + Index: 0.00MB
wp_events_question: Data: 0.00MB + Index: 0.00MB
wp_events_start_end: Data: 0.00MB + Index: 0.00MB
wp_events_venue: Data: 0.00MB + Index: 0.00MB
wp_events_venue_rel: Data: 0.00MB + Index: 0.00MB
wp_gmb_maps: Data: 0.00MB + Index: 0.00MB
wp_gmb_maps_meta: Data: 0.00MB + Index: 0.00MB
wp_gmb_marker_category: Data: 0.00MB + Index: 0.00MB
wp_gmb_marker_themes: Data: 0.00MB + Index: 0.00MB
wp_gmb_plugin_settings: Data: 0.00MB + Index: 0.00MB
wp_gmp_icons: Data: 0.00MB + Index: 0.00MB
wp_gmp_maps: Data: 0.00MB + Index: 0.00MB
wp_gmp_markers: Data: 0.00MB + Index: 0.00MB
wp_gmp_marker_groups: Data: 0.00MB + Index: 0.00MB
wp_gmp_membership_presets: Data: 0.00MB + Index: 0.00MB
wp_gmp_modules: Data: 0.00MB + Index: 0.00MB
wp_gmp_modules_type: Data: 0.00MB + Index: 0.00MB
wp_gmp_options: Data: 0.00MB + Index: 0.00MB
wp_gmp_options_categories: Data: 0.00MB + Index: 0.00MB
wp_gmp_usage_stat: Data: 0.00MB + Index: 0.00MB
wp_g_circles: Data: 0.00MB + Index: 0.00MB
wp_g_maps: Data: 0.00MB + Index: 0.00MB
wp_g_markers: Data: 0.00MB + Index: 0.00MB
wp_g_polygones: Data: 0.00MB + Index: 0.00MB
wp_g_polylines: Data: 0.00MB + Index: 0.00MB
wp_huge_itslider_images: Data: 0.00MB + Index: 0.00MB
wp_huge_itslider_params: Data: 0.00MB + Index: 0.00MB
wp_huge_itslider_sliders: Data: 0.00MB + Index: 0.00MB
wp_links: Data: 0.02MB + Index: 0.02MB
wp_ms_snippets: Data: 0.00MB + Index: 0.00MB
wp_my_calendar: Data: 0.00MB + Index: 0.00MB
wp_my_calendar_categories: Data: 0.00MB + Index: 0.00MB
wp_my_calendar_events: Data: 0.00MB + Index: 0.00MB
wp_my_calendar_locations: Data: 0.00MB + Index: 0.00MB
wp_options: Data: 7.47MB + Index: 0.48MB
wp_postmeta: Data: 12.52MB + Index: 16.03MB
wp_posts: Data: 7.52MB + Index: 6.02MB
wp_pta_sus_sheets: Data: 0.00MB + Index: 0.00MB
wp_pta_sus_signups: Data: 0.00MB + Index: 0.00MB
wp_pta_sus_tasks: Data: 0.00MB + Index: 0.00MB
wp_snippets: Data: 0.01MB + Index: 0.00MB
wp_termmeta: Data: 0.02MB + Index: 0.03MB
wp_terms: Data: 0.02MB + Index: 0.03MB
wp_term_relationships: Data: 0.02MB + Index: 0.02MB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB
wp_tz_plusgallery_images: Data: 0.02MB + Index: 0.00MB
wp_tz_plusgallery_item: Data: 0.00MB + Index: 0.00MB
wp_tz_plusgallery_options: Data: 0.00MB + Index: 0.00MB
wp_tz_plusgallery_type: Data: 0.00MB + Index: 0.00MB
wp_usermeta: Data: 1.52MB + Index: 3.03MB
wp_users: Data: 0.11MB + Index: 0.08MB
wp_wc_download_log: Data: 0.00MB + Index: 0.00MB
wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB
wp_wdslayer: Data: 0.00MB + Index: 0.00MB
wp_wdsslide: Data: 0.00MB + Index: 0.00MB
wp_wdsslider: Data: 0.00MB + Index: 0.00MB
wp_wpfront_ure_login_redirect: Data: 0.00MB + Index: 0.00MB
wp_wpfront_ure_options: Data: 0.01MB + Index: 0.00MB
wp_wpgmza: Data: 0.02MB + Index: 0.00MB
wp_wpgmza_categories: Data: 0.02MB + Index: 0.00MB
wp_wpgmza_category_maps: Data: 0.02MB + Index: 0.00MB
wp_wpgmza_maps: Data: 0.02MB + Index: 0.00MB
wp_wpgmza_polygon: Data: 0.02MB + Index: 0.00MB
wp_wpgmza_polylines: Data: 0.02MB + Index: 0.00MB

### Post Type Counts ###

attachment: 111
custom_css: 2
custom-css-js: 2
customize_changeset: 47
da_image: 1
fa_gallery: 1
fagp_gallery: 2
ich_cpt: 3
jetpack_migration: 2
mc-events: 5
mt-payments: 882
nav_menu_item: 3
oembed_cache: 3
page: 25
post: 7
product: 45
revision: 515
shop_coupon: 6
shop_order: 3582
shop_order_refund: 484
tablepress_table: 1
tc_api_keys: 18
tc_events: 20
tc_form_fields: 10
tc_forms: 3
tc_seat_charts: 1
tc_templates: 26
tc_tickets: 9
tc_tickets_instances: 12283

### Security ###

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

### Active Plugins (27) ###

Tickera: by Tickera.com – 3.3.2
Tickera Bridge for WooCommerce: by Tickera – 1.1.6.3 – Not tested with the active version of WooCommerce
Tickera Check-in Notifications: by Tickera.com – 1.1.2
Code Snippets: by Shea Bunge – 2.13.0
Tickera CSV Export: by Tickera.com – 1.2.5.1
Simple Custom CSS and JS: by SilkyPress.com – 3.22
Tickera - Custom Forms Add-on: by Tickera.com – 1.2.2.6
Tickera - Custom Ticket Template Fonts: by Tickera.com – 1.0.3
Easy Google Fonts: by Titanium Themes – 1.4.3
Easy Logo: by Varun Kumar – 1.9.1
Image Caption Hover Pro: by WebCodingPlace – 18.9.5
Members: by Justin Tadlock – 2.1.0
Menu Image: by Alex Davyskiba aka Zviryatko – 2.9.1
Postcode Based Order Restriction: by PrecursorWeb – 1.0 – Not tested with the active version of WooCommerce
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.0
Tickera Seating Charts: by Tickera.com – 0.47
Twilio SMS Notifications for Tickera: by Tickera.com – 1.2.0
WooCommerce - Autocomplete Orders: by Serious Plugins – 1.1.4 – Not tested with the active version of WooCommerce
WooCommerce Checkout Manager: by Visser Labs – 4.2.5
WooCommerce Coupons By Location: by Store Apps – 1.3.0 – Not tested with the active version of WooCommerce
WooCommerce Email Validation: by Hugh Lashbrooke – 2.1.1 – Not tested with the active version of WooCommerce
WooCommerce Filter Orders by Product: by Md. Kowsar Hossain – 2.0.7 – Not tested with the active version of WooCommerce
WooCommerce Max Quantity: by Isabel Castillo – 1.5.1 – Not tested with the active version of WooCommerce
WooCommerce Menu Cart: by Jeremiah Prummer
Ewout Fernhout – 2.7.3

Advanced Order Export For WooCommerce (Pro): by AlgolPlus – 2.0.1
WooCommerce Square: by WooCommerce – 1.0.34
WooCommerce: by Automattic – 3.5.3

### 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: #142 - /index.php/get-tickets/
Cart: #3039 - /index.php/cart/
Checkout: #3040 - /index.php/checkout/
My account: #3041 - /index.php/my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: GeneratePress
Version: 2.2.1
Author URL: https://tomusborne.com
Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ?

### Templates ###

Overrides: –

——————-

I am unsure what their process is aside from users ordering through the store, or if they are creating manual orders somehow, but I asked them to see.

Also, You’ll notice Tickera in there, and since these products are tickets, I asked them first. They checked into my site and believe the issue is WooCommerce and not their plugin.

Still coming up with more orders doing this today.

Ohh, and i have HOLD STOCK set to 10 mins.

The two orders today were completed at 9:39am & 9:51am respectively. No Idea if they were overlapped in the cart.

• This reply was modified 5 years, 10 months ago by jedfirestone.

I sent it through a support ticket, thanks! I missed the support ticket spot initially. oops!

Ok… I found it again in a NEW product we just started selling. There are some quirks though…

Order A – Jan 8 12:09pm – Stock levels reduced: Saturday February 23, 2019 – 7-9pm (MS-2-23) 417→415
Order B – Jan 9 1:40pm – 100% Discount code used – Stock levels reduced: Saturday February 23, 2019 – 7-9pm (MS-2-23) 417→415
Order C – Jan 9 1:52pm – Order FAILED for 2 tickets – no stock movement shown
Order D – Jan 9 3:54pm – Stock levels reduced: Saturday February 23, 2019 – 7-9pm (MS-2-23) 417→414

3 in a row, all starting their count at 417!

A couple of other notes. WooCommerce Reports shows 110 sold. The last order shows ending quantity of 394 (which says 106 were sold).

Somethings up… but what?

Thanks so much for the reply Erica! I’ve checked two places – both in the Woocommerce Reports area and had it show me how many items were sold for just the one event. I also added a plugin called “Export Orders” where I can get a spreadsheet with all the data and that shows more sold than there should have been.

The info you asked about is from the Order Details page when I drill into the order. It’s contained on the right side of the page where the details of the transaction (changed to pending, transaction ID for money etc.) I’ve tried to find in the DB directly where this info comes from but haven’t been able to. I’d love to export it and track it to see where it happens.

We seem to have 2 different items (possibly, it’s tough to tell with the way my client keeps adjusting also). Only one payment gateway so no issues there and it doesn’t appear coupon usage directly affects it.

Incidentally, I tracked down what happened with the one I referenced above! I found the refunded transaction accidentally where stock went from 20->23! So that’s good. But, then I found two in a row that went from 480-478… And I haven’t found a refund that coincides.

Maybe you CAN help with what I suggested above? Exporting the data that tells how the stock was adjusted? Then I can follow along and maybe see exactly where it went wrong?

You could try to make a variable product with a few options, then export the item and edit it in excel to make it right, then import the product back in.

Some of those add-ons are actually REALLY worth it for the time savings.

Consider how much they are going to make off these rooms and $250 is a drop in the bucket.

Here’s what I think you are trying to do.

Create a product, make it variable.

Go to Attributes, create ROOM then options of Cabin 1 | Cabin 2 | Cabin 3 etc.

Save and then head to variations tab – add all the variations then click into each variation, click manage stock and add 1 for inventory on each one.

I’d set it up once as a template, then just duplicate it for each date.