RE: Clean up shop database

On Wed, 19 Jan 2022 05:51:56 -0800, Mike Sofen wrote:
>> From: Richard Klingler <richard@klingler.net>  Sent: Wednesday, January
> 19, 2022 5:37 AM
>> On Wed, 19 Jan 2022 06:32:19 -0700, Rob Sargent wrote:
>>> 
>>>> No it does not...but I assume it lists products that where at least 
>>>> ordered before January 1st 2021 as it contains lower product IDs.
>>>> 
>>>> Hmm..gives me:
>>>> 
>>>>> ERROR:  function max(boolean) does not exist
>>>> LINE 5: having max(o.orderdate < '2021-01-01')
>>>> 
>>>> 
>>> Sorry
>>>> 
>>>> max(o.orderdate )< '2021-01-01'
>>> 
>>>> 
> 
>> You're a genius :-)
> 
>> Looks perfect...
> 
> There is one caveat here: unless you are 100% certain that the
> product.pieces count is 100% accurate, you should sum the
> orderitems.productid.  It is pretty common for the indirect counts (like
> product.pieces) to get out of sync with the "normal" source of truth (line
> items).  
> 
> This does depend on design of your system, of course.
> 
> Mike
> 

Well I use the productid for rough checking so that they are created
some time before the specified date.

And I won't delete any records..just mark them as inactive...
that way datatables loads much faster when it just grabs the
active products via ajax call.