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

Reply to
Kathryn WOJ
Loading thread data ...

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:

Reply to
Akber Alwani

Reply to
Kathryn WOJ

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.