[Skip to main content](#vessel-content) # Import Product Order Suggestion ## - **[brainforge](/forum/user/423-brainforge "View brainforge's Profile")** - [![brainforge's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar423.jpg)](/forum/user/423-brainforge "View brainforge's Profile") Topic Author - [ Offline](/forum/user/423-brainforge) Less More - Posts: 298 - Thank you received: 5 - - - - [](https://brainforge.co.uk) - 15 years 10 months ago [\#4349](#4349) by [brainforge](/forum/user/423-brainforge "View brainforge's Profile") *[Import Product Order Suggestion](/forum/2-general-talk-about-hikashop/4349-import-product-order-suggestion#4349 "Currently after import products appear in the admin screens listing with the order field set to 0. Would it be possible to set the order field to the import file line number please. I have a template where I am using the order field to determine the order products are displayed in and have entered the products in the import CSV file in the order I wish them to appear.")* was created by *[brainforge](/forum/user/423-brainforge "View brainforge's Profile")* Currently after import products appear in the admin screens listing with the order field set to 0. Would it be possible to set the order field to the import file line number please. I have a template where I am using the order field to determine the order products are displayed in and have entered the products in the import CSV file in the order I wish them to appear. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQzNDktaW1wb3J0LXByb2R1Y3Qtb3JkZXItc3VnZ2VzdGlvbj90bXBsPW1hcmtkb3du) 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: 86322 - Thank you received: 14280 - - 15 years 10 months ago [\#4353](#4353) 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 Product Order Suggestion](/forum/2-general-talk-about-hikashop/4349-import-product-order-suggestion#4353 "Currently after import products appear in the admin screens listing with the order field set to 0. Would it be possible to set the order field to the import file line number please. I have a template where I am using the order field to determine the order products are displayed in and have entered the products in the import CSV file in the order I wish them to appear.")* The products product_id column will be incremented automatically. So could could edit the module displaying our product to order them by product_id and you should have the same order as on the CSV. Also, when you save a product, all the product in the same categories will be ordered automatically.Not sure though if mysql will return the products in the order of insertion but it might do the trick. We don't do it on the import to reduce the load and enable small (or heavily restricted) servers to not fail on big imports. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQzNDktaW1wb3J0LXByb2R1Y3Qtb3JkZXItc3VnZ2VzdGlvbj90bXBsPW1hcmtkb3du) 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.053 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)