Is there an option to limit import to only one directory in shop

Is there an option to limit import to only one directory in shop

Avatar image
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.
Reply
1 Answer
Avatar image
Feb 06, 2019
Andrii Yanosh 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.