Exchanging Data

In this day and age, it is hard to find a single program that can do everything you need it to do.  Usually, running your business will include running different programs to manage different parts of your business.  We are well aware of this fact, and it is one of main reasons that we have chosen to implement SixBit on an open SQL Server database.  With an open database, users can integrate existing applications through their own development or by leveraging some of the tools included in SixBit.

Custom Development

The SixBit database is an open SQL Server database.  This means that if you load the SQL Server Management Studio addon to SQL Server, you can view all the tables and data in your database.  You can also create any Stored Procedures, Functions, Queries or Reports that you would like.  Working with SQL Server requires experience with databases and is beyond the scope of this document, however if your programmer or IT department has any questions, we'll always try to help.

 

If you do work with the database, we ask that you do not remove any existing fields or modify/rename any existing fields.  You can add your own fields, but we recommend you use a prefix or suffix to each name that is unique to you to avoid the possibility that we may someday create a field of the same name.

Integrated Imports and Exports

We certainly don't expect everyone to have experience with SQL Server so in addition to allowing you to create your own integration functions, we have provided import and export capabilities for many common applications directly from the user interface.  These include imports from the eCommerce sites, Turbo Lister, eBay Blackthorne, and CSV files.  Exporting to CSV files is also supported.  To learn more, see Importing Data into SixBit and Exporting Data from SixBit.  

Advanced Database Automation

In addition to allowing you to create your own stored procedures, we have created several and made them available to Enterprise subscribers.  With these stored procedures, you can perform tasks such as retrieving orders that are ready to be processed or notifying SixBit of any orders that you have shipped.  These stored procedures can help you integrate with existing order fulfillment solutions.  See Advanced Database Automation for more info.