Commerce limitations for websites with large numbers of products
I've been using Drupal Commerce on Drupal 7 for a while now and have been steadily adding products to my website at https://everylabels.com.au. Some observations:
I love the system. The field system works well and has the power of infinite expansion so you can collect all sorts of information if you want to. So I'm happy with it and have put the time into learning it ... but:
Setting up products is a complex operation, and the instructions on the Drupal commerce website are inadequate. I could not work it out on my own. I had an instant messaging chat with a chap from a website in the US who was very helpful and got me on the right track. I don't remember his name, but a sincere thanks to him.
Once I understood how it worked I could develop from there OK. Better documentation is needed!
Commerce is not that well set up for website with large numbers of products. So far I have more than eleven thousand products listed, and I will at least double or more like triple that. Handling large numbers like that can be tricky.
Most of my products are set up using the Bulk Product Creation function. Without this it would have been impossible. One of my products has a choice of 12 colours with a further choice of matt and gloss finishes. Add to that a choice of four pack sizes, and you have a total of 96 products you need to generate. There are about 180 shapes that are available in the category. So that category alone has 17 280 products! (actually there's more, because I haven't mentioned 4 other colours available only in matt finish, which adds another 16 'products' to each product, making it 112 'products', giving a total of 20 160). This is one of 9 label categories. It doesn't even touch on the other categories! I don't expect to be finished adding label products for at least another 6 months.
As far as I can work out the 'Create Products and Create Display' button on the Bulk Products Creation screen only works if all the products you want on the display are the same price. It doesn't work for me with four pack sizes with different prices. So I have to generate a display using the Add Content button and a Content Display that I have set up. That's OK, but the only viable layout on that screen for large numbers is checkboxes ... which means that for each of the above mentioned products I have to click 112 times! I'd like to use a Select List but the window given to select them in is just four lines high. Not set up for large numbers. :( The autocomplete option is totally inadequate for the numbers I am working with.
There is no provision for bulk amendments once the products have been generated. If you make a mistake and don't pick it up for just one product you have to amend 96 products. It's painful ... I know! :(
There's no provision for bulk deletion of products. You have to do them one by one. That's painful too!
I don't know of any way to change options once you've set them up - see my post here: http://www.drupalcommerce.org/node/2829
It may well be that I am missing something that would make life a lot easier. If I am I'd love to know!
Please don't misunderstand me. Even though I see the need for some improvements doesn't mean I'm unhappy with Commerce. I reckon it's great, and will be even better when large numbers of products are better catered for.
Perhaps Randy or Ryan could comment on the above?