New more user friendly product/variants logic. Let's discuss

a.m. wrote:

If a product has multiple size options AND offers a tier price discount (example: buy 5 or more and save money), I cannot get tier pricing to work if I split the tier amount (5 in this example) between different sizes. I can only get the tier price to work if I order (5) of one size - which is self defeating and confusing to the customer.

mattbrummett wrote:
If you mean product attributes, then this issue is already reported and it's not somehow related to this new product logic.

If you mean a "grouped" product with several associated "simple" products used as size options, then we use properties such as price, inventory, etc only for "simple" associated products. For "grouped" products these properties are ignored (similar to magento). There's a sub work item to hide these properties in UI when "grouped" product type is selected

a.m. wrote:

yes, it's when different attributes of the same product are ordered. i agree that a store owner should be able to choose if tier prices apply to single attributes or various.

do you have an idea of what version this will be implemented in? tier pricing was a popular option for my customers on my old shopping cart system and I can't implement tiers on nop commerce until it works for multiple attribute combinations. I'm just afraid I'm losing sales because they don't have this option right now, which is why I'm making it an important issue.

mattbrummett wrote:
Not yet

And here is the upgrade script for existing store owners - f47c2359b855. Please test.

P.S. There are a lot o other sub work items for this large refactoring

I got these error on updating from 2.65 to 3.10.

Errors are updating from 3.00 to 3.10

Msg 515, Level 16, State 2, Line 7
Can not insert NULL on column 'ParentProductId', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'ProductTypeId', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'IsGiftCard', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'GiftCardTypeId', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'RequireOtherProducts', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'AutomaticallyAddRequiredProducts', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'IsDownload', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'DownloadId', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'UnlimitedDownloads', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'MaxNumberOfDownloads', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'DownloadActivationTypeId', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'HasSampleDownload', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'SampleDownloadId', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'HasUserAgreement', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'IsRecurring', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'RecurringCycleLength', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'RecurringCyclePeriodId', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'RecurringTotalCycles', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'IsShipEnabled', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'IsFreeShipping', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'AdditionalShippingCharge', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'IsTaxExempt', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'TaxCategoryId', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'ManageInventoryMethodId', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'StockQuantity', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'DisplayStockAvailability', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'DisplayStockQuantity', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'MinStockQuantity', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'LowStockActivityId', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'NotifyAdminForQuantityBelow', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'BackorderModeId', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'AllowBackInStockSubscriptions', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'OrderMinimumQuantity', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'OrderMaximumQuantity', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'DisableBuyButton', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'DisableWishlistButton', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'AvailableForPreOrder', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'CallForPrice', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'Price', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'OldPrice', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'ProductCost', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'CustomerEntersPrice', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'MinimumCustomerEnteredPrice', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'MaximumCustomerEnteredPrice', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'HasTierPrices', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'HasDiscountsApplied', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'Weight', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'Length', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'Width', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

Msg 515, Level 16, State 2, Line 2
Can not insert NULL on column 'Height', table 'Test310.dbo.Product'. Column does not allow null values. Update Error.

More:

- "Product Variants" images are missing after updating.
- "Product Variants" short description is deleted after updating.

a.m. wrote:

When you say that there are lot o other sub work items, these works items will be on 3.10 release, right (like hidding "product variants" from search engine)?

PS: This new product structure is great for use with bundle products. Will be this feature on 3.10 release too?

Thanks!

sabueXo wrote:
Please share your 3.00 database backup (before running the 3.00 => 3.10 upgrade script) so I can test it
P.S. Please also ensure that it works fine with 3.00 RTM solution

sabueXo wrote:
on the roadmap

sabueXo wrote:
already done in the latest version

sabueXo wrote:
right. everything will be done in 3.10

sabueXo wrote:
Most probably. See the current roadmap for 3.10 here

a.m. wrote:
Thanks for sharing. After playing with your database backup I found that you had products without variants. It caused the error. Fixed. Get the latest version from codeplex and try one more time