st1x80

BTW, This issue is only a problem with the custom date fields.

Example from the Order Status page.

Measure Date: 2018-11-21T09:30
Order Date: 2018-11-24

Order Status Order Updated
Product Ordered 2018-11-24 18:40:51

MySQL Entry for Product Ordered Status Update “2018-11-24 18:40:51”
MySQL Entry for Order Date(Custom Field) “2018-11-21T09:30”

I figured out the reason why. You have all custom fields being input into the DB as “text” for the Meta Value but when we update one of the standard fields you have it going into the DB as “datetime”.

Can we get custom fields to have their own individual columns that take the correct input format as you have done with all of your prebuilt fields? Fields specifically for “datetime” instead of only “text”?

• This reply was modified 6 years, 3 months ago by st1x80.

This seems to have fixed itself. Not having this issue now.

This does not solve either of my issues.

I want MM-DD-YY and that is not an option from your plugin.

2nd I asked for a formatting that comes out in this format on the tracking side.

11/21/18 09:00AM

Currently your plugin does this

21/11/18T09:00 which is terrible to use with customers.

I have the same issue. My manual created orders work perfect but the ones I uploaded from a spreadsheet do not send updates.

I also noticed that the uploaded ones have an issue recognizing the emails with the order number on status tracking.