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

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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