Zen Cart Logo
Forums / General Questions / Daily Sales Spreadsheet

Daily Sales Spreadsheet

Locked

Views: 3,064

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
30 Jul 2008, 10:16 AM
#1
out2lunch avatar

out2lunch

New Zenner

Join Date:
Jul 2008
Posts:
64
Plugin Contributions:
0

Daily Sales Spreadsheet

Is there a way to automate a process say at midnight of each day, that would email me and my shipper a list of all items sold with their names, addresses, and items purchased in a spreadsheet format?

My drop shipper has asked me to provide this as he can then quickly import the data into his system and make the labels etc and send from his autopicking device.

This would stop me collating all the info everyday and retyping it etc to send to him every morning.

I hope this is easy to understand.

Thanks in advance.

30 Jul 2008, 10:25 AM
#2
swguy avatar

swguy

Administrator

Join Date:
Feb 2006
Location:
Tampa Bay, Florida
Posts:
10,686
Plugin Contributions:
56

Re: Daily Sales Spreadsheet

You'd have to write a program to do this. There's nothing built in for that.

30 Jul 2008, 4:09 PM
#3
out2lunch avatar

out2lunch

New Zenner

Join Date:
Jul 2008
Posts:
64
Plugin Contributions:
0

Re: Daily Sales Spreadsheet

Thanks for the speedy reply, are we talking about a mysql query etc, automated with a cronjob or is there a zen cart scripting language for all of this?

Cheers...

3 Aug 2008, 2:17 AM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Daily Sales Spreadsheet

There is not any built-in scripting language for that sort of thing at the present time.