The problem is an Excel bug. If there is nothing in the last column or last few
columns, after a while it will start leaving off the tabs for those last fields
in the exported tab-delimited file.
If you are only using 4 fields, then using the Ignore for the other fields won't
work, the file will still have the incorrect number of tabs and you will get the
error message from ShopSite. To only upload four fields, before your save the
excel file, delete all the other columns that you are not interested in. That
way when it saves out it only has the fields you want to use.
Another trick is to move a column that always has information in it, like Price,
to be the last column in Excel, that way when it exports the spreadsheet to
tab-delimited format it won't skip any tabs.
Or, don't use Excel, use Quattro Pro, I doubt it has the same problems, it is a
better program.
-Loren
Kevin Sullivan wrote:
Hi,
1) I downloaded a product database from my existing shopsite manager 5.0.
2) I then opened the database in excell, then changed the database in these
4 columns to the new information. I only use name, price, sku and option
text (for option pulldowns) in my products database. All other columns were
left untouched.
3) I uploaded to a completely brand new store that has the latest Pro
version installed. Just 97 items as a test using the same shopsite headers
I downloaded from my other store.
4) after 14 products were uploaded, I get this error message below. And Yet
when I look at the excell page, it appears all the columbs have the exact
same thing and the "companion ring" it is referring to appears the same as
the first 14 items accepted. So why did the first 14 work and then it
stops?
5) Also, if I am only using 4 fields (name, sku,price and option), do I
even need to upload all those other fields. Would that help? Can I select
ignore on all other fields so only 4 are uploaded? Lastly, if there is no
value in a column, is that OK.
Thanks for your help. Kevin Sullivan
------------------------------------------------------------------------
Added record number 0: 3 WISH RING -14KT
Added record number 1: 7TH HEAVEN RING -14KT
Added record number 2: ACCENT RING -Vermeil
Added record number 3: ACCENT RING -Silver
Added record number 4: ACCENT RING -14KT
Added record number 5: AMAZON RING -Vermeil
Added record number 6: AMAZON RING -Silver
Added record number 7: AMAZON RING -14KT
Added record number 8: Bahama Ring -Silver
Added record number 9: Bahama Ring -14KT
Added record number 10: Bahama Ring -Vermeil
Added record number 11: BELOVED RING -14KT
Added record number 12: CLADDAGH RING -Silver
Added record number 13: CLADDAGH RING -14KT
Added record number 14: CLADDAGH RING -Vermeil
* The record below has 41 tabs instead of the correct number of 44.
* Please correct the problem and reload.
* New records that have not yet been loaded will still be created if you
choose the "Add New" option.
* Products and pages will not be assigned to each other until the upload
is complete.
------------------------------------------------------------------------
COMPANION -Vermeil 87.95 0 0 0 0 0 0 0 0 0
0 0 R390-V none 1. Choose Ring Size Here|n|Ring Size 4|n|Ring
Size 5|n|Ring Size 6|n|Ring Size 7|n|Ring Size 8|n|Ring Size 9|n|Ring Size
10|n|Ring Size 11|n||n|2. Choose Birthstones
Here|n|Jan-Garnet|n|Feb-Amethyst|n|March-Aquamarine|n|April-Diamond|n|May-Em
erald|n|June-Alexandrite|n|July-Ruby|n|Aug-Peridot|n|Sept-Sapphire|n|Oct-Tou
ramaline|n|Nov-Citrine|n|Dec-Zircon none 00_Default_product_template
checked checked checked checked Bold Normal Bold Normal
Plain Small Plain Normal Left On
------------------------------------------------------------------------
Posted: Mon Jan 14, 2002 1:53 pm