Hi,
I am running into an isssue with an import into PIM where the Excel provider is the source and the Ecom provider is the destination. It appears the import reads the first few columns/fields and “interprets” the data type from the values in the first few fields. That is great if the column in totally consistent but in lots of data (like this for example) the data in the first columns in not a total representation.
Here are a few repro steps:
On site: https://dev-dukal.dw-demo2.com/Admin/Default
In PIM: Imported the file "Copy of validated barcode import 4_13_22_v5.xlsx" and use the source type EXCEL
Use “ITEM NUMBER” as the import key. Then map BASE GTIN – GTIN, Unit of use barcode – Unitofuse, Item Barcode – itemlevelpackagingbarcode, Inner Package Barcode – innerlevelpackagingbarcode, Case Barcode – caselevelpackagingbarcode. Delete “GROUPS” and "DESCRIPTION". Then RUN.
The empty values are getting mapped to (0) in the “%packagingbarcode” fields.
The import reads the Excel data type on the fields. I found a fix to enter all data types that exist for the field/row in the first columns. So a blank value, a string, and an int for this data file. Then run the import and the provider accounts for all those data types for the remainder of th import. After the import then just change the few records manually.
I think a help would be for the provider to double check by stepping through all rows to determine the data type versus just the first few rows. Or perhaps always import as a string and then it will be casted later in the process if it's an integer.
Thoughts?
Thanks,
Shawn Tehini