Prev/next button goes 16 products prev/after

-- url of the page with the problem -- : www.photokrokidis.gr
-- HikaShop version -- : 2.3.5
-- Joomla version -- : 2.5.24

Hello.

I have recently created an e-shop for a photographer. They want to display their photos and anyone can buy them. The thing is that in any product, if you click the previous/next button it gets you 16 products next/previous. The products have sequential ids. I wander how this happens. Any ideas and ways to make it go sequentially?

Thanks in advance.

Hi,

Are the products in many categories ?
If it is, it can be the source of the issue, if they don't have the same first category.

The buttons get the products just before or after the current product based on it's main category.
So if the products have many categories, and not always the same one, so it seems to display random products.

Hello!

The products are in the same category. I have seen already a thread that had the problem of the products belonging to many categories and that's not my problem too... I have put some products in one category (products "eikona 1" up to "eikona 3065") and some others in an other category (products "eikona 3066" up to "eikona 5055").
The thing is, that it shows products from the same category but it shows them with a "gap" of 15 products (product 1 -> product 17 -> product 33 -> product 49 e.t.c.).

Thanks.

Hi,

And in the backend, in the product listing view, are the products correctly ordered ? (order column)

Yes they are. They also have sequential ids. Product "EIKONA 1" has id 1141, product "EIKONA 2" has id 1142 e.t.c. Is there a problem that the id starts from number 1141 and not from 1?

I unsterstood your question now. The products aren't ordered in the order column... I'll try to order them and see what happens. Is there any way of doing that with one action?

OK I'll do it througth the import option. But what is the column name of the order column (ordering of products)? I'll do it through product_code+ the column name of the product_order

Thanks!

There are 3065 products in the 1st category and about 2000 products in the 2nd category. It'll take days to do that. Is there any other way to show the products ordered by id or to import - update the products using an extra field - column for the ordering?

Thanks.

Hi,

At this time, I don't see easy solution but do some MySQL queries with PHP value managment..
We will think to add this kind of feature in our mass action system.

Since I have php/mysql knowledge I could do some coding. But I don't know where should I put the code and what tables / attributes should I look for. Could you please help me on that in a manual way of presenting the products?

Thanks!

OK thanks a lot!

I did it through MySQL update statement in phpmyadmin part of the server.
It's the "ordering" column that needed to be updated.

When I tried to access and update ordering column through csv file (tried to import csv files in order to update existing products) it couldn't do it. I couldn't recognize this column as one of the permitted ones...

I would very much appreciate if you could "fix" this and let us set the ordering number of the products through csv file!!! It would make our lives easier (I think).

Thanks a lot!