Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

4.3.1: Options And Combinations. Details Please Rate Topic   * * * * * 1 votes

 
  • imac
  • Head of Product
  • CS-Cart Architects
  • Join Date: 22-Nov 05
  • 2074 posts

Posted 29 March 2017 - 07:33 AM #41

Hi poppedweb,

 

Hello,

 

Just a few more questions:

1. Will the products have different URL's (seo purposes)?

2. Will it be possible to share features in feature variants. I for example want to define group item id's so that google will recognize it is an option variant. Will this be possible as this would save me a lot of time!

3. What will not be possible to edit with those variants? What limitations does it have? And how does the database structure change? (so that we can future proof our store).

4. What will the product id's be? For example, now I have created it as follows, you have one main product which is linked to other products by defining a costum option. The ID's for the products will be a mockup of the original ID. So if you have product A with ID 1, the ID of product A variant 2 would be 1_2. This made API calls for me a lot easier, how will this work in the next version?

5. What can we expect performance wise? So after I did this huge database purge I got my store like insanely fast, but this mainly was after deleting all the options regarding the google product categories. Cant this be stored in a seperate table so that the filtering won't be affected by this? Because my store has about 250 products and 100 of them have variants. This store is also in 6 languages. So in the feature table I allreayd have about 5000 entires of features (in all languages). But then the big hit comes in. The total amount of google product categories entries is over 23000. Which makes filtering a PAIN!!!

 

This will do for now ;)

1. No, this is not planned. I'm not sure it can be achieved easily. What's the point in variations if the will be displayed at separate URL. I understand SEO purpose - but still don't understand why would one use variations in this case. usual separate products will do the trick.

2. Changing Features in variation products is not planned. When we will adapt variations for Data Feed & Google Export probably will add this feature.

I suppose you are talking about GTIN here?

3. We are working on detailed description and demo - I think it will be easier to take a look in real life.

4. Each variation will have own regular product id. Example parent product has id 1, variation A has id 2, variation B has id 3 etc.

5. No test were mades regarding performance yet. Most probably variations won't be took into account in filtering. Can not say anything certain regarding this at the moment.


Ilya Makarov,
CS-Cart Architect Team
Suggest and vote for new features | Report a bug

 
  • poppedweb
  • Authorized Reseller
  • Members
  • Join Date: 02-Aug 16
  • 547 posts

Posted 29 March 2017 - 02:26 PM #42

Hi poppedweb,

 

1. No, this is not planned. I'm not sure it can be achieved easily. What's the point in variations if the will be displayed at separate URL. I understand SEO purpose - but still don't understand why would one use variations in this case. usual separate products will do the trick.

2. Changing Features in variation products is not planned. When we will adapt variations for Data Feed & Google Export probably will add this feature.

I suppose you are talking about GTIN here?

3. We are working on detailed description and demo - I think it will be easier to take a look in real life.

4. Each variation will have own regular product id. Example parent product has id 1, variation A has id 2, variation B has id 3 etc.

5. No test were mades regarding performance yet. Most probably variations won't be took into account in filtering. Can not say anything certain regarding this at the moment.

 

1. We do this so that there is a dedicated URL that is content specific. So google will index every product as a different one, and therefore this will work out better if you search for a certain product variant in google. Furthermore, we just need the variant selector (as we really need this to show that we have variant products!)

2. Great to hear, but for now we just need to specify the color in the properties for all variants, which is not that useful either.

3. Okay, please send some sort of link whenever this gets release (slack perhaps).

4. Okay, seems reasonable.

5. Will all the google categories be submitted in a seperate database as this does increase filtering performance by a TON.


PoppedWeb | sales@poppedweb.com | https://poppedweb.com
TurnKey Website Design | Add-Ons | Performance Audits | Dedicated Server Management
24/7 Support | Response within an hour (during working hours).

 
  • Triplets
  • Senior Member
  • Members
  • Join Date: 23-Sep 08
  • 1179 posts

Posted 30 March 2017 - 12:14 PM #43

I asked one of my clients who uses options heavily to write something up, see below. I hope it helps.

 

We have a few thoughts:
 
1.    Regarding the structure of the way products and options are set up: Comparing CS-cart’s current method of option combinations with the way they say that Amazon and others do this, the OTHER is definitely superior – to create separate ITEMS that are then grouped together for sales. It would be a definite plus for many reasons, especially for inventory… BUT we would want to make sure that there would still be a way that SINGLE products could use options that did not necessitate the creation of new products. For example, some of our products have so many options that if we had to create a separate product for each option combination, we’d be making thousands of separate products. We COULDN’T do it!…  and we would still need the ability to create option combinations that would display an image for each unique set of options.  There also would need to be a way, even on those separate products, to add options that would not have to define the product URL.
 
2.  It would be SO WONDERFUL if we could have a way to have an option add a fixed cost to the TOTAL instead of to the cost of each item. This is useful for anyone that sells a SERVICE connected with a product. For example, we sell announcements in multiples of 10. If a customer wants lined envelopes, that adds $0.25 to EACH announcement – that’s easy… it’s how the options currently function. But if we want to add a RUSH to the order, that’s a fixed cost of $10 and we want it to apply to this product as it adds to the cart, but they don’t want to pay $10 for EACH announcement. A checkbox that would let us define an option as a “single charge” would open up wonderful possibilities for us.
 
3. It would be SO WONDERFUL if when ordering a product we could group options together that are related.  For example on a computer order have a hardware option area, then a software option area, etc.  Some of our products have so many options the page gets quite long, we had a addon done to allow grouping of options in a popup window so the customer doesn't have to keep scrolling down. This would be a NICE feature to have built in.
 
4. It would be SO WONDERFUL if we had the ability to add more text, html, pictures, tables, etc with an option to help the customer. The current limited option description capability is not sufficient to describe some complex options to a customer.   
 
5. Limit the SQL query or memory requirements for options. On the current version of cs-cart, we hit a PHP or memory limit on options that have hundreds of variants. This should not be happening. Better coding should prevent this in the new version.
 
David


 
  • poppedweb
  • Authorized Reseller
  • Members
  • Join Date: 02-Aug 16
  • 547 posts

Posted 30 March 2017 - 03:25 PM #44

 

5. Limit the SQL query or memory requirements for options. On the current version of cs-cart, we hit a PHP or memory limit on options that have hundreds of variants. This should not be happening. Better coding should prevent this in the new version.

 

 

Well, they could make it way faster if they would somehow cluster the option descriptions. You could ask the creator of your product option modification to add an extra column that gives the groups of options a 'group_id' which would then be queried first (as this would reduce the time of the queries by a great amount if you indeed have 100's of them).

 

What also might be an idea is to store the product option variants in a seperate table, or just the normal products to reduce the categories loading time and total table size.


PoppedWeb | sales@poppedweb.com | https://poppedweb.com
TurnKey Website Design | Add-Ons | Performance Audits | Dedicated Server Management
24/7 Support | Response within an hour (during working hours).

 
  • imac
  • Head of Product
  • CS-Cart Architects
  • Join Date: 22-Nov 05
  • 2074 posts

Posted 31 March 2017 - 08:05 AM #45

 

I asked one of my clients who uses options heavily to write something up, see below. I hope it helps.

 

We have a few thoughts:
 
1.    Regarding the structure of the way products and options are set up: Comparing CS-cart’s current method of option combinations with the way they say that Amazon and others do this, the OTHER is definitely superior – to create separate ITEMS that are then grouped together for sales. It would be a definite plus for many reasons, especially for inventory… BUT we would want to make sure that there would still be a way that SINGLE products could use options that did not necessitate the creation of new products. For example, some of our products have so many options that if we had to create a separate product for each option combination, we’d be making thousands of separate products. We COULDN’T do it!…  and we would still need the ability to create option combinations that would display an image for each unique set of options.  There also would need to be a way, even on those separate products, to add options that would not have to define the product URL.
 
2.  It would be SO WONDERFUL if we could have a way to have an option add a fixed cost to the TOTAL instead of to the cost of each item. This is useful for anyone that sells a SERVICE connected with a product. For example, we sell announcements in multiples of 10. If a customer wants lined envelopes, that adds $0.25 to EACH announcement – that’s easy… it’s how the options currently function. But if we want to add a RUSH to the order, that’s a fixed cost of $10 and we want it to apply to this product as it adds to the cart, but they don’t want to pay $10 for EACH announcement. A checkbox that would let us define an option as a “single charge” would open up wonderful possibilities for us.
 
3. It would be SO WONDERFUL if when ordering a product we could group options together that are related.  For example on a computer order have a hardware option area, then a software option area, etc.  Some of our products have so many options the page gets quite long, we had a addon done to allow grouping of options in a popup window so the customer doesn't have to keep scrolling down. This would be a NICE feature to have built in.
 
4. It would be SO WONDERFUL if we had the ability to add more text, html, pictures, tables, etc with an option to help the customer. The current limited option description capability is not sufficient to describe some complex options to a customer.   
 
5. Limit the SQL query or memory requirements for options. On the current version of cs-cart, we hit a PHP or memory limit on options that have hundreds of variants. This should not be happening. Better coding should prevent this in the new version.
 
David

 

Hi David,

 

Thank you for detailed feedback, as I see most of them concerns current options and combinations implementation, not the new variation feature. I will try to go through your points.

 

1) Is this about that you would like to keep old combinations work same way as it work now?

I can say for sure that current options will work as before in new implementation. So you will be able to

a) select a single product with options, modifiers etc (same as you can now)

B) select a configurable product (the one that stores its option combinations in separate products)

 

2) I see. You need option modifiers independent of quantity. I don't thing we will add this. It's more like a custom feature.

 

3) It's rather unique case when you have a lot of options, and it's more about design/template to configure the look and feel, not about how it works.

 

4) We have comment and description fields for all options, and in case you want to show there more information - it's also about templates / styles

 

5) Sql and PHP should work fine even if there are a lot of options. If you have any exact bug reports or problems we will investigate this. Please write me about this.


Ilya Makarov,
CS-Cart Architect Team
Suggest and vote for new features | Report a bug

 
  • Triplets
  • Senior Member
  • Members
  • Join Date: 23-Sep 08
  • 1179 posts

Posted 31 March 2017 - 11:21 AM #46

 5) Sql and PHP should work fine even if there are a lot of options. If you have any exact bug reports or problems we will investigate this. 

 

This is a big headache for my clients that needs to be fixed in the next release. Some options have hundreds of variants. The Admin area won't let any more variants after say around 80 (yes, it is server configuration dependent).  But this is poor coding if this limit exists. We are forced to use PHPMyAdmin to add more variants. The Front-end works fine, just the admin is hitting a PHP variable limit.

 

David



 
  • imac
  • Head of Product
  • CS-Cart Architects
  • Join Date: 22-Nov 05
  • 2074 posts

Posted 05 April 2017 - 08:49 AM #47

 5) Sql and PHP should work fine even if there are a lot of options. If you have any exact bug reports or problems we will investigate this. 

 

This is a big headache for my clients that needs to be fixed in the next release. Some options have hundreds of variants. The Admin area won't let any more variants after say around 80 (yes, it is server configuration dependent).  But this is poor coding if this limit exists. We are forced to use PHPMyAdmin to add more variants. The Front-end works fine, just the admin is hitting a PHP variable limit.

 

David

We will take a look and try to optimize it if you can provide a sample DB or access to your store. 

Please create a ticket in help desk. 


Ilya Makarov,
CS-Cart Architect Team
Suggest and vote for new features | Report a bug

 
  • imac
  • Head of Product
  • CS-Cart Architects
  • Join Date: 22-Nov 05
  • 2074 posts

Posted 16 May 2017 - 08:29 AM #48

Hi everyone,

 

I would like to inform you about recent changes regarding option variations features:

1. Now you can see Variation products on the "Product Variations" tab of the main product. Here is the link: http://variations.de...&product_id=249

If you are on the child product page then there is a link to the parent product: 

variation-of.png

2. In the Products advanced search popup in the admin area, there is a section where you can select what type of products you'd like to search for. By default "Variation products" are not included in the search.

advanced-search.jpeg

3. Now you can change feature values in variation products. The main idea is to have separate GTIN for Google Export.

 

4. You can change Shipping properties of variation products.

 

5. You can change Quantity properties of variation products.

 

6. Rest API is extended to work with Variation products.

The "Get product list" method now accepts the product_type array with values: P (simple product), C (configurable product), V (variations). By default, only simple and configurable products are selected.

If you want to create a new product varaition, you should specify the following parameters:

 product_type = V - type of the product
 parent_product_id - id of the parent product

 variation_code - variation code in the following format: {parent_product_id}_{variant_id1}_{variant_id1}, e.g.: 12_14_17.  

 

As always you are welcome to test these changes on our demo: http://variations.demo.cs-cart.com/


Ilya Makarov,
CS-Cart Architect Team
Suggest and vote for new features | Report a bug

 
  • remoteone
  • Member
  • Members
  • Join Date: 06-Oct 09
  • 742 posts

Posted 16 May 2017 - 09:06 AM #49

Regarding eBay sync.

Im hoping that each Product Variation will upload to eBay as a separate eBay item, and conversly, when orders are sync/Downloaded from eBay, that each item will then show in CSC orders as the applicable Product Variant. Will this be the case?

Then there still remains the problem where a Option Variant is actually another product, making a Product Package.

The ebay order for such would need to show in CSC orders as having the separate products the same way it will if using the Product Packages addon.



 
  • amdowney
  • Senior Member
  • Members
  • Join Date: 22-Oct 14
  • 253 posts

Posted 16 May 2017 - 09:34 AM #50

looks good - so individual features such as gtin & mpn?

 

Does it also export to google stating the item group id etc?

 

When will the be released?


Stores: CCTV Kits & www.jmtb.co.uk

 
  • imac
  • Head of Product
  • CS-Cart Architects
  • Join Date: 22-Nov 05
  • 2074 posts

Posted 17 May 2017 - 06:51 AM #51

looks good - so individual features such as gtin & mpn?

 

Does it also export to google stating the item group id etc?

 

When will the be released?

Best way is to check on online demo http://variations.demo.cs-cart.com/.

Please do it, we really need your feedback.


Ilya Makarov,
CS-Cart Architect Team
Suggest and vote for new features | Report a bug

 
  • imac
  • Head of Product
  • CS-Cart Architects
  • Join Date: 22-Nov 05
  • 2074 posts

Posted 17 May 2017 - 06:56 AM #52

Regarding eBay sync.

Im hoping that each Product Variation will upload to eBay as a separate eBay item, and conversly, when orders are sync/Downloaded from eBay, that each item will then show in CSC orders as the applicable Product Variant. Will this be the case?

Then there still remains the problem where a Option Variant is actually another product, making a Product Package.

The ebay order for such would need to show in CSC orders as having the separate products the same way it will if using the Product Packages addon.

I'm not familiar with Product Packages addon.

We will check the work of Variations with Ebay, but I can not guarantee we will adapt it before release.


Ilya Makarov,
CS-Cart Architect Team
Suggest and vote for new features | Report a bug

 
  • sok777
  • Senior Member
  • Members
  • Join Date: 23-Jun 11
  • 394 posts

Posted 19 May 2017 - 11:05 AM #53

Hello Imac,

If I understand right it works as follows:

First you create Simple products (Child products) with its own description, images etc.

Afterwords you create Configurable product (Parent product) and assign child products to that configurable product. Although I did not find how to assign simple products to parent product (probably not yet ready on demo version).

Looks good, but few things:

Could you please show the new sructure of import CSV?

Will we finally have only 1 import CSV, which will include: old product combinatination, extra images, product discount tables, product features?

Could you please bring back product combination price = modifiers (Now called Simple Products prices probably) next to each variant as before (at least for Radio buttons) and add discounted price next to it. So the client do not have to change the combination to know the old and new price.

 

BTW Any idea when it will be released, next month or later?

Thanks



 
  • sok777
  • Senior Member
  • Members
  • Join Date: 23-Jun 11
  • 394 posts

Posted 19 May 2017 - 11:17 AM #54

Also would be nice to have Features in Separate Columns by default

 

http://forum.cs-cart...parate-columns/



 
  • imac
  • Head of Product
  • CS-Cart Architects
  • Join Date: 22-Nov 05
  • 2074 posts

Posted 22 May 2017 - 06:34 AM #55

Hello Imac,

If I understand right it works as follows:

First you create Simple products (Child products) with its own description, images etc.

Afterwords you create Configurable product (Parent product) and assign child products to that configurable product. Although I did not find how to assign simple products to parent product (probably not yet ready on demo version).

Not exactly. First you create configurable products, than create its variations based on options. See detailed description on how it works here: http://forum.cs-cart...n-combinations/
 

Looks good, but few things:

Could you please show the new sructure of import CSV?

Take a look at attachment, first line is configurable product, lines 3 to 8 are variations. Ass you can see some fields of variations are empty (like Category, Downloadable etc) - this is because variations inherit some of the properties of their parent (configurable) product.
options_csv.png
 

Will we finally have only 1 import CSV, which will include: old product combinatination, extra images, product discount tables, product features?

Yes you will.
 

Could you please bring back product combination price = modifiers (Now called Simple Products prices probably) next to each variant as before (at least for Radio buttons) and add discounted price next to it. So the client do not have to change the combination to know the old and new price.

No we can't.
If we are talking about variations which have two or more options you just can not find out modifiers price for each option. This is becaise we set absolute price for variation product, and it is not based on modifiers anymore.

 

BTW Any idea when it will be released, next month or later?
Thanks

We plan to release it in "Beta" stage in 4.6.1 in June probably.
Ilya Makarov,
CS-Cart Architect Team
Suggest and vote for new features | Report a bug

 
  • sok777
  • Senior Member
  • Members
  • Join Date: 23-Jun 11
  • 394 posts

Posted 22 May 2017 - 07:19 AM #56

 
No we can't.
If we are talking about variations which have two or more options you just can not find out modifiers price for each option. This is becaise we set absolute price for variation product, and it is not based on modifiers anymore.

 

 

I meant could you show Absolute and Discounted Price next to every product variation? For example if you have as follows

 

Combination product = 20 USD * price of selected variation

 

Size 1 - 20 USD (25 USD - old price) * default selected variation

Size 2 - 30 USD (35 USD - old price)

Size 3 - 40 USD (45 USD - old price)

 

It is better when customer can see all variations prices without changing them one by one.

 

 

Fot the rest the new architechture looks very good



 
  • imac
  • Head of Product
  • CS-Cart Architects
  • Join Date: 22-Nov 05
  • 2074 posts

Posted 24 May 2017 - 01:23 PM #57


I meant could you show Absolute and Discounted Price next to every product variation? For example if you have as follows
 
Combination product = 20 USD * price of selected variation
 
Size 1 - 20 USD (25 USD - old price) * default selected variation
Size 2 - 30 USD (35 USD - old price)
Size 3 - 40 USD (45 USD - old price)
 
It is better when customer can see all variations prices without changing them one by one.
 
 
Fot the rest the new architechture looks very good

This can work in case you have only one option, like size.
But if you have size and color you can not see all variation prices in this case.
Ilya Makarov,
CS-Cart Architect Team
Suggest and vote for new features | Report a bug

 
  • sok777
  • Senior Member
  • Members
  • Join Date: 23-Jun 11
  • 394 posts

Posted 24 May 2017 - 01:27 PM #58

Yes of course I understand.

 

So will it be available by default in case of one option?



 
  • imac
  • Head of Product
  • CS-Cart Architects
  • Join Date: 22-Nov 05
  • 2074 posts

Posted 05 June 2017 - 08:22 AM #59

Yes of course I understand.

 

So will it be available by default in case of one option?

Probably in next versions but not in 4.6.1 


Ilya Makarov,
CS-Cart Architect Team
Suggest and vote for new features | Report a bug

 
  • amdowney
  • Senior Member
  • Members
  • Join Date: 22-Oct 14
  • 253 posts

Posted 06 June 2017 - 09:16 AM #60

Imac - do you have plans when you go to Products > Options to have a search box to filter the options list as well as being able to copy options here? Would be so much easier and the functionality is already there for other screens.


Stores: CCTV Kits & www.jmtb.co.uk