--- title: "Why am I getting \"Nan\" import error when trying to delete categories?" description: "Fix \"nan\" value errors when deleting categories via import in WizCommerce—clean up your export file before re-importing to avoid failures." --- [Skip to content](https://knowledge.wizcommerce.com/why-am-i-getting-nan-import-error-when-trying-to-delete-categories#main-content) [![Asset 9](https://knowledge.wizcommerce.com/hs-fs/hubfs/Asset%209.png?width=223&height=30&name=Asset%209.png)](https://wizcommerce.com/) Open main navigation Close main navigation - [Contact us](https://mail.google.com/mail/?view=cm&fs=1&to=help@wizcommerce.com) [Contact us](https://mail.google.com/mail/?view=cm&fs=1&to=help@wizcommerce.com) Hi, how can we help? - There are no suggestions because the search field is empty. 1. [WizCommerce Help Centre](https://knowledge.wizcommerce.com/) 2. [Help & FAQs](https://knowledge.wizcommerce.com/help-faqs) 3. [Help with Import/Export](https://knowledge.wizcommerce.com/help-faqs#help-with-import-export) June 5, 2026 # Why am I getting "Nan" import error when trying to delete categories? This usually happens because the exported file contains "nan" values in the Priority column. "nan" (not a number) is invalid and causes the import to fail. Clean up the file first, then re-import. --- #### **» Steps to delete categories without errors** 1. In WizOrder, go to***Manage → Import and Export***, click the ***Collection*** tile, then click ***Export***. The export file can be downloaded from the notifications bell (top right corner). 2. Open the downloaded Excel file and go to the ***Data Sheet*** tab. 3. Find the **Priority** column and replace any **nan** values with a valid number, use 0 or 1 if you are unsure. 4. Find the **Image URL** column, if there is no image, leave the cell blank. Do not leave "nan" in this field either. 5. In the ***Delete?*** column, enter **Delete** for each category you want to remove. 6. Save the file. Go back to ***Manage → Import/Export → Collection → Import*** and upload the updated file. 7. ***Verify,*** and check the notifications panel (bell icon, top right) to confirm the import completed successfully. **Tip:**  For more on managing categories, see [Manage Categories and Collections](https://knowledge.wizcommerce.com/manage-categories-and-collections) in the WizCommerce Help Centre. --- #### **» A few things worth knowing:** - "nan" is an invalid value, always replace it with a number or leave the field blank before importing. - Check all columns before re-importing to make sure no other invalid data remains. - To undo a deletion, re-import the category without the Delete entry in the ***Delete?*** column. --- **Still need help?** Reach out to your Customer Success Manager or contact our [Support Team](mailto:help@wizcommerce.com). - [Getting started](https://knowledge.wizcommerce.com/getting-started#main-content) - [Product Overview](https://knowledge.wizcommerce.com/getting-started#product-overview) - [Key Concepts You Should Know](https://knowledge.wizcommerce.com/getting-started#key-concepts-you-should-know) - [Product Guides](https://knowledge.wizcommerce.com/getting-started#product-guides) - [Trade Show Checklist](https://knowledge.wizcommerce.com/getting-started#trade-show-checklist) - [Product Search & Discovery](https://knowledge.wizcommerce.com/product-search-discovery#main-content) - [AI Product Recommendations](https://knowledge.wizcommerce.com/product-search-discovery#ai-product-recommendations) - [Filter and Navigate](https://knowledge.wizcommerce.com/product-search-discovery#filter-and-navigate) - [Catalog](https://knowledge.wizcommerce.com/product-search-discovery#catalog) - [Product Selection & Ordering](https://knowledge.wizcommerce.com/product-selection-ordering#main-content) - [Orders](https://knowledge.wizcommerce.com/product-selection-ordering#orders) - [Quotes](https://knowledge.wizcommerce.com/product-selection-ordering#quotes) - [Cart](https://knowledge.wizcommerce.com/product-selection-ordering#cart) - [Presentations](https://knowledge.wizcommerce.com/product-selection-ordering#presentations) - [Wishlist](https://knowledge.wizcommerce.com/product-selection-ordering#wishlist) - [Item History](https://knowledge.wizcommerce.com/product-selection-ordering#item-history) - [Invoices](https://knowledge.wizcommerce.com/product-selection-ordering#invoices) - [Customers & Accounts](https://knowledge.wizcommerce.com/customers-accounts#main-content) - [Customer Relationship Management (CRM)](https://knowledge.wizcommerce.com/customers-accounts#customer-relationship-management-crm) - [Inventory & Warehousing](https://knowledge.wizcommerce.com/inventory-warehousing#main-content) - [Inventory availability](https://knowledge.wizcommerce.com/inventory-warehousing#inventory-availability) - [Payments](https://knowledge.wizcommerce.com/payments#main-content) - [Payment Dashboard](https://knowledge.wizcommerce.com/payments#payment-dashboard) - [Pricing & Commercials](https://knowledge.wizcommerce.com/pricing-commercials#main-content) - [Pricelist](https://knowledge.wizcommerce.com/pricing-commercials#pricelist) - [Discounts & Promotions](https://knowledge.wizcommerce.com/pricing-commercials#discounts-promotions) - [Claims & Credits](https://knowledge.wizcommerce.com/pricing-commercials#claims-credits) - [AI Co-Workers](https://knowledge.wizcommerce.com/ai-co-workers#main-content) - [Ella - AI Order Entry Assistant](https://knowledge.wizcommerce.com/ai-co-workers#ella-ai-order-entry-assistant) - [WizPilot - AI Assistant](https://knowledge.wizcommerce.com/ai-co-workers#wizpilot-ai-assistant) - [WizStudio](https://knowledge.wizcommerce.com/wizstudio#main-content) - [Creating & Editing Images](https://knowledge.wizcommerce.com/wizstudio#creating-editing-images) - [Lifestyle Generator](https://knowledge.wizcommerce.com/wizstudio#lifestyle-generator) - [Silo Editor](https://knowledge.wizcommerce.com/wizstudio#silo-editor) - [Bulk Silo Editor](https://knowledge.wizcommerce.com/wizstudio#bulk-silo-editor) - [Asset Library (Assets)](https://knowledge.wizcommerce.com/wizstudio#asset-library-assets) - [AI Image Expander](https://knowledge.wizcommerce.com/wizstudio#ai-image-expander) - [Reports & Analytics](https://knowledge.wizcommerce.com/reports-analytics#main-content) - [Business Reports](https://knowledge.wizcommerce.com/reports-analytics#business-reports) - [Manage your WizCommerce (Admin)](https://knowledge.wizcommerce.com/manage-your-wizcommerce-admin#main-content) - [Import / Export](https://knowledge.wizcommerce.com/manage-your-wizcommerce-admin#import-export) - [Organizational Settings](https://knowledge.wizcommerce.com/manage-your-wizcommerce-admin#organizational-settings) - [Product Management](https://knowledge.wizcommerce.com/manage-your-wizcommerce-admin#product-management) - [Managing Your WizShop Website](https://knowledge.wizcommerce.com/manage-your-wizcommerce-admin#managing-your-wizshop-website) - [Integration & Apps](https://knowledge.wizcommerce.com/integration-apps#main-content) - [Marketing Integration](https://knowledge.wizcommerce.com/integration-apps#marketing-integration) - [Integration Dashboard](https://knowledge.wizcommerce.com/integration-apps#integration-dashboard) - [Help & FAQs](https://knowledge.wizcommerce.com/help-faqs#main-content) - [Help with Orders](https://knowledge.wizcommerce.com/help-faqs#help-with-orders) - [Help with Quotes](https://knowledge.wizcommerce.com/help-faqs#help-with-quotes) - [Help with Presentation](https://knowledge.wizcommerce.com/help-faqs#help-with-presentation) - [Help with Inventory](https://knowledge.wizcommerce.com/help-faqs#help-with-inventory) - [Help with User Management](https://knowledge.wizcommerce.com/help-faqs#help-with-user-management) - [Help with Pricelist & Discounts](https://knowledge.wizcommerce.com/help-faqs#help-with-pricelist-discounts) - [Help with WizStudio](https://knowledge.wizcommerce.com/help-faqs#help-with-wizstudio) - [Help with Ella](https://knowledge.wizcommerce.com/help-faqs#help-with-ella) - [Help with Org Settings (Admin)](https://knowledge.wizcommerce.com/help-faqs#help-with-org-settings-admin) - [Help with Emails](https://knowledge.wizcommerce.com/help-faqs#help-with-emails) - [Help with Products](https://knowledge.wizcommerce.com/help-faqs#help-with-products) - [Help with Import/Export](https://knowledge.wizcommerce.com/help-faqs#help-with-import-export) - [Help with WizShop](https://knowledge.wizcommerce.com/help-faqs#help-with-wizshop) - [Help with Integration](https://knowledge.wizcommerce.com/help-faqs#help-with-integration) - [Help with Categories and Collections](https://knowledge.wizcommerce.com/help-faqs#help-with-categories-and-collections) - [Help With Customers](https://knowledge.wizcommerce.com/help-faqs#help-with-customers) - [Help with Trade Show](https://knowledge.wizcommerce.com/help-faqs#help-with-trade-show) [![Asset 10](https://knowledge.wizcommerce.com/hs-fs/hubfs/Asset%2010.png?width=238&height=32&name=Asset%2010.png "Asset 10")](https://wizcommerce.com/)   [mailto:help@wizcommerce.com](mailto:help@wizcommerce.com) Copyright © 2025, WizCommerce