Author Topic: product sorting in category view  (Read 780 times)

caesarsk

  • Jr. Member
  • **
  • Posts: 50
product sorting in category view
« on: August 28, 2018, 08:07:03 am »
Hi all,

first J3.8.11 + VM3.2.14

I have a problem with product sorting in category view. I do not know why, but I can not see the ordering field in the administration (like admin->category). but this is my smallest problem.
I import the products directly into the database. I use the "pordering" column to sort product priority (in column #__virtuemart_products). But if I set the products sorting by List Order in the VM settings, this simply does not work.

is this only my problem? Doing something wrong? Have you some advice how to achieve product ordering by "pordering" column.

thx

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9909
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: product sorting in category view
« Reply #1 on: August 28, 2018, 11:37:55 am »
Product ordering is per category so select a category and there u see the ordering
the 3rd marked item is a poorly icon'ed Save
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 4387
  • Joomla & Virtuemart developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3
Re: product sorting in category view
« Reply #2 on: August 28, 2018, 12:35:11 pm »
pordering is used for product child listing not in category.
the ordering for products in category is in a specific table named #__virtuemart_product_categories

caesarsk

  • Jr. Member
  • **
  • Posts: 50
Re: product sorting in category view
« Reply #3 on: August 28, 2018, 12:49:01 pm »
Product ordering is per category so select a category and there u see the ordering
the 3rd marked item is a poorly icon'ed Save

ou, thx. Sorting appears only on filtered products?


pordering is used for product child listing not in category.
the ordering for products in category is in a specific table named #__virtuemart_product_categories

many thx. this is what i need :)

Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 4387
  • Joomla & Virtuemart developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3
Re: product sorting in category view
« Reply #4 on: August 28, 2018, 16:37:54 pm »
In last release of Vm Be Pro, i added a tree view, so you can set each ordering directly for each product in categories.
This can be done automatically or you can enter the order number per product.
I added it by customers request, because Virtuemart cannot handel all cases.
See https://shop.st42.fr/en/products/vm-be-pro-batch-product-edit.htm