Importing Items (parts, products) into your Free Purchase Order Software

Abdul needs to get 9,000 items/parts/products into the free version of SpendMap and he isn’t about to type all that information in manually…

“We have about 9000 products. Do we have option to upload products in bulk?  Because if I add one by one it will take months to finish this task.”

For sure, manually typing in 9,000 items would take way too long!

You can import your items into SpendMap’s Item Master File to save all that data entry. It’s a two-step process as follows…

1) First you need to set up an Import Configuration to tell SpendMap where the specific pieces of information (fields) are in your Excel spreadsheet, TXT or CSV file. Here’s the menu path…
– PURCHASING > Utility > Data Interfaces > Item master file > Item data > Import > Configure import file layout

2) Then, to actually run the import utility and bring in all your items, use this…
– PURCHASING > Utility > Data Interfaces > Item master file > Item data > Import > Import into Item Master File

When you run the import utility (#2 above), it will prompt you to select the Import Configuration that you set up in #1 above, and then you will select your file to import.

But before you get started, may I suggest that you review the following section of the Online Help in SpendMap…
– System-Wide Features and Information > Integration Tools > Overview and General Information

Click the “YouTube” icon at the top of that Help section, to watch a video tutorial on importing data into SpendMap (the video actually uses importing of items in its examples).

Also, as you will see during the video tutorial, in the Evaluation Copy of SpendMap (the one that comes preloaded with sample data), we included a sample Excel spreadsheet with a few sample items to import, and there is an Import Configuration already set up to match that spreadsheet.  So give it a try in your Eval Copy first, to see how it works, before actually importing your items into your Live Copy of SpendMap.

Finally, here are a few other blog posts related to importing data.

Hope that helps.

-FP

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s