Admin User Story 3 - Bulk Import Catalog Items

[ClaireReinken]

As an administrator, I want to add product catalog items in bulk so that each item does not have to be added line by line or cell by cell

Acceptance Criteria: • Administrators can import the catalog in .xlsx or .CSV format by using a bulk feature to import all items at once • The spreadsheet must contain the following data columns: o CLIN o UNPSC Code (Version 11) o Manufacturer Part Number (OEM #) o Manufacturer (OEM) o SKU #/ Item # o Item Name o Item Description o Unit of Measure o List Price/MSRP o Contract Unit Price o Contract Discount o Category o Product Type o Contract # o Contract Vendor o Contract Expiration Date o Product Image URL • The import feature will automatically not import any records duplicated in the spreadsheet or records already in the system

[ClaireReinken]

Dev and UI tasks are included in Issues #108 and #109

[Mikewilburn302]

Is there any check in case an admin uploads the same file twice? How do we prevent duplicate items?

[ClaireReinken]

Is there any check in case an admin uploads the same file twice? How do we prevent duplicate items? - Yes, we will use the CLIN number and contract number to identify a catalog item as an unique item. When a user attempts to upload duplicate items, an error will appear to the user, "X number of items successfully uploaded, X items failed to upload because they are already in the catalog." Or similar wording. If possible, we should tell the user what item failed to upload.

[ClaireReinken]

The Admin user would have to enter the product image column information. We’ll have instructions on the import page that indicates to show product images, this column need to contain a path to the image in their repository.

[Mikewilburn302]

Can I be sent an email containing a csv inventory file I could use?

[llin-freeman]

Hi Luis, Can you send Mike the data file?

Thanks, Lisa

I-Chun (Lisa) Lin-Freeman Senior Associate

office | 443.270.5100 x64858 direct | 667.786.4858 fax | 410.715.6538 email | Lisa.Lin-Freeman@feisystems.commailto:Lisa.Lin-Freeman@feisystems.com

FEi Systems | 9755 Patuxent Woods Drive, Suite 300 Columbia, MD 21046 | www.FEIsystems.comhttp://www.feisystems.com/

This document may contain confidential and proprietary information of FEI.com, Inc. (FEi Systems). This information is intended for the use of the individual(s) or entity(s) to whom it is addressed. If you have received this email in error, please notify the sender immediately at the address shown and delete it from your files.

From: Mike Wilburn [mailto:notifications@github.com] Sent: Monday, February 27, 2017 4:14 PM To: FEISystems/ca-adpq-prototype ca-adpq-prototype@noreply.github.com Cc: Subscribed subscribed@noreply.github.com Subject: Re: [FEISystems/ca-adpq-prototype] Admin User Story 3 - Bulk Import Catalog Items (#27)

Can I be sent an email containing a csv inventory file I could use?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://github.com/FEISystems/ca-adpq-prototype/issues/27#issuecomment-282855358, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AVdww-sfRaELfWxcutdywpVGTBonl_hsks5rgzy1gaJpZM4MAh5r.

[davidatfei]

Mike, open git board. Go to the code tab. Choose the develop branch.

ca-adpq-prototype/ca_proto/ca_service/DbScripts/

There are images in a folder there and there is a csv there: Data Set_ADPQ_v5.csv is the one to use.

[Mikewilburn302]

I need a csv file that has not already been uploaded. Everything is skipped because they are duplicates