Royal Mail Click and Drop Integration Stopped Working
-
We have been using the Royal Mail click and drop integration with WooCommerce for many years now but recently it has simply stopped working.
Trying to re-connect from Royal Mail to the site states it has failed
“The store has been updated but connection to the marketplace failed. Please check your details and try again”The details are correct but i have disconnected and (tried) to reconnect to the site. The connection stage works and a Rest API key is created on my Woocommerce site, but then it subsequently does not connect or pull any data. The Last Access date in the woocommerce REST API settings simply states unknown.
I have conducted tests with my caching and security plugins disabled, and even have gone soo far as to install a brand new WooCommerce site on a subdomain (see clean config report below) but still having the same issues.
Does WooCommerce log REST api calls in any logs that i can turn on/ review to understand where the problem may be?
Any help is appreciated.
Configuration Details of live site below:
### WordPress Environment ### WordPress address (URL): REDACTED Site address (URL): REDACTED 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 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ✔ Language: en_GB External object cache: – ### Server Environment ### Server Info: Apache/2.4.48 (cPanel) OpenSSL/1.1.1k mod_bwlimited/1.4 Phusion_Passenger/6.0.7 PHP Version: 7.4.22 PHP Post Max Size: 256 MB PHP Time Limit: 300 PHP Max Input Vars: 10000 cURL Version: 7.71.0 OpenSSL/1.1.1d SUHOSIN Installed: – MySQL Version: 5.7.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: REDACTED Total Database Size: 55.90MB Database Data Size: 38.11MB Database Index Size: 17.79MB hlfo_woocommerce_sessions: Data: 0.73MB + Index: 0.01MB + Engine MyISAM hlfo_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM hlfo_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM hlfo_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM hlfo_woocommerce_order_items: Data: 0.87MB + Index: 0.34MB + Engine MyISAM hlfo_woocommerce_order_itemmeta: Data: 5.70MB + Index: 3.78MB + Engine MyISAM hlfo_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM hlfo_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM hlfo_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM hlfo_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM hlfo_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM hlfo_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM hlfo_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM hlfo_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM hlfo_actionscheduler_actions: Data: 0.02MB + Index: 0.13MB + Engine InnoDB hlfo_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB hlfo_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB hlfo_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB hlfo_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM hlfo_comments: Data: 1.16MB + Index: 0.54MB + Engine MyISAM hlfo_gdpr_cc_options: Data: 0.02MB + Index: 0.00MB + Engine InnoDB hlfo_giftvouchers_activity: Data: 0.02MB + Index: 0.00MB + Engine InnoDB hlfo_giftvouchers_list: Data: 0.02MB + Index: 0.00MB + Engine InnoDB hlfo_giftvouchers_setting: Data: 0.02MB + Index: 0.00MB + Engine InnoDB hlfo_giftvouchers_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB hlfo_itsec_bans: Data: 0.09MB + Index: 0.11MB + Engine InnoDB hlfo_itsec_dashboard_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB hlfo_itsec_distributed_storage: Data: 0.00MB + Index: 0.00MB + Engine MyISAM hlfo_itsec_fingerprints: Data: 0.00MB + Index: 0.00MB + Engine MyISAM hlfo_itsec_geolocation_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM hlfo_itsec_lockouts: Data: 0.45MB + Index: 0.07MB + Engine MyISAM hlfo_itsec_logs: Data: 7.74MB + Index: 0.58MB + Engine MyISAM hlfo_itsec_mutexes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB hlfo_itsec_opaque_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM hlfo_itsec_temp: Data: 0.05MB + Index: 0.06MB + Engine MyISAM hlfo_itsec_user_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB hlfo_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM hlfo_options: Data: 1.06MB + Index: 0.15MB + Engine MyISAM hlfo_pimwick_gift_card: Data: 0.02MB + Index: 0.02MB + Engine InnoDB hlfo_pimwick_gift_card_activity: Data: 0.02MB + Index: 0.02MB + Engine InnoDB hlfo_postmeta: Data: 15.60MB + Index: 9.11MB + Engine MyISAM hlfo_posts: Data: 2.60MB + Index: 1.07MB + Engine MyISAM hlfo_relevanssi: Data: 0.19MB + Index: 0.33MB + Engine MyISAM hlfo_relevanssi_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM hlfo_relevanssi_stopwords: Data: 0.01MB + Index: 0.01MB + Engine MyISAM hlfo_termmeta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM hlfo_terms: Data: 0.01MB + Index: 0.02MB + Engine MyISAM hlfo_term_relationships: Data: 0.28MB + Index: 0.62MB + Engine MyISAM hlfo_term_taxonomy: Data: 0.01MB + Index: 0.01MB + Engine MyISAM hlfo_tm_taskmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM hlfo_tm_tasks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM hlfo_usermeta: Data: 0.65MB + Index: 0.02MB + Engine MyISAM hlfo_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM hlfo_wcpdf_invoice_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM hlfo_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB hlfo_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB hlfo_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB hlfo_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB hlfo_wc_deposits_lastemailsent: Data: 0.02MB + Index: 0.00MB + Engine InnoDB hlfo_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM hlfo_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB hlfo_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB hlfo_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB hlfo_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB hlfo_wc_product_meta_lookup: Data: 0.38MB + Index: 0.39MB + Engine MyISAM hlfo_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB hlfo_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM hlfo_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM hlfo_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB hlfo_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ### Post Type Counts ### attachment: 1653 custom_css: 1 foogallery: 2 giftcard: 4 itsec-dash-card: 5 itsec-dashboard: 1 ml-slide: 230 ml-slider: 40 nav_menu_item: 35 page: 23 post: 1 product: 424 product_variation: 3998 revision: 92 shop_coupon: 6 shop_order: 2490 shop_order_refund: 42 wcdp_payment: 70 wpcf7_contact_form: 1 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (21) ### FooGallery: by FooPlugins – 2.0.39 Akismet Anti-Spam: by Automattic – 4.1.11 iThemes Security: by iThemes – 8.0.2 Cache Enabler: by KeyCDN – 1.7.2 Honeypot for Contact Form 7: by Nocean – 2.1 Contact Form 7: by Takayuki Miyoshi – 5.4.2 Disable WooCommerce Bloat: by ospiotr – 2.5.1 FooBox Image Lightbox: by FooPlugins – 2.7.16 GDPR Cookie Compliance (CCPA, PIPEDA ready): by Moove Agency – 4.5.8 Google XML Sitemaps: by Auctollo – 4.1.1 Max Mega Menu: by megamenu.com – 2.9.4 MetaSlider: by MetaSlider – 3.22.1 Product Open Pricing (Name Your Price) for WooCommerce: by WP Wham – 1.6.0 Redux: by Redux.io – 4.2.14 Relevanssi: by Mikko Saari – 4.13.3.1 Variation Swatches for WooCommerce: by Emran Ahmed – 1.1.17 WooCommerce Deposits: by Webtomizer – 3.2.5 WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.1.2 WooCommerce Stripe Gateway: by WooCommerce – 5.4.0 WooCommerce: by Automattic – 5.6.0 WP Mail SMTP Pro: by WPForms – 3.0.2 ### Inactive Plugins (2) ### WooCommerce PDF Catalog: by weLaunch – 1.15.4 WP Rollback: by Impress.org – 1.7.1 ### Dropin Plugins (1) ### advanced-cache.php: advanced-cache.php ### Settings ### API Enabled: – Force SSL: – Currency: GBP (£) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) pw gift card (pw-gift-card) simple (simple) variable (variable) wgm_gift_card (wgm_gift_card) 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: #10 - /shop/ Basket: #11 - /basket/ Checkout: #12 - /checkout/ My account: #13884 - /my-account/ Terms and conditions: #23 - /terms-conditions/ ### Theme ### Name: Shopper Child Theme Version: 1.0.0 Author URL: REDACTED Child Theme: ✔ Parent Theme Name: Shopper Parent Theme Version: 1.3.8 Parent Theme Author URL: https://shopperwp.io WooCommerce Support: ✔ ### Templates ### Overrides: shopper/woocommerce/archive-product.php shopper-child/woocommerce/emails/admin-new-order.php shopper-child/woocommerce/emails/customer-completed-order.php shopper-child/woocommerce/emails/email-order-items.php shopper/woocommerce/global/quantity-input.php shopper/woocommerce/single-product.php ### Product Open Pricing Settings ### Product Open Pricing (Name Your Price): yes Frontend template: Custom Price (%currency_symbol%) %open_price_input% Input field position: woocommerce_before_add_to_cart_button Position priority.: 9999 Hide price: yes Disable quantity selector: yes Display on loop: no Frontend loop template: Name Your Price %open_price_input% %currency_symbol% Input field loop position: woocommerce_after_shop_loop_item Position priority.: 9 Hide price: yes Input style: width:75px;text-align:center; Input pattern: Enable step ticker: no Price step: 0.01 Force number of decimals: no Number of decimals.: 2 Add To Cart button text: Message on empty price: Price is required! Message on price too low: Price is too low! Message on price too high: Price is too high! Add "Open Pricing" column: no Fix mini cart: yes ### Action Scheduler ### Complete: 9 Oldest: 2021-08-01 00:17:39 +0100 Newest: 2021-08-22 00:27:49 +0100 Pending: 1 Oldest: 2021-08-29 00:27:49 +0100 Newest: 2021-08-29 00:27:49 +0100 ### Status report information ### Generated at: 2021-08-25 16:25:37 +01:00
Configuration Details of clean site
### WordPress Environment ### WordPress address (URL): REDACTED Site address (URL): REDACTED 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 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.29 PHP Post Max Size: 256 MB PHP Time Limit: 300 PHP Max Input Vars: 10000 cURL Version: 7.71.0 OpenSSL/1.1.1d SUHOSIN Installed: – MySQL Version: 5.7.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: nd_ Total Database Size: 4.30MB Database Data Size: 2.90MB Database Index Size: 1.40MB nd_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB nd_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB nd_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB nd_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB nd_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB nd_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB nd_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB nd_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB nd_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB nd_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB nd_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB nd_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB nd_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB nd_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB nd_actionscheduler_actions: Data: 0.02MB + Index: 0.13MB + Engine InnoDB nd_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB nd_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB nd_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB nd_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB nd_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB nd_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB nd_options: Data: 2.03MB + Index: 0.03MB + Engine InnoDB nd_postmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB nd_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB nd_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB nd_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB nd_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB nd_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB nd_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB nd_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB nd_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB nd_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB nd_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB nd_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB nd_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB nd_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB nd_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB nd_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB nd_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB nd_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB nd_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB nd_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB nd_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ### Post Type Counts ### attachment: 1 page: 7 post: 2 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (5) ### Invoice Gateway For WooCommerce: by Rymera Web Co – 1.1 WooCommerce Invoice Gateway: by Stuart Duff – 1.0.6 Package Orders for WooCommerce: by OneTeamSoftware – 1.0.31 Shipping Packages for WooCommerce: by OneTeamSoftware – 1.1.18 WooCommerce: by Automattic – 5.6.0 ### Inactive Plugins (0) ### ### 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: #7 - /shop/ Cart: #8 - /cart/ Checkout: #9 - /checkout/ My account: #10 - /my-account/ Terms and conditions: ❌ Page not set ### Theme ### Name: Top Store Pro Child Theme Version: 1.0.2 Author URL: REFACTED Child Theme: ✔ Parent Theme Name: Top Store Pro Parent Theme Version: 1.1.9 Parent Theme Author URL: https://www.themehunk.com WooCommerce Support: ✔ ### Templates ### Archive Template: Your theme has a woocommerce.php file you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues. Overrides: top-store-pro-child/woocommerce/emails/admin-new-order.php top-store-pro-child/woocommerce/emails/customer-on-hold-order.php top-store-pro-child/woocommerce/myaccount/dashboard.php ### Action Scheduler ### Complete: 6 Oldest: 2021-08-24 16:50:18 +0000 Newest: 2021-08-25 09:20:38 +0000 ### Status report information ### Generated at: 2021-08-25 16:27:26 +00:00
- The topic ‘Royal Mail Click and Drop Integration Stopped Working’ is closed to new replies.