Feb 04, 2019
Tomi Bačun
wrote
i have a supplier which has seperate xml feeds for product info and price list.
for new products i have a hidden directory in my webshop where they are imported on a daily basis.
How can i limit when i import a price list, it should only modify prices in this one directory not in the whole shop.
for new products i have a hidden directory in my webshop where they are imported on a daily basis.
How can i limit when i import a price list, it should only modify prices in this one directory not in the whole shop.
Reply
1 Answer
Feb 06, 2019
Dmytro Grycelyak
agent
wrote
Hello Tomi,
Import Wizard allows using the SQL expression which will apply the imported product price only if it belongs to a certain category.
You may use the following SQL expression applied to Price field:
CASE
WHEN [CSV_COL(5)] 'Category name' THEN [CSV_COL(6)]
ELSE ''
END
Where 5 is a number of Category column and 6 is a number of Price column.
Import Wizard allows using the SQL expression which will apply the imported product price only if it belongs to a certain category.
You may use the following SQL expression applied to Price field:
CASE
WHEN [CSV_COL(5)] 'Category name' THEN [CSV_COL(6)]
ELSE ''
END
Where 5 is a number of Category column and 6 is a number of Price column.