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

Notification

Icon
Error

NP
#1 Posted : Monday, August 13, 2018 2:25:36 AM(UTC)
NP

Rank: Member

Joined: 2/10/2017(UTC)
Posts: 62
India
Location: Nashik, Maharashtra

Thanks: 6 times
Hello Team,

We are using BVC 2018. We have set up BVC 2018 on server. We have found that record get inserted into bvc_order table automatically with empty values and new Bvin is generated with status "Shopping Cart". For inserted order Ordernumber is inserted as empty string. We have verified the records in bvc_lineItem, bvc_OrderPayment and bvc_OrderPackage tables and the record counts are as expected in these tables. There are no extra entries in these tables like bvc_order table

So there is issue with bvc_order table only. We have export order and import shipment schedulers into BVC. We have same export order and import shipment schedulers in BVC2015. It is working properly in BVC 2015. We are facing these issue only in BVC 2018.

Kindly let us know your comments.

Thank You.
Aaron
#2 Posted : Monday, August 13, 2018 1:19:28 PM(UTC)
Aaron

Rank: Administration

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

Thanks: 6 times
Was thanked: 158 time(s) in 153 post(s)
It doesn't sound like an issue. A shopping cart is just an unplaced order, so the bvc_Order table holds both shopping carts and placed orders. The easiest way to tell them apart is to look at the IsPlaced field/property. A value of 1 means that the order has been placed; a value of 0 means that it has not and is still a shopping cart.
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
NP
#3 Posted : Tuesday, August 14, 2018 6:34:05 AM(UTC)
NP

Rank: Member

Joined: 2/10/2017(UTC)
Posts: 62
India
Location: Nashik, Maharashtra

Thanks: 6 times
Hello Team,

Thank You for the reply.
As per above comments the order having IsPlaced value "0" are unplaced order. But This site is under internal testing phase and we are not placing these much order which we received in bvc_order table count.

While verifying setting done in BVC 2015 and BVC 2018, we find out the difference in setting for order "Cleanup Orders Older Than" and "Run Cleanup Every" properties in below path
Options=>Site Settings=> Orders

Please find attached image for the reference. Could you please explain the purpose of above setting/property

Thank You.
NP attached the following image(s):
OrderSetting.png (99kb) downloaded 1 time(s).

You cannot view/download attachments. Try to login or register.
Aaron
#4 Posted : Tuesday, August 14, 2018 12:28:30 PM(UTC)
Aaron

Rank: Administration

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

Thanks: 6 times
Was thanked: 158 time(s) in 153 post(s)
The cart cleanup process deletes carts (i.e. unplaced orders) based on these settings. From your screenshot, the process will run once every 24 hours and delete carts older than 30 days.
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
NP
#5 Posted : Thursday, August 16, 2018 12:15:28 AM(UTC)
NP

Rank: Member

Joined: 2/10/2017(UTC)
Posts: 62
India
Location: Nashik, Maharashtra

Thanks: 6 times
Thank You 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.

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