• Resolved hansvmourik

    (@hansvmourik)


    Hello all,

    I have a WooCommerce store, which is connected with Zapier to a Google spreadsheet. In this file, I keep track of the sales etc. Some of these columns contain -obviously- prices, such as price ex VAT, prices inc VAT, total prices, etc.

    Both the website and the Google Spreadsheet are set as Dutch, which means that commas are set as decimal dividers. This works perfectly in the webshop and in the emails. However, for some reason the pricing vales are stored in my spreadsheet as strings, such as 18.21.

    To be able to automatically calculate with these values, I really need these values to be stored as numbers with a comma as decimal value.

    I really hope that I made my question clear, and I sincerely hope that someone could help me out on this.

    Cheers,

Viewing 1 replies (of 1 total)
  • Caleb Burks

    (@icaleb)

    Automattic Happiness Engineer

    Hello,

    I’m afraid this forum can only be used for WooCommerce core support. Both Bookings and Zapier are separate products, and integrated with separate (likely premium) extension that make it against the forum rules to support here.

    You will need to contact the authors from where you got the Zapier connection plugin as I believe the issue is there. But first double check your Zaps and check the data coming into Zapier.

Viewing 1 replies (of 1 total)
  • The topic ‘Bookable products and Zapier bug’ is closed to new replies.