Home » Forums » Ubercart » Support
1 reply [Last post]
Tue, 05/03/2011 - 10:14
webmaker
webmaker's picture
Offline
Joined: 04/22/2009
Juice: 76
Was this information Helpful?

Hi,

this seems to be a strange issue: I created a custom views for my products which shows if stock is enabled for the product and the stock level. Just for some products the stock enabling shows "no" and the stock level is "0" although it is enabled and the stock level is for example 20. Stocking works as well: if I buy something the quantity is cut off from stock level - but still in my view I see "Stock enabled = No" und stock level "0".

To check this I added the field "article number" from stock module and found out that no article number was saved. Then I changed the article number from "ACC3330362S" to "ACC3330362S-1" - when I now visited the stock administration page of this product stocking was not enabled. So I clicked the checkbox and changed the stock level - now it was right in both administration page and view. Then I changed to the correct article number "ACC3330362S" - and on view still the incorrect article number "ACC3330362S-1" remained in the field for the aricle number from the stock module. Then I changed to "ACC3330362S-2" and now you can see that there are both incorrect article numbers in stock management - but not the correct one.

Please find attached screenshot which shows the view: first column is the article number from the product, last column the article number in stock management.

Best,
Tobias

PreviewAttachmentSize
Screenshot ViewScreenshot View233.02 KB
Screenshot stock administration page now. Listing the correct article number but this is not used in stock management as the view shows!Screenshot stock administration page now. Listing the correct article number but this is not used in stock management as the view shows!142.12 KB
Top
Tue, 05/03/2011 - 11:52
#1 View page
webmaker
webmaker's picture
Offline
Joined: 04/22/2009
Juice: 76
Re: In stock management article number is not updated - strange

Ok... found out the following: the admin created a product of a specific product group with the article number. Then he wanted to change the product group: he created a product of another product group and copied all the information into the fields including the article number. After saving the new product he deleted the old node.

Now I found in datbase that the correct article number was connected in stock table with a not existing node id. The two wrong article numbers were connected with the existing and correct node id of the current product.

My question: How can this happen???? Should the article number and node id not be deleted from stock table when a node is deleted??? Additionally should an article number not be used just once? How can it be that a product is created with the same article number as another one?

Best,
Tobias

Top