Export & Clean UP

Oct 16, 2007 2 Replies
K

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


Vote
Twitter Facebook LinkedIn
A

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:

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required