Project Home
Manuals
Contact Us
Download
Demo
Welcome,
Guest
. Please
login
or
register
.
Did you miss your
activation email
?
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News:
AbanteCart v
1.4.2
is released.
Home
Help
Search
Calendar
Login
Register
AbanteCart Community
»
Shopping Cart Operations
»
Support
»
General Support
»
Can order output file be customized for Quickbooks?
« previous
next »
Print
Pages: [
1
]
Author
Topic: Can order output file be customized for Quickbooks? (Read 8380 times)
Ollie
Sr. Member
Posts: 253
Karma: +28/-1
Can order output file be customized for Quickbooks?
«
on:
September 13, 2014, 11:18:41 AM »
I need Abantecart order.csv file to output one item per line. Is this possible? Right now, all items are lumped together on the same line for any given order.
Logged
Assistive technologies for people with special needs:
https://assistech.com/store/
llegrand
Hero Member
Posts: 1813
Karma: +529/-7
Re: Can order output file be customized for Quickbooks?
«
Reply #1 on:
September 13, 2014, 12:25:09 PM »
Ollie, take a look at this previous post I think it will get you on the path to manage your database information as you wish.
http://forum.abantecart.com/index.php/topic,2613.msg11148.html#msg11148
Logged
Ollie
Sr. Member
Posts: 253
Karma: +28/-1
Re: Can order output file be customized for Quickbooks?
«
Reply #2 on:
September 13, 2014, 01:10:04 PM »
Thank you, Lee. I visited mysqlreports.com. Is Smart Report Maker what I need? Do you know if it's easy to use?
Logged
Assistive technologies for people with special needs:
https://assistech.com/store/
llegrand
Hero Member
Posts: 1813
Karma: +529/-7
Re: Can order output file be customized for Quickbooks?
«
Reply #3 on:
September 13, 2014, 01:39:59 PM »
Yes, it is Smart Report Maker. I find it easy. this one is relatively inexpensive and supported.
Here's a video of how it works.
http://mysqlreports.com/tournew.html
and an online demo
http://mysqlreports.com/demo/wizard/step_2.php
There are free open-source ones out there, too. And if you are familiar with Microsoft Access - you can you that also.
You can even use Excel and an ODBC connection to pull it down. Here's a good how-to on that.
http://kidakaka.com/blog/2013/01/01/connecting-mysql-to-excel-using-odbc-connector/
They all work somewhat the same way - one needs a way to connect to the Database file, select the information one wants, and pull it down into a report or spreadsheet configured how you need to look or perform. The difference is in how much automation is built into the software to assist one. Also, in regards to the Abantecart you often need to pull info from multiple tables - so be sure your selection allows for that.
Logged
Print
Pages: [
1
]
« previous
next »
AbanteCart Community
»
Shopping Cart Operations
»
Support
»
General Support
»
Can order output file be customized for Quickbooks?
Powered by SMFPacks Social Login Mod