Author Topic: Virtuemart_order_id vs order_number not following each other  (Read 382 times)

welrachid

  • Jr. Member
  • **
  • Posts: 225
  • 3rd party plugin developer
  • Skype Name: wel.rachid
  • VirtueMart Version: Always LATEST stable
Hi guys
I've tried to search forum for answer but cannot find the previous discussions we had about virtuemart_order_id / order_number increment.

After we updated to VM3.2.14 J!3.8.8 VP OPC 6.0 (within last 24 hour) we have experienced that our order_number column and virtuemart_order_id column no longer match.

i remember reading a thread where there was a discussion about increasing order numbers and then lowering them again or something like that? I cannot recall what the issue was exactly

MY issue however is that somehow the order_number column is ahead of the virtuemart_order_id column. See attached photo. These are all orders from today (So its not happening to all orders!)
Im not sure if this is related to my other issue: http://forum.virtuemart.net/index.php?topic=140243.0
But i would really like to have those to numbers to match because having them this close is very confusing.

28102 was first order AFTER update..

We've had those numbers follow eachother for the last year or so without any problems..

Thanks
Best regards,
Wel

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2768
  • VirtueMart Version: 3.2.15
Re: Virtuemart_order_id vs order_number not following each other
« Reply #1 on: May 24, 2018, 12:52:06 pm »
Please talk to the OPC developers

This is not a VM issue
regards
A

Joomla 3.8.8
php 7.0

welrachid

  • Jr. Member
  • **
  • Posts: 225
  • 3rd party plugin developer
  • Skype Name: wel.rachid
  • VirtueMart Version: Always LATEST stable
Best regards,
Wel

welrachid

  • Jr. Member
  • **
  • Posts: 225
  • 3rd party plugin developer
  • Skype Name: wel.rachid
  • VirtueMart Version: Always LATEST stable
Re: Virtuemart_order_id vs order_number not following each other
« Reply #3 on: May 24, 2018, 18:11:09 pm »
So basically VP OPC reply it has nothing to do with their plugin:

-----------
This has nothing to do with VP One Page Checkout plugin. Such things are purely managed by core VirtueMart component. The plugin can never affect your order number.

For verification, you can always disable the plugin and check using standard VirtueMart checkout system. You will not find any difference.

It seems like a database issue of your site which was probably generated due to a recent VirtueMart component update.
----------

Any ideas?
Best regards,
Wel

welrachid

  • Jr. Member
  • **
  • Posts: 225
  • 3rd party plugin developer
  • Skype Name: wel.rachid
  • VirtueMart Version: Always LATEST stable
Re: Virtuemart_order_id vs order_number not following each other
« Reply #4 on: May 25, 2018, 09:32:48 am »
I've been using Advanced Ordernumbers for VirtueMart to control the order_numbers
So to solve this right now i have increased the auto_increment ID of the virtuemart_orders table and also changed the order_number counter in the plugin to match.

Hopefully this was a glitch in the update and will not be a problem in the future
Best regards,
Wel

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9607
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Virtuemart_order_id vs order_number not following each other
« Reply #5 on: May 29, 2018, 14:46:54 pm »
No, welrachid, it is a security feature, which you just disabled. There is an extra possibility to provide an offset.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

welrachid

  • Jr. Member
  • **
  • Posts: 225
  • 3rd party plugin developer
  • Skype Name: wel.rachid
  • VirtueMart Version: Always LATEST stable
Re: Virtuemart_order_id vs order_number not following each other
« Reply #6 on: May 29, 2018, 16:34:27 pm »
Hi milbo
Thanks for taking time to answer. Im not sure how this increases security.
What i want is that all displayed order number/ids/whatever are the same everywhere, so that when people ask for something they have a reference number and so that for (tax-services) we always have a increased-by-1 number on all orders.
Best regards,
Wel

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9607
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Virtuemart_order_id vs order_number not following each other
« Reply #7 on: May 29, 2018, 19:43:20 pm »
The virtuemart order id is always an integer. The order id is a pure database thing. The order NUMBER is for the customers and shopowners. Not the id. And there is an extra offset to avoid, that someone can use the ordernumber to get the id.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

welrachid

  • Jr. Member
  • **
  • Posts: 225
  • 3rd party plugin developer
  • Skype Name: wel.rachid
  • VirtueMart Version: Always LATEST stable
Re: Virtuemart_order_id vs order_number not following each other
« Reply #8 on: July 02, 2018, 23:18:20 pm »
I've gone away from using id to purely order number.
had to rewrite all my functions so that rely on the order number instead.but works again now.
Best regards,
Wel