How to mass remove all previous customers' tax exemptions?

giangabrielkim
Visitor
1 0 0

Hello! We've recently wanted to include taxes after we have successfully registered our business with our tax bureau here in the Philippines. However, after an repeat customer orders, we learned that previous customers were tagged as tax exempt. How can we remove the tax exempt status on all customers that were previously on the Shopify database? We want to collect taxes for all the 600+ customers. I hope anyone can help me. Thank you!

Reply 1 (1)

Blair
Shopify Staff
1986 261 234

Hey @giangabrielkim,

 

Thank you for reaching out to the Community! I'm happy to provide some assistance with making adjustments to your customers, to get this resolved. To provide some context, a CSV file can be utilized to provide the ability to export a large number of customers and their details to make adjustments. I recommend checking out our Using Customer CSV Files documentation for information on exporting and how to use the file. 

 

To complete this, you can: 

 

  • Head into the Shopify admin, select Customers
  • Click Export.

  • Select one of the following export options:

    • Current page to export the customers showing in your store admin.
    • All customers to export all your store's customers.
    • Selected customer to export customers you have selected.
    • # customers matching your filters to export a customer segment.
  • Click Export customers.

 

Once exported, you can update the Tax Exempt column to reflect the appropriate details and import back into the shop. It's important to note that exported and imported CSV files are limited to 1 MB in size, which may result in having to upload multiple CSV files to successfully complete this. 

 

Alternatively, you can look to the Shopify App Store for an available app that will allow for this change to be made. The app Matrixify for example, is a great workaround that will allow you to also achieve this in bulk. 

 

Please let me know if you have any other questions or concerns!

 

 

Blair | Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog