Can't Change The Position Of Products Within Categories

I've been using CS Cart for 8 years and been on early versions and now trying to get to grips with v4 (I've got 4.2.4 installed). It seems I cannot change the position of the products - it lets you enter a value and when you save it says changes have been saved, but the position is still 0.



Tried different browsers and different clients but the same. Anyone else have this problem?



Thanks.

It is the same on the live demo too so it's not a setup/installation issue.

Please post the issue to the bug tracker

Before you post, I suggest you use the forums Search feature to find the answer:



http://forum.cs-cart.com/tracker/issue-5404-bug-with-saving-position-of-product-in-category/

It is a bug in CS-Cart.



Here's the fix that I get from Support:



[color=#555555]To resolve the issue, please replace this part of code:[/color]





[color=#555555]
if (in_array('categories_filter', $params['extend'])) {
$category_filter_avail_cond = str_replace('?:categories', 'categories_filter', $category_avail_cond);
$join .= " INNER JOIN ?:products_categories as products_categories_filter ON products_categories_filter.product_id = products.product_id INNER JOIN ?:categories AS categories_filter ON categories_filter.category_id = products_categories_filter.category_id $category_filter_avail_cond ";
$condition .= fn_get_localizations_condition('categories_filter.localization', true);
}
[/color]



[color=#555555]with this one:[/color]



[color=#555555]
if (in_array('categories_filter', $params['extend'])) {
$category_filter_avail_cond = str_replace('?:categories', 'categories_filter', $category_avail_cond);
$join .= " INNER JOIN ?:products_categories as products_categories_filter ON products_categories_filter.product_id = products.product_id INNER JOIN ?:categories AS categories_filter ON categories_filter.category_id = products_categories_filter.category_id $category_filter_avail_cond ";
$fields['categories_position'] = $sortings['position'] = 'products_categories_filter.position';
$condition .= fn_get_localizations_condition('categories_filter.localization', true);
}
[/color]



[color=#555555]in the [/color]app/functions/fn.catalog.php[color=#555555] file of your CS-Cart installation.[/color]

info, thanks! I made the change and if I'm logged in as admin, the sorting is correct (by position Low to High). If I view the site (not logged in at all), the sorting is not in any particular order (likely as it was entered into the db).



Is there anything else to check/change?

[quote name='wmaven' timestamp='1439583688' post='226817']

Is there anything else to check/change?

[/quote]

Have you tried clearing cache for CS Cart? Administration → Storage → Clear cache.

@Reds, yes! The first thing I tried. Cleared browser caches as well. Admin Preview of the listed product is correct. User view of the listed products is not.

Most likely the frontend is using the sorting that is set up in Settings->Appearance.

sorting.jpg