[Skip to main content](#vessel-content) # Bulk Importing ## - **[daalouw](/forum/user/813-daalouw "View daalouw's Profile")** - [![daalouw's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/813-daalouw "View daalouw's Profile") Topic Author - [ Offline](/forum/user/813-daalouw) Less More - Posts: 12 - Thank you received: 0 - - 15 years 2 months ago [\#23420](#23420) by [daalouw](/forum/user/813-daalouw "View daalouw's Profile") *[Bulk Importing](/forum/4-how-to/23420-bulk-importing#23420 "Hi. I have Hikashop Business edition and love it but I am lacking a simpler bulk import process. I have a photography website where I specialise in school photography meaning I take 100's of pictures a week and then I need to upload them to the shopping cart. The current bulk import funtion (as I understand it) uses an excel file with all the products (photo files) preloaded on it which is used for importing. Each product line has many variants (photo sizes) meaning each photo can have 10 entries (1 for each variant). Let's say I am uploading 300 photos... this means I will haver 3,000 entires in my excel spreadheeet, each one having to have a unique name based on the photo. Obviously I do not have the time or energy to change 3,000 lines each week just to load my photos into the shopping cart. Is there an easier way to imoprt hundreds of products (with several variants each) into Hikashop? Something like importing files out of a specified folder? Keep up the good work Nicolas. Regards daalouw")* was created by *[daalouw](/forum/user/813-daalouw "View daalouw's Profile")* Hi. I have Hikashop Business edition and love it but I am lacking a simpler bulk import process. I have a photography website where I specialise in school photography meaning I take 100's of pictures a week and then I need to upload them to the shopping cart. The current bulk import funtion (as I understand it) uses an excel file with all the products (photo files) preloaded on it which is used for importing. Each product line has many variants (photo sizes) meaning each photo can have 10 entries (1 for each variant). Let's say I am uploading 300 photos... this means I will haver 3,000 entires in my excel spreadheeet, each one having to have a unique name based on the photo. Obviously I do not have the time or energy to change 3,000 lines each week just to load my photos into the shopping cart. Is there an easier way to imoprt hundreds of products (with several variants each) into Hikashop? Something like importing files out of a specified folder? Keep up the good work Nicolas. Regards daalouw Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzIzNDIwLWJ1bGstaW1wb3J0aW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 15 years 2 months ago [\#23430](#23430) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Bulk Importing](/forum/4-how-to/23420-bulk-importing#23430 "Hi. I have Hikashop Business edition and love it but I am lacking a simpler bulk import process. I have a photography website where I specialise in school photography meaning I take 100's of pictures a week and then I need to upload them to the shopping cart. The current bulk import funtion (as I understand it) uses an excel file with all the products (photo files) preloaded on it which is used for importing. Each product line has many variants (photo sizes) meaning each photo can have 10 entries (1 for each variant). Let's say I am uploading 300 photos... this means I will haver 3,000 entires in my excel spreadheeet, each one having to have a unique name based on the photo. Obviously I do not have the time or energy to change 3,000 lines each week just to load my photos into the shopping cart. Is there an easier way to imoprt hundreds of products (with several variants each) into Hikashop? Something like importing files out of a specified folder? Keep up the good work Nicolas. Regards daalouw")* Hi, That is already possible with the Business edition. On the import screen, you have an "import from folder" option which allows you to load all the files of a folder as products with the files attached as either images or files which the information of the products copied from a template product that you can select on the import screen before the import. More info here: [ www.hikashop.com/support/documentation/7...import.html#generate](http://www.hikashop.com/support/documentation/73-hikashop-import.html#generate) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzIzNDIwLWJ1bGstaW1wb3J0aW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[daalouw](/forum/user/813-daalouw "View daalouw's Profile")** - [![daalouw's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/813-daalouw "View daalouw's Profile") Topic Author - [ Offline](/forum/user/813-daalouw) Less More - Posts: 12 - Thank you received: 0 - - 15 years 2 months ago [\#23516](#23516) by [daalouw](/forum/user/813-daalouw "View daalouw's Profile") Replied by *[daalouw](/forum/user/813-daalouw "View daalouw's Profile")* on topic *[Re: Bulk Importing](/forum/4-how-to/23420-bulk-importing#23516 "Hi. I have Hikashop Business edition and love it but I am lacking a simpler bulk import process. I have a photography website where I specialise in school photography meaning I take 100's of pictures a week and then I need to upload them to the shopping cart. The current bulk import funtion (as I understand it) uses an excel file with all the products (photo files) preloaded on it which is used for importing. Each product line has many variants (photo sizes) meaning each photo can have 10 entries (1 for each variant). Let's say I am uploading 300 photos... this means I will haver 3,000 entires in my excel spreadheeet, each one having to have a unique name based on the photo. Obviously I do not have the time or energy to change 3,000 lines each week just to load my photos into the shopping cart. Is there an easier way to imoprt hundreds of products (with several variants each) into Hikashop? Something like importing files out of a specified folder? Keep up the good work Nicolas. Regards daalouw")* Thanks for yoru respopnse Nicolas. I believe this is what I've tried to use already but I still needed to use an excel spreadsheet with 3,000 lines of products and variants to associate with the images in the image folder I was importing. Are you stating the Hikashop has been updated so that I do not need to use that excel spreadsheet as a part of importing 100's of images at a time? daalouw Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzIzNDIwLWJ1bGstaW1wb3J0aW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[daalouw](/forum/user/813-daalouw "View daalouw's Profile")** - [![daalouw's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/813-daalouw "View daalouw's Profile") Topic Author - [ Offline](/forum/user/813-daalouw) Less More - Posts: 12 - Thank you received: 0 - - 15 years 2 months ago [\#23518](#23518) by [daalouw](/forum/user/813-daalouw "View daalouw's Profile") Replied by *[daalouw](/forum/user/813-daalouw "View daalouw's Profile")* on topic *[Re: Bulk Importing](/forum/4-how-to/23420-bulk-importing#23518 "Hi. I have Hikashop Business edition and love it but I am lacking a simpler bulk import process. I have a photography website where I specialise in school photography meaning I take 100's of pictures a week and then I need to upload them to the shopping cart. The current bulk import funtion (as I understand it) uses an excel file with all the products (photo files) preloaded on it which is used for importing. Each product line has many variants (photo sizes) meaning each photo can have 10 entries (1 for each variant). Let's say I am uploading 300 photos... this means I will haver 3,000 entires in my excel spreadheeet, each one having to have a unique name based on the photo. Obviously I do not have the time or energy to change 3,000 lines each week just to load my photos into the shopping cart. Is there an easier way to imoprt hundreds of products (with several variants each) into Hikashop? Something like importing files out of a specified folder? Keep up the good work Nicolas. Regards daalouw")* Attached is an excerpt of my excel spreadhseet for only 2 products (and I have 100's at a time): #### *This attachment is hidden for guests. Please log in or register to see it.* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzIzNDIwLWJ1bGstaW1wb3J0aW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 15 years 2 months ago [\#23527](#23527) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Bulk Importing](/forum/4-how-to/23420-bulk-importing#23527 "Hi. I have Hikashop Business edition and love it but I am lacking a simpler bulk import process. I have a photography website where I specialise in school photography meaning I take 100's of pictures a week and then I need to upload them to the shopping cart. The current bulk import funtion (as I understand it) uses an excel file with all the products (photo files) preloaded on it which is used for importing. Each product line has many variants (photo sizes) meaning each photo can have 10 entries (1 for each variant). Let's say I am uploading 300 photos... this means I will haver 3,000 entires in my excel spreadheeet, each one having to have a unique name based on the photo. Obviously I do not have the time or energy to change 3,000 lines each week just to load my photos into the shopping cart. Is there an easier way to imoprt hundreds of products (with several variants each) into Hikashop? Something like importing files out of a specified folder? Keep up the good work Nicolas. Regards daalouw")* Yes. You don't need the spreadsheet. You need to use the "import from folder" option of the import and not the "import from CSV". Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzIzNDIwLWJ1bGstaW1wb3J0aW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.123 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)