Rank: Member
Joined: 2/10/2017(UTC) Posts: 62 ![India]( "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.
|
|
|
|
|
|
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 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 |
|
|
|
|
|
Rank: Member
Joined: 2/10/2017(UTC) Posts: 62 ![India]( "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.
|
|
|
|
|
|
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 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 |
|
|
|
|
|
Rank: Member
Joined: 2/10/2017(UTC) Posts: 62 ![India]( "India") Location: Nashik, Maharashtra Thanks: 6 times
|
|
|
|
|
|
|
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.