I have a business scenario where the client has around 500 customers and around 50 Vendors. Each vendor has its own item list with specific BP Catalog numbers and price associated with the items supplied by that vendor. In order to maintain the difference in the item code from what is referred to by the vendors and customers in particular we are using BP catalog functionality of SAP Business One. I am aware of the DTW import for the BP catalogs.
The issue is, assuming there are around 1000 item codes supplied by different vendors, some of them may be common . If we make a BP Catalog import file for each customer for all the items in order to ease ourselves out of the effort of analysing the item codes that have different BP catalog numbers as compared to the item codes, the total records to be imported would come out to be at least 500,000 (500 X 1000). Doing a DTW import for this would take hours. Its running for 3 hours and still hasn't shown any progress bar yet where i am tring to import it from a database table rather than a CSV.
Could someone recommend a better out of the box solution for this scenario?
Thanks and regards