Author Topic: VM [3.2.14] I can't delete orders  (Read 235 times)

hazael

  • Beginner
  • *
  • Posts: 14
    • Biżuteria etniczna i orientalna
  • VirtueMart Version: 3.2.14
VM [3.2.14] I can't delete orders
« on: April 16, 2018, 16:51:52 pm »
in
Quote
administrator/index.php?option=com_virtuemart&view=orders
I have canceled orders in the list and I want to delete them.
After I try to delete, I get a error message: "An invoice has been issue, you are not allowed to delete this order QWERTY"
How to solve this problem?

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3273
  • using Matomo instead of Google Analytics
Re: VM [3.2.14] I can't delete orders
« Reply #1 on: April 16, 2018, 21:44:59 pm »
At present, after a (pdf) invoice has been generated, you can't delete the order from the VirtueMart administration anymore in VM 3.2.14+. This was recently implemented due to a new french law, but probably isn't the final solution to comply with that law yet. You should be able to delete the invoice in the xxxxx_virtuemart_invoices table with for example phpmyadmin and afterwards delete the order from the VM orders view.
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2699
  • VirtueMart Version: 3.2.14
Re: VM [3.2.14] I can't delete orders
« Reply #2 on: April 17, 2018, 15:05:06 pm »
Accidental order deletion and invoice removal has been a problem for some time.  It is not just an issue with French businesses.

If VirtueMart is producing invoices (it does not have to) then records of these invoices should be maintained.

The changes in the latest release help to prevent the removal of records that have resulted in an invoice being produced through normal administrator operations.

This will help maintain a sequential record of invoice data which is a legal requirement in many countries.
regards
A

Joomla 3.8.7
php 5.6 + php 7

hazael

  • Beginner
  • *
  • Posts: 14
    • Biżuteria etniczna i orientalna
  • VirtueMart Version: 3.2.14
Re: VM [3.2.14] I can't delete orders
« Reply #3 on: April 17, 2018, 18:47:58 pm »
This is understandable but this solution is troublesome. it would be useful to have a temporary option for administrator for testing - similar to the sandbox option in paypal. :-)
I removed tested orders from the database using the older version of Virtuemart [3.2.12]

lausianne

  • Beginner
  • *
  • Posts: 34
Re: VM [3.2.14] I can't delete orders
« Reply #4 on: Yesterday at 09:35:56 »
I see the legal requirement, and I had this trouble with other shop software as well. The "solution" is really useless, though - if anyone actually wants to mess with the data, he can easily do that in the database. No fraud protection here. You'd need a blockchain for that, or similar. Maybe every transaction transferred directly to a state controlled safe location. Not that I propose this, just thoughts.

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2699
  • VirtueMart Version: 3.2.14
Re: VM [3.2.14] I can't delete orders
« Reply #5 on: Yesterday at 13:59:23 »
Quote
The "solution" is really useless, though - if anyone actually wants to mess with the data, he can easily do that in the database. No fraud protection here.

This is designed for the average user who does not want to commit fraud - if you want to - you will find a way.

You could just delete the whole database and yes be done with it, in the same way that you could destroy paper invoices or delete all your other accounting records by formatting your hard disk.





regards
A

Joomla 3.8.7
php 5.6 + php 7

lausianne

  • Beginner
  • *
  • Posts: 34
Re: VM [3.2.14] I can't delete orders
« Reply #6 on: Yesterday at 17:43:16 »
So it's just to protect users from accidental deletion, right? Then why not just have an extra warning, "Are you sure you want to delete this???"

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 26745
  • Always on vacation
    • Jenkin Hill Internet
Re: VM [3.2.14] I can't delete orders
« Reply #7 on: Today at 10:47:46 »
It is also to prevent malicious deletion by a member of staff with admin access.
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 VM3.2.14.9808 on Joomla 3.8.6 PHP 7.0.29

Testing VM3.2.14.9808 on J3.8.6

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2699
  • VirtueMart Version: 3.2.14
Re: VM [3.2.14] I can't delete orders
« Reply #8 on: Today at 10:50:45 »
Quote
So it's just to protect users from accidental deletion, right?

No - that is not what I said.

The average user will not know how to manipulate a database

Quote
Then why not just have an extra warning, "Are you sure you want to delete this???

Because that will still allow deletion and that is not what the developers wanted to achieve.
regards
A

Joomla 3.8.7
php 5.6 + php 7