Is there an option to limit import to only one directory in shop
Home > For Customers > PrestaShop Store Manager > PrestaShop Users Forum > Automated Product Import for PrestaShop > 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

Feb 04 (2 months ago)
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
Feb 06 (2 months ago)
Iren Zakharko 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.