Skip to main content
Solved

Vendor Pricing Mass updates


Kandy Beatty
Captain II
Forum|alt.badge.img+16

I have a client currently who does Vendor Pricing and they need to update sometimes over 100,000 records. I know this isn’t feasible with the Price Worksheets as they have a limitation. I am looking to see what others have done to get around the limitation in Acumatica. Obviously using the Vendor Prices is not ideal because it would take too long to update. 

 

Thank you!

Best answer by DConcannon

@kbeatty21 I think Vendor Price Worksheets are your best option. On the Customer Pricing side, we have a client that has >60k parts and >seven pricing levels with frequent updates. Here are the tips I’ve learned along the way. Keep the commits in the import scenario to the bare minimum (end of each row?) - as the worksheet gets larger, it is the save that takes the time. Break up the vendor price sheets using some logical division, vendor, classes,... Keep the number of rows as low as feasible, but you can see we pushed 80k a number of times. Run the load after-hours if possible :)

 

 

View original
Did this topic help you find an answer to your question?

3 replies

DConcannon
Varsity II
Forum|alt.badge.img+2
  • Varsity II
  • 119 replies
  • Answer
  • August 16, 2022

@kbeatty21 I think Vendor Price Worksheets are your best option. On the Customer Pricing side, we have a client that has >60k parts and >seven pricing levels with frequent updates. Here are the tips I’ve learned along the way. Keep the commits in the import scenario to the bare minimum (end of each row?) - as the worksheet gets larger, it is the save that takes the time. Break up the vendor price sheets using some logical division, vendor, classes,... Keep the number of rows as low as feasible, but you can see we pushed 80k a number of times. Run the load after-hours if possible :)

 

 


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Author
  • Captain II
  • 2155 replies
  • August 16, 2022

HI @DConcannon 

I figured that was my only route unfortunately. I have an import scenario as well that I was testing but it didn’t like a few of my fields, so I will retry with that. 

Thanks for the tips! I have already stressed with them the importance of running these after hours as that is when they have the best chance to have it go faster. 

I appreciate your help :)


Forum|alt.badge.img
  • Freshman II
  • 13 replies
  • May 6, 2024

Were you able to create an import scenario for this? I’m struggling to do the same.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings