Rank: Member
Joined: 2/26/2007(UTC)
Posts: 57
|
How can I print off my entire customer/order list or at least get it in a file format like CSV?
|
|
|
|
|
|
Rank: Member
Joined: 4/10/2009(UTC)
Posts: 120
Location: Mechanicsville, VA
Thanks: 3 times
Was thanked: 1 time(s) in 1 post(s)
|
Will need to run a sql query for this information.
All of the orders are in BVC_ORDER table, and can be inner joined on the BVC_PEOPLE table to show the customer information for each order. This would only show the order information and who ordered it. If you are looking for something much more detailed, like a list of orders and items and address information and statuses and everything.... the query will need much more detail. |
Tim
|
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
It's actually the bvc_User table, not the bvc_People table. |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 2/26/2007(UTC)
Posts: 57
|
Thanks guys, but how do I do this?
|
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
You would need to know how to use SQL Server and download the appropriate software. If you're not comfortable with this, you can have a developer create a custom report for you. |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.