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.


Process


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 or OpenOffice. You can ensure that leading zeros will not be dropped of you select the Text data type from the choices given when opening the file.


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 spread sheet 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.