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?
- posted
17 years ago
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?
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...
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:
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
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
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
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...
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".
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.