[Skip to main content](#vessel-content) # Logistics... ## - **[stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile")** - [![stephmor74's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12328-stephmor74 "View stephmor74's Profile") Topic Author - [ Offline](/forum/user/12328-stephmor74) Less More - Posts: 17 - Thank you received: 1 - - 13 years 10 months ago [\#81949](#81949) by [stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile") *[Logistics...](/forum/4-how-to/76735-logistics#81949 "Hi Guys, I have setup an import routine which works well with our clients Export .csv file.. But it's not ideal, we cannot add new data to rows just change column headings really. Basically, I used categories as: Product type -Manufacture --Manufacture shortcode Now, I have been using the shortcode from the export as the category to reference it's import to a neat structure. The pain about this is... that you have to click the shortcode after the manufacture. I see we have brands.. but to me that seems like the same issue... If I had a brand code this would work great, as the name I can update manually as it will likely never change... Any ideas?")* was created by *[stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile")* Hi Guys, I have setup an import routine which works well with our clients Export .csv file.. But it's not ideal, we cannot add new data to rows just change column headings really. Basically, I used categories as: Product type -Manufacture --Manufacture shortcode Now, I have been using the shortcode from the export as the category to reference it's import to a neat structure. The pain about this is... that you have to click the shortcode after the manufacture. I see we have brands.. but to me that seems like the same issue... If I had a brand code this would work great, as the name I can update manually as it will likely never change... Any ideas? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc2NzM1LWxvZ2lzdGljcz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile")** - [![stephmor74's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12328-stephmor74 "View stephmor74's Profile") Topic Author - [ Offline](/forum/user/12328-stephmor74) Less More - Posts: 17 - Thank you received: 1 - - 13 years 10 months ago [\#82140](#82140) by [stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile") Replied by *[stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile")* on topic *[Logistics...](/forum/4-how-to/76735-logistics#82140 "Hi Guys, I have setup an import routine which works well with our clients Export .csv file.. But it's not ideal, we cannot add new data to rows just change column headings really. Basically, I used categories as: Product type -Manufacture --Manufacture shortcode Now, I have been using the shortcode from the export as the category to reference it's import to a neat structure. The pain about this is... that you have to click the shortcode after the manufacture. I see we have brands.. but to me that seems like the same issue... If I had a brand code this would work great, as the name I can update manually as it will likely never change... Any ideas?")* bump Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc2NzM1LWxvZ2lzdGljcz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 13 years 10 months ago [\#82145](#82145) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Logistics...](/forum/4-how-to/76735-logistics#82145 "Hi Guys, I have setup an import routine which works well with our clients Export .csv file.. But it's not ideal, we cannot add new data to rows just change column headings really. Basically, I used categories as: Product type -Manufacture --Manufacture shortcode Now, I have been using the shortcode from the export as the category to reference it's import to a neat structure. The pain about this is... that you have to click the shortcode after the manufacture. I see we have brands.. but to me that seems like the same issue... If I had a brand code this would work great, as the name I can update manually as it will likely never change... Any ideas?")* Hi, "Bump" ? Sorry, I assigned this topic to Nicolas because I don't understand your request and I have ask him if he understand more than me. If you have more information which would allow me to understand, it would be great, otherwise Nicolas would answer you as soon as possible. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc2NzM1LWxvZ2lzdGljcz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile")** - [![stephmor74's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12328-stephmor74 "View stephmor74's Profile") Topic Author - [ Offline](/forum/user/12328-stephmor74) Less More - Posts: 17 - Thank you received: 1 - - 13 years 10 months ago [\#82148](#82148) by [stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile") Replied by *[stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile")* on topic *[Logistics...](/forum/4-how-to/76735-logistics#82148 "Hi Guys, I have setup an import routine which works well with our clients Export .csv file.. But it's not ideal, we cannot add new data to rows just change column headings really. Basically, I used categories as: Product type -Manufacture --Manufacture shortcode Now, I have been using the shortcode from the export as the category to reference it's import to a neat structure. The pain about this is... that you have to click the shortcode after the manufacture. I see we have brands.. but to me that seems like the same issue... If I had a brand code this would work great, as the name I can update manually as it will likely never change... Any ideas?")* Basically, I want to eliminate the showing of a 3rd level category. Right now I have: Products -Tyres --the manufacture ---the manufactures shortcode I want to elminate the showing of the shortcode category but still show all it's products. If I view a product list view this is fine and works.. But when I put a filter on for example category, it just reloads the category selection page?? Regards Tony Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc2NzM1LWxvZ2lzdGljcz90bXBsPW1hcmtkb3du) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 13 years 10 months ago [\#82156](#82156) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Logistics...](/forum/4-how-to/76735-logistics#82156 "Hi Guys, I have setup an import routine which works well with our clients Export .csv file.. But it's not ideal, we cannot add new data to rows just change column headings really. Basically, I used categories as: Product type -Manufacture --Manufacture shortcode Now, I have been using the shortcode from the export as the category to reference it's import to a neat structure. The pain about this is... that you have to click the shortcode after the manufacture. I see we have brands.. but to me that seems like the same issue... If I had a brand code this would work great, as the name I can update manually as it will likely never change... Any ideas?")* Hi, I'm not following you. Why have the shortcode categories if you don't want to use them in your category structure ? Just assign the products to the category names in your csv and voilà, no ? I also don't see the problem with the filters ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc2NzM1LWxvZ2lzdGljcz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile")** - [![stephmor74's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12328-stephmor74 "View stephmor74's Profile") Topic Author - [ Offline](/forum/user/12328-stephmor74) Less More - Posts: 17 - Thank you received: 1 - - 13 years 10 months ago [\#82202](#82202) by [stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile") Replied by *[stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile")* on topic *[Logistics...](/forum/4-how-to/76735-logistics#82202 "Hi Guys, I have setup an import routine which works well with our clients Export .csv file.. But it's not ideal, we cannot add new data to rows just change column headings really. Basically, I used categories as: Product type -Manufacture --Manufacture shortcode Now, I have been using the shortcode from the export as the category to reference it's import to a neat structure. The pain about this is... that you have to click the shortcode after the manufacture. I see we have brands.. but to me that seems like the same issue... If I had a brand code this would work great, as the name I can update manually as it will likely never change... Any ideas?")* Hello, The problem is I have 10,000 products to import, so how to I assign the products to categories? the products have shortcodes so the only way I could see to import successfully was to assign the shortcodes as categories otherwise I cannot see a way of importing it successfully? If the categories had an extra field i.e. shortcode ![;)](/media/kunena/emoticons/24.png ";)") I think I have resolved the filter issue, its now only a problem trying to allow a hierarchy search, i.e. if I search category 1, show me results from all sub categories. even if this is an if no products found search sub categories. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc2NzM1LWxvZ2lzdGljcz90bXBsPW1hcmtkb3du) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 13 years 10 months ago [\#82307](#82307) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Logistics...](/forum/4-how-to/76735-logistics#82307 "Hi Guys, I have setup an import routine which works well with our clients Export .csv file.. But it's not ideal, we cannot add new data to rows just change column headings really. Basically, I used categories as: Product type -Manufacture --Manufacture shortcode Now, I have been using the shortcode from the export as the category to reference it's import to a neat structure. The pain about this is... that you have to click the shortcode after the manufacture. I see we have brands.. but to me that seems like the same issue... If I had a brand code this would work great, as the name I can update manually as it will likely never change... Any ideas?")* Hi, You could create a custom field of the table "product" via the menu Display->Custom fields and use that custom field column name in the column of your shortcode in your CSV in order to have the information in each product. Then, you could have a custom field filter based on that field. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc2NzM1LWxvZ2lzdGljcz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile")** - [![stephmor74's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12328-stephmor74 "View stephmor74's Profile") Topic Author - [ Offline](/forum/user/12328-stephmor74) Less More - Posts: 17 - Thank you received: 1 - - 13 years 10 months ago - 13 years 10 months ago [\#82380](#82380) by [stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile") Replied by *[stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile")* on topic *[Logistics...](/forum/4-how-to/76735-logistics#82380 "Hi Guys, I have setup an import routine which works well with our clients Export .csv file.. But it's not ideal, we cannot add new data to rows just change column headings really. Basically, I used categories as: Product type -Manufacture --Manufacture shortcode Now, I have been using the shortcode from the export as the category to reference it's import to a neat structure. The pain about this is... that you have to click the shortcode after the manufacture. I see we have brands.. but to me that seems like the same issue... If I had a brand code this would work great, as the name I can update manually as it will likely never change... Any ideas?")* Edited.. Just realised we can add custom-fields to categories. Last edit: 13 years 10 months ago by [stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc2NzM1LWxvZ2lzdGljcz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile")** - [![stephmor74's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12328-stephmor74 "View stephmor74's Profile") Topic Author - [ Offline](/forum/user/12328-stephmor74) Less More - Posts: 17 - Thank you received: 1 - - 13 years 10 months ago [\#82395](#82395) by [stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile") Replied by *[stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile")* on topic *[Logistics...](/forum/4-how-to/76735-logistics#82395 "Hi Guys, I have setup an import routine which works well with our clients Export .csv file.. But it's not ideal, we cannot add new data to rows just change column headings really. Basically, I used categories as: Product type -Manufacture --Manufacture shortcode Now, I have been using the shortcode from the export as the category to reference it's import to a neat structure. The pain about this is... that you have to click the shortcode after the manufacture. I see we have brands.. but to me that seems like the same issue... If I had a brand code this would work great, as the name I can update manually as it will likely never change... Any ideas?")* Umm.. The first option you mentioned about product custom field will not work. As I need to input it into a category, for example. The export does not contain the manufacture instead it has a shortcode i.e. AV = Avon so showing shortcodes for filtering is not an option. I thought I could use the customfields on the category to import against, instead of category name, a category customfield but doesn't like possible either.. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc2NzM1LWxvZ2lzdGljcz90bXBsPW1hcmtkb3du) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 13 years 10 months ago [\#82461](#82461) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Logistics...](/forum/4-how-to/76735-logistics#82461 "Hi Guys, I have setup an import routine which works well with our clients Export .csv file.. But it's not ideal, we cannot add new data to rows just change column headings really. Basically, I used categories as: Product type -Manufacture --Manufacture shortcode Now, I have been using the shortcode from the export as the category to reference it's import to a neat structure. The pain about this is... that you have to click the shortcode after the manufacture. I see we have brands.. but to me that seems like the same issue... If I had a brand code this would work great, as the name I can update manually as it will likely never change... Any ideas?")* Then, you could use the category namekey for the import. You can't edit the category namekey in the interface, but you can change it in the hikashop_category table of the database. Then, you can use the namekey in the categories column of the CSV to identify the categories of the products. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc2NzM1LWxvZ2lzdGljcz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile")** - [![stephmor74's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12328-stephmor74 "View stephmor74's Profile") Topic Author - [ Offline](/forum/user/12328-stephmor74) Less More - Posts: 17 - Thank you received: 1 - - 13 years 10 months ago [\#82472](#82472) by [stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile") Replied by *[stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile")* on topic *[Logistics...](/forum/4-how-to/76735-logistics#82472 "Hi Guys, I have setup an import routine which works well with our clients Export .csv file.. But it's not ideal, we cannot add new data to rows just change column headings really. Basically, I used categories as: Product type -Manufacture --Manufacture shortcode Now, I have been using the shortcode from the export as the category to reference it's import to a neat structure. The pain about this is... that you have to click the shortcode after the manufacture. I see we have brands.. but to me that seems like the same issue... If I had a brand code this would work great, as the name I can update manually as it will likely never change... Any ideas?")* Hello Nicolas, That is the perfect solution thank you! It would be nice... to have a category code listed in the administration of categories and even better if you could have multiple ![;)](/media/kunena/emoticons/24.png ";)") Regards Tony The following user(s) said Thank You: [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc2NzM1LWxvZ2lzdGljcz90bXBsPW1hcmtkb3du) 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.157 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)