View more context



well, just trying to figure that out per SQL... is tricky, when one image is used by more products...


I tend to keep it simple and just set files "last edited" to created...


then it's older than the latest product version before the update

  1. UPDATE File_Versions fv
  2. RIGHT JOIN SilverShop_Product_Versions pr ON (fv.RecordID = pr.ImageID AND pr.ImageID > 0)
  4. SET LastEdited = Created;

Hi guys,

Looking into the default fields of Order class in ss4. And i cant seem to find anywhere in the code where $Order->Dispatched is updated?

Anyone know where in the code this is updated?

Show 1 attachment(s)

        'Dispatched' => 'Datetime', //products have been sent to customer
Hide attachment content

Might be old or outdated, can’t see it used anymore


OrderStatusLog is a better place for it as it tracks it over time.

👍 (1)

Hi guys, I am having a problem with the SilverShop importer if a SKU code has a a space or a "-" or a "/". It imports the product and doesnt import the variants. Does anyone know how I can fix this? we have a client with hundreds of products that need these characters because of google shopping.


Cant seem to think of a fix for this. The field type for a internalItemID is varchar(30) and you can manually put the codes I am trying so this means its the importer 😕