Developer forum

Forum » Templates » Preserve description and image

Preserve description and image

E-mail notifications
Per Ljung
Reply
Posted on 29/06/2011 08:36:31
Hi!

I'm importing product groups using the Import/Export module, but the fields Description and LargeImage are always overwritten. Is there a way to preserve these fields from being overwritten? I know you can select these options when it comes to products, but I can't find way to do it for product groups too.

Any ideas?

Best regards,
P

Replies

 
Vladimir
Posted on 30/06/2011 05:35:44
Reply
Hi Per!

In the Import/Export module  is not implemented preservation of these fields.
But it is possible to realize by help of a trigger:
CREATE TRIGGER [dbo]. [PreserveDescriptions]
    ON [dbo]. [EcomGroups]
    AFTER UPDATE
AS
BEGIN
SET NOCOUNT ON;

update [EcomGroups]
set [GroupDescription] = d. [GroupDescription]
from deleted d
where [EcomGroups]. GroupID = d.GroupID AND [EcomGroups]. GroupLanguageID = d.GroupLanguageID

END

Only dont forget to disable trigger after import...

Best regards,
Vladimir


 

You must be logged in to post in the forum