Export Import

Is there a way for me to create in Excell a set of product complete with images and then import them straight into my cs cart? I can see it does csv but its a mighty unfriendly format to place a product into.



Many thanx

[quote name=‘12voltshop’]Is there a way for me to create in Excell a set of product complete with images and then import them straight into my cs cart? I can see it does csv but its a mighty unfriendly format to place a product into.



Many thanx[/QUOTE]



Sort-of. My suggestion, is:


  1. Do an Export of your catalog so you have a CSV file with all the appropriate column names
  2. Open the CSV file in Excel and delete all the data
  3. Create a directory where you put all your product images
  4. Now fill in your product details (the only required field is the Product Code)
  5. Put the filename of each product image(s) into the appropriate column
  6. Save your Excel file and also export it to a CSV file
  7. On CS-Cart’s Import screen, enter the full path to where you are storing your images
  8. The select your CSV file for import and press “Import”



    A little round about, but it beats working directly in a CSV.



    -)----- B



    P.S. I’m on v1.3.5-sp3