Product last sale timestamp

[venditdevs]

Hi,

 

When a customer order is succesfull i want to add a timestamp into the database for that product.

 

EG:

*** Customer order contains product id's 100 and 101

*** Products with id 100 and 101 will get a last sell timestamp

 

I need it on productlevel. How can we achieve this ?

 

I think i need to hook it at hookActionUpdateQuantity...but ....how to go from there?

[venditdevs]

Nobody? Serious ?

[hpar]

Hi,

 

I think i need to hook it at hookActionUpdateQuantity...but ....how to go from there?

 

Quick & Dirty: with an UPDATE (SQL) statement ?

(and of course add the column in your install())

[El Patron]

could you not just look through orders for a particular product to find last sold date time?  This would not require a new field.

[venditdevs]

Hi El Patron,

If i loop through the orders it will be to slow and especialy if you have many orders in your system. If i can do it on product level it will be much., much faster.

I hope somebody can help me with achieving this.

 

THX

[hpar]

If you don't want to modify the product table as I suggested, why not just create a dedicated table for that with [ product_id (FK), last_updated (DateTime) ?

You can feed it after an hook (application-level) or a trigger (db-level)