Author Topic: New collumn in DB for virtuemart order  (Read 510 times)

pinochico

  • 3rd party VirtueMart Developer
  • Jr. Member
  • *
  • Posts: 385
    • MiniJoomla
  • VirtueMart Version: 3
New collumn in DB for virtuemart order
« on: May 04, 2019, 15:04:56 pm »
Hi,

after upgrade virtuemart from 3.2.14 to 3.4.3 on DB table virtuemart order I see 3 new collumn:

STsameAsBT
paid
paid_on

Now our payment plugin (Gopay for Virtuemart) correctly change order status, but in collumn paid is still value "0".
Then order in admin view order list is check as unpaid and virtuemart not send email about order to client.

What's the new feature and where can I find the documentation to upgrade our payment modules?

And why don't we get developers noticing these major changes?

As a result, the production eshops of customers do not work, it is very unpleasant and they want compensation from us.
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds from products, orders and database table
Virtuemart Email Manager - customs email templates

n3t

  • Beginner
  • *
  • Posts: 32
  • A beginner
Re: New collumn in DB for virtuemart order
« Reply #1 on: February 18, 2020, 02:45:13 am »
Just discovered this, and google found me this only topic, so for someone looking for answer:

Seems payment plugin cannot influence this field. It is caculated automatically based on hidden (VM 3.6) settings called 'os_trigger_paid', which defaults to array('C').
So, if the payment plugin set status of order to 'C' after succesuful payment, all should work out of box. Otherwise you need to add os_trigger_paid to your virtuemart.cfg file manually.

If I am wrong, please correct me someone...