Which Excel settings should be used when exporting a CSV?
When exporting a file from Excel, use Comma-separated values (.csv) file format.
Verify that the separator Excel used in the exported CSV file is either comma or semicolon, and select the corresponding delimiter in the dropdown when importing the file in the merchandising tool.
How do you import multiple product sets?
You can import multiple product sets by using a single file. The file must be of the type comma separated values (.csv) and should follow the format below:
ProductKey,SetID,ADD (or REMOVE)
Example:
PRODUCT_KEY_01,SET_ID_01,ADD
PRODUCT_KEY_02,SET_ID_01,ADD
PRODUCT_KEY_03,SET_ID_02,ADD
PRODUCT_KEY_04,SET_ID_03,REMOVE
Can a product exist in multiple product sets?
A product can be included in multiple product sets. However, it will only be visible in the slice with the highest priority if multiple sets containing the same product are used on the same page.
Can you add products that are not yet available?
You can add products via import that aren't yet available in the product listing. These products will display as "Not available" in the edit product set view. However, they are excluded when editing slices and on the public storefront until they're imported from the feed.
What happens if you add or remove a product from an in-use product set?
The slice gets automatically updated and the effect on the public site will be instant (there is no need to re-publish the page).
Can you delete a product set that is used by slices on pages?
It is possible to delete a product set that's in use. Doing so will display this message shown below. Users do not need to re-publish the page if it is part of a published page.
How do I create a product set?
You can create a product set using a combination of three methods: importing data from a CSV file, handpicking specific products, and applying rule-based selection.
Article last updated