Share
ReportAny help appreciated.....
I have approximately 1500 released products, that have 2 style product variants, and 42 colour variants, this makes 126,000 combinations.
Everyone of these variants needs its own individual trade agreement selling price, no problem.
So, to enter the trade agreement price, create a sales price trade agreement journal, add lines each with a from and to date, post the journal... and done.
Changing from and to date for journal lines, no problem, the copy and revise can do that.... its changing the actual prices that becomes an issue.... and this is where the 126000 becomes a problem.
For auditing, accuracy and traceability, i'd want to do this change in one journal.
If I try and use the excel plug in it exceeds the number of records, and if I use data management the data import is prone to fall over if above 10000 lines, so when I did this previously I sliced the data set into 16 groups of 8000 lines each and did 16 different journals each in turn, a complete pain...
No in my opinion 126000 SKU's isnt a huge amount, in a B2C business it would be many many more.... if you had 1M SKU's you would'nt want to be doing over 160 separate journals, our gold partner claims that 126000 SKU's is a lot, don't believe that.
Note, the new prices are not as simple as a 3% uplift accross the board.
So how are other businesses doing this ?
All responses (
Answers (
291,280
