Product Export/Import Issue
Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=2181
Printed Date: 21-July-2025 at 11:57pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Product Export/Import Issue
Posted By: ledbettergroup
Subject: Product Export/Import Issue
Date 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?
|
Replies:
Posted By: Hamish
Date 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 http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code
|
Posted By: Hamish
Date Posted: 24-November-2008 at 8:30pm
Don't forget the values must be text again before the re-import!
-------------
Editing ProductCart Code?
See http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code
|
Posted By: ledbettergroup
Date 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.
|
Posted By: ledbettergroup
Date Posted: 24-November-2008 at 11:55pm
|
without the " ' " that is.
|
Posted By: ProductCart
Date 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 http://www.productcart.com" rel="nofollow - shopping cart software
|
Posted By: Hamish
Date 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 http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code
|
|