Viewing 15 replies - 16 through 30 (of 34 total)
  • Plugin Author N-Media

    (@nmedia)

    Hi,

    we just released the Google sync version 3.0, did you updated? And you must watch this video to use this.

    Thread Starter naratt

    (@naratt)

    Just ignore previous comments.
    Now i updated to V3. It seems to work fine except..

    1) I cannot fetch all my products. Got error “Exceed maximum execution time”. I got 1,137 products fetched before the error while I have 3,343 products in Woocommerce.
    >> https://i.imgur.com/JG1NdIl.png

    2) After the error, I modified data just, removed “OK” from Sync column just 1 row and press “Sync Data”, another error appeared
    >> https://i.imgur.com/hpPVOWr.png

    Thread Starter naratt

    (@naratt)

    I found that it’s Google’s limitation to allow just 6 minutes script runtime. However, there’re workarounds implemented in the script to bypass such timeout.
    https://script.gs/bypass-script-execution-timeout-programmatically/

    I’m sure many customers have thousands products like me. That’s why we need to bulk edit them in the sheet. That’s why they purchased your plugin. Please fix this.

    Plugin Author N-Media

    (@nmedia)

    Hi there, yes we released it and we released a new version of Google template V3.1, you can make a copy of the Google template again and will sync the products in chunks, make sure you set value in chunk_size inside **settings** page.

    Thread Starter naratt

    (@naratt)

    How do you recommend Chunk_size setting ?

    Thread Starter naratt

    (@naratt)

    I don’t see v3.1 yet, neither auto update nor wordpress website.
    Where can i get it, and the template ?
    My version is 3.0 and Pro 2.0

    and here is my current setting.

    View post on imgur.com

    Plugin Author N-Media

    (@nmedia)

    It is updated in GoogleSync template, not the plugin. You have to clone new Google sync template.

    Thread Starter naratt

    (@naratt)

    I tried template v3.1 with chunk_size=30 (both in plugin setting & template) and still the timeout issue is there : https://i.imgur.com/wwhDirQ.png
    This time i got just 1108 products before 6-minutes limit.

    Then i increased chunk_size setting in both places to 100. This time it ran until 100% just before 6 minutes ( https://i.imgur.com/To8Gn8W.png ) but after 40%, most rows were skipped ( https://i.imgur.com/FNaucFZ.png ). And after about 50% all rows were skipped. you can see the progress show ‘0=created, 0=Updated'( https://drive.google.com/uc?id=1dh-GBM81thENkTVcJPDLbk860cPMildA )

    The last row i got is 1658 while i have 3000+ products.

    Thread Starter naratt

    (@naratt)

    I also tried chunk_size=70, it can reach only 63% before timeout and some row skip found along the progress.

    Plugin Author N-Media

    (@nmedia)

    Narat, please set the chunk size to lower like 20, and you have images URL in sheet?

    Thread Starter naratt

    (@naratt)

    No image field. All fields i have are :

    id sku name type parent_id regular_price sale_price date_on_sale_from date_on_sale_to stock_quantity stock_status sync

    At chunk size = 20, the progress ran up to about 40% and stop a 6 minutes limit. I got 1,253 products.

    I think you should implement functions to bypass 6-minutes limit. I found some solutions in the internet.

    Thread Starter naratt

    (@naratt)

    Also found row skipping randomly > https://i.imgur.com/7OKPHUC.png

    Plugin Author N-Media

    (@nmedia)

    Thanks for sharing it, yes working on this to by-pass this timeout limit from the Google script.

    Thread Starter naratt

    (@naratt)

    For how long, can you estimate ?
    I cannot use it since bought.

    Plugin Author N-Media

    (@nmedia)

    It will be updated in one week here.

Viewing 15 replies - 16 through 30 (of 34 total)
  • The topic ‘Critical Error in plugin setting page’ is closed to new replies.