Support » Plugin: Sequential Order Number for WooCommerce » Order Number issue with Amazon Pay

  • Resolved ansondavis

    (@ansondavis)


    Hi,

    We are using this plugin for woocommerce orders and we notice the order number being exported to Amazon Pay is not correct. Noticed currently WooCommerce order post id is passing to amazon.

    How we can match the WooCommerce order sequential number amazon pay seller or id same. I have attached a screenshot for reference.
    https://prnt.sc/1re3g5w
    https://prnt.sc/1re3ka3

Viewing 14 replies - 1 through 14 (of 14 total)
  • Hi Ansondavis,

    I have exactly the same issue. This issue came to life when we updated the plugin to use the Apazon Pay v2 API. We where up to that point still using the v1 API.
    We didn’t actually update the either plugin, we just updated the configuration of the Amazon Pay plugin. So I believe this would be more of an issue with the Apazon Pay plugin than it is with Sequential Order Number for WooCommerce.

    Plugin Author webtoffee

    (@webtoffee)

    Hi @ansondavis @jurgen-oldenburg

    Thanks for reaching out.

    Kindly copy and paste the WooCommerce System report from WooCommerce > Status for a better understanding.

    Thread Starter ansondavis

    (@ansondavis)

    Hi @webtoffee, Please check the woocommerce status below.

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://apachepowerboats.com
    Site address (URL): https://apachepowerboats.com
    WC Version: 5.6.0
    REST API Version: ✔ 5.6.0
    WC Blocks Version: ✔ 5.5.1
    Action Scheduler Version: ✔ 3.2.1
    WC Admin Version: ✔ 2.5.1
    Log Directory Writable: ✔
    WP Version: 5.8.1
    WP Multisite: –
    WP Memory Limit: 768 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.4.23
    PHP Post Max Size: 256 MB
    PHP Time Limit: 0
    PHP Max Input Vars: 3000
    cURL Version: 7.66.0
    OpenSSL/1.1.1l-fips
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.32-35-log
    Max Upload Size: 256 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 5.6.0
    WC Database Prefix: wp
    Total Database Size: 479.81MB
    Database Data Size: 329.67MB
    Database Index Size: 150.14MB
    wpwoocommerce_sessions: Data: 3.58MB + Index: 0.12MB + Engine MyISAM
    wpwoocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpwoocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpwoocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpwoocommerce_order_items: Data: 0.89MB + Index: 0.44MB + Engine MyISAM
    wpwoocommerce_order_itemmeta: Data: 5.25MB + Index: 4.02MB + Engine MyISAM
    wpwoocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpwoocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpwoocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpwoocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpwoocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpwoocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpwoocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpwoocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpa3_exclude_email_subject: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpactionscheduler_actions: Data: 8.09MB + Index: 3.08MB + Engine InnoDB
    wpactionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpactionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpactionscheduler_logs: Data: 3.08MB + Index: 3.08MB + Engine InnoDB
    wpac_abandoned_cart_history_lite: Data: 4.55MB + Index: 0.12MB + Engine MyISAM
    wpac_email_templates_lite: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wpac_guest_abandoned_cart_history_lite: Data: 0.04MB + Index: 0.01MB + Engine MyISAM
    wpac_sent_history_lite: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
    wpaiowps_events: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpaiowps_failed_logins: Data: 0.19MB + Index: 0.08MB + Engine MyISAM
    wpaiowps_global_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpaiowps_login_activity: Data: 0.16MB + Index: 0.04MB + Engine MyISAM
    wpaiowps_login_lockdown: Data: 0.40MB + Index: 0.10MB + Engine MyISAM
    wpaiowps_permanent_block: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpamwscp_amazon_accounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpamwscp_amazon_feeds: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpamwscp_amazon_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpamwscp_feeds: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpamwscp_feed_product_record: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpamwscp_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpamwscp_template_values: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpatum_export_templates: Data: 0.17MB + Index: 0.03MB + Engine InnoDB
    wpatum_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpatum_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpatum_product_data: Data: 0.22MB + Index: 0.19MB + Engine InnoDB
    wpbv_activities_store: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpbv_dynamic_sync: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpbv_fw_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpbv_ip_store: Data: 0.19MB + Index: 0.17MB + Engine InnoDB
    wpbv_lp_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpcommentmeta: Data: 0.14MB + Index: 0.16MB + Engine InnoDB
    wpcomments: Data: 6.52MB + Index: 9.09MB + Engine InnoDB
    wpes_deliverreport: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpes_emaillist: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpes_notification: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpes_pluginconfig: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpes_sentdetails: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpes_templatetable: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpEWD_OTP_Customers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpEWD_OTP_Custom_Fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpEWD_OTP_Fields_Meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpEWD_OTP_Orders: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpEWD_OTP_Order_Statuses: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpEWD_OTP_Sales_Reps: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpewwwio_images: Data: 3.52MB + Index: 5.03MB + Engine InnoDB
    wpewwwio_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpfusion_forms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpfusion_form_entries: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpfusion_form_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpfusion_form_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpgf_addon_feed: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpgf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpgf_entry: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpgf_entry_meta: Data: 0.11MB + Index: 0.05MB + Engine InnoDB
    wpgf_entry_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpgf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpgf_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpgf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpgf_form_view: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wpgf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wplayerslider: Data: 0.05MB + Index: 0.00MB + Engine MyISAM
    wplayerslider_revisions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wplinks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpmailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpmailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpmediafromftp_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpoptions: Data: 40.44MB + Index: 1.14MB + Engine InnoDB
    wppmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppmxi_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppmxi_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppostmeta: Data: 60.58MB + Index: 37.13MB + Engine InnoDB
    wpposts: Data: 13.52MB + Index: 3.64MB + Engine InnoDB
    wprg_icontact: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpsbi_instagram_feeds_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsbi_instagram_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsbi_instagram_posts: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wpsmush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsr_woo_order_items: Data: 2.48MB + Index: 0.41MB + Engine InnoDB
    wpstatistics_exclusions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpstatistics_historical: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpstatistics_pages: Data: 9.52MB + Index: 38.78MB + Engine InnoDB
    wpstatistics_search: Data: 1.52MB + Index: 0.70MB + Engine InnoDB
    wpstatistics_useronline: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpstatistics_visit: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    wpstatistics_visitor: Data: 17.52MB + Index: 30.66MB + Engine InnoDB
    wptaxjar_record_queue: Data: 1.52MB + Index: 0.25MB + Engine InnoDB
    wptermmeta: Data: 0.08MB + Index: 0.03MB + Engine MyISAM
    wpterms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wpterm_relationships: Data: 0.16MB + Index: 0.14MB + Engine InnoDB
    wpterm_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wpUPCP_Catalogues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpUPCP_Catalogue_Items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpUPCP_Categories: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpUPCP_Custom_Fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpUPCP_Fields_Meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpUPCP_Items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpUPCP_Item_Images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpUPCP_SubCategories: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpUPCP_Tagged_Items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpUPCP_Tags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpUPCP_Tag_Groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpUPCP_Videos: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpusermeta: Data: 7.52MB + Index: 4.98MB + Engine InnoDB
    wpusers: Data: 0.14MB + Index: 0.14MB + Engine InnoDB
    wpwc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wpwc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpwc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpwc_customer_lookup: Data: 0.28MB + Index: 0.25MB + Engine InnoDB
    wpwc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpwc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpwc_order_product_lookup: Data: 1.52MB + Index: 0.92MB + Engine InnoDB
    wpwc_order_stats: Data: 0.36MB + Index: 0.38MB + Engine InnoDB
    wpwc_order_tax_lookup: Data: 0.09MB + Index: 0.13MB + Engine InnoDB
    wpwc_product_meta_lookup: Data: 0.19MB + Index: 0.47MB + Engine InnoDB
    wpwc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpwc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpwc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpwfBlockedIPLog: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wpwfBlocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpwfConfig: Data: 3.02MB + Index: 0.00MB + Engine InnoDB
    wpwfCrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpwfFileChanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpwfFileMods: Data: 8.52MB + Index: 0.00MB + Engine InnoDB
    wpwfHits: Data: 2.02MB + Index: 0.36MB + Engine InnoDB
    wpwfHoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpwfIssues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpwfKnownFileList: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
    wpwfLiveTrafficHuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpwfLocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpwfLogins: Data: 0.44MB + Index: 0.16MB + Engine InnoDB
    wpwfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpwfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpwfNotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpwfPendingIssues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpwfpklist_template_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpwfReverseCache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpwfSNIPCache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpwfStatus: Data: 0.19MB + Index: 0.13MB + Engine InnoDB
    wpwfTrafficRates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpwoocommerce_amazon_buyer_index: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpwoocommerce_shipping_zone_shipping_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpwoo_sr_cart_items: Data: 0.71MB + Index: 0.62MB + Engine MyISAM
    wpwoo_sr_orders: Data: 0.43MB + Index: 0.19MB + Engine MyISAM
    wpwoo_sr_order_items: Data: 0.58MB + Index: 0.46MB + Engine MyISAM
    wpwpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpwpgmza: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpwpgmza_circles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpwpgmza_maps: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpwpgmza_polygon: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpwpgmza_polylines: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpwpgmza_rectangles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpwpml_mails: Data: 109.52MB + Index: 0.00MB + Engine InnoDB
    wpwpr_rucss_resources: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpwpr_rucss_used_css: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpwt_iew_action_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpwt_iew_cron: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpwt_iew_ftp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpwt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpyoast_indexable: Data: 3.52MB + Index: 0.78MB + Engine InnoDB
    wpyoast_indexable_hierarchy: Data: 0.09MB + Index: 0.14MB + Engine InnoDB
    wpyoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpyoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpyoast_seo_links: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
    wpyoast_seo_meta: Data: 0.36MB + Index: 0.00MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    amn_exact-metrics: 1
    attachment: 1531
    atum_supplier: 2
    custom_css: 1
    et_pb_layout: 36
    fusion_element: 2
    fusion_template: 8
    nav_menu_item: 16
    oembed_cache: 5
    page: 48
    paypal_transaction: 1574
    post: 19
    postman_sent_mail: 250
    product: 100
    product_variation: 1315
    revision: 38
    shop_coupon: 4534
    shop_order: 3640
    shop_order_refund: 63
    slide: 20
    spucpt: 1
    testimonial: 22
    testimonial_rotator: 2
    woo_discount: 4
    woo_discount_cart: 1
    wp_email_images: 1
    yith-wcet-etemplate: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (62) ###
    
    ManageWP - Worker: by GoDaddy – 4.9.10
    Gravity Forms: by Gravity Forms – 2.5.10
    Add Admin CSS: by Scott Reilly – 2.0.1
    WooCommerce added to cart popup (Ajax): by XootiX – 1.5
    ATUM Inventory Management for WooCommerce: by Stock Management Labs™ – 1.9.3
    WordPress Backup & Security Plugin - BlogVault: by Backup by BlogVault – 4.64
    Change Quantity on Checkout for WooCommerce: by Bhavik Kiri – 2.0
    CheckoutWC: by Objectiv – 5.3.6
    Contact Form 7: by Takayuki Miyoshi – 5.4.2
    WooCommerce Continue Shopping: by HappyKite – 1.4.3
    Disable Admin Notices Individually: by Creative Motion  – 1.2.6
    Disable Comments: by WPDeveloper – 2.1.2
    Disable Gutenberg: by Jeff Starr – 2.5.1
    Disable Lazy Load: by Jeff Starr – 1.4
    Duplicate Page: by mndpsingh287 – 4.4.3
    Email SItem: by Dmwds – 1.0
    Avada Builder: by ThemeFusion – 3.4.1
    Avada Core: by ThemeFusion – 5.4.1
    Google Analytics Dashboard for WP (GADWP): by ExactMetrics – 7.0.0
    Google Language Translator: by Translate AI Multilingual Solutions – 6.0.11
    Smash Balloon Instagram Feed: by Smash Balloon – 2.9.3.1
    Jetpack: by Automattic – 10.1
    MainWP Child: by MainWP – 4.1.7
    Media from FTP: by Katsushi Kawamori – 11.14
    No Right Click Images Plugin: by Keith P. Graham – 3.6
    Order / Coupon / Subscription Export Import Plugin for WooCommerce (BASIC): by WebToffee – 2.1.0
    PayPal for WooCommerce: by Angell EYE – 2.1.16
    WooCommerce PDF Invoices, Packing Slips, Delivery Notes & Shipping Labels: by WebToffee – 2.8.3
    Product/Review CSV Import Export: by WebToffee – 3.8.1
    PRyC WP/WooCommerce: Edit all orders: by PRyC – 1.0.11
    Really Simple SSL: by Really Simple Plugins – 5.1.0
    Redirect 404 Error Page to Homepage: by ProThoughts – 1.1
    Smart Reporter For E-commerce: by StoreApps – 2.10.0
    String Locator: by Clorith – 2.4.2
    Testimonial Rotator: by Hal Gatewood – 3.0.3
    User Switching: by John Blackbourn & contributors – 1.5.7
    ELEX Stamps.com WooCommerce Extension (USPS): by ELEX – 2.3.5
    Woo Discount Rules: by Flycart – 2.3.8
    Abandoned Cart Lite for WooCommerce: by Tyche Softwares – 5.10.0
    WooCommerce Accepted Payment Methods: by jameskoster – 0.7.0
    WooCommerce Conversion Tracking: by weDevs – 2.0.8
    Print Invoice & Delivery Notes for WooCommerce: by Tyche Softwares – 4.6.4
    WooCommerce Email Customizer: by cxThemes – 3.33
    WooCommerce Extra Product Sorting Options: by SkyVerge – 2.9.0
    WooCommerce Amazon Pay: by WooCommerce – 2.0.3
    WooCommerce Google Analytics Integration: by WooCommerce – 1.5.2
    WooCommerce Print Invoices/Packing Lists: by SkyVerge – 3.11.3
    WooCommerce Shipping & Tax: by WooCommerce – 1.25.18
    WP Woocommerce to Google merchant center: by asaquzzaman – 1.9.0
    Woocommerce Ultimate Reports: by Deepak Shah – 2.8
    WooCommerce: by Automattic – 5.6.0
    Wordfence Security: by Wordfence – 7.5.5
    Yoast SEO: by Team Yoast – 17.1
    WP Crontrol: by John Blackbourn & crontributors – 1.10.0
    WP File Manager: by mndpsingh287 – 7.1.2
    WP Google Maps: by WP Google Maps – 8.1.15
    WP Mail Logging: by Wysija – 1.9.8
    WP Rocket: by WP Media – 3.9.3
    WP Rollback: by Impress.org – 1.7.1
    Smart Coupons for WooCommerce: by WebToffee – 1.3.3
    Sequential Order Numbers for WooCommerce: by WebToffee – 1.3.8
    YITH Infinite Scrolling: by YITH – 1.5.2
    
    ### Inactive Plugins (1) ###
    
    USPS WooCommerce Shipping: by WooForce – 3.0.2
    
    ### Dropin Plugins (1) ###
    
    advanced-cache.php: advanced-cache.php
    
    ### Must Use Plugins (1) ###
    
    ManageWP - Worker Loader: by GoDaddy –
    
    ### 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)
    visible (visible)
    
    Connected to WooCommerce.com: ✔
    
    ### WC Pages ###
    
    Shop base: #226 - /shop/
    Cart: #227 - /cart/
    Checkout: #228 - /checkout/
    My account: #229 - /my-account-3/
    Terms and conditions: ❌ Page not set
    
    ### Theme ###
    
    Name: APB Child
    Version: 1.0
    Author URL: https://apachepowerboats.com
    Child Theme: ✔
    Parent Theme Name: Avada
    Parent Theme Version: 7.4.1
    Parent Theme Author URL: https://themeforest.net/user/ThemeFusion
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: Avada/woocommerce/cart/cart.php
    APB-Child/woocommerce/checkout/form-checkout.php
    Avada/woocommerce/checkout/form-pay.php
    Avada/woocommerce/checkout/review-order.php
    Avada/woocommerce/checkout/thankyou.php
    /home/customer/www/apachepowerboats.com/public_html/wp-content/plugins/woocommerce-email-control/templates/emails/supreme/admin-cancelled-order.php version 3.7.0 is out of date. The core version is 4.1.0
    /home/customer/www/apachepowerboats.com/public_html/wp-content/plugins/woocommerce-email-control/templates/emails/supreme/admin-failed-order.php
    APB-Child/woocommerce/emails/supreme/admin-new-order.php
    /home/customer/www/apachepowerboats.com/public_html/wp-content/plugins/woocommerce-email-control/templates/emails/supreme/customer-completed-order.php
    /home/customer/www/apachepowerboats.com/public_html/wp-content/plugins/woocommerce-email-control/templates/emails/supreme/customer-invoice.php
    /home/customer/www/apachepowerboats.com/public_html/wp-content/plugins/woocommerce-email-control/templates/emails/supreme/customer-new-account.php
    /home/customer/www/apachepowerboats.com/public_html/wp-content/plugins/woocommerce-email-control/templates/emails/supreme/customer-note.php
    /home/customer/www/apachepowerboats.com/public_html/wp-content/plugins/woocommerce-email-control/templates/emails/supreme/customer-on-hold-order.php
    /home/customer/www/apachepowerboats.com/public_html/wp-content/plugins/woocommerce-email-control/templates/emails/supreme/customer-processing-order.php
    /home/customer/www/apachepowerboats.com/public_html/wp-content/plugins/woocommerce-email-control/templates/emails/supreme/customer-refunded-order.php
    /home/customer/www/apachepowerboats.com/public_html/wp-content/plugins/woocommerce-email-control/templates/emails/supreme/customer-reset-password.php version 3.7.0 is out of date. The core version is 4.0.0
    /home/customer/www/apachepowerboats.com/public_html/wp-content/plugins/woocommerce-email-control/templates/emails/supreme/email-addresses.php version 3.5.4 is out of date. The core version is 5.6.0
    /home/customer/www/apachepowerboats.com/public_html/wp-content/plugins/woocommerce-email-control/templates/emails/supreme/email-customer-details.php
    /home/customer/www/apachepowerboats.com/public_html/wp-content/plugins/woocommerce-email-control/templates/emails/supreme/email-downloads.php
    /home/customer/www/apachepowerboats.com/public_html/wp-content/plugins/woocommerce-email-control/templates/emails/supreme/email-footer.php
    /home/customer/www/apachepowerboats.com/public_html/wp-content/plugins/woocommerce-email-control/templates/emails/supreme/email-header.php version 2.4.0 is out of date. The core version is 4.0.0
    /home/customer/www/apachepowerboats.com/public_html/wp-content/plugins/woocommerce-email-control/templates/emails/supreme/email-order-details.php
    /home/customer/www/apachepowerboats.com/public_html/wp-content/plugins/woocommerce-email-control/templates/emails/supreme/email-order-items.php
    /home/customer/www/apachepowerboats.com/public_html/wp-content/plugins/woocommerce-email-control/templates/emails/supreme/email-styles.php version 3.3.0 is out of date. The core version is 4.0.0
    Avada/woocommerce/loop/loop-start.php
    Avada/woocommerce/single-product/add-to-cart/variable.php
    Avada/woocommerce/single-product/short-description.php
    Avada/woocommerce/single-product/tabs/additional-information.php
    Avada/woocommerce/single-product/tabs/description.php
    
    Outdated Templates: ❌
    					
    					
    						Learn how to update
    
    ### Action Scheduler ###
    
    Complete: 8,931
    Oldest: 2021-08-22 18:38:14 -0400
    Newest: 2021-09-13 08:56:46 -0400
    
    Failed: 406
    Oldest: 2020-03-31 02:48:28 -0400
    Newest: 2021-07-27 13:41:54 -0400
    
    Pending: 5
    Oldest: 2021-09-13 09:11:46 -0400
    Newest: 2021-09-13 21:12:57 -0400
    
    ### Status report information ###
    
    Generated at: 2021-09-13 09:03:37 -04:00
    

    `
    WordPress environment
    WordPress address (URL): https://staging.gasfedershop.de
    Site address (URL): https://staging.gasfedershop.de
    WooCommerce version: 5.6.0
    WooCommerce REST API package: 5.6.0 /kunder/gasvee_11258/gasvee_14918/public/wp-content/plugins/woocommerce/includes
    WooCommerce Blocks package: 5.5.1 /kunder/gasvee_11258/gasvee_14918/public/wp-content/plugins/woocommerce/packages/woocommerce-blocks/
    Action Scheduler package: 3.2.1 /kunder/gasvee_11258/gasvee_14918/public/wp-content/plugins/woocommerce-product-feeds/vendor/woocommerce/action-scheduler
    WooCommerce Admin package: 2.5.1 /kunder/gasvee_11258/gasvee_14918/public/wp-content/plugins/woocommerce/packages/woocommerce-admin
    Log directory writable: /kunder/gasvee_11258/gasvee_14918/public/wp-content/uploads/sites/2/wc-logs/
    WordPress version: 5.8.1
    WordPress multisite:
    WordPress memory limit: 512 MB
    WordPress debug mode:
    WordPress cron: –
    Language: de_DE_formal
    External object cache: –
    Server environment
    Server info: Apache/2.4
    PHP version: 7.4.22
    PHP post max size: 50 MB
    PHP time limit: 120
    PHP max input vars: 1000
    cURL version: 7.29.0, NSS/3.53.1
    SUHOSIN installed: –
    MySQL version: 5.5.5-10.4.21-MariaDB-log
    Max upload size: 1 MB
    Default timezone is UTC: Default timezone is Europe/Amsterdam – it should be UTC
    fsockopen/cURL:
    SoapClient:
    DOMDocument:
    GZip:
    Multibyte string:
    Remote post:
    Remote get:
    Database
    WooCommerce database version: 5.6.0
    Database prefix wp_22_
    Total Database Size 1814.23MB
    Database Data Size 858.44MB
    Database Index Size 955.79MB
    wp_22_woocommerce_sessions Data: 28.56MB + Index: 0.52MB + Engine InnoDB
    wp_22_woocommerce_api_keys Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_22_woocommerce_attribute_taxonomies Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_22_woocommerce_downloadable_product_permissions Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_22_woocommerce_order_items Data: 20.55MB + Index: 7.52MB + Engine InnoDB
    wp_22_woocommerce_order_itemmeta Data: 135.69MB + Index: 120.30MB + Engine InnoDB
    wp_22_woocommerce_tax_rates Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_22_woocommerce_tax_rate_locations Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_22_woocommerce_shipping_zones Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_22_woocommerce_shipping_zone_locations Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_22_woocommerce_shipping_zone_methods Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_22_woocommerce_payment_tokens Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_22_woocommerce_payment_tokenmeta Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_22_woocommerce_log Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_22_actionscheduler_actions Data: 14.55MB + Index: 12.13MB + Engine InnoDB
    wp_22_actionscheduler_claims Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_22_actionscheduler_groups Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_22_actionscheduler_logs Data: 7.52MB + Index: 5.03MB + Engine InnoDB
    wp_22_commentmeta Data: 1.52MB + Index: 1.91MB + Engine InnoDB
    wp_22_comments Data: 50.58MB + Index: 42.13MB + Engine InnoDB
    wp_22_links Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_22_lockdowns Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_22_login_fails Data: 0.11MB + Index: 0.00MB + Engine InnoDB
    wp_22_mollie_pending_payment Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_22_options Data: 35.53MB + Index: 0.48MB + Engine InnoDB
    wp_22_pmxe_exports Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_22_pmxe_google_cats Data: 0.39MB + Index: 0.00MB + Engine InnoDB
    wp_22_pmxe_posts Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_22_pmxe_templates Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_22_postmeta Data: 344.92MB + Index: 548.78MB + Engine InnoDB
    wp_22_posts Data: 38.56MB + Index: 21.09MB + Engine InnoDB
    wp_22_po_plugins Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wp_22_quick_flag_countries Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_22_quick_flag_ip_ranges Data: 6.52MB + Index: 4.52MB + Engine InnoDB
    wp_22_sb_queue Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_22_termmeta Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wp_22_terms Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_22_term_relationships Data: 0.52MB + Index: 0.45MB + Engine InnoDB
    wp_22_term_taxonomy Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_22_wc_admin_notes Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_22_wc_admin_note_actions Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_22_wc_category_lookup Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_22_wc_customer_lookup Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_22_wc_download_log Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_22_wc_gpf_render_cache Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_22_wc_order_coupon_lookup Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_22_wc_order_product_lookup Data: 0.06MB + Index: 0.06MB + Engine InnoDB
    wp_22_wc_order_stats Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_22_wc_order_tax_lookup Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_22_wc_product_meta_lookup Data: 1.52MB + Index: 0.92MB + Engine InnoDB
    wp_22_wc_reserved_stock Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_22_wc_tax_rate_classes Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_22_wc_webhooks Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_22_woocommerce_amazon_buyer_index Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_22_woocommerce_customer_order_index Data: 9.52MB + Index: 24.13MB + Engine InnoDB
    wp_22_woocommerce_gpf_google_taxonomy Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wp_22_wpmailsmtp_attachment_files Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_22_wpmailsmtp_debug_events Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_22_wpmailsmtp_emails_log Data: 0.47MB + Index: 0.03MB + Engine InnoDB
    wp_22_wpmailsmtp_email_attachments Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_22_wpmailsmtp_email_tracking_events Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_22_wpmailsmtp_email_tracking_links Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_22_wpmailsmtp_tasks_meta Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_22_wpmm_subscribers Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_22_xyz_ihs_short_code Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_22_yoast_indexable Data: 16.55MB + Index: 11.58MB + Engine InnoDB
    wp_22_yoast_indexable_hierarchy Data: 1.52MB + Index: 0.94MB + Engine InnoDB
    wp_22_yoast_migrations Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_22_yoast_primary_term Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_22_yoast_seo_links Data: 0.33MB + Index: 0.17MB + Engine InnoDB
    wp_22_yoast_seo_meta Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wp_2blogmeta Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_2blogs Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_2registration_log Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_2signups Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_2site Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_2sitemeta Data: 2.52MB + Index: 0.08MB + Engine InnoDB
    wp_2usermeta Data: 129.67MB + Index: 143.34MB + Engine InnoDB
    wp_2users Data: 6.52MB + Index: 8.55MB + Engine InnoDB
    Post Type Counts
    attachment 9288
    customize_changeset 1
    html_snippet 6
    nav_menu_item 188
    page 83
    post 4
    product 4431
    product_variation 989
    qa_faqs 28
    revision 872
    ris_gallery 1
    shop_coupon 17
    shop_order 75995
    shop_order_refund 4268
    wooframework 150
    wpcf7_contact_form 2
    Security
    Secure connection (HTTPS):
    Hide errors from visitors Error messages should not be shown to visitors.
    Active plugins (68)
    Postcode.nl Address Autocomplete by Postcode.nl – 1.0.7
    Angle measurement FeatherLight BV by Albert de Krijger – 1.0.0
    Contact Form 7 by Takayuki Miyoshi – 5.4.2
    Cookie Notice & Compliance for GDPR / CCPA by Hu-manity.co – 2.1.3
    Diverse tools FeatherLight BV by Albert de Krijger – 2.0.1
    FeatherLight Email Validation by Now: Albert de Krijger, previouws Hugh Lashbrooke – 1.0.0
    WooCommerce – Customer Order Index EDITED BY FEATHERLIGHT by Patrick Garman \ FEATHERLIGHT – 1.0.0
    FeatherLight account guest maker by Albert de Krijger – 1.0.0
    FeatherLight add to cart functionality by Albert de Krijger – 1.0.0
    FeatherLight EAN numbers voor FeatherLight BV by Albert de Krijger – 1.0.0
    FeatherLight Exact Online Connection by Albert de Krijger – 1.0.5
    Filter WooCommerce Posts for FeatherLight by FeatherLight – 1.0.0
    FeatherLight 3D STL Tool by Albert de Krijger – 1.0.0
    FeatherLight Voys caller info by Albert de Krijger – 1.1.0
    Front page choice horizontal by Albert de Krijger – 1.0.0
    Generate and show products automatically by Albert de Krijger – 1.1.2
    Gasveer Tools Server Side by Albert de Krijger – 1.1.0
    Show Kiyoh reviews on review page by Albert de Krijger; Jurgen Oldenburg – 2.0.3
    Loco Translate by Tim Whitlock – 2.5.3
    Mollie Payments for WooCommerce by Mollie – 6.5.2
    Protempo nummers zoeken website by Albert de Krijger – 1.0.1
    Q and A FAQ and Knowledge Base for WordPress by Raygun – 1.0.0
    Quote maker FeatherLight by Albert de Krijger – 1.0.1
    Raw HTML by Janis Elsts – 1.6.3
    SSL Insecure Content Fixer by WebAware – 2.7.2
    User Switching by John Blackbourn & contributors – 1.5.7
    WooCommerce Email CC & BCC by Routy Development LLC – 1.0
    WooCommerce Bulk Edit Product Variations by matterico_themes – 2.6
    WooCommerce Dynamic Pricing by Element Stark – 3.1.26
    WooCommerce EU VAT Number by WooCommerce – 2.4.1
    WooCommerce Amazon Pay by WooCommerce – 2.0.3
    WooCommerce Google Analytics Integration by WooCommerce – 1.5.2
    WooCommerce Google Product Feed by Ademti Software Ltd. – 10.1.6
    WooCommerce Sequential Order Numbers Pro by SkyVerge – 1.18.0
    WooCommerce by Automattic – 5.6.0
    Wordfence Security by Wordfence – 7.5.5
    Yoast SEO by Team Yoast – 17.1
    WP All Export Pro by Soflyy – 1.6.3
    WP Crontrol by John Blackbourn & crontributors – 1.10.0
    WP Mail SMTP Pro by WPForms – 3.0.2
    ReCaptcha v2 for Contact Form 7 by IQComputing – 1.3.5
    WPS Hide Login by WPServeur, NicolasKulka, wpformation – 1.8.6
    YITH WooCommerce Ajax Search by YITH – 1.0.0
    User Switching by John Blackbourn & contributors – 1.5.7
    Gasveer Tools Server Side by Albert de Krijger – 1.1.0
    Q and A FAQ and Knowledge Base for WordPress by Raygun – 1.0.0
    WooCommerce Email CC & BCC by Routy Development LLC – 1.0
    jQuery Updater by Ramoonus – 3.6.0.1
    jQuery Lightbox For Native Galleries by Viper007Bond – 3.2.2
    Contact Form 7 by Takayuki Miyoshi – 5.4.2
    FeatherLight Fix Reordering by Albert de Krijger – 1.0.0
    Network Plugin Auditor by Katherine Semel – 1.10.1
    Search By SKU – for Woocommerce by Unroll Digital – 0.8.0
    PublishPress Capabilities by PublishPress – 2.2
    Custom report plugin FeatherLight BV by Albert de Krijger – 1.2.0
    FeatherLight import and export products by Albert de Krijger – 1.0.0
    Classic Editor by WordPress Contributors – 1.6.2
    Wordfence Security by Wordfence – 7.5.5
    SSL Insecure Content Fixer by WebAware – 2.7.2
    FeatherLight Core by Jurgen Oldenburg – 1.6.0
    FeatherLight Maintenance Mode by Jurgen Oldenburg – 2.0.0
    Easy Theme and Plugin Upgrades by Chris Jean – 2.0.2
    WP Migrate DB Pro by Delicious Brains – 2.1.2
    WP Migrate DB Pro Media Files by Delicious Brains – 2.0.3
    WP Migrate DB Pro CLI by Delicious Brains – 1.5
    WP Migrate DB Pro Multisite Tools by Delicious Brains – 1.3.1
    Preview E-mails for WooCommerce by Digamber Pradhan – 1.6.8
    Servebolt Optimizer by Servebolt – 3.2
    Inactive plugins (22)
    Autoptimize by Frank Goossens (futtta) – 2.9.2
    Error Log Monitor by Janis Elsts – 1.7
    FeatherLight 3D STL Manipulation Tool by Albert de Krijger – 1.0.1
    Filter voor vervangingsgasveren versie 2 by Albert de Krijger – 1.0.0
    Google Language Translator by Translate AI Multilingual Solutions – 6.0.11
    Internal number Eckold by Albert de Krijger – 1.0.0
    JSON ordering for Echold AG, Switzerland by Albert de Krijger – 1.0.0
    JSON ordering for Hahn gasfedern, Itialy by Brian Moret – 2.0.0
    JSON ordering for Protempo B.V. by Albert de Krijger – 1.0.0
    Kiyoh Customerreview by kiyoh – 1.0.30
    Klarna Checkout for WooCommerce by Krokedil – 2.6.0
    MultiSafepay by MultiSafepay – 4.8.3
    PayPal Express Checkout Payment Gateway for WooCommerce by WebToffee – 1.2.7
    SiteGround Optimizer by SiteGround – 5.9.6
    WooCommerce Dotpay Gateway by Dotpay (tech@dotpay.pl) – 3.6.2
    WooCommerce Klarna Gateway by WooCommerce – 2.5.15
    WooCommerce PayPal Pro by wp.insider – 2.9.7
    WooCommerce Pixel Manager by woopt – 1.11.5
    WooCommerce PostFinanceCw by customweb GmbH – 5.0.67
    WP All Import Pro by Soflyy – 4.6.5
    WPForms Lite by WPForms – 1.6.9
    WP Mail SMTP by WPForms – 3.0.3
    Dropin Plugins (1)
    sunrise.php sunrise.php
    Must Use Plugins (2)
    fl_disable_woocommerce_analytics.php by –
    WP Migrate DB Pro Compatibility by Delicious Brains – 1.2
    Settings
    API enabled:
    Force SSL: –
    Currency EUR (€)
    Currency position right_space
    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: –
    WooCommerce pages
    Shop base: Page visibility should be public
    Cart: #6 – /warenkorb/
    Checkout: #7 – /zur-kasse/
    My account: #9 – /mein-konto/
    Terms and conditions: #106 – /allgemeine-geschaftsbedingungen/
    Theme
    Name: FeatherLight Germany
    Version: 2.0.5
    Author URL: https://www.gasveerwinkel.nl
    Child theme:
    Parent theme name: Storefront
    Parent theme version: 3.8.1
    Parent theme author URL: https://woocommerce.com/
    WooCommerce support:
    Templates
    Overrides storefrontfeatherlightde_bvh/woocommerce/cart/cart-item-data.php,
    storefrontfeatherlightde_bvh/woocommerce/cart/cart.php version 3.3.0 is out of date. The core version is 3.8.0,
    storefrontfeatherlightde_bvh/woocommerce/checkout/review-order.php version 3.3.0 is out of date. The core version is 5.2.0,
    storefrontfeatherlightde_bvh/woocommerce/content-single-product.php version 3.0.0 is out of date. The core version is 3.6.0,
    storefrontfeatherlightde_bvh/woocommerce/emails/customer-processing-order.php version 2.5.0 is out of date. The core version is 3.7.0,
    storefrontfeatherlightde_bvh/woocommerce/emails/email-order-details.php version 3.3.1 is out of date. The core version is 3.7.0,
    storefrontfeatherlightde_bvh/woocommerce/emails/email-order-items.php version 3.2.0 is out of date. The core version is 3.7.0,
    storefrontfeatherlightde_bvh/woocommerce/loop/no-products-found.php,
    storefrontfeatherlightde_bvh/woocommerce/myaccount/form-edit-account.php version 3.3.0 is out of date. The core version is 3.5.0,
    storefrontfeatherlightde_bvh/woocommerce/product-searchform.php
    Outdated templates: Learn how to update
    WooCommerce Google Product Feed feeds
    google Google merchant centre product feed
    Type: google
    Category filter: –
    Categories: –
    googleinventory Google merchant centre product inventory feed (legacy)
    Type: googleinventory
    Category filter: –
    Categories: –
    bing Bing merchant centre feed
    Type: bing
    Category filter: –
    Categories: –
    WooCommerce Google Product Feed options
    Include variations in feed –
    Send “item group ID” –
    Expanded schema markup –
    Debug key 46f33572-21ce-4646-b1ef-81e171c2163a
    WooCommerce Google Product Feed fields
    Condition Defaults to “new”.
    Brand Defaults to “Gasfedershop.de”.
    Product Type Pre-populates from product_cat taxonomy.
    Google Product Category Defaults to “2878”.
    Identifier exists flag Defaults to “included”.
    Delivery label Defaults to “DPD”.
    Title Pre-populates from product product_title.
    Availability (in stock products) Defaults to “in stock”.
    Availability (backordered products) Defaults to “in stock”.
    Availability (out of stock products) Defaults to “out of stock”.
    Action Scheduler
    Version: 3.2.1
    Data store: ActionScheduler_DBStore
    Action Status Count Oldest Scheduled Date Newest Scheduled Date
    Complete 34,576 2021-06-30 06:34:18 +0000 2021-09-08 11:45:49 +0000
    Failed 26 2019-06-18 17:41:10 +0000 2021-07-29 12:36:03 +0000
    Pending 23 -0001-11-30 00:00:00 +0000 2021-09-15 10:32:36 +0000
    Status report information
    Generated at: 2021-09-14 11:14:59 +01:00`

    Plugin Author webtoffee

    (@webtoffee)

    Hi @jurgen-oldenburg @ansondavis,

    Thanks for sharing the information. We are looking into it and will get back to you soon.

    @webtoffee
    Great, would be nice to have this fixed. Keep me posted 🙂

    Thread Starter ansondavis

    (@ansondavis)

    Hi @webtoffee we,

    I am still waiting for the fix.

    I agree, a solution would be nice!

    Plugin Author webtoffee

    (@webtoffee)

    Hi @ansondavis @jurgen-oldenburg,

    We are sorry for the delayed response while we are checking the issue on our end. Unfortunately, this cannot be fixed at our end alone. We have already contacted the plugin vendor and waiting for their response. We suggest you contact the plugin vendor from your side too. Thanks for understanding.

    Jurgen Oldenburg

    (@jurgen-oldenburg)

    @webtoffee @ansondavis Alright guys, I’ve finally found the time to solve this thing.
    With the filter and function below you’ll pass the custom order number to amazon pay, instead of the woocommerce order-id.

    // Pass our order number to amazon pay instead of the wc order-id
    add_filter( 'woocommerce_amazon_pa_update_checkout_session_payload', 'amazon_pay_custom_order_number', 99, 3 );
    
    

    /**
    * Pass the WooCommerce order number instead of the ID to Amazon Pay
    * @hook woocommerce_amazon_pa_update_checkout_session_payload
    * @param array $payload Payload data from amazon pay provider
    * @param string $checkout_session_id Checkout session id
    * @param WC_Order $order WooCommerce Order object
    * @return array The manipulated payload data with new order number attached
    */
    function amazon_pay_custom_order_number(array $payload, string $checkout_session_id, WC_Order $order): array {
    $payload[‘merchantMetadata’][‘merchantReferenceId’] = $order->get_order_number();
    return $payload;
    }`

    @jurgen-oldenburg Eyyyyy that’s a nice find. I was looking inside the WC_Amazon_Payments_Advanced_API::get_merchant_metadata() function and wanting a filter in there, but I see that the filter you found is just after the call to that function — nice.

    Some notes/thoughts —
    * It looks like that filter isn’t applied on scheduled subscription payments, so this solution probably won’t work right with Subscription stores
    * Oops, and here I see why I didn’t see that filter — it doesn’t get applied when running an _authorization_ in the WC_Gateway_Amazon_Payments_Advanced::perform_authorization() function, only when it’s a capture (the store I’m debugging this for uses authorize -> capture on complete).
    * I have no idea the implications of this for IPN functionality — mostly because I don’t really know what this plugin uses IPN for. I think just hotwiring the order number in at the payload stage will cause issues if the order subsequently gets updated via the IPN update method because the order ID coming back from the Amazon API won’t match the database.

    I’m working on some adjustments of my own to make this work in our situation, and I’ll share here since this is the only relevant thread I’ve found. I’m planning on submitting a pull request on the Amazon Pay plugin github to request some filters be added so we can do this kind of thing without hacking the plugin.

    So, first I’m adding a filter to the WC_Amazon_Payments_Advanced_API::get_merchant_metadata() function, making the return statement look like this:

    return apply_filters( 'woocommerce_amazon_pa_merchant_metadata', array(
    	'merchantReferenceId' => $order_id,
    	'merchantStoreName'   => WC_Amazon_Payments_Advanced::get_site_name(),
    	'customInformation'   => $version_note,
    ) );
    

    Then I’m adding another filter to WC_Amazon_Payments_Advanced_IPN_Handler::handle_notification_ipn_v2() after the first switch statement (line 439) that allows us to filter the order ID that’s coming in from IPN:

    
    $order_id = apply_filters( 'woocommerce_amazon_pa_ipn_order_id', $order_id );
    

    Annoyingly, there’s already a filter on the $order object right below that on line 446, but the is_numeric check above that will already dump out of the function if the order number returned by the API isn’t numeric (we use a alpha prefix for ours, so no bueno).

    So anyway, with those two filters added, I’ve popped these two functions into a plugin:

    
    /**
     * Use the WooCommerce Sequential Order Numbers Pro order number for Amazon API
     *
     * @param array $metadata Metadata array that goes to the Amazon API
     * @return array Filtered data with the merchantReferenceId replaced
     */
    function apcc_use_sequential_order_number_on_submit( $metadata ) {
    	$order = wc_get_order( $metadata['merchantReferenceId'] );
    	$metadata['merchantReferenceId'] = $order->get_order_number();
    	return $metadata;
    }
    add_filter( 'woocommerce_amazon_pa_merchant_metadata', 'apcc_use_sequential_order_number_on_submit' );
    
    /**
     * Lookup the IPN requested order by the sequential order number and return the order id
     *
     * @param string $order_id merchantReferenceId returned from the API
     * @return int Internal order ID
     */
    function apcc_lookup_order_by_seq_order_number( $order_number ) {
    	// Use the WooCommerce Sequential Order Numbers Pro helper function to look up the order ID
    	$order_id = wc_seq_order_number_pro()->find_order_by_order_number( $order_number );
    	// If an order ID is found, return it to the filter
    	if ( $order_id ) return $order_id;
    	// If it wasn't found, this might not be a sequential order number, so sent it back as-is
    	else return $order_number;
    }
    add_filter( 'woocommerce_amazon_pa_ipn_order_id', 'apcc_lookup_order_by_seq_order_number' );
    

    This code is actually set up for the _other_ Sequential Order Numbers plugin (sorry @webtoffee I’m sure this one is great too!), but the line with wc_seq_order_number_pro()->find_order_by_order_number( $order_number ) line can be replaced with whatever function is used to look up orders by the sequential order number in the Webtoffee plugin.

    I’ve done initial testing with this code in an Amazon Pay sandbox. I’m going to write some of this up and drop it on their Github as well.

    Thanks for your work on this — I got so hopeful that with your solution there was a simpler way to do this than mine, but looks like not quite!

    • This reply was modified 1 month, 3 weeks ago by eriktdesign. Reason: formatting

    Or maybe yours _will_ work and I’m just tired. I’m going to do some testing with both.

    Yeah, it looks like the IPN fails without also adding some kind of filter in the plugin there. I added a PR to the repo: https://github.com/woocommerce/woocommerce-gateway-amazon-pay/pull/133

Viewing 14 replies - 1 through 14 (of 14 total)
  • You must be logged in to reply to this topic.