Can you please explain the options we would have for Quickbooks integration with Smith Cart and how it might work?

Yes our shopping cart comes integrated with QuickBooks Merchant Services (QBMS). The way it works is the user enters their info including credit card number in the cart checkout then when they click process payment the cart sends the transaction to QBMS for authorization and returns an approved or declined message. All the info saved in the cart database.

If you are running the web version of quickbooks then the credit card transactions are automatically available in your account. If you are running the desktop version of quickbooks or are running quickbooks from your server then the credit card transactions must be downloaded from the quickbooks virtual terminal to your local copy of quickbooks.

The cart also has a feature that allows you to export your customers and orders to an iif file that can be imported to quickbooks.

Quickbooks offers an api for real time integration of your customer and order transactions between the cart and quickbooks. We developed a c# program for another one of our customers using the QB API that exported customer and orders info from our shopping cart and imported it to QB using their API on a real time basis.

---

At your service,
Dave Smith

Since it is an export import its not tied to a specific version of QB. The datarequirements will be driven by how you setup your accounts in QB.

-Scott

---

Scott Kelly
Project Manager

Our current client trying to import either the Customer or Orders from the QB export gets this:

Got this message in QB

"Warning: Found a misplaced SPL line in import file"

When i hit continue got "Data not imported"

There was no option for importing csv files in QB

Can you advise on this?

If it is a problem with how QB is organized per client, how can we figure out what the right organization is?

When I try to import the file, I get a message “Misplaced SPL line on the import file”. The SPL line is supposed to be between TRNS and ENDTRNS headers (and it is not). Could this be the problem?

Thank you. Look forward to it.