Author Topic: HELP! Reordering products using administrator isn't working Virtuemart 3.2.14  (Read 467 times)

bcohen0

  • Beginner
  • *
  • Posts: 39
This problem was in 3.2.12 for me, also, so it isn't a problem which appeared with the latest version.

Please help.
Reordering of products via the administrator isn't working for me. I can get the ordering numbers to save in the administrator when I change them, but the products in the website don't respect the change, when I view them. 

First off, can anyone tell me what table the ordering numbers are saved to? I can't seem to find it. Also, can anyone tell me if there are conflicting settings that might prevent the site from respecting the order setting?

Any clues would be appreciated.
thanks

Jörgen

  • Global Moderator
  • Full Member
  • *
  • Posts: 2284
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Have You tried klicking pn "Save ordering" in backend ?

Jörgen @ Kreativ Fotografi
Joomla 3.9.8
Virtuemart 3.4.x
Olympiantheme Hera (customized)

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 27478
  • Always on vacation
    • Jenkin Hill Internet
In VM Configuration/Product Order Settings set "Default product sort order " to Ordering.
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VM 3.4.3.10057 on Joomla 3.9.10 PHP 7.0.33
Testing VM 3.5.0.10097 on Joomla 3.9.10

bcohen0

  • Beginner
  • *
  • Posts: 39
Thank you! The upgrade to 3.2.14, plus the changing of the settings, seems to fix this problem. I didn't even think of those settings!

My client told me it wasn't working, when he was using 3.2.12, and the first question in my mind was also, are you sure you're clicking the save ordering in the backend? But yes he was, and it was broken on my development system too.  Which means I did something wrong when I upgraded him to 3.2.12 .

Can you tell me which table the product order numbers are saved into, in the database? I was able to find the saved order number for the product categories, and I was never having a problem with the product categories anyway.  But I couldn't find the saved order number for a product.