Three products won’t sync

  • Resolved germars

    (@germars)


    1 year, 7 months ago

    Hello, I created 15 products and synced them all from square to WooCommerce. They all showed up but my client asked me to change the images in a couple of them. When I synced them again, I am missing three of the products. I’ve checked the SKU numbers, they are ok. I didn’t do anything apart from alter the images. I cannot figure out why they won’t update and show on the site. They did originally.
    WordPress, woocommerce and square are all up to date.
    A question though, two of the three have variations, but they are really two different coloured wine goblets. When I create these, only the two variations have SKUs, is that right? I have inventory in each of these. Other products that also have variations seem to be fine. And I can still have a main image and then an image for each of the variations?

    I can give you the Sytem Status Report, but for some reason when I went to the logs, I scrolled down to look at it and it disappeared and now I don’t have any logs. Very strange. I didn’t delete them, was only looking.

    I had also set the number of items to 19 somewhere, but now I cannot find where that was anywhere.

    Thank you for your help.

    Mary

    WordPress Environment

WordPress address (URL): https://firingtimepottery.com
    Site address (URL): https://firingtimepottery.com
    WC Version: 8.0.2
    REST API Version: ? 8.0.2
    WC Blocks Version: ? 10.6.5
    Action Scheduler Version: ? 3.6.1
    Log Directory Writable: ?
    WP Version: 6.3
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: ? Server Environment

Server Info: Apache
    PHP Version: 7.4.33
    PHP Post Max Size: 32 MB
    PHP Time Limit: 120
    PHP Max Input Vars: 3000
    cURL Version: 7.87.0
    OpenSSL/1.1.1p

SUHOSIN Installed: –
    MySQL Version: 10.5.21-MariaDB-cll-lve
    Max Upload Size: 32 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ? Database

WC Database Version: 8.0.2
    WC Database Prefix: wp6o_
    Total Database Size: 21.39MB
    Database Data Size: 17.41MB
    Database Index Size: 3.98MB
    wp6o_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp6o_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp6o_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp6o_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp6o_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp6o_woocommerce_order_itemmeta: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
    wp6o_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp6o_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp6o_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp6o_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp6o_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp6o_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp6o_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp6o_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp6o_actionscheduler_actions: Data: 2.02MB + Index: 1.16MB + Engine InnoDB
    wp6o_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp6o_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp6o_actionscheduler_logs: Data: 0.17MB + Index: 0.17MB + Engine InnoDB
    wp6o_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp6o_comments: Data: 0.08MB + Index: 0.04MB + Engine MyISAM
    wp6o_easywpsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp6o_easywpsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp6o_em_bookings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp6o_em_events: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp6o_em_locations: Data: 0.00MB + Index: 0.02MB + Engine MyISAM
    wp6o_em_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp6o_em_tickets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp6o_em_tickets_bookings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp6o_et_bloom_stats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp6o_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp6o_mappress_maps: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp6o_mappress_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp6o_mapp_maps: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp6o_ngg_album: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp6o_ngg_gallery: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp6o_ngg_pictures: Data: 0.71MB + Index: 0.06MB + Engine MyISAM
    wp6o_options: Data: 4.48MB + Index: 0.10MB + Engine MyISAM
    wp6o_postmeta: Data: 2.00MB + Index: 0.72MB + Engine MyISAM
    wp6o_posts: Data: 6.67MB + Index: 0.17MB + Engine MyISAM
    wp6o_termmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp6o_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp6o_term_relationships: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
    wp6o_term_taxonomy: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp6o_usermeta: Data: 0.07MB + Index: 0.02MB + Engine MyISAM
    wp6o_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp6o_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    wp6o_wc_admin_note_actions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
    wp6o_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp6o_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp6o_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp6o_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
    wp6o_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp6o_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp6o_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp6o_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp6o_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp6o_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp6o_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp6o_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp6o_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp6o_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp6o_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp6o_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp6o_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp6o_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp6o_woocommerce_square_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp6o_yoast_indexable: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
    wp6o_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp6o_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp6o_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp6o_yoast_seo_links: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
    wp6o_yoast_seo_meta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM Post Type Counts

attachment: 185
    custom_css: 1
    customize_changeset: 1
    display_type: 20
    et_pb_layout: 19
    event: 13
    event-recurring: 1
    location: 5
    nav_menu_item: 20
    ngg_album: 6
    ngg_gallery: 40
    ngg_pictures: 720
    oembed_cache: 4
    page: 30
    post: 44
    product: 46
    product_variation: 47
    project: 1
    revision: 303
    shop_order: 130
    wpsc_cart_orders: 23 Security

Secure connection (HTTPS): ?
    Hide errors from visitors: ? Active Plugins (13)

Bloom: by Elegant Themes – 1.3.12
    Classic Widgets: by WordPress Contributors – 0.3
    Divi Booster: by Dan Mossop – 4.2.9
    Docket Cache: by Nawawi Jamili – 23.08.01
    Easy WP SMTP: by Easy WP SMTP – 2.1.2
    MapPress Google Maps and Leaflet Maps: by Chris Richardson – 2.88.4
    NextGEN Plus: by Imagely – 1.13.0
    NextGEN Gallery: by Imagely – 3.37
    Simple Facebook Plugin: by topdevs.net – 1.5.1
    WooCommerce Square: by WooCommerce – 4.2.0
    WooCommerce: by Automattic – 8.0.2
    Yoast SEO: by Team Yoast – 21.0
    WP Super Cache: by Automattic – 1.10.0 Inactive Plugins (0) Dropin Plugins (3)

advanced-cache.php: advanced-cache.php
    maintenance.php: maintenance.php
    object-cache.php: Docket Cache Drop-in Must Use Plugins (1)

ET Support Center :: Must-Use Plugins Autoloader: by Elegant Themes – Settings

API Enabled: –
    Force SSL: –
    Currency: CAD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    variation (variation)

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: –
    Enforce Approved Product Download Directories: –
    HPOS feature screen enabled: –
    HPOS feature enabled: –
    Order datastore: WC_Order_Data_Store_CPT
    HPOS data sync enabled: – WC Pages

Shop base: #2527 - /shop/
    Cart: #2528 - /cart/
    Checkout: #2529 - /checkout/
    My account: #2530 - /my-account/
    Terms and conditions: ? Page not set Theme

Name: Divi Child Theme
    Version: 1.0.0
    Author URL: https://www.johncharlton.ca/
    Child Theme: ?
    Parent Theme Name: Divi
    Parent Theme Version: 4.22.1
    Parent Theme Author URL: https://www.elegantthemes.com
    WooCommerce Support: ? Templates

Overrides: – Square

Environment: Production
    Tokenization Enabled: –
    Debug Mode: Off Admin

Enabled Features: activity-panels
    analytics
    product-block-editor
    coupons
    core-profiler
    customer-effort-score-tracks
    import-products-task
    experimental-fashion-sample-products
    shipping-smart-defaults
    shipping-setting-tour
    homescreen
    marketing
    mobile-app-banner
    navigation
    onboarding
    onboarding-tasks
    remote-inbox-notifications
    remote-free-extensions
    payment-gateway-suggestions
    shipping-label-banner
    subscriptions
    store-alerts
    transient-notices
    woo-mobile-welcome
    wc-pay-promotion
    wc-pay-welcome-page

Disabled Features: minified-js
    new-product-management-experience
    product-variation-management
    settings
    async-product-editor-category-field

Daily Cron: ? Next scheduled: 2023-08-26 18:24:24 -04:00
    Options: ?
    Notes: 161
    Onboarding: completed Action Scheduler

Canceled: 1
    Oldest: 2023-07-30 20:22:24 -0400
    Newest: 2023-07-30 20:22:24 -0400

Complete: 4,552
    Oldest: 2023-07-25 16:28:49 -0400
    Newest: 2023-08-25 15:51:09 -0400

Failed: 9
    Oldest: 2023-02-15 00:30:49 -0500
    Newest: 2023-06-01 01:17:24 -0400

Pending: 4
    Oldest: 2023-08-25 16:47:27 -0400
    Newest: 2023-08-30 02:54:13 -0400 Status report information

Generated at: 2023-08-25 15:52:18 -04:00

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

Viewing 6 replies - 1 through 6 (of 6 total)
  • Saif

    (@babylon1999)

    Hello @germars,

    Thank you for reaching out!

    Could you please attach some screenshots so we can try replicating the issue?

    A question though, two of the three have variations, but they are really two different coloured wine goblets. When I create these, only the two variations have SKUs, is that right?

    I’m not sure if I understand that part properly, but if you’re asking if all variations need to have a unique SKU, then you’re correct. :?)

    I also trust you checked the sync guide at https://woocommerce.com/document/woocommerce-square/sync-settings/#section-5.

    Look forward to hearing back from you.

    Thread Starter germars

    (@germars)

    Thank you for looking at this. I’m going to include a screen shot of the categories and what is in them in Square/Woocommerce and what is showing in the preview for Divi/woocommerce, and then if you go to https://firingtimepottery.com/online-products/ you can see that only 12 show up. It seems to be the last three items which makes me think it is something about page numbers and items per page.
    I changed the number of items per page (somewhere, but I can’t find it now) to 18 at one point, thinking that may put them all on one page, but it didn’t, so I changed it back to 12, but I’m not getting the pagination now, and I don’t know where to find that either (if that is the issue)> Maybe I”ve done something so the last three (coincidentally) don’t show up?

    The other question was this (as I got myself a bit confused): If I create a product of the wine goblets, for example, I have two types one green and one blue. I’ve given those two variations SKU numbers, but there isn’t an sku for the overall product, right? You’ll notice in my list of items in Woocommerce that some items don’t show SKUs but they do have them in the variations if you open them up.

    Thank you for looking at this for me. How do I attach screenshots? Do I have to upload them to my website for you to see them?

    Thread Starter germars

    (@germars)

    Hello again, I’ve created a page with the list of products (in the category of online-products) as seen on Square,
    – another one with the items in WooCommerce
    – a preview image of what I see in the Divi/WooCommerce preview
    -and finally, what it showing on the site.

    https://firingtimepottery.com/square-woocommerce

    As I mentioned, I think it’s something to do with the pagination, but I can’t find where that is to see if it is on or off. And maybe you have another idea of why I can’t see those three items?
    Thank you.

    • This reply was modified 1 year, 7 months ago by germars.
    Saif

    (@babylon1999)

    Sorry for not mentioning this previously, you can upload the screenshots to something like Snipboard.

    Just to confirm, are the products being synced over to the back end in the All Products tab?

    If so, then all is good. The way the products are shown in the front end is determined by your theme and page builder. :?)

    I did a quick tourn in your site and seems like this is the WooCommerce-generated archive page: https://firingtimepottery.com/product-category/online-products/

    The page you attached https://firingtimepottery.com/online-products/ is a custom page, so I’m not really sure why it’s not including all the category items.

    If it was made with the Divi builder, you can get in touch with their support about this at https://www.elegantthemes.com/contact/

    Let us know if I misunderstood your request.

    Thread Starter germars

    (@germars)

    I keep seeing questions online about turning on and off the pagination. But the pagination section under woocommerce-settings-products doesn’t exist on any of my sites, DIVI or otherwise. I think this is the issue. Is that option somewhere? I can’t find it. I really think that this is the problem.

    Hi there @germars ??

    Thank you for reaching back, elaborating further on this!

    I keep seeing questions online about turning on and off the pagination. But the pagination section under woocommerce-settings-products doesn’t exist on any of my sites, DIVI or otherwise. I think this is the issue. Is that option somewhere? I can’t find it. I really think that this is the problem.

    Just to clarify, are you able to see all products in the screen at WordPress > Products > All Products (including the three you report missing), or otherwise?

    While investigating the site’s System Status Report (SSR), it appears that the product count is 46 (instead of the 15 you are reporting), and the product variations count is 47.

    Based on your comments about pagination, I understand that the issue at hand is products being available in the back-end but not displaying as expected in the front end. Could you clarify if that is the case, or otherwise, please?

    Looking forward to your response, cheers!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Three products won’t sync’ is closed to new replies.

Tags