Unable to import/sync products

  • Resolved underclass

    (@underclass)


    5 years, 2 months ago

    I’m having trouble importing any products into my site from square. It appears tha the connection is ok in my logs, where customer info seems to be being scraped, but I am unable to import any products.

    https://controlc.com/e62e3b7d

    SKU, location etc is setup. going to the Update page shows the sync to be active but perpetually hangs in a loading state.

    
### WordPress Environment ###

WordPress address (URL): https://thebreadandroses.coop
Site address (URL): https://thebreadandroses.coop
WC Version: 3.8.1
REST API Version: ? 1.0.2
Log Directory Writable: ?
WP Version: 5.3.2
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ?
Language: en_GB
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.1
PHP Post Max Size: 512 MB
PHP Time Limit: 300
PHP Max Input Vars: 2500
cURL Version: 7.65.0
OpenSSL/1.0.2k-fips

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.2.26-MariaDB-log
Max Upload Size: 128 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.8.1
WC Database Prefix: wp_
Total Database Size: 12.74MB
Database Data Size: 10.99MB
Database Index Size: 1.75MB
wp_woocommerce_sessions: Data: 1.02MB + 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_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
wp_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_options: Data: 3.05MB + Index: 0.08MB + Engine InnoDB
wp_postmeta: Data: 0.36MB + Index: 0.25MB + Engine InnoDB
wp_posts: Data: 5.47MB + Index: 0.23MB + Engine InnoDB
wp_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_social_users: Data: 0.02MB + Index: 0.02MB + 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.05MB + Index: 0.02MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + 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_meta_lookup: Data: 0.02MB + Index: 0.09MB + 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_woocommerce_square_customers: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wp_yoast_seo_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

### Security ###

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

### Active Plugins (20) ###

Akismet Anti-Spam: by Automattic – 4.1.3
Classic Editor: by WordPress Contributors – 1.5
Conditional Menus: by Themify – 1.1.6
Contact Form 7: by Takayuki Miyoshi – 5.1.6
Cookie Notice: by dFactory – 1.2.50
Envato Market: by Envato – 2.0.3
Simple Calendar: by Simple Calendar – 3.1.22
Jetpack by WordPress.com: by Automattic – 8.1
Mailchimp for WooCommerce: by Mailchimp – 2.3.1
Nextend Social Login: by Nextendweb – 3.0.20
Simple Page Ordering: by Jake Goldman
10up – 2.3.2

WooCommerce Admin: by WooCommerce – 0.24.0
WooCommerce PayPal Checkout Gateway: by WooCommerce – 1.6.18
WooCommerce Services: by Automattic – 1.22.2
WooCommerce Square: by WooCommerce – 2.0.8
WooCommerce: by Automattic – 3.8.1
WooSidebars - Sidebar Manager to WooSidebars Converter: by WooThemes – 1.1.3
WooSidebars: by WooCommerce – 1.4.5
Yoast SEO: by Team Yoast – 12.8.1
YITH WooCommerce Wishlist: by YITH – 3.0.5

### Inactive Plugins (1) ###

Contact Form 7 Captcha: by 247wd – 0.0.3

### Settings ###

API Enabled: –
Force SSL: –
Currency: GBP (￡)
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: ? Page visibility should be public
Basket: ? Page visibility should be public
Checkout: ? Page visibility should be public
My account: ? Page visibility should be public
Terms and conditions: ? Page not set

### Theme ###

Name: Flatsome Child
Version: 3.0
Author URL: 
Child Theme: ?
Parent Theme Name: Flatsome
Parent Theme Version: 3.10.1
Parent Theme Author URL: https://www.uxthemes.com/
WooCommerce Support: ?

### Templates ###

Overrides: flatsome/woocommerce/archive-product.php
flatsome/woocommerce/cart/cart-empty.php
flatsome/woocommerce/cart/cart-shipping.php
flatsome/woocommerce/cart/cart.php
flatsome/woocommerce/checkout/form-checkout.php
flatsome/woocommerce/checkout/form-coupon.php
flatsome/woocommerce/checkout/terms.php
flatsome/woocommerce/checkout/thankyou.php
flatsome/woocommerce/content-product.php
flatsome/woocommerce/content-product_cat.php
flatsome/woocommerce/content-single-product.php
flatsome/woocommerce/content-widget-product.php
flatsome/woocommerce/global/breadcrumb.php
flatsome/woocommerce/global/quantity-input.php
flatsome/woocommerce/global/wrapper-end.php
flatsome/woocommerce/global/wrapper-start.php
flatsome/woocommerce/loop/loop-end.php
flatsome/woocommerce/loop/loop-start.php
flatsome/woocommerce/loop/pagination.php
flatsome/woocommerce/loop/result-count.php
flatsome/woocommerce/loop/sale-flash.php
flatsome/woocommerce/myaccount/form-login.php
flatsome/woocommerce/myaccount/navigation.php
flatsome/woocommerce/notices/error.php
flatsome/woocommerce/notices/notice.php
flatsome/woocommerce/notices/success.php
flatsome/woocommerce/product-searchform.php
flatsome/woocommerce/single-product/photoswipe.php
flatsome/woocommerce/single-product/price.php
flatsome/woocommerce/single-product/product-image.php
flatsome/woocommerce/single-product/product-thumbnails.php
flatsome/woocommerce/single-product/rating.php
flatsome/woocommerce/single-product/related.php
flatsome/woocommerce/single-product/review.php
flatsome/woocommerce/single-product/sale-flash.php
flatsome/woocommerce/single-product/share.php
flatsome/woocommerce/single-product/short-description.php
flatsome/woocommerce/single-product/tabs/tabs.php
flatsome/woocommerce/single-product/title.php
flatsome/woocommerce/single-product/up-sells.php
flatsome/woocommerce/single-product-reviews.php
flatsome/woocommerce/single-product.php

### Square ###

Environment: Production
Tokenization Enabled: –
Debug Mode: Save to Log

### Action Scheduler ###

Complete: 268
Oldest: 2019-12-21 10:14:00 +0000
Newest: 2020-01-21 09:06:33 +0000

Pending: 2
Oldest: 2020-01-21 10:06:33 +0000
Newest: 2020-01-27 22:06:34 +0000

Canceled: 2
Oldest: 2020-01-21 11:55:16 +0000
Newest: 2020-01-27 20:59:02 +0000

In-progress: 0
Oldest: –
Newest: –

Failed: 0
Oldest: –
Newest: –
    • This topic was modified 5 years, 2 months ago by underclass.
Viewing 3 replies - 1 through 3 (of 3 total)

  • Hi there @underclass,

    SKU, location etc is setup. going to the Update page shows the sync to be active but perpetually hangs in a loading state.

    I’m sorry to hear that you’re having issues with Square sync!

    Can you please advise what happens if you click Import products from Square in WooCommerce > Settings > Square?

    Does that create any products?

    Thread Starter underclass

    (@underclass)

    My host has helped me investigate the issue, and it looks to be a timeout error on the requests to the API in square.

    Do you know the usual request time needed, we’re erroring at 5 seconds at the moment, and the plugin seems to be making the request more than once, is this normal?

    Hi there @underclass,

    My host has helped me investigate the issue, and it looks to be a timeout error on the requests to the API in square.

    We’re very much interested in looking at the logs that your host has provided to you in order to come to such a conclusion.

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

    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. Meanwhile, I’ll close this thread and we’ll keep the communication via a ticket.

    Cheers!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Unable to import/sync products’ is closed to new replies.