I know how to remove all orders to count from the beginning now but now a new problem has appeared.

How to get rid of the numbering gap, for example if the ID 8 order will not be paid, I would like to remove it from database, but the new order has ID 9 number and not ID 8, where are the data for this vulnerability, somehow I can manually change it?

Best regards

    deemes
    Hi
    ID must be used to load and save a course, Its primary key to run the system.
    For more information, Kindly provide the page URL and screenshot that show what ID exactly you want to hide from the page?
    It helps me to understand your exact needs.

    Regards

    6 days later

    Hi pankaj,

    OK, ones againπŸ™‚ I want to be able to interfere in order numbering because if someone does not pay the order, I want to remove the order manually because I want to have only paid orders in the system. Because I use these orders / invoices to keep accounts for the tax office and I do not want to have an unpaid invoice number. When I manually remove orders from the guru_orders database -> https://www.screencast.com/t/uPXs5EYRMGF6, the order is deleted, it is OK and it disappears from the Guru panel. But when someone clicks on new, new orders, the gap is not filled but new, next order is created. For example, there is an order number 11, I have removed number 12, but another new order is created with number 13 and should be with number 12. How do you change it, where else do the order data save with guru_orders file? More simply, you can not explain πŸ™‚

    Best regards

      deemes
      Hi
      Because the order has been created and it will not be replaced by another user, the user also registered in Joomla user manager too, and the id increase its no. with every order, You may break something if you edit DB table every time.

      Regards

      Hi,
      OK, so it is impossible to change the order numbering manually? I know that it is risky but I have to do it and there is no possibility to change it automatically in Guru. So what, it is impossible to change this manually ???

      Regards

        deemes
        Hi
        You can not change it, its not no. its the unique ID and you can change it only from Database.
        I do not suggest you to do this as it required to use the same ID generated by system.
        system does this way to create new items in Joomla.

        Regards

        Write a Reply...
        You need to Login to view replies.