Product status blanks out during csv upload

[dkontod]

Hello.

I am using Magento 1.9.4

I am trying a procedure that I have performed successfully hundreds of times at the past: Updating product prices and status via CSV upload. This time, product status blanks out whatever I try:

I am uploading the following CSV (just a test with one product):

sku;price;special_price;status
6004;7,67;4,9855;1

I have tried this also:

sku;price;special_price;status
6004;7,67;4,9855;"1"

and this

"sku";"price";"special_price";"status"

6004;7,67;4,9855;1

and this:

"sku";"price";"special_price";"status"

6004;7,67;4,9855;"1"

and this

sku;price;special_price;status
6004;7,67;4,9855;Enabled

and this

"sku";"price";"special_price";"status"

6004;7,67;4,9855;"Enabled"

The result is always the same: Prices are updated and status blanks out. As a result all products disappear from the front end and back end. The first times I had to restore the database from backup. I had to access an infected product (the one I use as test) through the edit page and update the status manually. But I cannot do that for 1500 products. It will take me months.

I am using System->Import/Export->Dataflow Profiles

Any work around to this?

[Vimal Kumar]

Hi @dkontod,

In  Magento 1 there are 2 ways to import:

- for DataFlow 'Enabled' or 'Disabled' should be indicated in 'status' field

- for Import/Export 1 or 2 should be indicated in 'status' field

I hope it will help you!