me100finn Posted January 20, 2012 Share Posted January 20, 2012 When you import into the database, does it merge, overwrite, or add to the catalog? What are the required fields to have in order to import? Link to comment Share on other sites More sharing options...
Guest Posted January 20, 2012 Share Posted January 20, 2012 It will create a new product when you import unless you include the ID field I would highly recommend taking backups while you practice getting the import how you want it Link to comment Share on other sites More sharing options...
me100finn Posted January 20, 2012 Author Share Posted January 20, 2012 Yes, of course - backup! Thank you! So if I have the ID I can only export and re-import those products that I want to update, correct? Also, is there a way to assign attributes to products with imports? Link to comment Share on other sites More sharing options...
Guest Posted January 21, 2012 Share Posted January 21, 2012 Yes, of course - backup! Thank you! So if I have the ID I can only export and re-import those products that I want to update, correct? Also, is there a way to assign attributes to products with imports? When you import the file, if the column for ID contains a number that matches with Presta it will update the existing product, if the IF field is blank, or does not math then a new product will be created You will find export different though - you can't do it without a 3rd party plug in. It is not standard I do this regularly I have an external database, I change prices, categories and stock levels locally, then export a csv file from the database and upload to presta. It works really well I don;t think you can do attributes though. But that should not matter. If you add them manually, then when you update the product via csv it will only update the relevant parts included in the CSV file Link to comment Share on other sites More sharing options...
me100finn Posted January 21, 2012 Author Share Posted January 21, 2012 Thank you for the feedback and details! Can you recommend an export add-on that you find functional? Link to comment Share on other sites More sharing options...
badboyrc Posted January 22, 2012 Share Posted January 22, 2012 After editing my .csv file nearly 25 times I still can't get it to load......I'm about to unload this prestashop..Can someone please tell me what is wrong....I can email file or whatever might help Thanks Link to comment Share on other sites More sharing options...
Guest Posted January 22, 2012 Share Posted January 22, 2012 @badboyrc : can you give some clue as to what is going wrong? Are you getting error messages?Have you looked at the format of the sample file? Can you post the csv file so we can have a look? Link to comment Share on other sites More sharing options...
badboyrc Posted January 22, 2012 Share Posted January 22, 2012 I downloaded the sample file and copied it to the t, I downloaded a new office suite and tried that. Not sure how I can post it but I will try. I keep getting over 5000 errors about things don't exist, it loads in the window where you check the proper fields fine but when you press upload it all goes wrong. When its in the wrong format it loads all funny. How am I to post it here it won't Link to comment Share on other sites More sharing options...
Guest Posted January 22, 2012 Share Posted January 22, 2012 In the reply box at the bottom right hand side, click More reply options, you can then add an attachment A couple of things to check Are you making sure you save the CSV file either as a ";" or "," then on the upload screen make sure it matches. Also When you have uploaded the file, make sure you change the drop down menu option to products (categories is the default) Link to comment Share on other sites More sharing options...
badboyrc Posted January 22, 2012 Share Posted January 22, 2012 Thanks for the replies and help and I have done all this over and over again....I get this trying to upload here. RedCat2prod..csv This upload failed RedCat2prod.csv Upload Skipped (Error IO) Link to comment Share on other sites More sharing options...
Guest Posted January 22, 2012 Share Posted January 22, 2012 OK, try emailing it direct to haylau @ gmail . com Did you look at those two suggestions I made? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now