[OFBIZ-5116] Bulk creation of products via excel upload and product image content via zip file upload

• Type: New Feature
• Status: Patch Available
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: Trunk, Upcoming Branch
• Component/s: product
• Labels: excel productid zip

Environment

OS : Ubuntu 12.04
Database : mysql

• Sprint: Bug Crush Event - 21/2/2015
• Assignee: Unassigned
• Reporter: winster t jose
• Created: 29/Dec/12 01:57
• Updated: 11/Jan/22 08:48

Description

Users can use this feature to create a number of products and associated images in a single stretch.

The excel sheet is used for storing product information and the zip file should contain images for each product.

Spreadsheet parsing service for the creation of products had already been implemented as part of productImportFromSpreadsheet. But for that to happen, excel sheet has to be kept in a location somewhere inside server. But I have made it more flexible by allowing user to upload an excel sheet.
The next part is uploading images for each product. User has to create a folder which contains image file for each product which has been mentioned in excel. The name of image file should be product id. When a zip file is uploaded, it will be extracted in server and each image will be stored in respective image sever path.