Hi all, We are looking to automate outside vendors pricing files that would automatically connect to Netsuite or at least automate most of it so you don't have to manually go through the excel files that are sent to us and then edit them manually to match the requirements for the csv upload. Does anyone use or have suggestions on a program, bundles or outside partners they use for this? Any suggestions would be greatly appreciated! Thank you :)

Looked into Celigo for this? How are the files getting to you?

We have Celigo and have EDI 850, 855, 856 and 810 with them however we are running into issues trying to get it set up with them. Some are zip files and celigo doesn't support that right now. And running into mapping errors on that. If you use celigo any tips

@Kelli Webster Celigo should be able to assist, either with integrator.io or CloudExtend. Without knowing all the details I'd recommend something like the following. Have all your files dropped to a central location on SharePoint. User Excel Power Query to watch that folder for new files. Any new file would then be processed by Power Query which would automatically cleanse the file and put it in the proper format for an upload.

Thank you for the suggestion I will check out SharePoint. Also when you say integrator.io for Celigo that is what we currently use is either and ftp server or https sever to pull from but the issue is the data that the vendor ftp shares does line up right with what we need it to do so the mapping is having issues with getting the right information over and transformed so it properly drops into netsuite

@Kelli Webster is the issue the lack of support for zip files or the issue is files fail to parse?

Off-topic question: I'd really like to hear about your experience with Celgio's EDI if I could reach out to you in a direct message. We're evaluating EDI vendors right now.

@Tyler Lamparter thank you for the feedback and suggestions. The main issue we have is that one of the price files we import is MASSIVE. we currently have it set up to import from our google drive and then into netsuite. the issue is that the import into netsuite takes way too long (ran overnight and was only 23% complete) I think its due to the sheer number of items and the fact that it has to look up the internal id of the item before updating.

@Matthew what concurrency do you have set on the netsuite connection within your celigo env? If I had to guess, it isn't set and therefore defaults to 1.

Yes it is currently not set. I am testing it with the sandbox, but my only concern is that changing it will have an effect on the other flows that use that connection into netsuite. Thank you for the pointer

@Matthew you can always make another connection to NetSuite within Celigo that has different settings. Sometimes we see people do this to segment out high priority flows from low priority ones so that things don't get put into the same request queue

Oh awesome, thats good to know. thank you!

@Kelli Webster Celigo's integrator.io is a great option. In addition you can leverage Excel Power Query to normalize all your files. It's one of the most powerful (and unknown) tools I've discovered in the last couple of years. Highly automated as well, all you need to do is drop files into a folder that is watched by PQ and voila, data is cleansed.