Templates & UI

Product copy error report

Nigel - Cart Viper Developer — Thu, 31 Aug 2017 15:21:34 GMT

Hi,

If you execute the below SQL it should correct the issue:

ALTER procedure {databaseOwner}[{objectQualifier}CVStore_Products_Duplicate]
(
@productId int
)

as

declare @newProductId int

--variants need to be copied in c# code since the identity of
--variant is needed to determine the options for a given
--variant

--cvstore_products
insert into {databaseOwner}[{objectQualifier}CVStore_Products]
(PortalID, Manufacturer, ModelNumber, ModelName, ProductImage, UnitCost, Keywords, Summary, [Description],
Featured, Archived, CreatedByUser, CreatedDate, ProductWeight, ProductHeight, ProductLength, ProductWidth,
SaleStartDate, SaleEndDate, SalePrice, StockQuantity, LowThreshold, HighThreshold, DeliveryTime,
PurchasePrice, RoleID, isEvent, viewRoleId)
select PortalID, Manufacturer, ModelNumber, ModelName, ProductImage, UnitCost, Keywords, Summary, [Description],
Featured, Archived, CreatedByUser, getDate(), ProductWeight, ProductHeight, ProductLength, ProductWidth,
SaleStartDate, SaleEndDate, SalePrice, StockQuantity, LowThreshold, HighThreshold, DeliveryTime,
PurchasePrice, RoleID, isEvent, viewRoleId from {databaseOwner}[{objectQualifier}CVStore_Products] where productId=@productId

set @newProductId = @@identity

--CVStore_ProductAttributes
insert into {databaseOwner}[{objectQualifier}CVStore_ProductAttributes]
(parentId, [name], [value])
select @newProductId, [name], [value] from {databaseOwner}[{objectQualifier}CVStore_ProductAttributes]
where parentId = @productId

--cvstore_productimages
insert into {databaseOwner}[{objectQualifier}cvstore_productimages]
(productId, imageUrl, caption, displayOrder)
select @newProductId, imageUrl, caption, displayOrder from {databaseOwner}[{objectQualifier}cvstore_productimages]
where productId = @productId

--cvstore_categoryproduct
insert into {databaseOwner}[{objectQualifier}cvstore_categoryproduct]
(productId, CategoryId)
select @newProductId, CategoryId from {databaseOwner}[{objectQualifier}cvstore_categoryproduct]
where productId = @productId

-- cvstore_productuserpricing
insert into {databaseOwner}[{objectQualifier}cvstore_productuserpricing]
(productId, price, roleId, userId)
select @newProductId, price, roleId, userId from {databaseOwner}[{objectQualifier}cvstore_productuserpricing]
where productId = @productId

-- cvstore_producttabs
insert into {databaseOwner}[{objectQualifier}cvstore_producttabs]
(productId, tabName, tabContent, sortOrder, TabImageUrl, DisplayImageBeforeTitleText, dnnRoleId)
select @newProductId, tabName, tabContent, sortOrder, TabImageUrl, DisplayImageBeforeTitleText, dnnRoleId from {databaseOwner}[{objectQualifier}cvstore_producttabs]
where productId = @productId

-- cvstore_productyoutubes
insert into {databaseOwner}[{objectQualifier}cvstore_productYouTubeVideos]
(productId, videoId, description)
select @newProductId, videoId, description from {databaseOwner}[{objectQualifier}cvstore_productYouTubeVideos]
where productId = @productId

-- CVStore_ProductDigitalDownload
insert into {databaseOwner}[{objectQualifier}CVStore_ProductDigitalDownload]
(productId, fileName, downloadLimit, expiryDate)
select @newProductId, fileName, downloadLimit, expiryDate from {databaseOwner}[{objectQualifier}CVStore_ProductDigitalDownload]
where productId = @productId

-- CVStore_ProductAccordionLeaf
insert into {databaseOwner}[{objectQualifier}CVStore_ProductAccordionLeaf]
(productId,sortOrder,accordionId,accordionLeafName,AccordionLeafContent)
select @newProductId, sortOrder,accordionId,accordionLeafName,AccordionLeafContent from {databaseOwner}[{objectQualifier}CVStore_ProductAccordionLeaf]
where productId = @productId

-- cvstore_productDNNRoles
insert into {databaseOwner}[{objectQualifier}CVStore_ProductDnnRoles]
(productId, roleId, expiryDate)
select @newProductId, roleId, expiryDate from {databaseOwner}[{objectQualifier}CVStore_ProductDnnRoles]
where productId = @productId

-- CVStore_QtyDiscountBand
insert into {databaseOwner}[{objectQualifier}CVStore_QtyDiscountBand]
(productId, lowerBandLimit, upperBandLimit, discountAmount,
discountAsPercent, dnnRoleId)
select @newProductId, lowerBandLimit, upperBandLimit, discountAmount,
discountAsPercent, dnnRoleId from {databaseOwner}[{objectQualifier}CVStore_QtyDiscountBand]
where productId = @productId

select @newProductId

return

GO

Add summary for cart item

danami — Thu, 31 Aug 2017 12:44:01 GMT

Thanks perfect

Cart Viper Product Widget

danami — Thu, 31 Aug 2017 12:36:06 GMT

Ok, I've chosen the following solution:
1) If I have the result the operation is yours (no modification)
2) If I have no results, I take the top 10 (parameter in) without test date. Can I also be useful to you for future developments?

/****** Object: StoredProcedure [dbo].[CVStore_GetAllProductCreatedAfterDate] Script Date: 08/31/2017 12:37:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[CVStore_GetAllProductCreatedAfterDate]
(
@portalId int,
@dateCreated datetime,
@categoryid int
--,@nTop int = 10 --I think it is more correct as an optional parameter, but it goes wrong so I declare it internally
)
as

set nocount on

declare @nitem int = 0
declare @nTop int = 10
if @categoryid <> -1
BEGIN

select @nitem = COUNT(*) from dbo.[CVStore_Products] as p
inner join dbo.[CVStore_CategoryProduct] as cp
on p.productId = cp.productId
where portalId = @portalId and createddate > @dateCreated

and cp.categoryId = @categoryId and displayInStore = 1
and p.isDeleted = 0

if @nitem <> 0
BEGIN
select p.* from dbo.[CVStore_Products] as p
inner join dbo.[CVStore_CategoryProduct] as cp
on p.productId = cp.productId
where portalId = @portalId and createddate > @dateCreated
and cp.categoryId = @categoryId and displayInStore = 1
and p.isDeleted = 0
order by CreatedDate desc
end
else
begin
select top(@nTop) p.* from dbo.[CVStore_Products] as p
inner join dbo.[CVStore_CategoryProduct] as cp
on p.productId = cp.productId
where portalId = @portalId --and createddate > @dateCreated
--and createddate > DATEADD(month, -6, GETDATE())
and cp.categoryId = @categoryId and displayInStore = 1
and p.isDeleted = 0
order by CreatedDate desc
end

END
ELSE
begin

select @nitem = COUNT(*) from dbo.[CVStore_Products] as p
where portalId = @portalId and createddate > @dateCreated
and displayInStore = 1 and p.isDeleted = 0

if @nitem <> 0
begin
select p.* from dbo.[CVStore_Products] as p
where portalId = @portalId and createddate > @dateCreated
and displayInStore = 1 and p.isDeleted = 0
order by CreatedDate desc
end
else
begin
select top(@nTop) p.* from dbo.[CVStore_Products] as p
where portalId = @portalId --and createddate > @dateCreated
--and createddate > DATEADD(month, -6, GETDATE())
and displayInStore = 1 and p.isDeleted = 0
order by CreatedDate desc
end
END

login from cart skips directly to checkout

Vale_Neat — Wed, 30 Aug 2017 14:44:58 GMT

Thanks!

Problem with wish list item

Mark - Cart Viper Developer — Tue, 29 Aug 2017 10:00:50 GMT

Hi

As Nigel has said we don't expose that parameter/data in the wishlist. What Nigel suggested was for us to add to the product road map the ability to create a razor template that would be used by the wishlist module to render the content to the page.
This would then give you scope to customize and provide the category that the a wishlist product is assigned to and potentially then create some type of url rewrite to push the browser to the correct category page.
If you are interested in having this featured developed quickly you could always sponsor it?

So if you have changes the ascx files you'll need to take care when upgrading. When the upgrade happens all the ascx files are replaced with files in the zip PA. This means your changes would be lost.
What you'd need to do is perform a backup offline on a local copy of the site after you have taken a backup of folder containing the ascx file (DesktopModules/CartViper) then just use WinMerge or similar to compare your post upgrade ASCX with the upgraded folder.
Its not that hard to do.
The probelm with just just running the scripts and copying the DLLs is that if we have added a new asp.net control to the ascx then it will generate a null reference since your version of the ASCX will not have this change.

Regards

Mark

button "add item to cart" from wishlist

Nigel - Cart Viper Developer — Mon, 21 Aug 2017 11:28:30 GMT

Hi,

The HTML has been removed in the latest version:

http://cartviper.com/free-trial

Regards

Problem with [BREADCRUMB]

Nigel - Cart Viper Developer — Tue, 18 Jul 2017 12:21:19 GMT

That particular token uses the tab ID of the main store page when creating the URL's , so the bread crumb categories will load on the main store page.

Below is a Razor script that will generate the breadcrumbs, so you can replace our standard breadcrumb token with the below script. It will use the current tab ID when generating the URL's rather than the main store page, so based upon your description I believe this will resolve your issue, if not it should give you a basis to edit as per your needs:

@using CartViper.Modules.Store.WebControls
@using CartViper.Modules.Store.Catalog
@using CartViper.Modules.Store.StoreFrontUI
@using DotNetNuke.Entities.Tabs;

@inherits DotNetNuke.Web.Razor.DotNetNukeWebPage<dynamic>

@helper GenerateBreadCrumb(){
CatalogNavigation catNav = new CatalogNavigation(Request.QueryString);

if(catNav != null){

@* SEARCH breadcrumb *@
if (!string.IsNullOrEmpty(catNav.SearchValue))
{

}
@* CATEGORY BROWSE breadcrumb *@
else if(Model.Category != null)
{
var data = BreadCrumbs.GenerateBreadCrumb(catNav, TabController.CurrentPage.TabID);
<div>
<span>Current Location:</span>
<ul>

@foreach(var i in data){
<li>
<a href="@i.Url">@i.DisplayName</a>
</li>
}

</ul>
</div>
}
}
}

@GenerateBreadCrumb()

Problem with button "add to wishlist"

Nigel - Cart Viper Developer — Fri, 14 Jul 2017 13:23:22 GMT

The below should work, it was missing a using statement and one of the properties was incorrectly typo:

@using System.Dynamic;
@using CartViper.Modules.Store.Catalog;
@using CartViper.Modules.Store.Catalog.Templates;
@using DotNetNuke.Common;
@using CartViper.Modules.Store.Admin;
@using CartViper.Modules.Store.WebControls;
@using System.Web.UI.HtmlControls;
@using CartViper.Modules.Store.Extensions;
@using System.Linq;
@using CartViper.Modules.Store.UserProductList;

@inherits DotNetNuke.Web.Razor.DotNetNukeWebPage<dynamic>

@{
var presente = "fa-heart-o";
foreach (var wishlist in PublicPrivateWishlist.UserWishLists(Dnn.Portal.PortalId))
{
foreach (var product in wishlist.GetAllProductsInTheList())
{
if (product.ProductId == Model.Product.ProductID)
{
//product with ID 1 is in the wishlist..
presente = "fa-heart";
}
}
}
@presente

}

Display all category in ProductDetail.htm

Nigel - Cart Viper Developer — Fri, 14 Jul 2017 09:16:13 GMT

Hi,

If you just want the original URL just amend the code to use the below:

string imageUrl = item.CategoryImage;

You will need to add in some checks to see if the above has a value and either show a place holder image or hide the image completely if your category does not have an image assigned.

Regards

Pagination missing

Nigel - Cart Viper Developer — Wed, 05 Jul 2017 15:42:55 GMT

Hi,

Can you email me an admin username / password so I can login and view how your store is configured? nigel@cartviper.com

Regards
Nigel.

Add textarea to checkout and order confirmation email

Nigel - Cart Viper Developer — Thu, 15 Jun 2017 09:14:20 GMT

Hi,

if you use [ORDERNOTES] it should output, page 155 onwards contains the full list of tokens the emails supports:

http://cartviper.com/portals/0/userguide.pdf

Disable Product Reviews

Nigel - Cart Viper Developer — Mon, 05 Jun 2017 19:46:30 GMT

Hi,

Yes its possible to remove the product reviews from the tabs on the product details page. If you go to the Cart Viper catalog module settings then go to the section "Product Details Settings" and un-select the option "show reviews".

Regards
Nigel.

Product Accordion Default Open

Nigel - Cart Viper Developer — Wed, 03 May 2017 14:15:25 GMT

Hi,

We don't have a setting for it, however if you open the below file:

DesktopModules\cartviper\ProductAccordion.ascx

Look for the below section and add in the line in bold it should load with the first accordion tab open:

jQuery("#<% =ProductAccordionId %>").accordion({
header: 'div.accordionheader',
active: true,
alwaysOpen: true,
animated: false,
autoheight: false,
heightStyle: "content"
});

jQuery(".ui-icon").hide();

jQuery(".accordionheader").first().click();

Breadcrumb

Nigel - Cart Viper Developer — Wed, 03 May 2017 13:54:19 GMT

Hi,

The page that will be used in the breadcrumb to open the category on is the primary store page and is set in store admin -> store info -> store settings under the setting "Store Page".

Regards

Product Menu

LP — Wed, 03 May 2017 11:47:46 GMT

Thanks!

New custom field for product in adminpanel

Nigel - Cart Viper Developer — Thu, 13 Apr 2017 10:25:10 GMT

Hi,

We don't support adding custom fields to a product, what I would suggest is using a field such as "featured" to differentiate these special products. As our templates support Razor scripts you can then check of the product is marked as featured and if so output your badge, more information on our Razor support is listed below:

http://www.cartviper.com/features/advanced-templates

Below is the code for a simple Razor script that will check if the current product is marked as featured:

@using System.Dynamic;
@using CartViper.Modules.Store.Customer;
@using CartViper.Modules.Store.Catalog;
@using CartViper.Modules.Store.Extensions;

@inherits DotNetNuke.Web.Razor.DotNetNukeWebPage<dynamic>

@{

if(Model.Product != null && Model.Product.Featured)
{
@:This product is featured!
}
}

adding a token to orderDetailsConfirmEmail.htm template

Jen Sharp. — Fri, 30 Sep 2016 13:31:10 GMT

YAY! That worked! Sorry I didn't think to just try it first straight out. I didn't see it in the documentation so I assumed it wasn't there.

Time to start studying Razor for me!

Hide Prices if Price is 0 or Null

Nigel - Cart Viper Developer — Wed, 28 Sep 2016 14:12:27 GMT

By template do you mean the icon / text that appears on the button? If so they are stored in:

DesktopModules\cartviper\App_LocalResources\SharedResources.resx

Based on the type of product we use different text, so I would suggest searching this file for the words you're looking to replace to find the correct one.

Editing My Account and Continue Shopping

Nigel - Cart Viper Developer — Fri, 02 Sep 2016 15:55:58 GMT

That part is not templated but is set via the below control:

DesktopModules\cartviper\Account.ascx

You can modify it but be careful not to delete anything from the file, instead use CSS to hide / manipulate the items, if you're going to modify the file I would suggest taking a backup so you can revert in case of an issue. We do have a number of settings in the my account module that can hide various links if that is what you're wanting todo.

Out of the box the continue shopping button will return you to the page that is defined as the store page in the store admin settings. However you should be able to get the referring URL and update the link the continue shopping button goes to using jQuery.

The below shows some examples of how todo this:

http://stackoverflow.com/questions/2415633/how-to-get-previous-page-url-using-jquery#answer-2415645
http://stackoverflow.com/questions/179713/how-to-change-the-href-for-a-hyperlink-using-jquery#answer-179717