Address Billing problems

Roger · February 1, 2018, 4:02pm

I put by mistake for the billing address preferred shipping address in excel and i imported it but now i cant change them to value 0 the preferred shipping address of my billing address in excel any help ?

umair · February 1, 2018, 4:10pm

Hi,

To overwrite value in the Shipping Address field, you should update:

Address ID in the Name (column B).
Shipping Address as “0”.
Remove column for rest of the fields from excel file.
In Data import, check field “Update Records”.

Hope this helps.

Roger · February 1, 2018, 4:48pm

@umair I tried this it wont update i dont know why

umair · February 1, 2018, 4:51pm

Please share the excel file (via google-drive?) and screenshot of error log in the data import.

Roger · February 1, 2018, 4:53pm

it doesn’t put an error log in the data import it put successful but don’t change @umair

umair · February 1, 2018, 4:54pm

very important to review excel file you are trying to import, so that we could provide further assistance on this.

Roger · February 1, 2018, 4:58pm

this is my excel file @umair

Roger · February 1, 2018, 5:32pm

@umair i tried this what you told me but it didn’t change

umair · February 2, 2018, 6:03am

In this excel file, keep only three columns.

Column A
Column B
Preferred Shipping Address

Delete rest of the columns from the file.

For the column “Preferred Shipping Address”, to uncheck value in this field, set value at 0 for all the rows.

Save file.

Import into your ERPNext account.

Hope this helps.