Rank: Member
Joined: 1/10/2005(UTC)
Posts: 714
Thanks: 14 times
Was thanked: 1 time(s) in 1 post(s)
|
I can open up my database and export my orders into excel, but there are a lot of orders that were not placed. Does anyone know of a query that will pull out only orders that have been placed (have order numbers) so I can view them in excel?
|
|
|
|
|
|
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)
|
The IsPlaced field must be set to 1, denoting an actual order vs a cart. So, a simple query would look like this: Code:SELECT *
FROM bvc_Order
WHERE IsPlaced = 1
|
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 6/1/2004(UTC)
Posts: 720
|
I would be VERY (and would be willing to pay for it) interested in something like this too that would allow extraction of the orders to excel as opposed to straight into QuickBooks.
Thanks,
Derek |
|
|
|
|
|
|
Rank: Member
Joined: 1/10/2005(UTC)
Posts: 714
Thanks: 14 times
Was thanked: 1 time(s) in 1 post(s)
|
Ive got my orders exported, but the billing info and shipping info looks to be xml so I dont know how to get each field to be seperate.
|
|
|
|
|
|
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)
|
Derek and Bryan,
Sounds like you guys should get together and hire a developer and split the cost. We're pretty busy at the moment, but I'm sure that any BV developer can easily handle this task. |
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.