Interspire Products Import Tips
  • acomptonacompton
     
    October 2011

    Just a few things I've learnt doing some product importing.


    - You don't need double-quotes around every field, just the ones that have the separator character (e.g. comma) in them.
    - If you really want a double-quote in the text, use two of them ("")
    - If you screw up the import (fields are out of line), don't try to re-import to fix it, as some values won't be overwritten by the new import. It's best to delete the product(s) and re-import.
    - If you have multiple images to associate with a product, just repeat the import for each image with the image filename changed each time. Tick 'replace matching products' but don't tick 'delete existing images'.


     
    Awarded Goat Points by 1Gabriel Crowe
  • Gabriel CroweGabriel Crowe
     
    October 2011
    I can add to this:

    if your shop has over a 1000 products, try to import only 100 to see if it works, trim your csv

    if you are doing multiple test imports to get an awkward feed in *deliberately* set the image field to 'ignore'. it will import much faster if it does not have to pull images across the web.

    Import the largest image you can. They will be resized later. Dont worry about image sizes, try to make it 800 x 800 or larger. Thumbs will be generated, dont worry.

    If your categories fail to import correctly and everything is all over the place, strip all the punctuation out of the feed and try again. If your original shop has a category with slashes in it for example, it will break the category importer.

    A quick way to pre-delete all the products is to go to the categories menu and select all, then select delete. It will ask you to delete all products too. Say yes. Tabula rasa.
     
    Awarded Goat Points by 1acompton
Add a Comment