View Issue Details

IDProjectCategoryView StatusLast Update
0004844OXID eShop (all versions)1.01. Products (product, categories, manufacturer, promotions etc.)public2024-07-05 20:13
ReporterLinas Kukulskis Assigned To 
PriorityhighSeveritymajorReproducibilityalways
Status confirmedResolutionopen 
Product Version4.7.2 / 5.0.2 revision 53018 
Summary0004844: Missing article in list when used blUseTimeCheck
DescriptionWith the blUseTimeCheck option you can turn on the feature to specify a time frame (from/to) in which a product is active. When this option is on, shop act wrong in this situations:

1. Shop does not recalculate article count in /manufacturer/vendor list when product becomes active
2. Price from is calculated wrongly
3. Product with time-limited variants stays inactive


Possible solutions:
Use cron jobs to recalculate products with from/till dates related data.
Steps To ReproduceCase 1
======

Steps to reproduce:
- Imagine it is Monday
- Create a category Foo with four active products in it (article count = 4)
- Create product A in category Foo
- Configure product A to become active from Tuesday to Thursday
- Activate the configuration option "Show article count near category|manufacturer|..."
- Wait until Tuesday and open listing view for category Foo

What happens:
- The product A appears in the category Foo's listing view
- The article count is still 4, because it is cached

What is expected:
- The product A appears in the category Foo's listing view
- The article count is 5, because product A became Active

Additional Information:
On Friday, product A becomes inactive again. Then, it should not show up in Foo's listing view anymore and article count should be 4 again.


Case 2
======

Steps to reproduce:
- Imagine it is Monday
- Create product A with variant Foo and Bar
- Configure variant Foo to become active from Tuesday to Thursday, whereas Bar is always active
- Set price for variant Foo to 0.99 EUR and for variant Bar to 2.99 EUR (s. th. Foo is cheaper than Bar)
- Wait until Tuesday

What happens:
- Foo becomes active and has the lowest price (0.99 EUR)
- "Price from" for product A still reads "2.99 EUR" (price of variant Bar)

What is expected:
- Foo becomes active and has the lowest price (0.99 EUR)
- "Price from" for product A reads "0.99 EUR" (price of variant Foo instead of variant Bar)

Additional Information:
Sorting is also broken in this case. Note that on Friday, when variant Foo becomes inactive again, the "Price from" should be 2.99 EUR again.


Case 3
======

Steps to reproduce:
- Image it is Monday
- Create a product with one variant
- Make sure the variant has a stock of 20 items
- 10 items of this variant are on sale
- 10 items of this variant will be activated from Thursday to Sunday
- Buy 10 items of the variant on Tuesday (product sold out, becomes inactive)
- Wait until Thursday

What happens:
- The product is not activated again, even though the second half of the stock (10 items) is active since Thursday

What is expected:
- The product becomes active again, as soon as the variant items become active on Thursday

Additional information:
If the product has more than one variant, then the variant which is time-boxed does not become active at the beginning of the time-box (depends on stock flag).
Additional InformationIf we use cron and remove subselect it can increase performance
TagsCache, Category, Products, Stock
ThemeAll
BrowserAll
PHP VersionNot defined
Database VersionNot defined

Activities

There are no notes attached to this issue.