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 & ...Clearing order historyClearing order history
Previous
 
Next
New Post
2/5/2015 4:43 AM
 
shaggyspfld
No Ranking

Joined: 2/4/2015
Posts: 9

Is there anyway either through the GUI or via a script to clear the order history? I was doing testing and now it's almost time to go live and I want to remove all my test orders from the system so I start off with valid orders.

Also I noticed that with the store on a portal it's not possible to delete a user from the user manager.  It appears to of deleted the user, but since there is a foreign key constraint to the orders table and others the row doesn't actually delete from the dbo.[users] table.  it does remove it from the GUI of the user manager though so unless you look in the logs it appears to have worked.  Again this came out through testing because i was going through the entire process and trying to delete the account i created in the previous test run only to have it tell me on the next "Register" step that the userid was already in use.  I don't know if there is a way around this given that you'd lose order history, but i thought I would bring it up in case other got confused by the same behavior.
 
New Post
2/5/2015 11:37 AM
 
Nigel - Cart Viper Developer
4th Level Poster


Joined: 7/27/2010
Posts: 789

Hi,

Executing the below sql will delete all your Cart Viper orders:

delete from CVStore_OrderDetailsAttributes
delete from CVStore_OrderDetails
delete from CVStore_OrderAttributes
delete from cvstore_orders
 
New Post
2/5/2015 2:51 PM
 
shaggyspfld
No Ranking

Joined: 2/4/2015
Posts: 9
I do that, but when i process the next order cycle using the same testing information (to verify that the clear worked and that everything is reset and still functioning) i get this when running it through the paypal sandbox "

This invoice has already been paid. For more information, please contact the merchant." any suggestions?

 It does remove the orders from list till i go to process the next order, but it doesn't seem like it's entirely gone.  Either that or some primer information also gets lost.
 
New Post
2/5/2015 6:00 PM
 
Nigel - Cart Viper Developer
4th Level Poster


Joined: 7/27/2010
Posts: 789

When we send the transaction to PayPal we send the order ID which comes from the primary key cvstore_orders table. If your Paypal account has already processed a transaction with that order ID you get that message from PayPal, deleting the orders will reset the count on the cvstore_orders table.

What I would suggest is executing the below SQL as it will mean the next order ID should not have been processed by your PayPal account:

dbcc checkident('cvstore_orders',RESEED,50000) 

 
New Post
2/5/2015 10:44 PM
 
shaggyspfld
No Ranking

Joined: 2/4/2015
Posts: 9

ok, I think i got past that.  however, in using the paypal sandbox do you know if the ipn notifications come back and are processed the same?  I supposedly processed one through, but the order is still in "Processing status"  below is a snippet from the end of the audit log for the order.  I see a verified, but then I see a pending and I'm not sure if it's a problem with the module or with the sandbox.

 

 

2/5/2015 4:35:41 PM CV_STORE_ORDER_LOGGING result from paypal IPN verification: VERIFIED
2/5/2015 4:35:41 PM CV_STORE_ORDER_LOGGING order != null
2/5/2015 4:35:41 PM CV_STORE_ORDER_LOGGING checking currency
2/5/2015 4:35:41 PM CV_STORE_ORDER_LOGGING currency we comparing: US
2/5/2015 4:35:41 PM CV_STORE_ORDER_LOGGING currency valid
2/5/2015 4:35:41 PM CV_STORE_ORDER_LOGGING result of IPN check Pending
 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeIssues and Supp...Issues and Supp...Installation & ...Installation & ...Clearing order historyClearing order history


 

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