Resolved mass import delivery date to orders

ok great...
yes i user the delivery_date to import tracking code for my records... ok this thread is solved

I am a little confused, you said you want to import the delivery date but in reality the file has a tracking code. You must use the exact table names in your CSV file if you are using the file as configuration. If you use the template fields, the field names in the CSV file are not used.

So that explains why it wouldn't work.

Yes, it is normal to see only 5 lines, you can set the number of debug lines in the settings of CSVI.

well i rename the columns of csvi from order_id to virtuemart_order_id and Tacking to delivery_date (as thr columns on the db table) and it worked....
answer is always in a mysterious path...
anyway...i have 15 lines on the csv when i go to vm order i see that it update every order of the csv file... but in the view debug log i see always that it procesed 5 lines..
is this normal?

that is strange... this is the file

Hello,

The log shows me empty inserts, can you also post the file you imported?

this is the log

No ideas but post the debug log and let's see what is in there.

ok great feature (i didnt know)
but i enable the virtuemart_orders table i update the available fields i go to csvi custom import i create my temp
i proccess it i get message of success and Success Custom field added
but in the order and db delivery date it is not imported ..
any ideas?

The order import requires a number of fields to make sure the order is complete. In your case you are not really doing an order import but rather an order update. That is not possible with the order import.

You can use the custom table import. You can read in the Custom tables import and export tutorial how to set it up.

You will be OK because you use the primary key virtuemart_order_id.