POS Magazine
Retail POS Software
Restaurant POS
POS Software (All)
POS Hardware Directory
Case Studies
POS Resellers by State
POS Career Listings
Upcoming POS Trade shows






Want to advertise here? Download the info now.

Author Topic: database in retail ice  (Read 3422 times)

virus.app

  • Guest
database in retail ice
« on: September 20, 2011, 01:32:35 PM »
can i import my inventory from excel to retail ice? i came across an add in to excel which wud supposedly let me import/ export from/to excel/sql db.. if all that makes sense.. pls help me out by posting the "how to...". thank you.

jgbreeden

  • Newbie
  • *
  • Posts: 4
  • Post Quality: +0/-0
    • View Profile
    • www.simpliflex.com
Re: database in retail ice
« Reply #1 on: October 12, 2011, 07:25:23 PM »
In general, it would go something like this:
- select the export option in the add-in
- it should give you options for the export type (from what I have read on Retail ICE, it's SQLbase)
- it should then give you an option to find or specify the database by name
- hopefully the add-in will allow you to select an existing table within the database to receive the export -- you will need to figure out the correct table (or tables) to hold your information
- you would then need to "map" the fields, such as "column C" in your spreadsheet matches to the "description" field in the inventory table
- then run the export process, and it will certainly get errors
- read the errors, try to clean up your data, and keep repeating until you get a clean load

Jeff
www.simpleposshop.com

 

Sitemap 1 2 3 4 5 6 7 8 9 10