• Resolved rorywp20

    (@rorywp20)


    Hello!
    Does the automatic synchronization allow me to update a product value that is linked to a formula?

    I have an Excel file consisting of these sheets:
    “load”, where I manually enter the product code and the number of pieces of that product in stock in my offline shop
    “unload”, where I manually enter the product code and the number of pieces of that product I sold in my offline shop
    “woocommerce unload”, where I want to have the product code and the number of pieces sold online 
    “warehouse” where each product corresponds to a number (automatically calculated using an Excel formula) that is the difference between the pieces indicated in the “load” sheet and those in the “unload” and “woocommerce unload” sheets.

    What I need is a communication of this type:
    – WooCommerce must put up for sale the number of products indicated in the “warehouse” sheet
    – When a sale occurs on the website, it must be reflected in the “woocommerce unload” sheet.

    Is it possible to do that with just this plugin?

    Thank you very much

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author N-Media

    (@nmedia)

    Hi,

    this plugin reads the values of cell wheather these are static values or build with formulas. So make sure columns should be matched (custom columns for meta can be created of course).

    Thread Starter rorywp20

    (@rorywp20)

    Perfect!

    Does this plugin also synchronizes the number of products sold on WooCommerce to a specific Excel sheet (“woocommerce unload”)?

    Thread Starter rorywp20

    (@rorywp20)

    @nmedia I’ve set the autosync each 1 minute.
    If the product stock value (connected to a formula) changes I can’t see the changes automatically appear in woocommerce. In App script log I have “No Data to Sync” even if the value is changed.
    If I sync manually I can see the value changed in woocommerce.
    What can I do to make the changes appear with autosync?
    (I’ve also enabled the “AutoSync Direct” setting but hasn’t helped)

    Plugin Author N-Media

    (@nmedia)

    Hi,

    what is you remove the sync col value as well?

    Thread Starter rorywp20

    (@rorywp20)

    Nothing.
    I’ve noticed Autosync only works with products that have a “sync” value other than ‘ok’. How can I set up autosync to work even for values with ‘ok’?”

    Plugin Author N-Media

    (@nmedia)

    Hi,

    make sure you clone sheet our base templte from https://docs.google.com/spreadsheets/d/1P5ARmpqrEQh–o37c3McYWBhN-8Yr7zW8utJkCbA-WE/edit?gid=0#gid=0 and also keep  “AutoSync Direct”

    Thread Starter rorywp20

    (@rorywp20)

    I had done it. Anyway, it seems like I’ve resolved

    Plugin Author N-Media

    (@nmedia)

    good to see that you resolved.

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘sync cells with formula’ is closed to new replies.