This might be a stupid question (I'm a network guy, not a programmer!), but what do you mean by an instance of the database? The only database I have at the moment is the sample products. Is that what you meant, or did I just give you a good laugh?
That's correct. The problem you may encounter is that GoDaddy won't allow you too much flexibility in terms of what you can change with their hosted version of nopCommerce. What you really need is your own hosted web space that supports SQL Server. You can then change and build the nopCommerce code and then upload to your web space.
hi - can you elaborate on what you mean about godaddy not being too flexible with nopcommerce - i'm considering giving them a go with my much altered cart
Hosting companies tend to run the compiled version of applications (and rightly so, it improves performance) which means that almeras doesn't have access to the application's source code, which means he can't make the changes to the application that he would like to make. This is what I meant by GoDaddy not being too flexible in terms of what almeras was tring to achieve (i.e., modifying the source code of a hosted application).
My experience of GoDaddy and other shared hosting organisations is that they typically don't provide you with full Administrator rights on the shared server that you host your application. Again, the hosting organisation does this for very good reasons. Security being one. However, that may not be an issue with nopCommerce. You may be able to do all that you need to do without full Administrator rights. You will only find out once you try it.
Search Google with the following words 'nopcommerce godaddy' and you will get some idea of other peoples experience with hosting nopcommerce on GoDaddy.
adds the value of 'order.BillingFirstName' to the Token name 'Order.BillingFirstName'.
You will need to add a line in this function which takes the value of the 'Manufacturer Part Number' and associates it with a Token name -- for example: "Order.ManufacturerPartNumber".
Then use this Token name "Order.ManufacturerPartNumber" in your templates.
In NopCommerce v1.60 the ManufacturerPartNumber apears in the table Nop_ProductVariant. The Product Variant is related to the Nop_Order via the Nop_OrderProductVariant table. Each row in the Nop_Order table is effectively the Order Header, and each row in the Nop_OrderProductVariant table is effectively the Order Detail or Line Item. Many Nop_ProductVariant rows can be related to a Nop_Order via the Nop_OrderProductVariant table. In fact this is a many-to-many relationship where many Product Variants can be related to many Orders.
So basically, what you've got to do is to get the ManufacturerPartNumber value for each Product Variant associated with the Order and replace the Token in the message with the value.
Take a look through my previous post and follow the steps. It's all there in the NopCommerce code. Set a breakpoint in Visual Studio and step through: public static string ReplaceMessageTemplateTokens(Order order, string Template, int LanguageID) for instance. It's a great way to learn. I've learnt so much from this well-written application.
I suggest you do this only for experimental purposes. This will display the Manufacturer Part Number for each Product associated with Order and not the Full Product Name.
Once you have seen that this works then change the code back to display Full Product Name.
To make this a more permanent change to the application, I suggest you insert the following line after Line 236 (or wherever you want it positioned within the grid / table):
You will then need to insert a row in the table Nop_LocaleStringResource for each of the active Languages in your system - with a ResourceValue of say 'Mfr Part No.' or whatever you choose for the English language.