Can I remove Products through a CSV Import?
There may come a time when you need to delete your products en masse. The most common method to do this is by selecting all of the products that you'd like to remove from your Online Store Manager's Products List page (Products >Product List) and selecting "Delete" from the Batch Action menu located at the bottom.
Another method is to remove the products via a CSV export. This second method can be useful if you have hundreds (if not thousands!) of products that need to be removed and going through the Shift4Shop Online Store Manager is not a feasible method for your needs.
This article will illustrate how to delete products via the CSV.
Please exercise CAUTION when attempting the following instructions as your products will not be recoverable after deletion except via a complete site restore.
Shift4Shop assumes no responsibility for misuse of the information contained in this article.
Exporting your Products
The first step is to export a CSV of your existing products from your store. The basic process of removing Products via CSV import involves adding a simple minus sign (-) to the catalogid of the products you'd like to remove. Normally, a product's catalogid will be listed as a whole number such as 1234 but to remove the product from your store's database upon import, you will need to list the catalogid as -1234 for the import.
What we will be doing in this case is creating a custom export set that lists your product catalogid data with the hyphen already populated on it. After generating the CSV export, you will simply need to remove the products you'd like to keep from the CSV file (thereby only having the products set for removal in the CSV) and importing the resultant file to your store.
Custom Export Set
Log into your Shift4Shop Online Store Manager and use the left hand navigation menu to:
You should see an area (under the Manufacturer and Distributor fields) called "Custom Export Sets." At the bottom of this area, you'll see a link marked "Manage."
These next steps will allow you to create a customized export set containing only the columns we need for the product removal.
The above steps will generate a CSV file with only 3 columns on it:
As mentioned before, to remove items from the store using CSV, the file needs to have the catalog ID listed with a minus (-) sign. So in the next step, we'll have the store generate the file with the minus sign already in place!
This time, place a dit in the button to select the custom export you just created. Then click on "Export Data" to generate your CSV file.
You should now have a CSV export file containing your product data with 3 columns: catalogid, id, and name. Furthermore, the catalogid listing on the products will contain a minus sign to the front of them.
This file - if imported as is - will remove all of your items. Therefore, you will need to edit the file to remove those products which you intend to keep!
Editing your Exported CSV file
The next step will be to edit your CSV file so that it contains ONLY those products which you wish to remove from the store.
So while editing the CSV file, only take out the rows of products from the CSV for products that you intend to keep on your Shift4Shop store.
After making your needed changes you should now have a CSV list of products which you'll be removing from your store. Save this file after editing, and you're all set. You may now import this special CSV file to your store and it will remove the listed products upon import. Just be sure that - when you import the file - it is imported as an Update (rather than insert).
During the process, you will be taken to the Import/Export Status page which will display a grid layout of your recent imports and exports. The progress column will show you the progress of the import.
At the far right of each grid item will be an action wheel that contains the following options:
This will be present in all of the store's Export/Import functions.