Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Edgar Rasquin 326 posts 925 karma points
    May 20, 2021 @ 09:06
    Edgar Rasquin
    0

    Vendr checkout values

    Hi Matt,

    I am using Vendr checkout. In which sql db table do you store the values for the Newsletter subscription and the customer comments? I had a look around, thinking it should be a column in VendrOrder but could not find it.

    Thanks, Edgar

    enter image description here

    Copy Link
  • Matt Brailsford 4125 posts 22223 karma points MVP 9x c-trib
    May 20, 2021 @ 09:09
    Matt Brailsford
    100

    Hi Edgar,

    That's a custom order property stored in the orders Properties collection so that will get saved to the vendrOrderProperty table.

    Matt

    Copy Link
  • Edgar Rasquin 326 posts 925 karma points
    May 20, 2021 @ 09:55
    Edgar Rasquin
    0

    Thanks.

    In that table I have the marketingOptIn value but cannot find the customer comments?

    Edgar

    enter image description here

    Copy Link
  • Matt Brailsford 4125 posts 22223 karma points MVP 9x c-trib
    May 20, 2021 @ 10:05
    Matt Brailsford
    1

    Hi Edgar,

    Do you actually have a comments value? If there is no value, it won't get added to the database table. It should get saved with the alias "comments" if there is a value, otherwise no row will be added.

    Matt

    Copy Link
  • Edgar Rasquin 326 posts 925 karma points
    May 20, 2021 @ 10:36
    Edgar Rasquin
    0

    That's exactly how it is. Thanks Matt!

    Edgar

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft