I'm having performance issues with Merchello (to the point where I can't use Umbraco without deleting my Merchello Index) and just wondered if anyone had any solutions to this/if this is normal etc..?
I have 11 products in my store, each with 5 variants, and upto 5 options except one, that has 15 options. After saving out this one product, my site (front + back end) became unresponsive until I deleted the Merchello index -> deleted the product -> and re-indexed my merchello products.
According to my index it had 3000 (!!) products based on these variants for just ONE product, is this typical behaviour? In total there'd be something like 30000 products, can anyone offer any advice at all as I really want to use Merchello!
I'm using v1.11.0 (it's an old project) with Umbraco 7.2.6.
@proto - Wow, 15 options. How many choices per option? A variant is created for every single combination so depending on how many choices you could wind up with quite a few variants.
Would you mind posting a screen shot of your product options pages. I'd like to run some tests to see if I can replicate your issue.
Thanks for the reply. Haha yeah, unfortunately that's the number of options the client has asked for! Here's a similar option setup that I used:
Luckily some of my variants don't alter the price so I've used extended data for some options. But with this method, I have an issue where if a user orders two of the same product with different extended data, Merchello groups them and I can only retrieve extended data of one of them. Is there a solution to this?
I'm not sure if it's a version thing but if I try to add an product/variant to my basket that has zero stock, I get a YSOD - is there a way to update the stock fields on all the products+variants at once (I won't be using stock levels)?
@pronto - when you add the item to the basket, make sure the SKU for each line item is unique. The collection is managed via the SKU property so unique SKUs will be saved as different line items.
In your store settings, uncheck the track inventory on all variants. There is not a bulk action at the moment to update all previously saved products so you will need to do a direct SQL update against the merchProductVariant table - setting the tracksInventory property to 0. Then rebuild your product index since the indexing events will not be triggered.
Essentially I'm trying to 'fake' unique sku's on the fly as each product has a personalized message option - so in the basket I don't want the products to be grouped by the merchello sku as I can't show display the unique extended data for each product, if that makes sense?
Merchello performance issues with lots of variants + options
Hi everyone,
I'm having performance issues with Merchello (to the point where I can't use Umbraco without deleting my Merchello Index) and just wondered if anyone had any solutions to this/if this is normal etc..?
I have 11 products in my store, each with 5 variants, and upto 5 options except one, that has 15 options. After saving out this one product, my site (front + back end) became unresponsive until I deleted the Merchello index -> deleted the product -> and re-indexed my merchello products.
According to my index it had 3000 (!!) products based on these variants for just ONE product, is this typical behaviour? In total there'd be something like 30000 products, can anyone offer any advice at all as I really want to use Merchello!
I'm using v1.11.0 (it's an old project) with Umbraco 7.2.6.
Kind regards,
@proto - Wow, 15 options. How many choices per option? A variant is created for every single combination so depending on how many choices you could wind up with quite a few variants.
Would you mind posting a screen shot of your product options pages. I'd like to run some tests to see if I can replicate your issue.
Hi Rusty,
Thanks for the reply. Haha yeah, unfortunately that's the number of options the client has asked for! Here's a similar option setup that I used:
Luckily some of my variants don't alter the price so I've used extended data for some options. But with this method, I have an issue where if a user orders two of the same product with different extended data, Merchello groups them and I can only retrieve extended data of one of them. Is there a solution to this?
I'm not sure if it's a version thing but if I try to add an product/variant to my basket that has zero stock, I get a YSOD - is there a way to update the stock fields on all the products+variants at once (I won't be using stock levels)?
Kind Regards,
@pronto - when you add the item to the basket, make sure the SKU for each line item is unique. The collection is managed via the SKU property so unique SKUs will be saved as different line items.
In your store settings, uncheck the track inventory on all variants. There is not a bulk action at the moment to update all previously saved products so you will need to do a direct SQL update against the merchProductVariant table - setting the tracksInventory property to 0. Then rebuild your product index since the indexing events will not be triggered.
Cool, thanks for the help Rusty.
Is there a way I can set different extended data for multiple quantities of the same sku in my basket?
Kind Regards
@pronto - Probably with an invoice builder tasks and a custom basket view of sorts. How do you want it to work?
Essentially I'm trying to 'fake' unique sku's on the fly as each product has a personalized message option - so in the basket I don't want the products to be grouped by the merchello sku as I can't show display the unique extended data for each product, if that makes sense?
is working on a reply...