Flexible Search in Impex Import

 

Flexible Search in Impex Import


If you want you can use here mentioned scripts and please make sure to include the generated sql and that will work for you.

 UPDATE GenericItem[processor=de.hybris.platform.commerceservices.impex.impl.ConfigPropertyImportProcessor];pk[unique=true]
 INSERT_UPDATE Stocklevel;pk[unique=true];inStockStatus(code)[default='notSpecified'];
 #% impex.initDatabase("$config-db.url", "$config-db.username","$config-db.password","$config-db.driver");
 "#%
 impex.includeSQLData( 
 ""Put your generated sql here which you can get it from sql tab after running your flexible search.""
 );
 "

#% impex.enableCodeExecution( true );
#% impex.setRelaxedMode( true );
UPDATE VariantProduct;code[unique=true];quickOrderOnly[default=0];$approved;$catalogVersion
#% impex.includeSQLData(""select {product.PK} FROM {VariantProduct AS product JOIN Product2SalesOrg AS pso ON {pso.source}={product.PK} JOIN SalesOrg AS so ON {so.PK}={pso.target} and {product.activeFlag}=1  and lower({product.catalogVersion})=lower('8796355297881') }"");

Comments

Popular Posts