Creation of material from excel sheet

[Former Member]

Hi All,

Can we create material by uploading from excel sheet.

I have created all necessary product categories in system.

I want to create 20 materials in one product category from excel sheet.

Abdul Raheem

[Former Member · Accepted solution]

Hi Abdul,

have you tried to import the data via Import Data (System Administration --> Import and Export Tools --> Import Data).

Also did you use the correct template; to access the correct template, please follow these steps:

• Go to Import Data
• Insert a dummy .xls file
• From the dropdown list, choose Materials
• On the next screen, download the template.csv file
• Populate the fields as required on that spreadsheet

Repeat the import.

Hope this helps, if it solves your question, please mark this answer as solved.

Thanks,

Armin