Adding Store Email and Phone Number to Invoice

skinsfan99 · Post by **skinsfan99** » Wed Jun 15, 2016 9:45 am

We would like to add the Store's email and phone number to the invoice. In the invoice.aspx file I find this line of code:

<%#AbleContext.Current.Store.Name%> - this displays the store name.

<%# AbleContext.Current.Store.DefaultWarehouse.FormatAddress(true) %> - This formats and prints the street address, city, state, zip and country.

I am assuming the next lines would be something like:

<%#AbleContext.Current.Store.Email%> - email
<%#AbleContext.Current.Store.Phone%> - phone

Are these variables available for the store and are these the correct names.

We are looking to bring some of the custom coding in house. What version of Visual Studio will we need?
Until we get Visual Studio installed is there a reference available to show me what fields are available in the database?

Thank you

Post by **mazhar** » Thu Jun 16, 2016 12:43 am

I am assuming the next lines would be something like:

<%#AbleContext.Current.Store.Email%> - email
<%#AbleContext.Current.Store.Phone%> - phone

It would be like this where you will have to get Email and Phone from Default Warehouse

Code: Select all

<span class="inlineCaption"><%#AbleContext.Current.Store.DefaultWarehouse.Email%></span> - email
<span class="inlineCaption"><%#AbleContext.Current.Store.DefaultWarehouse.Phone%></span> - phone

Until we get Visual Studio installed is there a reference available to show me what fields are available in the database?

You can download the documentation file from following URL. You may have to unblock the chm file to view its content in windows. Just right click on chm file and then from properties unblock it.

http://www.ablecommerce.com/docs/Commer ... erGold.chm

We are looking to bring some of the custom coding in house. What version of Visual Studio will we need?

You can use Visual Studio 2015 community edition which is free.

skinsfan99 · Post by **skinsfan99** » Tue Jul 12, 2016 10:48 am

Mazhar,

Thanks for the information.

I forgot to ask but what version of MS SQL would we need to have installed to be able to create tables, stored procedures, etc?

Thank you,
David

Post by **mazhar** » Tue Jul 12, 2016 9:50 pm

Here is the information about software requirements
http://help.ablecommerce.com/installati ... ements.htm

A new (empty) Microsoft SQL database for data storage.
The following versions are supported:

SQL 2012

SQL 2008 R2

SQL 2005

SQL 2005/2008 Express**

SQL 2012

** Microsoft's SQL Express is a free, easy-to-use, lightweight version of SQL Server. Download

AbleMods · Post by **AbleMods** » Thu Jul 14, 2016 7:18 am

Mazhar has anyone tested Able Gold on SQL 2014 or SQL 2016? Seems like the supported SQL versions could use a little updating....

Post by **Katie** » Thu Jul 14, 2016 8:22 am

I'm pretty sure it runs on SQL 2014, but I'm not sure about SQL 2016. SQL compatibility has never really been an issue. I think the only time we had to write separate code was between SQL 2000 and SQL 2005.

And yes, it does look like we need to get those updated. Where does the time go...

Thanks
Katie

AbleMods · Post by **AbleMods** » Thu Jul 14, 2016 8:32 am

SQL 2016 just came out. I never even saw anyone using SQL 2014.

jmestep · Post by **jmestep** » Thu Jul 14, 2016 11:36 pm

My local development sites run fine on SQL Server 2014.

AbleCommerce Shopping Cart Software

Adding Store Email and Phone Number to Invoice

Adding Store Email and Phone Number to Invoice

Re: Adding Store Email and Phone Number to Invoice

Re: Adding Store Email and Phone Number to Invoice

Re: Adding Store Email and Phone Number to Invoice

Re: Adding Store Email and Phone Number to Invoice

Re: Adding Store Email and Phone Number to Invoice

Re: Adding Store Email and Phone Number to Invoice

Re: Adding Store Email and Phone Number to Invoice