Every time you download any information from your store (inventory, items
from Catalog Manager, cross-sell information, etc.) you receive a
comma-delimited text file (CSV). These files are readable by most programs that
can manipulate data, and in particular, you can simply open a CSV file using
Microsoft Excel, make changes to it and save it just like you would with a
regular spreadsheet. A little known fact is that when Excel opens up a CSV file,
it removes any trailing zeros from cells containing only numbers. This can be a
problem in your Code field, for example, if some of your product codes are
numeric and they contain leading zeros. To prevent excel from removing the
zeros, follow these steps:
- Rename your csv file from filename.csv to filename.txt (where filename is
the actual name of the file.)
- Open up Microsoft Excel.
- Select File > Open.
- Under "Files of Type", select "Text files".
- Browse to your file and open it. Excel will present you with a file
conversion dialog box.
- On the first screen, select "Delimited" (the default) and click "Next"
- On the following screen, select "Comma" as the delimiter, and click "Next"
- On the following screen, highlight the column containing your product
codes, and select "Text" as the Column Data Format. Click "Finish" when done.
- Now Excel opens the file and all leading zeros are preserved in the Code
You can now change your file, and when you are ready to save it, select "File
> Save As". On the next screen, under "Save as type", select CSV, then proceed
with saving your file.