SQL Scripts
Posted: Tue Nov 25, 2008 12:39 pm
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
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