[Skip to main content](#vessel-content) # cvs import of secondary images / reordering images ## - **[psymedia](/forum/user/38357-psymedia "View psymedia's Profile")** - [![psymedia's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/38357-psymedia "View psymedia's Profile") Topic Author - [ Offline](/forum/user/38357-psymedia) Less More - Posts: 11 - Thank you received: 1 - - 10 years 11 months ago [\#220413](#220413) by [psymedia](/forum/user/38357-psymedia "View psymedia's Profile") *[cvs import of secondary images / reordering images](/forum/37-import-export-csv-xls/880430-cvs-import-of-secondary-images-reordering-images#220413 "Hi, quite a complex question so let me explain first what i am trying to achieve. we have 800 products on amazon i successfully imported via csv each with a primary image, now i need a bulk way of...")* was created by *[psymedia](/forum/user/38357-psymedia "View psymedia's Profile")* Hi, quite a complex question so let me explain first what i am trying to achieve. we have 800 products on amazon i successfully imported via csv each with a primary image, now i need a bulk way of adding secondary images we have a total close to 5000 images. the issue: - using a little magic from powershell, excel and sql i managed to upload all secondary images, dump filenames to csv the filenames contain product\_code so this was split out with excel giving me product code and filename. - next step with a custom sql table imported the csv with product code and filename. using group concat i was able to get the filenames into your format for 'images' ie 1.jpg\|2.jpg\|3.jpg etc and export to csv now i have my products + secondary images only they are incorrectly ordered ie main image is not the main image now. I tried both 1.jpg\|2.jpg\|3.jpg and 3.jpg\|2.jpg\|1.jpg but what ever i do over 50% of the products have the wrong images order, i see on the csv import we have the column images\_ordering but it is lacking documentation so can you please explain the syntax of this import field to enable me to do a bulk image reordering. yes i know in an individual product you can drag images into the required order but for 800 products this will be unfeasible. PS the amazon fulfillment project i was working on is 100% working on our site, when i get the time i will add an admin interface to create a plugin to allow others to have the functionality of directly exporting hikashop orders to the amazon flat file format for automated dispatch. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA0MzAtY3ZzLWltcG9ydC1vZi1zZWNvbmRhcnktaW1hZ2VzLXJlb3JkZXJpbmctaW1hZ2VzP3RtcGw9bWFya2Rvd24=) 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: 86290 - Thank you received: 14268 - - 10 years 11 months ago [\#220424](#220424) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[cvs import of secondary images / reordering images](/forum/37-import-export-csv-xls/880430-cvs-import-of-secondary-images-reordering-images#220424 "Hi, quite a complex question so let me explain first what i am trying to achieve. we have 800 products on amazon i successfully imported via csv each with a primary image, now i need a bulk way of...")* Hi, In the images_ordering column you want to write: 1|2|3 where 1 is the ordering value for the first image in the images column, 2 is the ordering value for the second one, etc. We're looking forward to that amazon fulfillment export ! The following user(s) said Thank You: [psymedia](/forum/user/38357-psymedia "View psymedia's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA0MzAtY3ZzLWltcG9ydC1vZi1zZWNvbmRhcnktaW1hZ2VzLXJlb3JkZXJpbmctaW1hZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[psymedia](/forum/user/38357-psymedia "View psymedia's Profile")** - [![psymedia's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/38357-psymedia "View psymedia's Profile") Topic Author - [ Offline](/forum/user/38357-psymedia) Less More - Posts: 11 - Thank you received: 1 - - 10 years 11 months ago [\#220497](#220497) by [psymedia](/forum/user/38357-psymedia "View psymedia's Profile") Replied by *[psymedia](/forum/user/38357-psymedia "View psymedia's Profile")* on topic *[cvs import of secondary images / reordering images](/forum/37-import-export-csv-xls/880430-cvs-import-of-secondary-images-reordering-images#220497 "Hi, quite a complex question so let me explain first what i am trying to achieve. we have 800 products on amazon i successfully imported via csv each with a primary image, now i need a bulk way of...")* Awesome - Thanks nicolas, i made the wrong presumption that ordering started from 0 small comment on csv import if i import a csv with only product_code and images field it creates secondary (child) products, it would be nice to just update current products without creating the children. The best work around i found was export products, delete images column, delete all from hikashop_files. _products. _product_categories. import csv minus the images column, import csv with images and ordering. delete all from _products, _product_categories then reimport csv with products - it work and only takes 30 seconds but would be nice to just have an update only button. Thanks again PS anyone wanting hikashop to amazon dispatch you can direct to me (for a small fee) i have a set of scripts to get it running in 10 mins there is just no admin interface yet Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA0MzAtY3ZzLWltcG9ydC1vZi1zZWNvbmRhcnktaW1hZ2VzLXJlb3JkZXJpbmctaW1hZ2VzP3RtcGw9bWFya2Rvd24=) 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.185 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)