dannytaki

Okay this was my solution. I had to do a database SQL operation on the wp_posts table

SQL:

ALTER TABLE wp_posts AUTO_INCREMENT = 100000;

I picked the value 100,000 by iterating through all my orders in my woocommerce store connection in Shipstation using their List Order API call then paginated and kept track of the maximum orderKey value through each pagination response. I determined my maximum was 60208 and choose 10000 just to be safe and make sure no future conflicts arise. Since this is only affecting new orders, I don’t see this operation affecting any other tables that may depend on the postID column as a foreign key. Here’s my Python code incase someone could use it.

import requests
import logging

# Setup basic logging
logging.basicConfig(level=logging.INFO, format='%(asctime)s - %(levelname)s - %(message)s')

def get_orders(store_id, page=1):
    url = f"https://ssapi.shipstation.com/orders?storeId={store_id}&page={page}"
    headers = {
        'Authorization': ''
    }
    response = requests.get(url, headers=headers)
    if response.status_code == 200:
        return response.json()
    else:
        logging.error(f"Failed to retrieve data: Status Code {response.status_code}")
        return None

store_id = '####' // replace with your store id
page = 1
max_order_key = None

while True:
    logging.info(f"Processing page: {page}")
    data = get_orders(store_id, page)
    if data and 'orders' in data:
        # Convert orderKey to integer for correct comparison
        page_max_order_key = max(int(order['orderKey']) for order in data['orders'] if order['orderKey'].isdigit())
        logging.info(f"Max orderKey on page {page}: {page_max_order_key}")

        if max_order_key is None or page_max_order_key > int(max_order_key):
            max_order_key = str(page_max_order_key)

        logging.info(f"Overall max orderKey after page {page}: {max_order_key}")
        page += 1
        if page > data['pages']:
            break
    else:
        break

logging.info(f"Final overall maximum orderKey value is: {max_order_key}")

@zubair,

This is not correct. The plugin Woocommerce Sequential Order Numbers Pro only affects the Order Number (visible in backend woo order dashboard) and not the postID of the order.

After activating the Sequential Order Numbers Pro plugin I set the Order Number to start at 3000

View post on imgur.com

However, in the database wp_posts table. We can the see the latest order has a postID = 2009.

View post on imgur.com

But in the order dashboard the latest order has the visible order number as 3000.

View post on imgur.com

Therefore the plugin doesn’t affect the orderID as you thought.

@zubair,

If I use the plugin though that just affects the superficial OrderNumber not the Post ID or am I mistaken?

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

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

@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.

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?

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

We recorded the orders that were missing over the weekend

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

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.

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.

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.

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>`

Thanks for the reply @anastas10s, so based on that piece of documentation, it seems there is no hook/filter to prevent a specific item from being exported to shipstation – all data is exported.

Interesting that’s definitely what I did. A couple of follow up questions if you dont mind answering or pointing me in the right direction:
1. How do I assign my pi a static IP address on my LAN
2. Why can’t I use the IP address assigned to my Pi by default to navigate my wordpress site from another computer – why should wordpress prevent this?