Support » Plugin: Stock Sync for WooCommerce » Live adjustment not working on sales

  • Resolved ajamm

    (@ajamm)


    I’ve successfully set this up on the two sites, I imported the identical products into both sites, so SKUs all line up nicely.

    The stock seems to have done an initial sync, but I processed a sale on Site B, and the stock was NOT adjusted in Site A.

    Adjusting stock in site A via product page seems to work, though oddly, the remote site number in site B remains as it was (bot adjusted), but the local site number was updated.

    Tried with bulk stock management page (plugin) and this does not seem to work.

    Most of our products are variations.

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Author wooelements

    (@wooelements)

    Thanks for reporting the issue!

    Please go to WooCommerce > Status > Logs and select Stock Sync log (e.g. woo-stock-sync-2019-02-11-xxxxxxxx.log). Is there any error messages or other messages about syncing related to the product?

    Also please check that you’re using the latest version 1.0.1. There were some issues with variations in 1.0.0.

    Thread Starter ajamm

    (@ajamm)

    There are some log entries.
    Below are the last few entries on both, the time seems to be mismatched?
    Will see how tomorrow goes, some of this could have been initial setup.
    The logs don’t make it clear which site is triggering the update… or if this is pushing the update?

    Site B Logs
    2019-02-12T07:27:14+00:00 DEBUG Started stock sync
    2019-02-12T07:27:16+00:00 INFO Wrapped Fizzies – Rockets – 200gm (5476) – Set stock quantity to -1
    2019-02-12T07:27:16+00:00 DEBUG Finished stock sync
    2019-02-12T07:27:38+00:00 DEBUG Started stock sync
    2019-02-12T07:27:40+00:00 INFO Wrapped Fizzies – Rockets – 500gm (5475) – Set stock quantity to -2
    2019-02-12T07:27:40+00:00 DEBUG Finished stock sync
    2019-02-12T07:28:15+00:00 DEBUG Started stock sync
    2019-02-12T07:28:16+00:00 INFO Wrapped Party Pack – 200gm (5463) – Set stock quantity to 0
    2019-02-12T07:28:16+00:00 DEBUG Finished stock sync
    2019-02-12T07:28:16+00:00 DEBUG Started stock sync
    2019-02-12T07:28:18+00:00 INFO Wrapped Party Pack – 500gm (5462) – Set stock quantity to -3
    2019-02-12T07:28:18+00:00 DEBUG Finished stock sync
    2019-02-12T07:28:37+00:00 DEBUG Started stock sync
    2019-02-12T07:28:38+00:00 INFO Wrapped Party Pack – Bulk 2kg (5461) – Set stock quantity to 1
    2019-02-12T07:28:38+00:00 DEBUG Finished stock sync

    Site A Log
    2019-02-12T20:51:31+00:00 DEBUG Started stock sync
    2019-02-12T20:51:48+00:00 ERROR Licorice Logs – Black (370) – Exception while trying to push update. Message: cURL Error: Operation timed out after 15000 milliseconds with 0 bytes received
    2019-02-12T20:51:48+00:00 DEBUG Finished stock sync
    2019-02-12T20:52:33+00:00 DEBUG Started stock sync
    2019-02-12T20:52:38+00:00 INFO Licorice Logs – Black (370) – Set stock quantity to 17
    2019-02-12T20:52:38+00:00 DEBUG Finished stock sync
    2019-02-12T21:11:57+00:00 DEBUG Started stock sync
    2019-02-12T21:12:05+00:00 INFO Aniseed Balls – Sugar Free 250gm (392) – Set stock quantity to 3
    2019-02-12T21:12:05+00:00 DEBUG Finished stock sync
    2019-02-12T21:12:05+00:00 DEBUG Started stock sync
    2019-02-12T21:12:15+00:00 INFO Mixed Mints – Sugar Free 250gm (1248) – Set stock quantity to 5
    2019-02-12T21:12:15+00:00 DEBUG Finished stock sync
    2019-02-12T21:12:15+00:00 DEBUG Started stock sync
    2019-02-12T21:12:24+00:00 INFO Raspberry Drops – Sugar Free 250gm (394) – Set stock quantity to 4
    2019-02-12T21:12:24+00:00 DEBUG Finished stock sync
    2019-02-12T22:36:00+00:00 DEBUG Started stock sync
    2019-02-12T22:36:18+00:00 INFO Blue Raspberry Razzoos – 100 Count (3593) – Set stock quantity to 0
    2019-02-12T22:36:18+00:00 DEBUG Finished stock sync
    2019-02-12T22:43:58+00:00 DEBUG Started stock sync
    2019-02-12T22:44:10+00:00 INFO Blue Raspberry Razzoos – 100 Count (3593) – Set stock quantity to 1
    2019-02-12T22:44:10+00:00 DEBUG Finished stock sync

    Thread Starter ajamm

    (@ajamm)

    A couple more notes. The order I made on Site B is still in the ‘On Hold’ status, and the values are negative (backorder). It is still not correct on site A

    Plugin Author wooelements

    (@wooelements)

    Thanks for the logs.

    The time is in UTC time zone so it may be different than your local time.

    The logs are always about the local site pushing to the external site. For example, if someone purchases a product on site A, that will show in site A logs but not in site B logs.

    The logs seems to be fine except one timeout error for “Licorice Logs – Black (370)”. It was retried successfully later though.

    Anyway, if you run into this issue later on, please check the logs if there is a mention about it. If the sync was successful and it didn’t update on the external site, please let me know and I will have a look. Thanks!

    Thread Starter ajamm

    (@ajamm)

    Righto, we’ve just seen a sale 30 minutes ago on Site A, stock is correct on site A (0), and incorrect on Site B. There is no log appearing for today… and nothing in the previous date log regarding this.
    Is the log created only when the day starts in UTC? We’re 12 hours ahead 🙂

    Plugin Author wooelements

    (@wooelements)

    The log will be created in real time. However, if you are 12 hours ahead and it’s still yesterday in UTC, you would see the events in the yesterday’s log.

    Is there any mention at all about the sale in the yesterday’s log? If not, there is two possibilities:

    1) Product or variation doesn’t have “Manage stock” checked. However this is unlikely if the stock is updating on the site A.

    2) Product or variation doesn’t have SKU set. For variation SKU needs to be unique from parent product.

    Apart from these there should be some mention in the logs.

    Thread Starter ajamm

    (@ajamm)

    Nothing has been added to the logs on Site A since the sample I gave earlier. There has only been this one sale though. Mostly it seems to be working… certainly from Site B to Site A it appears to be fine so far.
    SKU is the same – image here – https://livelaughlove.nz/wp-content/uploads/2019/02/stock-sync.png

    Plugin Author wooelements

    (@wooelements)

    SKUs seems to be fine. If there is no log messages at all, it’s not detecting stock change for some reason.

    Would it be possible to get temporary WordPress admin credentials? I could then check the settings to make sure everything is fine there. If possible, you can send them to lauri.karisola@wooelements.com.

    Another option is to wait for the second sale and check if it syncs.

    Thread Starter ajamm

    (@ajamm)

    OK, it seems like at least some of the log is not working delayed
    I adjusted using bulk stock management plugin, and the log shows most of the adjustments, but not all… however it looks like all the stock is adjusted…

    See image here https://livelaughlove.nz/wp-content/uploads/2019/02/stocksync2.png
    You can see in here, the Log in Site A, and a before and after updating view of the Stock Sync info. Notice that the stock amounts for both Mentos products have been increased, but only one shows in the log at this time.

    5 mins later I rechecked the log and it is now correct! Maybe the log has a delay on the write.

    I’ll keep an eye on it, but seems to be working, if just a little unpredictable.

    • This reply was modified 2 years, 2 months ago by ajamm. Reason: Updated info
    Plugin Author wooelements

    (@wooelements)

    I will check what’s up with the log. It uses standard WooCommerce logging so not sure if that has some delay.

    Thank you for providing detailed info, it definitely helps. I will mark this as resolved now but let me know if you run into any issues.

    Plugin Author wooelements

    (@wooelements)

    Just an update on this. A new version (1.1.0) published today has improved syncing. In the previous version there could be a delay of a few seconds in syncing. In the new version syncing is instant.

    1.1.0 also has debug logging mode which you can enable in the settings (WooCommerce > Settings > Stock Sync). Debug logging provides additional information about syncing operations which should help to debug any issues.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Live adjustment not working on sales’ is closed to new replies.