ProductCart Shopping Cart Software Forums : Issue with Export for Re-import

ProductCart Shopping Cart Software Forums : Issue with Export for Re-import https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 17:25:47 +0000 Wed, 16 Dec 2009 10:40:23 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=3279 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Issue with Export for Re-import : I usually make sure all my exports...]]> https://forum.productcart.com/issue-with-export-for-reimport_topic3279_post12375.html#12375 Author: whizzinpc
Subject: 3279
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.]]> Wed, 16 Dec 2009 10:40:23 +0000 https://forum.productcart.com/issue-with-export-for-reimport_topic3279_post12375.html#12375 <![CDATA[Issue with Export for Re-import : It's probably time to open...]]> https://forum.productcart.com/issue-with-export-for-reimport_topic3279_post12308.html#12308 Author: Greg Dinger
Subject: 3279
Posted: 11-December-2009 at 1:16pm

It's probably time to open a support ticket and discuss this directly with EI.]]> Fri, 11 Dec 2009 13:16:00 +0000 https://forum.productcart.com/issue-with-export-for-reimport_topic3279_post12308.html#12308 <![CDATA[Issue with Export for Re-import : The csv file already took the...]]> https://forum.productcart.com/issue-with-export-for-reimport_topic3279_post12306.html#12306 Author: gessepi
Subject: 3279
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]]> Fri, 11 Dec 2009 12:52:00 +0000 https://forum.productcart.com/issue-with-export-for-reimport_topic3279_post12306.html#12306 <![CDATA[Issue with Export for Re-import : Openthe .csv filein Excel and...]]> https://forum.productcart.com/issue-with-export-for-reimport_topic3279_post12305.html#12305 Author: Greg Dinger
Subject: 3279
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.]]> Fri, 11 Dec 2009 12:49:21 +0000 https://forum.productcart.com/issue-with-export-for-reimport_topic3279_post12305.html#12305 <![CDATA[Issue with Export for Re-import : I know about how to format it...]]> https://forum.productcart.com/issue-with-export-for-reimport_topic3279_post12304.html#12304 Author: gessepi
Subject: 3279
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. ]]> Fri, 11 Dec 2009 12:06:14 +0000 https://forum.productcart.com/issue-with-export-for-reimport_topic3279_post12304.html#12304 <![CDATA[Issue with Export for Re-import : Also you need to do this in case...]]> https://forum.productcart.com/issue-with-export-for-reimport_topic3279_post12303.html#12303 Author: Greg Dinger
Subject: 3279
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.

]]> Fri, 11 Dec 2009 11:57:14 +0000 https://forum.productcart.com/issue-with-export-for-reimport_topic3279_post12303.html#12303 <![CDATA[Issue with Export for Re-import : It might be wise if you created...]]> https://forum.productcart.com/issue-with-export-for-reimport_topic3279_post12302.html#12302 Author: Greg Dinger
Subject: 3279
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.

]]> Fri, 11 Dec 2009 11:55:52 +0000 https://forum.productcart.com/issue-with-export-for-reimport_topic3279_post12302.html#12302 <![CDATA[Issue with Export for Re-import : Ok i have another proble. Im...]]> https://forum.productcart.com/issue-with-export-for-reimport_topic3279_post12301.html#12301 Author: gessepi
Subject: 3279
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.

]]> Fri, 11 Dec 2009 11:42:51 +0000 https://forum.productcart.com/issue-with-export-for-reimport_topic3279_post12301.html#12301