Square not importin all products. Just a very small handful.

Hi @crobley!

Thank you for reaching out.

I understand you are having product syncing issues with Square; it is not syncing your entire catalog, correct?

If so, as a first step, let’s try the following to have some context:

1. Check the product SKU: Square and WooCommerce use SKUs as unique values, and they have to match between the two platforms. Kindly select a few products that are not syncing and check if they have an SKU. You can do this by going to Products > All Products, searching for the product you want, selecting the Quick Edit option, and looking if the SKU field has any information. If they don’t, please assign an SKU and check if the issue persists.
2. ?Enable Square logs: This could help us determine what could be going on with the product syncing. Please enable Square logging by going to WooCommerce > Settings > Square and activating the Enable Logging option. Once you do this, please try syncing your products with Square again to catch any issues in the logs. Then, go to WooCommerce > Status > Logs and search for the ones that start with only a square label in them, and kindly share them with us.

Thank you.

In the meantime, here are some other things to bear in mind if you are having syncing issues: https://woo.com/document/woocommerce-square/troubleshooting/#section-2

We will be looking for your response!

Thank you for the support!

I have quite a lot of categories within square – in one category (Dog Food) we have nearly 200 products. Only 4 items appear in Woocommerce.

Oddly enough, those 4 items that successfully imported do not have SKUs. Browsing through the list of all products I have imported (76 total) some have SKUs and others do not.

I just now enabled debug and ran the import again. Same result – imports 76 products.

There were a lot of logs – I think this is the most recent. Let me know if its helpful.

2024-03-12T00:38:36+00:00 NOTICE Starting step cycle: pull_inventory CONTEXT: {"_legacy":true}
2024-03-12T00:38:37+00:00 NOTICE Request
 Request
method:
uri: batchRetrieveInventoryCounts
user-agent: WooCommerce-Square/4.5.1 (WooCommerce/8.6.1; WordPress/6.4.3)
headers: Array
(
)
body:
duration: 0.16835s
 CONTEXT: {"_legacy":true}
2024-03-12T00:38:37+00:00 NOTICE Response
 Response
code: 200
message:
headers: Array
(
    [0] => HTTP/2 200
    [date] => Tue, 12 Mar 2024 00:38:37 GMT
    [content-type] => application/json
    [content-length] => 380
    [cf-ray] => 862fb8f1693f7c25-DEN
    [cf-cache-status] => DYNAMIC
    [content-encoding] => gzip
    [strict-transport-security] => max-age=631152000; includeSubDomains; preload
    [vary] => Origin, Accept-Encoding
    [square-version] => 2023-07-20
    [x-content-type-options] => nosniff
    [x-download-options] => noopen
    [x-envoy-decorator-operation] => /v2/inventory/**
    [x-frame-options] => SAMEORIGIN
    [x-permitted-cross-domain-policies] => none
    [x-speleo-traceid] => CDN-1ff85d75-2436-4541-bd10-b4dda35a8d83
    [x-sq-dc] => aws
    [x-sq-region] => us-west-2
    [x-xss-protection] => 1; mode=block
    [set-cookie] => __cf_bm=CL3LpdwXarbT2jTQd6nVTKqiGp_11EM9FwUhPPGwtQ8-1710203917-1.0.1.1-R0qCnTKIQtN0exesuFeVFI7Z6oXRPxN8weZIlb.VezM_heIwhvrofdUJBzDhTLeQ03ffTCUHM1TP3QbB9umlOA; path=/; expires=Tue, 12-Mar-24 01:08:37 GMT; domain=.connect.squareup.com; HttpOnly; Secure; SameSite=None
    [server] => cloudflare
)
body: {
    "counts": [
        {
            "catalog_object_id": "5ZK55AZ3RPGIVJURGAH6R7UA",
            "catalog_object_type": "ITEM_VARIATION",
            "state": "IN_STOCK",
            "location_id": "L4YHR14PBQNS7",
            "quantity": "0",
            "calculated_at": "2023-11-24T02:07:35.014Z"
        },
        {
            "catalog_object_id": "FTO55YRYUDZPGQUQYUBWOIB6",
            "catalog_object_type": "ITEM_VARIATION",
            "state": "IN_STOCK",
            "location_id": "L4YHR14PBQNS7",
            "quantity": "0",
            "calculated_at": "2023-11-24T02:07:34.926Z"
        },
        {
            "catalog_object_id": "I2EYNLJ7R3P5B5K7NK2FYNFP",
            "catalog_object_type": "ITEM_VARIATION",
            "state": "IN_STOCK",
            "location_id": "L4YHR14PBQNS7",
            "quantity": "2",
            "calculated_at": "2023-11-24T02:08:14.773Z"
        },
        {
            "catalog_object_id": "YFU6QG4RWCWS5DBU7WMB5B5F",
            "catalog_object_type": "ITEM_VARIATION",
            "state": "ORDERED_FROM_VENDOR",
            "location_id": "L4YHR14PBQNS7",
            "quantity": "16",
            "calculated_at": "2024-03-11T00:59:21.385Z"
        },
        {
            "catalog_object_id": "YFU6QG4RWCWS5DBU7WMB5B5F",
            "catalog_object_type": "ITEM_VARIATION",
            "state": "RETURNED_BY_CUSTOMER",
            "location_id": "L4YHR14PBQNS7",
            "quantity": "5",
            "calculated_at": "2023-11-18T19:33:09.836Z"
        },
        {
            "catalog_object_id": "YFU6QG4RWCWS5DBU7WMB5B5F",
            "catalog_object_type": "ITEM_VARIATION",
            "state": "IN_STOCK",
            "location_id": "L4YHR14PBQNS7",
            "quantity": "10",
            "calculated_at": "2024-03-12T00:22:23.274Z"
        }
    ]
}
 CONTEXT: {"_legacy":true}
2024-03-12T00:38:37+00:00 NOTICE Request
 Request
method:
uri: batchRetrieveCatalogObjects
user-agent: WooCommerce-Square/4.5.1 (WooCommerce/8.6.1; WordPress/6.4.3)
headers: Array
(
)
body:
duration: 0.16636s
 CONTEXT: {"_legacy":true}
2024-03-12T00:38:37+00:00 NOTICE Response
 Response
code: 200
message:
headers: Array
(
    [0] => HTTP/2 200
    [date] => Tue, 12 Mar 2024 00:38:37 GMT
    [content-type] => application/json
    [content-length] => 1268
    [cf-ray] => 862fb8f28c091f3d-DEN
    [cf-cache-status] => DYNAMIC
    [content-encoding] => gzip
    [strict-transport-security] => max-age=631152000; includeSubDomains; preload
    [vary] => Origin, Accept-Encoding
    [square-version] => 2023-07-20
    [x-content-type-options] => nosniff
    [x-download-options] => noopen
    [x-envoy-decorator-operation] => /v2/catalog/**
    [x-frame-options] => SAMEORIGIN
    [x-permitted-cross-domain-policies] => none
    [x-speleo-traceid] => CDN-55ace407-2791-4a94-be7b-aef64a54555e
    [x-sq-dc] => aws
    [x-sq-region] => us-west-2
    [x-xss-protection] => 1; mode=block
    [set-cookie] => __cf_bm=NN8BBz31AEB3FW1VnMUANQDwFcgKz1lNCILD_yBubWM-1710203917-1.0.1.1-XKHNo1cB5CW.VnLJyWKvlfA55lyZMFJdf3p3OXHwEDP12u2IzWB97Pwr05bbuggPCARPA_4D15LqUgwzB1rJ8g; path=/; expires=Tue, 12-Mar-24 01:08:37 GMT; domain=.connect.squareup.com; HttpOnly; Secure; SameSite=None
    [server] => cloudflare
)
body: {
    "objects": [
        {
            "type": "ITEM_VARIATION",
            "id": "YFU6QG4RWCWS5DBU7WMB5B5F",
            "updated_at": "2024-02-07T03:27:52.539Z",
            "version": 1707276472539,
            "is_deleted": false,
            "custom_attribute_values": {
                "Square:bc32d433-db82-426e-b4ae-f5b9a89c596e": {
                    "name": "Markup",
                    "string_value": "38%",
                    "custom_attribute_definition_id": "OUEVXQ32U6QGC7TKHI43LF3L",
                    "type": "STRING",
                    "key": "Square:bc32d433-db82-426e-b4ae-f5b9a89c596e"
                }
            },
            "present_at_all_locations": false,
            "present_at_location_ids": [
                "L4YHR14PBQNS7"
            ],
            "item_variation_data": {
                "item_id": "JK4UIZQBVPGT7DJIXZQ5ORYL",
                "name": "",
                "sku": "800400637721",
                "ordinal": 1,
                "pricing_type": "FIXED_PRICING",
                "price_money": {
                    "amount": 2050,
                    "currency": "USD"
                },
                "location_overrides": [
                    {
                        "location_id": "L4YHR14PBQNS7",
                        "track_inventory": true,
                        "inventory_alert_type": "NONE",
                        "inventory_alert_threshold": 19
                    }
                ],
                "track_inventory": true,
                "inventory_alert_type": "NONE",
                "sellable": true,
                "stockable": true,
                "item_variation_vendor_info_ids": [
                    "6U5L3MO77Z63JBIE5TYLZBOS"
                ]
            }
        },
        {
            "type": "ITEM_VARIATION",
            "id": "I2EYNLJ7R3P5B5K7NK2FYNFP",
            "updated_at": "2023-12-16T18:19:35.871Z",
            "version": 1702750775871,
            "is_deleted": false,
            "custom_attribute_values": {
                "Square:bc32d433-db82-426e-b4ae-f5b9a89c596e": {
                    "name": "Markup",
                    "string_value": "\/.5",
                    "custom_attribute_definition_id": "OUEVXQ32U6QGC7TKHI43LF3L",
                    "type": "STRING",
                    "key": "Square:bc32d433-db82-426e-b4ae-f5b9a89c596e"
                }
            },
            "present_at_all_locations": false,
            "present_at_location_ids": [
                "L4YHR14PBQNS7"
            ],
            "item_variation_data": {
                "item_id": "ME3AUGFADYONXK3WOQO7NFWZ",
                "name": "",
                "sku": "010279105849",
                "ordinal": 1,
                "pricing_type": "FIXED_PRICING",
                "price_money": {
                    "amount": 1699,
                    "currency": "USD"
                },
                "location_overrides": [
                    {
                        "location_id": "L4YHR14PBQNS7",
                        "track_inventory": true
                    }
                ],
                "sellable": true,
                "stockable": true,
                "item_variation_vendor_info_ids": [
                    "MRLYLXPXDBJN6IUEQC4ADW77"
                ]
            }
        },
        {
            "type": "ITEM_VARIATION",
            "id": "FTO55YRYUDZPGQUQYUBWOIB6",
            "updated_at": "2023-10-05T17:19:13.05Z",
            "version": 1696526353050,
            "is_deleted": false,
            "present_at_all_locations": false,
            "present_at_location_ids": [
                "L4YHR14PBQNS7"
            ],
            "item_variation_data": {
                "item_id": "ISVH3VFW2JCJL777NBVUNWVB",
                "name": "Grey with Red",
                "sku": "076484648069",
                "ordinal": 3,
                "pricing_type": "FIXED_PRICING",
                "price_money": {
                    "amount": 2250,
                    "currency": "USD"
                },
                "location_overrides": [
                    {
                        "location_id": "L4YHR14PBQNS7",
                        "track_inventory": true,
                        "sold_out": true
                    }
                ],
                "track_inventory": true,
                "sellable": true,
                "stockable": true,
                "image_ids": [
                    "C5N4A5SHWDGJQSW7XSHD2M7N"
                ],
                "item_variation_vendor_info_ids": [
                    "S63SVQRRDDQZGPGBNZB3KF7Q"
                ]
            }
        },
        {
            "type": "ITEM_VARIATION",
            "id": "5ZK55AZ3RPGIVJURGAH6R7UA",
            "updated_at": "2023-10-05T17:19:13.05Z",
            "version": 1696526353050,
            "is_deleted": false,
            "present_at_all_locations": false,
            "present_at_location_ids": [
                "L4YHR14PBQNS7"
            ],
            "item_variation_data": {
                "item_id": "ISVH3VFW2JCJL777NBVUNWVB",
                "name": "Grey with Blue",
                "sku": "076484648052",
                "ordinal": 4,
                "pricing_type": "FIXED_PRICING",
                "price_money": {
                    "amount": 2250,
                    "currency": "USD"
                },
                "location_overrides": [
                    {
                        "location_id": "L4YHR14PBQNS7",
                        "track_inventory": true,
                        "sold_out": true
                    }
                ],
                "track_inventory": false,
                "sellable": true,
                "stockable": true,
                "image_ids": [
                    "WDBHU5PC4T2MXSEV25CLOS7E"
                ],
                "item_variation_vendor_info_ids": [
                    "52PPFKNLVWLHRSXBUUQFUH5J"
                ]
            }
        }
    ]
}
 CONTEXT: {"_legacy":true}
2024-03-12T00:38:37+00:00 NOTICE Completed step cycle: pull_inventory (0.51s) CONTEXT: {"_legacy":true}
2024-03-12T00:38:37+00:00 NOTICE Starting step cycle: pull_inventory CONTEXT: {"_legacy":true}
2024-03-12T00:38:37+00:00 NOTICE Completed job step: pull_inventory (Synced products: 128) CONTEXT: {"_legacy":true}
2024-03-12T00:38:37+00:00 NOTICE Completed step cycle: pull_inventory (0.01s) CONTEXT: {"_legacy":true}
2024-03-12T00:41:19+00:00 NOTICE Request
 Request
method:
uri: listLocations
user-agent: WooCommerce-Square/4.5.1 (WooCommerce/8.6.1; WordPress/6.4.3)
headers: Array
(
)
body:
duration: 0.19478s
 CONTEXT: {"_legacy":true}
2024-03-12T00:41:19+00:00 NOTICE Response
 Response
code: 200
message:
headers: Array
(
    [0] => HTTP/2 200
    [date] => Tue, 12 Mar 2024 00:41:19 GMT
    [content-type] => application/json
    [content-length] => 664
    [cf-ray] => 862fbce90f0b1f35-DEN
    [cf-cache-status] => DYNAMIC
    [content-encoding] => gzip
    [strict-transport-security] => max-age=631152000; includeSubDomains; preload
    [vary] => Accept-Encoding
    [frame-options] => DENY
    [square-version] => 2023-07-20
    [squareup--connect--v2--common--versionmetadata-bin] => CgoyMDIzLTA3LTIw
    [x-content-type-options] => nosniff
    [x-envoy-decorator-operation] => /v2/locations
    [x-frame-options] => DENY
    [x-sq-dc] => aws
    [x-sq-region] => us-west-2
    [x-xss-protection] => 1; mode=block
    [set-cookie] => __cf_bm=GKkZ05Q4YkURsws5o.8STj0ulF4QbagXC1445X31u6I-1710204079-1.0.1.1-4u.T2uHxLmQLgf5wLBBvfA3JQjndH.bpMHPfa4X3Voo793TsBuJGC9POXudFr4E56qHJmjzomwAA8kepBZmSYg; path=/; expires=Tue, 12-Mar-24 01:11:19 GMT; domain=.connect.squareup.com; HttpOnly; Secure; SameSite=None
    [server] => cloudflare
)
body: {
    "locations": [
        {
            "id": "L4YHR14PBQNS7",
            "name": "Eastern Sierra Feed",
            "address": {
                "address_line_1": "1245 Waterloo Ln",
                "locality": "Gardnerville",
                "administrative_district_level_1": "NV",
                "postal_code": "89410-7348",
                "country": "US"
            },
            "timezone": "America\/Los_Angeles",
            "capabilities": [
                "CREDIT_CARD_PROCESSING",
                "AUTOMATIC_TRANSFERS"
            ],
            "status": "ACTIVE",
            "created_at": "2023-03-21T18:22:45.798Z",
            "merchant_id": "MLMRWVF3RQX1X",
            "country": "US",
            "language_code": "en-US",
            "currency": "USD",
            "phone_number": "+1 775-782-3143",
            "business_name": "Eastern Sierra Feed",
            "type": "PHYSICAL",
            "website_url": "www.easternsierrafeed.com",
            "business_hours": {
                "periods": [
                    {
                        "day_of_week": "MON",
                        "start_local_time": "08:30:00",
                        "end_local_time": "17:30:00"
                    },
                    {
                        "day_of_week": "TUE",
                        "start_local_time": "08:30:00",
                        "end_local_time": "17:30:00"
                    },
                    {
                        "day_of_week": "WED",
                        "start_local_time": "08:30:00",
                        "end_local_time": "17:30:00"
                    },
                    {
                        "day_of_week": "THU",
                        "start_local_time": "08:30:00",
                        "end_local_time": "17:30:00"
                    },
                    {
                        "day_of_week": "FRI",
                        "start_local_time": "08:30:00",
                        "end_local_time": "17:30:00"
                    },
                    {
                        "day_of_week": "SAT",
                        "start_local_time": "08:30:00",
                        "end_local_time": "17:00:00"
                    }
                ]
            },
            "instagram_username": "easternsierrafeed",
            "coordinates": {
                "latitude": 38.9319169999999985520844347774982452392578125,
                "longitude": -119.7483490000000045938577386550605297088623046875
            },
            "logo_url": "https:\/\/square-web-production-f.squarecdn.com\/files\/ee215e7c342acefe3cf5076dda347c80c3fac44b\/original.png",
            "mcc": "5995"
        }
    ]
}
 CONTEXT: {"_legacy":true}

Hey @crobley,

Thank you for sharing the logs and additional details; they are indeed helpful.

From the logs, it’s clear that the sync is working as it should, but it’s not pulling all the products for some reason.

Seeing that some products without SKUs are syncing, it might be worth checking if there’s any pattern or common factor among the products that are not syncing. For example, check if they all belong to a specific category, if they all have a specific attribute, etc.

Also, it’s worth noting that WooCommerce Square syncs products based on the SKU, and if multiple products have the same SKU, it can cause issues. Please ensure that all your products have unique SKUs.

To further troubleshoot the issue, please disconnect and reconnect your Square account and try importing the product again.

In the meantime, please continue to share any additional information or observations that might help us troubleshoot this issue.

Looking forward to resolving this issue for you.

So I compared a few products side by side. Each has a unique SKU, they both have 2 variations. One didn’t have a vendor name while the other did. I changed it so they both had the same vendor name and synced. Nothing.

I really tried to analyze all the other factors and cant seem to find a common disconnect between the products that do appear and the products that don’t.

I then disconnected and reconnected Square and synced and got the same thing. Not totally sure what the best next move is but I really appreciate the help.

Hi @crobley,

Thank you for the additional details. This is certainly unusual; the importer should bring all the products that have their unique SKU not existing in WooCommerce. If you’ve confirmed the products in Square have unique SKUs and those do not exist in WooCommerce yet, then my theory is that something external could be interfering with this import process.

I’d like to understand your site properly. Please share with us the necessary information below for us to investigate the issue further:

• System Status Report which you can find via WooCommerce > Status > Get system report > Copy for support.
• Fatal error logs (if any) under WooCommerce > Status > Logs.

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

Once we have more information, we’ll be able to assist you further.

Thanks!

Thank you!

Fatal Report (from a few days ago)

2024-03-11T17:46:20+00:00 Critical Maximum execution time of 60 seconds exceeded  
Additional context
{
    "error": {
        "type": 1,
        "file": "\/home4\/etmdcsmy\/public_html\/wp-includes\/class-wp-image-editor-imagick.php",
        "line": 888
    },
    "backtrace": [
        {
            "file": "\/home4\/etmdcsmy\/public_html\/wp-content\/plugins\/woocommerce\/includes\/class-woocommerce.php",
            "line": 324,
            "function": "critical",
            "class": "WC_Logger",
            "type": "->"
        },
        {
            "function": "log_errors",
            "class": "WooCommerce",
            "type": "->"
        }
    ]
}

Woo System Report:

`
### WordPress Environment ###

WordPress address (URL): https://thedogandponystore.com
Site address (URL): https://thedogandponystore.com
WC Version: 8.6.1
REST API Version: ? 8.6.1
WC Blocks Version: ? 11.8.0-dev
Action Scheduler Version: ? 3.7.1
Log Directory Writable: ?
WP Version: 6.4.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: 8.3.3
PHP Post Max Size: 516 MB
PHP Time Limit: 60
PHP Max Input Vars: 1000
cURL Version: 8.6.0
OpenSSL/1.1.1w

SUHOSIN Installed: –
MySQL Version: 5.7.23-23
Max Upload Size: 512 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 8.6.1
WC Database Prefix: dxY_
Total Database Size: 16.73MB
Database Data Size: 12.85MB
Database Index Size: 3.88MB
dxY_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dxY_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dxY_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dxY_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
dxY_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dxY_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dxY_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
dxY_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dxY_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
dxY_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dxY_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
dxY_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dxY_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dxY_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dxY_actionscheduler_actions: Data: 0.31MB + Index: 0.58MB + Engine InnoDB
dxY_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dxY_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dxY_actionscheduler_logs: Data: 0.22MB + Index: 0.17MB + Engine InnoDB
dxY_ce4wp_abandoned_checkout: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dxY_ce4wp_contacts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dxY_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dxY_comments: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
dxY_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
dxY_gla_budget_recommendations: Data: 0.19MB + Index: 0.14MB + Engine InnoDB
dxY_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
dxY_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dxY_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dxY_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dxY_nfd_data_event_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
dxY_options: Data: 4.08MB + Index: 0.09MB + Engine InnoDB
dxY_postmeta: Data: 1.52MB + Index: 0.61MB + Engine InnoDB
dxY_posts: Data: 1.52MB + Index: 0.13MB + Engine InnoDB
dxY_revslider_css: Data: 0.13MB + Index: 0.02MB + Engine InnoDB
dxY_revslider_css_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dxY_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
dxY_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
dxY_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
dxY_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
dxY_revslider_sliders: Data: 0.30MB + Index: 0.02MB + Engine InnoDB
dxY_revslider_sliders_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dxY_revslider_slides: Data: 2.41MB + Index: 0.02MB + Engine InnoDB
dxY_revslider_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dxY_revslider_static_slides: Data: 0.13MB + Index: 0.02MB + Engine InnoDB
dxY_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dxY_social_users: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dxY_termmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
dxY_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dxY_term_relationships: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
dxY_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dxY_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dxY_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
dxY_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
dxY_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
dxY_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
dxY_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dxY_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dxY_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
dxY_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dxY_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
dxY_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dxY_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dxY_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
dxY_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
dxY_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dxY_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dxY_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dxY_wc_product_meta_lookup: Data: 0.03MB + Index: 0.09MB + Engine InnoDB
dxY_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dxY_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
dxY_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dxY_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dxY_woocommerce_square_customers: Data: 0.38MB + Index: 0.00MB + Engine InnoDB
dxY_wpforms_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
dxY_wpforms_payments: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
dxY_wpforms_payment_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
dxY_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
dxY_yith_wcwl: Data: 0.08MB + Index: 0.05MB + Engine InnoDB
dxY_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dxY_yoast_indexable: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
dxY_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
dxY_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dxY_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dxY_yoast_seo_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

### Post Type Counts ###

attachment: 170
blocks: 8
customize_changeset: 3
featured_item: 8
nav_menu_item: 38
page: 79
post: 11
product: 134
product_variation: 69
revision: 68
ux_template: 2
wp_navigation: 1
wpcf7_contact_form: 5

### Security ###

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

### Active Plugins (14) ###

The Bluehost Plugin: by Bluehost – 3.9.1
Contact Form 7: by Takayuki Miyoshi – 5.9.2
Google Listings and Ads: by WooCommerce – 2.6.2
Nextend Social Login: by Nextendweb – 3.1.13
Pinterest for WooCommerce: by WooCommerce – 1.3.23
Slider Revolution Mousetrap Add-On: by ThemePunch – 3.1.0
Slider Revolution Particles Effect: by ThemePunch – 3.3.3
Slider Revolution Transitionpack Add-On: by ThemePunch – 1.0.6
Slider Revolution: by ThemePunch – 6.6.20
TikTok: by TikTok – 1.2.4
WooCommerce Shipping & Tax: by WooCommerce – 2.5.3
WooCommerce Square: by WooCommerce – 4.5.1
WooCommerce: by Automattic – 8.6.1
YITH WooCommerce Wishlist: by YITH – 3.30.0

### Inactive Plugins (8) ###

Akismet Anti-spam: Spam Protection: by Automattic - Anti-spam Team – 5.3.1
Creative Mail by Newfold Digital: by Newfold Digital – 1.6.7
Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.25.0
Hello Dolly: by Matt Mullenweg – 1.7.2
Jetpack: by Automattic – 13.2
OptinMonster: by OptinMonster Popup Builder Team – 2.16.0
WPForms Lite: by WPForms – 1.8.7.2
Yoast SEO: by Team Yoast – 22.2

### Must Use Plugins (2) ###

Endurance Page Cache: by Mike Hansen – 2.2
SSO: by Garth Mortensen
Mike Hansen – 0.4


### 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)
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 Woo.com: –
Enforce Approved Product Download Directories: ?
HPOS feature screen enabled: ?
HPOS feature enabled: ?
Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore
HPOS data sync enabled: –

### WC Pages ###

Shop base: #9 - /shop/
Cart: #10 - /cart/
Checkout: #11 - /checkout/
My account: #12 - /my-account/
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.18.4
Parent Theme Author URL: https://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/cart/mini-cart.php
flatsome/woocommerce/checkout/form-checkout.php
flatsome/woocommerce/checkout/form-coupon.php
flatsome/woocommerce/checkout/order-received.php
flatsome/woocommerce/checkout/terms.php
flatsome/woocommerce/checkout/thankyou.php
flatsome/woocommerce/content-product-cat.php
flatsome/woocommerce/content-product.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/rating.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


### Cash App Pay (Square) ###

Environment: Production
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
product-variation-management
product-virtual-downloadable
product-external-affiliate
product-grouped
product-linked
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: customize-store
minified-js
new-product-management-experience
product-pre-publish-modal
settings
async-product-editor-category-field

Daily Cron: ? Next scheduled: 2024-03-13 00:17:23 +00:00
Options: ?
Notes: 73
Onboarding: completed

### Action Scheduler ###

Complete: 1,022
Oldest: 2024-02-29 11:26:21 +0000
Newest: 2024-03-12 19:24:55 +0000

Failed: 2
Oldest: 2024-03-05 00:18:27 +0000
Newest: 2024-03-11 17:44:26 +0000

Pending: 6
Oldest: 2024-03-12 19:44:36 +0000
Newest: 2024-03-19 15:41:42 +0000


### Status report information ###

Generated at: 2024-03-12 19:40:20 +00:00
`

Hey, @crobley!

The fatal error you shared is regarding the maximum execution time being exceeded.

You can try increasing the maximum execution time in your PHP configuration to allow WordPress more time to process things. This can usually be done by modifying the max_execution_time directive in your php.ini file or by using a .htaccess file. However, if you’re on a shared hosting environment, you may need to contact your hosting provider for assistance with this.

Regarding the importing issue, ?Is the Square product assigned to the Location that’s configured in the plugin settings??This plugin only supports one Square Location, so if some products aren’t syncing as expected, double-check to ensure they are in the same Square Location as defined in the plugin settings.

Also, do the products that are not being synced have multiple categories or attributes?

Looking forward to your reply.

Have a wonderful day!

Hi there ?? ,

We haven’t heard from you in a while; this is to check if you’ve been able to proceed with the troubleshooting steps provided before and if you still need help.

Thanks!
-OP