load of pages

  • Posts: 92
  • Thank you received: 0
11 years 9 months ago #94700

Hi
i am the bothersome again. :S
This is just for a question: the pages of my shop load really slow (over all, products with many caracteristics). My company of hosting says to me that I can be leaving opened connections to the database or processes php in execution without need. How I can know if it is the problem or only it is a problem of lack of memory in my hosting?
Always, thanks for your time and work

Please Log in or Create an account to join the conversation.

  • Posts: 83041
  • Thank you received: 13405
  • MODERATOR
11 years 9 months ago #94718

Hi,

If you have lot of variants it's probable that it will slow down the page processing as it would require a lot of processing.
The solution would be to reduce the number of variants per product and/or use a more powerful hosting plan.

The following user(s) said Thank You: pymgym

Please Log in or Create an account to join the conversation.

  • Posts: 92
  • Thank you received: 0
11 years 9 months ago #94755

thanks for information.
I have some products with a lot of variants. For example, a trouser has thirteen different colors and each color fourteen different sizes.
how much ram do you think I need?
with my current company of hosting I have 60 MB and higher plan just offers 80MB. Do you think that can be enough or I'd have to change of hosting plan??
Thanks in advance

Please Log in or Create an account to join the conversation.

  • Posts: 83041
  • Thank you received: 13405
  • MODERATOR
11 years 9 months ago #94925

13*14, that's 182 variants for one product. That's indeed a lot.
The problem doesn't come from the ram but the processing speed and then the amount of data to transfer to the browser.

Would you have a link to such product page so that we can see if there is any way you can improve the speed with maybe some modifications in the display of the data ?

Please Log in or Create an account to join the conversation.

  • Posts: 92
  • Thank you received: 0
11 years 9 months ago #94952

Hi,
I send you the links of two products with a lot of variants.
Precisely, the trouser is the most sold product, so I'd like to display it with all sizes and colours.

pantalon-modelo-multibolsillos
parka-modelo-boreal

thanks for your work and advice

Please Log in or Create an account to join the conversation.

  • Posts: 83041
  • Thank you received: 13405
  • MODERATOR
11 years 9 months ago #95074

Hi,

I see that you have the same information for all the variants of the product.
So I would recommend to use custom item fields instead of characteristics since you don't need variants as far as I can see.
That should greatly help reduce the page load.

Please Log in or Create an account to join the conversation.

  • Posts: 92
  • Thank you received: 0
11 years 9 months ago #95087

I don't understand too well your recommendation.
how can I put these custom item fields in products? :blush:

Please Log in or Create an account to join the conversation.

  • Posts: 83041
  • Thank you received: 13405
  • MODERATOR
11 years 9 months ago #95096

Create a custom item field, assign it to an unpublished category that you created for it, and then add that category in your product and the custom item field will appear on the product page.

The following user(s) said Thank You: pymgym

Please Log in or Create an account to join the conversation.

  • Posts: 92
  • Thank you received: 0
11 years 9 months ago #95112

I'll try it and I'll tell you.
thanks, thanks, thanks, thanks, thanks, thanks.

Please Log in or Create an account to join the conversation.

  • Posts: 92
  • Thank you received: 0
11 years 9 months ago #95133

I did what you said: I created a custom item field, assigned it to an unpublished category that I created for it, and then I added that category in my product but the custom item field appear on the product page just with first option.
I created custom item field in product table as a single dropdown with 10 values.
I looked in your demo shop and I tried and other thing: I created two products named colours and sizes, added to options category, and after I added this products as an option in my product. It means that I have to change everytime these colours and sizes in each product, but it seems to load quickly, even with more than 200 options.
could you tell me if this option can be correct?
thanks in advance

Please Log in or Create an account to join the conversation.

  • Posts: 92
  • Thank you received: 0
11 years 9 months ago #95138

I think I have a big, big problem: I tried again your method but in item table and options display in each product. The problem is that neither your method nor mine, I can choose the options for each product, and each product has different colours and sizes!!
Please HEEEELP!!

Please Log in or Create an account to join the conversation.

  • Posts: 83041
  • Thank you received: 13405
  • MODERATOR
11 years 9 months ago #95140

Yes, you would need to have one custom item field per characteristic per product in your case. It's indeed less practical than characteristics, but you won't get slow page loads.

The following user(s) said Thank You: pymgym

Please Log in or Create an account to join the conversation.

  • Posts: 92
  • Thank you received: 0
11 years 9 months ago #95360

thaks for your help.
It means two months of work thrown to the trash :(
Well, I'll change my face :laugh: and continue working.
thanks again

Please Log in or Create an account to join the conversation.

  • Posts: 92
  • Thank you received: 0
11 years 9 months ago #96356

Hi,
I have been working on this, but the only valid alternative is to create a field personalized by every article and to add every field to a category without publishing.
But I cannot duplicate the personalized fields and go adapting them to every product. I have to create every field with all the options of every product every time and it can take me many months.
There is no option to accelerate the load of the pages with many characteristics?
Some another option?
I take the opportunity to ask you two questions:

  1. in product list the order of display is: image-price-product name. I want to change it to: product name-image-price. Wich view and what can I to change?
  2. in checkout, the final shipping price display with taxes and after taxes display total taxes (including those of shipping price). How can I display price of shipping without taxes
I hope you can help me!!!!!
THANKS!!!!

Please Log in or Create an account to join the conversation.

  • Posts: 83041
  • Thank you received: 13405
  • MODERATOR
11 years 9 months ago #96563

Hi,

If you want to accelerate the load of pages with characteristics there are not many options available...
1. use a mix of characteristics and custom fields. So if you have some dropdowns which have the same values for a lot of products, you can use a custom item field for that dropdown and keep using characteristics for the rest. It could greatly help.
2. increase the perfs of your hosting. However, the page size might still be a lot.

You can edit the file "listing_img_title" of the view "product" via the menu Display->Views. You simply need to switch the different blocks of code around.

In the file "cart" of the view "checkout", change the code $this->shipping->shipping_price_with_tax to $this->shipping->shipping_price and that should work.

The following user(s) said Thank You: pymgym

Please Log in or Create an account to join the conversation.

  • Posts: 92
  • Thank you received: 0
11 years 9 months ago #96564

I thought to use a characteristic for colors and a custom field for sizes, but every product has his own colors and his own sizes: there are trousers that have from 34 to 60, others from 38 to 56, from XS to XXL... no one coincides, and with colors the same thing. And almost all my catalogue is like that.
I waited for a better news (I was praying for it) but I think just a hard and long, long work wait for me :(
With regard to other questions, I suppose i won't have any problem.
Thank you anyhow for your time, but if you have a great idea about this, I'll waiting for it :)

Please Log in or Create an account to join the conversation.

Time to create page: 0.083 seconds
Powered by Kunena Forum