How to Display Orders Records by Range

How to Display Orders Records by Range

When you want an orders record based on the order range, you can use the query and export feature from the admin.

Here are the steps to display it.

  • Login to admin.
  • Go to Misc > Query and Export.

  • curbside pickup

  • For example, if you want to display orderid from 1 - 10, then use the command: select * from orders WHERE orderid BETWEEN 1 and 10
  • Click "Run Query".

  • curbside pickup

  • The query will appear and you can edit.

  • curbside pickup

  • You can also export to CSV by clicking the "Export to Excel" button.

  • curbside pickup


    curbside pickup

    curbside pickup

    For more information regarding Query and Export, please refer: https://helpnotes.vpcart.com/userguide900/#!Documents/querybuilder.htm


    Times Viewed:
    335
    Added By:
    Richard
    Date Created:
    7/17/2020
    Last Updated:
    7/17/2020