Login   |   29 Mar 2024 
Support Center » Knowledgebase » 12. ShopFactory Add-Ons » 12-0005-EN-Import Wizard: importing XLS spreadsheet - Catalog Number in TEXT type but with numeric entry shows up as number with decimal values
 12-0005-EN-Import Wizard: importing XLS spreadsheet - Catalog Number in TEXT type but with numeric entry shows up as number with decimal values
Article

Description of the problem:
The Catalog number with numeric entries are being treated as "Number" type having decimal places rather than Text type.
The field has been formatted with TEXT as data type.

The Item Number has been changed from number to text format in Microsoft Excel. However, it is still displaying the same result.

How to resolve this issue?
This is a flaw in the Excel ODBC driver, it reads the first 8 rows to guess what the data type is of the column, so you can either re-arrange the sheet so that the row with text entry comes on one of the first rows or simply, move the row with text entry on top.

or

insert ' (single quote symbol) before the number entry per product (e.g. at the start of the number). Setting the type to TEXT will NOT help in any way. You must put a ' (single quote) at the beginning of the Catalog number entry.

Add single quote in front of the field entry - do this for the first 8 rows

Once you have edited your spreadsheet, then you can import products into your shop again.



Article Details
Article ID: 658
Created On: 18 Jan 2010 12:00 AM

 This answer was helpful  This answer was not helpful

 Back
 Search
 Article Options
Home | Knowledgebase | Downloads
Language:

Help Desk Software by Kayako SupportSuite v3.70.02