Discussions
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
Customer lists exporting multiples/duplicates
I export my customer list from netsuite to a spreadsheet on a regular basis, typically using the "items purchased" as a delimiter for selecting the customers. I have used this technique for years with no problem.
Now, with the latest upgrade, when I search by items purchased by customer it provides me with the correct answer on the results screen, say for example 4,987 unique customers [most likely with a 5% duplication rate in the list] purchased a particular face cream. The screen reports the correct 4,987 customers and I can use the drop down to see the names, addresses, etc.
The flaw is in exporting, when I export this exact list of 4,987 names Netsuite exports 15,000 customer names, treating each time a unique customer purchased a specific product as a unique event. i.e., I have Susie Smith listed 8 times as a record because she has bought the same item 2x per year for 4 years, even though she only has one customer record.