Issue with Export for Re-import

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Ok i have another proble.

Im exporting products thru the export for reimport feature. When i use the tab option the file is a mess. When I use the comma option it is fine except when i open it in excel it gets rid of all of the zero's that are in the front of my sku numbers and upc numbers. ive tried the other feature and it doesnt work either. any suggestions. 

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
gessepi Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 17-December-2008 Location: Ohio Status: Offline Points: 0	Post Options Post Reply Quote gessepi Report Post Thanks(0) Quote Reply Topic: Issue with Export for Re-import Posted: 11-December-2009 at 11:42am
	Ok i have another proble. Im exporting products thru the export for reimport feature. When i use the tab option the file is a mess. When I use the comma option it is fine except when i open it in excel it gets rid of all of the zero's that are in the front of my sku numbers and upc numbers. ive tried the other feature and it doesnt work either. any suggestions.
	Tom

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 11-December-2009 at 11:55am
	It might be wise if you created new topics since this originally dealt with a graphic design issue. From the WIKI: http://wiki.earlyimpact.com/productcart/products_import#formatting_the_import_file If you are planning to import complex product descriptions containing HTML code, we strongly recommend that you import an Excel file and NOT a CSV file. It sounds like you need to switch from tab-delimited or comma-delimited to an XLS file.

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 11-December-2009 at 11:57am
	Also you need to do this in case you missed it: Select the SKU column by left clicking on the Column header. Select the menu item: Data > Text to Columns. The Convert Text to Columns Wizard will be displayed.

gessepi Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 17-December-2008 Location: Ohio Status: Offline Points: 0	Post Options Post Reply Quote gessepi Report Post Thanks(0) Quote Reply Posted: 11-December-2009 at 12:06pm
	I know about how to format it for import. What i need to figure out is how to export the file from the backend as an xls file.
	Tom

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 11-December-2009 at 12:49pm
	Open the .csv file in Excel and save as .XLS. Emphasis on XLS and not XLSX or other such new format.

gessepi Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 17-December-2008 Location: Ohio Status: Offline Points: 0	Post Options Post Reply Quote gessepi Report Post Thanks(0) Quote Reply Posted: 11-December-2009 at 12:52pm
	The csv file already took the zero's out of the fields so saving it as an xls doesnt accomplish anything
	Tom

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 11-December-2009 at 1:16pm
	It's probably time to open a support ticket and discuss this directly with EI.

whizzinpc Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 17-January-2006 Location: California Status: Offline Points: 20	Post Options Post Reply Quote whizzinpc Report Post Thanks(0) Quote Reply Posted: 16-December-2009 at 10:40am
	I usually make sure all my exports save as .txt files... Then open excel and browse for the file.... next it will ask you how the file is delimited and if you want to change the data format of a column.