• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

kavi
#1 Posted : Monday, October 15, 2018 6:07:57 AM(UTC)
kavi

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?

Aaron
#2 Posted : Monday, October 15, 2018 7:39:42 AM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,220
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 138 time(s) in 133 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
kavi
#3 Posted : Monday, October 15, 2018 7:41:30 AM(UTC)
kavi

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
Aaron
#4 Posted : Tuesday, October 16, 2018 1:07:56 PM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,220
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 138 time(s) in 133 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
kavi
#5 Posted : Wednesday, October 17, 2018 2:11:26 AM(UTC)
kavi

Rank: Member

Joined: 10/15/2018(UTC)
Posts: 4

Thank you so much for the reply
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.

©2018 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012