Deleting SKUs via CSV File (Ingest Data)

In this article, we will walk through the steps on how to delete SKUs using ingest data.  

Things to know: 

• The ability to delete SKUs via ingest data is governed by the 'Accessing Ingest Data' access control setting.
  
• The ability to delete SKUs via CSV files is controlled by a hidden setting that only the MyTime team can enable. To enable the hidden setting, please contact our support team at support@mytime.com.
  
• The barcode associated with a deleted SKU will also be removed. You can then use the same barcode for other SKUs

To delete an SKU:

1. Navigate to POS > Inventory 
2. Select the Export link at the bottom right corner of the page
3. The inventory data will be downloaded in a zip file. In that file, locate and open the inventory_skus sheet.
4. On this sheet, you will see the following:  

   Column	Description
   sku_id	The unique ID assigned to the specific SKU
   product_id	The unique ID assigned to the product
   name	The name assigned to the SKU
   number	The manufacturer SKU number listed on the 'Edit Product' modal
   barcode	The barcode assigned to the SKU
   deleted	This gives you the option to delete products by changing the '0's to '1's
   mytime_sku_id	The unique internal MyTime ID assigned to the SKU
   mytime_product_id	The unique internal MyTime ID assigned to the product

5. To delete product SKUs, change the "0" to "1" in the deleted column for the corresponding SKU 
6. Once you have made your changes, download the sheet as a CSV
7. On the Inventory page, click Import
8. On the Import Inventory page, read the instructions and then click "Upload File Here"
9. Select the CSV file from the file manager and then click the Import button
10. You will then be directed to the Ingest Data batch page, with the file located at the top
11. Refresh the page until it is completed. When completed, the file will be assigned an end time and the status will be changed to Finished

Congratulations on successfully deleting your product SKU with Ingest Data. You can navigate to POS > Inventory to view the changes. 

For more information, contact us at support@mytime.com.