How to bulk import the Inclusive/exclusive box unticked

Frank22

Hi there,

I am bulk importing new pricing, but want to have the new pricing without GST. The previous pricing included GST, so the tick box for Inclusive/Exclusive is ticked.

What character can I insert on the 'Sell Price Inclusive' field to clear the Inclusive/Exclusive tick, on import?

Cheers

Komal_S

Hi @Frank22 

 

If you're updating the prices of items already existing in the data file which had Sell Price Inclusive ticked, it would remain ticked even if the Excel document has nothing in that field ( No character in the Sell price inclusive indicates that the prices are not tax inclusive) . 

It works only if the item to be imported is new or for items that never had Sell Price inclusive ticked before. 

 

In the meantime, can you please try entering N in the Sell price inclusive for those items and do the import again and check if its unchecked?