Search found 23 matches

by fruitbat
Fri Jan 01, 2016 1:53 pm
Forum: Installation & Upgrade Support
Topic: Reset products purchased and sales
Replies: 10
Views: 27323

Re: Reset products purchased and sales

Hi Leo Thanks. I went to the link from within the website last night but was looking for something similar to the format I was using and did not realise that all it needed was "UTC, Australia/South Australia" in the field!! I entered that but didn't try any updates. :oops: Starting to feel a bit stu...
by fruitbat
Fri Jan 01, 2016 3:04 am
Forum: Installation & Upgrade Support
Topic: Reset products purchased and sales
Replies: 10
Views: 27323

Re: Reset products purchased and sales

Hi Leo I have discovered the problem when you asked "what have you entered literally" as I couldn't remember off the top of my head and went to check. Here's what I did - I had all the default country/region/etc set for here but I had the "Time Zone" with just "UTC" in it!! :oops: I've tried making ...
by fruitbat
Wed Dec 30, 2015 2:26 pm
Forum: Installation & Upgrade Support
Topic: Reset products purchased and sales
Replies: 10
Views: 27323

Re: Reset products purchased and sales

Hi Leo. I have set the time zone to my local time, UTC +9:30 hours, South Australia. The server is in Dallas, Texas, which is UTC -6:00 hours (currently) which means that at midnight Dallas, Texas, it will be 15:30 hours later here or 15:30 local time. (Daylight saving is now in effect in Dallas oth...
by fruitbat
Tue Dec 22, 2015 5:29 pm
Forum: Installation & Upgrade Support
Topic: Reset products purchased and sales
Replies: 10
Views: 27323

Re: Reset products purchased and sales

Hi Brent. Yes, the time zone is correct. I changed one product to update "today" and after calculating the time difference between the server and locally, I determined that a 00:00 server time update would be at 16:30 here. Although I was not able to check the product at exactly 16:30, it had become...
by fruitbat
Sat Dec 19, 2015 3:31 pm
Forum: Installation & Upgrade Support
Topic: Reset products purchased and sales
Replies: 10
Views: 27323

Re: Reset products purchased and sales

Thanks Leo. I'm not keen on deleting all my sales figures but may do that to start fresh. I rechecked the figures and noticed that the data was from two years instead of two months so after changing the dates and doing another search, it seemed to then be correct. I will keep an eye on it though and...
by fruitbat
Fri Dec 18, 2015 4:38 pm
Forum: Installation & Upgrade Support
Topic: Reset products purchased and sales
Replies: 10
Views: 27323

Reset products purchased and sales

I would like to reset both the "Products Purchased" and the "Sales" data to zero. I have used the SQL query in another topic (UPDATE `product` SET `viewed` = '0';) to reset the "Products Viewed" data and was wondering if I can also do the same to the other two using a SQL query please? One reason fo...
by fruitbat
Tue Sep 30, 2014 12:11 am
Forum: Coming Soon in Version 1.3
Topic: New additions for Version 1.2.9
Replies: 31
Views: 207240

Re: New additions for Version 1.2.9

Excellent! Maximum order quantity will be a real help to me, thanks Leo.
by fruitbat
Fri Jun 20, 2014 9:48 pm
Forum: Template Support
Topic: need a little help at first
Replies: 1
Views: 7785

Re: need a little help at first

It might look a little daunting when you first start but once you put in a little effort, this cart really is well done and quite easy to understand. You should try a few things first and see how you go and if there is something that you are having trouble understanding, search the forum first as yo...
by fruitbat
Wed May 21, 2014 9:21 pm
Forum: General Discussion
Topic: Singapore - No Zone - can't go past shipping page
Replies: 1
Views: 8106

Singapore - No Zone - can't go past shipping page

I had a customer that could not get past the shipping page. I found the reason was that Singapore (where this customer was located) did not have a "zone" allocated and this was causing the problem. I inserted a zone called Singapore in the country Singapore and it now works. Just posting this in cas...
by fruitbat
Fri Dec 20, 2013 3:09 am
Forum: General Support
Topic: Limit maximum order quantity
Replies: 9
Views: 13602

Re: Limit maximum order quantity

G'day Leo. Champion, looking forward to it. I can't begin to tell you how pleased I am with AlegroCart and the support you people give, just fantastic, thank you. Merry Christmas.