Woocommerce Square suddenly not syncing product description

  • Resolved heathervh

    (@heathervh)


    3 years, 6 months ago

    We have a website with a Woocommerce Square integration, where the inventory is being managed by Square. It’s all been working pretty well, except suddenly I notice the product descriptions I added on Square over the last few days are not showing on my website.

    – The sync is scheduled to run every 1.5 hours.
    – I have cleared the cache on my caching plugin
    – I have cleared my browser cache.

    Any ideas would be great as we really need the seo.

    Thanks

    The page I need help with: [log in to see the link]

Viewing 11 replies - 1 through 11 (of 11 total)
  • Thread Starter heathervh

    (@heathervh)

    Sorry, 1 more issue – new products being added to Square are not being imported with the scheduled syncing – I have to manually run the importer to add the new products – is this how it is supposed to work?

    Hello @heathervh,

    I see that the product description that is being added to Square isn’t being synced to your WooCommerce store. Additionally, new products added to Square aren’t automatically syncing with the scheduled syncing, and you have to manually sync to get the new products.

    is this how it is supposed to work?

    No, the scheduled syncing should be syncing all new products and updates on the existing products.

    Can you clarify whether the product description gets updated with the manual syncing or just the new products get added?

    Can you also let us know if you see any errors related to the syncing?

    Finally, could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”.? Once you’ve done that, paste it here in your response.

    This will help us understand how your site is set up so we can continue to troubleshoot.

    Thread Starter heathervh

    (@heathervh)

    Hi, thanks for responding.

    1. The product descriptions used to be updated when syncing up until about 2 weeks ago, now it doesn’t update at all, with scheduled sync or manual sync

    2. I don’t see any errors related to syncing

    3. System status below

    4. I see Square-Woocommerce renames images when syncing – is there a way to stop this as it’s bad for SEO. If I rename them on woocommerce, it then duplicates the images on the next sync.

    5. Also, while I have you here, is there a better caching plugin that works well with this plugin? I also have to manually clear the cache on WP Fastest Cache to show product updates currently, and there are constant inventory updates

    
### WordPress Environment ###

WordPress address (URL): https://newcastlebiltongco.com.au
Site address (URL): https://newcastlebiltongco.com.au
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: 512 MB
WP Debug Mode: ?
WP Cron: ?
Language: en_AU
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.23
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: wpup_
Total Database Size: 30.76MB
Database Data Size: 20.87MB
Database Index Size: 9.89MB
wpup_woocommerce_sessions: Data: 0.46MB + Index: 0.02MB + Engine MyISAM
wpup_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpup_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_woocommerce_order_items: Data: 0.08MB + Index: 0.04MB + Engine MyISAM
wpup_woocommerce_order_itemmeta: Data: 0.76MB + Index: 0.49MB + Engine MyISAM
wpup_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_woocommerce_shipping_zone_locations: Data: 0.03MB + Index: 0.05MB + Engine MyISAM
wpup_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_actionscheduler_actions: Data: 0.82MB + Index: 0.36MB + Engine MyISAM
wpup_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpup_actionscheduler_logs: Data: 0.63MB + Index: 0.45MB + Engine MyISAM
wpup_alp_pickup_location: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpup_cartflows_ca_cart_abandonment: Data: 0.25MB + Index: 0.02MB + Engine InnoDB
wpup_cartflows_ca_email_history: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpup_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpup_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpup_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpup_comments: Data: 0.20MB + Index: 0.07MB + Engine MyISAM
wpup_e_submissions: Data: 0.00MB + Index: 0.03MB + Engine MyISAM
wpup_e_submissions_actions_log: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpup_e_submissions_values: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpup_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_mailerlite_checkouts: Data: 0.20MB + Index: 0.00MB + Engine InnoDB
wpup_ml_data: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wpup_options: Data: 2.05MB + Index: 0.09MB + Engine MyISAM
wpup_postmeta: Data: 3.85MB + Index: 1.43MB + Engine MyISAM
wpup_posts: Data: 0.46MB + Index: 0.20MB + Engine MyISAM
wpup_rank_math_404_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpup_rank_math_analytics_gsc: Data: 2.52MB + Index: 4.88MB + Engine InnoDB
wpup_rank_math_analytics_objects: Data: 0.13MB + Index: 0.05MB + Engine InnoDB
wpup_rank_math_internal_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpup_rank_math_internal_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpup_rank_math_redirections: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wpup_rank_math_redirections_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpup_smush_dir_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_termmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wpup_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpup_term_relationships: Data: 0.05MB + Index: 0.09MB + Engine MyISAM
wpup_term_taxonomy: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wpup_tm_taskmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_tm_tasks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_usermeta: Data: 0.39MB + Index: 0.22MB + Engine MyISAM
wpup_users: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
wpup_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpup_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wpup_wc_admin_note_actions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wpup_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_wc_customer_lookup: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
wpup_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_wc_order_product_lookup: Data: 0.12MB + Index: 0.11MB + Engine MyISAM
wpup_wc_order_stats: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wpup_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_wc_product_meta_lookup: Data: 0.05MB + Index: 0.06MB + Engine MyISAM
wpup_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpup_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_wfblockediplog: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_wfblocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_wfconfig: Data: 2.32MB + Index: 0.01MB + Engine MyISAM
wpup_wfcrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_wffilemods: Data: 3.04MB + Index: 0.59MB + Engine MyISAM
wpup_wfhits: Data: 0.07MB + Index: 0.02MB + Engine MyISAM
wpup_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_wfissues: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpup_wfknownfilelist: Data: 1.65MB + Index: 0.18MB + Engine MyISAM
wpup_wflivetraffichuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_wflocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_wflogins: Data: 0.04MB + Index: 0.01MB + Engine MyISAM
wpup_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpup_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpup_wfnotifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_wfpendingissues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_wfpklist_template_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpup_wfreversecache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_wfsnipcache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_wfstatus: Data: 0.16MB + Index: 0.07MB + Engine MyISAM
wpup_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_woocommerce_square_customers: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
wpup_woo_shippment_provider: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wpup_wpvivid_scan_result: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpup_wpvivid_unused_uploads_files: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

### Post Type Counts ###

acf-field: 1
acf-field-group: 1
attachment: 686
custom_css: 1
elementor-hf: 1
elementor_library: 9
is_search_form: 1
nav_menu_item: 49
page: 13
post: 2
product: 582
product_variation: 12
revision: 4
seedprod: 1
shop_coupon: 2
shop_order: 198
wcpa_pt_forms: 1
wpforms: 1
xlwcty_thankyou: 1

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (20) ###

FiboSearch - AJAX Search for WooCommerce: by FiboSearch Team – 1.13.0
Duplicate Page: by mndpsingh287 – 4.4.3
Elementor Pro: by Elementor.com – 3.4.1
Elementor: by Elementor.com – 3.4.4
Media File Renamer: by Jordy Meow – 5.2.8
Rank Math SEO: by Rank Math – 1.0.71.1
Simple Google reCAPTCHA: by Michal Novák – 3.8
Advanced Shipment Tracking for WooCommerce: by zorem – 3.2.9
Woo Align Buttons: by 320up – 3.6.7
WooCommerce Cart Abandonment Recovery: by CartFlows Inc – 1.2.13
WooCommerce - MailerLite: by MailerLite – 1.5.6
WooCommerce PayPal Payments: by WooCommerce – 1.5.1
WooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 2.9.3
WooCommerce Square: by WooCommerce – 2.5.3
WooCommerce: by Automattic – 5.6.0
Wordfence Security: by Wordfence – 7.5.5
WP Fastest Cache: by Emre Vona – 0.9.4
WP-Optimize - Clean, Compress, Cache: by David Anderson
Ruhani Rabin
Team Updraft – 3.1.12

Smush: by WPMU DEV – 3.9.0
WPvivid Backup Plugin: by WPvivid Team – 0.9.61

### Inactive Plugins (1) ###

WooCommerce Custom Product Addons (Free): by Acowebs – 2.5.4

### Settings ###

API Enabled: –
Force SSL: –
Currency: AUD ($)
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: #6 - /shop/
Cart: #7 - /cart/
Checkout: #8 - /checkout/
My account: #9 - /my-account/
Terms and conditions: #2759 - /terms-conditions/

### Theme ###

Name: Astra Child
Version: 1.0.0
Author URL: https://newcastlebiltongco.com.au
Child Theme: ?
Parent Theme Name: Astra
Parent Theme Version: 3.7.1 – 3.7.2 is available
Parent Theme Author URL: https://wpastra.com/about/
WooCommerce Support: ?

### Templates ###

Overrides: –

### WooCommerce PayPal Payments ###

Onboarded: Yes
Shop country code: AU
PayPal card processing available in country: Yes
Pay Later messaging available in country: Yes
Vault enabled: Yes

### Square ###

Environment: Production
Tokenization Enabled: ?
Debug Mode: Off

### Action Scheduler ###

Complete: 3,742
Oldest: 2021-09-08 15:40:50 +1000
Newest: 2021-09-16 10:50:09 +1000

Pending: 8
Oldest: 2021-09-16 11:56:15 +1000
Newest: 2021-10-10 11:00:51 +1100

### Status report information ###

Generated at: 2021-09-16 11:08:33 +10:00

    Hello @heathervh ,

    Thanks for sharing the details.

    The product descriptions used to be updated when syncing up until about 2 weeks ago, now it doesn’t update at all, with scheduled sync or manual sync

    Can you please check what is selected as your system of record in the WooCommerce > Settings > Square page?

    According to the documentation, you need to select Square as the system of record so that WooCommerce update it’s product description. Check more on What Is a System of Record?

    I don’t see any errors related to syncing

    Can you please enable logging from WooCommerce > Settings > Square page and then try to manually sync the products?

    Then check the log from WooCommerce > Logs page and share the Square log with us.

    I see Square-Woocommerce renames images when syncing – is there a way to stop this as it’s bad for SEO. If I rename them on woocommerce, it then duplicates the images on the next sync.

    Can you please clarify and provide an example of the image rename when syncing?

    is there a better caching plugin that works well with this plugin?

    We do not have any specific recommendations for the caching plugins. However, make sure to follow these steps when configuring the caching plugins: https://docs.woocommerce.com/document/configuring-caching-plugins/

    You can also try to sync keeping your caching plugin deactivated to see if that was causing the problem.

    Let us know how it goes.

    Thank you ??

    Thread Starter heathervh

    (@heathervh)

    Hi, thanks for your message. Answers below:

    1. Square is set as my inventory of record

    2. I ran a manual sync and new products were imported. Log below. Interestingly I notice in the log that my missing descriptions are in the log (for example: Game Powder Naartjie”, but they are still not in my woocommerce products – so the issue seems to be between the sync and woocommerce?

    3. Images – once I upload an image to Square named “game_orange_newcastle-biltong-co.jpg”, after it has synced, the image appears on woocommerce as “original.jpg” or original-68.jpg etc. If I rename it on woocommerce – it duplicates the image on the next sync.

    4. I have removed my caching plugin completely, and disabled minify on WP-optimise

    Thread Starter heathervh

    (@heathervh)

    Sorry I can’t paste in the Square log here as everytime I do, it says I cannot submit a blank message

    Plugin Support Saravanan S, a11n

    (@simplysaru)

    Hi @heathervh,

    Are you able to share the logs via https://gist.github.com/ so that we can review the same and help you with this further?

    Thread Starter heathervh

    (@heathervh)

    https://gist.github.com/heathervh/627504a67c83384ca90cfa84fabb2c2a

    Hello @heathervh ,

    Thanks for sharing the log. However, it’s not clear yet why the description is not synced from Square.

    Can you please create a ticket on WooCommerce.com so that we can investigate it more closely? You may need to open an account before submitting the ticket.

    Please make sure to include this discussion link in the ticket details.

    Thank you.

    Thread Starter heathervh

    (@heathervh)

    Hi Rashed, unfortunately, tickets are only for people who have purchased extensions. I have posted on the support forum, but no responses yet.

    Hello @heathervh,

    unfortunately, tickets are only for people who have purchased extensions.

    The Square for WooCommerce plugin is free to download. So you should be able to open a ticket

    You contact us at WooCommerce.com > My Account > Support. You may need to create an account before you can access that page.

    Do you see any errors when trying to open a support ticket with us?

    If not, please include a link to this forum thread, so that we can keep track of what’s already been done.

    We will be able to help you further there.

    Kind regards,

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Woocommerce Square suddenly not syncing product description’ is closed to new replies.