Announcement

Collapse
No announcement yet.

Export orders to flat file

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

    Export orders to flat file

    Any way to edit the export orders to flat file? I need to run a daily export that includes all orders for the last day. It needs to contain the gross sales, postage, tax, sub total and order number of each order. Also would like it to run automatically at a given time.
    Gary

    [email protected]
    www.icCommerce.com

    #2
    Re: Export orders to flat file

    Using Miva's Batch reports, you can create a custom export of any order data you need in any format and have it export to a CSV file.

    This thread has a little background. But a feed like this usually takes around 10 hours to create.

    http://extranet.miva.com/forums/show...nt-information

    We can also automate it as well using Miva's Enterprise Connect tools, but that does require a dedicated server.
    Brennan Heyde
    VP Product
    Miva, Inc.
    [email protected]
    https://www.miva.com

    Comment


      #3
      Re: Export orders to flat file

      I noticed in Miva 9 > Home > Order Processing > Orders, there is a CSV button that creates a file containing fields displayed on the screen. Also under the setting button is a list of available fields to display. Any way to add the Postage, Tax and SubTotal fields to the list? This would create the file I need.
      Last edited by gsam; 11-07-14, 06:43 PM.
      Gary

      [email protected]
      www.icCommerce.com

      Comment


        #4
        Re: Export orders to flat file

        While it is possible to add new fields to that list, all three of those are not available at this time. If you click the three vertical lines icon on the far right, it will show you all the available fields for that screen.
        Brennan Heyde
        VP Product
        Miva, Inc.
        [email protected]
        https://www.miva.com

        Comment


          #5
          Re: Export orders to flat file

          I've created a custom batch report but I'm having some trouble downloading it as a csv.

          Does this look correct?
          Gary

          [email protected]
          www.icCommerce.com

          Comment


            #6
            Re: Export orders to flat file

            The word attachment needs to be in the value column. Everything else looks correct.
            Attached Files
            Brennan Heyde
            VP Product
            Miva, Inc.
            [email protected]
            https://www.miva.com

            Comment


              #7
              Re: Export orders to flat file

              Thanks.
              Gary

              [email protected]
              www.icCommerce.com

              Comment

              Working...
              X