--- title: "Product Impact Calculator: Bulk Delete" description: "Product Impact Calculator: Bulk Delete" --- [Skip to content](https://support.worldly.io/hc/en-us/articles/40226252906907-product-impact-calculator-bulk-delete#main-content) English Show submenu for translations [Submit a request](https://support.worldly.io/kb-tickets/new?hsLang=en) [![Worldly logo](https://support.worldly.io/hs-fs/hubfs/Worldly%20Media%20Kit/Worldly%20Logos/Worldly_LogoTM_Red.png?width=250&height=61&name=Worldly_LogoTM_Red.png)](https://www.worldly.io/) Open main navigation Close main navigation - English Show submenu for translations - [Submit a request](https://support.worldly.io/kb-tickets/new) How can we help? - There are no suggestions because the search field is empty. 1. [Help Center](https://support.worldly.io/?hsLang=en) 2. [Products](https://support.worldly.io/products?hsLang=en) 3. [Product Impact Calculator](https://support.worldly.io/products?hsLang=en#product-impact-calculator) # Product Impact Calculator: Bulk Delete **Table of Contents** - [**Preparing to Bulk Delete**](https://support.worldly.io/hc/en-us/articles/40226252906907-product-impact-calculator-bulk-delete#h_01K3514HG4S631BF3SR4SE2R32) - [**How to Bulk Delete**](https://support.worldly.io/hc/en-us/articles/40226252906907-product-impact-calculator-bulk-delete#h_01K8PQDE7BHKFM6VWGH695AD38) - [**What can I bulk delete?**](https://support.worldly.io/hc/en-us/articles/40226252906907-product-impact-calculator-bulk-delete#h_01K3514PRVYWHKPY2VABMHYS16) Use the following directions to bulk delete columns from the Product Impact Calculator.  Bulk deleting information from any column means 100% erasing all values.  For example, if you have a string of tags, bulk deleting will remove all tags saved in the row. If you wish to delete just one tag, you must use the [**Product Impact Calculator: Bulk Upload - Overwrite Products Workbook**](https://support.worldly.io/hc/en-us/articles/40226246347675?hsLang=en) to do so.   ## **Preparing to Bulk Delete** Bulk deleting information in PIC requires bulk uploading a file with the columns you wish to delete.  It is highly recommended to download the Purchase Order Impacts CSV file in order to quickly scan all of your data and determine what needs to be deleted.  **NOTE:** The bulk delete functionality can only be applied to certain fields. Refer to [the table below](https://support.worldly.io/hc/en-us/articles/40226252906907-product-impact-calculator-bulk-delete#h_01K3514PRVYWHKPY2VABMHYS16) to see which fields can be bulk deleted. 1. Begin by navigating to **Products,** followed by **Purchases.** **![44312761243035.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/44312761243035.png?width=459&height=167&name=44312761243035.png)** 2. On the **Purchases** tab, select **Download All** and then **Purchase Order Impacts CSV.** **![42714868379675.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/42714868379675.png?width=811&height=134&name=42714868379675.png)** **OPTIONAL:** You can also use the check boxes to select a smaller group of records to bulk delete. **Expand to show screenshot** Select **Download** from the black navigation bar, followed by **Purchase Order Impacts CSV.**![42714901377051.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/42714901377051.png?width=810&height=610&name=42714901377051.png) This downloads a csv file of your purchases. You will use this to bulk delete any columns from your table. **Expand to show screenshot** ![42714901376667.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/42714901376667.png?width=1148&height=129&name=42714901376667.png) 3. Before continuing, it is important to understand the difference between the two fields below when preparing your excel file. You cannot use both the **Worldly Product ID** and the **Worldly PO ID** when bulk deleting. Decide which of the two fields to keep in your sheet for uploading. - **Worldly Product ID** - A unique identifier assigned to a specific product or item. It distinguishes one product from another and is used to track product details such as name, type, and specifications. - **Worldly PO ID** - A unique identifier assigned to a purchase order — the document issued by a buyer to a supplier to request products or services. It’s used to track and manage orders and multiple POs can be applied to the same Product ID. 4. Next, determine which columns you wish to delete. In this example, a facility is redoing how they've applied tags to their products. In order to delete (2) tags that correspond with (1) specific products, their excel sheet will look like this: **Expand to show screenshot** ![42748451248923.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/42748451248923.png?width=470&height=549&name=42748451248923.png) 1. This facility has multiple PO IDs applied to each Product ID, so they keep the **Worldly Product ID** columnand delete the **Worldly PO ID** column. 2. Additionally, all other columns except the **Tags** column are deleted. The facility bulk deletes the tags from the associated products by uploading an excel sheet with these two columns. 5. Your file is now ready to upload.   ## **How to Bulk Delete** 1. Navigate to **Products**, followed by the **Products** tab to upload your prepared file. **Expand to show screenshot** ![42748451252251.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/42748451252251.png?width=495&height=172&name=42748451252251.png) 2. Select **Import. ** **Expand to show screenshot** **![42748419763227.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/42748419763227.png?width=364&height=156&name=42748419763227.png)** 3. Make sure to select the **Bulk Upload - Delete Products** workbook. **Expand to show screenshot** ![42748451263131.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/42748451263131.png?width=440&height=373&name=42748451263131.png) 4. Drag and drop your file onto the screen. You can upload the following file formats: CSV, Excel, or JSON. We recommend CSV as a best practice. **Expand to show screenshot** ![42748419773723.gif](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/42748419773723.gif?width=868&height=540&name=42748419773723.gif) 5. Review the field mapping on the next two windows before clicking Continue. - If a field is missing or incorrect, select the dropdown arrow to select the desired field. - Preview the data for the category on the right side of the window. Hovering over different rows updates the preview window. - Select **Continue.** **Expand to show screenshot** ![42748419776155.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/42748419776155.png?width=870&height=290&name=42748419776155.png) 6. On the next page, toggle the switch in each cell that you wish to delete the tags from. **Expand to show screenshot** ![42748419782299.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/42748419782299.png?width=870&height=390&name=42748419782299.png) **Bulk Transformations** Use the transform functionality to toggle the switches in mass. 1. Select **Transform.** ![42748451288091.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/42748451288091.png?width=251&height=96&name=42748451288091.png) 2. Enter "change @tags to TRUE" in the text field and select the arrow key to apply the transformation. ![42748451291419.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/42748451291419.png?width=830&height=513&name=42748451291419.png) 3. Lastly, select **Transform Data** to apply changes. 7. After the table has been reviewed and all errors have been resolved, click **Submit Data**. **Expand to show screenshot** ![42748451292827.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/42748451292827.png?width=161&height=39&name=42748451292827.png) 8. You’ll know if you were successful when you see the Success pop up. **Expand to show screenshot** ![40465939472283.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/40465939472283.png?width=516&height=184&name=40465939472283.png)   ## **What can I bulk delete?** Select True for each data type you want to delete. You must provide either Worldly Product ID or Purchase Order ID to identify the product. **NOTE:** Use caution as anything deleted is permanent **Field Name** **Description** **Worldly Product ID** **(worldlyProductId)** (At least one required) String **Worldly Purchase Order ID** **(worldlyPurchaseOrderId)** (At least one required) String **Product ID** **(productID)** User-supplied product identifier Deleting this field also deletes Product ID Type   Boolean **Packaging 1** **Packaging 2** **Packaging 3** **Packaging 4** **(packaging)** Also deletes Packaging Units (1-4)   Boolean **Component 1** **Component 2** **Component 3** **Component 4** **Component 5** **Component 6** **(components)** Also deletes Component Units (1-6)   Boolean **Tags** **(tags)** Deletes full array of tags For example, if the field contains two tags, both tags will be deleted   Boolean **Purchase Order Number** **(purchaseOrderId)** Deletes the user-provided unique identifier for the Purchase Order   Boolean **Quantity** **(quantity)** Deletes the quantity purchased   Boolean **Final Assembly** **(finalAssembly)** Deletes the Tier 1 facility name The facility name should match the account name on the platform   Boolean [![Worldly logo](https://support.worldly.io/hs-fs/hubfs/Worldly%20Media%20Kit/Worldly%20Logos/Worldly_LogoTM_Red.png?width=120&height=30&name=Worldly_LogoTM_Red.png "Worldly logo")](https://www.worldly.io) © 2026 Worldly. All Rights Reserved [Terms of use](https://worldly.io/terms-of-use/)  |  [DPA](https://worldly.io/data-privacy-addendum/)  |  [Privacy Policy](https://worldly.io/privacy-policy/)  |  [Cookie notice](https://worldly.io/cookie-notice/)