Announcement

Collapse
No announcement yet.

Transfering orders from live store to dev

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

    Transfering orders from live store to dev

    Hi folks,

    I have a client who's about to go live with a dev store, by swapping URLs to turn the dev store into the live store. The dev store, of course, contains all the orders that were present in the live store when a copy was taken to create the dev store. But while the dev store was under construction, a lot of new orders came into the live store. The client wants to transfer these orders into the new store, so that the order history will be complete.

    I see that Miva Merchant still has a built-in "Export Orders to Flat File" function, as it has for years. But there's no corresponding import function. The conventional wisdom is that it's not possible to import orders from one store to another, because there are ID numbers and other data that won't be correct when moved from one store to another. But I'm an unconventional guy ... and this is a special case, transferring orders from one store to another that has an almost identical configuration.

    I think I can write a matched pair of import and export modules that will do a decent job of transferring data from one store to another. It may not get everything, but it can get enough data to be helpful on the admin pages, and also on the order-history pages that customers use to view their orders. Before I start spec'ing out the project for the client, I wanted to ask:
    • Has anyone done this already?
    • Any thoughts on how to do it, and how well it will work?
    • If I get the modules working well, would you like to buy a copy for your own use? Or maybe pay a modest fee to have me provide this service?
    Thanks --
    Kent Multer
    Magic Metal Productions
    http://TheMagicM.com
    * Web developer/designer
    * E-commerce and Miva
    * Author, The Official Miva Web Scripting Book -- available on-line:
    http://www.amazon.com/exec/obidos/IS...icmetalproducA

    #2
    Hey Kent, the Miva Merchant API can be used to both push and pull orders / customers. You could offer a sync service, code remains on your side, it could check different stores and move order/customer data between. It would not need to store them on your side, nor in any export/import files on the server that dangerously sit there forever in plain text. You could also determine just what records need to move, rather than export everything, import everything skipping duplicates, which would not scale to a big store. The store owner could issue you an API key and IP restriction, with only the level of access needed, so then you don't even have to worry about having credentials to the store.
    David Hubbard
    CIO
    Miva
    [email protected]
    http://www.miva.com

    Comment


      #3
      Great ideas, David, Thanks!
      Kent Multer
      Magic Metal Productions
      http://TheMagicM.com
      * Web developer/designer
      * E-commerce and Miva
      * Author, The Official Miva Web Scripting Book -- available on-line:
      http://www.amazon.com/exec/obidos/IS...icmetalproducA

      Comment

      Working...
      X