Normally a product CSV is used to update existing product data, add data, or add new products. This article shows the process.
You may need to clear a specific field, like the image URL, or the barcode for all items in GroovePacker or for a selection of items.
This can be done in bulk for many items very quickly using the product importer delete function.
Removing product data (keeping the products)
Please create a backup of your product data from Settings > Backup and Export > Backup and Restore before continuing so you can easily restore your current product data if needed.
Next, you can export the products you wish to modify to a CSV. Do this from the Products section. You can go to the Active products list or the Show All list and use the Select All button if you'll be modifying all products. If you'll be modifying all products of a specific category you may instead search for the category name and then use the Select all button to select the results. With your selection highlighted choose the "Export products to CSV" option from the edit drop-down. Save and open this file on your local workstation. You can open it with Excel, Google Sheets or OpenOffice. To ensure that leading zeros will not be dropped it's a good idea to select the Text data type when opening the file. This will also prevent barcodes from being converted to scientific notation.
To delete data, simply choose the fields you wish to delete and replace their current value with [DELETE]
(The brackets before and after need to be included.)
Once you enter [DELETE] into a cell in your spreadsheet editor, you can copy it, then create a selection of cells or select an entire column (exclude the column header from the selection) and paste it into all of the cells at once.
You can now map this column to the proper field and import the file.
Be sure to choose the Create and Update product records option when mapping the file.
Any previous data that is now replaced by [DELETE] will be removed from GroovePacker when the file imports.
How to bulk delete a list of products
If you have a list of discontinued items in an Excel sheet or CSV file and you would like to remove them, you can do this as well.
Before you get started it's advisable to take a backup of your products described here.
Before you continue be sure that every SKU in the file is one that you would like to remove. The delete operation can not be undone.
The first step is to save your Excel file as a CSV so it can be imported. Next, open the file in the CSV product importer found in Settings > Store > Click on the CSV store name in the list of store connections to open it. The Product importer is the second importer in the list.
You'll only need to map the SKU column for this operation. In the mapping section at the bottom locate the SKU column and select "Remove this SKU" from the bottom of the list. Next, click the import button and the SKUs should be removed.