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
Post a Comment