Archived and Closed
This conversation is no longer open for comments or replies and is no longer visible to community members. The community moderator provided the following reason for archiving: Old
-
120 Points
Posted 4 years ago
Jordan, Software Engineer
-
7,480 Points
Thank you for your post! It all depends on how the data is sent from your Trading Partner as we may parse out spaces and add commas in order to display "cleanly" within WebForms. Do you mind providing me with the Trading Partner this is occurring with as well as an example PO number and I will take a look at the raw data and determine our best next-steps?
Thanks,
Jordan
-
120 Points
Thanks for replying! Our trading Partner is Recreational Equipment Inc, or REI. You may use PO# 4501829770 as an example, thanks again!
Jordan, Software Engineer
-
7,480 Points
1) Is this a recent problem or has it always been this way?
2) If it has always been this way, it is likely that new development will be needed as opposed to simply fixing a bug. Is there are particular date that you need a fix put in place? While as soon as possible is always nice and I completely understand, justification helps me set a due date and hold our Development Team accountable.
A concern I have off the bat is that there is very valid reasoning as to why commas are removed prior to creating the CSV file. It is likely you have not seen the raw data before, so below is a quick snipet.
This is what is received from REI. When creating the CSV file for download, our system will take the relevant fields and remove each (*) with (,). I am thinking there is a rule put in place to remove and commas in the data as they are actually a part of the same EDI element (not separated by *). In that sense, our system believes them all to be one value as opposed to separate values.
All of this being said, I will definitely do what I can to get the commas added to the CSV download, I just wanted to present you with a little context.
I look forward to your response to the two questions above and hope you find this helpful as we work for a solution.
Jordan
-
120 Points
To answer your question:
1. We just started using SPS Commerce this January and it has been like this since the first day.
2. Please have it fixed before end of April (while ASAP will be great too) because May is the peak season when REI places large number of order to us. We will need the csv file ready in order for us to import PO information to our system.
Thank you!
Allen
Jordan, Software Engineer
-
7,480 Points
Jordan, Software Engineer
-
7,480 Points
Stay tuned!
Jordan, Software Engineer
-
7,480 Points
-
120 Points
My name is Allen. Importing csv to our system will be the most efficient way to import data. It will save us a lot of time and avoid man-made mistakes. The help from you and your team will be greatly appreciated! Thank you!
Jordan, Software Engineer
-
7,480 Points
Thank you for your patience in waiting with me. Unfortunately, this will not be possible to complete. Reason being, as slightly touched upon above, is that allowing commas will break the csv formatting. My hope was that we could get a customer csv download for REI, however it was noted that the amount of commas is not consistent among all Purchase Orders sent by REI. With this being said, I see two options to streamline this import to your system.
1. Ask your Trading Partner (REI) to send the information in three separate lines. This will be the easiest solution if their system allows them to do so.
2. If the above is not an option, you will want to look at an Integrated solution. It is my understanding that this could be performed for just the REI Purchase Order and you could still use your WebForms account to transmit documents. And Integrated solution would allow the PO to go directly to your back-end system (the one you are uploading to currently) and be formatted in a custom way. This request would go through your Account Executive, Kevin Fecho. I can provide his information if appreciated.
I wanted to let you know ASAP as I realize the busy season is getting close. I truly wish we could have been able to make an exception in the csv file and I understand the impact this has on your company. I hope you are able to find a solution that works for you! Apologies for this news, please let me know if there is anything else I can do!
Jordan
This conversation is no longer open for comments or replies.
This conversation is no longer open for comments or replies.
Related Categories
-
WebForms Fulfillment
- 269 Conversations
- 282 Followers