• Resolved komalvashisht

    (@komalvashisht)


    Problem 1) My product catalogue was syncing and showing in Instagram already, I enabled Checkout from Instagram and suddenly ALL my items started showing as Out of Stock.

    Problem 2) To fix the problem 1) above, I triggered manual sync and its been 2 days since it is syncing itself, I have no option to stop it or try re-trigggering it.

    Please help ASAP, my shop is practically down at this time.

    Here’s the System Report:

    WordPress Environment
    
    WordPress address (URL): https://komalvashisht.com
    Site address (URL): https://komalvashisht.com
    WC Version: 7.4.1
    REST API Version: ? 7.4.1
    WC Blocks Version: ? 9.4.4
    Action Scheduler Version: ? 3.5.4
    Log Directory Writable: ?
    WP Version: 6.1.1
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: – Server Environment Server Info: LiteSpeed
    PHP Version: 7.4.32
    PHP Post Max Size: 256 MB
    PHP Time Limit: 60
    PHP Max Input Vars: 5000
    cURL Version: 7.71.0
    OpenSSL/1.1.1d SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.5.12-MariaDB-cll-lve
    Max Upload Size: 256 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ? Database WC Database Version: 7.4.1
    WC Database Prefix: wp_
    Total Database Size: 83.93MB
    Database Data Size: 72.04MB
    Database Index Size: 11.89MB
    wp_woocommerce_sessions: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 4.52MB + Index: 3.47MB + Engine InnoDB
    wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_logs: Data: 2.52MB + Index: 3.03MB + Engine InnoDB
    wp_aioseo_cache: Data: 0.09MB + Index: 0.03MB + Engine InnoDB
    wp_aioseo_notifications: Data: 0.14MB + Index: 0.06MB + Engine InnoDB
    wp_aioseo_posts: Data: 0.20MB + Index: 0.02MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_gla_budget_recommendations: Data: 0.22MB + Index: 0.14MB + Engine InnoDB
    wp_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_gla_shipping_rates: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_litespeed_url: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_litespeed_url_file: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_mailpoet_automations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mailpoet_automation_runs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_automation_run_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_automation_run_subjects: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_automation_triggers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mailpoet_automation_versions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mailpoet_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wp_mailpoet_scheduled_tasks: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_subscribers: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
    wp_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_subscriber_tag: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_tags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_options: Data: 9.38MB + Index: 0.17MB + Engine InnoDB
    wp_postmeta: Data: 19.48MB + Index: 1.72MB + Engine InnoDB
    wp_posts: Data: 29.44MB + Index: 0.31MB + Engine InnoDB
    wp_sbi_feeds: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_sbi_feed_caches: Data: 0.42MB + Index: 0.02MB + Engine InnoDB
    wp_sbi_instagram_feeds_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_sbi_instagram_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_sbi_instagram_posts: Data: 0.36MB + Index: 0.00MB + Engine InnoDB
    wp_sbi_sources: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_usermeta: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
    wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpforms_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_yoast_indexable: Data: 0.47MB + Index: 0.23MB + Engine InnoDB
    wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_yoast_seo_links: Data: 0.05MB + Index: 0.03MB + Engine InnoDB Post Type Counts attachment: 563
    custom_css: 2
    elementor_library: 6
    jp_img_sitemap: 3
    jp_sitemap: 3
    jp_sitemap_master: 3
    jp_vid_sitemap: 3
    mailpoet_page: 1
    nav_menu_item: 9
    omapi: 2
    page: 12
    post: 5
    product: 47
    product_variation: 13
    revision: 1118
    shop_order: 1
    shop_order_refund: 2
    wp_global_styles: 2
    wpcf7_contact_form: 1
    wpforms: 2 Security Secure connection (HTTPS): ?
    Hide errors from visitors: ? Active Plugins (19) Advanced Post Block: by bPlugins LLC – 1.8.3
    Contact Form 7: by Takayuki Miyoshi – 5.7.4
    Elementor: by Elementor.com – 3.11.4
    Facebook for WooCommerce: by Facebook – 3.0.14
    Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.11.0
    Google Listings and Ads: by WooCommerce – 2.4.0
    Smash Balloon Instagram Feed: by Smash Balloon – 6.1
    Jetpack: by Automattic – 11.9
    LiteSpeed Cache: by LiteSpeed Technologies – 5.3.3
    MailPoet: by MailPoet – 4.8.0
    Ocean Extra: by OceanWP – 2.1.4
    Ocean Social Sharing: by OceanWP – 2.0.2
    WooCommerce Stripe Gateway: by WooCommerce – 7.2.0
    WooCommerce Payments: by Automattic – 5.5.1
    WooCommerce Shipping & Tax: by WooCommerce – 2.2.3
    WooCommerce: by Automattic – 7.4.1
    Yoast SEO: by Team Yoast – 19.13
    WP Mail SMTP: by WPForms – 3.7.0
    WPForms Lite: by WPForms – 1.8.0.2 Inactive Plugins (1) All in One SEO: by All in One SEO Team – 4.2.8 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)
    subscription (subscription)
    variable (variable)
    variable subscription (variable-subscription) 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: –
    Order datastore: WC_Order_Data_Store_CPT WC Pages Shop base: #355 - /shop/
    Cart: #356 - /cart/
    Checkout: #357 - /checkout/
    My account: #358 - /my-account/
    Terms and conditions: ? Page not set Theme Name: OceanWP
    Version: 3.3.6 (update to version 3.4.2 is available)
    Author URL: https://oceanwp.org/about-oceanwp/
    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
    WooCommerce Support: ? Templates Overrides: oceanwp/woocommerce/cart/mini-cart.php
    oceanwp/woocommerce/content-single-product.php
    oceanwp/woocommerce/loop/loop-start.php
    oceanwp/woocommerce/single-product/title.php Subscriptions WCS_DEBUG: ? No
    Subscriptions Mode: ? Live
    Subscriptions Live URL: https://komalvashisht.com
    Subscriptions-core Library Version: 5.3.1
    Subscription Statuses: –
    WooCommerce Account Connected: ? Yes
    Active Product Key: ? No Store Setup Country / State: United States (US) — Illinois Subscriptions by Payment Gateway Payment Gateway Support Direct bank transfer: products
    Stripe: products
    refunds
    tokenization
    add_payment_method Admin Enabled Features: activity-panels
    analytics
    coupons
    customer-effort-score-tracks
    import-products-task
    experimental-fashion-sample-products
    shipping-smart-defaults
    shipping-setting-tour
    homescreen
    marketing
    multichannel-marketing
    mobile-app-banner
    navigation
    new-product-management-experience
    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
    product-variation-management
    settings Daily Cron: ? Next scheduled: 2023-03-13 04:19:27 +00:00
    Options: ?
    Notes: 101
    Onboarding: completed WooCommerce Payments Version: 5.5.1
    Connected to WPCOM: Yes
    Blog ID: 204742270
    Account ID: acct_1Kj79n2EDawVyghO Action Scheduler Complete: 8,373
    Oldest: 2023-02-11 19:00:59 +0000
    Newest: 2023-03-13 00:50:02 +0000 Failed: 1,575
    Oldest: 2022-12-01 00:18:09 +0000
    Newest: 2023-03-10 15:50:05 +0000 Pending: 7
    Oldest: 2023-03-13 00:52:02 +0000
    Newest: 2023-03-18 19:15:08 +0000 Status report information Generated at: 2023-03-13 00:50:21 +00:00
    `

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

Viewing 7 replies - 1 through 7 (of 7 total)
  • Hello,

    Sorry to hear about that.

    You can use the WP-Crontrol plugin to monitor your cron jobs, by checking the system report, it appears that many of them are either failed or pending:

    Failed: 1,575<br>Pending: 7

    Also, can you navigate under WooCommerce > System Status > Logs? (Please check if there is any error message being generated).

    Let us know what you find.

    Thread Starter komalvashisht

    (@komalvashisht)

    Thanks for the quick reply, is there a way I could attach these files for you? I don’t see an option here. I can paste them here, but these are big. Thanks!

    Hi @komalvashisht

    is there a way I could attach these files for you? I don’t see an option here. I can paste them here, but these are big. Thanks!

    You could paste it via https://gist.github.com/ and send the link here.

    Meanwhile, going back to your original query:

    My product catalogue was syncing and showing in Instagram already, I enabled Checkout from Instagram and suddenly ALL my items started showing as Out of Stock.

    Kindly be reminded that the Checkout with Facebook or Instagram option isn’t supported yet.

    Hope this helps!

    Thread Starter komalvashisht

    (@komalvashisht)

    Thanks, are you saying WordPress does not support Checkout with FB/ Insta or Woocommerce does not support yet. If its woocommerce, please suggest alternatives.

    Meanwhile here’re the logs you requested.

    Latest Log – https://gist.github.com/vaibhavvashisht/51ef76f487b2635fa754636fb47d2567

    Cron Job Logs – https://gist.github.com/vaibhavvashisht/d3f00352cfe431ed2e35ef6023eff6b3

    Hi,

    Thank you for sending the logs.

    ...I enabled Checkout from Instagram and suddenly ALL my items started showing as Out of Stock...

    Sorry to hear that, At this time, Instagram shopping/checkout support is not available. We recommend Instagram Shopping?if you will need your customers to check out from Instagram.

    With Instagram Shopping you can link an Instagram Business Account to the Facebook account, and sync products to the Facebook catalog. This catalog can be shared between these two platforms.

    To learn more, please refer to:?WooCommerce Instagram.

    Kind regards.

    Thread Starter komalvashisht

    (@komalvashisht)

    Thanks for your reply and recommendations, I have follow up question –

    So do I keep WooCommerce for the other platforms and my site that are tied to it and install “Instagram Shopping” for Insta? Will both co-exist or do I need to undo WooCommerce completely before.? TIA

    Hi @komalvashisht

    So do I keep WooCommerce for the other platforms and my site that are tied to it and install “Instagram Shopping” for Insta?

    Yes, you can use the Instagram Shopping extension if you need users to checkout from Instagram.

    Will both co-exist or do I need to undo WooCommerce completely before.?

    Yes again. No need to undo WooCommerce prior to installing the Instagram Shopping extension.

    Hope this helps!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Product Sync going on forever’ is closed to new replies.