Importing items with an excel worksheet

I am getting about 1000 new items from a new company and I don't really want to add the items one by one does anyone know a way to maybe import the excel file with all of these to Headquarters?

Reply to
Claudia Stevens
Loading thread data ...

We have a Utility to do this which is to do it once as well as often as you get a supplier catalogue. This add-on RR Import is priced at $495 for import to store and HQ. It also automatically creates a 250 to transfer the data to Store from HQ

Afshin Alikhani - [ snipped-for-privacy@retailrealm.co.uk ] CEO - Retail Realm = = = = = = = = "Claudia Stevens" wrote in message news: snipped-for-privacy@microsoft.com...

Reply to
Afshin Alikhani

QSC Import. Free utility available from MS through CustomerSource. Save to a CSV file then import. Easy as pie. Make sure you assign the unique item number before importing.

Claudia Stevens wrote:

Reply to
Mickie

BACKUP FIRST. It might be best to do this after hours.

If you don't know the field names, etc. you might be better off with QSCimport. It's free if you have access to CustomerSource or maybe from

formatting link
as a download.

In Excel, try a formula like this...

="INSERT INTO Item (ItemLookupCode, Description, Cost, etc) VALUES ('"&[ILC]&'", '"&[Desc]&"', "&[Cost]&", '"&etc... )

Where [fieldName] is a cell reference. Text stings will require single quotes before & after. Numeric values don't. True/False (appear as checkbox in both Admin query results and HQ Manager) are either 0 or 1.

Fill down.

Copy entire list of query statements into SO Admin new query. F5 runs the query.

IN HQ Manager, issue a WS250 for all of the new items. If they're all from the same supplier, just issue a WS250 for that supplier. Other tables (ItemDynamic, SupplierList) will auto-update.

Tom

Reply to
Terrible Tom

One more thing - set up the supplier first., then in HQ Admin SELECT * from SUPPLIER and find the SupplierID. You'll need it if you want to assign the items being imported to the new supplier.

Tom

Reply to
Terrible Tom

DO NOT USE QSCImport against HQ Database. This does not update the dynamics tables. Also if you are updating a large set of records regularly you need to know what is new, what is changed and decide which data to update or create. These are not avilable in the QSCImport.

Afshin Alikhani - [ snipped-for-privacy@retailrealm.co.uk ] CEO - Retail Realm = = = = = = = = = "Claudia Stevens" wrote in message news: snipped-for-privacy@microsoft.com...

Reply to
Afshin Alikhani

HAve need of the same utility. Is this what is shown, in Customer Source, as RMS Store Operations Import Utility? I can't find anything there containing "QSC".

Reply to
PRJ

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.