[Skip to main content](#vessel-content) # Import brands ? ## - **[cosg2004](/forum/user/9738-cosg2004 "View cosg2004's Profile")** - [![cosg2004's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9738-cosg2004 "View cosg2004's Profile") Topic Author - [ Offline](/forum/user/9738-cosg2004) Less More - Posts: 6 - Thank you received: 0 - - 14 years 1 month ago [\#67986](#67986) by [cosg2004](/forum/user/9738-cosg2004 "View cosg2004's Profile") *[Import brands ?](/forum/4-how-to/67986-import-brands#67986 "I am trying to import brand names directly in mysql as create them manually into the back panel is too much of a time consuming process. Is it any way that I can import csv (manufacturing_id, "brand name") doirectly in mysql. I guess my question also relates to where is the brand name stored in the database?. What tables are involved? Is it a back panel alternative through import csv? Thanks.")* was created by *[cosg2004](/forum/user/9738-cosg2004 "View cosg2004's Profile")* I am trying to import brand names directly in mysql as create them manually into the back panel is too much of a time consuming process. Is it any way that I can import csv (manufacturing_id, "brand name") doirectly in mysql. I guess my question also relates to where is the brand name stored in the database?. What tables are involved? Is it a back panel alternative through import csv? Thanks. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY3OTg2LWltcG9ydC1icmFuZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14276 - - 14 years 4 weeks ago [\#68144](#68144) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Import brands ?](/forum/4-how-to/67986-import-brands#68144 "I am trying to import brand names directly in mysql as create them manually into the back panel is too much of a time consuming process. Is it any way that I can import csv (manufacturing_id, "brand name") doirectly in mysql. I guess my question also relates to where is the brand name stored in the database?. What tables are involved? Is it a back panel alternative through import csv? Thanks.")* Hi, In the column "product_manufacturer_id" of your product import CSV, you can enter directly the name of your brands. The following user(s) said Thank You: [cosg2004](/forum/user/9738-cosg2004 "View cosg2004's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY3OTg2LWltcG9ydC1icmFuZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[IamJim](/forum/user/5406-iamjim "View IamJim's Profile")** - [![IamJim's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2012-12-17-3.jpg)](/forum/user/5406-iamjim "View IamJim's Profile") - [ Offline](/forum/user/5406-iamjim) Less More - Posts: 135 - Thank you received: 5 - - 13 years 11 months ago - 13 years 11 months ago [\#73810](#73810) by [IamJim](/forum/user/5406-iamjim "View IamJim's Profile") Replied by *[IamJim](/forum/user/5406-iamjim "View IamJim's Profile")* on topic *[Re: Import brands ?](/forum/4-how-to/67986-import-brands#73810 "I am trying to import brand names directly in mysql as create them manually into the back panel is too much of a time consuming process. Is it any way that I can import csv (manufacturing_id, "brand name") doirectly in mysql. I guess my question also relates to where is the brand name stored in the database?. What tables are involved? Is it a back panel alternative through import csv? Thanks.")* > nicolas wrote: Hi, > > In the column "product\_manufacturer\_id" of your product import CSV, you can enter directly the name of your brands. Hello Nicolas, and I right now am posing this question also...and as I mentioned I am having to start from "scratch" as the above user has not been back here since: Last Visit Date: 09 Oct 2012 1) I have created (1) test product for now, in order to EXPORT the CSV 2) The column you mention is "P" in the CSV. 3) This is not what the poster needed, nor neither do I.. What is needed? Is to Populate MySQL with Brands first, so that when New Products are entered, it is already there for Drop Down Selection. For example, I have a CSV with 90 Brands separated by " , " that I want to pre-populate. So I do not have to create them one by one. Once they are in? It will be FAST to Click Edit on Existing brand and Insert Picture.. Jim ADDED > OK, I added (1) Brand to see where in MySQL it showed up in relationship to HikaShop tables.. 1 match inside table rfuhn_hikashop_category and I also see it adds many other things needed? That is what his and my question is to do. category_id category_parent_id category_type category_name category_description category_published category_ordering category_left category_right category_depth category_namekey category_created category_modified category_access category_menu category_keywords category_meta_description category_layout category_page_title Last edit: 13 years 11 months ago by [IamJim](/forum/user/5406-iamjim "View IamJim's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY3OTg2LWltcG9ydC1icmFuZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14276 - - 13 years 11 months ago [\#74069](#74069) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Import brands ?](/forum/4-how-to/67986-import-brands#74069 "I am trying to import brand names directly in mysql as create them manually into the back panel is too much of a time consuming process. Is it any way that I can import csv (manufacturing_id, "brand name") doirectly in mysql. I guess my question also relates to where is the brand name stored in the database?. What tables are involved? Is it a back panel alternative through import csv? Thanks.")* The import system is for products data import. If you specify the name of a manufacturer in the product_manufacturer_id, the system will create a manufacturer if it doesn't exist and link it to the product automatically. The other information like description, image, etc cannot be added via the import. You need to do it via the interface. You can't import manufacturer in the category table. That would break the left and right values in the table. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY3OTg2LWltcG9ydC1icmFuZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[IamJim](/forum/user/5406-iamjim "View IamJim's Profile")** - [![IamJim's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2012-12-17-3.jpg)](/forum/user/5406-iamjim "View IamJim's Profile") - [ Offline](/forum/user/5406-iamjim) Less More - Posts: 135 - Thank you received: 5 - - 13 years 11 months ago [\#74072](#74072) by [IamJim](/forum/user/5406-iamjim "View IamJim's Profile") Replied by *[IamJim](/forum/user/5406-iamjim "View IamJim's Profile")* on topic *[Re: Import brands ?](/forum/4-how-to/67986-import-brands#74072 "I am trying to import brand names directly in mysql as create them manually into the back panel is too much of a time consuming process. Is it any way that I can import csv (manufacturing_id, "brand name") doirectly in mysql. I guess my question also relates to where is the brand name stored in the database?. What tables are involved? Is it a back panel alternative through import csv? Thanks.")* Hello and thank you for the reply.. re: That would break the left and right values in the table. Yes, I figured that much Nicolas... So, what you are telling me is that I can not "pre-populate" the BRANDS before hand?... So they 'exist' for then 'adding a product' And that each must be already in the master export-import template of yours? Again, thank you for the reply. Jim Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY3OTg2LWltcG9ydC1icmFuZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14276 - - 13 years 11 months ago [\#74075](#74075) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Import brands ?](/forum/4-how-to/67986-import-brands#74075 "I am trying to import brand names directly in mysql as create them manually into the back panel is too much of a time consuming process. Is it any way that I can import csv (manufacturing_id, "brand name") doirectly in mysql. I guess my question also relates to where is the brand name stored in the database?. What tables are involved? Is it a back panel alternative through import csv? Thanks.")* You can populate them. Just enter them via the menu Products->Brands. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY3OTg2LWltcG9ydC1icmFuZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[IamJim](/forum/user/5406-iamjim "View IamJim's Profile")** - [![IamJim's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2012-12-17-3.jpg)](/forum/user/5406-iamjim "View IamJim's Profile") - [ Offline](/forum/user/5406-iamjim) Less More - Posts: 135 - Thank you received: 5 - - 13 years 11 months ago [\#74077](#74077) by [IamJim](/forum/user/5406-iamjim "View IamJim's Profile") Replied by *[IamJim](/forum/user/5406-iamjim "View IamJim's Profile")* on topic *[Re: Import brands ?](/forum/4-how-to/67986-import-brands#74077 "I am trying to import brand names directly in mysql as create them manually into the back panel is too much of a time consuming process. Is it any way that I can import csv (manufacturing_id, "brand name") doirectly in mysql. I guess my question also relates to where is the brand name stored in the database?. What tables are involved? Is it a back panel alternative through import csv? Thanks.")* Do you mean "one at a time"? Yes, I know that...that is how I did it before. I have over 90 of them. Problem is? That cart and database/server/vps the company shut down and I lost it all..with over 100 products and pictures/descriptions entered. And I have to make a new cart. Even at 2 minutes each, w/out pictures that is 180 minutes.. = 3 hours of typing.. Importing, would be so much easier..<sigh> Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY3OTg2LWltcG9ydC1icmFuZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14276 - - 13 years 11 months ago [\#74079](#74079) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Import brands ?](/forum/4-how-to/67986-import-brands#74079 "I am trying to import brand names directly in mysql as create them manually into the back panel is too much of a time consuming process. Is it any way that I can import csv (manufacturing_id, "brand name") doirectly in mysql. I guess my question also relates to where is the brand name stored in the database?. What tables are involved? Is it a back panel alternative through import csv? Thanks.")* Sure but I can't help you with something which doesn't exist ![:/](/irritated.gif ":/") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY3OTg2LWltcG9ydC1icmFuZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) 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.106 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)