The attached spreadsheet will provide you with a sales report for your ezimerchant account. The data inside the spreadsheet is live linked to your sales information on the ezimerchant servers via the Internet (and protected by your password and a secure connection)
Steps on how to use the spreadsheet
Step 1: You will need to enter your merchant number in 'add here'
Step 2: You will then need to enable this spreadsheet, to do so you will need to click on options on top of the spreadsheet, and tick the 'enable this content' and click ok.
Step 3: It will then ask for your ezimerchant credentials (this is what you login with ezimerchant)
Step 4: You have two tabs that you can view first tab:Product sales cube(this will tell you your revenue and all your sales) second tab: Product sales data(this is where you can view all your orders)
Step 5: To view your review all you need to do click on the Product sales cube, once you click on it a Pivot table field will show up, this is where you can edit and filter to your desired reports.
You can learn more about getting questions about your online business answered via pivot tables here: http://office.microsoft.com/en-us/excel-help/pivottable-reports-101-HA001034632.aspx
Comments
3 comments
Hi, I have just started playing with/evaluating the ezimerchant shopping cart and so far am really happy with it. It does just about everything we need except, provide a product name and buyers name in the sales report (so we can see a list of exactly who purchased which product). Is there anyway of adding this in, or have I missed a step somewhere?
Cheers
Ren..
Hi Ren,
The second sheet of the spreadsheet will provide the product name and order ID.
I think the name is currently missing. We should have this fixed by tomorrow.
James
Still no good, just make the fields the same that were available in version 4 for download .
Product qunatity
Special instructions etc.
I raised this with Gerald a few weeks ago.
Please sign in to leave a comment.