24/7 Support - 800.608.6482

Miva Merchant Community Forums

Page 1 of 2 1 2 LastLast
  1. #1
    Join Date
    Jan 2012
    Posts
    11

    Default 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. #2
    Join Date
    Jan 2012
    Posts
    11

    Default Re: adding orders from an external source

    no ideas?

  3. #3
    Join Date
    Mar 2011
    Posts
    28

    Default Re: adding orders from an external source

    Quote 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
    phansen@mivamerchant.com

  4. #4
    Join Date
    Mar 2006
    Posts
    6,876

    Default Re: adding orders from an external source

    ..not to mention possibly hosing the PCI Compliance of the Merchant system.<g>

  5. #5
    Join Date
    Jan 2012
    Posts
    11

    Default Re: adding orders from an external source

    Quote 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.

  6. #6
    Join Date
    Jan 2012
    Posts
    11

    Default Re: adding orders from an external source

    Quote 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!

  7. #7
    Join Date
    Aug 2007
    Posts
    7,509

    Default 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
    President
    Miva Merchant
    rwilson@mivamerchant.com
    http://www.mivamerchant.com

  8. #8
    Join Date
    Jan 2012
    Posts
    11

    Default Re: adding orders from an external source

    any ideas, phansen?

  9. #9
    Join Date
    Mar 2011
    Posts
    28

    Default Re: adding orders from an external source

    Quote 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: phansen@mivamerchant.com

    Thank you much,

    -Philip
    Philip Hansen
    Strategy & Solutions Manager
    phansen@mivamerchant.com

  10. #10
    Join Date
    Jan 2012
    Posts
    11

    Default 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!

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •