Cart Viper Logo

We understand that your ecommerce site is crucial to the success of your business, from time to time issues and questions can arise and you need to have the assurance there will be someone on hand to help resolve these in a timely fashion so you can spend your time driving your own business forward.

So if you are looking for faster responses to your questions or would like the assurance there is someone on hand for you to contact, fear not we have a number of paid support options that are available to you that can give your organisation the peace of mind knowing a member from the Cart Viper team will always be available to assist!

Purchase a Support Plan

Community Support

HomeHomeIssues and Supp...Issues and Supp...Installation & ...Installation & ...Order NumbersOrder Numbers
Previous
 
Next
New Post
3/27/2013 8:06 PM
 
spoynor
No Ranking

Joined: 3/14/2013
Posts: 6
Is there a way to set what number the order number begins at?  Also, my client has an issue in that the order numbers skip  (i.e.  1045 then 1050 as the next order)  I assume that the numbers in between are orders that were abandoned, but I cannot view them.  Is there a way to force the order numbers to generate in sequence (without the gaps)?
 
New Post
3/28/2013 8:37 AM
 
Nigel - Cart Viper Developer
4th Level Poster


Joined: 7/27/2010
Posts: 789
By executing the below sql via host -> sql you will start the next order ID at 3000, note it is very important if you change the order ID it is a bigger number than the last order ID in the table cvstore_orders

dbcc checkident('cvstore_orders',RESEED,3000)

You are correct the missing numbers are orders that were never completed, we have a graph showing the number of abandoned carts in the store admin -> sales stats or alternately you can look in table cvstore_orders. Due to the way CV works you will not get consecutive order numbers.

Thanks
Nigel. 
 
New Post
9/19/2016 7:03 PM
 
Brian Duffy
No Ranking

Joined: 9/11/2012
Posts: 14
I would urge you to reconsider this design of disappearing order numbers (because of an abandoned cart) in the sequence.  It alarms my clients as well because it is not a good accounting practice.  An auditor would take serious issue with this because of the lack of audit trail.

It would be better to record the order number in the order table (and the order report) showing the abandoned order numbers with "abandoned cart" next to it.  So it's like a canceled order.

Better design: In other checkout systems that I have implemented, an order number is not assigned until the cart is completed and a payment or option to pay later has been verified.  That is how accounting is supposed to work.  If the checkout process is not completed 100%, it is a quote/estimate, not an order.
 
New Post
9/20/2016 12:27 PM
 
Mark - Cart Viper Developer
7th Level Poster


Joined: 7/27/2010
Posts: 424
Hi Brian

We totally agree that the order numbers need to be improved so that they are consecutive and hence you no longer will see order number gaps. It would make the system appear to work better for the client/store owners.

We wouldn't display the abandoned orders in the UI.

As you would imagine its a lot of work to implement the change. We would be happy to add this to roadmap so that a future version of Cart Viper will have this feature. If you would like to see this implemented in the next few weeks we would be prepared to subsidize this work and only charge a day for implementing when its going to take a lot longer. If you are interested in sponsoring the feature please email me at mark@cartviper.com

Regards

Mark
 
 Page 1 of 1
Previous
 
Next
HomeHomeIssues and Supp...Issues and Supp...Installation & ...Installation & ...Order NumbersOrder Numbers


 

We use cookies on our website to improve our service to you, by continuing you agree to our use of cookies. However you are able to update your settings at any time.

Continue View Cookie Policy Cookie Settings

Cookie Policy

A cookie, also known as an HTTP cookie, web cookie, or browser cookie, is a piece of data stored by a website within a browser, and then subsequently sent back to the same website by the browser. Cookies were designed to be a reliable mechanism for websites to remember things that a browser had done there in the past, which can include having clicked particular buttons, logging in, or having read pages on that site months or years ago.

Strictly Necessary Cookies

These cookies cannot be disabled

These cookies are necessary for the website to function and cannot be switched off. They are normally set in response to your interactions on the website e.g. logging in etc.

Cookies:
  • .ASPXANONYMOUS
  • .DOTNETNUKE
  • __RequestVerificationToken
  • authentication
  • CV_Portal
  • CV_Store_Portal_Cart_0
  • CV_USER
  • dnn_IsMobile
  • language
  • LastPageId
  • NADevGDPRCookieConsent_portal_0
  • userBrowsingCookie

Performance Cookies

These cookies allow us to monitor traffic to our website so we can improve the performance and content of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited or how you navigated around our website.

Cookies:
  • _ga
  • _gat
  • _gid

Functional Cookies

These cookies enable the website to provide enhanced functionality and content. They may be set by the website or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.

Cookies:

Currently we are not utilizing these types of cookies on our site.

Targeting Cookies

These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.

Cookies:

Currently we are not utilizing these types of cookies on our site.

Feedback