HomeHome Product Discus... Product Discus...SmithCartSmithCart** Upgrade Notes **** Upgrade Notes **
Previous
 
Next
New Post
10/20/2011 1:31 PM
 

Upgrade Notes - v.6.0 +

If you upgrade from a earlier version of the Cart to 6.0+ and are seeing strange numbers on the Manage Order Details screen the following SQL scipt can be run to update the SubTotal and Grand Total fields:

MERGE INTO Smith_StoreOrders OTO
   USING (
                  SELECT 
                        o.orderid, convert(money,sum(od.UnitCost * od.Quantity),1) as "SubTotal", 
                        convert(money, sum(od.UnitCost * od.Quantity) + (o.shippingtotal + o.handlingcharge + o.taxtotal) - o.discount ,1) as "GrandTotal"
                  FROM
                        Smith_StoreOrders o
                        INNER JOIN Smith_StoreOrderDetails od ON o.OrderID = od.OrderID
                  GROUP BY 
                        o.orderid, o.discount, o.shippingtotal, o.handlingcharge, o.taxtotal
         ) OFROM
      ON OTO.orderid = OFROM.orderid
WHEN MATCHED THEN
   UPDATE 
      SET SubTotal = OFROM.SubTotal, 
          GrandTotal = OFROM.GrandTotal;

Upgrade Notes - v.5.0 +

If you upgrade your store and your Products are not showing, please take the following steps to resolve this issue:

1. From the store admin menu, click on the page template button to go into the page template editor and delete all your page templates.

2. In file explorer, navigate to your \portals\[portalid]\smithcart\tenplates folder

3. Delete all the files in the \portals\[portalid]\smithcart\templates folder

4. Reset iis and restart the application from the dnn host menu

5. Go to product listing page and see if your products are displayed.



Upgrade Notes - v.4.99

In SmithCart v4.99 a new feature for page templating on the product listing page was released.   If you upgrade your cart and recieve and error viewing the product list page you will need to setup your page template.  To setup your page template please follow these steps:

 

1.      Go into the BuyNow module settings

 

2.      Smith Cart Settings, then click “Load BuyNow Settings”

 

 

 

3.      Go to the Payment Setup section and click the button below

 

4.      Click Store Admin Menu

 

 

 

5.      Scroll to the Templates section and click Page Templates:

 

6.      Click Add Page Templates and save the default templates:

 

Upgrade Notes - v.4.67

After you upgrade to 4.67 you will need to go into the Manage Invoice Template screen and save an Invoice Template for the both the "Store Invoice Template" and the "My Accounts Invoice Template" in order for the invoice to display properly.  

Also, after upgrading to any new cart version its always a good idea to go into the BuyNow module settings and re-save your settings to initialize any new settings that have been added.

 

 
New Post
10/24/2011 4:47 PM
 

FWIW, implementing iUpgradable could call save settings as part of the upgrade process and will ensure the proper settigs are initialized.

I have encountered/missed this step way too many times . (g)

public string UpgradeModule(string moduleVersion)
{
    switch (moduleVersion)
    {
        case “04.67.00”:
            //Take action for this version

LoadSettings();

SaveSettings():

           break;
    }
                  
    return “True”;
}
 

 

 
New Post
10/24/2011 4:53 PM
 
Dwayne,
You're the man! thanks for the tip!! we will work getting this implemented into the next build.


At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
5/7/2012 2:57 AM
 
Hi Kevin, thanks. I could go to the admin store as you told, using the layout view.
I created the templates, but when I try to see the page I still have the error:

An error has occurred.
DotNetNuke.Services.Exceptions.PageLoadException: The control collection cannot be modified during DataBind, Init, Load, PreRender or Unload phases. ---> System.Web.HttpException: The control collection cannot be modified during DataBind, Init, Load, PreRender or Unload phases. at System.Web.UI.ControlCollection.RemoveAt(Int32 index) at System.Web.UI.ControlCollection.Clear() at DotNetNuke.UI.Modules.ModuleHost.CreateChildControls() at System.Web.UI.Control.EnsureChildControls() at System.Web.UI.Control.FindControl(String id, Int32 pathOffset) at System.Web.UI.Control.FindControl(String id) at DotNetNuke.Common.Globals.FindControlRecursive(Control objControl, String strControlName) at DotNetNuke.Entities.Modules.PortalModuleBase.get_ContainerControl() at Smith.DNN.Modules.BuyNow.ProductsList.bindDtProductList() at Smith.DNN.Modules.BuyNow.ProductsList.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
 
New Post
5/7/2012 10:01 AM
 
Hi,
Try resetting IIS or recycling your app pool from the DNN host settings menu.


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
12/14/2012 10:15 AM
 
Hi Kevin, thanks for the having this on the site. Let me fix the cart in few minutes.
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCart** Upgrade Notes **** Upgrade Notes **