Announcement

Collapse
No announcement yet.

MVT code for accessing "Notes" inside customers?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • MVT code for accessing "Notes" inside customers?

    I can't find the answer with google and was wondering if we can get the notes for customers in some way...
    Thanks for reading :)

  • Do you mean the admin, order processing 'Notes'? If so, I'm not aware of any SMT code that can do that. (I don't even know of any API calls for that feature since it wouldn't be published in the Source Code Kit.

    If you mean a customer added note via custom fields or one of the "Tool-thingies", that's a different story.
    Bruce Golub
    Phosphor Media - "Your Success is our Business"

    Improve Your Customer Service | Get MORE Customers | Edit CSS/Javascript/HTML Easily | Make Your Site Faster | Get Indexed by Google | Free Modules | Follow Us on Facebook
    phosphormedia.com

    Comment


    • You can pull notes via the API if you wanted:

      https://docs.miva.com/json-api/funct...ist_load_query

      Let me see what template functions are available to load notes.

      Brennan Heyde
      VP Product
      Miva, Inc.
      [email protected]
      https://www.miva.com

      Comment


      • I meant the notes when you go into a customer in the admin. We have people writing in notes for certain customers and we wanna print it with our batches. Maybe just making a note in custom fields is the better way to do this...

        Comment


        • Originally posted by teedle View Post
          I meant the notes when you go into a customer in the admin. We have people writing in notes for certain customers and we wanna print it with our batches. Maybe just making a note in custom fields is the better way to do this...
          It could very well be better to use custom order fields as you could break them up into different content types. For example, you could have "shipping" notes and output them next to the 'ship to' fields. And then you could have Packing Notes and place them in the next to the item list, etc.
          Bruce Golub
          Phosphor Media - "Your Success is our Business"

          Improve Your Customer Service | Get MORE Customers | Edit CSS/Javascript/HTML Easily | Make Your Site Faster | Get Indexed by Google | Free Modules | Follow Us on Facebook
          phosphormedia.com

          Comment


          • I took a quick look at the API. No documentation that I could find for Notes in docs.miva. However, there are API functions to load the notes if you know the note's ID. So the API is fairly thin at the moment. IOW, there doesn't appear to be a way to load a note by customer id -- which is part of the notes table. You could load all the notes associated with the Order ID, however. At this point in time, looks like using the custom fields will give you the most options.

            I did look to see if the customer table stored a notes ID. Unfortunately, it only stores a note count.

            Scott
            What help do you need today!
            Interactive Design Solutions http://www.southbound.com
            MivaMerchant Business Partner | Certified MivaMerchant Web Developer
            My T-shirt Collection is mostly MivaCon T-shirts!!
            Competitive Rates, Popular Modules, and Integrations:
            Product Copy | AutoBaskets | Waitlist Integration| Wholesale Integration

            Comment


            • Originally posted by ids View Post

              I did look to see if the customer table stored a notes ID. Unfortunately, it only stores a note count.

              Scott
              I think the those notes are 'Customer' notes...and not the ones on orders. (At least, that how it appears in a quick test.) But yea, just use Customer Order Fields and call it a day.

              Bruce Golub
              Phosphor Media - "Your Success is our Business"

              Improve Your Customer Service | Get MORE Customers | Edit CSS/Javascript/HTML Easily | Make Your Site Faster | Get Indexed by Google | Free Modules | Follow Us on Facebook
              phosphormedia.com

              Comment


              • There is only one notes table. The keys could be an order id, customer id, and account id. I haven't looked at the LSK for 9.14 (is it out yet?) to see if new notes functions exist to be able to load the info into an email or batch template. In admin, you need to be in a correct screen to have access to the actual note(s). This actually leaves the impression of different containers for the notes.

                Bottom line, to answer teedle's question, it doesn't appear (save 9.14 LSK) you can load notes from a customer id into a batch template report. So, unless 9.14 addressed this, custom fields are the only built-in option.

                Scott
                What help do you need today!
                Interactive Design Solutions http://www.southbound.com
                MivaMerchant Business Partner | Certified MivaMerchant Web Developer
                My T-shirt Collection is mostly MivaCon T-shirts!!
                Competitive Rates, Popular Modules, and Integrations:
                Product Copy | AutoBaskets | Waitlist Integration| Wholesale Integration

                Comment


                • Didn't look at the tables...(since I didn't have database viewer on this account). Just entered an order note, and then checked my customer account...and nada was there....but, it was mostly an academic effort.
                  Bruce Golub
                  Phosphor Media - "Your Success is our Business"

                  Improve Your Customer Service | Get MORE Customers | Edit CSS/Javascript/HTML Easily | Make Your Site Faster | Get Indexed by Google | Free Modules | Follow Us on Facebook
                  phosphormedia.com

                  Comment


                  • ....but, it was mostly an academic effort.
                    LOL.

                    If you drilled down into the customer's orders (Customer account admin screens) and list the orders, turn on the Note Count field, you can drill down to the specific order to see the notes entered for that order because you made it to a screen that can load that data.

                    Scott
                    What help do you need today!
                    Interactive Design Solutions http://www.southbound.com
                    MivaMerchant Business Partner | Certified MivaMerchant Web Developer
                    My T-shirt Collection is mostly MivaCon T-shirts!!
                    Competitive Rates, Popular Modules, and Integrations:
                    Product Copy | AutoBaskets | Waitlist Integration| Wholesale Integration

                    Comment


                    • wow...that's useful.../s
                      Bruce Golub
                      Phosphor Media - "Your Success is our Business"

                      Improve Your Customer Service | Get MORE Customers | Edit CSS/Javascript/HTML Easily | Make Your Site Faster | Get Indexed by Google | Free Modules | Follow Us on Facebook
                      phosphormedia.com

                      Comment


                      • Originally posted by Bruce - PhosphorMedia View Post
                        Just entered an order note, and then checked my customer account...and nada was there....but, it was mostly an academic effort.
                        Where did you check for the Note? I added a Note to my customer account, it then showed there was 1 Note associated with my account.

                        I also noticed that there is a "Notes" in the customer orders, which seems to only hold Notes for Order specific to the order. I have one test order with 2 Notes "Changed order status" and "Created order" - neither of those notes appear in my Customer Account.

                        Could this be adding to the confusion as to what the database sees and /or how to find it?

                        Leslie Kirk
                        Miva Certified Developer
                        Miva Merchant Specialist since 1997
                        Previously of Webs Your Way
                        (aka Leslie Nord leslienord)

                        Email me: [email protected]
                        www.lesliekirk.com

                        Follow me: Twitter | Facebook | FourSquare | Pinterest | Flickr

                        Comment


                        • As of 9.13 LSK, there isn't an API function that loads the notes based on customer id and order id. You can load them by order id. But, it seems, the admin screens only load notes based on where you're at. Order tables are just data, so it's almost like there isn't any association with the customer -- even though a customer id exists. So, notes per order id. If in the customer screen, ther must be an admin API function that loads via customer id, but doesn't use the order id. Of course, you could drill down through customer's orders in that tab.

                          Bottom line is that there is room for some CRM style improvements. So, IMO, yes. Could be adding or creating confusion.
                          What help do you need today!
                          Interactive Design Solutions http://www.southbound.com
                          MivaMerchant Business Partner | Certified MivaMerchant Web Developer
                          My T-shirt Collection is mostly MivaCon T-shirts!!
                          Competitive Rates, Popular Modules, and Integrations:
                          Product Copy | AutoBaskets | Waitlist Integration| Wholesale Integration

                          Comment


                          • Thank you everyone for the answers!

                            Comment

                            Working...
                            X

                            This website uses cookies to identify visitors, track visitors to our website, store login session information and to remember your user preferences. By continuing to use this site you agree to our use of cookies. Learn More.

                            This website uses cookies. By continuing to use this site you agree to our use of cookies. Learn More.

                            Accept