thread Exporting Items sales to Detailed CSV file the Year is wrong in Online Store

Exporting Items sales to Detailed CSV file the Year is wrong

Jody2323 — Wed, 13 May 2020 15:23:14 GMT

Is anyone experiencing this problem?

Date	Time	Time Zone
2007-05-20	14:11:15	Eastern Time (US & Canada)
2007-05-20	14:11:15	Eastern Time (US & Canada)
2007-05-20	14:09:55	Eastern Time (US & Canada)
2004-05-20	17:19:09	Eastern Time (US & Canada)
2028-04-20	17:57:35	Eastern Time (US & Canada)
2028-04-20	12:17:51	Eastern Time (US & Canada)
2028-04-20	12:17:16	Eastern Time (US & Canada)
2023-04-20	12:28:57	Eastern Time (US & Canada)
2023-04-20	12:28:57	Eastern Time (US & Canada)

Re: Exporting Items sales to Detailed CSV file the Year is wrong

AnitaM — Thu, 14 May 2020 00:31:01 GMT

Yes and I've found 3 posts on this but no solution.

Re: Exporting Items sales to Detailed CSV file the Year is wrong

AshleyK — Thu, 14 May 2020 19:28:50 GMT

Hi @Jody2323 and @AnitaM I'm sorry to see that this has been happening to you guys. Can you please tell me what browser you are using when you export your Detail CSV?

If you are already using Chrome, can you try clearing your cache to see if that also does the trick? Also, is it only for a certain date range that this is happening?

Re: Exporting Items sales to Detailed CSV file the Year is wrong

Jody2323 — Thu, 14 May 2020 19:52:00 GMT

I am using Chrome and I cleared the cache unfortunately it made no difference.

I'm not sure what other report that exports to CSV file exports the date?

I tried a few but I can't find anything.

Re: Exporting Items sales to Detailed CSV file the Year is wrong

AnitaM — Thu, 14 May 2020 20:04:17 GMT

I use chrome as well and have cleared the cache without any change. I do bookkeeping for 3 different companies (all using Square) and this happens for all of them and has been an issue for a couple of years now. I have not sought support until now as I adjusted each of the dates manually as I entered them into Sage 50 but our Auditors have now brought it up as a concern that the initial download from Square does not have the correct dates.

Re: Exporting Items sales to Detailed CSV file the Year is wrong

sayra — Fri, 15 May 2020 23:38:50 GMT

Hi there @Jody2323 and @AnitaM. Not fully sure why this keeps happening. I would also suggest updating your Microsoft Excel software as well as your Square App and browser.

When you get some time can you please send me a private message with the dates you are pulling your report for?

In the meantime, we will make sure to update you here with any new troubleshooting steps.

Re: Exporting Items sales to Detailed CSV file the Year is wrong

Jody2323 — Mon, 18 May 2020 16:08:52 GMT

I have updated the programs as suggested, and still get a CSV file with the year being incorrect.

Surprisingly the month, day and time is correct.

I sent you a private message showing you the issue

Re: Exporting Items sales to Detailed CSV file the Year is wrong

Joe — Tue, 19 May 2020 13:40:29 GMT

Thanks for sending over the private message, @Jody2323 - I'm sure Sayra will be in touch soon.

Also, would like to submit a helpful reminder that you can also reach out to our Support Team for further 'hands-on' troubleshooting! They can take a deeper dive and help diagnose where the issue may be in real time.

Re: Exporting Items sales to Detailed CSV file the Year is wrong

Jody2323 — Tue, 19 May 2020 14:27:19 GMT

Thanks Joe

I have done that and the team suggested to post head also.

Hopefully the team at Square is working on a solution

Re: Exporting Items sales to Detailed CSV file the Year is wrong

Joe — Tue, 19 May 2020 14:45:02 GMT

Awesome - thanks for reaching out and letting us know @Jody2323! We will be in touch soon. Cheers!

Re: Exporting Items sales to Detailed CSV file the Year is wrong

Jody2323 — Wed, 15 Jul 2020 14:44:47 GMT

Any solution?

Has Square even looked at this?

Very disappointed in Square's follow up. I have 3 issues where the system is not reporting correctly and no solutions!

CSV export year is wrong, Inventory Tracking POS, refunds not capturing the customers name in report

Jody2323 — Wed, 15 Jul 2020 15:04:35 GMT

So i have been waiting months for a reply from the " Engineering Team" at Square but have not received a reply to my issues.

Here they are again Square..............

1) year is wrong in CSV file

Date	Time
2007-05-20	14:11:15
2007-05-20	14:11:15
2007-05-20	14:09:55
2004-05-20	17:19:09
2028-04-20	17:57:35
2028-04-20	12:17:51
2028-04-20	12:17:16
2023-04-20	12:28:57
2023-04-20	12:28:57

2) Refunds- Customer name is not Captured in CSV file

Books And Beers	1	John Campbell
Books And Beers	1	Jody LaPlante
Books And Beers	-1
Books And Beers	-1
Books And Beers	1	Jody LaPlante
Books And Beers	1	Jody LaPlante
Books And Beers	1	Jody LaPlante

3) Zero Inventory does not prevent overselling the item on POS.

Will wait again for a response..........and no follow up.

Square is quick to take their % but poor on Customer service.

Will start to escalate these issues......

Re: CSV export year is wrong, Inventory Tracking POS, refunds not capturing the customers name in re

Jody2323 — Sat, 29 Aug 2020 17:10:59 GMT

An update on issues;

1) Wrong Year is an issue with Excel on my specific computer but I have not been able to resolve.

( works fine on another computer and Google Sheets)

2) Refunds- Customer name is not Captured in CSV file.........Spoke with Square, no action to date

3) Zero Inventory does not prevent overselling the item on POS.............Spoke with Square, no action to date

I added a fourth when speaking with Square - number of clicks it takes to add a customer to a sale...too many....Spoke with Square, no action to date

Square, we re only trying to make the product better yet not alot of support is recieved.