Negative values in order total. Edit Orders Problem

[swguy]

The current values of orders_total.value *should* be positive unless you've diddled with them, in which case you should probably restore from backup.

The values of of orders_total.text might not show a "-" if you haven't used the fix I described.

I think I just fixed them in phpMyAdmin - I don't seem to have a script that does this.

[DigitalShadow]

some are positive some are negative, it is a mess.

The fix you described is already in my edit orders

What about the reward point module, how does that interact with edit orders and this - problem

[swguy]

OK. Fixing negative values field:

1) Make a backup
2) Run this SQL
update orders_total set value = value * -1 WHERE value < 0;

On the rewards stuff, I have no idea. Ask the rewards mod author.

Give me a bit and I'll figure out how to fix the text field.

[swguy]

OK, this has Zen Cart's built in group pricing and coupons plus all my stuff. You probably don't need all this but it's here for reference.

Again, backup first.

update `orders_total` SET text = concat('-', text) WHERE substring(text, 1, 1) <> '-' AND class in ('ot_coupon', 'ot_group_pricing', 'ot_better_together', 'ot_big_chooser', 'ot_bigspender_discount', 'ot_combination_discounts', 'ot_frequency_discount', 'ot_quantity_discount', 'ot_newsletter_discount', 'ot_military_discount');

[DigitalShadow]

I presume I can dump ot_reward_points in there too.

The strange thing is, the totals still don't add up, (in monthly sales/tax summary) and I can't figure out why!

[swguy]

Please stick to one problem per thread. Get the table fixed and then open a new thread or post to the support thread about your issues with the tax summary mod.

[DigitalShadow]

Will do, what is the default layout for the text field?

-&pound;15.75
or
&pound;-15.75



Also, your code turns

&pound;-15.75 into -&pound;-15.75

which looks odd, -£-15.75

[swguy]

There is no default; it depends on what the software does. You'd have to look at each module. Mine all do -$. Look at coupon and gv to see how they work.

If you get -£-15.75 then fix it. I already posted a SQL query which does string modification. Figure out how to make this fix -L- into -L.

[DigitalShadow]

I understand concat('-', text)

but I'm stumped by

WHERE substring(text, 1, 1) <> '-'


Sub-Total: £24.99
Value of Redeemed Reward Points: -£2.50
FastFix≡ (Collect from our store, your goods will be waiting for you!): £0.50
Total: £27.99

I can see a problem with that total...

is that a edit/super orders issue?

[DigitalShadow]

where the reward_points are being added instead of removed, resulting in £2.50 discount becoming a £2.50 surcharge, showing a £5 difference between expected and displayed.