SQL Scripts

[juliochristo]

Hi,

Does anyone know how to access the SQL scripts for AC7? Is the full source required for this?

Here is the problem:
We have our warehouse in Canada but only want to ship to the USA and essentially pretend like we are an american site. So we add Canada and USA as countries. We specify the Canadian warehouse location and limit the shipping zones to US states. On the site the shipping estimator shows Canada even though it is not in a shipping zone. We want to edit the query that retrieves all the countries on the store front to only return countries with a mapped shipping zone.


The SQL change is quite simple but where are the queries?


Tom

[jmestep]

Most of the queries are in the compiled source code and cannot be changed. You might have to write something custom and there is info on wiki.ablecommerce.com about how to do custom queries using the data access layer.

[mazhar]

Please have a look at following WIKI topic
http://wiki.ablecommerce.com/index.php/ ... uilder_API