https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 00:56:59 +0000 Tue, 25 Nov 2008 04:08:35 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=2181 https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ https://forum.productcart.com/product-export-import-issue_topic2181_post7540.html#7540 Author: Hamish
Subject: 2181
Posted: 25-November-2008 at 4:08am

The SKU's really are text even if you only have numeric ones.
Another option is to use an excel formula
=VALUE(A1)  will get the numeric value of the text number in cell A1.
If you want "pure" values after that (without the formula then copy the column with the =VALUE() formulas and "Paste Special" > Values.

   ]]> Tue, 25 Nov 2008 04:08:35 +0000 https://forum.productcart.com/product-export-import-issue_topic2181_post7540.html#7540 https://forum.productcart.com/product-export-import-issue_topic2181_post7539.html#7539 Author: ProductCart
Subject: 2181
Posted: 25-November-2008 at 3:52am

You can ignore it. It will not affect your ability to re-import the edited MS Excel file.]]> Tue, 25 Nov 2008 03:52:04 +0000 https://forum.productcart.com/product-export-import-issue_topic2181_post7539.html#7539 https://forum.productcart.com/product-export-import-issue_topic2181_post7535.html#7535 Author: ledbettergroup
Subject: 2181
Posted: 24-November-2008 at 11:55pm

without the " ' " that is.]]> Mon, 24 Nov 2008 23:55:56 +0000 https://forum.productcart.com/product-export-import-issue_topic2181_post7535.html#7535 https://forum.productcart.com/product-export-import-issue_topic2181_post7534.html#7534 Author: ledbettergroup
Subject: 2181
Posted: 24-November-2008 at 11:55pm

Is there a way that we can tell Product Cart not to export the SKU with the " ' "? It would make things so much easier.]]> Mon, 24 Nov 2008 23:55:26 +0000 https://forum.productcart.com/product-export-import-issue_topic2181_post7534.html#7534 https://forum.productcart.com/product-export-import-issue_topic2181_post7525.html#7525 Author: Hamish
Subject: 2181
Posted: 24-November-2008 at 8:30pm

Don't forget the values must be text again before the re-import!]]> Mon, 24 Nov 2008 20:30:16 +0000 https://forum.productcart.com/product-export-import-issue_topic2181_post7525.html#7525 https://forum.productcart.com/product-export-import-issue_topic2181_post7524.html#7524 Author: Hamish
Subject: 2181
Posted: 24-November-2008 at 8:29pm

Hi, Yes, use custom formatting & set it to the number of digits you wish to use. For example 000000 for a six digit number with leading zeros.  ]]> Mon, 24 Nov 2008 20:29:02 +0000 https://forum.productcart.com/product-export-import-issue_topic2181_post7524.html#7524 https://forum.productcart.com/product-export-import-issue_topic2181_post7517.html#7517 Author: ledbettergroup
Subject: 2181
Posted: 24-November-2008 at 7:48pm

I have exported my product database for the purpose of re-importing. Now, here's where it gets technical; I am exporting only the SKU, Name, Online Price, Stock and Product Cost. What I am doing is using Microsoft Access to run a query comparing this file (1) to another file (2) containing the same information to ulimately give me a file with the Product Cost and Stock on file (2). The problem is the SKU data from PC contain a " ' " before it ('000001) and when I run the query linking the two files by SKU I get nothing as the SKU from file (2) does not contain the " ' " (000001). I have used Excel to remove the " ' " but that not only remove it but it also removes the leading zeros as Excel is known to do. It does that even if the column is formatted as "text". Got any ideas?]]> Mon, 24 Nov 2008 19:48:20 +0000 https://forum.productcart.com/product-export-import-issue_topic2181_post7517.html#7517