[fixed] Orders not reporting correct quantity Reply to topic

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.

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

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...

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

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...

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....

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

It still does it....

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

Mine works flawlessly every time

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

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....

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.

no need to if that was all that was done.

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?

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.

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...

could it be the mysql version I have?