Negative values in order total. Edit Orders Problem

[DigitalShadow]

In orders_total the ot_group_pricing class shows values as positive, this results in the wrong values being shown in edit orders.

Can someone write me some sql code that will enable me to change all positive 'value' where 'class' = ot_group_pricing in orders_total as doing 898 one by one would be just too much!

[DigitalShadow]

Is it possible to modify the code so that any negative values, i.e. group pricing or reward points are stored as negative values in the ordertotals database table?

[swguy]

You're going to have to do a database query to fix the values you already have. If someone doesn't post it before I get home I'll post it then.

For the code change to prevent future problems, here are the instructions.

http://thecartblog.com/2009/12/21/ze...counting-mods/

I notice that Edit Orders 3.0 has this problem partially fixed; I'll fix that at some point this month.

[Kim]

Moderator's note: thread moved to the appropriate forum.

[DigitalShadow]

I have latest version of edit orders.

I use reward points and group discount, these need to be stored as negative values in the order_totals table so that my exporting of sales data is shown correctly

[DigitalShadow]

This isn't an edit orders problem, as a fresh order stores the values as positive before I even look at the order. (checked in the database)

[DrByte]

Right. It's your order export routine which needs improvement.

Zen Cart's architecture stores the 'value' field without a minus sign, because it knows that the line item is a negative amount based on the order total module used for that line item.

If you want to rewrite the core code to work entirely differently just so you don't need to change your export process, feel free.

If you go changing existing data then all your order details will show up incorrectly for your customers and in your admin panel.

Maybe you should change your export approach?

[DigitalShadow]

I'm using a mod on this website that is verified for version 1.5

monthly_sales_and_tax_summary_report_1-4

It isn't calculating my sales correctly.

The amount of "deductions" aren't adding up to the correct amount.

So what are you saying, go the other way? Make everything positive and then figure a solution from there.

[DigitalShadow]

I switched to ver 1-3 as not on 1.5x

Right, if I update all values to be positive, everything should be grand.

Fix the edit/super orders problem with reward points and we are sorted.

[DigitalShadow]

Can anyone help me with a piece of code that will ensure that all my current values are positive and the text values are formatted correctly to reflect - figures

should it show

-£15.75
or
£-15.75