anybody know’s a way to do a mass removal of items...
# suitecommerce
f
anybody know’s a way to do a mass removal of items assigned to a commerce category??
m
CSV?
j
@Francisca Galperin Yes. 1. Create a saved search of the commerce categories that include a column for the Internal ID of the category, either Item Name or Item ID and also the Item Sequence number 2. Export the results as a CSV and open in Excel 3. Sort by Item Sequence Number (if it isn’t already) 4. Remove the items you need to from the relevant categories. 5. Refill the Item Sequence numbers so that they count sequentially from 1 to whatever for each category 6. Import the CSV, using Import Type > Website and Record Type > Commerce Category, using Update as your Data Handling Method. 7. IMPORTANT: Under Advanced Options, make sure that you select “Overwrite Sublists”. This will make sure that all the commerce categories item data is replaced by your new list (and not just appended if it finds new items) 8. On the field mapping map Internal ID to the commerce category Internal ID. 9. Expand the “Commerce Category Items” section on the bottom of the NetSuite fields section on the right and map “Items” to either the Item ID or Item Name (if you use Item ID, make sure that you click the little pencil icon in the center column and choose “Internal ID” as your reference type). Map Item Sequence Number to Item Sequence Number. 10. Run the import That should remove any items that aren’t in the CSV because you’re overwriting the commerce category’s Items Sublist
f
thanks!