# Support importing Term column with "no term"

**URL:** <https://community.hubspot.com/t/support-importing-term-column-with-no-term/52860>\
**Category:** HubSpot Ideas\
**Created:** [March 10, 2022, 3:15am UTC](https://community.hubspot.com/t/support-importing-term-column-with-no-term/52860 "2022-03-10T03:15:36Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jwebster411](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jwebster411/32/53869_2.png) [@jwebster411](https://community.hubspot.com/u/jwebster411)\
**Post date:** [March 10, 2022, 3:15am UTC](https://community.hubspot.com/t/support-importing-term-column-with-no-term/52860/1 "2022-03-10T03:15:36Z")

</div>

I set a term for 300 products the other day and wanted to remove the term. The only supported values are 1-a really big number. I need to change the term to 0 or “blank”

The export doesn’t support either of these options and Hubspot support suggested deleting the products and re-importing to remove the value. Would be great if the next person that needs to do this can use an import file instead of deleting products.

---

<div class="post-metadata">

**Author:** ![jwebster411](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jwebster411/32/53869_2.png) [@jwebster411](https://community.hubspot.com/u/jwebster411)\
**Post date:** [March 16, 2022, 6:07pm UTC](https://community.hubspot.com/t/support-importing-term-column-with-no-term/52860/2 "2022-03-16T18:07:55Z")

</div>

I also set the billing frequency to “monthly” and need to change it back to “one-time” guess how that is handled! If you guessed, “change it to blank” you guessed correctly. Spoiler. You can’t import a blank value so we are in the same boat with billing frequency 😞 😞 😞

---

<div class="post-metadata">

**Author:** ![Harald\_Harstad](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/harald_harstad/32/33328_2.png) [@Harald\_Harstad](https://community.hubspot.com/u/Harald_Harstad)\
**Post date:** [January 25, 2023, 6:04pm UTC](https://community.hubspot.com/t/support-importing-term-column-with-no-term/52860/3 "2023-01-25T18:04:02Z")

</div>

Just met the same problem. Want to update line item “Billing Frequency” from annual to one-time, but not possible… In export Billing frequency)=“One-time” has “no value”