Need Help Testing Variant Behavior in 7.0.6

[JaminLeather]

I am trying to track down a problem and needed help with a quick test. Could anyone that is on a clean install of 7.0.6 please perform the following test for me? It should only take a few minutes.

1. Create a new item. Give it a name and a sku and hit Save.
2. Click Options and Variants. Enter "Size" beside Option and "S, M, L" beside Choices and hit Add.
3. Click the Edit Option Icon (Not the Manage Variants button).
4. Enter S, M, and L for the Sku boxes 1, 2 and 3. Leave everything else blank and hit Save and Close.
5. Click Product Details, then under Inventory Tracking, choose "Track Variants" and hit Save.
6. Click Options and Variants, then the Manage Variants button.
7. WITHOUT modifying anything else on this page, enter "1" for the In Stock box on Size S only. Leave M and L at 0 then hit Save.
8. Take note of the ProductId for this item in the address bar of your browser.
9. Open SQL Server Management Studio and query the "ac_ProductVariants" table (xxxx = the ProductId for the item)

Code: Select all

SELECT * FROM dbo.ac_ProductVariants WHERE ProductId = xxxx

How many records were returned? One or three?

In my installation of 7.0.5 only one record is returned. This is causing a problem in an interface from Stone Edge Software. Their interface expects three records in this table for it to work correctly, and they told me it should be fixed in 7.0.6. Before I do an upgrade I wanted to make sure this was indeed true.

Thank you very much for your help!

[plugables]

How many records were returned? One or three?

In my installation of 7.0.5 only one record is returned. This is causing a problem in an interface from Stone Edge Software. Their interface expects three records in this table for it to work correctly, and they told me it should be fixed in 7.0.6. Before I do an upgrade I wanted to make sure this was indeed true.

As I understand this is the way AbleCommerce works. ac_ProductVariants table is not used to store all the variants but it is used to store only the variants that have a non-default values for some field. Other (default) variants are created on the fly. I don't think AbleCommerce is going to change the way it works just because Stone Edge software is expecting data in a certain way. When Stone Edge integrates with AbleCommerce it is up to Stone Edge to figure out the variants the same way AbleCommerce figures them out in their own code. As far as I know variants are stored this way for the purpose of efficiency.

[JaminLeather]

As I understand this is the way AbleCommerce works. ac_ProductVariants table is not used to store all the variants but it is used to store only the variants that have a non-default values for some field. Other (default) variants are created on the fly. I don't think AbleCommerce is going to change the way it works just because Stone Edge software is expecting data in a certain way. When Stone Edge integrates with AbleCommerce it is up to Stone Edge to figure out the variants the same way AbleCommerce figures them out in their own code. As far as I know variants are stored this way for the purpose of efficiency.

I strongly suspect this is how AbleCommerce is designed to work and I have explained as much to Stone Edge's Lead Developer repeatedly. Unfortunately, he is convinced he already knows how AbleCommerce is supposed to work and refuses to listen. He says this table functions differently in version 7.0.6 and I believe he is wrong, however I was hoping to get confirmation from somebody without having to install the latest version myself.

What is EXTREMELY FRUSTRATING is I wrote a few line code snippet that would allow Stone Edge to get exactly the information they need, but they so convinced that they can't possible be wrong, that they refuse to even look at it.

ac_ProductVariants table is not used to store all the variants but it is used to store only the variants that have a non-default values for some field.

All I need is for somebody from AbleCommerce to verify the above statement. If Stone Edge still refuses to fix their bug after this, I will at least have justification to get my money back.

[plugables]

Someone from Able please confirm how ac_ProductVariants are stored. My understanding is that only the ones that have non-default values are stored. The default ones are built on the fly.

Also may be someone who has 7.0.6 installed verify the above mentioned scenario. I suspect that the above mentioned scenario indicates that at least three variants have non-default values.... because 3 sku modifier have been set.

[jmestep]

From what I have seen with variants, plugables is correct.