1. Home
  2. Point-Of-Sale Software
  3. Importing new Items in bulk

Importing new Items in bulk

I've got a CSV with 400 new items. Be damned if I'm going to manually enter them one by one. I am quite comfortable with SQL scripting and VB so I was thinking of writing a simple CSV-to-Items-Table program. Are there any dependancies or relationships I should consider before just tossing 400 new items into the items table? They won't be getting suppliers right away (I have a tool for adding suppliers en masse anyways) so that's a non-issue. All the new items will be atomic units (ie: no kits or assemblies) so that, too, is a non-issue.

I'm just afraid of breaking something by bypassing RMS's business logic and was wondering if anyone else has done this sort of one-off import job before.

Reply to
MartiniTheAce
Loading thread data ...

Make sure that none of the item look up codes exist in Item.ItemLookupCode or Alias.Alias

If you want to assign departments, categories or taxes, they are all enetered as Int values from Department.ID, Category.ID, etc...

Glenn Adams Tiber Creek C> I've got a CSV with 400 new items. Be damned if I'm going to manually

Reply to
Glenn Adams [MVP - Retail Mgmt]

Martini,

Another option to try is to get the Store Operations Import Utility available from RMS Support.

Reply to
Jeff

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.