problems with our e-commerce orders

's Avatar

millsapfarms

05 Jul, 2018 12:50 PM

We use the e-commerce functions to sell pizza night reservations, and usually it works fine; we sell reservations through our pizza night department, and then download the orders into excell, and sort by date, eliminating the columns we don't need, until we have a simple spreadsheet with the names of the people with reservations for that evening. However, we've run into a tech glitch; last week and this week, when we downloaded the orders, the column that contained that week's orders was mislabelled or missing. Last week we were able to figure out which one it actually was by looking at a downloaded list from earlier in the week, and the column that was supposed to be labelled June 28, was instead May 29th. We hoped it was maybe a one-time weird glitch, but it's doing it again as of last night. When we look at this week's date, there are a few names under the column. the reservations that are there are correct, we are pretty certain, but there are only a few, and should be over 200. Do you have any idea why the spreadsheet is mixed up? we need to use this asap, we need to send out our final confirmation e-mail for tonight (we usually send this out Wednesday), and then use the spreadsheet to check off people with reservations as they come to the door. Feel free to call us if that will help sort out what's happening.
Thanks,
Curtis and Sarah

  1. Support Staff 1 Posted by qroth on 05 Jul, 2018 02:23 PM

    qroth's Avatar

    Hi Curtis:

    I downloaded the most recent export you ran (from 7/2 at 11:11pm) and looked at the spreadsheet. I'm not sure I understand what you are saying the issue is. I show 4 columns relating to products with "July 5" in the title of the item - Adult, Child, Toddler and Gluten-Free options. There seems to be data in all of these columns. Can you clarify what column(s) are missing?

    Q

  2. qroth closed this discussion on 05 Jul, 2018 02:23 PM.

  3. Millsap Farms re-opened this discussion on 05 Jul, 2018 03:25 PM

  4. 2 Posted by Millsap Farms on 05 Jul, 2018 03:25 PM

    Millsap Farms's Avatar

    The July 4 11:04 pm export for excel only has 48 people in the column, but
    we have ticket reservations for 236 people. I know that because I sell 250
    tickets and I had 14 tickets left. I had an idea to check on a friend who
    is coming and found her reservation under

    AT: Item a. Pop-up Saturday Pizza Night May 26th - Gluten Free Crust by Ken
    Fox, MUST PREORDER. then pay $4.50/crust at the door Quantity

    Why is this happening?

    Thanks

    Sarah

    Millsap Farms
    www.millsapfarms.com
    417-839-0847

  5. 3 Posted by millsapfarms on 05 Jul, 2018 03:29 PM

    millsapfarms's Avatar

    Yes, the columns are there, but they should have 200 or more in the adult quantity column. Instead there’s like a dozen. This is what happened last week too, we found the other data in a different column.

    Curtis Millsap
    Millsap Farm
    Millsapfarms.com
    417-839-0847
    Sent from my iPhone

  6. Support Staff 4 Posted by qroth on 05 Jul, 2018 03:35 PM

    qroth's Avatar

    Sarah - what is your friend's name?

  7. qroth closed this discussion on 05 Jul, 2018 03:35 PM.

  8. Millsap Farms re-opened this discussion on 05 Jul, 2018 03:36 PM

  9. 5 Posted by Millsap Farms on 05 Jul, 2018 03:36 PM

    Millsap Farms's Avatar

    ACTUALLY THE RIGHT COLUMN AU ONLY HAS 7 PEOPLE AND THE WRONG ONE AT: HAS
    219, LEAVING 10 TICKETS UNACCOUNTED FOR. I know MOST today's people are
    reading in the AT: Pop-up line, I see many people that I know are coming
    tonight that do not always come. I need help fixing the problem so that
    the collect columns are in the correct places.
    Thanks,
    Sarah

    Millsap Farms
    www.millsapfarms.com
    417-839-0847

  10. 6 Posted by Millsap Farms on 05 Jul, 2018 03:44 PM

    Millsap Farms's Avatar

    Klaire

    Sent from my iPhone

  11. 7 Posted by Millsap Farms on 05 Jul, 2018 04:03 PM

    Millsap Farms's Avatar

    and
    Lisa Skiffington

    Millsap Farms
    www.millsapfarms.com
    417-839-0847

  12. Support Staff 8 Posted by qroth on 05 Jul, 2018 04:40 PM

    qroth's Avatar

    Attached is an updated file.

    I found the problem. In the one title for the June 21st event, you somehow added a TAB code into the title for the Adult option. This meant that when created the spreadsheet, it was splitting the title of that item into 2 columns. The actual data works off item ID numbers, so those remained the correct number of columns, so the data got shifted by one column.

    I fixed the document and that is what is attached. We'll get the data in the database fixed as well, otherwise future exports will also still have this problem.

    Q

  13. qroth closed this discussion on 05 Jul, 2018 04:40 PM.

  14. Millsap Farms re-opened this discussion on 05 Jul, 2018 04:57 PM

  15. 9 Posted by Millsap Farms on 05 Jul, 2018 04:57 PM

    Millsap Farms's Avatar

    Wonderful, thank you for fixing this problem!!!
    Sarah

    Millsap Farms
    www.millsapfarms.com
    417-839-0847

  16. qroth closed this discussion on 05 Jul, 2018 04:58 PM.

  17. Millsap Farms re-opened this discussion on 12 Jul, 2018 04:20 PM

  18. 10 Posted by Millsap Farms on 12 Jul, 2018 04:20 PM

    Millsap Farms's Avatar

    Unfortunatly I am still having the same problem as last week. Our pizza
    night is tonight and I am trying to send an email

    As i just did excel, the AQ column only has 48 people all of those were
    placed 4/24/08- 5/26/18

    I know Susan Lynch is coming and usually doesn't come so I searched her and
    found her in the AP column, and there appears to be 230 people in that
    column which is June 21st. I do not know how to sort this out, who is
    actually coming tonight. Gully and Thompson are also in the AP and coming
    tonight

    CAN WE GET THIS FIXED?

    HELP PLEASE

    Thanks
    Sarah

    Millsap Farms
    www.millsapfarms.com
    417-839-0847

  19. Support Staff 11 Posted by qroth on 12 Jul, 2018 04:49 PM

    qroth's Avatar

    Ok, fixed spreadsheet attached.

    I'll try to see what we can do about fixing this. The problem is that changing the item centrally doesn't retroactively change the orders. The title of the item is in the order and that's not as easy as just making one change in the item listing itself.

    You should really just need to find that one "b2" item June 21st ADULT header that it is splitting into 2 column headers and combine those, then shift all the other cells in the header row over to the left one to get them to line up properly.

    Q

  20. qroth closed this discussion on 12 Jul, 2018 04:49 PM.

  21. Millsap Farms re-opened this discussion on 14 Jul, 2018 01:21 AM

  22. 12 Posted by Millsap Farms on 14 Jul, 2018 01:21 AM

    Millsap Farms's Avatar

    Can you please confirm were you able to fix the problem so all my future downloads work properly? It is a serious problem and really messed us up last night. Thank you for your time and attention to this.
    Thanks
    Sarah

    Sent from my iPhone

  23. Support Staff 13 Posted by qroth on 17 Jul, 2018 03:47 PM

    qroth's Avatar

    Hi Sarah:

    Unfortunately no, this isn't resolved.

    My co-worked Mike who is the one who has access to the database is out this week and he's the one who can assist with this problem. At the end of last week he was backed up with a lot of Harvie related development that had priority so he didn't have another chance to look at this.

    As I noted in my last email, the issue is purely in the headers on the spreadsheet. The data in the columns is correct. It is just a matter of finding that one header for the "Item b2. June 21 (no pizza on 14th) w Brandon Moore - Adult $14-$5 nonrefundable = $9 at the door Quantity" that gets split into two cells at the top of the spreadsheet.

    Once you find those two cells, just copy the contents of the 2nd cell (Adult $14-$5 nonrefundable = $9 at the door Quantity) into the 1st (Item b2. June 21 (no pizza on 14th) w Brandon Moore - ) and then delete the 2nd cell. It should ask if you if want to shift the cells up or to the left. Choose to shift them to the left. This will move all of the headers over to the correct column then. (See attached screenshot of the spreadsheet).

    Q

  24. qroth closed this discussion on 17 Jul, 2018 03:47 PM.

  25. Millsap Farms re-opened this discussion on 17 Jul, 2018 04:25 PM

  26. 14 Posted by Millsap Farms on 17 Jul, 2018 04:25 PM

    Millsap Farms's Avatar

    Q, Does this keep integrity with the rest of the data? So if we copy and
    paste the data from one column to another, do the names and other data in
    those *rows* travel with that data? Can I still tell who has purchased
    those reservations?

    Millsap Farms
    www.millsapfarms.com
    417-839-0847

  27. Support Staff 15 Posted by qroth on 17 Jul, 2018 04:29 PM

    qroth's Avatar

    You want to make sure you are only adjusting the cells in the first row. All of the data below row 1 is correct; it is just a matter of the error in the item name causing the header for that one product to get split into 2 cells. This causes there to be one extra column in the header row than there are data columns. All you are doing is shifting the headers over so the right headers match with the right columns.

    If you want to compare totals to make sure everything is lining up correctly, you can also run the regular e-commerce report by going to - Sell --> Orders&Reports --> Create Report. The top of that report will give you the aggregate totals for each item and you can compare that against the columns on the spreadsheet.

    Q

  28. qroth closed this discussion on 17 Jul, 2018 04:29 PM.

  29. Millsap Farms re-opened this discussion on 17 Jul, 2018 04:41 PM

  30. 16 Posted by Millsap Farms on 17 Jul, 2018 04:41 PM

    Millsap Farms's Avatar

    got it, that makes more sense to me.
    Thanks,
    Curtis

    Millsap Farms
    www.millsapfarms.com
    417-839-0847

  31. qroth closed this discussion on 17 Jul, 2018 04:53 PM.

  32. Millsap Farms re-opened this discussion on 19 Jul, 2018 03:18 PM

  33. 17 Posted by Millsap Farms on 19 Jul, 2018 03:18 PM

    Millsap Farms's Avatar

    Q,
    This is giving me fits. I thought I understood what needed to happen, and
    I modified the spreadsheet accordingly, but then when we e-mailed everyone
    to remind them about tonight, we had one respond that they are not coming
    tonight ( Sara Kaczynski. Then as we looked closer, we found at least one
    other who we were able to confirm is not actually signed up for tonight
    (matthew and Jessica Brown). Could you please repair the spreadsheet and
    send us a copy? the only data we need is the columns for tonight.
    Thanks,
    Curtis

    Millsap Farms
    www.millsapfarms.com
    417-839-0847

  34. Support Staff 18 Posted by qroth on 19 Jul, 2018 04:04 PM

    qroth's Avatar

    Here you go.

    Q

  35. qroth closed this discussion on 19 Jul, 2018 04:04 PM.

  36. Millsap Farms re-opened this discussion on 26 Jul, 2018 03:39 AM

  37. 19 Posted by Millsap Farms on 26 Jul, 2018 03:39 AM

    Millsap Farms's Avatar

    Here we are again and it looks like we still need to ask for help. When is
    Mike going to be able to help? Until then can you please send me an
    adjusted list asap.

    Thanks
    Sarah

    Millsap Farms
    www.millsapfarms.com
    417-839-0847

  38. 20 Posted by Millsap Farms on 26 Jul, 2018 02:01 PM

    Millsap Farms's Avatar

    We have rain in the forecast and I need to email everyone asap so can you
    please help me out with the list.
    Thanks
    Sarah

    Millsap Farms
    www.millsapfarms.com
    417-839-0847

  39. Support Staff 21 Posted by qroth on 26 Jul, 2018 02:16 PM

    qroth's Avatar

    Updated spreadsheet attached. I'll try to get some time with Mike today to discuss.

    Q

  40. qroth closed this discussion on 26 Jul, 2018 02:16 PM.

  41. Millsap Farms re-opened this discussion on 26 Jul, 2018 02:20 PM

  42. 22 Posted by Millsap Farms on 26 Jul, 2018 02:20 PM

    Millsap Farms's Avatar

    thanks

    Millsap Farms
    www.millsapfarms.com
    417-839-0847

  43. qroth closed this discussion on 26 Jul, 2018 05:59 PM.

  44. qroth re-opened this discussion on 26 Jul, 2018 06:47 PM

  45. Support Staff 23 Posted by qroth on 26 Jul, 2018 07:09 PM

    qroth's Avatar

    Ok, I had Mike take a look at this again and it looks to be doing the export correctly now.

    Q

  46. qroth closed this discussion on 26 Jul, 2018 07:09 PM.

  47. Millsap Farms re-opened this discussion on 27 Jul, 2018 09:07 PM

  48. 24 Posted by Millsap Farms on 27 Jul, 2018 09:07 PM

    Millsap Farms's Avatar

    We are still having a problem with the list were finding that the numbers for tonight “ in yesterday’s column for the children column. Could you please export a list and send it to us again ASAP and then can you please have Mike look at the problem and get it fixed.
    Thanks
    Sarah
    Sent from my iPhone

  49. Support Staff 25 Posted by qroth on 27 Jul, 2018 09:13 PM

    qroth's Avatar

    Updated file attached.

    I'll have Mike look at this. Something must be getting reset.

    Q

  50. qroth closed this discussion on 27 Jul, 2018 09:13 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac