We are looking to find a way to take advantage of the NetSuite system.
We import items from Ford and GM via a price tape. Some of these items do not have pricing information for the item ($0.00). We may look into creating a workflow or a script to help us out on a monthly basis if what I am planning will work. That is where the community comes in for your knowledge on my plan.
I know that by placing an item in an 'Inactive' status it will not get updated during a price tape import, but we do want the information from the price tape to update the item record.
My 'solution' is to change the items that do not have the pricing information to a status of 'No Pricing' and have it so that it will not be visible to our customers, but it will not be 'Inactive'. This will, hopefully, allow the item to still be updated through the price tape and once the pricing information is correct we can change the status back to 'good' and be able to sell the item again.
This has been an issue for a while and we have narrowed it down to the price tape importing.
So would this 'STATUS' change work the way that I have lined out above? Or is there another way that I do not know about? We have just passed our one year anniversary of using NetSuite and I am far from knowing what I can. But I am learning more and more every day.