Auto Complete Crashing

  • 1
  • Problem
  • Updated 3 years ago
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

When we receive multi-store POs from Bed Bath and Beyond we really have no other choice but to Auto-complete the ASNs into the drafts folder. 

We had this same problem last year, and had to have your interal people help with this apologizing and promising they would work on the servers to make them not interrupt the process.

We really have no other choice but to auto complete due to the size of the PO. 

This is the problem:

We pre-load the defaults with as much info as possible, then we auto-complete the PO to generate the ASNs to the drafts folder. 

The problem is we know how many ASNs should generate but mid-way to 3/4 the way it will crash. Since the ASNs offer NO recognizable identification in the drafts fodler we cannot see which ones have been completed or not. So we must go and delete them all and try again. This can go on for days... it's a complete waste of time.

In the event say we need 2000 asns and 1800 complete we decide  - ok that is enough to at least keep those... then we have to page by page download CSVs (max 100 at a time from the search since the "SELECT ALL RESULTS" crashes every single time) of what was generated then sort and compare the store numbers to what we have on the PO... figure out what was/was not generated then manually generate each one that was missed one-by-one.

Same thing goes when we try to auto-complete invoices.

This is an exhaustive method and we really want to know if there is a way to improve this process.

This takes us literally weeks to do since the process doesn't stop there, once the asn is completed you then have to go in again and download the files and manually type in how many boxes sent... which again is a pain because you have to download all the files for this and compare the asn number (which has no meaning at that stage) and figure out which one has which boxes... it would be REALLY nice if on that auto complete page that you enter information the store number appeared that would allow us to reference the PO to enter this info per store/asn.
Ideally an IF statement should be possible since when we pack the boxes it should know how many boxes based on my packing information, 1 box per label generated.

Help!
Photo of Kayte Giorgini

Kayte Giorgini

  • 170 Points 100 badge 2x thumb

Posted 3 years ago

  • 1
Photo of Katrina Wolyniec

Katrina Wolyniec, Employee

  • 3,762 Points 3k badge 2x thumb
Hello,

Thank you for reaching out to us at the Support Center!

After researching your question I have discovered that you are running into a hard system limitation that happens with our WebForms product when it encounters documents of a very large nature that require auto-completing.

You mention you ran into this last year and we have seen this before at this time of year as the large shipments are starting to come in to ensure availability of product for Black Friday and other heavy retail days.

I'm terribly sorry you are experiencing this because we do recognize that this is frustrating and creates a lot of work to process a document when they are this large. Companies that work with documents of this size on a regular basis have made the decision to move to an integrated system as those systems can easily handle processing documents of this size.  WebForms, on the other hand, is not designed to be able to work with the processing of these documents.

As you stated in your post: we have been working on this issue and trying to see how we can have WebForms expand and contract for these larger processing moments a handful of our WebForms customers experience before the busy retail season.  Unfortunately, at this time, we have not been able to launch a fix that successfully does that.

Currently, there are three best practices for this system limitation you are experiencing: you can contact you Account Executive and explore the options of an integrated connection that will allow you to process documents of this size.  You can reach out to your trading partner (Bed Bath & Beyond in this case) and ask that they break up the PO into smaller POs that you can use auto-complete to process. The final option is to work through them manually to process them.

Please let us know if you have any further questions or need assistance as you work with this document.

Thank you,

SPS Commerce Infinite Retail Power

 

Katrina Wolyniec

Analyst | WebForms Fulfillment Support 

P: 1-888-739-3232 Option 1

niservices@spscommerce.com

[supportcenter.spscommerce.com]Support Center – Get Help. Give Help. Share Ideas.

Photo of Kayte Giorgini

Kayte Giorgini

  • 170 Points 100 badge 2x thumb
Ok I can try and break up the POs for next season, can you tell me how many your system CAN handle so I have a starting point?
Photo of Katrina Wolyniec

Katrina Wolyniec, Employee

  • 3,762 Points 3k badge 2x thumb
Hello,

The best estimate we have is about 2,000 auto-completed ASN documents. 

This will vary a bit depending on the amount of data in each repetition of data, however, that is a good starting point.

Thank you,

Katrina

This conversation is no longer open for comments or replies.