← Back to team overview

openerp-expert-ergonomy team mailing list archive

Re: [Magentoerpconnect-community] sale order default sort order


2011/1/6 Sharoon Thomas <sharoonthomas@xxxxxxxxxxxx>

> Hi all,
> I suggest _order by date.$
Right, OpenERP guys, any reason to keep ordering on the name by default in
the core of OpenERP?

> The order by name is unintuitive whether the connector is installed or not.
> This in addition to being simple to implement also leaves an easy option if
> the end user wants to change the behaviour rather than introducing a schema
> change.
> Another implementation could be doing the same on a different
> action/window/view/menu so that the default behaviour is retained but a
> different action  does what we want.

All right, but then how do we implement that? Unless I'm missing some new
hidden v6 hack, there is no way to declaratively specify an order at the
menu or action_window or view level, right?

So what do we do? Put some context key in the existing order list
action_window and then override the search method of the sale order object
in the base_sale_multichannels module to inject the "date" as the order
param in the super search method call when we find that trigger key in the

Anything better, any reason not to do so? Thank you in advance.

Raphaël Valyi
Founder and consultant
+55 21 3010 9965

> Sharoon Thomas
> http://openlabs.co.in
> On 6 Jan 2011 20:31, "Raphaël Valyi" <rvalyi@xxxxxxxxx> wrote:
>  Hello Magentoerpconnect and OpenERP usability experts,
> As you might know, magentoerpconnect can import orders from several web
> shops.
> What happens is that Magento use to have different sale order sequences for
> each shop.
> But, unlike OpenERP, it's a pure numeric sequence.
> For instance:
> shop 1: 10000XXXX
> shop 2: 20000XXXX
> etc...
> When importing those orders in OpenERP we just prefix them by "mag_" and
> write that in the order name for easy lookup. so we have: mag_10000XXXX for
> instance.
> But by default OpenERP use the order name to sort the sale orders.
> That means that by default you won't see your last Magento orders unless
> you click twice on the date column (because name alphabetical order will
> differ from date order depending on the shop you import).
> This sucks!
> What do you think we should do to improve that?
> 1) override sale order default order to make OpenERP sort by date?
> 2) change the default order directly in OpenERP and make it order by date?
> 3) use a unique OpenERP sequence and store the order name elsewhere?
> 4) other?
> Please give me you suggestions. Thanks in advance.
>  --
> Raphaël Valyi
> Founder and consultant
> +55 21 3010 9965
> www.akretion.com
> _______________________________________________
> Mailing list: https://launchpad.net/~magentoerpconnect-community
> Post to     : magentoerpconnect-community@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~magentoerpconnect-community
> More help   : https://help.launchpad.net/ListHelp