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 ?
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.
Please share the excel file (via google-drive?) and screenshot of error log in the data import.
very important to review excel file you are trying to import, so that we could provide further assistance on this.
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.