How to import products from Excel or CSV
Import several products at once from a spreadsheet: download the template, fill one row per product, upload the file and confirm the new products in the list.
In this video
- Download the import template and fill it in
- Upload the file and read the validation messages
- Confirm the imported products in the list
Step by step
- Open Products and choose Import Products.
- Download the template and fill in one row per product, keeping the columns in their order.
- Save it as Excel or CSV and upload it.
- If a row is rejected, read the message, fix that row and upload again.
- Check the new products in the product list.
Why it matters
Typing hundreds of items one by one is slow and invites mistakes. Importing moves your whole item list from your old system or spreadsheet in minutes, with the same names, codes and prices, so you can start selling on day one.
All Products and stock videos
-
2:54
Lesson 1
How to add a product with opening stock
Create a product, set its unit, brand, category, VAT and prices, then add opening stock and confirm the quantity in the product list.
-
2:07
Lesson 2
How to edit a product and change its price
Find a product in the product list, open it from the Actions menu, change its name, alert quantity and selling price, and confirm the change in the list.
-
2:56
Lesson 3
Product variations: sizes and colours explained
Create a Size variation template, then a variable product that uses it, with a price for each size, and confirm it in the product list.
-
2:16
Lesson 5
How to set up categories, units and brands
Add a product category, a unit of measure and a brand, and see each one appear in its list.
Get certified in Skyline Nexus ERP for 199 SAR or 49 USD
Show employers and clients that you can run daily sales, purchasing, stock and customer and supplier accounts in an ERP. Preparing for the exam improves your accounting practice: invoices, credit and debit notes, opening balances and ledgers, done the way real companies do them.
- An online exam on the four modules: products, contacts, sales and purchases
- Practice tasks on a demo company before the exam
- A Skyline certificate in your name with its own certificate number
- For accountants, bookkeepers, cashiers, sales and purchasing staff, students and business owners
199 SAR 49 USD
199 SAR in Saudi Arabia, or 49 USD from any other country. Prices exclude VAT; 15% VAT is added for buyers in Saudi Arabia.
Enrol for the certification
Send your details and we reply by e-mail with the payment link and your exam access.