render to google sheet

  • Resolved hossam91

    (@hossam91)


    1 year, 4 months ago

    when user submit order his details saved to google sheet

    but i see some data are shorten like country

    i see US instead of united state

    and payment method is bacs instead of bank transfer

    is there a way to render the full data to g-sheet

Viewing 1 replies (of 1 total)
  • Plugin Support wayes001

    (@wayes001)

    1 year, 4 months ago

    Thank you for reaching out to us.

    We have reviewed your issue and found that the data being sent to Google Sheets is based on the backend values used by WooCommerce. For example:

    • The country is sent as “US” instead of “United States” because WooCommerce uses the country code “US” in its backend.
    • The payment method is sent as “bacs” instead of “Direct bank transfer” since it also uses this value internally.

    To display the full names or titles in Google Sheets, we recommend using the Payment Method Title field instead of the Payment Methods. This will provide the full title, such as “Direct bank transfer,” rather than “bacs.”

    Unfortunately, WooCommerce sends country codes by default to render full country names.

Viewing 1 replies (of 1 total)

The topic ‘render to google sheet’ is closed to new replies.