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
and it wasn't tracked in SS3
- UPDATE File_Versions fv
- RIGHT JOIN SilverShop_Product_Versions pr ON (fv.RecordID = pr.ImageID AND pr.ImageID > 0)
- SET LastEdited = Created;
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?
Might be old or outdated, can’t see it used anymore
OrderStatusLog is a better place for it as it tracks it over time.
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 😕