Exclusive eBooks, Software Solutions, Quality Guaranteed
 
Web NukeBiz
Welcome to NukeBiz · Members
Forums » DragonflyCMS Projects » Storez » [fixed] Orders not reporting correct quantity
[fixed] Orders not reporting correct quantity
A comprehensive shopping cart solution.
Topic initiation via Bugger.

Go to page 1, 2  Next
Post new topic    Reply to topic    Printer Friendly Page     Forum Index »  eCommerce » Storez

View previous topic :: View next topic  
Author Message
AIPman1
Nice Poster
Nice Poster

Offline Offline
Joined: Jan 16, 2008
Posts: 30

PostPosted: Tue Jan 22, 2008 11:25 am
Post subject: [fixed] Orders not reporting correct quantity

In testing my store operation, the orders reported to the database are wrong. If I ordered 2 of something that's .50, then the price and shipping set is currently adding correctly and everything in the order build side, but once confirmed, and e-mail sent, the e-mail says:

Order Number: 4
Order Date: 01/21/2008

Products Ordered
------------------------------------------------------
0 x [DSP-TAM1] Minicomics The Adventures of Marky #1 = $0.00

------------------------------------------------------
Product Total: $1.00
Shipping/Handling Charge: $0.20
Tax: $0.00

Total: $1.20

Billing Address || Payment Method: PayPal/Credit Card/eCheck
-------------------------------------

it's not passing on the correct quantity.

Then, if you click the link back to view the order, it says

Product Qty. Unit Cost Total
Minicomics: The Adventures of Marky #1 0 $2.00 $0.00
Product Total: $1.00
Shipping/Handling Charge: $0.20
Tax: $0.00

Total: $1.20
------------------------------------
so, the unit cost is being reported there as $2.00. It still has the correct order cost...but the rest is just off.

Let me know on that, I'm going to look for file corruptions, as I've had that problem with my uploads lately.

Initiated by Bugger (Original Entry) - Comments Here Please.


AIPman1's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/Apache 2.0.54 (Fedora)/4.1.20/5.0.4/9.1.2.1
Back to top
View user's profile Visit poster's website
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 18, 2004
Posts: 1525
Location: Netizen
PostPosted: Tue Jan 29, 2008 4:37 pm
Post subject: Re: Orders not reporting correct quantity

I need to know what the link is when this happens.

_________________
DonationsPro for vBulletin, SMF, MyBB, DragonflyCMS


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
AIPman1
Nice Poster
Nice Poster

Offline Offline
Joined: Jan 16, 2008
Posts: 30

PostPosted: Wed Jan 30, 2008 12:04 am
Post subject: Re: Orders not reporting correct quantity

You'd start an order at this site:

www.dimestoredistro.com/

there's only one product in the store so far to test, so if you add it to the cart, and view the cart, it's correct at that stage:

www.dimestoredistro.co...wCart.html

Clicking Checkout, it is still correct:

www.dimestoredistro.co...pping.html

it stays correct through the adding of shipping and payment addresses, and is correct at the checkout confirm stage:

www.dimestoredistro.co...ation.html

but when you click confirm order, the page that then displays....

www.dimestoredistro.co...Order.html

has the quantity at 0 and the unit cost wrong, although the amount to pay and the shipping amount are both correct for the order.

It DOES take one copy out of the inventory record for the item.

If you click the link that is sent in the e-mail for the order:

www.dimestoredistro.co...613df.html

it shows the zero quantity and wrong price, but the right total and shipping as well.

If you need to get into my system, ether as a superuser on the site, or into the server itself, I can do that, it's on a dedicated set up, I have full access.

I thank you for helping with this problem. As do the hundreds of publishers in my association, who LOVE the new site...


AIPman1's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/Apache 2.0.54 (Fedora)/4.1.20/5.0.4/9.1.2.1
Back to top
View user's profile Visit poster's website
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 18, 2004
Posts: 1525
Location: Netizen
PostPosted: Wed Jan 30, 2008 12:21 am
Post subject: Re: Orders not reporting correct quantity

It may not make any difference, but you don't appear to have the latest version of Storez?

_________________
DonationsPro for vBulletin, SMF, MyBB, DragonflyCMS


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
AIPman1
Nice Poster
Nice Poster

Offline Offline
Joined: Jan 16, 2008
Posts: 30

PostPosted: Wed Jan 30, 2008 12:44 am
Post subject: Re: Orders not reporting correct quantity

I thought I did, the folder i dowloaded was 9.1.2 - but I can re-download and replace the files if you think I should...


AIPman1's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/Apache 2.0.54 (Fedora)/4.1.20/5.0.4/9.1.2.1
Back to top
View user's profile Visit poster's website
AIPman1
Nice Poster
Nice Poster

Offline Offline
Joined: Jan 16, 2008
Posts: 30

PostPosted: Wed Jan 30, 2008 1:27 am
Post subject: Re: Orders not reporting correct quantity

I downloaded a fresh copy, and uploaded the files over the ones I had up. I'm still getting the same problem...

I'm going to turn off all blocks and other things on the site, make sure something else isn't interfering with the store....


AIPman1's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/Apache 2.0.54 (Fedora)/4.1.20/5.0.4/9.1.2.1
Back to top
View user's profile Visit poster's website
AIPman1
Nice Poster
Nice Poster

Offline Offline
Joined: Jan 16, 2008
Posts: 30

PostPosted: Wed Jan 30, 2008 1:33 am
Post subject: Re: Orders not reporting correct quantity

well, did that too, and even tried changing the theme to a default one just in case.

It still does it....


AIPman1's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/Apache 2.0.54 (Fedora)/4.1.20/5.0.4/9.1.2.1
Back to top
View user's profile Visit poster's website
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 18, 2004
Posts: 1525
Location: Netizen
PostPosted: Wed Jan 30, 2008 1:47 am
Post subject: Re: Orders not reporting correct quantity

hmm, I can see it happening on your site, but damned if I can reproduce it.

Mine works flawlessly every time Confused

Only thing that is different in your case is the multiple payment option which you seem to have edited.

_________________
DonationsPro for vBulletin, SMF, MyBB, DragonflyCMS


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
AIPman1
Nice Poster
Nice Poster

Offline Offline
Joined: Jan 16, 2008
Posts: 30

PostPosted: Wed Jan 30, 2008 2:03 am
Post subject: Re: Orders not reporting correct quantity

All I did there was add words to the cart display name, and the cart display info for each option I activated. I can try to turn them off and remove the words, but shouldn't we be able to add such safely? it's stored in the database... report in a minute....


AIPman1's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/Apache 2.0.54 (Fedora)/4.1.20/5.0.4/9.1.2.1
Back to top
View user's profile Visit poster's website
AIPman1
Nice Poster
Nice Poster

Offline Offline
Joined: Jan 16, 2008
Posts: 30

PostPosted: Wed Jan 30, 2008 2:11 am
Post subject: Re: Orders not reporting correct quantity

well, I turned off other options for checkout, and took the extra wording off the Paypal option, and - it still does it.

I actually think I'll leave it that way regardless, one less page in the checkout, and I can add wording on the checkout confirmation that if they do not want to pay with PayPal they can mail in the $$...

If I can get over this reporting hump, lol. It's gotta be something simple I'd think.


AIPman1's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/Apache 2.0.54 (Fedora)/4.1.20/5.0.4/9.1.2.1
Back to top
View user's profile Visit poster's website
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 18, 2004
Posts: 1525
Location: Netizen
PostPosted: Wed Jan 30, 2008 2:11 am
Post subject: Re: Orders not reporting correct quantity

no need to if that was all that was done.

_________________
DonationsPro for vBulletin, SMF, MyBB, DragonflyCMS


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
AIPman1
Nice Poster
Nice Poster

Offline Offline
Joined: Jan 16, 2008
Posts: 30

PostPosted: Wed Jan 30, 2008 2:15 am
Post subject: Re: Orders not reporting correct quantity

could there be a writing permission I've missed? Does having the site database shared with other sites that are using the same membership base make a difference?


AIPman1's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/Apache 2.0.54 (Fedora)/4.1.20/5.0.4/9.1.2.1
Back to top
View user's profile Visit poster's website
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 18, 2004
Posts: 1525
Location: Netizen
PostPosted: Wed Jan 30, 2008 2:31 am
Post subject: Re: Orders not reporting correct quantity

I wouldn't have thought so - I cannot reproduce it, despite testing numerous permutations, so I'll just have to leave it on hold until it can be reproduced by someone else.

_________________
DonationsPro for vBulletin, SMF, MyBB, DragonflyCMS


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
AIPman1
Nice Poster
Nice Poster

Offline Offline
Joined: Jan 16, 2008
Posts: 30

PostPosted: Wed Jan 30, 2008 2:38 am
Post subject: Re: Orders not reporting correct quantity

would going into the back end of my site help? is there anything I can look at to help? I'd really like to use and figure out this system as our store...


AIPman1's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/Apache 2.0.54 (Fedora)/4.1.20/5.0.4/9.1.2.1
Back to top
View user's profile Visit poster's website
AIPman1
Nice Poster
Nice Poster

Offline Offline
Joined: Jan 16, 2008
Posts: 30

PostPosted: Wed Jan 30, 2008 2:40 am
Post subject: Re: Orders not reporting correct quantity

could it be the mysql version I have?


AIPman1's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/Apache 2.0.54 (Fedora)/4.1.20/5.0.4/9.1.2.1
Back to top
View user's profile Visit poster's website
Display posts from previous:   
Post new topic    Reply to topic    Printer Friendly Page    Forum Index »  eCommerce » Storez
Page 1 of 2
All times are GMT + 9.5 Hours
Go to page 1, 2  Next



Jump to:  


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum