False SOLDs

dknelson · June 2nd, 2011, 08:58 AM

I have a vendor who has his items listed with multiple quantities. He entered 999 as available. There are two problems.

Every couple of days, his ads are getting changed to "SOLD" but he is getting no notification of any buyer. I go to his ads and they are marked sold but the quantity is still at 999. Even if somebody makes a purchase though, the ads should not be marked sold when he still has a large quantity available.

So, what would cause them to be marked sold if there is no buyer.

Chuck S · June 2nd, 2011, 09:58 AM

sold could also mean expired?

If you look in the database what is entered in the enddate and status fields for that ad.

I would need to know what is there to theorize on what your issue might be.

dknelson · June 2nd, 2011, 01:30 PM

Endate: 0

Status: 0

Duration: 9999

Quantity: 999

Chuck S · June 2nd, 2011, 01:46 PM

Status should be 0 if its an active ad so I see no way at all you could be seeing sold when viewing the ad if status is 0. That information shows it is an active ad with no expiration and a quantity of 999.

dknelson · June 2nd, 2011, 02:05 PM

Yes, I'm sorry. I had already hit Re-List so will have to wait until it happens again.

Chuck S · June 2nd, 2011, 02:34 PM

Not a problem

dknelson · August 3rd, 2011, 04:53 PM

OK...I'm still having a problem with this. I have a member that listed his items yesterday. He listed them with a quantity of 500. Now it shows a quantity of 499 and his item is marked "SOLD". Why would it be marked sold if he still has many available. In addition to that, he doesn't appear to have sold any of either item.

enddate: 0

status: 1312345807

duration: 9999

quantity: 499

His other item:

enddate: 0

status: 0

duration: 9999

quantity: 500

Chuck S · August 3rd, 2011, 06:00 PM

The problem that I see is status is a number however nowhere am I seeing in our code if quantity is over 1 would status ever be updated. If quantity is multiple in the code when you sell an ad or he marks it sold whichever happens we update the enddate and lower the quantity by 1.

My suggestion is you can go into the database and set his status back to 0 on that one ad but you should redownload the build and upload all the core php files. See if that helps.

dknelson · August 4th, 2011, 05:59 AM

I did exactly what you said. I uploaded all the original files even though I hadn't modified them. I reset the status of three ads to "0". All three of these ads showed multiple items available.

I did all that last night. This morning, all three ads were marked sold. The status on all three was changed from a "0" to a number, quantity had not decreased. Seller emailed me to let me know that he had actually sold NONE of any of the items.

I truly don't understand this one.

dknelson · August 4th, 2011, 06:23 AM

One further thought. Maybe I'm causing this problem. We discussed before that we need an option to make some ads in some categories "never expire". You had confirmed that a temporary way to get around the lack of this option was to go into the database and change the enddate to 0. That is what I am doing on these ads. After they are listed, I go into the database and change the enddate to 0 and the duration to 9999.

When I do that, they seem to be OK just after doing it but could it be causing the problem?

dknelson · August 4th, 2011, 07:16 AM

One last thing. I decided to try and add the "no expiration" to the listing options.

I added this to the upload template per discussion in another thread.

<option value="9999">{$pp_phrase['noexpire']}</option>

I then tried to place a test ad using this option and I got a message that "the system has encountered an error, please try again later". So obviously it takes more than that one line to add the no expire option back in.

Chuck S · August 4th, 2011, 09:06 AM

You could be possibly be sure but like I said you want to redownload the software from our site not your backups and replace the files to make sure you are completely 100% using the right files. enddate should not be 0

relisting an ad status is set back to 0 not enddate

dknelson · August 4th, 2011, 10:39 AM

OK...but I didn't exactly upload them for a backup. I uploaded them from the original zip file that I downloaded the last time.

So, if I want to set an ad to never expire, what should the end date be?

Chuck S · August 4th, 2011, 10:44 AM

right but I noted to download the build cause that way if yours is older and ours contains the most update code you want that.

If you want a noexpire option you need to add that to the upload template and the correct enddate would be added.

dknelson · August 4th, 2011, 10:48 AM

I added this to the upload template per discussion in another thread.

<option value="9999">{$pp_phrase['noexpire']}</option>

I then tried to place a test ad using this option and I got a message that "the system has encountered an error, please try again later". So obviously it takes more than that one line to add the no expire option back in.

Chuck S · August 4th, 2011, 11:04 AM

well that should not cause an error if your using the correct files. You can turn your debug option to display errors if your logged in as admin and see the real error. Like I said your probally using older files.