To post a new support question, click the Post New Topic button below.
Current Version: 5.2.4 | Sytist Manual | Common  Issues | Feature Requests

Please log in or Create an account to post or reply to topics.
You will still receive notifications of replies to topics you are part of even if you do not subscribe to new topic emails.

Custom Photo Sales Report

r
31 posts
Sat Aug 26, 23 7:07 PM CST

I’m looking for a relatively easy way to export a custom report…  We want a report (.csv) that would list every photo sale on it’s own line, and I have 15 columns of info I want to use/include. in the report (order#, gallery, file name, etc ...)

Am I missing something? Or do you have a way or any advice on how to generate this? I’m currently exploring a php export command from the DB. I'm not sure what else to try...   

16,823 posts (admin)
Mon Aug 28, 23 4:14 AM CST

Select the orders from the orders section (check the box next to the order numbers) and select the Product Export option.

Exporting Ordered Products

Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
r
31 posts
Mon Aug 28, 23 9:41 AM CST

Thank you!   :)   I completely missed that.  

Edited Mon Aug 28, 23 10:27 AM by randy peterson
r
31 posts
Mon Aug 28, 23 10:46 AM CST

Are there codes I can insert into the command to add in additional fields?  For example Tax, or other...   

16,823 posts (admin)
Mon Aug 28, 23 11:04 AM CST

Go to the export settings,  Orders -> Product/Order Export Settings, and use the "Add additional order data fields from the order" option to add more order fields, such as tax.

Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
5 total messages
Please log in or Create an account to post or reply to topics.
This post has been viewed 345 times
Category: Reports
 
Loading more pages
Loading more pages

Sign up for email promotions.

Your information is safe with us and won't be shared.

Thank you for signing up!

 
©2003 - 2021 Grissett, LLC. All Rights Reserved.

By continuing to browse or by clicking Accept Cookies, you agree to the storing of cookies on your device necessary to provide you with the services available through our website.

    Accept   Privacy & Cookie Policy
Loading More Photos
Scroll To Top
Close Window
Loading
Close