Announcement

Collapse
No announcement yet.

Possible to generate a report for customer order information with purchase category

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

    Possible to generate a report for customer order information with purchase category

    I am looking to generate a report that would include the following

    1) Customer Login ID
    2) Order Information like order total, shipping total
    3) Order Items
    4) Product Category

    Is this possible to generate such a report from the Dashboard or do I need to run a SQL query.

    Please advise and thanks
    Keyboard Not Found..... Press F1 to continue

    #2
    You can create a custom report using a Template Based Based Batch Report. Here are a couple related examples to give you an idea of how to work with the data:

    https://docs.miva.com/code-samples/coupon-batch-report

    https://docs.miva.com/code-samples/b...kordered-items
    Brennan Heyde
    VP Product
    Miva, Inc.
    [email protected]
    https://www.miva.com

    Comment


      #3
      Hi Brennan,

      Thanks for sending you these samples. Appreciate it.

      Quick question, Will I be able to add product category name to each order item line.

      Keyboard Not Found..... Press F1 to continue

      Comment


        #4
        Hi Brennan,

        I was able to get the product category code using the following token.

        l.settings:item:product:catcount

        Thanks for providing the sample code link again.
        Keyboard Not Found..... Press F1 to continue

        Comment

        Working...
        X