Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 06-01-2011 15:51:12

jensme
Member
Registered: 04-29-2010
Posts: 392

Creating Custom Reports?

I need to create a custom sales report since I use Excel to manage my sales right now.  How do I do that?  Where do I find information on how to do that?

Offline

 

#2 06-01-2011 16:00:10

dh783
Member
From: Avondale, Arizona
Registered: 04-06-2005
Posts: 6233
Website

Re: Creating Custom Reports?

Short of doing some kind of sql statement (if possible) with in the Raw Database Admin to get the information you want and in the form you need from the database you would have to write a custom mod to do what you want.

John

Offline

 

#3 06-01-2011 16:01:43

jensme
Member
Registered: 04-29-2010
Posts: 392

Re: Creating Custom Reports?

I'm sure that would be nothing short of a complete disaster.

Are there people on here who help with that sort of thing for a fee?

Last edited by jensme (06-01-2011 16:02:01)

Offline

 

#4 06-01-2011 17:15:57

dh783
Member
From: Avondale, Arizona
Registered: 04-06-2005
Posts: 6233
Website

Re: Creating Custom Reports?

There are Kryptronic, Dave, vbsaltydog, myself to name a few but we would need more info on what you need how you would like the export to go.

John

Offline

 

#5 06-01-2011 18:02:10

jensme
Member
Registered: 04-29-2010
Posts: 392

Re: Creating Custom Reports?

I can get really clear, really fast:

I need a sales report that I can pull into my standard data that comes from multiple sources.  It should spit out:

Product Number (I need each one sold)
Sale Date
Title
Quantity
Price
Coupon Code (if any)
Coupon Discount
Custom Sale Code
Custom Sale Discount
Sales Tax
Order Total
Shipping
Transaction ID
Name
Address1
Address2
City
State
Country
Postal Code

All in a CSV file that I can import.

Offline

 

#6 06-01-2011 18:14:35

Dave
Member
Registered: 07-05-2003
Posts: 11233

Re: Creating Custom Reports?

FWIW shipping information for each product is not stored anywhere. It is only available on a per order basis.

Offline

 

#7 06-01-2011 18:18:02

jensme
Member
Registered: 04-29-2010
Posts: 392

Re: Creating Custom Reports?

Pisser.  So there's no way to extract that or... manufacture it?

If you want to message me a quote, I'm all for it!

Offline

 

#8 06-02-2011 03:36:58

Dave
Member
Registered: 07-05-2003
Posts: 11233

Re: Creating Custom Reports?

There is never a calculation done on a per product basis (doesn't really make any sense to do that anyway). You could create a "guess" based on the total shipping cost but it would be just that, a guess.

Offline

 

#9 06-02-2011 07:13:15

dh783
Member
From: Avondale, Arizona
Registered: 04-06-2005
Posts: 6233
Website

Re: Creating Custom Reports?

When you say Custom Sale Code, what are you looking for? Since custom sale scripts can't be assigned on a per product basis ccp does not build or keep information on what was used during the time the sale was completed, it does keep the custom discount amount.

John

Offline

 

#10 05-21-2013 10:50:34

wmlard00
Member
Registered: 06-28-2010
Posts: 7

Re: Creating Custom Reports?

The fact that I can't just pull this info up is a joke. 

This shopping cart has serious limitations and I actually blame it for causing a huge amount of grief for my business.  Seriously, even if you know coding very well, the cart won't turn out looking half as good or operate with 1/10th the effectiveness of an "out of the box template" like at shopify, volusion, magento, big commerce, etc.

Offline

 

Board footer