Missing Order Numbers

[Shaun]

After noticing a gap of 7 between order numbers, I became curious and began perusing the tables in my Miva 5 MySQL database -- specifically s01_orders, s01_orderitems, s01_baskets, and s01_basketitems.

I found one of the "missing" orders in s01_baskets. The shipping/billing information was filled in but no shipping method, so I guess the shopper must have abandoned checkout on the OPAY screen.

I was unable to find any other "missing" orders. Thoughts on where they might be or why they don't exist? Is there a point in time where an order number has been "removed from circulation" but not placed in the order_id field in the s01_baskets table (ie. the order_id field remains 0)?

On a related note, I have WAY more baskets than visitors. Are spiders causing baskets to be created when they crawl my site? Should I care?

Thanks!

-Shaun

[Kiriyo]

When a shopper starts to complete an order, MIVA assigns it an order number. If the shopper abandons the order at any point after that, the order number is used up. So you'll see gaps in your order numbers all the time.

In our store I track the number of abandoned orders to see what may be frustrating our customers about the process, in order to streamline and improve the process for them in the future.