Save product short description in order (without updating in order details if it is updated in product)

I understand that it is possible to display the short description of the product on the order details page, even in an email. But I need this not to update when I update the short product description.

Real situation: My products are updated every day, these products detail the number of parts that will actually be sent at the time of purchase, according to availability.

Title: Surprise box

Short description: Contains a palette, a lemon and a stone. (this changes every day)

I need to pass this short description in the mail, order details for the client and for the admin, so I can follow up later.

The problem is that I only find codes to show the short description of the updated product, no matter the time of purchase, the last one edited will always be shown.

any idea where to start?

Free(1 month access) GSA SER SiteLists / Updated Hourly / Dropbox Auto-Sync

Hi Guys,
As We are Testing our new scraping system, We want to give Dropbox free access to GSA SER forum`s members.
So if you are interested in checking our site lists which are grouped by Platforms(Using GSA SER Platform Identifier) for free(No joking!) just PM me and send me your Dropbox Email.
I will add your Email in Dropbox in less than 12 hours.

Postgres Query conversion (Count, updated date)

I currently run the below query in Snowflake for some of my reconciliations- have never worked in PostgreSQL but we just adopted it.


I’m looking to do the same thing in PosgreSQL. It’s one that we can run against a table that will give us the last updated date and a count when checking that movements completed.

I know postgres can be time heavy on counts and some of these tables are massive. That aside I’m not sure how to rewrite this either. Any pointers/tips would be amazing



Was the Monster Lore Compendium ever updated after April 6th, 2008?

Was the Monster Lore Compendium ever updated after April 6th, 2008? If so, where can it be found?

I have read that it was going to be added to the d20pfsrd (yes, d20pfsrd, even though this is a 3.5e resource), though I don’t think that ever happened.

I know it was put into a spreadsheet here but I don’t believe that any updates were added.

Does the now updated Integrated Protection feature of the Warforged mean they are counted as “wearing” armor?

The new and updated Warforged’s Integrated Protection feature, detailed in Ebberon Rising from the Last War, now states:

Integrated Protection

Your body has built-in defensive layers, which can be enhanced with armor.


  • You can don only armor with which you have proficiency. To don armor […]. To doff armor […]. You can rest while donning or doffing armor in this way.
  • While you live, your armor can’t be removed from your body against your will.

With this revised wording, does the warforged now count as wearing armor?

This is important in the context of how something like integrating a set of Plate Mail would interact with Monk features like Martial Arts.

Is Deluge safe to use still when it’s not been updated since the first part of 2017?;O=D

The latest version of Deluge for Windows that can actually be downloaded and installed is deluge-1.3.15-win32-py2.7.exe from 2017-05-12.

That’s well over three years ago now!

They have been discussing the problems of releasing the new version for years, but nothing comes from it. Like so many slowly dying (but never quite gone) projects I’ve painfully witnessed in the last many years.

Doesn’t this more than likely make it extremely unsafe for me to be running this software on my machine? I feel as if it’s an open door to my machine, almost certainly containing unpatched exploits.

Yet the sad reality is that there are no alternatives. uTorrent is an ad-infested spyware nightmare since many years, and others… well, just like with browsers, I’ve given up on searching because there’s just nothing out there. Nobody seems to care one bit about the entirely desktop computer anymore.

Can I still use this ancient software? If so, how much longer?

Trigger function accessing newly updated data from another table

I have two tables A and B. In one transaction I update both tables. In the trigger function after update I want to select data from both tables, but the result is the old data. The trigger is on table A, but they both are being updated in the same transaction. Is this possible to achieve or I have to think for another approach?