Updated to 2.2.0 and now can’t import/sync

  • Resolved kegobeer

    (@kegobeer)


    4 years, 6 months ago

    I performed a manual import and pulled a new product from my Square account to my WooCommerce installation and it worked perfectly. Then, I updated to version 2.2.0, and a few minutes later I did another import to get a brand new item just loaded to my Square account. Unfortunately it is now stuck in a sync loop. Here is the log information that shows the previous completed import/sync and the new and failing import/sync:

    08-31-2020 @ 15:59:10 - Starting step cycle: update_category_data
08-31-2020 @ 15:59:10 - Completed job step: update_category_data
08-31-2020 @ 15:59:10 - Completed step cycle: update_category_data (0.26s)
08-31-2020 @ 15:59:11 - Starting step cycle: update_product_data
08-31-2020 @ 15:59:11 - Completed job step: update_product_data
08-31-2020 @ 15:59:11 - Completed step cycle: update_product_data (0.62s)
08-31-2020 @ 15:59:12 - Starting step cycle: update_inventory_counts
08-31-2020 @ 15:59:13 - Completed job step: update_inventory_counts
08-31-2020 @ 15:59:13 - Completed step cycle: update_inventory_counts (0.32s)
08-31-2020 @ 16:02:32 - Starting step cycle: import_products
08-31-2020 @ 16:02:34 - Imported Products Count: 0
08-31-2020 @ 16:02:34 - Completed step cycle: import_products (2.64s)
08-31-2020 @ 16:02:35 - Starting step cycle: import_products
08-31-2020 @ 16:02:37 - Imported Products Count: 0
08-31-2020 @ 16:02:37 - Completed step cycle: import_products (1.80s)
08-31-2020 @ 16:02:38 - Starting step cycle: import_products
08-31-2020 @ 16:02:39 - Imported Products Count: 0
08-31-2020 @ 16:02:39 - Completed step cycle: import_products (1.82s)
08-31-2020 @ 16:02:40 - Starting step cycle: import_products
08-31-2020 @ 16:02:43 - Imported Products Count: 0
08-31-2020 @ 16:02:43 - Completed step cycle: import_products (2.58s)
08-31-2020 @ 16:02:44 - Starting step cycle: import_products
08-31-2020 @ 16:02:48 - Imported Products Count: 1
08-31-2020 @ 16:02:48 - Completed job step: import_products
08-31-2020 @ 16:02:48 - Completed step cycle: import_products (4.05s)
08-31-2020 @ 16:02:48 - Starting step cycle: import_inventory
08-31-2020 @ 16:02:49 - Completed step cycle: import_inventory (0.84s)
08-31-2020 @ 16:02:50 - Starting step cycle: import_inventory
08-31-2020 @ 16:02:51 - Completed step cycle: import_inventory (1.13s)
08-31-2020 @ 16:02:52 - Starting step cycle: import_inventory
08-31-2020 @ 16:02:54 - Completed step cycle: import_inventory (1.63s)
08-31-2020 @ 16:02:54 - Starting step cycle: import_inventory
08-31-2020 @ 16:02:56 - Completed step cycle: import_inventory (1.42s)
08-31-2020 @ 16:02:57 - Starting step cycle: import_inventory
08-31-2020 @ 16:02:59 - Completed step cycle: import_inventory (1.97s)
08-31-2020 @ 16:02:59 - Starting step cycle: import_inventory
08-31-2020 @ 16:03:02 - Completed step cycle: import_inventory (2.84s)
08-31-2020 @ 16:03:04 - Starting step cycle: import_inventory
08-31-2020 @ 16:03:07 - Completed step cycle: import_inventory (2.65s)
08-31-2020 @ 16:03:07 - Starting step cycle: import_inventory
08-31-2020 @ 16:03:10 - Completed step cycle: import_inventory (2.63s)
08-31-2020 @ 16:03:11 - Starting step cycle: import_inventory
08-31-2020 @ 16:03:13 - Completed step cycle: import_inventory (2.32s)
08-31-2020 @ 16:03:14 - Starting step cycle: import_inventory
08-31-2020 @ 16:03:16 - Completed step cycle: import_inventory (2.30s)
08-31-2020 @ 16:03:17 - Starting step cycle: import_inventory
08-31-2020 @ 16:03:20 - Completed step cycle: import_inventory (2.50s)
08-31-2020 @ 16:03:20 - Starting step cycle: import_inventory
08-31-2020 @ 16:03:23 - Completed step cycle: import_inventory (2.29s)
08-31-2020 @ 16:03:23 - Starting step cycle: import_inventory
08-31-2020 @ 16:03:26 - Completed step cycle: import_inventory (2.81s)
08-31-2020 @ 16:03:27 - Starting step cycle: import_inventory
08-31-2020 @ 16:03:28 - Completed job step: import_inventory
08-31-2020 @ 16:03:28 - Completed step cycle: import_inventory (1.25s)
08-31-2020 @ 16:20:25 - Starting upgrade to v2.2.0
08-31-2020 @ 16:20:25 - Upgrade to v2.2.0 complete
08-31-2020 @ 16:21:53 - Starting step cycle: import_products
08-31-2020 @ 16:23:01 - Imported New Products Count: 0
08-31-2020 @ 16:23:01 - Updated Products Count: 17
08-31-2020 @ 16:23:01 - Completed step cycle: import_products (68.52s)
08-31-2020 @ 16:23:02 - Starting step cycle: import_products
08-31-2020 @ 16:32:27 - Starting step cycle: import_products
08-31-2020 @ 16:37:31 - Starting step cycle: import_products

    You can see the import that started at 16:21:53 just keeps going.

Viewing 10 replies - 46 through 55 (of 55 total)

  • Hi @popped, please do send me your logs and I can take a look.

    If the images aren’t importing at all there could be something in the PHP logs that pin-point what’s going wrong here.

    Are the images quite large? I know square has a 15MB limit but it’s possible uploading them to WordPress could be timing out.

    In any case, PHP error logs and Square logs should highlight any issues.
    Let me know once you’ve sent them

    Thread Starter kegobeer

    (@kegobeer)

    @mattdallan It’s during the second import that it never progresses any further. If left alone long enough it will re-import existing items and existing images, like in a loop. My uploaded image directory is full of duplicates of images that show the same batch of items is repeated.

    Once you have a fix for the import image problem I will do another test. Until then I will not select existing items during the import when I have new items in my inventory, and if I add a new variation to an existing product I will just delete the item, empty the trash, and do an import to get those new variations (like I have been doing since I started using square).

    Thanks.

    Hey @kegobeer, thanks for your patience!

    We’ve just deployed Square 2.2.2 which includes the fix to duplicate copies of product images from Square being uploaded on every import.

    Can you please:
    1. Update to Square 2.2.2
    2. Clear any existing Sync/imports by going to WooCommerce > Status > Tools and clicking the “Clear Square Sync” button (screenshot)
    3. Enable logging again (if you disabled it) from the Square settings: WooCommerce > Settings > Square.
    4. Try run the Square import/update process again

    To view the status of the current import/update, visit the update tab found on the Square settings page.

    Refresh the page every couple of minutes and if it’s not updating, it’s stuck again.

    Let me know how this all goes and feel free to send me any logs using the same email as before.
    Thanks!

    Thread Starter kegobeer

    (@kegobeer)

    @mattdallan I updated to 2.2.2 and, although it took longer than I expected, the import and update of existing products during import completed. It didn’t upload any existing images. I’ll email you my log so that you can look and make sure everything executed properly.

    Hi @kegobeer,

    I appreciate you sending the logs as I was able to double-check the changes in v2.2.2 are working as intended on your store.

    From the logs, I can see we imported/updated a total of 251 products from Square in approximately 2 minutes (completed in 5 batch API requests to Square), which is not bad at all.

    When updating products as part of the import process, it’s expected to take a bit longer because are updating data in the DB, instead of simply skipping over existing products as we did previously.

    With that said, I’m very glad to hear we got this all sorted and it is working smoothly now.

    Thanks for initially reporting this issue to us and for your continued patience as we diagnosed and fixed the issues.

    Cheers.

    Thread Starter kegobeer

    (@kegobeer)

    @mattdallan Thanks for reviewing the logs for me. I appreciate the quick updates to get this fixed.

    @mattdallan Ok I’m not sure what is going on with mine, I updated to the 2.2.0 and it’s been trying to import/sync for 24hrs. I stopped it and tried without updated current products. That’s not working either. Now in my media I see greyed out images named original-###.jpeg. I’m frustrated here, my WordPress seems to also be super slow. Any help would be greatly appreciated.

    Also to mention, not just my WordPress being super slow but my website is loading too slow.

    Thread Starter kegobeer

    (@kegobeer)

    If you deactivate the Square plugin does your website start responding like normal? What other plugins do you have on your site?

    Hey guys. I still seem to be having an issue with syncing. it keeps sticking here
    Importing now…
    Skipped: 3
    Updated: 97
    Imported: 0

    Images are being imported but don’t show on the product. Quantities and prices are not being updated. I have items in stock that shows sold out.

    Any help would be appreciated.

    Version 2.2.5

Viewing 10 replies - 46 through 55 (of 55 total)
  • The topic ‘Updated to 2.2.0 and now can’t import/sync’ is closed to new replies.