ADD MULTIPLE PRODUCTS TO CMS - elitan23/testui GitHub Wiki

Ideation/Hypothesis (from Eli)
Create "bulk upload", so user can upload a lot of product at once
To make the process of adding products faster, user can upload all the products in 1 single file.

User Goal
User can upload multiple products at once.

User Problem
It takes time for user to add a lot of products to the platform.

Validate the Ideation/Hypothesis
Do the users need the bulk upload? What kind of users that need the feature?

To validate the ideation, I decided to take short interview to 3 certain users (already sell something; online, offline, the users picked randomly)
- Have ever sell the products before? How is it?
- What kind of product do you sell?
- How many variants of products that you sell?
- How large the business is?
- How do you save the product list? (using laptop, or book)

Result of Interview
* 2/3 users sell their products through store and Instagram, while 1 user sells the products through marketplace
* The products that they sell; (1) Clothes, (2) Handphone Accessories, (3) Oil for motorbike and cars
* 2/3 users already have > 100 products, while 1 user only has 30 products
* 2/3 users has developed their business 2 years ago (small-med business), while 1 user started the business since 6 months ago (small business)
* 2/3 users has saved their product list using laptop (excel app, or gsheet), while 1 user listed down the products in the book
* Based on the result, multiple products feature can be useful for some users.
User will use bulk upload, if:
- They want to add a lot of products to the platform at once
- They already have the item list in spreadsheet file (excel)

User Persona
- >18 years old
- User has started the business (might be online; in another platform, or offline)
- User has a lot of product catalogue in excel sheet
- User would like to expand the business (small-mid business)
- User understand the tech; can learn and adapt the tech

User's Problem in Real Case
Aldi has developed his fashion business through Instagram since 2 years ago. Currently, the number of products in his shop has reached > 200 clothes, and sells more than 600 clothes per month. Due to high demand, Aldi wants to expand his business in another platforms.

Now, he wants to try the instant online store platform; Sirclo. While setting up his store, he would like to add products to the platform. He has to move his product; one by one; from excel to CMS platform.

For now, Aldi doesn't have an admin yet, and must divide his time to manage his business. He hopes that he can add all of the products quickly at once.

User's Pain Point
- Needs a lot of time to add multiple products, especially when there are so many products that need to be added
User has to add all of the products one by one.
- Needs time to change the details from several products
User has to find the product from the product list, and change the detail one by one.

User Requirement
- Provide a way to add multiple items at once
- Provide a way to notify user whether the adding process would be successful or not

Desk Research
Tokopedia
There are 2 ways adding products to the platform; Add product, or Add at once When user chooses "Add at once", user can upload the products in spreadsheet file (.xlsx)
There is spreadsheet format, so user can download the format, and fill the format based on the data.
Max. rows of product that can be add in 1 file: 150 rows (To prevent the error potential)

Shopify
Shopify provides 2 ways to add the products to the platform; "Import" or "Add product"
When user chooses "Import", user can choose file, and upload the file (.csv)
There is a sample CSV template to see an example of the format required

User Flows
Case 1:
User would like to add multiple products at once to the system. Assume this is the first time for him. The products can be added successfully.
Steps:

• User chooses “Product” menu
• User clicks “Add Product”, then clicks “Multiple Products”
• User downloads the template
• User fills the values using the template, and reviews the values
• User clicks “Choose File”, then selects the file
• User clicks “Upload”
• User waits the uploading process
• User sees the uploaded result
• The products have been added to the system

Case 2:
User chooses the wrong format file. Assume that the user already has the file with the correct template, but the user chooses another file (mistakenly chooses the file).
Steps: - User chooses “Product” menu - User clicks “Add Product”, then clicks “Multiple Products” - User fills the values using the template, and reviews the values - User clicks “Choose File”, then selects the file - User clicks “Upload” - Due to incorrect format type, user gets the error message: “Wrong file extension. Please upload the .csv, .xlsx file.“ - User chooses the correct file - User waits the uploading process - User sees the uploaded result - The products have been added to the system

Case 3:
User already downloaded the template, but he forgot to fill some values, and fill the values incorrectly. Instead of revising the file first, he uploads the file to the platform.
Steps: - User chooses “Product” menu - User clicks “Add Product”, then clicks “Multiple Products” - User fills the values using the template - User clicks “Choose File”, then selects the file - User clicks “Upload” - User waits the uploading process - Due to missing values, user gets the error message: “Please fix incorrect values, then re-upload the file.“ - User reviews the incorrect and missing values - User revises the files - User chooses the correct file - User waits the uploading process - User sees the uploaded result - The products have been added to the system

Prototyping URL https://invis.io/7CVK45Q4ZWS