Export & Clean UP

I have exported the retail database to .csv file. Opened in Excel and I am cleaning up Deptmements - Categories & Suppliers.
Couple of things: 1) The Dept/Cat/Sup export as ID codes - rather than text
- Will I need to create a text equivalent for each & import the text names for each? 2) Can I delete all items & then reimport cleanly without losing sales & report data?
I will be using QSImport tool to reimport the cleaned up data
Kathryn Wings Of Joy
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
hi Kathey, if the purpose of the export to clean up the department, categories so no need the hug work just update the Item table with following query update item set departmentid=null,categoryid=null,supplierid=null -- this will update for all items for department and categories and supplier to empty
Don't delete the items as it will create the descripencieis in your reports and data will be reduandant then.
"Kathryn WOJ" wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Thanks - that makes sense - I will run a test db with query - clean up & re-import
"Akber Alwani" wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.