Difference between revisions of "Export All Customers"

From Skynet Software Wiki
Jump to navigation Jump to search
m (added a button)
m (corrections made)
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
===In This Section===
 
This section allows you to export the selected customers to a CSV file for manipulation in Excel.
 
This section allows you to export the selected customers to a CSV file for manipulation in Excel.
  
 
'''Last Ordered From'''<br />
 
'''Last Ordered From'''<br />
Use the date selection to select a date for ordered from, or leave blank to show all dates.<br />
+
Use the date selection to select a date for ordered from, or leave blank to show all dates. yyyy-mm-dd<br />
 +
 
 
'''Last Ordered To'''<br />
 
'''Last Ordered To'''<br />
Use the date selection to select a date for ordered to, or leave blank to show all dates.<br />
+
Use the date selection to select a date for ordered to, or leave blank to show all dates. yyyy-mm-dd<br />
 +
 
 
'''Total Spend Greater/equal than'''<br />
 
'''Total Spend Greater/equal than'''<br />
 
Limit to customers who have spent this amount or more.<br />
 
Limit to customers who have spent this amount or more.<br />
 +
 
'''Largest Order Greater/equal than'''<br />
 
'''Largest Order Greater/equal than'''<br />
 
Limit to customers who have an order greater than or equal to this amount.<br />
 
Limit to customers who have an order greater than or equal to this amount.<br />
 +
 
'''Total Orders Equals'''<br />
 
'''Total Orders Equals'''<br />
 
Limit to customers who have this amount of orders. Leave at zero to ignore.<br />
 
Limit to customers who have this amount of orders. Leave at zero to ignore.<br />
 +
 
'''Total Orders Greater/equal than'''<br />
 
'''Total Orders Greater/equal than'''<br />
 
Limit to customers who have this amount of orders or more.<br />
 
Limit to customers who have this amount of orders or more.<br />
 +
 
'''Total Returns Greater/equal than'''<br />
 
'''Total Returns Greater/equal than'''<br />
 
Limit to customers who have this amount of returns or more.<br />
 
Limit to customers who have this amount of returns or more.<br />
'''Then click run report'''<br />
+
 
[[File:Run-report.PNG|alt=Run=|Run]]
+
Then click run report[[File:Run-report.PNG|alt=Run=|Run]]

Latest revision as of 12:53, 4 November 2021

In This Section

This section allows you to export the selected customers to a CSV file for manipulation in Excel.

Last Ordered From
Use the date selection to select a date for ordered from, or leave blank to show all dates. yyyy-mm-dd

Last Ordered To
Use the date selection to select a date for ordered to, or leave blank to show all dates. yyyy-mm-dd

Total Spend Greater/equal than
Limit to customers who have spent this amount or more.

Largest Order Greater/equal than
Limit to customers who have an order greater than or equal to this amount.

Total Orders Equals
Limit to customers who have this amount of orders. Leave at zero to ignore.

Total Orders Greater/equal than
Limit to customers who have this amount of orders or more.

Total Returns Greater/equal than
Limit to customers who have this amount of returns or more.

Then click run reportRun=