AaaTeX Shopping Cart Integrator©

for use with QuickBooks  US editions and Online Edition.

 

 

New Store / Remote Database support Questions.
If this is for QBPOS please adjust accordingly.

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?

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 (ie 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.
 
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. Worse case we can import from a downloaded file (i.e. XLS,CSV,Tab delimited Text, XML).

Almost any cart can be supported - just send us the files you download.

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

 Requirements:

QuickBooks USA version 2003 Pro or better (Canadian version coming soon) or
QuickBooks Online Edition
QuickBooks QBPOS for the POSeIntegrator

Microsoft Windows 2003 or later.

Same machine requirements as QuickBooks/QBPOS

Microsoft Excel 2003 or later (for other Excel Functions)
 

 

 
 

 
   
 
   
 
 
 
 
 

  Email us