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...MiscellaneousMiscellaneousOrder not marked as complete via PayPalOrder not marked as complete via PayPal
Previous
 
Next
New Post
5/9/2011 9:35 AM
 
Hi, using DNN 5.6.1 and CV 1.2.4c (just upgraded to 1.2.7 when we noticed the problem today).

Our client has received an order on their site and the customer paid via PayPal. Our client received the email order confirmation email from PayPal but the site does not show the order in the Store Admin->Orders page.

Looking in the database, we can see the order in the Orders table but the "OrderIsPlaced" field is still set to 0 so i assume this is why it's not showing in the orders page.

Would you know why this would happen? Can we manually change"OrderIsPlaced" to 1 so our client can begin to process the order?

The same customer had problems submitting an order as a guest and they said that the site was telling them that the system could not deliver to their postcode - we haven't been able to reproduce this problem so wanted to know what would cause this? We have shipping rates which only cover the UK and a certain price range but if the user doesn't meet this criteria then the system will tell them it can't ship it and does not mention the postcode problem. Can you shed any light on this? The user then registered and was able to place the order using PayPal but we've come across the problem above.

Hope you can help.

Thanks
Dan
 
New Post
5/9/2011 10:24 AM
 
Hi Dan

Firstly if you're site is not getting the orders marked as paid its likely the IPN callback from the Paypal servers is not getting processed correctly.
This callback is used to notify the module that the order has been paid.

Can you confirm the following.
1. The my account page is available to anonymous users. This page is used to handle the IPN request so it needs to be available to all users since the request from Paypal won't have any authentication cookies.

2. Have you looked in the event log, do you see any exceptions being thrown at the time the order was placed.

3. We record a log of the IPN in a table, you can query this table using the script below. I'd be interested in seeing this (please email me the output).

select * from {databaseOwner}[{objectQualifier}cvstore_orderattributes] where parentId=1000
change the parentId parameter to be the orderId for the order you are having issue with.


Since you know the order has been paid you can manually change the following fields for the order in the cvstore_orders table, this will mark the order as paid and placed
orderIsPlaced = 1
OrderStatusID = 2

Not sure where the postcode caption is coming from, is this on the customers site or is this when they are on Paypal?
I've just search the resource files we use and we don't have any postcode warning caption hence my question about if this is something Paypal is displaying?
The shipping provider only works by country and doesn't perform any validation on the postcode field.

Regards

Mark
 
Previous
 
Next
HomeHomeIssues and Supp...Issues and Supp...MiscellaneousMiscellaneousOrder not marked as complete via PayPalOrder not marked as complete via PayPal


 

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.

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