Exporting products when product codes start with zero

[ecentralstores]

Version info:
Miva Merchant 5.5
Production Release 8 Update 3
Miva Merchant Engine v5.13
Database API: mysql

Just wanted to mention this issue we are having when we export products with product codes that have leading zeros.

Every time we use the export feature to update product information the export drops the leading zeros for our products that the vendor code starts with leading zeros. This would be okay if all codes only had one leading zero the product comes in when some have one zero some have two zeros some have even 3 or 4 leading zeros sometimes.

As an example:

Original product code was:

0553303
0553301
0553304

Exported as CSV or TAB file results in:

553303
553301
553304

Currently, I have to use MySql's phpmyadmin to export product codes for items with leading zeros.

Hope this helps someone if your experiencing this issue, I hope miva will look into correcting this export issue.

Also, we have a custom field that controls if an item can be sampled the values for this field are 0 or 1 so 0 = false and 1 = true.

Miva won't let you update a custom field with the value of 0, not sure why the import with update feature won't allow this either but it will let you update 0.01 so we have had to change the logic to if the value equal to or greater than 1. Otherwise you have to update all the products to zero manually.

Hope this info helps!

[papi34]

Re: Exporting products when product codes start with zero

if you open the exported file in excel, you can define the column containing the product code as a text field and it won't drop the zeros. We do that for both product code and UPC code.

[ecentralstores]

Re: Exporting products when product codes start with zero

I have taken a look at the exported files from Miva and the leading zeros don't exist in the product codes on the exported spreadsheets. Its like miva's export feature is dropping the leading zeros altogether.

This is the same when we use .csv or .txt format for the export file.

[papi34]

Re: Exporting products when product codes start with zero

try exporting the file with a .dat extension (e.g. products.dat).

[ecentralstores]

Re: Exporting products when product codes start with zero

Thanks for the tip, you are correct when you use the .dat extention for the file type it does retain the leading zeros in the file. So, then I just opened excel, then used the open feature to open the .dat file then after stepping thru then import options I set the product code column to text, and presto it works. Thanks for the info we will be using this from now on. Thanks for taking the time to help.

[Mark Hood]

Re: Exporting products when product codes start with zero

Thanks for the tip, you are correct when you use the .dat extention for the file type it does retain the leading zeros in the file. So, then I just opened excel, then used the open feature to open the .dat file then after stepping thru then import options I set the product code column to text, and presto it works. Thanks for the info we will be using this from now on. Thanks for taking the time to help.

Somewhere in excel this can be changed....
I know because I can open csv files with leading zero products.

[papi34]

Re: Exporting products when product codes start with zero

Somewhere in excel this can be changed....
I know because I can open csv files with leading zero products.

Can't seem to find the setting. Even looked through MSOffice 2010 help files. Anybody know how to set this up?
It's kinda pain to save the file with a .dat extension and then define the problematic fields as text fields. Would love to just open a .csv file and be ready to rock and roll.

[Mark Hood]

Re: Exporting products when product codes start with zero

Can't seem to find the setting. Even looked through MSOffice 2010 help files. Anybody know how to set this up?
It's kinda pain to save the file with a .dat extension and then define the problematic fields as text fields. Would love to just open a .csv file and be ready to rock and roll.

I am trying to remember....Was some time ago but in the meant time to make sure we are on the same page you are using the new product export and not changing the drop down to legacy correct?

As soon as I can I will grab someones else's computer and give this a try.

[papi34]

Re: Exporting products when product codes start with zero

to make sure we are on the same page you are using the new product export and not changing the drop down to legacy correct?

As soon as I can I will grab someones else's computer and give this a try.

When exporting, I am using Export Format > File Format: Product Import
not Legacy Import Products From Flat File