Hello Justine, There is a table `SequenceValueItem` that manage those kind of sequences, you just need to set a value above you max product Id into the tuple with SeqName = "Product". Then reboot your OFBiz instance to empty the current sequence bank in memory.
Regards, Gil On Fri, Oct 08, 2021 at 10:04:59PM -0500, Justine Nowak wrote: > Hello, > > We did an XML upload of a lot of SKUs into Ofbiz, but today when I go to > manually add a new product without a Product Id letting the system > automatically decide that. I get the following error. > > (SQL Exception while executing the following:null (Duplicate entry '10044' > for key 'PRODUCT.PRIMARY')))) > > How do we get the system to automatically generate the Product Id based on > the next one in line.
signature.asc
Description: PGP signature
