Some Orders not Exporting

Status Report:

` WordPress Environment</p> <p class=””>WordPress address (URL): https://alliancechemical.com/wp<br>Site address (URL): https://alliancechemical.com<br>WC Version: 8.3.1<br>REST API Version: ? 8.3.1<br>WC Blocks Version: ? 11.4.9<br>Action Scheduler Version: ? 3.6.4<br>Log Directory Writable: ?<br>WP Version: 6.4.1<br>WP Multisite: –<br>WP Memory Limit: 256 MB<br>WP Debug Mode: –<br>WP Cron: –<br>Language: en_US<br>External object cache: – Server Environment</p> <p class=””>Server Info: nginx/1.23.2<br>PHP Version: 8.0.26<br>PHP Post Max Size: 32 MB<br>PHP Time Limit: 120<br>PHP Max Input Vars: 1000<br>cURL Version: 7.68.0<br>OpenSSL/1.1.1f</p> <p class=””>SUHOSIN Installed: –<br>MySQL Version: 10.5.18-MariaDB-1:10.5.18+maria~ubu2004<br>Max Upload Size: 32 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ? Your server does not have the SoapClient class enabled – some gateway plugins which use SOAP may not work as expected.<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ? Database</p> <p class=””>WC Database Version: 8.3.1<br>WC Database Prefix: wp_<br>Total Database Size: 423.07MB<br>Database Data Size: 347.19MB<br>Database Index Size: 75.88MB<br>wp_woocommerce_sessions: Data: 1.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_order_items: Data: 1.52MB + Index: 0.22MB + Engine InnoDB<br>wp_woocommerce_order_itemmeta: Data: 6.52MB + Index: 5.00MB + Engine InnoDB<br>wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_payment_tokens: Data: 0.06MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_payment_tokenmeta: Data: 0.11MB + Index: 0.14MB + Engine InnoDB<br>wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_actions: Data: 9.02MB + Index: 10.11MB + Engine InnoDB<br>wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_logs: Data: 7.02MB + Index: 6.03MB + Engine InnoDB<br>wp_aws_cache: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wp_aws_index: Data: 2.19MB + Index: 2.13MB + Engine InnoDB<br>wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_comments: Data: 5.52MB + Index: 8.05MB + Engine InnoDB<br>wp_fbv: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_fbv_attachment_folder: Data: 0.14MB + Index: 0.00MB + Engine InnoDB<br>wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailchimp_carts: Data: 1.03MB + Index: 0.00MB + Engine InnoDB<br>wp_mailchimp_jobs: Data: 0.13MB + Index: 0.00MB + Engine InnoDB<br>wp_media_library_organizer_exif_iptc_geo: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mw_wc_qbo_sync_customer_pairs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mw_wc_qbo_sync_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mw_wc_qbo_sync_paymentmethod_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mw_wc_qbo_sync_payment_id_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mw_wc_qbo_sync_product_pairs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mw_wc_qbo_sync_qbo_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mw_wc_qbo_sync_qbo_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mw_wc_qbo_sync_real_time_sync_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mw_wc_qbo_sync_real_time_sync_queue: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wp_mw_wc_qbo_sync_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mw_wc_qbo_sync_shipping_product_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mw_wc_qbo_sync_tax_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mw_wc_qbo_sync_variation_pairs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mw_wc_qbo_sync_wq_cf_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nextend2_image_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_nextend2_section_storage: Data: 0.05MB + Index: 0.06MB + Engine InnoDB<br>wp_nextend2_smartslider3_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nextend2_smartslider3_sliders: Data: 0.08MB + Index: 0.03MB + Engine InnoDB<br>wp_nextend2_smartslider3_sliders_xref: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_nextend2_smartslider3_slides: Data: 0.05MB + Index: 0.13MB + Engine InnoDB<br>wp_options: Data: 8.09MB + Index: 1.11MB + Engine InnoDB<br>wp_postmeta: Data: 39.58MB + Index: 27.89MB + Engine InnoDB<br>wp_posts: Data: 6.41MB + Index: 1.72MB + Engine InnoDB<br>wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_term_relationships: Data: 0.27MB + Index: 0.14MB + Engine InnoDB<br>wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_usermeta: Data: 7.45MB + Index: 7.70MB + Engine InnoDB<br>wp_users: Data: 1.50MB + Index: 0.38MB + Engine InnoDB<br>wp_wcpdf_invoice_number: Data: 0.16MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_admin_notes: Data: 0.09MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_admin_note_actions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_customer_lookup: Data: 0.50MB + Index: 0.47MB + Engine InnoDB<br>wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_gpf_render_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_coupon_lookup: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_product_lookup: Data: 0.52MB + Index: 0.53MB + Engine InnoDB<br>wp_wc_order_stats: Data: 1.52MB + Index: 0.45MB + Engine InnoDB<br>wp_wc_order_tax_lookup: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_product_attributes_lookup: Data: 0.23MB + Index: 0.19MB + Engine InnoDB<br>wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_meta_lookup: Data: 0.36MB + Index: 0.59MB + Engine InnoDB<br>wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wfblockediplog: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wfconfig: Data: 1.30MB + Index: 0.00MB + Engine InnoDB<br>wp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wffilemods: Data: 8.52MB + Index: 0.00MB + Engine InnoDB<br>wp_wfhits: Data: 2.02MB + Index: 1.14MB + Engine InnoDB<br>wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wfknownfilelist: Data: 4.52MB + Index: 0.00MB + Engine InnoDB<br>wp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wflogins: Data: 0.44MB + Index: 0.14MB + Engine InnoDB<br>wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wfls_role_counts: Data: 0.00MB + Index: 0.00MB + Engine MEMORY<br>wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfsecurityevents: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wfstatus: Data: 0.13MB + Index: 0.11MB + Engine InnoDB<br>wp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfwaffailures: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_gpf_google_taxonomy: Data: 2.02MB + Index: 0.13MB + Engine InnoDB<br>wp_wpml_mails: Data: 225.52MB + Index: 0.00MB + Engine InnoDB Post Type Counts</p> <p class=””>acf-field: 105<br>acf-field-group: 16<br>attachment: 2600<br>blog: 50<br>nav_menu_item: 16<br>page: 16<br>post: 8<br>product: 170<br>product_variation: 1388<br>revision: 259<br>shop_coupon: 7<br>shop_order: 3834<br>shop_order_refund: 84<br>wp_global_styles: 1<br>wp_navigation: 1 Security</p> <p class=””>Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (33)</p> <p class=””>Advanced Custom Fields PRO: by WP Engine – 6.2.4<br>Advanced Woo Search PRO: by ILLID – 2.93<br>Contextual Related Posts: by WebberZone – 3.4.2<br>GTM4WP: by Thomas Geiger – 1.18.1<br>Export All URLs: by Atlas Gondal – 4.7<br>FileBird: by Ninja Team – 5.0.8<br>XML Sitemap Generator for Google: by Auctollo – 4.1.13<br>Import and export users and customers: by codection – 1.24<br>Klaviyo: by Klaviyo<br>Inc. – 3.3.3</p> <p class=””>Mailchimp for WooCommerce: by Mailchimp – 3.3<br>Smart Slider 3 Pro: by Nextend – 3.5.1.21<br>Recently viewed and most viewed products: by CedCommerce – 1.1.1<br>SatisPress: by Cedaro – 1.0.4<br>Sellbrite: by GoDaddy – 1.0.2<br>SVG Support: by Benbodhi – 2.5.5<br>Product Feed PRO for WooCommerce: by AdTribes.io – 13.1.3<br>WP Sheet Editor – WooCommerce Products (Premium): by WP Sheet Editor – 1.8.7<br>WooCommerce Combo Offers: by IceBreakerStudio – 1.0.1<br>WooCommerce Coupon Restrictions: by WooCommerce – 1.8.6<br>WooCommerce Stripe Gateway: by WooCommerce – 7.7.0<br>WooCommerce Lift Gate Feature: by IceBreakerStudio – 1.0.1<br>PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.7.3<br>WooCommerce – Pipedrive CRM – Integration: by itgalaxycompany – 1.28.0<br>WooCommerce Google Product Feed: by Ademti Software Ltd. – 10.8.2<br>WooCommerce Shipment Tracking: by WooCommerce – 1.9.0<br>WooCommerce – ShipStation Integration: by WooCommerce – 4.3.9<br>WooCommerce: by Automattic – 8.3.1<br>Wordfence Security: by Wordfence – 7.11.0<br>WP Change Default From Email: by Subodh Ghulaxe – 1.1.5<br>3CX Live Chat: by 3CX – 10.0.10<br>WP Mail Logging: by WP Mail Logging Team – 1.12.0<br>Sequential Order Numbers for WooCommerce: by WebToffee – 1.5.7<br>Yotpo Social Reviews for Woocommerce: by Yotpo – 1.6.6 Inactive Plugins (3)</p> <p class=””>Make Filename Lowercase: by Ed Reckers (Red Bridge Internet) – 1.0.2<br>Query Monitor: by John Blackbourn – 3.15.0<br>Trustpilot-reviews: by Trustpilot – 2.5.925 Must Use Plugins (1)</p> <p class=””>Bedrock Autoloader: by Roots – 1.0.3 Settings</p> <p class=””>API Enabled: ?<br>Force SSL: –<br>Currency: USD ($)<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)</p> <p class=””>Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)</p> <p class=””>Connected to WooCommerce.com: –<br>Enforce Approved Product Download Directories: ?<br>HPOS feature screen enabled: –<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: – WC Pages</p> <p class=””>Shop base: #6 – /shop/<br>Cart: #7 – /cart/<br>Checkout: #8 – /checkout/<br>My account: #9 – /my-account/<br>Terms and conditions: ? Page not set Theme</p> <p class=””>Name: Alliance-Chemical<br>Version: 1.0.0<br>Author URL: https://icebreakerstudio.net/<br>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<br>WooCommerce Support: ? Templates</p> <p class=””>Overrides: alliance-chemical/archive-product.php<br>alliance-chemical/woocommerce/cart/cart-empty.php version 3.5.0 is out of date. The core version is 7.0.1<br>alliance-chemical/woocommerce/cart/cart-shipping.php version 3.6.0 is out of date. The core version is 7.3.0<br>alliance-chemical/woocommerce/cart/cart-totals.php<br>alliance-chemical/woocommerce/cart/cart.php version 3.8.0 is out of date. The core version is 7.9.0<br>alliance-chemical/woocommerce/cart/proceed-to-checkout-button.php version 2.4.0 is out of date. The core version is 7.0.1<br>alliance-chemical/woocommerce/cart/shipping-calculator.php version 4.0.0 is out of date. The core version is 7.0.1<br>alliance-chemical/woocommerce/checkout/form-billing.php<br>alliance-chemical/woocommerce/checkout/form-checkout.php<br>alliance-chemical/woocommerce/checkout/form-coupon.php version 3.4.4 is out of date. The core version is 7.0.1<br>alliance-chemical/woocommerce/checkout/form-login.php<br>alliance-chemical/woocommerce/checkout/form-pay.php version 5.2.0 is out of date. The core version is 8.2.0<br>alliance-chemical/woocommerce/checkout/form-shipping.php<br>alliance-chemical/woocommerce/checkout/order-receipt.php<br>alliance-chemical/woocommerce/checkout/payment-method.php<br>alliance-chemical/woocommerce/checkout/payment.php version 3.5.3 is out of date. The core version is 8.1.0<br>alliance-chemical/woocommerce/checkout/review-order.php<br>alliance-chemical/woocommerce/checkout/terms.php<br>alliance-chemical/woocommerce/checkout/thankyou.php version 3.7.0 is out of date. The core version is 8.1.0<br>alliance-chemical/woocommerce/content-product.php<br>alliance-chemical/woocommerce/content-single-product.php<br>alliance-chemical/woocommerce/global/quantity-input.php version 4.0.0 is out of date. The core version is 7.8.0<br>alliance-chemical/woocommerce/myaccount/dashboard.php<br>alliance-chemical/woocommerce/myaccount/form-add-payment-method.php version 4.3.0 is out of date. The core version is 7.8.0<br>alliance-chemical/woocommerce/myaccount/form-edit-account.php version 3.5.0 is out of date. The core version is 7.0.1<br>alliance-chemical/woocommerce/myaccount/form-edit-address.php version 3.6.0 is out of date. The core version is 7.0.1<br>alliance-chemical/woocommerce/myaccount/form-login.php<br>alliance-chemical/woocommerce/myaccount/form-lost-password.php version 3.5.2 is out of date. The core version is 7.0.1<br>alliance-chemical/woocommerce/myaccount/form-reset-password.php version 3.5.5 is out of date. The core version is 7.0.1<br>alliance-chemical/woocommerce/myaccount/my-account.php<br>alliance-chemical/woocommerce/myaccount/my-address.php<br>alliance-chemical/woocommerce/order/form-tracking.php version 6.5.0 is out of date. The core version is 7.0.1<br>alliance-chemical/woocommerce/order/order-again.php version 3.5.0 is out of date. The core version is 7.8.0<br>alliance-chemical/woocommerce/order/order-details-customer.php<br>alliance-chemical/woocommerce/order/order-details-item.php<br>alliance-chemical/woocommerce/order/order-details.php version 4.6.0 is out of date. The core version is 7.8.0<br>alliance-chemical/woocommerce/order/order-downloads.php<br>alliance-chemical/woocommerce/order/tracking.php<br>alliance-chemical/woocommerce/single-product/add-to-cart/grouped.php version 4.8.0 is out of date. The core version is 7.0.1<br>alliance-chemical/woocommerce/single-product/add-to-cart/simple.php version 3.4.0 is out of date. The core version is 7.0.1<br>alliance-chemical/woocommerce/single-product/add-to-cart/variable.php<br>alliance-chemical/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php version 3.4.0 is out of date. The core version is 7.0.1<br>alliance-chemical/woocommerce/single-product/add-to-cart/variation.php</p> <p class=””>Outdated Templates: ?</p> <pre class=”wp-block-code”><code> Learn how to update</code></pre> <p class=””>WooCommerce Google Product Feed feeds</p> <p class=””>4959927270c6f61a: Google Merchant<br>  Type: google<br>  Category filter: -<br>  Categories: – WooCommerce Google Product Feed options</p> <p class=””>Include variations in feed: Enabled<br>Send “item group ID”: Enabled<br>Expanded schema markup: -<br>Debug key: 52ebfed9-9dd9-486a-a583-679f7340e245 WooCommerce Google Product Feed fields</p> <p class=””>Title: Pre-populates from product product_title.<br>Product description: Main product description (full preferred) plus variation description<br>Availability (in stock products): Defaults to “in stock”.<br>Availability (backordered products): Defaults to “in stock”.<br>Availability (out of stock products): Defaults to “out of stock”.<br>Brand: Defaults to “Alliance Chemical”.<br>Manufacturer Part Number (MPN): Pre-populates from product sku.<br>Product Type: Defaults to “Business & Industrial > Science & Laboratory > Laboratory Chemicals”.<br>Google Product Category: Defaults to “Business & Industrial > Science & Laboratory > Laboratory Chemicals”.<br>Global Trade Item Number (GTIN): Pre-populates from hwp_var_gtin meta field.<br>Size: Pre-populates from pa_size taxonomy.<br>Size system: Defaults to “US”.<br>Material: Pre-populates from pa_packaging-type taxonomy. WooCommerce Google Product Feed DB status</p> <p class=””>Database version: 16<br>Active database version: 16<br>wc_gpf_render_cache: Empty<br>woocommerce_gpf_google_taxonomy (en-US): 5595 items Admin</p> <p class=””>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>product-variation-management<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page</p> <p class=””>Disabled Features: customize-store<br>minified-js<br>new-product-management-experience<br>product-virtual-downloadable<br>product-external-affiliate<br>settings<br>async-product-editor-category-field</p> <p class=””>Daily Cron: ? Next scheduled: 2023-11-29 12:43:26 +00:00<br>Options: ?<br>Notes: 153<br>Onboarding: skipped Action Scheduler</p> <p class=””>Canceled: 4<br>Oldest: 2023-11-07 18:32:38 +0000<br>Newest: 2023-11-28 01:01:08 +0000</p> <p class=””>Complete: 23,077<br>Oldest: 2023-10-28 20:00:07 +0000<br>Newest: 2023-11-28 19:56:44 +0000</p> <p class=””>Failed: 15<br>Oldest: 2023-01-17 17:31:10 +0000<br>Newest: 2023-11-22 19:20:23 +0000</p> <p class=””>Pending: 1<br>Oldest: 2023-11-29 15:15:05 +0000<br>Newest: 2023-11-29 15:15:05 +0000 Status report information</p> <p class=””>Generated at: 2023-11-28 20:00:23 +00:00<br>`

Hello @dannytaki,

Thank you for reaching out!

This issue did begin though after installing Sequential Order Numbers for WooCommerce plugin by webToffee.

Could you please try temporarily disabling the plugin to confirm if it’s the cause of the issue?

If it turns out that the plugin is indeed causing the problem, consider the following alternative from SkyVerge: https://woo.com/products/sequential-order-numbers-pro/

All extensions sold on WooCommerce.com have a 30-day refund policy. If the product doesn’t work the way you need it or you think another product would work better, we are more than happy to provide a full refund.

Let us know how it goes!

Thanks for the reply. I’m a bit worried about deactivating the plugin. If I deactivate the plugin, then the order numbers on these orders with status “processing” will change back to the woocommerce default. If that happens, will shipstation recognize them as new unique orders and import all my orders again?

What does the shipstation woocommerce plugin use to identify a order for pulling into its application? If its the order number, then it will see all these new orders and may possibly create duplicate orders in my shipstation store. The issue is that some are correctly being exported however some are not.

Hi @dannytaki,

When you deactivate the Sequential Order Numbers plugin, it won’t alter the existing order numbers. They will remain as they are. However, any new orders that come in will use the WooCommerce default order numbering system.

Also, ShipStation uses the Order ID, not the order number, to identify orders. The Order ID is a unique identifier that doesn’t change, even if the order number does. Therefore, deactivating the plugin shouldn’t result in duplicate orders in ShipStation.

If you’re still concerned about potential issues, you might want to consider doing a test run on a staging site first. If you don’t have a staging site set up, you can follow this guide: https://woo.com/posts/what-is-staging-site-wordpress-how-to-set-one-up/

Let us know how that goes. Looking forward to helping you.

Oh okay, so if the primary key is the order ID that maps the orders from shipstation to woocommerce, then I’ll disable the plugin and try a different one.

Hi there @dannytaki ??

Oh okay, so if the primary key is the order ID that maps the orders from shipstation to woocommerce, then I’ll disable the plugin and try a different one.

That is correct, about the Order ID. Let us know how trying with another plugin goes, please. Cheers!

I’ve let the plugin active over the weekend and we still encountered the issue were 12 different orders were never synced to Shipstation from Woocommerce. I’m using the Skyverge plugin now, however, I just deactivated to see if orders go through – the only problem is some orders won’t go through because without a different numbering schema, they will match the order number from past point in time because this is the 2nd iteration of our woocomerce site and it seem overlap between new and old order nubmers.

We recorded the orders that were missing over the weekend

• A11773
• A11770
• A11767
• A11764
• A11761
• A11758
• A11754
• A11751
• A11748
• A11747
• A11353

After disabling the plugin, we discovered an order where that didn’t sync however in its case there wasn’t any past order in shipstation with its identical order number that would block it, which means the issue may not be arising from the custom order number plugins at all? Any thoughts on debugging this? Do you offer paid support. Would like to resolve this issue

Ok, I think I’m figuring this out. What I think is happening is that there is using the field <OrderID> to map orders instead of the superficial <OrderNumber> field which is the visible order number one sees in the order dashboard of woocommerce associated with each order. How do we change that <OrderID> field with a custom pattern so that we don’t duplicate orderIDs that are already in Woocommerce and shipstation?

Hi @dannytaki,

From what you’ve described, it looks like there might be a conflict between the order IDs in WooCommerce and Shipstation due to the use of a custom order number plugin. This could potentially be causing the syncing issue you’ve been experiencing.

The field in WooCommerce is a unique identifier for each order and is automatically generated by WooCommerce. It’s not recommended to change this as it could cause further issues within your WooCommerce setup. The field, which is visible in the WooCommerce dashboard, can be changed using a custom order number plugin, as you already did.

In your case, it may be worth exploring the settings of your custom order number plugin to see if there’s a way to prevent the duplication of order numbers. If the plugin doesn’t provide this option, you may consider using a different plugin that allows for more customization of the order numbers.

In terms of debugging the issue, you could try deactivating all other plugins except for WooCommerce and the custom order number plugin to check if there’s a conflict with another plugin. If the issue persists, it might be necessary to consult with the plugin developer or seek help from the following:

• A local web developer
• Codeable.io
• WooExperts

Please let us know if you have any other questions.

@shameem,
The conflict is because the store connection in Shipstation was used for two different iterations of our website. Iteration 2 of our website is conflicting with orders that passed into shipstation in the past. The custom order number plugin is only changing the superficial <OrderNumber> field. For instance this is what the xml output looks like for an order where this problem is occurring:

<Order>

        <OrderNumber>

            <![CDATA[A11373]]>

        </OrderNumber>

        <OrderID>

            <![CDATA[12118]]>

        </OrderID>

        <OrderDate>12/11/2023 20:31</OrderDate>

This order, instead of being exported into shipstation as a new order, has instead updated a past order already in our shipstation , which has already shipped and occurred in 12/07/2020. I believe it is because they are matching on the OrderID, even if their OrderNumber were originally different.

The question is how can we alter the pattern of the orderID, so that we can guarantee that shipstation doesn’t contain any matching OrderIDs with Woocommerce

The XML Field generated from the shipstation plugin titled <OrderID> actually matches the fields titled orderNumber and orderKey

According to the Shipstation API Order Model:

orderNumberstring – A user-defined order number used to identify an order.
orderKeystring – A user-provided key that should be unique to each order. Can only be initialized during order creation. If the?orderkey?isn’t specified during creation, a unique value will be generated and assigned to the order.

I’m thinking its the orderKey field which is causing the issue. Where is this orderID value coming from in Woocomerce? Can we increase the number of the next value if its auto incrementing?

I ran GET request on the order with the issue using the shipstation API

{
“orderId”: 12139631,
“orderNumber”: “12118”,
“orderKey”: “12118”,
…
…
}

The OrderID can be found by inspect the row of the order number element in Shipstation

https://imgur.com/a/Dz1TqkS

Then a GET request to following endpoint gets back the information on the order:
https://ssapi.shipstation.com/orders/12139631

Hi dannytaki

Thank you for your reply.

WordPress treats most elements, be that posts, pages, media, attributes, categories, or tags, as ‘posts’, with each assigned a unique post ID. This includes elements associated with WooCommerce like products and orders. In the case of an order, its ID is the same as its post ID.

WordPress assigns these IDs sequentially, but not always based on the same element. It depends on what’s being created. For instance, if you receive two orders with a new blog post or product creation in between, those orders won’t have consecutive order ID numbers because the post ID (which also serves as the order ID) would have been used for the blog post or product.

To have more control over your order IDs, you might want to consider the WooCommerce Sequential Order Numbers Pro plugin. This particular plugin allows you to ensure your order numbers are sequential, rather than scattered, which might make things easier for you in the long run.

I hope this helps ??