AaaTeX Shopping Cart Integrator^©

To use with QuickBooks  US, Canada, UK, AU and NZ editions and Online Edition.

 

New Store / Remote Database support Questions.
If this is for QBPOS please click here.

Questions for New Cart Support

Questions on your QuickBooks

What platform is it on? Linux, Windows? What Database is it using? MySQL, SQL Server? What language is it written in? PHP, ASP, ASP.NET? Can you download orders from it? If so can you send us the file(s)? Hopefully they have column headings? Does it or your hosting provide support remote access (i.e.ODBC) or other methods? If SQL based we will need the SQL statements necessary for getting complete orders. Estimates, or Sales Orders with Payment transactions or Invoiced Payment items We also need to know what you are actually doing on your sites. Overall Structure of how you run your business with your web sites. How many stores do you have?

What versions (2004, Pro, Enterprise) What Country versions (ie. US, CA, UK)? What Transactions (ie Invoices, POs) Are Orders already paid via Store? Do you need to bring in Credit Card #s? Do you need to dynamically add customers? Do you need to dynamically add items? Do you use sub-items? How are options (i.e color size) handled? Do you use Custom Fields, if so what for? Overall Structure of how you run your business with QB. How many QB companies are you using?

 

 

Other Questions

• Does the lists (i.e. Items, ShipMethods, etc) EXACLTY the same in both systems?
• Do you need to UPLOAD data to the web database?
• Which Windows operating system are you using?

 

What we need for Database Interface (not file upload)

• Access to Database to view structure, export, SQL tools (i.e. Query Analyzer, phpMyAdmin)
• FTP access if a script will be used (not for Remote Access)
• Connection String for Remote Access (i.e. ODBC)
• SQL SELECT Statement for complete orders
• Cart Admin to see what the orders are suppose to look like
• Having your files here will help greatly
• Remote Access to your system for Setup, TroubleShooting and Training (i.e. XP Remote Assistance or other way for us to see your screens with you).

 

Does NOT change the cart. Uses remote access via ODBC or a small PHP or ASP script. In worse case we can import from a downloaded file (i.e. XLS,CSV,Tab delimited Text, XML).

Almost any cart can be supported via a manual download interface- just send us the files you download. This is usally done only if there are no other seamless options (i.e. ODBC, API, etc.).

Have a custom made cart - we can customize our Integrator to work with it.

 

Requirements:

• QuickBooks USA version 2003 Pro or better or
  QuickBooks Online Edition
  QuickBooks QBPOS for the POSeIntegrator
• Microsoft Windows 2003 or later including Windows 7/2008 32 and 64 bit.
• Same machine requirements as QuickBooks/QBPOS
• Microsoft Excel 2003 or later (for other Excel Functions)

 

 

Email us