Announcement

Collapse
No announcement yet.

adding orders from an external source

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

    adding orders from an external source

    greetings,

    we'd like to write a php script to import orders directly into our miva database.

    as i understand it, miva has its own particular way of handling order and order item creation, relying on a table of index values [s01_StoreKeys] to keep track of index maxima which it then increments manually, rather than having the dbm handle this automatically via auto-increment keys. if we want to add orders via a batch import program, to ensure against index number collisions and data conflicts, would incrementing the appropriate maxima in s01_StoreKeys be enough, or would the solution be more complicated than that? the idea is-

    lock the s01_StoreKeys table
    read the appropriate maxima
    update the maxima incremented accorded to the data imported for the batch
    unlock the table

    - would this approach work, or is it too naïve?
    - does anyone know where i can find an annotated data dictionary of some sort to the keys in the s01_StoreKeys table?

    thanks

    #2
    Re: adding orders from an external source

    no ideas?

    Comment


      #3
      Re: adding orders from an external source

      Originally posted by coder1 View Post
      greetings,

      we'd like to write a php script to import orders directly into our miva database.

      as i understand it, miva has its own particular way of handling order and order item creation, relying on a table of index values [s01_StoreKeys] to keep track of index maxima which it then increments manually, rather than having the dbm handle this automatically via auto-increment keys. if we want to add orders via a batch import program, to ensure against index number collisions and data conflicts, would incrementing the appropriate maxima in s01_StoreKeys be enough, or would the solution be more complicated than that? the idea is-

      lock the s01_StoreKeys table
      read the appropriate maxima
      update the maxima incremented accorded to the data imported for the batch
      unlock the table

      - would this approach work, or is it too naïve?
      - does anyone know where i can find an annotated data dictionary of some sort to the keys in the s01_StoreKeys table?

      thanks
      Hi there,

      First off, this approach is incredibly prone to issues and there are much better ways to solve this. I guess the first important question to ask is: "where are the outside orders being created, and why not use the 'manage orders' region to create the orders?"

      Also, please provide a little background on the order management / ERP you are using. I'll do my best to point you in the right direction!


      Thank you much,

      -Philip
      Philip Hansen
      Strategy & Solutions Manager // [email protected]

      Comment


        #4
        Re: adding orders from an external source

        ..not to mention possibly hosing the PCI Compliance of the Merchant system.<g>
        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


          #5
          Re: adding orders from an external source

          Originally posted by phansen View Post
          First off, this approach is incredibly prone to issues and there are much better ways to solve this. I guess the first important question to ask is: "where are the outside orders being created, and why not use the 'manage orders' region to create the orders?"

          Also, please provide a little background on the order management / ERP you are using. I'll do my best to point you in the right direction!
          hi philip,

          thanks much for your reply, i am definitely open to hearing about better ways to approach this problem.

          ok, to answer your questions, the orders are being taken by about a dozen different organizations. many of them have their own proproprietary systems. they send us the orders in a number of formats, which we're in the process of standardizing. we can't use the 'manage orders' region because it's just too slow. we'll be receiving hundreds of orders in a batch format, and putting them in one at a time is unacceptable. is it possible to batch-input from the order mgt region? i know you can export in batch, but it doesn't seem like importing batches is an available option.

          as to our order tracking system, we're using a custom-tailored proprietary system developed specifically for our line of business. it'll be extended to provide the batch import functionality.

          thanks once again for the help, looking fwd to hearing your thoughts on this.

          Comment


            #6
            Re: adding orders from an external source

            Originally posted by Bruce - PhosphorMedia View Post
            ..not to mention possibly hosing the PCI Compliance of the Merchant system.<g>
            well, actually miva isn't strictly pci-compliant, because it stores customer information such as credit card numbers and authorization transaction information in the database in cleartext.

            ...but your point is well-taken!

            Comment


              #7
              Re: adding orders from an external source

              actually miva isn't strictly pci-compliant, because it stores customer information such as credit card numbers and authorization transaction information in the database in cleartext.
              You can store cards and be PCI compliant and if you follow our PA-DSS Product Implementation Guide you would never have that data stored in clear text.

              So Miva Merchant's PCI Compliance depends on how you configure your installation and is fully capable of being PCI Compliant.
              Thanks,

              Rick Wilson
              CEO
              Miva, Inc.
              [email protected]
              https://www.miva.com

              Comment


                #8
                Re: adding orders from an external source

                any ideas, phansen?

                Comment


                  #9
                  Re: adding orders from an external source

                  Originally posted by coder1 View Post
                  hi philip,

                  thanks much for your reply, i am definitely open to hearing about better ways to approach this problem.

                  ok, to answer your questions, the orders are being taken by about a dozen different organizations. many of them have their own proproprietary systems. they send us the orders in a number of formats, which we're in the process of standardizing. we can't use the 'manage orders' region because it's just too slow. we'll be receiving hundreds of orders in a batch format, and putting them in one at a time is unacceptable. is it possible to batch-input from the order mgt region? i know you can export in batch, but it doesn't seem like importing batches is an available option.

                  as to our order tracking system, we're using a custom-tailored proprietary system developed specifically for our line of business. it'll be extended to provide the batch import functionality.

                  thanks once again for the help, looking fwd to hearing your thoughts on this.

                  Hey there, sorry for the delay - forums had some issues this morning and I forgot to come back to my draft! I understand that manually re-keying into Miva Merchant is a pain. The most important question I should have asked is 'Why do you want/need the orders present in the Miva Merchant database?' Assuming that Miva is not the central 'hub' of your operations, it may be redundant to push into Miva Merchant..

                  If you can, I'd like to continue our discussion offline for quicker back/forth. Please email me direct with your reply: [email protected]

                  Thank you much,

                  -Philip
                  Philip Hansen
                  Strategy & Solutions Manager // [email protected]

                  Comment


                    #10
                    Re: adding orders from an external source

                    hi philip,

                    just wanted to let you know i sent you an email yesterday and outlined the problem.

                    cheers!

                    Comment


                      #11
                      Re: adding orders from an external source

                      Is there any chance that the solution to this could be posted? I feel like the purpose of the forum isn't just to request help, but to have an archive where others can search for the solution and not have to ask.

                      Thanks in advance!
                      Joel

                      Comment


                        #12
                        Re: adding orders from an external source

                        Originally posted by joelw View Post
                        Is there any chance that the solution to this could be posted? I feel like the purpose of the forum isn't just to request help, but to have an archive where others can search for the solution and not have to ask.
                        yes, i agree.

                        the solution we found was to sign up for miva's extended support so we could use some of their tools to develop a batch import program. i'm under n.d.a., so unfortunately i can't release the details, but if you contact miva, i'm sure they could give you a few potential directions to consider. sorry i couldn't be more help.

                        Comment


                          #13
                          Re: adding orders from an external source

                          It's probably not super secret. I"m sure the provisioning system is probably capable of it. the samples of the provision.xml are open source and there are xml tags that reference order number and such. but again, i'd use lots of caution and probably build some kind of php front end to accept and clean this data before pulling it into the miva merchant store. It seems like a big big big risk to me.

                          Comment


                            #14
                            Re: adding orders from an external source

                            We have some tools that make using the provisioning system much easier/safer but they're only available to our dedicated hosting/enterprise customers. They're the cornerstone of our new Miva Merchant Enterprise offering.

                            However if you're an advanced user you could certainly use the provisioning XML to do it yourself without our tools.
                            Thanks,

                            Rick Wilson
                            CEO
                            Miva, Inc.
                            [email protected]
                            https://www.miva.com

                            Comment

                            Working...
                            X