I have over 150 customers that have custom (absolute) pricing on their records. 1200 items each. To initially put them there, we uploaded them via csv import. It takes 1.5 hrs for one customer's pricing to be imported. That's a LOT of time for 150 customers. Now, we need to remove all these special priced items off the customer records. They will be a straight 8% off list/base price. I know I can "overwrite" on the import, but that's not really what I'm trying to do. Want to delete/remove them. If "overwrite" is the answer, what is going in the file exactly? I tried to import a file with the customer internal ID, and blank columns for pricing, but it wants values. Appreciate the help. Have question also submitted on FB and to NS but no clear answers yet.
UPDATE - I forgot to add that i need it to be effective on a specified date. I can't do all the updates on the day that they need to take effect, so need to submit in advance, for a specific date in the future.