Announcement

Collapse
No announcement yet.

Downloading order payment information

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

    Downloading order payment information

    I have been trying to find a way to download some payment information for integration with our company computer system. I have been working with Emporium's email template format and have that working with most items except payment information. I am looking for the information that is in order processing. Type of payment: V, MC, D, AX, Paypal; authorization number, and credit card (not entire cc) partial with last 4. I am not using email (only FTP), this data is not a problem for security, so how is this done. OrderPayments has some of it in Pay_data but not all.
    Thanks,
    Chet Vincentz
    [email protected]

    www.electrodyne.cc Quality Motoring Accessories
    www.racdyn-usa.com BMW, MINI & Porsche performance
    www.artisticartifacts.com Creative art materials

    #2
    Re: Downloading order payment information

    Dear Chet,

    Depending on what Gateway you are using, some of that information may not be available.

    Some of it may be coded and you will have to figure out what each of the codes mean.
    Thank You,

    Nerd Boy

    http://www.nerdboyinc.com

    1-855-Nerd-Boy

    Comment


      #3
      Re: Downloading order payment information

      Yes I forgot to state we are using Chase Paymentech. We have the ability to import with a cross reference to coded data as long as the coding is consistent.

      I am going by what is available in manage orders. If it shows up in manage orders it has to be stored somewhere in my database, I assume?
      Thanks,
      Chet Vincentz
      [email protected]

      www.electrodyne.cc Quality Motoring Accessories
      www.racdyn-usa.com BMW, MINI & Porsche performance
      www.artisticartifacts.com Creative art materials

      Comment


        #4
        Re: Downloading order payment information

        Dear Chet,

        Not know the inside the Payment Module you are using, I would guess yes, all of it should be in the databases somewhere.
        Thank You,

        Nerd Boy

        http://www.nerdboyinc.com

        1-855-Nerd-Boy

        Comment


          #5
          Re: Downloading order payment information

          The best way to do this is going to be to create batch report to output the data to a CSV. Miva does have this data saved in its database and a batch report is going to be the easiest way to get to it, especially if it is encrypted.

          If you go to manage orders and select a few orders then click the batch report button, choose Printable Invoice. This will give you an page you can print out, however it also has the payment data you are looking for. (It may ask you to put in your encryption key if you have order encryption turned on.

          What you would need to to is create a new batch report (Under Utilities) that only out the payment data you need as a comma separated list. If you look at the batch report code there is a foreach loop which loops through the payments array.

          Here is a simplified version of it:

          Code:
          <mvt:foreach iterator="field" array="order:payment:fields">
          	&mvt:field:label;
          	&mvt:field:value;
          </mvt:foreach>
          There is a field label and a field value. You most likely want the field label as a column header so you may need to see what data is available from Chase and use those as column headers.


          Once you have the report outputting data in the format you need, you can change the header value to force the report to output the file as a csv to download. To do that go to the Item Tab on the batch report page template you are creating and assign the http_headers item to the page.

          Then within that tab add the following two headers:

          Content-Type text/csv
          Content-Disposition attachment; filename="payment_export.csv"


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

          Comment


            #6
            Re: Downloading order payment information

            Brennan,
            Thanks, will try.

            Chet
            Thanks,
            Chet Vincentz
            [email protected]

            www.electrodyne.cc Quality Motoring Accessories
            www.racdyn-usa.com BMW, MINI & Porsche performance
            www.artisticartifacts.com Creative art materials

            Comment


              #7
              Re: Downloading order payment information

              Brennan,

              After trying out your suggestion and reading the invoice code I realized it would be easier to export the entire invoice data and save me the effort of my separate export we that we are already using. I need bill to; ship to; order content; shipping anyway. I tried your suggestion and tried to export the entire invoice but my lack of code writing is stopping me.

              export_order_info.jpg

              I did the assign, but am having trouble getting the export to work because I don't understand how I am to fill in HTTP headers. I tried attaching jpg or pdf but couldn't get it to work. Used Chrome. What goes in left box, what in right?
              Last edited by lesliekirk; 06-10-14, 04:03 AM.
              Thanks,
              Chet Vincentz
              [email protected]

              www.electrodyne.cc Quality Motoring Accessories
              www.racdyn-usa.com BMW, MINI & Porsche performance
              www.artisticartifacts.com Creative art materials

              Comment


                #8
                Re: Downloading order payment information

                I'm used my moderator foo and inserted the image Chet is referring to.

                Leslie
                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


                  #9
                  Re: Downloading order payment information

                  Brennan, would Chet be able to use your tokens in place of the ones that are not working for him?

                  Code:
                  l.all_settings:order:pay_data
                  is not pulling in the basic payment data into the Emporium Plus Tool Kit Template Order Export he has previous created.

                  I'm "thinking" your example is to help him determine what to use in place of the non-working pay_data token.


                  I have a question for Bruce (if you are following along) - would the Merchant Inspector help ferret out the exact tokens he would need based on his payment gateway?

                  Leslie
                  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


                    #10
                    Re: Downloading order payment information

                    What is baffling me even more, is if I use the built-in Token List, I find the l.settings:order:pay_data and an entry for a specific order. I just don't understand why the something like =VI is not being pulled into the export. It should be noted that l.settings:order:pay_data is included in the tk_template_order_export.txt file that Bill provided in his example.

                    Okay, I'm going to try and use Brennan's token in it's place....
                    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


                      #11
                      Re: Downloading order payment information

                      In the export it is l.all_settings:order:pay_data, not l.settings:order:pay_data

                      If the payment module puts non-encrypted data in that non-encrypted field, it should be showing in the export. It will not export encrypted data.
                      Bill Weiland - Emporium Plus http://www.emporiumplus.com/store.mvc
                      Online Documentation http://www.emporiumplus.com/tk3/v3/doc.htm
                      Question http://www.emporiumplus.com/mivamodu...vc?Screen=SPTS
                      Facebook http://www.facebook.com/EmporiumPlus
                      Twitter http://twitter.com/emporiumplus

                      Comment


                        #12
                        Re: Downloading order payment information

                        If the data were encrypted would I have been able to see it when I looked at on the page using the Token List the way I did? Just wondering...
                        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


                          #13
                          Re: Downloading order payment information

                          Hi Brennan,

                          Leslie and I have playing around with this export idea for a few days without success. Maybe if I make a simple request you can give us the answer. Instead of printing an order invoice can you just help us get an export of the invoice in something we can open in Excel, like csv. Everything I need is on the invoice.

                          I know I don't have the export function working correctly per my previous post. You have got us close but no cigar!
                          Thanks,
                          Chet Vincentz
                          [email protected]

                          www.electrodyne.cc Quality Motoring Accessories
                          www.racdyn-usa.com BMW, MINI & Porsche performance
                          www.artisticartifacts.com Creative art materials

                          Comment


                            #14
                            Re: Downloading order payment information

                            I have changed the token to l.all_settings:order:pay_data per Bill's post and still nothing in the export. I am sooooo baffled as to why I can see what should be in the export when I use the VAR LIST. I can enter in an Order Number and BOOM, there is what should be in that field clear as day.

                            Part of my confusion comes from trying to figure out how to use Brennan's suggestion to discover what token is needed instead of the l.all_settings:order:pay_data token.

                            As Chet has asked previously, when he peeks inside his database and finds that there isn't any PAY_DATA field in the Orders. He's finding it in the OrderPayments. So is there a different token that Chet needs?

                            Leslie
                            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


                              #15
                              Re: Downloading order payment information

                              Hey Guys -

                              I got some clarification from development. l.settings:order:pay_data used to be available up until the payment data got split out into its own table (for PCI reasons)

                              That variable is no longer available on INVC or anywhere in runtime. The reason you are seeing it in the admin, is because there is a compatibility layer the code in the admin is using and it is able to access that data.

                              The batch report is going to be the best way to access the data you need. Because the batch report is running it admin, it is able to access the payment data you need. But I wouldn't access that variable directly. It is going to be easier to use the available payments array to loop though the available payment data.
                              Last edited by Brennan; 06-11-14, 09:00 AM.
                              Brennan Heyde
                              VP Product
                              Miva, Inc.
                              [email protected]
                              https://www.miva.com

                              Comment

                              Working...
                              X