HomeНаука и техникаRelated VideosMore From: Indzara

Create your own Small Business Product Catalog - Free Excel Template - Tour

122 ratings | 47563 views
Use this Free Excel template to create product catalog for your small business. Just enter your own products in the pre-built template. Download: https://indzara.com/2016/07/small-business-product-catalog-excel/ Features Included: Filter products by Categories Search products by keywords (on Product Name) Sort products by Price (Ascending or Descending) Scroll to see products in sets of 8 Add thumbnail images to appear on Catalog Add links to website as needed on product detail sheets Catalog links to individual product detail sheets Format the catalog as needed with usual Excel formatting options Customize product detail pages as needed Simple and Effective Excel Templates: http://indzara.com/ Free Excel Templates: http://indzara.com/free-excel-templates/ Premium Excel Templates: http://indzara.com/shop/ Small Business Management Templates: http://indzara.com/small-business-excel-templates/ Project Management Templates: http://indzara.com/project-management-excel-templates/ HR Templates: http://indzara.com/hr-excel-templates/ Free Excel Course: http://indzara.com/useful-excel-for-beginners/ Social: Subscribe to YouTube: http://www.youtube.com/user/theindzara?sub_confirmation=1 Facebook: https://www.facebook.com/theindzara YouTube: https://www.youtube.com/user/theindzara LinkedIn: https://www.linkedin.com/company/indzara Twitter: https://www.youtube.com/user/theindzara
Html code for embedding videos on your blog
Text Comments (61)
Octavian Ciati (22 days ago)
really usefull, thank you
Indzara (21 days ago)
You are welcome. Best wishes.
svinsky21 (1 month ago)
Hi thanks for the template, just wanna know if it's possible to show more than 8 products in one page on the product_catalog tab and why is it not refreshing properly when I click next page (calculation's on automatic) Thanks in advance
Indzara (1 month ago)
Please email file to [email protected] Best wishes.
svinsky21 (1 month ago)
when i said not refreshing it's mainly the thumbnails not refreshing when flipping through pages
Viney Grover (1 month ago)
Hello sir I am trying to change picture but when I go back to the product catalog. The page is showing blank. No picture showing.Please help
Indzara (1 month ago)
Thank you. Please email [email protected] the file with specific questions. Please specify Excel version and Operating system. Best wishes.
First off, Thank you so much for taking the time to create these free templates for small business, you will never know how much time and money you are saving us all!! I was wondering though if maybe you could tell me how to create sub categories?
Indzara (3 months ago)
Thank you for the feedback. Please review 'Category' and create a similar column for Sub Categories. It involves many steps though. Thanks & Best wishes.
aidan bradley (4 months ago)
Hi, thanks for the video and template, I'd like to add more products than 30 - please send me the link to the video that explains who to do this, thanks
*Copied from a previous question/reply* Hi this is awesome, how can I expand the number of products in the catalog? I have more than 200 different products in my store. I Indzara Indzara 1 year ago Thank you. Steps to add 31st product. 1. Add a row to table in Input_Data sheet. Change row height to 120. 2. Name the thumbnail image cell as P_31. 3. Add a row to table in C sheet. Make sure the column A has number 31. 4. Create a new sheet with the same name as Product Name. We have to repeat these steps for as many products as needed. It is not ideal to do manually for 200+ products, but it works. Best wishes.
Varsha Nautiyal (6 months ago)
Very nice sir actually our company is scientific and laboratory equipments manufacturing co.we have atleats 200 products how can i putting all and also i wantet to knw that i want to make page by my company name so can consumer can contacts us easly .
Indzara (6 months ago)
Thanks. The number of products is limited by default. You can edit the sheet to add more products. Brief overview of steps to expand: Enter the additional products in hidden Input data sheet Increase the row height to 120 to make sure that the image can be visible. Name the thumbnail image cell as P_31 for 31st product, P_32 for 32nd product,… Enter additional categories in hidden Input data sheet In the hidden sheet C, insert row in row 10 to make room for more product categories. Add checkboxes in Product Catalog sheet for the additional categories. Link the checkboxes to the column B in hidden C sheet. Extend the products calculation table in hidden C sheet Best wishes.
Vikram Sangtani (8 months ago)
i have garments shop do u any templet for it
Indzara (7 months ago)
For managing inventory in a retail business, please see https://www.youtube.com/watch?v=YtafYRqZP9g Best wishes.
The Truth (8 months ago)
This is great where can I donate to you?
Indzara (8 months ago)
Thank you. If you can spread the word about the site, that would be great. Also, there is a shop https://indzara.com/shop/ where you can purchase templates if they are useful to you. Best wishes.
Sales Kaltimber (8 months ago)
how can I extend the limit of thumbnail images?
Indzara (7 months ago)
It is a slightly complex process. Enter the additional products in hidden Input data sheet Increase the row height to 120 to make sure that the image can be visible. Name the thumbnail image cell as P_31 for 31st product, P_32 for 32nd product,… Enter additional categories in hidden Input data sheet In the hidden sheet C, insert row in row 10 to make room for more product categories. Add checkboxes in Product Catalog sheet for the additional categories. Link the checkboxes to the column B in hidden C sheet. Extend the products calculation table in hidden C sheet The above should help expand the products and categories. Best wishes.
Imran Ashraf (8 months ago)
please also share the videos how to make of your all free templates. just for learning.Many Thanks
Imran Ashraf (8 months ago)
Many Thanks.
Indzara (8 months ago)
Thank you. I will plan to create such videos in the future. Best wishes.
Mike Branderhorst (10 months ago)
Great template!!! I’m in the process of modifying this template to suit my company’s needs and am adding products. The concern I have is the quantity of sheets that are required. Is there a way to hide the product sheet once the back to product catalog hyperlink is chosen? Thank you in advance.
Indzara (10 months ago)
Thank you. I am sure that is possible with some macros. I have not done it myself, but if you google you could find some simple code that hides sheets. Best wishes.
Karen Norskow (10 months ago)
i am trying to customize this template. I changed the pictures and information in the cells. When I go back to the product catalog....there is nothing there. I am not sure what I did wrong. Can you help?
Indzara (7 months ago)
Can you please clarify what is not working? Please email file to [email protected] and specify what data has been entered and any other changes made. Thanks & Best wishes.
heraldfashion (7 months ago)
its not working
Indzara (10 months ago)
Please email me the file at [email protected] I will review and get back to you. Best wishes.
Flying Machines (10 months ago)
"THE KING" only word For the guy. Sir keep doing the outstanding work. We are always here to support you.
Indzara (10 months ago)
Thanks for the kind words. I will continue to do my best. Thanks & Best wishes.
gabigrtv (1 year ago)
Hi, thank you this is just what I need. My problem is that if I change the number format to a different currency with 2 decimal places this does not transfer to the product catalog. the catalog stays with no decimal and still in $. What shall I do?
Indzara (1 year ago)
Thanks for letting me know. Best wishes.
gabigrtv (1 year ago)
hi again ... ignore question I just solved it :)
Adrienne Doctor (1 year ago)
Can you do a video on how to add more rows and creating new sheets that correspond if you click the "view" button? Great template! Thank you!
Indzara (1 year ago)
Thanks for feedback. Will definitely post when I get a chance to work on this. Best wishes.
Mitchel Jennings (1 year ago)
Hi first off Wonderful, great job.I was wondering if there was a way to only show the interactive catalog and no the other spread sheets
Indzara (1 year ago)
Thank you. You can hide the other sheets - Right click on sheet name and choose Hide. Best wishes.
Kashif Ghafoor (1 year ago)
very helpful, thanks
Indzara (1 year ago)
You are welcome. Best wishes.
KLB7113 (1 year ago)
Thank you for this great template! Is it possible to remove the $ and replace with difference currency symbol? Thank you!!!!
Indzara (1 year ago)
You are welcome. Yes, please click on the cell and change number format (ctrl+1). Best wishes.
Jas Coasttocoast (1 year ago)
AWESOME!!!!!!!!!!!!!!!!!!
Indzara (1 year ago)
Thank you. Best wishes.
nima khodadadi (1 year ago)
hi first of all thanks for your template its amazing i have two question first is it possible to convert this template to PDF format and still able to use links and searches second most of my costumer using smart phones to view my price list when i use ur template every thing looks fine on a computer but when send it to smart phone every thing get messed up and no search scrolling ability i was wondering is there an way to over come this issue thanks
Indzara (1 year ago)
Thank you. The template cannot be converted to PDF with all its features. Also, it is not designed for smart phone use. Sorry. Best wishes.
shanmukh sagar (1 year ago)
Wonderful, Just what I was looking for. Thanks a lot for your contribution. Would love to learn things from you. Can you please help me in expanding the list?
Indzara (1 year ago)
Thanks for the feedback. I don't have the documentation on how to expand this template yet. Sorry. Best wishes.
Unique Fall (1 year ago)
Thanks for your great contribution. That will be highly appreciated if could further help me on the followings: how could be able to add 100 + items at a time to your Excel Templet? After half term school holiday, I need to do this task for my class test. Most welcome you to send me an attachment to my e-mail. Finally, Thanks and appreciated for your prompt attention to the matter and please respond to the query to the earliest possible.
Indzara (1 year ago)
you are welcome. Steps Enter the additional products in hidden Input data sheet Increase the row height to 120 to make sure that the image can be visible. Name the thumbnail image cell as P_31 for 31st product, P_32 for 32nd product,… Enter additional categories in hidden Input data sheet In the hidden sheet C, insert row in row 10 to make room for more product categories. Add checkboxes in Product Catalog sheet for the additional categories. Link the checkboxes to the column B in hidden C sheet. Extend the products calculation table in hidden C sheet I believe the above should help expand the products and categories. Best wishes
Rafael Ramírez (1 year ago)
Hi this is awesome, how can I expand the number of products in the catalog? I have more than 200 different products in my store.
Indzara (1 year ago)
Thank you. Steps to add 31st product. 1. Add a row to table in Input_Data sheet. Change row height to 120. 2. Name the thumbnail image cell as P_31. 3. Add a row to table in C sheet. Make sure the column A has number 31.  4. Create a new sheet with the same name as Product Name. We have to repeat these steps for as many products as needed. It is not ideal to do manually for 200+ products, but it works.  Best wishes.
Mohammad Sharfuddin (1 year ago)
I would like to know that how you kept all products in to the first page as we click any product image in first page how it is showing details and all
Indzara (1 year ago)
It's hard to explain in just text here. Everything is a lookup using a formula. The hidden sheet has all the calculations. Based on user filters and selections in the catalog, the calculations provide the product list in the order and they get displayed. The hyperlinks are dynamic based on product name and sheet name. That's why they take us to the appropriate product page when clicked. Please see the calculations and it will be easier to follow. Best wishes.
Kim Rebernig (1 year ago)
This is really excellent, thank you. I have two requirements that don't quite fit however: 1) can I add a unit value to the price ("per handling unit" etc) so that the search functionality still works 2) can I add a default sort so that it reverts to the order I have entered the products in the input sheet? This catalogue is unfortunately not effective if I am sorting by price Thank you for any assistance you can give me.
Indzara (1 year ago)
You are welcome. I think you could add the unit as a separate field and then bring it up on the catalog via separate formula. This would ensure that the search functionality is not impacted. Or you can try custom formatting and add the unit as suffix. Best wishes.
Kim Rebernig (1 year ago)
Thanks for your quick reply! To point 1): What I would like to do it be able to put a unit following the price, such as  € 0,10/SKU or € 0,10 per SKU. This seems to breakt the sheet howeverTo point 2): I have solved the problem by adding a dropdown to the search field - with this the pricing filter isn't such a problem.
Indzara (1 year ago)
Thanks for the feedback. 1) In the Input_Data sheet, we can enter the price for each product. The search functionality is only on the product names. 2) Providing original sort order would require modifying the data validation of the drop down, and the calcualtions in the hidden C sheet (cells B15, B16, and I40). Please clarify why the catalog is not effective if sorted by price. Best wishes.
Christopher Sweeten (1 year ago)
how do I get rid of or add filter categories?
Indzara (1 year ago)
The filter categories are listed in the hidden Input_Data sheet. The checkboxes can be clicked and deleted in the Product_catalog sheet. To add, we have to copy the checkbox and then point that new checkbox to the newly added category in the hidden Input_Data sheet. best wishes.
Arun Jaipur (2 years ago)
are u a excel genius!!!
Indzara (2 years ago)
Thank you. I am still learning with every template I publish. Best wishes.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.