hi,
We need to have a manual sort on product listing in categories.
So that the admin is able to sort products as they need it for each category assignation.
It seems we would need a nodequeue in the category taxonomy and modify the collection_products view to sort by it.
But I can't get it done.
Any clue?
thannks!
Example:
In "winter clothing" collection, we need a certain pant to be near the top
while in "summer clothing" we might want them a fit further in the list....
Depending on how many products you have and how you want things to work, you could use
https://drupal.org/project/draggableviews to manually order
You mean that with Draggable_Views, within the taxonomy term (category), I would be able to SORT the products that belong to this category?
The product listing page would react on this?
Looks like nodeorder is exactly what you're looking for
https://drupal.org/project/nodeorder
as it allows to "order nodes within their taxonomy terms". Plus, "there is Views support for ordering taxonomy views by weight_in_tid".
Yes.. We already tried this as described in the definition in nodeorder module. But it seems that the DrupalCommerce view does not offer the weight_in_tid in the sort options. Maybe a relationship is wrong, or the view is already altered by DrupalCommerce view... Something was wrong.
We ended up sorting the view by altering it programatically like this:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
function hook_views_post_execute(&$view) {
if ('collection_products' == $view->name) {
$orders = array();
foreach($view->result as $row) {
$nid = $row->entity;
$tid = $view->args[0];
$weight = db_query("SELECT weight FROM {taxonomy_index} WHERE nid = :nid AND tid = :tid", array(':nid' => $nid, ':tid' => $tid))->fetchField();
$orders[] = $weight;
}
array_multisort($orders, SORT_ASC, $view->result);
}
}
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The hard way. ;)
As sorting products manually in each category (term) is really hot in shops to maximise convertion, there must be a general solution for this in Drupal Commerce? Does anyone have solution to this? I can't imagine not a single Drupal web shop is using this feature.
I'll be continuing my search :-)
Greets
I figured it out. But it's not very well documented in my opinion and that... I find very strange. Even stranger is the low amount of question people are asking about this. It's like nobody cares to manually order the products per category from a marketing point of view.
Or there is super easy solution out there that everybody is using and I just...missed.
The most usable solution is the module which is most used for manual sorting: DraggableViews.
The secret lies in the fact that you have to use native draggableviews sorting and activate the arguments handling of the draggableviews sort criteria. Don't use the Field API. One display of the view will be used as front-end page and one display will be used as sorting page (back-end).
More information about the setup can be found here: https://drupal.org/node/283498
A issue I ran into and solved: https://drupal.org/node/1813746#comment-8506599
I figured it out. But it's not very well documented in my opinion and that... I find very strange. Even stranger is the low amount of question people are asking about this. It's like nobody cares to manually order the products per category from a marketing point of view.
Or there is super easy solution out there that everybody is using and I just...missed.
The most usable solution is the module which is most used for manual sorting: DraggableViews.
The secret lies in the fact that you have to use native draggableviews sorting and activate the arguments handling of the draggableviews sort criteria. Don't use the Field API. One display of the view will be used as front-end page and one display will be used as sorting page (back-end).
More information about the setup can be found here: https://drupal.org/node/283498
A issue I ran into and solved: https://drupal.org/node/1813746#comment-8506599
Manual sorting of nodes on a per taxonomy basis.
I figured it out. But it's not very well documented in my opinion and that... I find very strange. Even stranger is the low amount of question people are asking about this. It's like nobody cares to manually order the products per category from a marketing point of view.
Or there is super easy solution out there that everybody is using and I just...missed.
The most usable solution is the module which is most used for manual sorting: DraggableViews.
The secret lies in the fact that you have to use native draggableviews sorting and activate the arguments handling of the draggableviews sort criteria. Don't use the Field API. One display of the view will be used as front-end page and one display will be used as sorting page (back-end).
More information about the setup can be found here: https://drupal.org/node/283498
A issue I ran into and solved: https://drupal.org/node/1813746#comment-8506599
I figured it out. But it's not very well documented in my opinion and that... I find very strange. Even stranger is the low amount of question people are asking about this. It's like nobody cares to manually order the products per category from a marketing point of view.
Or there is super easy solution out there that everybody is using and I just...missed.
The most usable solution is the module which is most used for manual sorting: DraggableViews.
The secret lies in the fact that you have to use native draggableviews sorting and activate the arguments handling of the draggableviews sort criteria. Don't use the Field API. One display of the view will be used as front-end page and one display will be used as sorting page (back-end).
More information about the setup can be found here: https://drupal.org/node/283498
A issue I ran into and solved: https://drupal.org/node/1813746#comment-8506599
Same problem! Not found solution for sort products manualy, when using view with facet search.
Does anyone have solution to this?
Don't use node order in 2017, it has some weird bugs. Use Draggable Views instead.
Comments
Hi Mastap,
I am attempting to do this myself, please could you let me know how I implement this suggestion of yours.
Many thanks in advance
Alex