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.
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
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
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
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
FWIW shipping information for each product is not stored anywhere. It is only available on a per order basis.
Offline
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
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
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
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