Messages

Hi Julie,

ok when we need the change I will contact you. I just thought the situation
having products with "automatic" prising is no good, and the system do keep track on the quantities in the right way. So I thought you was not aware of it and would consider correcting the bug for the next version 

Best regards
golfsailor

Hi Julie,

well the 'problem' is that we have a system with the quantities for every combination, to keep track of the store. Pricing is not on the same level. We could say some products will be priced by the system not by the shop owner .... Of course instead of two products with 4*4 options we will have 16 products....

So, you are right, if there is no change in the system we have to find the solution somewhere else. If the design have some flaws, your system could be better than osCommerce changing them 

(The most flexible solution would be to add the price data in the Quantity table, or to keep the osCommerce compatability, add a new one... )

Best regards

Hi again,
no problem getting the reports. The problem is a application problem which might depend on the db structure.
When entering product attributes / options there is 2 levels. Then when using this structure and
entering prices the application puts the prices not in a tree but in the flat structure. (The price is entered flat on the last level). However, the quantities is entered in the tree structure which makes the quantities take notice of the combination. For example : I have a lamp with E14 Socket and E27 Socket the price 1 and 2. Then the lamp could also have different color like red blue and so on. Each color have a different price adjustment like 1, 2 and 3. Now, the stock contains as it should the relevant quantity for each combination but the price will not be able to change for a certain combination. Let's say red should be cheaper with the E27 Socket.
Best regards

Actually upgrading Birt is easy, and the new version is working much better. (At least a lot
easier to make new reports).

I guess there is a problem with the product attribute / option structure. Now the prices goes into the system per option or attribute, but the numbers (quantities) in stock is per combination..... and the prices may vary with the combination of options. Now there is a way around, (new product instead of option), however not a nice way. The right way should be to enter prices for the combination, which in turn causes a minor change in the price calculation routine. Any idea ?

Best regards

are you considering upgrading Birt ?
I have some nice reports with birt version 2.3.1 wich I will be happy to submit.
Best regards