What settings in excel should be used when exporting a csv file?
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
Note:
Product set ID's cannot contain spaces or any unusual characters, and spaces are not trimmed, so ensure there are no extraneous spaces around separators.
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.
Adding 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 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).
Note:
If you are viewing a page containing the above slice in the merchandising tool you need to hit refresh in order to see the change as well.
Deleting a product set that is used by slices on pages?
You can't delete a product set if it's currently in use on a page. To delete it, head to the page and remove the slice that's using the specific product set you want to delete and then re-publish the page. After that, it's possible to delete the product set.
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