Product Export/Import Issue

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

   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?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
ledbettergroup Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 24-November-2008 Status: Offline Points: 0	Post Options Post Reply Quote ledbettergroup Report Post Thanks(0) Quote Reply Topic: Product Export/Import Issue 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?

Hamish Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56	Post Options Post Reply Quote Hamish Report Post Thanks(0) Quote Reply 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.
	Editing ProductCart Code? See WIKI Guidelines for Editing ProductCart's ASP Source Code

Hamish Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56	Post Options Post Reply Quote Hamish Report Post Thanks(0) Quote Reply Posted: 24-November-2008 at 8:30pm
	Don't forget the values must be text again before the re-import!
	Editing ProductCart Code? See WIKI Guidelines for Editing ProductCart's ASP Source Code

ledbettergroup Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 24-November-2008 Status: Offline Points: 0	Post Options Post Reply Quote ledbettergroup Report Post Thanks(0) Quote Reply 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.

ledbettergroup Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 24-November-2008 Status: Offline Points: 0	Post Options Post Reply Quote ledbettergroup Report Post Thanks(0) Quote Reply Posted: 24-November-2008 at 11:55pm
	without the " ' " that is.

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply 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.
	The ProductCart Team Home of ProductCart shopping cart software

Hamish Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56	Post Options Post Reply Quote Hamish Report Post Thanks(0) Quote Reply 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.
	Editing ProductCart Code? See WIKI Guidelines for Editing ProductCart's ASP Source Code