Close

Profile: Boyko

Avatar

User posts

8 years ago

Hi guys,

Just continued our conversation in the nopCommerce forum since the same questions was added there and it doesn't seem to be related only to the Ajax Filters but with how the default nopCommerce search is working.

8 years ago

Sizzler wrote:
If the sort order for the specification attribute options is not set (all 0), can you have the default sort order to be in ascending order? It now uses the order that it was added to the database in admin.


Hi Sizzler,

The specification attribute values are plain text (not numbers) and they can be ordered only alphabetically, which is not going to help you in your case. You should put proper display order to your specification attributes in order for them to be ordered correctly.

hkreklame wrote:

Hi.

My azure database is kneeling. The following query is running constantly, and for a long time.

INSERT INTO #FilterableSpecs ([SpecificationAttributeOptionId])
          SELECT DISTINCT [psam].SpecificationAttributeOptionId
          FROM [Product_SpecificationAttribute_Mapping] [psam] WITH (NOLOCK)
              WHERE [psam].[AllowFiltering] = 1
              AND [psam].[ProductId] IN (
  SELECT p.Id
  FROM
    Product p with (NOLOCK)
    LEFT JOIN Product_Category_Mapping pcm with (NOLOCK)
      ON p.Id = pcm.ProductId
  WHERE
    p.Deleted = 0
    AND pcm.CategoryId IN (SELECT CategoryId FROM #FilteredCategoryIds)
    AND pcm.IsFeaturedProduct = 0
    AND p.VisibleIndividually = 1
      AND p.Published = 1
    AND p.Deleted = 0
    AND (getutcdate() BETWEEN ISNULL(p.AvailableStartDateTimeUtc, '1/1/1900') and ISNULL(p.AvailableEndDateTimeUtc, '1/1/2999')))

As far as i know this is a temp table created by a stored procedure. But, is it my plugin, or is this code in nopcommerce? The problems started with 4 of my sites after upgrading to 3.8.


Does anyone know what this is? Could it be a problem with my nop templates ajax filter?


Hi hkreklame,

This is the default nopCommerce stored procedure. Please note that the Ajax Filters stored procedure is used only when you filter the products.
For example when a category page is loaded the default nopCommerce stored procedure is used to load the products and only when you select a filter then the Ajax Filters stored procedure is used.
Please check if you are using the latest version of nopCommerce 3.80 since there was an update.

8 years ago

myo myint han wrote:
Hello,

I am considering to buy Nop pavilion theme for setup store. I want nop pavilion responsive theme to show on phone like nop minimal theme ( 100% width on phone). Is it possible to modify nop pavilion theme like nop minimal on phone?
Thanks


Hi myo myint han,

Thank you for considering our products!

Please note that both themes are responsive and both use 100% of the width of the device i.e phone, tablet etc.

8 years ago

Whiteman wrote:
Topic for general discussion regarding the Nop Poppy Responsive Theme.

Hi! Here https://www.nop-templates.com/licensingfaqs refers to the trial license.
How can I get trial license.
I want to try this theme https://www.nop-templates.com/poppy-responsive-theme-for-nopcommerce


Hi Whiteman,

As specified in the FAQs - "Please note that the trial license applies only to our plugins.".
We do not have trials for our themes. Please contact us at [email protected] and we will provide more information.

8 years ago

Sizzler wrote:
Can we have some more "real estate" on the settings page for the Theme to enter the CSS code?  The text box is too small to work in and there is lots of opportunity on the page to give it some more room.  Please see the attached image.





Hi Sizzler,

Thank you for the suggestions!

Please note that the administration of nopCommerce 3.80 is completely different and responsive (you might be using older version).
In the new version of the administration we will make the custom head styles box to take the full width of the right side.

Thank you again for your feedback!

8 years ago

deselt wrote:
I recently update this theme to 3.8.354.21965 version and run test at Google Speed inside.
and getting two recommendation to fix.
1. Leverage browser caching
https://www.cycleheart.com/PavilionTheme/RetrieveColorSquares (expiration not specified)
2. Prioritize visible content (screen shot below)


Hi deselt,

Please let me explain:

1. Leverage browser caching.

This is a URL that is used for making Ajax calls to get the color squares. It should not have any expiration date since it is not a static resource. I really don't know why google thinks it is a static resource and suggests you to add expiration date.
What does expiration date means?
It means that if you have static resources i.e images etc. The server should add expiration date that is used by the browser to cache these resources for the specified time.
Google usually suggest this to be at least 2 weeks.
Please note that nopCommerce adds expiration date to all static resources and the default value is 7 days which is defined in the Web.config file and could be changed.
We should not add expiration date to non-static resources.
It doesn't make sense to do this for ajax request i.e if we cache the color squares of the products then all products would have the same color squares which is not something that we want to be dynamic content depending on the products on the home page.

2.  Prioritize visible content.

Google suggests that the visible part of the web page should not contain any data that is retrieved by making additional calls to the server, which is the case with the products from the smart product collections that you have on the Home page.
Of course we have made the Smart product collections to use Ajax on purpose, so that the products are loaded after the page is loaded and only when the collection becomes visible, which by the way greatly improves the loading of the page since only the products that are visible are loaded. So basically Google suggests you to remove the Smart Product collections from the visible part when the page is loaded. So you can put something above the Smart Collections and this way in the visible part of the page everything will be loaded at the time the page loads and no ajax called will be made to show that content.

Both suggestions are as google say "Consider fixing", which means that they will not have such a great impact.

I hope this information is useful!

8 years ago

GreatAdventure wrote:
Hello Nop-Templates,

I'm getting ready to upgrade Nop from 3.7 to 3.8, and my Nop-Traction theme from 3.7 to 3.8. I have downloaded the Nop Traction theme. Inside there is a "Theme upgrade.txt" and a "7Spikes_upgrade.sql".

On the top of the "7Spikes_upgrade.sql" file it states "-- 7Spikes upgrade scripts from nopCommerce 3.70 to 3.80". Does this have to be executed if upgrading the theme from 3.7 to 3.8? The reason I'm asking is because the "Theme upgrade.txt" doesn't mention this step.

Thanks,
Shawn


HI Shawn,

Yes, absolutely. You need to run our script too as explained here.

p.s: We will update the information in the "offline" upgrade instructions.
Thank you for reporting this!

8 years ago

Jhopper wrote:
Hello,

I've been looking at the daily sale plugin and realised that you can't actually apply any discounts to the products you've selected.

Is there a way to do this easily or could this be something to add in a future version of the plugin?



Hi Jhopper,

We don't have plans to add any discount features in the plugins since there are already a lot of options out of the box in nopCommmerce.
The Sale of the Day plugin allows you to pick up certain products but it is up to the store owner if these products will have a discount, special price or old/new prices.
Actually you can select any products and change the title to be "Product of the Day" rather than "Sales of the Day". The store owner has a lot of flexibility in the way to use the plugin.

8 years ago

chrisADK wrote:
Hi,
Product Ribbons Version=3.6.799.17438
PR has been working fine up until yesterday. When I go tot he plugin it will juts infinitely sit there with the page loading spinning wheel. I can go to the setting page, product images page and help pages for the plugin no problem.
Only 20 or so ribbons created I think.
Have tried restarting the web site and deactivating the plugin.
Have not tried re-installing it since I'm not sure if loose all the ribbons already there or not.
The plug seems to still be functioning on the live site. It is juts on the admin side.

Have not added any ribbons in a couple weeks.
Have not updated any seven spikes plugins recently.

Any help to get this back working would be great.

Thanks Chris


Hi Chris,

Unless you provide us with access to your website to see what might be wrong we won't be able to help. Please submit a ticket providing access and we will take a look and advise

Have you added any other third party plugins to your store?