Issue with Bulk Data Import

ERPNext Buying
, ,
1

Hello,

I am facing an issue while importing bulk data into ERPNext.

Scenario:
We are importing records for the last three years step by step:

Issue:

While importing Purchase Orders, item prices are automatically created.
If an item is repeated in the next Purchase Order, the price is automatically overridden based on the Price List, instead of keeping the actual value from the import file.
Some items are also getting set to 0 value by default.
How can we prevent item prices from being overridden during import? Also, is there any alternative way to handle bulk imports efficiently?

2

Hi

I think you can Checkout the Buying Setting → Transaction Settings.
Ensure that Maintain Same Rate Throughout the Purchase Cycle Checkbox is Unchecked.

Using this system will not pick the price list rate and consider your excel rate for the same.

Regards
Ranbir

3

Hi,

I followed the steps you suggested, @Ranbir

  1. I unchecked the “Maintain Same Rate Throughout the Purchase Cycle” option and then imported the records, but the same issue persists.
  2. I manually deleted the associated item prices for the items and then tried importing again. Now, all item prices are set to zero.