export items from Stores to HQ??

It won't be easy...

If you have *identical* supplier lists at both stores, simply use one store as your HQ template (all of the items from that store will be imported automatically, so pick the store with the most items).

Then (and this is the tricky part) export the results of the following query from both SO DBs: SELECT * from Item

You'll get two CSV files. Open them with MS Excel. Delete any unwanted/unused columns. Add a column for 'store'. Filter the list on ILC for unique records only. Delete all of the resulting records that are from Store 1 (assuming that Store 1 was the HQ template store). Import the remaining records.

Regarding the import... I have use the QSCimport utility with HQ. It didn't cause any problems that I am aware of, though after the fact I was cautioned rather strongly against this procedure. A potentially better solution would be to use text functions in Excel (&R1C1 or CONCATENATE) to create a series of INSERT INTO query statements to insert the rows into the HQ Items table. You will want to make absolutely certain that the imported Supplier/Dept/Ctgy IDs match up with the HQ tables. A thorough and intimate knowledge of Excel is recommended.

HTH, Tom

"> I have two separate store operation system,and the items in the two system is