Sequential order numbers may create duplicate payment numbers

[hiddenpearls]

Recently we faced an issue where we had multiple sales but their order ID's was same.

[cklosowski]

@hiddenpearls Can we get a little more information as to what your settings are? Are you using sequential order numbers, the advanced sequential order numbers extension, how long passed between these two orders?

If you could supply some of the information requested in the template that would be helpful as well. Steps to reproduce, version of EDD, other extensions for EDD installed.

[hiddenpearls]

Multisite: No

-- Hosting Provider

Host: DBH: localhost

-- User Browser

Platform: Apple Browser Name: Chrome
Browser Version: 70.0.3538.77 User Agent String: Mozilla/5.0 (Macintosh; Intel Ma c OS X 10_14_0) AppleWebKit/537. 36 (KHTML, like Gecko) Chrome/70 .0.3538.77 Safari/537.36

-- WordPress Configuration

Version: 4.9.8 Language: en_US Permalink Structure: /%postname%/ Active Theme: theme 1.0.1 Show On Front: page Page On Front: Home (#72) Page For Posts: Blog (#146)

Remote Post: wp_remote_post() works Table Prefix: Length: 10 Status: Acceptable WP_DEBUG: Disabled Memory Limit: 40M Registered Post Stati: publish, future, draft, pending, private, trash, auto-draft, inherit, request-pending, request-confirmed, request-failed, request-completed, refunded, failed, revoked, abandoned, processing, active, inactive, acf-disabled, nc_pending, nc_improvable, nc_complete, nc_broken, nc_check, cancelled, edd_subscription, preapproval

-- EDD Configuration

Version: 2.9.8 Upgraded From: 2.4.3 Test Mode: Disabled AJAX: Enabled Guest Checkout: Enabled Symlinks: Disabled Download Method: Redirect Currency Code: USD Currency Position: before Decimal Separator: . Thousands Separator: , Upgrades Completed: upgrade_customer_payments_association,upgrade_payment_taxes,sl_add_bundle_licenses,upgrade_user_api_keys,remove_refunded_sale_logs,sl_deprecate_site_count_meta,stripe_customer_id_migration,reviews_upgrade_20_database,reviews_upgrade_21_database,upgrade_mailchimp_api3,upgrade_mailchimp_api3_default_list,upgrade_24_subscriptions,fix_24_stripe_customers,recurring_27_subscription_meta,recurring_paypalproexpress_logs,eddmc_304_interests_fix,migrate_licenses,migrate_license_parent_child,migrate_license_logs,remove_legacy_licenses,update_file_download_log_data Download Link Expiration: 24 hour(s)

-- EDD Page Configuration

Checkout: Valid Downloads Slug: /downloads

-- EDD Gateway Configuration

Enabled Gateways: PayPal Standard, Stripe Default Gateway: PayPal Standard

-- EDD Tax Configuration

Taxes: Disabled Tax Rate: 0 Display On Checkout: Not Displayed Prices Include Tax: No

-- Must-Use Plugins

WP Migrate DB Pro Compatibility: 1.1

-- WordPress Active Plugins

Accelerated Mobile Pages: 0.9.97.19 Advanced Custom Fields PRO: 5.7.7 AffiliateWP: 2.2.11 AffiliateWP - Affiliate Dashboard Sharing: 1.0.1 AffiliateWP - PayPal Payouts: 1.1.11 AffiliateWP Mailchimp Add-on: 1.1.0 (needs update - 1.2.0) Akismet Anti-Spam: 4.0.8 Analytify - Google Analytics Dashboard: 2.2.1 Analytify - Gooogle Analytics Dashboard widget: 1.1.0 Analytify Email Notifications: 1.2.2 Analytify for Easy Digital Downloads: 1.0.0 Analytify Pro: 2.0.18 Category Order and Taxonomy Terms Order: 1.5.5 Connects - Mailchimp Addon: 2.2.1 Contact Form 7: 5.0.4 (needs update - 5.0.5) Convert Plus: 3.3.5 (needs update - 3.3.6) Duplicator: 1.2.52 Easy Digital Downloads: 2.9.8 Easy Digital Downloads - Amazon S3: 2.3.5 Easy Digital Downloads - Auto Register: 1.3.10 Easy Digital Downloads - Campaign Tracker: 1.0.0 Easy Digital Downloads - Discount Code Generator: 1.1 Easy Digital Downloads - Email Reports: 1.0.4 Easy Digital Downloads - Email Templates: 1.0.5 Easy Digital Downloads - Free Downloads: 2.3.4 Easy Digital Downloads - MailChimp: 3.0.11 Easy Digital Downloads - Manual Purchases: 2.0.5 Easy Digital Downloads - PDF Invoices: 2.2.23 Easy Digital Downloads - Per Product Emails: 1.1.5 Easy Digital Downloads - Recurring Payments: 2.7.28 Easy Digital Downloads - Reviews: 2.1.9 Easy Digital Downloads - Software Licensing: 3.6.5 Easy Digital Downloads - Stripe Payment Gateway: 2.6.16 Easy Digital Downloads - User History: 1.6.0 EDD Metrics: 0.7 Facebook Secret Meta Pro: 1.0.0 GIF Animation Preview: 1.10.3 Gravity Forms: 2.3.6 Head, Footer and Post Injections: 3.1.2 Jilt for Easy Digital Downloads: 1.4.3 MailChimp: 1.5.7 Nelio Content: 1.6.0 New Relic Reporting for WordPress: 1.3 Nginx Helper: 1.9.12 No Self Pings: 1.1.2 Peter's Login Redirect: 2.9.1 PixelYourSite: 5.3.2 Plugin Reviews: 0.4.0 PMS - Analytify: 0.2 Pretty Links Marketer Edition: 2.1.7 Simple Social Buttons: 2.0.20 Simple Social Buttons Pro: 1.0.5 SparkPost: 3.2.0 Twitter Cards Meta: 2.9.0 Twitter Cards Meta - Summary Card with Large Image: 1.0.2 Uber reCaptcha: 1.1.0 Username Changer: 3.1.3 User Switching: 1.4.0 WordPress Backup & Security Plugin - BlogVault: 1.76 (needs update - 1.78) WP-PostViews: 1.75 WP GDPR Compliance: 1.4.2 WP Menu Cart: 2.7.2 WP Migrate DB Pro: 1.8.6 WP Migrate DB Pro Media Files: 1.4.10 WP phpMyAdmin: 1.65 WP Rocket | EDD Cookie Cache: Yoast SEO: 9.0.2 (needs update - 9.0.3)

-- WordPress Inactive Plugins

AffiliateWP - Pushover Notifications: 1.0.1 Autoptimize: 2.4.1 Contact Form Builder for WordPress – Conversion Tools by HubSpot: 7.0.1 Crisp: 0.23 Easy Digital Downloads - Downloads As Services: 1.0.6 Easy Digital Downloads - Purchase Limit: 1.2.19 EDD Google Analytics Universal Ecommerce: 1.2 Google XML Sitemaps: 4.0.9 Screets Chat X: 2.2.8 Transients Manager: 1.7.5 W3 Total Cache: 0.9.7 WPfomify: 2.0-beta.1 WP Rocket: 3.1.4

-- Webserver Configuration

PHP Version: 7.0.30-1+ubuntu14.04.1+deb.sury.org+1 MySQL Version: 5.5.5 Webserver Info: nginx/1.14.0

-- PHP Configuration

Memory Limit: 256M Upload Max Size: 100M Post Max Size: 100M Upload Max Filesize: 100M Time Limit: 300 Max Input Vars: 1000 Display Errors: N/A PHP Arg Separator: &

-- PHP Extensions

cURL: Supported fsockopen: Supported SOAP Client: Installed Suhosin: Not Installed

-- Session Configuration

EDD Use Sessions: Enabled Session: Disabled

-- Jilt Abandoned Cart Recovery

Plugin Version: 1.4.3 Jilt API Version: v2 Jilt API Authentication Method: OAuth Jilt API Connected: Yes Linked to Jilt: Yes Enabled: Yes EDD API Available: Yes

[hiddenpearls]

@cklosowski Orders were instant, the difference could be in seconds or may be not.

Yes, I am using sequential order numbers.

[mihaijoldis]

I am posting here instead of opening a new one as I have a support ticket with the same issue. Perhaps we can change the issue title tho.

Sequential Order numbers is enabled in the admin and the Payment History page shows 2 purchases with the same ID 51680 https://share.getcloudapp.com/X6ulYAnm

Both orders are legit and for different customers but they have both been recorded at the same time in EDD https://share.getcloudapp.com/xQu697oO

I installed debug bar and I am looking at the "date" property for EDD_Payment:

string(19) "2021-05-24 00:33:15"
string(19) "2021-05-24 00:33:15" 

[ashleyfae]

This will be a tough one to solve. D: