Rank: Member
Joined: 10/15/2018(UTC)
Posts: 4
|
In BV Commerce (2017.0.0.1575) we have an option for exporting an order from the backend. But doing an export from backend am not getting all the information I needed for the order. How I can do it to achieve all information like products that have been purchased for the respective orders?
|
|
|
|
|
|
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 order export is a 'summary' export, meaning it does not export line items. You will need to create a custom export or modify the existing one to give you the data that you need; alternately you can use SQL to query the database directly. |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 10/15/2018(UTC)
Posts: 4
|
Can you please the give the sql query to get the line items. (as am new to bv commerce) just I need the datas from BV Commerce
|
|
|
|
|
|
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 line items of an order are in the bvc_LineItem table. You can join to the order table (bvc_Order) using the bvin of the order table to the OrderBvin of the line item table. You may need/want other bits of data related to the order, but this should get you started. |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 10/15/2018(UTC)
Posts: 4
|
Thank you so much for the reply
|
|
|
|
|
|
|
|
Message was deleted by a Moderator. | Reason: Not specified
|
|
|
|
|
|
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.