+ Reply to Thread
Results 1 to 4 of 4

Order Fulfillment Report - Multiple Items on Separate Lines

  1. #1
    Registered User
    Join Date
    11-15-2011
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    1

    Order Fulfillment Report - Multiple Items on Separate Lines

    Hello everyone,

    I have a report that we export out of our ecommerce system to send to our fulfillment center. The report lists all items of the order on separate lines rather than all on one line which is what we need it to do.

    Basically, if there is an order containing 12 of the same widgets, it is all listed on one line. If another order has 12 of widget A and 12 of widget B, there are two line items. The good thing is all the other data is consistent on the other line items so I am sure there is a way to look up the invoice number and append any additional products to one line.

    Attached is a report of our current report. On the first worksheet is the current report and on the second is an example of how we would like it to look. The ideal report would include up to 10 products and their quantities on one line.

    I appreciate any help and direction the community can provide.

    Cheers,
    Stephen
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-23-2011
    Location
    Hurst, Tx
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Order Fulfillment Report - Multiple Items on Separate Lines

    I revamped your spreadsheet a bit and I hope it will help you rather then hindering. I changed a few things around and added more data including a price list tab so if prices change... only that page would need to change. This may be much more then you wanted and if so, sorry I got a bit carried away

    If this is not what you are wanting or won't help or if you want it in the original format you posted, then let me know and I will see what i can do.

    Hope this helps.

    Chuck
    Attached Files Attached Files
    Last edited by cebubb; 11-25-2011 at 12:03 PM.

  3. #3
    Registered User
    Join Date
    06-08-2013
    Location
    India
    MS-Off Ver
    Gujarat
    Posts
    1

    Re: Order Fulfillment Report - Multiple Items on Separate Lines

    I like the thread with the best information and I hope you will keep to share.
    Ecommerce | Logistics | Warehousing

  4. #4
    Registered User
    Join Date
    04-23-2020
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    1

    Re: Order Fulfillment Report - Multiple Items on Separate Lines

    We are starting our Ecommerce line. This is very useful.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1