My suppliers have fowarded their upc codes (barcode #s) to me in an excel format and shy of manually entering all my inventory by hand is there anyone out there that can tell me how to import them from excel to RMS. I can't get a hold of my supplier to find out more about the maintenance program from microsoft called customersource. I understand that this might help.
I came across something called "STORE_OPERATIONS_IMPORT_UTILITY" does mean anything?
please help somebody.
We have a good utility that does what you need [item import and catalogue import]. Contact me for more info.
Afshin Alikhani - [ snipped-for-privacy@retailrealm.co.uk] CEO - Retail Realm
Apparently I already have the import utility from SMS which i tried today, but got nowhere.
"country" wrote:
You can use any import utility for SQL. My favorite is EMS SQL Import
The QSImport Utility has some specific ways the needs to be passed. i.e. Dept and Cat need to be the exact spelling including case sensitivity. Also don't try and import Taxes just assign them after you have imported the items using the Inventory Wizard in RMS.
What specific probelems are you having?
Rob
You can use the excel files that came from your suppliers and just rename the headings. Once you have modified the file to your liking save it as a CSV file.(Just be careful because if you open the file after it has been save as a CSV file you will lose any 0 'zeros' from the beginning of any cell.) Then map select you file, enter the database info and click next. Map you fields and click next. If you have any headings in your file be sure to check the 'Skip first line when importing' box and click next then Import.
Some other tidbits: It is best that you already have your Departments, Categories and Suppliers setup before importing. Be sure to double check spelling of all your Departments, Categories and Suppliers. Do not import Tax. Alias importing is always done after you imported the item. ALWAYS DO A BACKUP OF YOU DATABASE BEFORE IMPORTING!!!!
Rob
Have something to add? Share your thoughts — no account required.
Ask the community — no account required