Where is the Articles List source please ?

Didier31

Avatar: Didier31

2009-02-09 16:56

Hi there,

What is the name of the module which lists all articles in the Admin menu ? And were is it please ?
I would like to disable the case sensitive sort feature. Article names are (and should) not (be) case sensitive. This messes up the list.

Thanks,

D.

» Quick.Cart v3.x

beholder

Avatar: beholder

2009-02-10 03:30

I just had a quick look at the source of core/products-admin.php and I think that (case-sensitive) sorting by product name is done somewhere else. Treewood help?

treewood (OpenSolution)

Avatar: treewood

2009-02-10 08:41

Please read this:
http://opensolution.org/Quick.Cart/docs/?id=db

You will get information where are defined columns to SORT

beholder

Avatar: beholder

2009-02-10 12:51

We know that. It's not about the columns but where to define not to do case-sensitive sort. Any help there?

Didier31

Avatar: Didier31

2009-02-10 13:02

I just received this message from QC Engineering :

Unfortunately we can't help You with this problem. We use official PHP function for sorting and
in ASCII, characters are in this order: 1...9, A-Z, a-z.

Now, let's see within the code what function is actually used among :

* usort()
* uasort()
* sort() and its numerous parameters
* asort()
* arsort()
* ksort()
* natsort()
* rsort()

and we'll see how to fix that.
Thanks for your (expected) support, beholder :-)

D.

Didier31

Avatar: Didier31

2009-02-10 13:08

Here is a temporary solution from db/xx-products.def.php :

$aFieldsSort = Array( 'iPosition', 'sName', 'iProduct', 'sAvailable', 'fPrice', 'sDescriptionShort', 'iStatus', 'sWeight', 'fPriceOld', 'iProducer', 'sSearchWords', 'fPrice2', 'fPrice3' );

iPosition is my friend, until we find how to disable this non-sense

I hate the guy who invented case sensitivity :-(

beholder

Avatar: beholder

2009-02-10 22:43

Actually, if you also properly sort your products in Excel, add the product positions accordingly and then export products to QC (and sort by position), your problem is solved.

Good lead on that sorting-by-position, btw.

cachousam

Avatar: cachousam

2009-02-17 14:20

How download my products in excel,and export to qc
Thanks

beholder

Avatar: beholder

2009-02-18 02:32

Have you actually tried, cachousam? The process of loading db/xx_products.php into OOo Calc or MS Excel is quite self-explanatory.

Back to top
about us | contact