directly accessing shopsite database

[redskys]

Some time ago there was a discussion about the possibility of querying directly the shopsite database to select products meeting customer specifications. For example, querying product fields containing product dimensions, so a customer could choose a product size to meet a certain need.

Is this still impossible?


Does anyone know of a workaround?

[Jim]

Direct access to the ShopSite database is not supported. If you do so, it is at your own risk.

[mokele]

Like Jim says, "Not Officall Supported," but yes you can access the Shopsite database directly if you're using Shopsite 8.x that is using the SQLite database. For PHP you best to use PHP 5 and you need to have PDO for SQLite compiled into PHP. I've wrote to searches for clients of at YourHost.com that access database directly and works fine.

Direct access to the ShopSite database is not supported. If you do so, it is at your own risk.

[andmott]

ShopSite does provide a way to upload and download your product/page database information in standard XML format. While there is little or no documentation on ShopSite's internal database format, XML is an industry standard data format well documented. ShopSite does support database manipulation through XML, though perhaps not as powerful as an SQL interface.

If you have a knowledge of Perl, PHP, C, or some programming language, and the right server setup, you could create a program to interact with your database in XML format. ShopSite provides documentation and sample scripts to help you get started. Here are a few helpful resources:

Getting data in and out of your product/pages database:
http://www.shopsite.com/help/8.3/en-US/sc/pro/database.automated_XML_upload.html

Detailed List of Upload/Download Parameters:
http://www.shopsite.com/help/8.3/en-US/sc/pro/index.htm?page=/help/8.3/en-US/sc/pro/upload.fields.html