Product CSV template
Type your products, sizes, prices and stock into the table. Rows with a blank title join the product above, so each size is one row. Download a CSV that Storelala can import, or a general CSV for any other store or sheet.
These rows are an example and cannot be downloaded. Add your own product with Add a row or a pasted list, or press Clear rows. Download blank template gives an empty file.
Paste a list or open a CSV file
Leave the title blank to add a size or colour to the product above. Scroll the table sideways for more columns.
- In Storelala, open Products, press the menu button and choose Import from a spreadsheet.
- Leave Stock blank if you do not want Storelala to count it. Type 0 for sold out.
- Photos can be https links or file names such as red-lawn.jpg, which you add during the import.
- Need codes for each size? Make them with the SKU generator, or keep counts with the stock register.
Ready to put these products in a store?
In Storelala you can import products from a spreadsheet, so this file goes straight in. Every plan has cash on delivery, and Lite is free forever.
Start your storeQuestions
How do I add sizes and colours?
Give each variant its own row. Write the product title on the first row, then leave the title blank on the rows below it. Fill Option 1 with the name, such as Size, and the value on each row, such as S, M and L. For a second option, such as Colour, use Option 2.
How do I import the file into Storelala?
Open Products in your store admin, press the menu button and choose Import from a spreadsheet. Pick the file you downloaded. Storelala shows you what it will add and any rows to fix before anything is saved. A title already in your store updates that product instead of adding a new one.
Why does the table show problems?
The Storelala import needs a title and a price on every row, whole-number stock, a different size or colour on each row of a product, and no SKU used twice. The table points at the row and says what to change. The Storelala file stays locked until these are fixed.
What do I put for photos?
Paste a link that starts with https://, or the file name of a photo you will add during the import, such as red-lawn.jpg. The first row with a photo is the first picture of that product.
Can I use this CSV in another store or Excel?
Yes. Choose the general CSV. It has plain columns for title, handle, description, type, SKU, options, price, compare-at price, quantity, weight and image. It opens in Excel and Google Sheets with Urdu names intact.
Are my rows saved?
They are kept in this browser, so they are still here after you refresh. Clearing your browser data removes them, so download a CSV when you finish a batch.