Importing data to Price list items table is not easy as product table. Because the price list items include lookup fields from different tables. Sometimes the import may lead to “The lookup reference could not be resolved” error. For that, we have to follow some simple steps to accomplish this import.
Solution:
- Create an Excel table with the following columns, which are Price List, Product, Unit, Quantity Selling Option, Pricing Method, and Amount. Save the file as CSV format.
Note: Sometimes Excel file will throw errors while importing through data import. So, we go for CSV.
- Go to the Environment ➔ Settings ➔ Data Management ➔ Data Import Wizard. Click on the Import Data button in the wizard, a dialog box opens up for importing files.
- Choose the file which we created and hit the next button. In the Review page, unless you have any change in delimiter, click on next. Select Default in Data Map and click on next.
- Select Price List Item in Record type and click next.
- In the map fields page, make sure all the fields are mapped correctly and replace the Product ID with the Name in the Product Lookup. Then click next.
- Review the mapping and navigate to next page and submit the mapping.
- In the imports page, we can see the status of our import, and it is imported successfully without any error. I have accomplished the import of Price List Items with this simple way.
Have a Good Day!