cvs import of secondary images / reordering images

  • Posts: 11
  • Thank you received: 1
9 years 1 week ago #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 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 or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 1 week ago #220424

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

Please Log in or Create an account to join the conversation.

  • Posts: 11
  • Thank you received: 1
9 years 1 week ago #220497

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 or Create an account to join the conversation.

Time to create page: 0.057 seconds
Powered by Kunena Forum